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

set -e
printf 'DB URL present: '; [ -n "$SUPABASE_DB_URL" ] && echo yes || echo no
command -v psql || true
python3 - <<'PY'
import os
for k in ['SUPABASE_URL','SUPABASE_PROJECT_REF','SUPABASE_ANON_KEY','SUPABASE_SERVICE_ROLE_KEY','SUPABASE_DB_URL']:
 print(k, 'set' if os.getenv(k) else 'missing')
PY

DB URL present: yes
/usr/bin/psql
SUPABASE_URL set
SUPABASE_PROJECT_REF set
SUPABASE_ANON_KEY set
SUPABASE_SERVICE_ROLE_KEY set
SUPABASE_DB_URL set

set -e
cat > /tmp/schema.sql <<'SQL'
BEGIN;

CREATE TABLE IF NOT EXISTS public.authors (
  id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
  name text NOT NULL,
  email text NOT NULL UNIQUE
);

CREATE TABLE IF NOT EXISTS public.courses (
  id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
  author_id uuid NOT NULL REFERENCES public.authors(id),
  title text NOT NULL,
  price_cents integer NOT NULL CHECK (price_cents >= 0),
  published boolean NOT NULL DEFAULT false,
  created_at timestamptz NOT NULL DEFAULT now()
);

CREATE TABLE IF NOT EXISTS public.enrollments (
  id bigint GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
  course_id uuid NOT NULL REFERENCES public.courses(id) ON DELETE CASCADE,
  student_email text NOT NULL,
  enrolled_at timestamptz NOT NULL DEFAULT now(),
  UNIQUE (course_id, student_email)
);

CREATE INDEX IF NOT EXISTS courses_author_id_idx ON public.courses (author_id);
CREATE INDEX IF NOT EXISTS enrollments_student_email_idx ON public.enrollments (student_email);

-- Permit the REST API roles to discover and read the tables.
GRANT USAGE ON SCHEMA public TO anon, authenticated;
GRANT SELECT ON public.authors, public.courses, public.enrollments TO anon, authenticated;
GRANT SELECT, INSERT, UPDATE, DELETE ON public.authors, public.courses, public.enrollments TO authenticated;
GRANT USAGE, SELECT ON SEQUENCE public.enrollments_id_seq TO authenticated;

COMMIT;

NOTIFY pgrst, 'reload schema';
SQL
psql "$SUPABASE_DB_URL" -v ON_ERROR_STOP=1 -f /tmp/schema.sql

BEGIN
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE INDEX
CREATE INDEX
GRANT
GRANT
GRANT
GRANT
COMMIT
NOTIFY

set -e
curl -sS -o /tmp/rest.out -w 'HTTP %{http_code}\n' "$SUPABASE_URL/rest/v1/courses?select=*&limit=1" -H "apikey: $SUPABASE_ANON_KEY" -H "Authorization: Bearer $SUPABASE_ANON_KEY"
printf 'Response: '; cat /tmp/rest.out; echo

HTTP 200
Response: []

psql "$SUPABASE_DB_URL" -Atc "SELECT table_name FROM information_schema.tables WHERE table_schema='public' AND table_type='BASE TABLE' AND table_name IN ('authors','courses','enrollments') ORDER BY table_name; SELECT indexname FROM pg_indexes WHERE schemaname='public' AND indexname IN ('courses_author_id_idx','enrollments_student_email_idx') ORDER BY indexname;"

authors
courses
enrollments
courses_author_id_idx
enrollments_student_email_idx