Changes between Version 42 and Version 43 of Transactions

Timestamp:

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

Author:

222039

Comment:

--

Transactions

@@ -127 +127 @@
 }}}
 
+===== Procedure Change Seat (атомична промена)
+Ако новото седиште е веќе земено, не смееме да го изгубиме старото -> промената мора да биде all or nothing.
 
+{{{
+DELIMITER $$
+
+CREATE PROCEDURE sp_change_seat(
+  IN p_booking_id INT,
+  IN p_new_seat CHAR(4)
+)
+BEGIN
+  DECLARE v_flight_id INT;
+  DECLARE exit handler FOR SQLEXCEPTION
+  BEGIN
+    ROLLBACK;
+    SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Seat change failed (transaction rolled back).';
+  END;
+
+  START TRANSACTION;
+
+  SELECT flight_id INTO v_flight_id
+  FROM booking
+  WHERE booking_id = p_booking_id
+  FOR UPDATE;
+
+  UPDATE booking
+  SET seat = p_new_seat
+  WHERE booking_id = p_booking_id;
+
+  COMMIT;
+END$$
+
+DELIMITER ;
+}}}
+
+
+