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'))