3fitndZddlmZddlZddlmZmZmZddlm Z m Z er ddl m Z ddl mZ d ddZdd Zdd Zej$d Zej$d Zej$d Zej$dZej$dZddZddZddZy)zGoogle Sheets tool utils.) annotationsN) TYPE_CHECKINGListOptionalget_google_credentials'import_googleapiclient_resource_builder) Credentials)Resourcecfddg}|xs|}|xst||||}t}||||S)aBuild a Google Sheets service with OAuth2 credentials (full access). Args: credentials: OAuth2 credentials. If None, will attempt to load from default locations. service_name: The Google API service name. service_version: The Google API service version. use_domain_wide: Whether to use domain-wide delegation. delegated_user: User to impersonate for domain-wide delegation. service_account_file: Path to service account file for domain-wide delegation. scopes: List of OAuth2 scopes. Defaults to full access scopes. Returns: Resource: Google Sheets API service with full access capabilities. z,https://www.googleapis.com/auth/spreadsheetsz.https://www.googleapis.com/auth/drive.readonly)scopesuse_domain_widedelegated_userservice_account_file) credentialsr) r service_nameservice_versionrrrr default_scopesbuilders e/var/www/auto_recruiter/arenv/lib/python3.12/site-packages/langchain_google_community/sheets/utils.pybuild_sheets_servicersT8 78N  %~F!7'%1 "K 67G <k JJc,t}|dd|S)aBuild a Google Sheets service with API key (read-only access). Args: api_key: Google API key for authentication. Returns: Resource: Google Sheets API service with read-only access to public spreadsheets. !!! note API key authentication only works with public spreadsheets. For private spreadsheets, use OAuth2 credentials instead. sheetsv4) developerKey)r )api_keyrs r!build_sheets_service_with_api_keyr>s 67G 8T 88rc|s tdd|vr;|jddz}|jd|}|dk(r t|}|||}t|dkrtd||S) zValidate and normalize a Google Spreadsheet ID. Args: spreadsheet_id: The spreadsheet ID to validate. Returns: The validated spreadsheet ID. Raises: ValueError: If the spreadsheet ID is invalid. zSpreadsheet ID cannot be emptyzdocs.google.com/spreadsheets/d/z/d//zInvalid spreadsheet ID format: ) ValueErrorfindlen)spreadsheet_idstartends rvalidate_spreadsheet_idr*Rs 9::)N:##E*Q.!!#u- "9n%C'c2 >R:>:JKLL rz^[A-Za-z]+[1-9]\d*$z%^[A-Za-z]+[1-9]\d*:[A-Za-z]+[1-9]\d*$z^[A-Za-z]+:[A-Za-z]+$z^[1-9]\d*:[1-9]\d*$z^[A-Za-z_][A-Za-z0-9_]*$ctj|rytj|rytj|rytj|ryt j|r|ddk(rt d|Dryyy)zValidate a range target (after sheet qualifier removed). Args: target: Range string without sheet qualifier. Returns: True if valid, False otherwise. Tr"0c3<K|]}|jyw)N)isalpha).0cs r z#_validate_target..s$AQQYY[$AsF)_AREA fullmatch_CELL_COLS_ROWS_NAMEDany)targets r_validate_targetr:sr v v v v ": $A&$A!A rc|r|jsy|jdry|jd\}}}|r|sy|}t|S|}t|S)aValidate A1 notation range format. Supports: - Single cells: `'A1'`, `'Z99'` - Areas: `'A1:B2'` - Whole columns: `'A:A'`, `'B:D'` - Whole rows: `'1:1'`, `'5:10'` - Sheet-qualified: `'Sheet1!A1'`, `"'My Sheet'!A1:B2"` - Named ranges: `'MyData'`, `'Sales_2024'` Args: range_name: Range string to validate. Returns: `True` if valid format, `False` otherwise. Examples: >>> validate_a1_range("A1") True >>> validate_a1_range("A1:B2") True >>> validate_a1_range("Sheet1!A1") True >>> validate_a1_range("A:A") True >>> validate_a1_range("") False F!)strip startswith partitionr:) range_namesheethad_bangafterr9s rvalidate_a1_rangerDsj: Z--/S!'11#6E8U F ## F ##rc:t|std|d|S)aWValidate and normalize a range name. Permissive A1 validator. Supports: - Single cells: `'A1'`, `'Z99'` - Areas: `'A1:B2'` - Whole columns: `'A:A'`, `'B:D'` - Whole rows: `'1:1'`, `'5:10'` - Sheet-qualified: `'Sheet1!A1'`, `"'My Sheet'!A1:B2"` - Named ranges: `'MyData'`, `'Sales_2024'` Args: range_name: The range name to validate (e.g., `'A1:Z100'`, `'Sheet1!A1:B2'`). Returns: The validated range name. Raises: ValueError: If the range name is invalid. Examples: >>> validate_range_name("A1") 'A1' >>> validate_range_name("Sheet1!A1:B2") 'Sheet1!A1:B2' >>> validate_range_name("A:A") 'A:A' >>> validate_range_name("") Traceback (most recent call last): ... ValueError: Invalid range format: ... zInvalid range format: zb. Expected A1 notation like 'A1', 'A1:B2', 'Sheet1!A1', 'A:A', or '1:1'. Named ranges are allowed.)rDr$)r@s rvalidate_range_namerFs3@ Z ($ZL1( (  r)NrrFNNN)rzOptional[Credentials]rstrrrGrboolr Optional[str]rrIr zOptional[List[str]]returnr )rrGrJr )r'rGrJrG)r9rGrJrH)r@rGrJrH)r@rGrJrG)__doc__ __future__rretypingrrr!langchain_google_community._utilsrr google.oauth2.credentialsr googleapiclient.discoveryr rrr*compiler4r2r5r6r7r:rDrFrrrTs" 00 52*. !$(*."&)K&)K)K)K )K " )K ( )K )K)KX9(H  )* ;< +, )* / 08*$Z'r