|
BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLEБайланысты: Язык SQL. Базовый курсБұл бет үшін навигация:
- INSERT INTO bookings ( book_ref, book_date, total_amount ) VALUES ( ABC123, bookings.now(), 0 ); INSERT 0 1 INSERT INTO tickets
- INSERT INTO ticket_flights ( ticket_no, flight_id, fare_conditions, amount ) VALUES ( 9991234567890, 13881, Business, 12500 );
- BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE;
- INSERT INTO bookings ( book_ref, book_date, total_amount ) VALUES ( ABC456, bookings.now(), 0 ); INSERT 0 1 INSERT INTO tickets
BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE;
BEGIN
SELECT * FROM ticket_flights WHERE flight_id = 13881;
ticket_no
| flight_id | fare_conditions | amount
---------------+-----------+-----------------+----------
0005433848165 |
13881 | Business
| 99800.00
...
0005433848007 |
13881 | Economy
| 33300.00
(82 строки)
INSERT INTO bookings ( book_ref, book_date, total_amount )
VALUES ( 'ABC123', bookings.now(), 0 );
INSERT 0 1
INSERT INTO tickets
( ticket_no, book_ref, passenger_id, passenger_name )
VALUES
( '9991234567890', 'ABC123', '1234 123456',
'IVAN PETROV' );
INSERT 0 1
INSERT INTO ticket_flights
( ticket_no, flight_id, fare_conditions, amount )
VALUES
( '9991234567890', 13881, 'Business', 12500 );
INSERT 0 1
UPDATE bookings
SET total_amount = 12500
WHERE book_ref = 'ABC123';
UPDATE 1
COMMIT;
COMMIT
Вторая транзакция:
BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE;
BEGIN
225
SELECT * FROM ticket_flights WHERE flight_id = 5572;
ticket_no
| flight_id | fare_conditions | amount
---------------+-----------+-----------------+----------
0005433847924 |
5572 | Business
| 99800.00
...
0005433847890 |
5572 | Economy
| 33300.00
(100 строк)
INSERT INTO bookings
( book_ref, book_date, total_amount )
VALUES
( 'ABC456', bookings.now(), 0 );
INSERT 0 1
INSERT INTO tickets
( ticket_no, book_ref, passenger_id, passenger_name )
VALUES
( '9991234567891', 'ABC456', '4321 654321',
Достарыңызбен бөлісу: |
|
|
