def deleteItem(item_name, category_name):
'''
Deletes item, only allows creator to delete
'''
# check if user is logged in
if not 'user_id' in login_session:
flash("You need to be logged-in to perform this action", 'error')
return redirect('/')
item = session.query(Item).filter_by(name=item_name).one()
# check if user has permission
if login_session['user_id'] != item.user_id:
flash("You do not have permissions to edit this item", 'error')
return redirect('/')
if request.method == 'POST':
session.delete(item)
session.commit()
category = session.query(Category).filter_by(
name=category_name).first()
itemsLeft = session.query(Item).filter_by(category=category).first()
# if there are no more items in category delete it.
if itemsLeft == None:
session.delete(category)
session.commit()
flash("menu item deleted!", 'success')
return redirect('/')
else:
return render_template('deleteitem.html', item=item)
def deleteItem(item_name, category_name):
'''
Deletes item, only allows creator to delete
'''
# check if user is logged in
if not 'user_id' in login_session:
flash("You need to be logged-in to perform this action", 'error')
return redirect('/')
item = session.query(Item).filter_by(name=item_name).one()
# check if user has permission
if login_session['user_id'] != item.user_id:
flash("You do not have permissions to edit this item", 'error')
return redirect('/')
if request.method == 'POST':
session.delete(item)
session.commit()
category = session.query(Category).filter_by(
name=category_name).first()
itemsLeft = session.query(Item).filter_by(category=category).first()
# if there are no more items in category delete it.
if itemsLeft == None:
session.delete(category)
session.commit()
flash("menu item deleted!", 'success')
return redirect('/')
else:
return render_template(
'deleteitem.html', item=item)
def delete(self):
try:
session.delete(self)
session.commit()
except Exception:
session.rollback()
raise
def delPut(id):
homes = session.query(Homes).filter_by(id=id).first()
session.delete(homes)
try:
session.commit()
return jsonify({'status': 'APAGADO'})
except:
return jsonify({'status': 'FALHA'})
def delete(id, commit=True):
plane = session.query(Plane).get(id)
if not plane:
raise Exception(f'No plane with id={id} found!')
for tile in plane.tiles:
session.delete(tile)
session.delete(plane)
if commit:
session.commit()
def delete(self, snack_id):
"""
Delete the selected snack.
"""
snack = SnackMenu.query.get(snack_id)
session.delete(snack)
session.commit()
result = snack_schema.dump(snack)
return jsonify(result)
def deletar_item_pedido(id, id_cod_pt, id_cod_pd, id_pp):
# del_pedido = session.get(tbl_pedido, id_pp)
# session.delete(del_pedido)
del_item = session.query(tbl_item).get((id, id_cod_pt, id_cod_pd))
session.delete(del_item)
session.commit()
session.close()
return redirect(url_for('admin_pedido'))
def clear_statistics():
statistics = session.query(Statistics).all()
if statistics:
for i in statistics:
session.delete(i)
session.commit()
return f'Statistics clear', 200
else:
raise BaseClearException
def delete(self, employee_id):
"""
Delete the selected employee.
"""
employee = Employees.query.get(employee_id)
session.delete(employee)
session.commit()
result = employee_schema.dump(employee)
return jsonify(result)
def delete_task(task_id):
try:
task_id = int(task_id)
except Exception:
return redirect(url_for('index'))
task = session.query(models.Task).filter_by(id=task_id).first()
session.delete(task)
session.commit()
return redirect(url_for('index'))
def delete_person(person_id):
try:
person_id = int(person_id)
except Exception:
return redirect(url_for('index'))
person = session.query(models.Person).filter_by(id=person_id).first()
session.delete(person)
session.commit()
return redirect(url_for('add_acc'))
def delete_book(book_id):
book_to_delete = session.query(Book).filter_by(id=book_id).one()
if request.method == 'POST':
session.delete(book_to_delete)
session.commit()
logger.info(
f"Deleted book: {book_to_delete.title} by {book_to_delete.author}")
return redirect(url_for('showBooks', book_id=book_id))
else:
return make_response(jsonify("error"))
def delete_item(category_name, item_style):
category = session.query(Category).filter_by(
name=category_name).one_or_none()
item = session.query(Item).filter_by(style=item_style).one_or_none()
if request.method == 'POST':
session.delete(item)
session.commit()
return redirect('/catalog')
else:
return render_template('delete_item.html',
category=category,
item=item)
def deleteCategory(categoryID):
category = session.query(Category).filter_by(id=categoryID).one_or_none()
if request.method == 'GET':
# return confirm delete form
return render_template('item_catalog/categoryDelete.html',
category=category)
elif request.method == 'POST':
# delete category from databaes
session.delete(category)
session.commit()
return redirect(url_for('item_catalog.viewCategories'))
def deleteItem(itemID):
item = session.query(Item).filter_by(id=itemID).one_or_none()
if request.method == 'GET':
# return confirm deletion page
return render_template('item_catalog/itemDelete.html', item=item)
elif request.method == 'POST':
category_id = item.category_id
# remove item from database
session.delete(item)
session.commit()
return redirect(
url_for('item_catalog.viewItem', categoryID=category_id))
def on_delete(self, req, resp):
body = req.stream.read()
body = json.loads(body)
stid = req.get_param("student_id")
tid = req.get_param("teacher_id")
date = req.get_param("date")
date = datetime.datetime.strptime(date, "%Y-%m-%d").date()
schedule = sess.query(ms.Schedule).get(stid, tid, date)
if schedule is None:
resp.status = falcon.HTTP_400
resp.body = "Student Not Found"
sess.delete(schedule)
sess.commit()
resp.body = "Schedule Successfully Removed"
def deleteItem(item_name):
if 'username' not in login_session:
return redirect(url_for('auth.showLogin'))
itemToDelete = session.query(Item).filter_by(name=item_name).one()
if itemToDelete.user_id != login_session['user_id']:
return "<script>function myFunction() {alert('You are not authorized to delete this item. Please create your own item in order to delete.');}</script><body onload='myFunction()''>"
if request.method == 'POST':
session.delete(itemToDelete)
session.commit()
flash('Item Successfully Deleted')
return redirect(url_for('catalog.showCatalog'))
else:
return render_template('items/deleteitem.html', item=itemToDelete)
def deleteCategory(category_name):
if 'username' not in login_session:
return redirect(url_for('auth.showLogin'))
categoryToDelete = session.query(Category).filter_by(name=category_name).one()
print categoryToDelete.user_id
if categoryToDelete.user_id != login_session['user_id']:
return "<script>function myFunction() {alert('You are not authorized to delete this category. Please create your own category in order to delete.');}</script><body onload='myFunction()''>"
if request.method == 'POST':
session.delete(categoryToDelete)
flash('%s Successfully Deleted' % categoryToDelete.name)
session.commit()
return redirect(url_for('catalog.showCatalog'))
else:
return render_template('catalog/deletecategory.html', item=categoryToDelete)
def on_post(self, req, resp):
today = datetime.date.today()
absent = req.get_param_as_list("absent")
# req.log_error(" ".join(absent))
present = req.get_param_as_list("present")
# req.log_error(" ".join(present))
for stid in absent:
if sess.query(ms.Absence).get((stid, today)) is None:
sess.add(ms.Absence(stid, today))
for stid in present:
temp = sess.query(ms.Absence).get((stid, today))
if temp is not None:
sess.delete(temp)
sess.commit()
resp.status = falcon.HTTP_200
resp.body = "Attendance Successfully Taken"
def delete_ticket(**kwargs):
user_id = get_jwt_identity()
try:
role = check_access()
ticket = session.query(Ticket).get(kwargs.get('ticket_id'))
if ((not ticket.is_booked) & ( role == "manager")) |\
(ticket.is_booked & ((ticket.user_id == user_id) | (role == "manager"))):
session.delete(ticket)
session.commit()
else:
return{'msg': "not allowed to delete the ticket" }, 401
except Exception as e:
session.rollback()
logger.warning(
f'user: {user_id} - failed to delete ticket: {e}')
return {'message': str(e)}, 400
logger.info(f'user {user_id} deleted ticket')
return {"msg": "Successfully deleted ticket"}, 200
def run(self):
while self.stopped() is False:
logger.info(f'thread {threading.get_ident()} begins the proccess')
session_lock.acquire()
now = datetime.now()
tickets_to_delete = session.query(Ticket).filter(
Ticket.book_end_date < now).all()
if len(tickets_to_delete) != 0:
print(
str(len(tickets_to_delete)) +
f" outdated bookings found by thread {threading.get_ident()}, commence deletion"
)
for ticket in tickets_to_delete:
session.delete(ticket)
session.commit()
session_lock.release()
logger.info(f'thread {threading.get_ident()} enters sleep')
self._stop_event.wait(60)
logger.info('dataclean thread has stopped')
def deleteSku(price_list_id, sku_id):
if 'username' not in login_session:
return redirect('/oauth/login')
else:
pass
sku = session.query(Sku).filter_by(id=sku_id).one()
if request.method == 'POST':
session.delete(sku)
session.commit()
flash("item eliminado!")
return redirect(url_for('pxlst.readSkus', price_list_id=price_list_id))
#protection from non creator
if login_session['username'] != sku.user.name:
flash("Debes ser el creador de la lista para borrar este Sku.")
return redirect(url_for('pxlst.readSkus', price_list_id=price_list_id))
else:
return render_template('pxlst/deleteSku.html', price_list_id=price_list_id, sku_id=sku_id, sku=sku)
def deleteItem(id):
'''Deletes a specific item from database. Only logged in users can delete their own items'''
item = session.query(SportsItem).filter_by(id=id).one()
if (item.userId != login_session["user_id"]):
flash('Only Item Creators can edit or delete their items')
print url_for('item.ShowItem', id=id)
return redirect(url_for('item.ShowItem', id=id))
if (request.method == 'GET'):
csrftoken = generateToken()
return render_template('deleteitem.html',
CSRFTOKEN=csrftoken,
ITEMNAME=item.name)
if (request.method == 'POST'):
if ('csrftoken' not in login_session
or request.form['csrftoken'] != login_session['csrftoken']):
abort(400)
session.delete(item)
session.commit()
del login_session['csrftoken']
return redirect('/')
def deletePriceList(price_list_id):
if 'username' not in login_session:
return redirect('/oauth/login')
else:
pass
item = session.query(PriceList).filter_by(id=price_list_id).one()
if request.method == 'POST':
session.delete(item)
session.commit()
flash("item deleted!")
return redirect(url_for('pxlst.readPricelists'))
#protection from non creator
if login_session['username'] != item.user.name:
flash("Debes ser el creador de la lista para borrarla.")
return redirect(url_for('pxlst.readPricelists'))
else:
return render_template('pxlst/deletePricelist.html', price_list_id=price_list_id, price_list=item)
def delete_food(id):
association = session.query(Association).get(id)
session.delete(association)
return redirect(url_for('food_log_get'))
def remove(self, obj):
""" Remove an object from the database """
session.delete(obj)
session.commit()
def remHome(self, Homes):
session.delete(Homes)
session.commit()
session.close()
def deletar_pessoajuridica(id):
id_log = session.get(tbl_cliente, id)
session.delete(id_log)
session.commit()
session.close()
return redirect(url_for('adminpj'))
def delete_food(id):
association = session.query(FoodLogFoodAssociation).get(id)
session.delete(association)
session.commit()
return redirect(url_for('food_log_get'))
def deletar_produto(id):
id_produto = session.get(tbl_produto, id)
session.delete(id_produto)
session.commit()
session.close()
return redirect(url_for('admin_produto'))
def deletar_pedido(id):
del_pedido = session.get(tbl_pedido, id)
session.delete(del_pedido)
session.commit()
session.close()
return redirect(url_for('admin_pedido'))
def del_ad(id):
ad = session.query(Ads).filter_by(id=id).one()
session.delete(ad)
session.flush()
return f'ok', 200
def delete_food(id):
association = session.query(FoodLogFoodAssociation).get(id)
session.delete(association)
session.commit()
return redirect(url_for('food_log_get'))
