dao

from fooditem import FoodItem

import sqlite3

class DAO():
    def __init__(self):
        self.conn = sqlite3.connect('fooditem.db')
        self.c = self.conn.cursor()

    def update_info(self, updated_food):
        with self.conn:
            self.c.execute("UPDATE fooditems SET name=:name, ss=:ss, unit=:unit, cal=:cal, carb=:carb, fat=:fat, "
                        "protein=:protein, fiber=:fiber, sugar=:sugar WHERE name=:name", (updated_food.get_dict()))