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

echo "=== ENV VARS ===" && echo "SUPABASE_URL=$SUPABASE_URL" && echo "SUPABASE_PROJECT_REF=$SUPABASE_PROJECT_REF" && echo "SUPABASE_DB_URL=${SUPABASE_DB_URL:+set}" && echo "SUPABASE_ANON_KEY=${SUPABASE_ANON_KEY:0:20}..."

=== ENV VARS ===
SUPABASE_URL=https://<ref>.supabase.co
SUPABASE_PROJECT_REF=<ref>
SUPABASE_DB_URL=set
SUPABASE_ANON_KEY=eyJhbGciOiJIUzI1NiIs...

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

CREATE TABLE

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)
ON CONFLICT (sku) DO UPDATE SET name = EXCLUDED.name, price_cents = EXCLUDED.price_cents, stock = EXCLUDED.stock;
"

INSERT 0 5

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

GRANT

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

[{"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}]
200

PGPASSWORD="$SUPABASE_DB_PASSWORD" psql "$SUPABASE_DB_URL" -c "
SELECT * FROM public.products ORDER BY sku;
" && echo "---" && PGPASSWORD="$SUPABASE_DB_PASSWORD" psql "$SUPABASE_DB_URL" -c "
\d public.products"

   sku    |   name   | price_cents | stock 
----------+----------+-------------+-------
 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
(5 rows)

---

ERROR:  syntax error at or near "\"
LINE 2: \d public.products
        ^

PGPASSWORD="$SUPABASE_DB_PASSWORD" psql "$SUPABASE_DB_URL" -c "
SELECT column_name, data_type, is_nullable, column_default
FROM information_schema.columns
WHERE table_schema = 'public' AND table_name = 'products'
ORDER BY ordinal_position;"

 column_name | data_type | is_nullable | column_default 
-------------+-----------+-------------+----------------
 sku         | text      | NO          | 
 name        | text      | NO          | 
 price_cents | integer   | NO          | 
 stock       | integer   | NO          | 0
(4 rows)