def test_table_has_extra_item(self): self.db2.cursor().execute("INSERT INTO foo VALUES (" + str(11) + ", 'missing');"); self.assertEqual(fmt.format_table_diff("foo", diff.diff_table("foo", self.db1, self.db2)), "> INSERT INTO foo VALUES (11, 'missing');\n") self.db1.cursor().execute("INSERT INTO foo VALUES (" + str(11) + ", 'missing');"); self.db1.cursor().execute("INSERT INTO foo VALUES (" + str(12) + ", 'missing');"); self.assertEqual(fmt.format_table_diff("foo", diff.diff_table("foo", self.db1, self.db2)), "< INSERT INTO foo VALUES (12, 'missing');\n")
def test_table_has_diff_items(self): self.db1.cursor().execute("INSERT INTO foo VALUES (" + str(11) + ", 'AAA');"); self.db2.cursor().execute("INSERT INTO foo VALUES (" + str(11) + ", 'BBB');"); self.assertEqual(fmt.format_table_diff("foo", diff.diff_table("foo", self.db1, self.db2)), """< INSERT INTO foo VALUES (11, 'AAA'); --- > INSERT INTO foo VALUES (11, 'BBB'); """)
def test_tables_identical(self): self.assertEqual(fmt.format_table_diff("foo", diff.diff_table("foo", self.db1, self.db2)), '')