z-ai/glm-5.2 · d1_crud · rep 1

echo "URL: $SUPABASE_URL" && echo "REF: $SUPABASE_PROJECT_REF" && echo "ANON: ${SUPABASE_ANON_KEY:0:20}..." && echo "SERVICE: ${SUPABASE_SERVICE_ROLE_KEY:0:20}..." && echo "DB_URL: $SUPABASE_DB_URL" && echo "DB_PASS set: $([ -n "$SUPABASE_DB_PASSWORD" ] && echo yes || echo no)" && which psql && which curl && which jq

URL: https://<ref>.supabase.co
REF: <ref>
ANON: eyJhbGciOiJIUzI1NiIs...
SERVICE: eyJhbGciOiJIUzI1NiIs...
DB_URL: <redacted:SUPABASE_DB_URL>
DB_PASS set: yes
/usr/bin/psql
/usr/bin/curl
/usr/bin/jq

psql "$SUPABASE_DB_URL" -v ON_ERROR_STOP=1 <<'SQL'
-- Create the products 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
);

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

-- Enable RLS
ALTER TABLE public.products ENABLE ROW LEVEL SECURITY;

-- Drop existing policy if any, then create a public read policy
DROP POLICY IF EXISTS "public read products" ON public.products;
CREATE POLICY "public read products"
    ON public.products
    FOR SELECT
    USING (true);
SQL

CREATE TABLE
INSERT 0 5
ALTER TABLE
DROP POLICY
CREATE POLICY

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

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

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

parse error: Invalid numeric literal at line 6, column 12

curl -s -o /tmp/products.json -w "%{http_code}" \
  "$SUPABASE_URL/rest/v1/products?order=sku" \
  -H "apikey: $SUPABASE_ANON_KEY" \
  -H "Authorization: Bearer $SUPABASE_ANON_KEY"
echo ""
echo "--- Row count ---"
jq 'length' /tmp/products.json
echo "--- Verifying all rows match expected ---"
jq -e '
  [
    {"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}
  ] as $expected
  | . == $expected
' /tmp/products.json && echo "✅ All rows match exactly" || echo "❌ Mismatch"

200
--- Row count ---
5
--- Verifying all rows match expected ---
true
✅ All rows match exactly