def delete_menu_item():
record_id = request.form['itemid']
try:
obj = Food.query.filter(Food.id == record_id)
for item in obj:
Food.delete(item)
except SQLAlchemyError as exc:
error = str(exc.__dict__['orig'])
return jsonify({"error": "Oops! %s" % error})
else:
return jsonify({"name": "Successfully deleted record"})
def delete_all_menu_items():
try:
obj = Food.query.all()
for item in obj:
Food.delete(item)
except SQLAlchemyError as exc:
error = str(exc.__dict__['orig'])
return jsonify({"error": "Oops! %s" % error})
else:
return jsonify({
"name":
"All items successfully deleted - Reloading in 5 seconds"
})
def delete_food(food_id):
'''
Deletes a row from the database and redirects to add page
Arguments:
food_id -- int: id of the row in de database
'''
result = Food.delete().where(Food.id == food_id).execute()
if result == 1:
flash("Food item is deleted", "succes")
elif result > 1:
flash("Something strange happend, multiple items where deleted",
"warning")
elif result < 1:
flash("No item found", "error")
return redirect(url_for("main.add"))
