minimax/minimax-m3 · d1_crud · rep 2

echo "URL=$SUPABASE_URL"; echo "REF=$SUPABASE_PROJECT_REF"; echo "DB_URL set: $([ -n "$SUPABASE_DB_URL" ] && echo yes || echo no)"; echo "ANON set: $([ -n "$SUPABASE_ANON_KEY" ] && echo yes || echo no)"; echo "SERVICE set: $([ -n "$SUPABASE_SERVICE_ROLE_KEY" ] && echo yes || echo no)"

URL=https://<ref>.supabase.co
REF=<ref>
DB_URL set: yes
ANON set: yes
SERVICE set: yes

curl -sS -o /tmp/before.txt -w "HTTP %{http_code}\n" -H "apikey: $SUPABASE_ANON_KEY" -H "Authorization: Bearer $SUPABASE_ANON_KEY" "$SUPABASE_URL/rest/v1/products?select=*"; echo "---body---"; cat /tmp/before.txt

HTTP 404
---body---
{"code":"PGRST205","details":null,"hint":null,"message":"Could not find the table 'public.products' in the schema cache"}

cat > /tmp/schema.sql <<'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
);

alter table public.products enable row level security;

drop policy if exists "public read products" on public.products;
create policy "public read products"
  on public.products
  for select
  to anon
  using (true);

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;

notify pgrst, 'reload schema';
SQL
psql "$SUPABASE_DB_URL" -v ON_ERROR_STOP=1 -f /tmp/schema.sql

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

psql:/tmp/schema.sql:10: NOTICE:  policy "public read products" for relation "public.products" does not exist, skipping

sleep 2; curl -sS -o /tmp/after.txt -w "HTTP %{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"; echo "---body---"; cat /tmp/after.txt; echo

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