z-ai/glm-5.2 · d1_crud · rep 3

echo "SUPABASE_URL=$SUPABASE_URL" && echo "SUPABASE_PROJECT_REF=$SUPABASE_PROJECT_REF" && echo "SUPABASE_ANON_KEY length=$(echo -n $SUPABASE_ANON_KEY | wc -c)" && echo "SUPABASE_DB_URL=$SUPABASE_DB_URL"

SUPABASE_URL=https://<ref>.supabase.co
SUPABASE_PROJECT_REF=<ref>
SUPABASE_ANON_KEY length=208
SUPABASE_DB_URL=<redacted:SUPABASE_DB_URL>

which psql && psql --version

/usr/bin/psql
psql (PostgreSQL) 18.4 (Debian 18.4-1.pgdg12+1)

export PGPASSWORD="<redacted:SUPABASE_DB_PASSWORD>"
psql "$SUPABASE_DB_URL" -c "
DROP TABLE IF EXISTS public.products;
CREATE TABLE public.products (
    sku text PRIMARY KEY,
    name text NOT NULL,
    price_cents integer NOT NULL,
    stock integer NOT NULL DEFAULT 0
);
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);
"

DROP TABLE
CREATE TABLE
INSERT 0 5

NOTICE:  table "products" does not exist, skipping

export PGPASSWORD="<redacted:SUPABASE_DB_PASSWORD>"
psql "$SUPABASE_DB_URL" -c "
ALTER TABLE public.products ENABLE ROW LEVEL SECURITY;
CREATE POLICY \"public read products\" ON public.products
    FOR SELECT TO anon, authenticated
    USING (true);
GRANT SELECT ON public.products TO anon, authenticated;
"

ALTER TABLE
CREATE POLICY
GRANT

echo "=== Test with anon key (should work) ===" && \
curl -s "$SUPABASE_URL/rest/v1/products?select=*&order=sku" \
  -H "apikey: $SUPABASE_ANON_KEY" \
  -H "Authorization: Bearer $SUPABASE_ANON_KEY" && \
echo "" && \
echo "=== Row count ===" && \
curl -s "$SUPABASE_URL/rest/v1/products?select=*&order=sku" \
  -H "apikey: $SUPABASE_ANON_KEY" \
  -H "Authorization: Bearer $SUPABASE_ANON_KEY" | python3 -c "import sys,json; d=json.load(sys.stdin); print(f'{len(d)} rows returned')"

=== Test with anon key (should work) ===
[{"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}]
=== Row count ===
5 rows returned