#!/usr/bin/env python # # Public Domain 2014-present MongoDB, Inc. # Public Domain 2008-2014 WiredTiger, Inc. # # This is free and unencumbered software released into the public domain. # # Anyone is free to copy, modify, publish, use, compile, sell, or # distribute this software, either in source code form or as a compiled # binary, for any purpose, commercial or non-commercial, and by any # means. # # In jurisdictions that recognize copyright laws, the author or authors # of this software dedicate any and all copyright interest in the # software to the public domain. We make this dedication for the benefit # of the public at large and to the detriment of our heirs and # successors. We intend this dedication to be an overt act of # relinquishment in perpetuity of all present and future rights to this # software under copyright law. # # THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, # EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF # MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. # IN NO EVENT SHALL THE AUTHORS BE LIABLE FOR ANY CLAIM, DAMAGES OR # OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, # ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR # OTHER DEALINGS IN THE SOFTWARE. # # test_txn20.py # Transactions: more granular testing of isolation levels # import wttest from wtscenario import make_scenarios class test_txn20(wttest.WiredTigerTestCase): uri = 'table:test_txn' iso_types = [ ('isolation_read_uncommitted', dict(isolation='read-uncommitted')), ('isolation_read_committed', dict(isolation='read-committed')), ('isolation_snapshot', dict(isolation='snapshot')) ] scenarios = make_scenarios(iso_types) key = 'key' old_value = 'value: old' new_value = 'value: new' def test_isolation_level(self): self.session.create(self.uri, 'key_format=S,value_format=S') cursor = self.session.open_cursor(self.uri, None) cursor[self.key] = self.old_value # Make an update and don't commit it just yet. We should see the update # from the 'read-uncommitted' isolation level. self.session.begin_transaction() cursor[self.key] = self.new_value s = self.conn.open_session() cursor = s.open_cursor(self.uri, None) s.begin_transaction('isolation=' + self.isolation) if self.isolation == 'read-uncommitted': # Unlike the 'read-committed' and 'snapshot' isolation levels, we're # not protected from dirty reads so we'll see the update above even # though its respective transaction has not been committed. self.assertEqual(cursor[self.key], self.new_value) else: self.assertEqual(cursor[self.key], self.old_value) # Commit the update now. We should see the update from the # 'read-committed' and 'read-uncommitted' isolation levels. self.session.commit_transaction() if self.isolation == 'snapshot': # We should never see the updates above since it wasn't committed at # the time of the snapshot. self.assertEqual(cursor[self.key], self.old_value) else: # Unlike the 'snapshot' isolation level, 'read-committed' is not # protected from non-repeatable reads so we'll see an update # that wasn't visible earlier in our previous read. As before, # 'read-uncommitted' will still see the new value. self.assertEqual(cursor[self.key], self.new_value) if __name__ == '__main__': wttest.run()