def AddNewItem():
if login_session.get('username') is not None:
if request.method == 'POST':
print login_session.get('user_id')
conn = engine.connect()
select_cat_id = select([Category]).\
where(Category.name == request.form['Category'])
res = conn.execute(select_cat_id)
for category_id in res:
newItem = Item(name=request.form['itemname'],
description=request.form['description'],
cat_id=category_id.id,
user_id=login_session.get('user_id'))
session.add(newItem)
session.commit()
conn.close()
categories = session.query(Category).all()
items = session.query(Item).\
order_by(Item.creation_date.desc()).all()
flash("New Item has been Added")
return redirect('/catalog')
else:
categories = session.query(Category).all()
return render_template('CreateNewItem.html', categories=categories)
else:
return redirect('/catalog')
def addItemCat(cat_id):
'''
create new item
method GET will open the 'addItem.html' page.
The method POST insert new item DB and redirect the user to
the 'categories.html' page
'''
# check if user has been logged in
if 'userName' not in login_session:
return redirect(url_for('allCategories'))
else:
# call helper method to get Category
cat = get_category_by_id(cat_id)
if request.method == 'POST':
# create new item
new_item = Item(name=request.form['name'],
description=request.form['description'],
category_id=cat.id,
user_id=login_session['user_id'])
add_item(new_item)
return redirect(url_for('itemsByCategory', cat_id=cat.id))
else:
return render_template('addItem.html',
cat=cat,
user=login_session)
def createItem():
categories = session.query(Category).all()
sizeCategories = len(categories)
if login_session['LoggedIn'] == False:
return render_template('pleaseLogin.html',
categories=categories,
sizeCategories=sizeCategories,
login_session=login_session)
if (request.method == 'GET'):
return render_template('createItem.html',
categories=categories,
sizeCategories=sizeCategories,
login_session=login_session)
name = request.form['name']
description = request.form['description']
category = request.form['category']
id = session.query(Category).filter_by(name=category).one().id
user_id = session.query(User).filter_by(
email=login_session['email']).one().id
item = Item(name=name,
description=description,
category_id=id,
user_id=user_id)
session.add(item)
session.commit()
flash('Created Item')
return redirect(url_for('home')), 303
def newItem(categoryName):
category = session.query(Category).filter_by(name=categoryName).one()
if request.method == 'POST':
newItem = Item(name=request.form['name'],
description=request.form['description'],
category=category)
session.add(newItem)
session.commit()
return redirect(url_for('showCategory', categoryName=category.name))
else:
return render_template('newItem.html', category=category)
def newItem(categoryName):
if 'username' not in login_session:
return redirect('/login')
category = session.query(Category).filter_by(name=categoryName).one()
if request.method == 'POST':
newItem = Item(name=request.form['name'],
description=request.form['description'],
category=category,
owner=login_session['username'])
session.add(newItem)
session.commit()
return redirect(url_for('showCategory', categoryName=category.name))
else:
return render_template('newItem.html',
category=category,
login_session=login_session)
def add(username):
if request.method == 'POST':
name = request.form['itemName']
if (checkDuplicateItem(name) == False):
user = session.query(User).filter_by(username = username).one()
newItem = Item(
name = name,
description = request.form['description'],
category = request.form['category'],
user_id = user.id
)
session.add(newItem)
session.commit()
return redirect(url_for('userIndex', username = username))
else :
flash("The item is already in the catalog!")
return redirect(url_for('add', username = username))
else :
return render_template('addItem.html', username = username)
def newItem(categoryName):
#make sure user has permission to edit item
if 'username' not in login_session:
return redirect(url_for('login'))
#create item if post request is received
if request.method == 'POST':
category = session.query(Category).filter_by(
name=request.form['category']).one()
user = session.query(User).filter_by(
email=login_session['email']).one()
newItem = Item(name=request.form['name'],
description=request.form['description'],
category=category,
user=user)
session.add(newItem)
session.commit()
flash("New item has been added!")
#redirect to the category where the item has been added
return redirect(url_for('homepage'))
return render_template('newItem.html', category=categoryName)
'''
i = 0
while i < len(categories):
category = Category(user_id=1, name=categories[i])
print(categories[i])
session.add(category)
session.commit()
if categories[i] == "Mexican":
restaurantArray = Mexican
elif categories[i] == "AsianFusion":
restaurantArray = AsianFusion
elif categories[i] == "Southern":
restaurantArray = Southern
elif categories[i] == "Deli":
restaurantArray = Deli
else:
restaurantArray = [[
"Unknown", "No Restaurants are defined for this category"
]]
restaurants = restaurantArray
for restaurant in restaurants:
print(restaurant[0])
print(restaurant[1])
addRestaurant = Item(user_id=1,
name=restaurant[0],
description=restaurant[1],
category=category)
session.add(addRestaurant)
session.commit()
i += 1
from sqlalchemy.orm import sessionmaker
from databaseSetup import Category, Base, Item
engine = create_engine('sqlite:///catalogitem.db')
Base.metadata.bind = engine
DBSession = sessionmaker(bind=engine)
session = DBSession()
category1 = Category(name="Kite Boarding")
session.add(category1)
session.commit()
item1 = Item(name='14m^2 Kite',
description='Kite for light winds.',
category=category1,
owner='*****@*****.**')
session.add(item1)
session.commit()
item2 = Item(name='11m^2 Kite',
description='Kite for higher winds.',
category=category1)
session.add(item2)
session.commit()
item3 = Item(
name='Bar and Lines',
description='Enable attachment of the kite to harness and steering.',
Category6 = Category(name="Rock Climbing")
session.add(Category6)
session.commit()
Category7 = Category(name="Skating")
session.add(Category7)
session.commit()
User1 = User(name="System", email="*****@*****.**")
session.add(User1)
session.commit()
ItemC1 = Item(name="Breakaway rim",
description="A breakaway rim is a \
basketball rim that contains a hinge \
and a spring at the point",
cat_id=Category1.id,
user_id=User1.id)
session.add(ItemC1)
session.commit()
ItemC2 = Item(name="Shin Guard",
description="A shin guard or shin pan is \
a piece of equipment worn on the front of a \
players shin to protect them from injury",
cat_id=Category2.id,
user_id=User1.id)
session.add(ItemC2)
session.commit()
ItemC3 = Item(name="Soccer Ball",
'Rock Climbing', 'Foosball', 'Skating', 'Hockey', 'Table Tennis'
]
#creates user in order to assign an owner for all the items
newUser = User(name="Rohan Wadhwa", email="*****@*****.**")
session.add(newUser)
session.commit()
#adds all necessary categories in the database
for category in categories:
newCategory = Category(name=category)
session.add(newCategory)
session.commit()
user = session.query(User).filter_by(email="*****@*****.**").one()
#adds category items for Soccer
category = session.query(Category).filter_by(name="Soccer").one()
session.add(Item(name="Soccer Ball", category=category, user=user))
session.add(
Item(
name="Soccer Cleats",
category=category,
description=
"Shoes created specifically for soccer that allow you to up your game and play safer and better",
user=user))
session.add(
Item(
name="Shinguards",
category=category,
description=
"Important safety item that allows you to protect damage to your shin",
user=user))
session.add(Item(name="Jersey", category=category, user=user))
category8 = Category(name="Skating", user_id=1)
session.add(category8)
session.commit()
# Category 9
category9 = Category(name="Hockey", user_id=1)
session.add(category9)
session.commit()
print("added categories!")
# Item 1
item1 = Item(name="item 1",
description="description item 1",
category_id=5,
user_id=1)
session.add(item1)
session.commit()
# Item 2
item2 = Item(name="item 2",
description="description item 2",
category_id=1,
user_id=1)
session.add(item2)
session.commit()
# Item 3
item3 = Item(name="item 3",
description="description item 3",