def test_recursive_transaction(self):
"""test recursive transaction"""
table = self._create_table(('name VARCHAR(10)',), None)
connection_holder = Connection(self._context.make_connection())
query = transaction(self.get_insert_query(table))
connection_holder.commit = self.count_calls(connection_holder.commit)
connection_holder.commit.call_count = 0
self._context.wait(connection_holder.execute(transaction(query)))
self.assertEqual(1, connection_holder.commit.call_count)
def test_recursive_transaction(self):
"""test recursive transaction"""
table = self._create_table(('name VARCHAR(10)', ), None)
connection_holder = Connection(self._context.make_connection())
query = transaction(self.get_insert_query(table))
connection_holder.commit = self.count_calls(connection_holder.commit)
connection_holder.commit.call_count = 0
self._context.wait(connection_holder.execute(transaction(query)))
self.assertEqual(1, connection_holder.commit.call_count)
def test_commit(self):
"""test transaction commit"""
table = self._create_table(('name VARCHAR(10)',), None)
connection = Connection(self._context.make_connection())
query = self.get_insert_query(table)
self.assertIs(self._context.wait(connection.execute(transaction(query))), True)
self._context.wait(connection.rollback())
cursor = self._context.cursor()
self._context.wait(cursor.execute("SELECT * FROM %s" % table))
self.assertEqual([('Evelina',)], cursor.fetchall())
def test_commit(self):
"""test transaction commit"""
table = self._create_table(('name VARCHAR(10)', ), None)
connection = Connection(self._context.make_connection())
query = self.get_insert_query(table)
self.assertIs(
self._context.wait(connection.execute(transaction(query))), True)
self._context.wait(connection.rollback())
cursor = self._context.cursor()
self._context.wait(cursor.execute("SELECT * FROM %s" % table))
self.assertEqual([('Evelina', )], cursor.fetchall())
