Changes between Version 14 and Version 15 of DatabaseProgramming

Timestamp:

05/01/26 02:13:42 (37 hours ago)

Author:

231027

Comment:

--

DatabaseProgramming

@@ -216 +216 @@
 {{{
 
--- 1. make purchase
+-- make purchase
 CALL proc_execute_purchase(1, 100, 'QR-TEST-CODE-001');
 
--- 2. check if ticket is not available (is_available should be false)
+-- check if ticket is not available (is_available should be false)
 SELECT is_available FROM "Ticket" WHERE ticket_id = 100;
 
--- 3. check if price is calculated correctly in Ticket_Purchase
+-- check if price is calculated correctly in Ticket_Purchase
 SELECT * FROM "Ticket_Purchase" WHERE ticket_id = 100;
 
--- 4. make refund to the purchase (purchase_id from before)
+-- make refund to the purchase (purchase_id from before)
 CALL proc_execute_refund(16000001);
 
--- 5. check if the ticket is available (is_available should be true)
+-- check if the ticket is available (is_available should be true)
 SELECT is_available FROM "Ticket" WHERE ticket_id = 100;
 
--- 6. check if there is a corresponding record in Ticket_Refund
+-- check if there is a corresponding record in Ticket_Refund
 SELECT * FROM "Ticket_Refund" WHERE purchase_id = 16000001;