Changes between Version 43 and Version 44 of Transactions

Timestamp:

02/10/26 18:14:06 (3 weeks ago)

Author:

222039

Comment:

--

Transactions

@@ -162 +162 @@
 }}}
 
+===== Procedure Cancel Booking
+За да спречиме паралелна модификација (пр. change seat) да се судри со cancel.
 
+{{{
+DELIMITER $$
 
+CREATE PROCEDURE sp_cancel_booking(
+  IN p_booking_id INT
+)
+BEGIN
+  DECLARE exit handler FOR SQLEXCEPTION
+  BEGIN
+    ROLLBACK;
+    SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Cancel failed (transaction rolled back).';
+  END;
+
+  START TRANSACTION;
+
+  SELECT booking_id
+  FROM booking
+  WHERE booking_id = p_booking_id
+  FOR UPDATE;
+
+  DELETE FROM booking
+  WHERE booking_id = p_booking_id;
+
+  COMMIT;
+END$$
+
+DELIMITER ;
+}}}
+