xiaomi/mimo-v2.5 · d1_crud · rep 3

echo "SUPABASE_URL=$SUPABASE_URL"
echo "SUPABASE_PROJECT_REF=$SUPABASE_PROJECT_REF"
echo "SUPABASE_ANON_KEY=$SUPABASE_ANON_KEY"
echo "SUPABASE_SERVICE_ROLE_KEY=${SUPABASE_SERVICE_ROLE_KEY:0:20}..."
echo "SUPABASE_DB_URL=$SUPABASE_DB_URL"
echo "SUPABASE_DB_PASSWORD=${SUPABASE_DB_PASSWORD:0:4}..."

SUPABASE_URL=https://<ref>.supabase.co
SUPABASE_PROJECT_REF=<ref>
SUPABASE_ANON_KEY=<redacted:SUPABASE_ANON_KEY>
SUPABASE_SERVICE_ROLE_KEY=eyJhbGciOiJIUzI1NiIs...
SUPABASE_DB_URL=<redacted:SUPABASE_DB_URL>
SUPABASE_DB_PASSWORD=1a9f...

which psql && psql --version

/usr/bin/psql
psql (PostgreSQL) 18.4 (Debian 18.4-1.pgdg12+1)

PGPASSWORD="$SUPABASE_DB_PASSWORD" psql "$SUPABASE_DB_URL" <<'SQL'
-- 1. Create the 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
);

-- 2. Enable Row Level Security (Supabase default for new tables)
ALTER TABLE public.products ENABLE ROW LEVEL SECURITY;

-- 3. Allow anon (public) read access
DROP POLICY IF EXISTS "Public read access" ON public.products;
CREATE POLICY "Public read access"
  ON public.products
  FOR SELECT
  TO anon
  USING ( true );

-- 4. Allow service_role full access (for inserts / admin)
DROP POLICY IF EXISTS "Service role full access" ON public.products;
CREATE POLICY "Service role full access"
  ON public.products
  FOR ALL
  TO service_role
  USING ( true )
  WITH CHECK ( true );

-- 5. 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)
ON CONFLICT (sku) DO UPDATE
  SET name        = EXCLUDED.name,
      price_cents = EXCLUDED.price_cents,
      stock       = EXCLUDED.stock;

-- 6. Verify row count
SELECT count(*) AS row_count FROM public.products;
SQL

CREATE TABLE
ALTER TABLE
DROP POLICY
CREATE POLICY
DROP POLICY
CREATE POLICY
INSERT 0 5
 row_count 
-----------
         5
(1 row)

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

# Read all products using ONLY the anon key
curl -s "${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
    }
]