Python format_table_header_diff Examples

Example #1

File: test_format.py Project: awakmu/Sqlite-Diff

    def test_different_table_def(self):
        self.__create_stocks_bonds()
        self.db1.cursor().execute("create table futures (date text, trans text, symbol text, qty real, price real);")
        self.db2.cursor().execute("create table futures (date text, symbol text, qty real, price real);")
        self.assertEqual(fmt.format_table_header_diff(self.db1, self.db2),
                         u"""Table(futures),4
> CREATE TABLE futures (date text, symbol text, qty real, price real)
> 0 rows
---
< CREATE TABLE futures (date text, trans text, symbol text, qty real, price real)
< 0 rows
"""
                         )
        self.db2.cursor().execute("create table options (date text, symbol text, qty real, price real);")
        self.assertEqual(fmt.format_table_header_diff(self.db1, self.db2),
                         u"""Table(options),5
> CREATE TABLE options (date text, symbol text, qty real, price real)
> 0 rows
Table(futures),4
> CREATE TABLE futures (date text, symbol text, qty real, price real)
> 0 rows
---
< CREATE TABLE futures (date text, trans text, symbol text, qty real, price real)
< 0 rows
"""
                         )

Example #2

File: test_format.py Project: awakmu/Sqlite-Diff

    def test_add_row_format(self):
        self.__create_stocks_bonds()
        self.assertEqual(fmt.format_table_header_diff(self.db1, self.db2), '')
        self.db2.cursor().execute("create table futures (date text, trans text, symbol text, qty real, price real);")
        self.db2.commit()
        self.assertEqual(fmt.format_table_header_diff(self.db1, self.db2),
                         u"""Table(futures),4
> CREATE TABLE futures (date text, trans text, symbol text, qty real, price real)
> 0 rows
"""
                         )

Example #3

File: test_format.py Project: awakmu/Sqlite-Diff

    def test_format_index(self):
        self.__create_stocks_bonds()
        self.db1.cursor().execute("CREATE INDEX idx_stock_symbol ON stocks (symbol);")
        self.assertEqual(fmt.format_table_header_diff(self.db1, self.db2),
u"""Table(stocks),4
< CREATE INDEX idx_stock_symbol ON stocks (symbol)
"""
                         )
        self.db2.cursor().execute("CREATE INDEX idx_stock_symbol ON stocks (date);")
        self.assertEqual(fmt.format_table_header_diff(self.db1, self.db2),
u"""Table(stocks),4
> CREATE INDEX idx_stock_symbol ON stocks (date)
---
< CREATE INDEX idx_stock_symbol ON stocks (symbol)
"""
                         )

Example #4

File: test_format.py Project: awakmu/Sqlite-Diff

 def test_null_results(self):
     self.__create_stocks_bonds()
     self.assertEqual(fmt.format_table_header_diff(self.db1, self.db2), '')