#!/usr/bin/env python3
"""arq-airtable — airtable API bridge.
v0: list bases
"""
import argparse, json, os, sys, urllib.request, urllib.error
from pathlib import Path
sys.path.insert(0, str(Path(__file__).parent))
from _arq_provider_base import sops_extract, call_with_audit, print_json, handle_meta_flags

PROVIDER = "airtable"
REQUIRED_SCOPES: dict[str, list[str]] = {
    # Airtable PAT scope for /v0/meta/bases.
    "list": ["schema.bases:read"],
}
def _key(): return os.environ.get("AIRTABLE_API_KEY") or sops_extract('["arqera_twin_admin"]["airtable"]["value"]') or sops_extract('["airtable"]["airtable_api_key"]')
def _get(path):
    k = _key()
    if not k: return 401, "no airtable key"
    req = urllib.request.Request(f"https://api.airtable.com/v0/meta{path}", headers={"Authorization": f"Bearer {k}"})
    try:
        with urllib.request.urlopen(req, timeout=30) as r: return r.status, json.loads(r.read())
    except urllib.error.HTTPError as e: return e.code, e.read().decode("utf-8","ignore")
    except Exception as e: return 500, str(e)

def _list(a):
    c, d = _get("/bases")
    if c != 200: sys.stderr.write(f"HTTP {c}: {d}\n"); return 1
    return print_json(d)

def main():
    handle_meta_flags(PROVIDER, REQUIRED_SCOPES)
    p = argparse.ArgumentParser(prog="arq-airtable"); s = p.add_subparsers(dest="cmd", required=True)
    sl = s.add_parser("list"); sl.set_defaults(func=_list, verb="list")
    args = p.parse_args()
    return call_with_audit(PROVIDER, args.verb, args.func, args)

if __name__ == "__main__": sys.exit(main())
