deepseek/deepseek-v4-pro · d1_crud · rep 3

echo "SUPABASE_URL=$SUPABASE_URL" && echo "SUPABASE_PROJECT_REF=$SUPABASE_PROJECT_REF" && echo "SUPABASE_DB_URL=$SUPABASE_DB_URL" | sed 's/:[^:@]*@/:*****@/'

SUPABASE_URL=https://<ref>.supabase.co
SUPABASE_PROJECT_REF=<ref>
SUPABASE_DB_URL=postgresql://postgres.<ref>:<redacted>@aws-0-us-east-1.pooler.supabase.com:5432/postgres

PGPASSWORD="$SUPABASE_DB_PASSWORD" psql "$SUPABASE_DB_URL" -c "
CREATE TABLE public.products (
    sku text PRIMARY KEY,
    name text NOT NULL,
    price_cents integer NOT NULL,
    stock integer NOT NULL DEFAULT 0
);
"

CREATE TABLE

PGPASSWORD="$SUPABASE_DB_PASSWORD" psql "$SUPABASE_DB_URL" -c "
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);
"

INSERT 0 5

PGPASSWORD="$SUPABASE_DB_PASSWORD" psql "$SUPABASE_DB_URL" -c "
GRANT SELECT ON public.products TO anon;
ALTER PUBLICATION supabase_realtime ADD TABLE public.products;
"

GRANT
ALTER PUBLICATION

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 -s -H "apikey: $SUPABASE_ANON_KEY" "$SUPABASE_URL/rest/v1/products?select=*&order=sku" | 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
    }
]