claude-sonnet-5 · d1_crud · rep 1

echo "SUPABASE_URL=$SUPABASE_URL"; echo "SUPABASE_PROJECT_REF=$SUPABASE_PROJECT_REF"; echo "SUPABASE_DB_URL=$SUPABASE_DB_URL"; echo "has anon key: ${#SUPABASE_ANON_KEY}"; echo "has service key: ${#SUPABASE_SERVICE_ROLE_KEY}"; echo "has db password: ${#SUPABASE_DB_PASSWORD}"

SUPABASE_URL=https://<ref>.supabase.co
SUPABASE_PROJECT_REF=<ref>
SUPABASE_DB_URL=<redacted:SUPABASE_DB_URL>
has anon key: 208
has service key: 219
has db password: 32

which psql || (apt-get update -qq && apt-get install -y -qq postgresql-client) 2>&1 | tail -20

/usr/bin/psql

psql "$SUPABASE_DB_URL" -v ON_ERROR_STOP=1 <<'EOF'
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
);

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;

-- Enable RLS and allow public read access
ALTER TABLE public.products ENABLE ROW LEVEL SECURITY;

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);

-- Grant select to anon/authenticated roles
GRANT SELECT ON public.products TO anon, authenticated;

SELECT * FROM public.products ORDER BY sku;
EOF

CREATE TABLE
INSERT 0 5
ALTER TABLE
DROP POLICY
CREATE POLICY
GRANT
   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)

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

curl -s -X GET "${SUPABASE_URL}/rest/v1/products?select=*&order=sku" \
  -H "apikey: ${SUPABASE_ANON_KEY}" \
  -H "Authorization: Bearer ${SUPABASE_ANON_KEY}" | python3 -m json.tool

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

curl -s -o /dev/null -w "HTTP status: %{http_code}\n" "${SUPABASE_URL}/rest/v1/products?select=*" \
  -H "apikey: ${SUPABASE_ANON_KEY}" \
  -H "Authorization: Bearer ${SUPABASE_ANON_KEY}"

# also confirm count matches exactly 5
curl -s "${SUPABASE_URL}/rest/v1/products?select=sku" \
  -H "apikey: ${SUPABASE_ANON_KEY}" \
  -H "Authorization: Bearer ${SUPABASE_ANON_KEY}" | python3 -c "import json,sys; d=json.load(sys.stdin); print('row count:', len(d))"

HTTP status: 200
row count: 5