console_2

-- 1.4
BEGIN ISOLATION LEVEL READ COMMITTED;

SELECT pilot_name FROM results
    WHERE id = 1;

UPDATE results SET pilot_name = 'Lewis' WHERE id = 1;

SELECT pilot_name FROM results
    WHERE id = 1;

COMMIT;


BEGIN ISOLATION LEVEL READ COMMITTED;

INSERT INTO results( stable_id, stage_id, laps_count, pilot_name, race_time, pit_stop_count, place)
VALUES ( 1, 1, 50, 'Lewis', '3:12:5', 2, 1);

COMMIT;


BEGIN ISOLATION LEVEL REPEATABLE READ;

INSERT INTO results(stable_id, stage_id, laps_count, pilot_name, race_time, pit_stop_count, place)
VALUES (1, 1, 50, 'Lewis', '3:12:5', 2, 1);

COMMIT;



BEGIN ISOLATION LEVEL SERIALIZABLE;

INSERT INTO results(stable_id, stage_id, laps_count, pilot_name, race_time, pit_stop_count, place)
VALUES (1, 1, 50, 'Lewis', '3:12:5', 2, 1);

COMMIT;


select * from stables;

select * from stages;

select * from results;