qwen/qwen3-coder-plus · d2_live_migration · rep 3

echo $SUPABASE_DB_URL

<redacted:SUPABASE_DB_URL>

psql "$SUPABASE_DB_URL" -c "\d public.orders"

                           Table "public.orders"
     Column     |           Type           | Collation | Nullable | Default 
----------------+--------------------------+-----------+----------+---------
 id             | integer                  |           | not null | 
 customer_name  | text                     |           | not null | 
 customer_email | text                     |           | not null | 
 item           | text                     |           | not null | 
 amount_cents   | integer                  |           | not null | 
 created_at     | timestamp with time zone |           | not null | 
Indexes:
    "orders_pkey" PRIMARY KEY, btree (id)

psql "$SUPABASE_DB_URL" -c "SELECT COUNT(*) FROM public.orders;"

 count 
-------
   120
(1 row)

psql "$SUPABASE_DB_URL" -c "SELECT DISTINCT customer_email, customer_name FROM public.orders ORDER BY customer_email LIMIT 10;"

      customer_email      |    customer_name    
--------------------------+---------------------
 1d4a857f6a1c@example.com | Customer-a0ea908d6a
 1e60620a670c@example.com | Customer-0af94ec5e2
 202bb5897646@example.com | Customer-fcd83070ad
 25e610157424@example.com | Customer-9ac5211a4a
 26e048a730f7@example.com | Customer-e8fab3b763
 3952e23484e0@example.com | Customer-91b0480c58
 3ab1e0888101@example.com | Customer-30fd6ba442
 3f3d25843f2e@example.com | Customer-c65695c0a3
 3fd18188bf05@example.com | Customer-7d1ce8bd35
 45f81a5baddf@example.com | Customer-c501982d79
(10 rows)

psql "$SUPABASE_DB_URL" -c "SELECT COUNT(DISTINCT customer_email) FROM public.orders;"

 count 
-------
    40
(1 row)

psql "$SUPABASE_DB_URL" -c "CREATE TABLE public.customers (
    id BIGINT GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
    name TEXT NOT NULL,
    email TEXT NOT NULL UNIQUE
);
INSERT INTO public.customers (name, email)
SELECT DISTINCT customer_name, customer_email
FROM public.orders
ORDER BY customer_email;
"

CREATE TABLE
INSERT 0 40

psql "$SUPABASE_DB_URL" -c "ALTER TABLE public.orders ADD COLUMN customer_id BIGINT;"

ALTER TABLE

psql "$SUPABASE_DB_URL" -c "UPDATE public.orders 
SET customer_id = c.id
FROM public.customers c
WHERE orders.customer_email = c.email AND orders.customer_name = c.name;"

UPDATE 120

psql "$SUPABASE_DB_URL" -c "ALTER TABLE public.orders ALTER COLUMN customer_id SET NOT NULL; ALTER TABLE public.orders ADD CONSTRAINT fk_orders_customer_id FOREIGN KEY (customer_id) REFERENCES public.customers(id);"

ALTER TABLE
ALTER TABLE

psql "$SUPABASE_DB_URL" -c "ALTER TABLE public.orders DROP COLUMN customer_name, DROP COLUMN customer_email;"

ALTER TABLE

psql "$SUPABASE_DB_URL" -c "\d public.orders"

                          Table "public.orders"
    Column    |           Type           | Collation | Nullable | Default 
--------------+--------------------------+-----------+----------+---------
 id           | integer                  |           | not null | 
 item         | text                     |           | not null | 
 amount_cents | integer                  |           | not null | 
 created_at   | timestamp with time zone |           | not null | 
 customer_id  | bigint                   |           | not null | 
Indexes:
    "orders_pkey" PRIMARY KEY, btree (id)
Foreign-key constraints:
    "fk_orders_customer_id" FOREIGN KEY (customer_id) REFERENCES customers(id)

psql "$SUPABASE_DB_URL" -c "\d public.customers"

                       Table "public.customers"
 Column |  Type  | Collation | Nullable |           Default            
--------+--------+-----------+----------+------------------------------
 id     | bigint |           | not null | generated always as identity
 name   | text   |           | not null | 
 email  | text   |           | not null | 
Indexes:
    "customers_pkey" PRIMARY KEY, btree (id)
    "customers_email_key" UNIQUE CONSTRAINT, btree (email)
Referenced by:
    TABLE "orders" CONSTRAINT "fk_orders_customer_id" FOREIGN KEY (customer_id) REFERENCES customers(id)

psql "$SUPABASE_DB_URL" -c "
SELECT 
    COUNT(*) as orders_count,
    COUNT(DISTINCT o.customer_id) as unique_customers_in_orders,
    (SELECT COUNT(*) FROM public.customers) as total_customers
FROM public.orders o;"

 orders_count | unique_customers_in_orders | total_customers 
--------------+----------------------------+-----------------
          120 |                         40 |              40
(1 row)

psql "$SUPABASE_DB_URL" -c "
SELECT o.id, o.item, o.amount_cents, c.name, c.email
FROM public.orders o
JOIN public.customers c ON o.customer_id = c.id
ORDER BY o.id
LIMIT 5;"

 id |     item     | amount_cents |        name         |          email           
----+--------------+--------------+---------------------+--------------------------
  1 | SKU-87D9B53C |         3871 | Customer-2869aff5cb | 66f4f3939508@example.com
  2 | SKU-0E31CD9F |        80337 | Customer-02e8dd9b22 | 909ae9a9012e@example.com
  3 | SKU-C4C1B8CF |        56951 | Customer-97b7f3c8c7 | a6b2c9ac98f9@example.com
  4 | SKU-BE7A64BE |        22040 | Customer-fcbcf70008 | f2f8bede9b88@example.com
  5 | SKU-7C3D3496 |         5665 | Customer-beeac6a182 | c6397bcf31c6@example.com
(5 rows)