def table_column_diff(cur1, cur2):
names = shared_tables(cur1, cur2)
diffs = []
for n in names:
col1 = utils.sqlite_master_table_def(cur1, n)
col2 = utils.sqlite_master_table_def(cur2, n)
if col1 != col2:
diffs.append( (col1, col2) )
if len(diffs) > 0:
return diffs
else:
return False
def test_sqlite_master_table_def(self):
self.assertEquals(utils.table_names(self.db.cursor()),
set([u'bonds', u'stocks']))
self.assertEquals(utils.sqlite_master_table_def(self.db.cursor(), "stocks"),
(u'table', u'stocks', u'stocks', 2, u'CREATE TABLE stocks (date text, trans text, symbol text, qty real, price real)'))
self.assertEquals(utils.table_definition(self.db.cursor(), "stocks"),
((u'table', u'stocks', u'stocks', 2, u'CREATE TABLE stocks (date text, trans text, symbol text, qty real, price real)'), [(u'index', u'idx_stock_symbol', u'stocks', 4, u'CREATE INDEX idx_stock_symbol ON stocks (symbol)')]))