def newItem():
# Check if the user is logged in
if 'username' not in login_session:
return redirect('/login')
# POST method
if request.method == 'POST':
newItem = CatItem(name=request.form['name'],
description=request.form['description'],
category_id=request.form['category'],
user_id=login_session['user_id'])
# Add the new item to database
session.add(newItem)
session.commit()
# Send a slush message
flash("New Game created!")
# Redirect to the main page
return redirect(url_for('showCategories'))
else:
# Get all categories
categories = session.query(Category).all()
# Return the page to create new item
return render_template('newmenuitem.html', categories=categories)
def add_item_by_category(category_id):
if 'username' not in login_session:
flash("You were not authorised to access that page.")
return redirect(url_for('login'))
elif request.method == 'POST':
# Check if the item already exists in the database.
# If it does, display an error.
item = session.query(CatItem).filter_by(
name=request.form['name']).first()
if item:
if item.name == request.form['name']:
flash('The item already exists')
return redirect(url_for("add_item"))
new_item = CatItem(name=request.form['name'],
category_id=category_id,
description=request.form['description'],
user_id=login_session['user_id'])
session.add(new_item)
session.commit()
flash('New item created!')
return redirect(
url_for('show_items_in_category', category_id=category_id))
else:
category = session.query(Category).filter_by(id=category_id).first()
return render_template('neweritem.html', category=category)
def createItem(cat_name, cat_id):
if 'username' not in login_session:
return redirect('/login')
DBSession = sessionmaker(bind=engine)
session = DBSession()
username = login_session['username']
pic = login_session['picture']
if request.method == 'POST':
Items = session.query(Category).filter_by(name=cat_name)
newItem = CatItem(name=request.form['name'],
description=request.form['Description'],
cat_id=cat_id,
user_id=login_session['user_id'])
session.add(newItem)
session.commit()
flash('Item Successfully Created')
return redirect(
url_for('showItems',
cat_name=cat_name,
username=username,
pic=pic,
cat_id=cat_id))
else:
return render_template('createItem.html',
cat_name=cat_name,
cat_id=cat_id)
flash('Item Successfully Created')
def newCatItem(category_id):
if 'username' not in login_session:
return redirect('/login')
category = session.query(Category).filter_by(id=category_id).one()
if login_session['user_id'] != category.user_id:
return "<script>function myFunction() {alert('You are not authorized to add menu items to this category. Please create your own category in order to add items.');}</script><body onload='myFunction()'>"
if request.method == 'POST':
newItem = CatItem(name=request.form['name'],
description=request.form['description'],
price=request.form['price'],
category_id=category_id,
user_id=category.user_id)
session.add(newItem)
session.commit()
flash('New Category %s Item Successfully Created' % (newItem.name))
return redirect(url_for('showCatItems', category_id=category_id))
else:
return render_template('newmenuitem.html', category_id=category_id)
def newCatItem():
if 'username' not in login_session:
return redirect('/login')
if request.method == 'POST':
category = session.query(Category).filter_by(
name=request.form['category']).one()
newItem = CatItem(name=request.form['name'],
description=request.form['description'],
cat_id=category.id,
user_id=login_session['user_id'])
session.add(newItem)
session.commit()
flash('New %s Item Successfully Created for %s' %
(newItem.name, category.name))
return redirect(url_for('showCategories'))
else:
categories = getCategories()
return render_template('newcatitem.html', categories=categories)
def addItem(category_id):
if 'username' not in login_session:
#flash("Please login to utlize this application!")
#return render_template('pubcatalog.html')
return redirect(url_for('showLogin'))
else:
category = session.query(Category).filter_by(id=category_id).one()
if request.method == 'POST':
if request.form['name']:
if request.form['descr']:
description = request.form['descr']
else:
description = 'void'
catItem = CatItem(user_id=login_session['user_id'], name=request.form['name'], description=description, category=category)
session.add(catItem)
session.commit()
flash('New Item %s Successfully Added. Item Description = %s' % (request.form['name'], description))
else:
flash('ERROR: Item name cannot be empty for successful add.')
return redirect(url_for('showCategory', category_id=category_id))
else:
return render_template('additem.html', category=category)
'https://pbs.twimg.com/profile_images/2671170543/18debd694829ed78203a5a36dd364160_400x400.png'
)
session.add(User2)
session.commit()
# Menu for UrbanBurger
category1 = Category(user_id=1, name="Inkjet Printers")
session.add(category1)
session.commit()
CatItem2 = CatItem(
user_id=1,
name="HP Deskjet 3788",
description="All in one A4 4800 dpi usb wi-fi color inkjet",
price="$67.50",
#course="Entree",
category=category1)
session.add(CatItem2)
session.commit()
CatItem1 = CatItem(
user_id=2,
name="HP Officejet 7110",
description="15 ppm A3 usb wi-fi Inkjet",
price="$72.99",
#course="Appetizer",
category=category1)
email="*****@*****.**",
picture='https://pbs.twimg.com/profile_images/'
'2671170543/18debd694829ed78203a5a36dd364160_400x400.png')
session.add(User1)
session.commit()
# Create dummy data
cat1 = Category(name="Massively Multiplayer Online (MMO)",user_id=1)
session.add(cat1)
session.commit()
catItem1 = CatItem(name="World of Warcraft",
description="Since its release, the game has become the most popular"
"and subscribed MMORPG ever with more than 5 million subscribers."
"In the game, players control a character from either the "
"first- or third-person perspective and begin exploring the game "
"world completing quests, interacting with other characters, "
"and fighting all sorts of monsters from the WarCraft universe.",
category=cat1)
session.add(catItem1)
session.commit()
catItem2 = CatItem(name="Guild Wars 2",
description="The game features a unique aspect in which the game's storyline "
"adjusts based on actions taken by player characters. "
"In it, players create a character based on one of five "
"races and eight character classes or professions.",
category=cat1)
# Categories + User
user1 = User(name='Abdirashiid Jama', email='*****@*****.**',
picture='https://lh6.googleusercontent.com/-sVcI-LPVb-0/AAAAAAAAAAI/AAAAAAAAAAc/JfhLrXf4Po4/s96-c/photo.jpg')
session.add(user1)
session.commit()
category1 = Category(name='Football', user=user1)
session.add(category1)
session.commit()
catItem1 = CatItem(name="Ball", description="Beautiful Champions League ball",
category=category1, user=user1)
session.add(catItem1)
session.commit()
catItem2 = CatItem(name="Shirt", description="Ajax Number 13 Shirt",
category=category1, user=user1)
session.add(catItem2)
session.commit()
catItem3 = CatItem(name="Shoes", description="Nike Football Shoes",
category=category1, user=user1)
session.add(catItem3)
session.commit()
category8 = Category(name="Skating") session.add(category8) session.commit() category9 = Category(name="Hockey") session.add(category9) session.commit() # Create default user user1 = CatUser(name="Default User", email="*****@*****.**") session.add(user1) session.commit() # Create items for default user catItem1 = CatItem(user_id=1, name="Jersey", description="""100% polyester breathable and moisture whisking fabric. Red with black stripes and the number 13 on the back.""", category=category1) session.add(catItem1) session.commit() catItem2 = CatItem(user_id=1, name="Shorts", description="""100% polyester breathable and moisture whisking fabric. All black and coming down to just 1 inch above the knee.""", category=category1) session.add(catItem2) session.commit() catItem3 = CatItem(user_id=1, name="Shinguards", description="""Standard shinguards covering the area 1 inch above the ankle and extending to 2 inches below the knee.""", category=category1) session.add(catItem3) session.commit() catItem4 = CatItem(user_id=1, name="Soccer Cleats", description="""100% synthetic leather with removable studs not exceeding 0.5 inches in length.""", category=category1) session.add(catItem4) session.commit()