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())