bsa7/pg-transaction-isolation-levels

Test Postgresql transaction isolation with RSpec and Ruby

Postgresql transaction isolation level test with RSpec and Ruby

How to use this examples:

To prepare:

bundle install

To start pg:

docker-compose up -d

To run examples:

bundle exec rspec

Also, you can run each example separately:

bundle exec rspec spec/read_committed/dirty_read_spec.rb

List of examples

• spec/accounts_spec.rb - This spec checks that the connection to the database is established and the accounts table contains data.
• spec/read_committed/dirty_read_spec.rb - This spec demonstrates dirty reads allowed at the read committed isolation level.
• spec/read_committed/unconsistent_read_spec.rb - This spec demonstrates unconsistent reads at the read committed isolation level.
• spec/read_committed/lost_update_spec.rb - This spec demonstrates lost update problem at the read committed isolation level.