def db_insert_user_wanted_ing(user_id,ing_name_list):
user = db_retrieve_user(user_id)
for ing_name in ing_name_list:
try:
ing = db_retrieve_ingredient(ing_name)
user.wanted_ingredients.add(ing)
if ing is False:
ing = db_insert_ingredient(ing_name)
user.wanted_ingredients.add(ing)
except:
try:
new_ing = db_insert_ingredient(ing_name)
user.wanted_ingredients.add(new_ing)
except:
pass
return True
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
