def test_save_changes_to_csv(self): test_tile = self.csv_file + '_test.csv' copyfile(self.csv_file, test_tile) db = CSVDB(test_tile) db.print_sql("update personnes_csv_test set id = 0") db.print_sql("commit") time.sleep(0.5) db = CSVDB(test_tile) result = db.execute_sql("select distinct id from personnes_csv_test") self.assertEqual(result, [['id'], (0, )])
def test_execute_sql(self): db = CSVDB(self.root_dir) result = db.execute_sql("select 1") self.assertEqual(result, [['1'], (1, )])