3fidZddlmZddlmZmZddlmZddlm Z erddl m Z n ddl m Z GddeZ y #e $rYwxYw) z#Base class for Google Sheets tools.) annotations) TYPE_CHECKINGOptional)BaseTool)Field)ResourceceZdZUdZeddZded<eddZded <dd Zdd Z e dd Z e dd Z ddZ ddZy)SheetsBaseToolaBase class for Google Sheets tools. Authentication: - `api_resource`: OAuth2 credentials for full access (read/write private sheets) - `api_key`: API key for read-only access (public sheets only) !!! note Write operations require OAuth2 credentials. Nz>Google Sheets API resource, OAuth2 credentials for full access)default descriptionzOptional[Resource] api_resourcez:Google API key for read-only access to public spreadsheetsz Optional[str]api_keyc|jr |jS|jrddlm}||jSddlm}|S)zGet the appropriate Google Sheets service based on available credentials. Returns: Resource: Google Sheets API service Raises: ValueError: If neither `api_resource` nor `api_key` is provided r)!build_sheets_service_with_api_key)build_sheets_service)r r'langchain_google_community.sheets.utilsrr)selfrrs d/var/www/auto_recruiter/arenv/lib/python3.12/site-packages/langchain_google_community/sheets/base.py _get_servicezSheetsBaseTool._get_service+sJ   $$ $ \\ 5   U') )cL|jr|js tdyy)zCheck if the current authentication method supports write operations. Raises: ValueError: If using API key for write operations zWrite operations require OAuth2 credentials, not API key. Please provide api_resource for write access to private spreadsheets.N)rr ValueError)rs r_check_write_permissionsz'SheetsBaseTool._check_write_permissionsDs- << 1 1X !2rEsD)"*)2 6 BXB    s9AA