# Python 3, biblioteca padrão; execute apenas no servidor.
import json, os, urllib.request, urllib.error
payload = {"action": "usuarios-list", "limit": 100, "offset": 0}
request = urllib.request.Request(
    "https://fizgujocdsnnvmwbrvgq.supabase.co/functions/v1/api?route=integracao",
    data=json.dumps(payload).encode("utf-8"),
    headers={"Authorization": "Bearer " + os.environ["PSICOGES_API_KEY"],
             "Content-Type": "application/json"}, method="POST")
try:
    with urllib.request.urlopen(request, timeout=30) as response:
        data = json.load(response)
        print(data["usuarios"])
except urllib.error.HTTPError as error:
    message = json.loads(error.read().decode("utf-8"))
    raise RuntimeError(f"HTTP {error.code}: {message.get('error', 'Falha')}") from error