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

echo "SUPABASE_URL=$SUPABASE_URL"; echo "SUPABASE_PROJECT_REF=$SUPABASE_PROJECT_REF"; echo "ANON_KEY length: ${#SUPABASE_ANON_KEY}"; echo "SERVICE_ROLE_KEY length: ${#SUPABASE_SERVICE_ROLE_KEY}"; echo "DB_URL=$SUPABASE_DB_URL"; echo "DB_PASSWORD length: ${#SUPABASE_DB_PASSWORD}"

SUPABASE_URL=https://<ref>.supabase.co
SUPABASE_PROJECT_REF=<ref>
ANON_KEY length: 208
SERVICE_ROLE_KEY length: 219
DB_URL=<redacted:SUPABASE_DB_URL>
DB_PASSWORD length: 48

which psql 2>/dev/null; which curl 2>/dev/null; which jq 2>/dev/null

/usr/bin/psql
/usr/bin/curl
/usr/bin/jq

export PGPASSWORD="$SUPABASE_DB_PASSWORD"
DB_URL="$SUPABASE_DB_URL"
psql "$DB_URL" -v ON_ERROR_STOP=1 <<'SQL'
-- Create the products table
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
);

-- Clear any existing data
TRUNCATE public.products;

-- Insert the five rows
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);

-- Verify
SELECT * FROM public.products ORDER BY sku;
SQL

CREATE TABLE
TRUNCATE TABLE
INSERT 0 5
   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)

export PGPASSWORD="$SUPABASE_DB_PASSWORD"
DB_URL="$SUPABASE_DB_URL"
psql "$DB_URL" -v ON_ERROR_STOP=1 <<'SQL'
-- Enable RLS
ALTER TABLE public.products ENABLE ROW LEVEL SECURITY;

-- Create policy allowing public read access (anon role)
DROP POLICY IF EXISTS "public read access" ON public.products;
CREATE POLICY "public read access"
    ON public.products
    FOR SELECT
    TO anon, authenticated
    USING (true);

-- Verify policies
SELECT polname, polcmd, polroles::regrole[] FROM pg_policy WHERE polrelid = 'public.products'::regclass;
SQL

ALTER TABLE
DROP POLICY
CREATE POLICY
      polname       | polcmd |       polroles       
--------------------+--------+----------------------
 public read access | r      | {anon,authenticated}
(1 row)

NOTICE:  policy "public read access" for relation "public.products" does not exist, skipping

curl -s "$SUPABASE_URL/rest/v1/products?select=*&order=sku.asc" \
  -H "apikey: $SUPABASE_ANON_KEY" \
  -H "Authorization: Bearer $SUPABASE_ANON_KEY" | jq .

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