def convert_to_food_items_list(self, fetched): foods_list = [] for info_tuple in fetched: food = FoodItem() food.set_info_from_tuple(info_tuple) foods_list.append(food) return foods_list
def get_foods_by_name(self, name): self.c.execute("SELECT * FROM fooditems WHERE name=?", (name,)) food_info_tuple = self.c.fetchone() food = FoodItem() if food_info_tuple is None: return None food.set_info_from_tuple(food_info_tuple) return food
def calc_macros(): food_dao = DAO() name = input("Enter name of food: ") if name == 'x': return None food_by_name = food_dao.get_foods_by_name(name) if food_by_name is None: print("No foods found") return None else: size = input("Enter amount: ") if size == 'x': return None ratio = float(size) / food_by_name.ss() print(f"ratio: {ratio}") # testing altered_food = FoodItem() altered_food.set_info_from_tuple(food_by_name.get_tuple()) altered_food.proportionalize(ratio) return altered_food