def test_rollback(self): cmy1 = MySQL(buffered=True) cmy1.connect(**self.connect_kwargs) cmy2 = MySQL(buffered=True) cmy2.connect(**self.connect_kwargs) table = "commit_test" cmy1.query("DROP TABLE IF EXISTS {0}".format(table)) cmy1.query("CREATE TABLE {0} (c1 INT)".format(table)) cmy1.query("START TRANSACTION") cmy1.query("INSERT INTO {0} (c1) VALUES " "(1), (2), (3)".format(table)) cmy1.commit() cmy2.query("SELECT * FROM {0}".format(table)) self.assertEqual([(1,), (2,), (3,)], fetch_rows(cmy2)) cmy1.query("START TRANSACTION") cmy1.query("INSERT INTO {0} (c1) VALUES " "(4), (5), (6)".format(table)) cmy1.rollback() cmy2.query("SELECT * FROM {0}".format(table)) self.assertEqual(3, cmy2.num_rows()) cmy1.query("DROP TABLE IF EXISTS {0}".format(table))
def test_rollback(self): cmy1 = MySQL(buffered=True) cmy1.connect(**self.connect_kwargs) cmy2 = MySQL(buffered=True) cmy2.connect(**self.connect_kwargs) table = "commit_test" cmy1.query("DROP TABLE IF EXISTS {0}".format(table)) cmy1.query("CREATE TABLE {0} (c1 INT)".format(table)) cmy1.query("START TRANSACTION") cmy1.query("INSERT INTO {0} (c1) VALUES " "(1), (2), (3)".format(table)) cmy1.commit() cmy2.query("SELECT * FROM {0}".format(table)) self.assertEqual([(1, ), (2, ), (3, )], fetch_rows(cmy2)) cmy1.query("START TRANSACTION") cmy1.query("INSERT INTO {0} (c1) VALUES " "(4), (5), (6)".format(table)) cmy1.rollback() cmy2.query("SELECT * FROM {0}".format(table)) self.assertEqual(3, cmy2.num_rows()) cmy1.query("DROP TABLE IF EXISTS {0}".format(table))