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