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