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_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_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
