def save_and_check(self, dataIn, tableIn, dataOut, tableOut = None, twice = True):
if tableOut == None:
tableOut = quote(tableIn)
# Insert
sqlite.save([], dataIn, tableIn)
# Observe with pysqlite
connection=sqlite3.connect(self.DBNAME)
cursor=connection.cursor()
cursor.execute("SELECT * FROM %s" % tableOut)
observed1 = cursor.fetchall()
connection.close()
if twice:
# Observe with DumpTruck
observed2 = sqlite.select('* FROM %s' % tableOut)
#Check
expected1 = dataOut
expected2 = [dataIn] if type(dataIn) == dict else dataIn
self.assertListEqual(observed1, expected1)
self.assertListEqual(observed2, expected2)
def save(self):
"""Saves this passage list manager to its file."""
sqlite.save()
def save(self): """Saves this passage list manager to its file.""" sqlite.save()
def save_and_select(self, d):
sqlite.save([], {"foo": d})
observed = sqlite.select('* from swdata')[0]['foo']
self.assertEqual(d, observed)
rep += letter
return rep
if __name__ == '__main__':
data = db.load()
print("Chargement des données effectué")
saved = False
m = ""
while m != "Q":
m = i_menu()
if m == "A":
i_add()
elif m == "S":
db.save(data)
elif m == "R":
i_search()
elif m == "E":
i_delete()
elif m == "Q":
if not saved:
print("Sauvegarde...")
db.save(data)
saved = not saved
elif m == "C":
if not saved:
db.save(data)
data = db.load()
print("Chargement des données effectué")
