def testDataTableList(self):
return
dba = DBAccess(db_path=th.TEST_DB_PATH)
ft = FileTable(th.FILE_PATH, db=th.TEST_DB_PATH)
sql_str = "DELETE FROM %s WHERE table_name='%s'" % (settings.UPLOAD_FILE_TABLE, ft._table_name)
try:
dba.ExecuteQuery(sql_str, commit=True)
except:
pass
old_table_set = set(FileTable.DataTableList(db=th.TEST_DB_PATH))
ft.CreateAndPopulateTable()
new_table_set = set(FileTable.DataTableList(db=th.TEST_DB_PATH))
new_row_set = set([ft._table_name])
self.assertTrue(new_table_set.issuperset(new_row_set))
self.assertFalse(old_table_set.issuperset(new_row_set))
ft._ExecuteSQL("", CloseDB=True)
def testDataTableList(self):
return
dba = DBAccess(db_path=th.TEST_DB_PATH)
ft = FileTable(th.FILE_PATH, db=th.TEST_DB_PATH)
sql_str = "DELETE FROM %s WHERE table_name='%s'" % (
settings.UPLOAD_FILE_TABLE, ft._table_name)
try:
dba.ExecuteQuery(sql_str, commit=True)
except:
pass
old_table_set = set(FileTable.DataTableList(db=th.TEST_DB_PATH))
ft.CreateAndPopulateTable()
new_table_set = set(FileTable.DataTableList(db=th.TEST_DB_PATH))
new_row_set = set([ft._table_name])
self.assertTrue(new_table_set.issuperset(new_row_set))
self.assertFalse(old_table_set.issuperset(new_row_set))
ft._ExecuteSQL('', CloseDB=True)
