def autocomplete_ingredients(food_item):
results = []
# search = request.args.get('term')
search = '%' + str(food_item) + '%'
# print search
query = """SELECT Food_Item.item_id FROM Food_Item WHERE Food_Item.name LIKE %s"""
result = functions.get_result(query, [search])
if result is None:
return []
all_ingr = []
for i in range(len(result)):
ingr_list = functions.get_item_ingredients(result[i]["item_id"])
for ingredient in ingr_list:
all_ingr.append(ingredient["name"])
all_ingr_names = list(set(all_ingr))
return json.dumps(all_ingr_names)
def get_item(item_id):
if not session.get(user_id):
flash(functions.get_flash_message("not_logged_in"))
return redirect(url_for('login'))
item = functions.get_food_item(item_id)
if not item:
flash(functions.get_flash_message("no_food_item"))
return redirect(url_for('index'))
ingredients = functions.get_item_ingredients(item_id)
badges = functions.get_item_badges(item_id)
return render_template('fooditem.html', item=item, ingredients=ingredients, badges=badges)