| import json | |
| import logging | |
| import os | |
| logger = logging.getLogger(__name__) | |
| def _load() -> frozenset: | |
| sa_json = os.environ.get("GOOGLE_SERVICE_ACCOUNT_JSON", "") | |
| sheet_id = os.environ.get("GOOGLE_SHEET_ID", "") | |
| if not sa_json or not sheet_id: | |
| logger.warning("inventory: env vars missing — inventory disabled") | |
| return frozenset() | |
| try: | |
| import gspread | |
| gc = gspread.service_account_from_dict(json.loads(sa_json)) | |
| ws = gc.open_by_key(sheet_id).sheet1 | |
| rows = ws.get_all_values() | |
| codes = {row[0].strip().upper().replace("-", "") for row in rows[1:] if row and row[0].strip()} | |
| logger.info("inventory: loaded %d codes", len(codes)) | |
| return frozenset(codes) | |
| except Exception as exc: | |
| logger.warning("inventory: failed to load (%s) — inventory disabled", exc) | |
| return frozenset() | |
| OWNED: frozenset = _load() | |