def importIngredients(filename):
"""Importer les ingredients depuis un fichier csv. Opération destructrice."""
cursor.execute("DELETE FROM Ingredients")
connection.commit()
cursor.execute("INSERT INTO Ingredients VALUES (NULL, ?, ?, ?)", Csv.loadall("csv/ingredients.csv"))
connection.commit()
def saturation(this):
sat = 0
saturations = Csv.loadall("csv/saturation.csv")
for items in saturations:
if int(items["saturation"]) == 1:
sat += int(this.acideGras[items["acidegras"]])
return sat
def importSaturation(filename):
"""Importer la saturation depuis un fichier csv."""
cursor.execute("DELETE FROM Saturation")
connection.commit()
for d in Csv.loadall(filename):
cursor.execute("INSERT INTO Saturation VALUES (?, ?)", (d["acidegras"], d["saturation"]))
connection.commit()
