deepseek/deepseek-v4-pro · d1_crud · rep 1

echo "URL: $SUPABASE_URL" && echo "REF: $SUPABASE_PROJECT_REF" && echo "DB_URL: $SUPABASE_DB_URL" | head -c 100

URL: https://<ref>.supabase.co
REF: <ref>
DB_URL: postgresql://postgres.<ref>:<redacted:SUPABASE_DB_PASSWORD>@

export PGPASSWORD="$SUPABASE_DB_PASSWORD" && psql "$SUPABASE_DB_URL" -c "
CREATE TABLE public.products (
    sku text PRIMARY KEY,
    name text NOT NULL,
    price_cents integer NOT NULL,
    stock integer NOT NULL DEFAULT 0
);"

CREATE TABLE

export PGPASSWORD="$SUPABASE_DB_PASSWORD" && psql "$SUPABASE_DB_URL" -c "
INSERT INTO public.products (sku, name, price_cents, stock) VALUES
    ('CARI-001', 'Anvil S', 1999, 12),
    ('CARI-002', 'Anvil M', 2999, 7),
    ('CARI-003', 'Anvil L', 4999, 3),
    ('CARI-004', 'Rope 30m', 1250, 40),
    ('CARI-005', 'Pulley', 780, 0);
"

INSERT 0 5

export PGPASSWORD="$SUPABASE_DB_PASSWORD" && psql "$SUPABASE_DB_URL" -c "
GRANT SELECT ON public.products TO anon;
GRANT SELECT ON public.products TO authenticated;
"

GRANT
GRANT

export PGPASSWORD="$SUPABASE_DB_PASSWORD" && psql "$SUPABASE_DB_URL" -c "
ALTER TABLE public.products ENABLE ROW LEVEL SECURITY;
CREATE POLICY products_select_policy ON public.products FOR SELECT USING (true);
"

ALTER TABLE
CREATE POLICY

curl -s -w "\nHTTP_CODE: %{http_code}\n" \
  "${SUPABASE_URL}/rest/v1/products" \
  -H "apikey: ${SUPABASE_ANON_KEY}" \
  -H "Authorization: Bearer ${SUPABASE_ANON_KEY}" \
  | head -80

[{"sku":"CARI-001","name":"Anvil S","price_cents":1999,"stock":12}, 
 {"sku":"CARI-002","name":"Anvil M","price_cents":2999,"stock":7}, 
 {"sku":"CARI-003","name":"Anvil L","price_cents":4999,"stock":3}, 
 {"sku":"CARI-004","name":"Rope 30m","price_cents":1250,"stock":40}, 
 {"sku":"CARI-005","name":"Pulley","price_cents":780,"stock":0}]
HTTP_CODE: 200