def db_add_consumption_history(user_id, food_id, rate=0): try: food = db_retrieve_food(food_id) user = db_retrieve_user(user_id) new_history = ConsumptionHistory(user=user, food=food, food_rate=rate) new_history.save() return True except: return False
def db_insert_consumption_record(user_id, food_id): try: user = db_retrieve_user(user_id) food = db_retrieve_food(food_id) record = ConsumptionHistory(food=food, user=user) record.save() return record except: return False
def db_search_consumption_foods(start_timestamp_date, end_timestamp_date, user_id): try: user = db_retrieve_user(user_id) records = list(ConsumptionHistory.objects.filter(date__range=(start_timestamp_date,end_timestamp_date), user=user)) history = [] for record in records: history.append(record.food) return history except: return False
def db_insert_consumption_record(user_id,food_id): try: user = db_retrieve_user(user_id) food = db_retrieve_food(food_id) record = ConsumptionHistory( food=food, user=user ) record.save() return record except: return False
def db_get_user_foods(user_id): try: user = db_retrieve_user(user_id) foods = list(FoodModel.objects.filter(food_owner=user)) food_list = [] for food in foods: food_dict = dict(food_name=food.food_name, food_id=food.food_id, food_image=food.food_image) food_list.append(food_dict) return food_list except: return False
def db_search_consumption_foods(start_timestamp_date, end_timestamp_date, user_id): try: user = db_retrieve_user(user_id) records = list( ConsumptionHistory.objects.filter( date__range=(start_timestamp_date, end_timestamp_date), user=user)) history = [] for record in records: history.append(record.food) return history except: return False
def db_get_user_foods(user_id): try: user = db_retrieve_user(user_id) foods = list(FoodModel.objects.filter(food_owner=user)) food_list = [] for food in foods: food_dict=dict( food_name=food.food_name, food_id=food.food_id, food_image=food.food_image ) food_list.append(food_dict) return food_list except: return False
def db_insert_tag(tag_dict): generic_id = tag_dict['generic_id'] if tag_dict["type"] == "Food": generic_object = db_retrieve_food(generic_id) else: generic_object = db_retrieve_user(generic_id) new_tag = TagModel( tag_label=tag_dict['tag_name'], semantic_tag_item=tag_dict['tag_id'], semantic_tag_item_label=tag_dict['tag_label'], semantic_tag_item_description=tag_dict['tag_description'], tagged_object=generic_object) try: new_tag.save() return True except: return False
def db_insert_tag(tag_dict): generic_id = tag_dict['generic_id'] if tag_dict["type"] == "Food": generic_object = db_retrieve_food(generic_id) else: generic_object = db_retrieve_user(generic_id) new_tag = TagModel( tag_label=tag_dict['tag_name'], semantic_tag_item=tag_dict['tag_id'], semantic_tag_item_label=tag_dict['tag_label'], semantic_tag_item_description=tag_dict['tag_description'], tagged_object=generic_object ) try: new_tag.save() return True except: return False
def db_insert_food(food_dict, nutrition_dict, ingredient_list): food_owner_id = food_dict['food_owner'] food_owner = db_retrieve_user(food_owner_id) ingredient_object_list = [] print(ingredient_list) for ingredient in ingredient_list: ing_object = db_retrieve_ingredient(ingredient) if ing_object == False: print(ingredient, 'DOES NOT Exists') new_object = db_insert_ingredient(ingredient) if new_object is not False: ingredient_object_list.append(new_object) else: ingredient_object_list.append(ing_object) print(ingredient, 'Exists') print(ingredient_object_list) new_food = FoodModel( food_description=food_dict['food_description'], food_name=food_dict['food_name'], food_image=food_dict['food_image'], food_owner=food_owner, food_recipe=food_dict['food_recipe'], protein_value=nutrition_dict['protein_value'], fat_value=nutrition_dict['fat_value'], carbohydrate_value=nutrition_dict['carbohydrate_value'], fiber_value=nutrition_dict['fiber_value'], calorie_value=nutrition_dict['calorie_value'], sugar_value=nutrition_dict['sugar_value'], serving_weight_grams=nutrition_dict['serving_weight_grams'], vitamin_A=nutrition_dict['vitamin_A'], vitamin_C=nutrition_dict['vitamin_C'], vitamin_D=nutrition_dict['vitamin_D'], vitamin_E=nutrition_dict['vitamin_E'], vitamin_K=nutrition_dict['vitamin_K'], thiamin=nutrition_dict['thiamin'], riboflavin=nutrition_dict['riboflavin'], niacin=nutrition_dict['niacin'], vitamin_B6=nutrition_dict['vitamin_B6'], folatem=nutrition_dict['folatem'], vitamin_B12=nutrition_dict['vitamin_B12'], pantothenic_acid=nutrition_dict['pantothenic_acid'], choline=nutrition_dict['choline'], calcium=nutrition_dict['calcium'], copper=nutrition_dict['copper'], flouride=nutrition_dict['flouride'], iron_Fe=nutrition_dict['iron_Fe'], magnesium=nutrition_dict['magnesium'], manganese=nutrition_dict['manganese'], sodium_Na=nutrition_dict['sodium_Na'], phosphorus=nutrition_dict['phosphorus'], selenium=nutrition_dict['selenium'], zinc=nutrition_dict['zinc']) new_food.save() try: for ing in ingredient_object_list: new_food.ingredient_list.add(ing) print(ing, ' IS ADDED') return new_food.food_id except: print('cannot handle saving food') return False
def db_insert_food(food_dict, nutrition_dict, ingredient_list): food_owner_id = food_dict['food_owner'] food_owner = db_retrieve_user(food_owner_id) ingredient_object_list = [] print(ingredient_list) for ingredient in ingredient_list: ing_object = db_retrieve_ingredient(ingredient) if ing_object == False: print(ingredient, 'DOES NOT Exists') new_object = db_insert_ingredient(ingredient) if new_object is not False: ingredient_object_list.append(new_object) else: ingredient_object_list.append(ing_object) print(ingredient, 'Exists') print(ingredient_object_list) new_food = FoodModel( food_description=food_dict['food_description'], food_name=food_dict['food_name'], food_image=food_dict['food_image'], food_owner=food_owner, food_recipe=food_dict['food_recipe'], protein_value=nutrition_dict['protein_value'], fat_value=nutrition_dict['fat_value'], carbohydrate_value=nutrition_dict['carbohydrate_value'], fiber_value=nutrition_dict['fiber_value'], calorie_value=nutrition_dict['calorie_value'], sugar_value=nutrition_dict['sugar_value'], serving_weight_grams=nutrition_dict['serving_weight_grams'], vitamin_A=nutrition_dict['vitamin_A'], vitamin_C=nutrition_dict['vitamin_C'], vitamin_D=nutrition_dict['vitamin_D'], vitamin_E=nutrition_dict['vitamin_E'], vitamin_K=nutrition_dict['vitamin_K'], thiamin=nutrition_dict['thiamin'], riboflavin=nutrition_dict['riboflavin'], niacin=nutrition_dict['niacin'], vitamin_B6=nutrition_dict['vitamin_B6'], folatem=nutrition_dict['folatem'], vitamin_B12=nutrition_dict['vitamin_B12'], pantothenic_acid=nutrition_dict['pantothenic_acid'], choline=nutrition_dict['choline'], calcium=nutrition_dict['calcium'], copper=nutrition_dict['copper'], flouride=nutrition_dict['flouride'], iron_Fe=nutrition_dict['iron_Fe'], magnesium=nutrition_dict['magnesium'], manganese=nutrition_dict['manganese'], sodium_Na=nutrition_dict['sodium_Na'], phosphorus=nutrition_dict['phosphorus'], selenium=nutrition_dict['selenium'], zinc=nutrition_dict['zinc'] ) new_food.save() try: for ing in ingredient_object_list: new_food.ingredient_list.add(ing) print(ing, ' IS ADDED') return new_food.food_id except: print('cannot handle saving food') return False