test a basic rollback
(self, local_connection)
| 63 | connection.close() |
| 64 | |
| 65 | def test_rollback(self, local_connection): |
| 66 | """test a basic rollback""" |
| 67 | |
| 68 | users = self.tables.users |
| 69 | connection = local_connection |
| 70 | transaction = connection.begin() |
| 71 | connection.execute(users.insert(), dict(user_id=1, user_name="user1")) |
| 72 | connection.execute(users.insert(), dict(user_id=2, user_name="user2")) |
| 73 | connection.execute(users.insert(), dict(user_id=3, user_name="user3")) |
| 74 | transaction.rollback() |
| 75 | result = connection.exec_driver_sql("select * from users") |
| 76 | assert len(result.fetchall()) == 0 |
| 77 | |
| 78 | def test_raise(self, local_connection): |
| 79 | connection = local_connection |