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