def delete_item(item_id):
if request.method == 'POST':
try:
database = Modify()
items = database.DBSelectAllItems()
item = ""
for i in items:
if i.id == item_id:
item = i
break
print('this is the item : {}'.format(item))
result = database.DBDeleteItem(item.name)
print(result)
return redirect(url_for('home'))
except Exception as e:
print('failed')
print(e)
return redirect(url_for('home'))
else:
print('get mothod')
database = Modify()
items = database.DBSelectAllItems(2)
item = ""
for i in items:
if i.id == item_id:
item = i
print(item.name)
restaurant = database.DBSelectRestById(item.restaurant_id)
return render_template('delete_template.html',
item=item,
Restaurant=restaurant)
def home():
database = Modify()
restaurants = database.DBSelectAllRests()
for restaurant in restaurants:
items = database.DBSelectAllItems(restaurant.id)
restaurant_and_items[restaurant.name] = items
return render_template('menu.html',
Restaurant=restaurants[0],
Items=restaurant_and_items[restaurants[1].name])
def edit_item(item_id):
if request.method == 'POST':
database = Modify()
items = database.DBSelectAllItems()
item = ''
for i in items:
if i.id == item_id:
item = i
database.DBEditItem(item.name, request.form['newname'])
return redirect(url_for('home'))
else:
database = Modify()
items = database.DBSelectAllItems(2)
item = ""
for i in items:
if i.id == item_id:
item = i
return render_template('edit_template.html', item=item)