Changes between Version 1 and Version 2 of ImportatntUseCase003

Timestamp:

02/10/25 11:55:59 (12 days ago)

Author:

221128

Comment:

--

ImportatntUseCase003

@@ -4 +4 @@
 === Steps in the Scenario ===
 **__1. Employee opens tab.__**
-
+{{{
 SELECT p.name, p.price, oi.quantity
 FROM order_items oi
 JOIN products p ON p.id = oi.product_id
-WHERE oi.order_id = 1;
+WHERE oi.order_id = 1
+}}}
 
 **__2. Employee adds order items.__**
-
+{{{
 INSERT INTO order_items(id, order_id, product_id, is_processed, quantity)
 VALUES (7,1,1,false,1);
 INSERT INTO order_items(id ,order_id, product_id, is_processed, quantity)
 VALUES (8,1,2,false,1);
-
+}}}
 **__3. Employee marks order items as processed.__**
-
+{{{
 UPDATE order_items SET is_processed=true WHERE id=7;
 UPDATE order_items SET is_processed=true WHERE id=8;
-
+}}}
 **__4. Employee closes tab.__**
 
 **__5. System prints bil.__**
-
-UPDATE orders SET status='CONFIRMED' WHERE id=1;
+{{{
+UPDATE orders SET status='CONFIRMED' WHERE id=1
+}}}
 
 **__6. Employee finalizes payment.__**
-
+{{{
 INSERT INTO payments(id, order_id, amount, payment_type, tip_amount)
 SELECT 3,1, SUM(oi.price), ‘cash’, 0 FROM order_items oi WHERE oi.order_id = 1
+}}}