def createUser(login_session):
newUser = User(name=login_session['username'],
email=login_session['email'],
picture=login_session['picture'])
session.add(newUser)
session.commit()
user = session.query(User).filter_by(email=login_session['email']).first()
return user.id
def deleteItemFromCategory(category, item):
# Do not show the page for deleting an item if the user is not logged in.
pass
category = session.query(Category).filter_by(name=category).first()
if category is None:
return categoryAlert()
item = (
session.query(Item)
.filter_by(
name=item,
category_id=category.id
)
.first()
)
if item is None:
return itemAlert()
else:
# User can only delete items they have created.
if item.user_id != login_session['user_id']:
return modificationAlert()
# Server received a POST request.
if request.method == 'POST':
session.delete(item)
session.commit()
flash("%s was deleted!" % item.name.title())
return (
redirect(
url_for(
'showCatalogForCategory',
category=category.name
)
)
)
# Server received a GET request.
else:
return render_template(
'deleteItem.html',
category=category,
item=item
)
def editItemInCategory(category, item):
# Do not show the page for editing an item if the user is not logged in.
pass
category = session.query(Category).filter_by(name=category).first()
if category is None:
return categoryAlert()
item = (
session.query(Item)
.filter_by(
name=item,
category_id=category.id
)
.first()
)
# Check if item exists if user manually enters a url.
if item is None:
return itemAlert()
else:
# User can only edit items they have created.
if item.user_id != login_session['user_id']:
return modificationAlert()
# Server received POST request.
if request.method == 'POST':
newItemName = request.form['name'].strip()
newItemDescription = request.form['description'].strip()
if not newItemName or not newItemDescription:
return blankFieldsAlert()
# Check for a duplicate with a different item.id
itemDuplicate = (
session.query(Item)
.filter_by(
name=newItemName.lower(),
category_id=category.id
)
.first()
)
# The item being edited can have the same name as the new name,
# but not another item with a different id.
# This would create two items with the same name.
if itemDuplicate is not None and itemDuplicate.id != item.id:
return duplicateNameAlert()
# Save the new file upload.
filename = None
file = request.files['file']
if file and allowed_file(file.filename):
filename = secure_filename(file.filename)
file.save(os.path.join(app.config['UPLOAD_FOLDER'], filename))
# Or grab the url for the image.
if filename is None:
filename = request.form['image']
oldItemName = item.name
newItemName = request.form['name']
item.name = newItemName
item.description = request.form['description']
item.image = filename
session.add(item)
session.commit()
flash("%s was edited!" % oldItemName.title())
return (
redirect(
url_for(
'showCatalogForCategory',
category=category.name
)
)
)
# Server received GET request.
else:
categories = session.query(Category).all()
return render_template(
'editItem.html',
categories=categories,
category=category,
item=item
)
def createNewItem(category):
# Do not show the page for creating an item if the user is not logged in.
pass
categories = session.query(Category).all()
category = session.query(Category).filter_by(name=category).first()
# Check if the category exists if user manually enters a url.
if category is None:
return categoryAlert()
else:
# Server received POST request.
if request.method == 'POST':
newItemName = request.form['name'].strip()
newItemDescription = request.form['description'].strip()
# Check if name or description field is blank.
if not newItemName or not newItemDescription:
return blankFieldsAlert()
# Check if an item in the category exists with that name.
item = (
session.query(Item)
.filter_by(
name=newItemName.lower(),
category_id=category.id
)
.first()
)
# Prevent duplicate entries.
if item is not None:
return duplicateNameAlert()
# Save the new file upload.
filename = None
file = request.files['file']
if file and allowed_file(file.filename):
filename = secure_filename(file.filename)
file.save(os.path.join(app.config['UPLOAD_FOLDER'], filename))
# Or grab the url for the image.
if filename is None:
filename = request.form['image']
item = Item(name=newItemName,
description=newItemDescription,
category_id=category.id,
categoryName=category.name,
user_id=login_session['user_id'],
image=filename)
session.add(item)
session.commit()
flash("%s was created!" % newItemName.title())
return (
redirect(
url_for(
'showCatalogForCategory',
category=category.name
)
)
)
else:
items = session.query(Item).all()
return render_template(
'createNewItem.html',
items=items,
login_session=login_session,
categories=categories,
category=category
)