Changes between Version 7 and Version 8 of OtherTopics

Timestamp:

09/15/26 04:53:16 (12 days ago)

Author:

232012

Comment:

--

OtherTopics

@@ -37 +37 @@
 
     FROM generate_series(1, 5000)
+
+    RETURNING order_id
+)
+INSERT INTO project.order_products
+(
+    order_id,
+    product_id,
+    price_at_purchase,
+    quantity
+)
+SELECT
+    no.order_id,
+    p.product_id,
+    p.price,
+    1 + floor(random() * 4)::bigint
+FROM new_orders no
+CROSS JOIN LATERAL (
+    SELECT
+        product_id,
+        price
+    FROM project.products
+    ORDER BY random()
+    LIMIT 3
+) p;
+}}}
+
+{{{
+WITH new_orders AS (
+    INSERT INTO project.orders
+    (
+        user_id,
+        payment_method,
+        purchase_date,
+        points_earned,
+        points_used,
+        status
+    )
+    SELECT
+        (ARRAY[1,2,3,5,6,7,8,10,11,12,13,14])
+            [1 + floor(random() * 12)::int],
+
+        (ARRAY[
+            'CARD'::project.payment_method_type,
+            'PAYPAL'::project.payment_method_type,
+            'CASH'::project.payment_method_type
+        ])
+            [1 + floor(random() * 3)::int],
+
+        CURRENT_DATE
+            - 366
+            - floor(random() * 730)::int,
+
+        floor(random() * 100)::bigint,
+
+        NULL,
+
+        'CANCELLED'::project.order_status_type
+
+    FROM generate_series(1, 20000)
 
     RETURNING order_id