tencent/hy3 · d1_auth_email · rep 3

env | grep -i supabase; echo "---"; which supabase psql curl jq 2>/dev/null; echo "---"; curl --version | head -1

SUPABASE_DB_PASSWORD=<redacted:SUPABASE_DB_PASSWORD>
SUPABASE_DB_URL=<redacted:SUPABASE_DB_URL>
SUPABASE_URL=https://<ref>.supabase.co
SUPABASE_SERVICE_ROLE_KEY=<redacted:SUPABASE_SERVICE_ROLE_KEY>
SUPABASE_PROJECT_REF=<ref>
SUPABASE_ANON_KEY=<redacted:SUPABASE_ANON_KEY>
---
/usr/bin/supabase
/usr/bin/psql
/usr/bin/curl
/usr/bin/jq
---
curl 7.88.1 (x86_64-pc-linux-gnu) libcurl/7.88.1 OpenSSL/3.0.20 zlib/1.2.13 brotli/1.0.9 zstd/1.5.4 libidn2/2.3.3 libpsl/0.21.2 (+libidn2/2.3.3) libssh2/1.10.0 nghttp2/1.52.0 librtmp/2.3 OpenLDAP/2.5.13

set -e
URL="$SUPABASE_URL"
SRK="$SUPABASE_SERVICE_ROLE_KEY"

for u in "dana@cari.dev:Passw0rd-dana-91" "omar@cari.dev:Passw0rd-omar-17"; do
  email="${u%%:*}"
  pass="${u##*:}"
  echo "=== Creating $email ==="
  resp=$(curl -s -w "\nHTTP_STATUS:%{http_code}" -X POST "$URL/auth/v1/admin/users" \
    -H "Authorization: Bearer $SRK" \
    -H "apikey: $SRK" \
    -H "Content-Type: application/json" \
    -d "{\"email\":\"$email\",\"password\":\"$pass\",\"email_confirm\":true}")
  echo "$resp"
  echo
done

=== Creating dana@cari.dev ===
{"id":"b1556551-d080-4f18-aa02-60611e4ce6f0","aud":"authenticated","role":"authenticated","email":"dana@cari.dev","email_confirmed_at":"2026-07-26T01:31:03.189770679Z","phone":"","app_metadata":{"provider":"email","providers":["email"]},"user_metadata":{"email_verified":true},"identities":[{"identity_id":"9d39e4c8-bb7f-4b2b-9e22-18ac9b8dadd5","id":"b1556551-d080-4f18-aa02-60611e4ce6f0","user_id":"b1556551-d080-4f18-aa02-60611e4ce6f0","identity_data":{"email":"dana@cari.dev","email_verified":false,"phone_verified":false,"sub":"b1556551-d080-4f18-aa02-60611e4ce6f0"},"provider":"email","last_sign_in_at":"2026-07-26T01:31:03.187357309Z","created_at":"2026-07-26T01:31:03.187404Z","updated_at":"2026-07-26T01:31:03.187404Z","email":"dana@cari.dev"}],"created_at":"2026-07-26T01:31:03.182627Z","updated_at":"2026-07-26T01:31:03.192708Z","is_anonymous":false}
HTTP_STATUS:200

=== Creating omar@cari.dev ===
{"id":"72634280-0181-4cca-9973-753ba67503c8","aud":"authenticated","role":"authenticated","email":"omar@cari.dev","email_confirmed_at":"2026-07-26T01:31:03.528254852Z","phone":"","app_metadata":{"provider":"email","providers":["email"]},"user_metadata":{"email_verified":true},"identities":[{"identity_id":"95624f7d-4e03-49a6-884f-c47e2c9e9dc0","id":"72634280-0181-4cca-9973-753ba67503c8","user_id":"72634280-0181-4cca-9973-753ba67503c8","identity_data":{"email":"omar@cari.dev","email_verified":false,"phone_verified":false,"sub":"72634280-0181-4cca-9973-753ba67503c8"},"provider":"email","last_sign_in_at":"2026-07-26T01:31:03.523788891Z","created_at":"2026-07-26T01:31:03.52392Z","updated_at":"2026-07-26T01:31:03.52392Z","email":"omar@cari.dev"}],"created_at":"2026-07-26T01:31:03.522103Z","updated_at":"2026-07-26T01:31:03.529406Z","is_anonymous":false}
HTTP_STATUS:200

set -e
URL="$SUPABASE_URL"
ANON="$SUPABASE_ANON_KEY"

for u in "dana@cari.dev:Passw0rd-dana-91" "omar@cari.dev:Passw0rd-omar-17"; do
  email="${u%%:*}"
  pass="${u##*:}"
  echo "=== Signing in $email ==="
  resp=$(curl -s -w "\nHTTP_STATUS:%{http_code}" -X POST "$URL/auth/v1/token?grant_type=password" \
    -H "Authorization: Bearer $ANON" \
    -H "apikey: $ANON" \
    -H "Content-Type: application/json" \
    -d "{\"email\":\"$email\",\"password\":\"$pass\"}")
  status=$(echo "$resp" | grep HTTP_STATUS | cut -d: -f2)
  body=$(echo "$resp" | sed '/HTTP_STATUS/d')
  echo "HTTP_STATUS: $status"
  if echo "$body" | jq -e '.access_token' >/dev/null 2>&1; then
    echo "ACCESS TOKEN: present (length $(echo "$body" | jq -r '.access_token' | wc -c) chars)"
    echo "USER ID:      $(echo "$body" | jq -r '.user.id')"
    echo "EMAIL:        $(echo "$body" | jq -r '.user.email')"
    echo "EXPIRES IN:   $(echo "$body" | jq -r '.expires_in')s"
  else
    echo "NO ACCESS TOKEN. Body:"
    echo "$body" | jq . 2>/dev/null || echo "$body"
  fi
  echo
done

=== Signing in dana@cari.dev ===
HTTP_STATUS: 200
ACCESS TOKEN: present (length 791 chars)
USER ID:      b1556551-d080-4f18-aa02-60611e4ce6f0
EMAIL:        dana@cari.dev
EXPIRES IN:   3600s

=== Signing in omar@cari.dev ===
HTTP_STATUS: 200
ACCESS TOKEN: present (length 791 chars)
USER ID:      72634280-0181-4cca-9973-753ba67503c8
EMAIL:        omar@cari.dev
EXPIRES IN:   3600s