minimax/minimax-m3 · d1_crud · rep 1

env | grep -i supabase | sed 's/=.*/=<REDACTED>/'

SUPABASE_DB_PASSWORD=<REDACTED>
SUPABASE_DB_URL=<REDACTED>
SUPABASE_URL=<REDACTED>
SUPABASE_SERVICE_ROLE_KEY=<REDACTED>
SUPABASE_PROJECT_REF=<REDACTED>
SUPABASE_ANON_KEY=<REDACTED>

echo "SUPABASE_URL=$SUPABASE_URL"; echo "SUPABASE_PROJECT_REF=$SUPABASE_PROJECT_REF"

SUPABASE_URL=https://<ref>.supabase.co
SUPABASE_PROJECT_REF=<ref>

PGPASSWORD="$SUPABASE_DB_PASSWORD" psql "$SUPABASE_DB_URL" -c "SELECT current_database(), current_user, version();" 2>&1 | head -20

 current_database | current_user |                                   version                                    
------------------+--------------+------------------------------------------------------------------------------
 postgres         | postgres     | PostgreSQL 17.6 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 15.2.0, 64-bit
(1 row)

PGPASSWORD="$SUPABASE_DB_PASSWORD" psql "$SUPABASE_DB_URL" <<'SQL'
-- Idempotent: drop if exists for a clean state
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);

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

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

-- Grant table-level privileges to anon role
GRANT SELECT ON public.products TO anon;
GRANT USAGE ON SCHEMA public TO anon;
SQL

DROP TABLE
CREATE TABLE
INSERT 0 5
ALTER TABLE
DROP POLICY
CREATE POLICY
GRANT
GRANT

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

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

   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)

curl -sS -w "\nHTTP %{http_code}\n" \
  -H "apikey: $SUPABASE_ANON_KEY" \
  -H "Authorization: Bearer $SUPABASE_ANON_KEY" \
  "$SUPABASE_URL/rest/v1/products?select=sku,name,price_cents,stock&order=sku"

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