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