def show(list_id, item_id):
"""Get single item via id."""
list = db_session.query(List).filter(List.id == list_id).first()
data = db_session.query(Item).filter(Item.id == item_id).first()
if '/json' in request.path:
return jsonify(data.as_dict())
else:
return render_template('item/show.html', item=data, list=list)
def destory(list_id, item_id):
"""Delete item."""
list = db_session.query(List).filter(List.id == list_id).first()
if (list.user_id != login_session['user_id']):
flash("This list does not belong to your account")
return redirect(url_for('list.show', list_id=list_id))
item = db_session.query(Item).filter(Item.id == item_id).first()
db_session.delete(item)
db_session.commit()
flash("Item %s destroyed" % item.name)
return redirect(url_for('list.show', list_id=list_id))
def index(list_id):
"""Get all lists."""
data = db_session.query(Item).filter(Item.list_id == list_id).all()
items = []
for item in data:
items.append(item.as_dict())
return jsonify(items)
def getUserByMail(email):
"""Get User by mailt."""
try:
user = db_session.query(User).filter_by(email=email).one()
return user
except Exception:
return None
def show(list_id):
"""Get single list via id."""
data = db_session.query(List).filter(List.id == list_id).first()
if '/json' in request.path:
return jsonify(data.as_dict())
else:
return render_template('list/show.html', list=data)
def destory(list_id):
"""Delete list."""
list = db_session.query(List).filter(List.id == list_id).first()
if (list.user_id != login_session['user_id']):
flash("This list does not belong to your account")
return redirect(url_for('list.index'))
db_session.delete(list)
db_session.commit()
flash("List %s destroyed" % list.name)
return redirect(url_for('list.index'))
def update(list_id, item_id):
"""Update item."""
list = db_session.query(List).filter(List.id == list_id).first()
if (list.user_id != login_session['user_id']):
flash("This list does not belong to your account")
return redirect(url_for('list.show', list_id=list_id))
item = db_session.query(Item).filter(Item.id == item_id).first()
name = request.form.get("name")
if not name:
flash("Please provide a name")
return redirect(url_for('item.show', list_id=list_id, item_id=item.id))
description = request.form.get("description")
if not description:
flash("Please provide a description")
return redirect(url_for('item.show', list_id=list_id, item_id=item.id))
item.name = name
item.description = description
item.list_id = list_id
db_session.add(item)
db_session.commit()
flash("Item %s was updated" % item.name)
return redirect(url_for('item.show', list_id=list_id, item_id=item.id))
def update(list_id):
"""Update list."""
list = db_session.query(List).filter(List.id == list_id).first()
if (list.user_id != login_session['user_id']):
flash("This list does not belong to your account")
return redirect(url_for('list.show', list_id=list_id))
name = request.form.get("name")
if not name:
flash("Please provide a name")
return redirect(url_for('list.show', list_id=list_id))
list.name = name
db_session.add(list)
db_session.commit()
flash("List %s was updated" % list.name)
return redirect(url_for('list.show', list_id=list_id))
def create(list_id):
"""Store new item."""
list = db_session.query(List).filter(List.id == list_id).first()
if (list.user_id != login_session['user_id']):
flash("This list does not belong to your account")
return redirect(url_for('list.show', list_id=list_id))
name = request.form.get("name")
if not name:
flash("Please provide a name")
return redirect(url_for('list.show', list_id=list_id))
description = request.form.get("description")
if not description:
flash("Please provide a description")
return redirect(url_for('list.show', list_id=list_id))
item = Item(name=name, description=description, list_id=list_id)
db_session.add(item)
db_session.commit()
flash("New item %s created" % name)
return redirect(url_for('list.show', list_id=list_id))