Python format_table_diff Exemples

Exemple #1

Fichier : test_format.py Projet : 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")

Exemple #2

Fichier : test_format.py Projet : 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');
""")

Exemple #3

Fichier : test_format.py Projet : awakmu/Sqlite-Diff

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