def delete(self):
account = g.account
session.delete(account)
session.commit()
return ('', 204)
def deleteTask(category_id, task_id):
"""Given a category id and task id, render a button that will allow the
given task to be deleted, and process the clicking of that button.
Args:
category_id: The id of the category to be displayed after task deletion.
task_id: The id of the task to be deleted
Returns:
Redirect for category that contained the deleted task on form submission,
otherwise renders the task deletion template for display.
"""
if 'username' not in user_session:
return redirect('/login')
task = session.query(Task).filter_by(id=task_id).one()
if task.user_id != user_session['user_id']:
return "<script>function showAuthAlert() {alert('You are not " \
+ "authorized to delete this task.');}" \
+ "</script><body onload='showAuthAlert()'>"
if request.method == 'POST':
session.delete(task)
try:
session.commit()
except:
session.rollback()
flash("Task: " + task.name + " was successfully deleted!")
return redirect(url_for('showCategory', category_id=category_id))
else:
return render_template('delete_task.html', task=task)
def deleteCategory(category_id):
"""Given a category id, display a button for deleting that category,
and handle the clicking of that button.
Args:
category_id: The id of the category to be deleted
Returns:
Redirect to main dashboard on successful form submission, which will show
the remaining categories. Otherwise, returns rendered delete
category template.
"""
if 'username' not in user_session:
return redirect('/login')
category = session.query(Category).filter_by(id=category_id).one()
if category.user_id != user_session['user_id']:
return "<script>function showAuthAlert() {alert('You are not " \
+ "authorized to delete this category.');}" \
+ "</script><body onload='showAuthAlert()'>"
if request.method == 'POST':
session.delete(category)
try:
session.commit()
except:
session.rollback()
flash("Category: " + category.name + " was successfully deleted!")
return redirect(url_for('showDashboard'))
else:
return render_template('delete_category.html', category=category)
def delete(self, keg_id):
keg = session.query(Keg).filter(Keg.id == keg_id).first()
if keg:
session.delete(keg)
session.commit()
return ('', 204)
else:
return ('Keg Not Found', 404)
def delete_category(category_name):
user_jwt = request.headers.get('Authorization')
# If user is not logged in or user is not in db return error response
if user_jwt == u"null" or not verify_jwt(user_jwt):
create_message_response('Unauthorized access', 400)
else:
del_cat = session.query(Category).filter_by(name=category_name).one()
session.delete(del_cat)
session.commit()
return create_message_response('Category successfully deleted!', 200)
def delete(self, beer_id):
beer = session.query(Beer).filter(Beer.id == beer_id).first()
if beer:
session.delete(beer)
session.commit()
return ('', 204)
else:
return ('Beer Not Found', 404)
def delete(self, account_id):
account = session.query(Account).filter(
Account.id == account_id).first()
if account:
session.delete(account)
session.commit()
return ('', 204)
else:
return ('Account Not Found', 404)
def delete_item(category_name, item_name):
item = session.query(Item).filter_by(name=item_name).one()
user_jwt = request.headers.get('Authorization')
# If user is not logged in or user is not in db return error response
if user_jwt == u"null" or not verify_jwt(user_jwt):
return create_message_response('Unauthorized access', 400)
else:
# Get username from jwt, and check if logged in user is same as item creator
user_info = jwt.decode(user_jwt, SECRET, algorithms=['HS256'])
if user_info['username'] == item.creator:
session.delete(item)
session.commit()
return create_message_response('Item successfully deleted', 200)
# If logged in user is not same as item creator
else:
return create_message_response('Unauthorized access', 400)
# -*- coding: utf-8 -*-
from models import User, Image
from session import session
# UserとImageを追加する。
testuser = User('test_cascade', '', '')
testimage = Image('image name', testuser)
session.add(testuser)
session.add(testimage)
session.commit()
# 追加されているか確認
user = session.query(User).filter(User.name=='test_cascade').first()
image = session.query(Image).filter(Image.filename=='image name').first()
print user.name
print image.filename
# Userを削除する。Imageは直接削除しない。
session.delete(user)
session.commit()
# UserもImageも削除されていることを確認
user = session.query(User).filter(User.name=='test_cascade').first()
image = session.query(Image).filter(Image.filename=='image name').first()
print user
print image
def delete():
users = session.query(GaoZhong).all()
for user in users:
session.delete(user)
session.commit()