tencent/hy3 · d1_crud · rep 3

echo "SUPABASE_URL=$SUPABASE_URL"
echo "SUPABASE_PROJECT_REF=$SUPABASE_PROJECT_REF"
echo "SUPABASE_ANON_KEY length: ${#SUPABASE_ANON_KEY}"
echo "SUPABASE_SERVICE_ROLE_KEY length: ${#SUPABASE_SERVICE_ROLE_KEY}"
echo "SUPABASE_DB_URL=$SUPABASE_DB_URL"
which psql supabase 2>/dev/null; echo "---"

SUPABASE_URL=https://<ref>.supabase.co
SUPABASE_PROJECT_REF=<ref>
SUPABASE_ANON_KEY length: 208
SUPABASE_SERVICE_ROLE_KEY length: 219
SUPABASE_DB_URL=<redacted:SUPABASE_DB_URL>
/usr/bin/psql
/usr/bin/supabase
---

psql "$SUPABASE_DB_URL" <<'SQL'
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
);

TRUNCATE public.products;

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);
SQL
echo "exit=$?"

CREATE TABLE
TRUNCATE TABLE
INSERT 0 5
exit=0

psql "$SUPABASE_DB_URL" <<'SQL'
-- Enable RLS and allow public (anon) reads
ALTER TABLE public.products ENABLE ROW LEVEL SECURITY;

DROP POLICY IF EXISTS "products_public_read" ON public.products;
CREATE POLICY "products_public_read"
  ON public.products
  FOR SELECT
  TO anon, authenticated
  USING (true);

-- Ensure roles have explicit select privilege
GRANT SELECT ON public.products TO anon, authenticated;
GRANT ALL ON public.products TO service_role;
SQL
echo "exit=$?"

ALTER TABLE
DROP POLICY
CREATE POLICY
GRANT
GRANT
exit=0

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

curl -s -w "\nHTTP %{http_code}\n" \
  -H "apikey: $SUPABASE_ANON_KEY" \
  -H "Authorization: Bearer $SUPABASE_ANON_KEY" \
  "$SUPABASE_URL/rest/v1/products?order=sku.asc"

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