def table_name_diff(cur1, cur2):
names1 = utils.table_names(cur1)
names2 = utils.table_names(cur2)
diff1 = names1 - names2
diff2 = names2 - names1
if len(diff1) == 0 and len(diff2) == 0:
return False
else:
return (list(diff1), list(diff2))
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)')]))
def shared_tables(cur1, cur2):
names1 = utils.table_names(cur1)
names2 = utils.table_names(cur2)
return set(names1).intersection(set(names2))
