Changes between Version 5 and Version 6 of DatabaseProgramming

Timestamp:

04/30/26 14:32:08 (2 days ago)

Author:

231027

Comment:

--

DatabaseProgramming

@@ -201 +201 @@
 
 }}}
+
+== Тестирање на `proc_execute_purchase`, `fn_calculate_price`, `proc_execute_refund`, `trg_buy_age`, `trg_ticket_gate`
+
+{{{
+
+-- 1. make purchase
+CALL proc_execute_purchase(1, 100, 'QR-TEST-CODE-001');
+
+-- 2. 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
+SELECT * FROM "Ticket_Purchase" WHERE ticket_id = 100;
+
+-- 4. 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)
+SELECT is_available FROM "Ticket" WHERE ticket_id = 100;
+
+-- 6. check if there is a corresponding record in Ticket_Refund
+SELECT * FROM "Ticket_Refund" WHERE purchase_id = 16000001;
+
+}}}