Python diff_table示例

示例#1

文件： test_format.py 项目： awakmu/Sqlite-Diff

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

示例#2

文件： test_format.py 项目： awakmu/Sqlite-Diff

    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');
""")

示例#3

文件： test_format.py 项目： awakmu/Sqlite-Diff

 def test_tables_identical(self):
     self.assertEqual(fmt.format_table_diff("foo", diff.diff_table("foo", self.db1, self.db2)), '')

示例#4

文件： test_table_diff.py 项目： awakmu/Sqlite-Diff

 def test_table_has_diff_items(self):
     self.db1.cursor().execute("INSERT INTO foo VALUES (11, 11, 'AAA');");
     self.db2.cursor().execute("INSERT INTO foo VALUES (11, 11, 'BBB');");
     self.assertEqual(diff.diff_table("foo", self.db1, self.db2), [ ((11, 11, u"AAA"), (11, 11, u"BBB"))] )

示例#5

文件： test_table_diff.py 项目： awakmu/Sqlite-Diff

 def test_table_has_extra_item(self):
     self.db2.cursor().execute("INSERT INTO foo VALUES (11, 11, 'missing');");
     self.assertEqual(diff.diff_table("foo", self.db1, self.db2), [ (None, (11, 11, u"missing") )] )
     self.db1.cursor().execute("INSERT INTO foo VALUES (11, 11, 'missing');");
     self.db1.cursor().execute("INSERT INTO foo VALUES (11, 12, 'missing');");
     self.assertEqual(diff.diff_table("foo", self.db1, self.db2), [ ((11, 12, u"missing"), None)] )

示例#6

文件： test_table_diff.py 项目： awakmu/Sqlite-Diff

 def test_tables_identical(self):
     self.assertFalse(diff.diff_table("foo", self.db1, self.db2))

示例#7

文件： test_table_diff.py 项目： awakmu/Sqlite-Diff

 def test_table_has_gap(self):
     self.db2.cursor().execute("INSERT INTO foo VALUES (" + str(11) + ", 'missing');");
     self.db1.cursor().execute("INSERT INTO foo VALUES (" + str(12) + ", 'AAA');");
     self.db2.cursor().execute("INSERT INTO foo VALUES (" + str(12) + ", 'AAA');");
     self.assertEqual(diff.diff_table("foo", self.db1, self.db2), [ (None, (11, u"missing"))] )