Changes between Version 6 and Version 7 of DatabaseProgramming

Timestamp:

05/26/26 16:48:28 (9 hours ago)

Author:

231070

Comment:

--

DatabaseProgramming

@@ -659 +659 @@
 EXECUTE FUNCTION fn_trig_quantity();
 
--- Pred insert: quantity_available = 692
+-- Test INSERT - нов тикет
+SELECT quantity_available FROM event_ticket_type 
+WHERE eventid = 33 AND ticket_typeid = 1;
+-- quantity_available пред insert == 692
+
+-- Додавање нов тикет
 INSERT INTO ticket (code, status, ticket_typeid, user_orderid, seatid, app_userid, eventid, hallid)
 VALUES ('TKT-TEST-TRIG', 'ACTIVE', 1,
-        (SELECT MIN(id) FROM user_order), NULL,
-        (SELECT MIN(id) FROM app_user WHERE id != 1), 33,
+        (SELECT MIN(id) FROM user_order),
+        NULL,
+        (SELECT MIN(id) FROM app_user WHERE id != 1),
+        33,
         (SELECT MIN(hallid) FROM event_hall WHERE eventid = 33));
--- Po insert: quantity_available = 691
-
+
+
+SELECT quantity_available FROM event_ticket_type 
+WHERE eventid = 33 AND ticket_typeid = 1; 
+-- quantity_available по insert == 691
+
+-- Test UPDATE - откажување тикет
 UPDATE ticket SET status = 'CANCELLED' WHERE code = 'TKT-TEST-TRIG';
--- Po update: quantity_available = 692
+
+SELECT quantity_available FROM event_ticket_type 
+WHERE eventid = 33 AND ticket_typeid = 1;
+-- quantity_available по откажување == 692
 }}}