openai/gpt-5.6-luna · d1_auth_email · rep 3

set -e
for v in SUPABASE_URL SUPABASE_PROJECT_REF SUPABASE_ANON_KEY SUPABASE_SERVICE_ROLE_KEY SUPABASE_DB_URL SUPABASE_DB_PASSWORD; do if [ -n "${!v:-}" ]; then echo "$v=set"; else echo "$v=missing"; fi; done
printf 'URL host: '; python3 - <<'PY'
import os, urllib.parse
u=os.environ.get('SUPABASE_URL','')
print(urllib.parse.urlparse(u).netloc)
PY

SUPABASE_URL=set
SUPABASE_PROJECT_REF=set
SUPABASE_ANON_KEY=set
SUPABASE_SERVICE_ROLE_KEY=set
SUPABASE_DB_URL=set
SUPABASE_DB_PASSWORD=set
URL host: <ref>.supabase.co

set -euo pipefail
base="$SUPABASE_URL"
admin="$base/auth/v1/admin/users"
for pair in 'dana@cari.dev|Passw0rd-dana-91' 'omar@cari.dev|Passw0rd-omar-17'; do
  email=${pair%%|*}; password=${pair#*|}
  body=$(python3 - "$email" "$password" <<'PY'
import json,sys
print(json.dumps({'email':sys.argv[1],'password':sys.argv[2],'email_confirm':True}))
PY
)
  response=$(curl --fail-with-body -sS -X POST "$admin" -H "apikey: $SUPABASE_SERVICE_ROLE_KEY" -H "Authorization: Bearer $SUPABASE_SERVICE_ROLE_KEY" -H 'Content-Type: application/json' --data "$body" || true)
  echo "$email admin response: $response"
done

dana@cari.dev admin response: {"id":"f6ad15b7-7b81-4f2c-a3c6-2b612321d1b6","aud":"authenticated","role":"authenticated","email":"dana@cari.dev","email_confirmed_at":"2026-07-25T05:28:23.740403523Z","phone":"","app_metadata":{"provider":"email","providers":["email"]},"user_metadata":{"email_verified":true},"identities":[{"identity_id":"1d51f6ab-f116-4b2e-b9df-8942dc9cd158","id":"f6ad15b7-7b81-4f2c-a3c6-2b612321d1b6","user_id":"f6ad15b7-7b81-4f2c-a3c6-2b612321d1b6","identity_data":{"email":"dana@cari.dev","email_verified":false,"phone_verified":false,"sub":"f6ad15b7-7b81-4f2c-a3c6-2b612321d1b6"},"provider":"email","last_sign_in_at":"2026-07-25T05:28:23.738904991Z","created_at":"2026-07-25T05:28:23.738954Z","updated_at":"2026-07-25T05:28:23.738954Z","email":"dana@cari.dev"}],"created_at":"2026-07-25T05:28:23.737843Z","updated_at":"2026-07-25T05:28:23.741178Z","is_anonymous":false}
omar@cari.dev admin response: {"id":"6073fff5-564e-4dd1-ba70-70f6671bb5ea","aud":"authenticated","role":"authenticated","email":"omar@cari.dev","email_confirmed_at":"2026-07-25T05:28:23.988255116Z","phone":"","app_metadata":{"provider":"email","providers":["email"]},"user_metadata":{"email_verified":true},"identities":[{"identity_id":"55f6dd6f-821a-47bb-999d-70416f33062a","id":"6073fff5-564e-4dd1-ba70-70f6671bb5ea","user_id":"6073fff5-564e-4dd1-ba70-70f6671bb5ea","identity_data":{"email":"omar@cari.dev","email_verified":false,"phone_verified":false,"sub":"6073fff5-564e-4dd1-ba70-70f6671bb5ea"},"provider":"email","last_sign_in_at":"2026-07-25T05:28:23.98440486Z","created_at":"2026-07-25T05:28:23.984679Z","updated_at":"2026-07-25T05:28:23.984679Z","email":"omar@cari.dev"}],"created_at":"2026-07-25T05:28:23.983344Z","updated_at":"2026-07-25T05:28:23.988954Z","is_anonymous":false}

set -euo pipefail
for pair in 'dana@cari.dev|Passw0rd-dana-91' 'omar@cari.dev|Passw0rd-omar-17'; do
  email=${pair%%|*}; password=${pair#*|}
  body=$(python3 - "$email" "$password" <<'PY'
import json,sys
print(json.dumps({'email':sys.argv[1],'password':sys.argv[2]}))
PY
)
  out=$(curl --fail-with-body -sS -X POST "$SUPABASE_URL/auth/v1/token?grant_type=password" -H "apikey: $SUPABASE_ANON_KEY" -H 'Content-Type: application/json' --data "$body")
  python3 - "$email" "$out" <<'PY'
import json,sys
email, raw=sys.argv[1:]
r=json.loads(raw)
assert r.get('access_token'), r
assert r.get('token_type') == 'bearer', r
assert r.get('user',{}).get('email') == email, r
print(f"{email}: sign-in verified; token_type={r['token_type']}, expires_in={r.get('expires_in')}, user_id={r['user']['id']}")
PY
done

dana@cari.dev: sign-in verified; token_type=bearer, expires_in=3600, user_id=f6ad15b7-7b81-4f2c-a3c6-2b612321d1b6
omar@cari.dev: sign-in verified; token_type=bearer, expires_in=3600, user_id=6073fff5-564e-4dd1-ba70-70f6671bb5ea