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