def delete_item(self): id = self.treeview.item(self.treeview.selection(), "text") session.delete(session.query(Checkout).filter_by(id=id).first()) session.commit() self.treeview.delete(*self.treeview.get_children()) self.loadTable()
async def delete(self, instance_id: str): post = session.query(Post).filter(Post.id == instance_id).first() if not post: raise HTTPNotFound(text="Post {} doesn't exist".format(id), content_type="application/text") session.delete(post) session.commit() return Response(status=204)
def checkout_items(self): print('hit') user_items = session.query(Checkout).filter( Checkout.user_id == self.CURRENT_USER.id) for item in user_items: new_booking = Booking(booked_date=item.booked_date, duration_of_booking=item.duration_of_booking, tool_id=item.tool_id, user_id=item.user_id, delivery=item.delivery) session.add(new_booking) session.delete(item) session.commit() self.treeview.delete(*self.treeview.get_children()) self.loadTable()
def delete_mooc(field_id, mooc_id): """Delete a MOOC""" field = session.query(Field).filter_by(id=field_id).first() mooc = session.query(MOOC).filter_by(id=mooc_id, field_id=field_id).first() # Verify if he is the user who created it if mooc.user_id == login_session['user_id']: if request.method == 'POST': session.delete(mooc) session.commit() flash('MOOC {} Successfully Deleted'.format(mooc.title)) return redirect(url_for('mooc.show_moocs', field_id=field_id)) return render_template('delete_mooc.html', mooc=mooc, field=field) else: return jsonify(error={'msg': "You are not the owner of that!!"}), 401
def delete_field(field_id): """Delete a CS field""" field = session.query(Field).filter_by(id=field_id).first() # Verify if he is the user who created it if field.user_id == login_session['user_id']: if request.method == 'POST': session.delete(field) flash('Field {} Successfully Deleted'.format(field.name)) session.commit() # Delete Field MOOCs too moocs = session.query(MOOC).filter_by(field_id=field.id).all() for mooc in moocs: session.delete(mooc) flash('MOOC {} Successfully Deleted'.format(mooc.title)) session.commit() return redirect(url_for('field.index')) return render_template('delete_field.html', field=field) else: return jsonify(error={'msg': "You are not the owner of that!!"}), 401
session.commit() print(user) # 更新数据 user.password = '******' session.add(user) session.commit() session.close() # 查询Users中username=wzy的全部记录,返回的是一个List对象 users_f = session.query(Users).filter_by(username='******').all() print((users_f)) # 删除数据 user = session.query(Users).get(2) print(user) session.delete(user) session.commit() session.close() users = session.query(Users).all() print(users)''' # 删除全部Posts posts = session.query(Posts).all() for post in posts: session.delete(post) session.commit() session.close()
def delete(self): session.delete(self) session.commit()
def delete_post(self, post): session.delete(post) session.commit()