Changes between Version 4 and Version 5 of UseCase007

Timestamp:

06/02/26 21:56:53 (9 days ago)

Author:

232012

Comment:

--

UseCase007

@@ -56 +56 @@
 {{{#!div style="margin-left: 20px;"
 {{{
-INSERT INTO ORDER_ITEMS (order_id, product_id, quantity, price_at_purchase) 
+INSERT INTO ORDER_PRODUCTS (order_id, product_id, quantity, price_at_purchase) 
 VALUES (:active_order_id, :selected_product_id, :requested_quantity, :current_price)
 ON CONFLICT (order_id, product_id) 
@@ -68 +68 @@
 {{{
 SELECT COALESCE(SUM(quantity * price_at_purchase), 0) AS new_total
-FROM ORDER_ITEMS
+FROM ORDER_PRODUCTS
 WHERE order_id = :active_order_id;
 }}}