def webAddItem(category_id): if 'username' not in login_session: return redirect('/login') else: newItem = Items(name='', description='', category_id=category_id) newItem.id = 0 return render_template('EditItem.html', item=newItem)
def newitems(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 restaurant. Please create your own restaurant in order to add items.');}</script><body onload='myFunction()''>" if request.method == 'POST': newitem = Items(name = request.form['name'], description = request.form['description'],img_url = request.form['img_url'] ,user_id = category.user_id,category_id = category_id) session.add(newitem) session.commit() flash ('Items Successfully added %s' % newitem.name) return redirect (url_for('Showitems', category_id = category_id)) else: return render_template('newitem.html',category_id = category_id)
def addItem(): DBSession = sessionmaker(bind=engine) session = DBSession() categories = session.query(Categories).all() if 'username' not in login_session: return redirect('/login') if request.method == 'POST': newItem = Items(name=request.form['title'], description=request.form ['description'], categories = session.query(Categories).filter_by(name=request.form['catego']).first(), datee=datetime.datetime.now(), user_id=login_session['user_id']) session.add(newItem) session.commit() return redirect(url_for('listcategories')) else: return render_template('addItemm.html', categories=categories)
def webUpdateItem(category_id, item_id): if 'username' not in login_session: return redirect('/login') else: if item_id == 0: newItem = Items(name=request.form['name'], description=request.form['description'], category_id=category_id) session.add(newItem) else: updateItem = session.query(Items).filter_by(id=item_id).one() if request.form['name']: updateItem.name = request.form['name'] if request.form['description']: updateItem.description = request.form['description'] session.add(updateItem) session.commit() return redirect(url_for('webCategoryItems', category_id=category_id))
category1 = Category(name='Women', user_id=1) category2 = Category(name='Men', user_id=1) category3 = Category(name='Baby', user_id=1) category4 = Category(name='Books', user_id=1) session.add(category1) session.add(category2) session.add(category3) session.add(category4) session.commit() items1 = Items( user_id=1, name='Clothing', description='Stylist Dress', img_url= "https://ae01.alicdn.com/kf/HTB1IdHhLFXXXXaoXFXXq6xXFXXXD/Navy-Blue-Oversized-Long-Sleeve-Women-Clothing-Home-House-Dress-With-Belt-Summer-Long-Shirt-Dress.jpg", category=category1) items2 = Items( user_id=1, name='Watches', description='Luxury watches', img_url= "https://slimages.macysassets.com/is/image/MCY/products/5/optimized/8310605_fpx.tif?bgc=255,255,255&wid=224&qlt=90,0&layer=comp&op_sharpen=0&resMode=bicub&op_usm=0.7,1.0,0.5,0&fmt=jpeg", category=category1) items3 = Items( user_id=1, name='shoes', description='high heels', img_url=
from sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker from Database_setup import Base, Items, Category engine = create_engine('sqlite:///itemsdb.db') Base.metadata.bind = engine DBsession = sessionmaker(bind=engine) session = DBsession() Category1 = Category(name="3d Printing") session.add(Category1) session.commit() Item1 = Items(name="CR10", description="A mid level printer with large print space", category=Category1) session.add(Item1) session.commit() Item2 = Items(name="MonoPrice Mini", description="An entry level printer with small print space", category=Category1) session.add(Item2) session.commit() Item1 = Items(name="Hatchbox Filament", description="A popular filament", category=Category1) session.add(Item1) session.commit() # Start of second category