def new_category(category_obj):
category_to_add = Categories(name=category_obj['name'],
description=category_obj['description'],
image=category_obj['image'],
user_id=category_obj['user_id'])
session.add(category_to_add)
session.commit()
def getCategories(accessToken):
url = 'https://api.joom.com/1.1/categoriesHierarchy'
headers = {
'Accept': '*/*',
'Authorization': 'Bearer ' + accessToken,
'Content-Encoding': 'gzip'
}
payload = {'levels': -1, 'parentLevels': 1}
rsps = requests.get(url=url, headers=headers, params=payload)
if rsps.status_code == 200:
jsonresponse = rsps.json()
for category in jsonresponse['payload']['children']:
category_id = category['id']
category_name = category['name']
hasPublicChildren = category['hasPublicChildren']
if 'parentId' in category:
parent_id = category['parentId']
else:
parent_id = None
session.add(
Categories(category_id=category_id,
category_name=category_name,
hasPublicChildren=hasPublicChildren,
parent_id=parent_id))
session.commit()
getChildren(category)
return
def addCategory():
categories = session.query(Categories).all()
if request.method == 'POST':
# if user typed in a name for the category
if request.form['name']:
for category in categories:
# since, we are quering categories in edit and delete
# functions.we cannot have duplicate categoryName,
# making sure, there are no duplicate names for
# categoryName.
if request.form['name'] == category.categoryName:
return "<script>function myFunction(){alert\
('Choose different name');}</script><body\
onload = 'myFunction()'>"
categoryToAdd = Categories(categoryName=request.form['name'],
categorySector=request.form['sector'],
categoryDetails=request.form['details'],
priceRange=request.form['pricerange'],
categoryAgeGroup=request.form[
'agegroup'],
user_id=login_session['user_id'])
session.add(categoryToAdd)
session.commit()
flash("Category %s successfully added" %
categoryToAdd.categoryName)
# redirect showAllCategories after the POST is handled.
return redirect(url_for('showAllCategories'))
# GET function
return render_template('addCategory.html', categories=categories)
def newProduct():
if 'username' not in login_session:
flash('Please Login to create new item')
return redirect('/login')
if request.method == 'POST':
user = session.query(User).filter_by(name=login_session['username'].encode('ascii','ignore')).one()
try:
cat = session.query(Categories).filter_by(
name=str(request.form['category']).strip().encode('ascii','ignore')).one()
except:
new_cat = Categories(name=request.form['category'].strip().encode('ascii','ignore'))
session.add(new_cat)
session.commit()
cat = session.query(Categories).filter_by(
name=str(request.form['category']).strip().encode('ascii','ignore')).one()
pass
P = Products(name=str(request.form['name']).strip().encode('ascii','ignore'), cat_id=cat.id,
category=str(request.form['category']).strip().encode('ascii','ignore'),
desc=str(request.form['description']).strip().encode('ascii','ignore'), user_id=user.id,
img=str(request.form['img']).encode('ascii','ignore'), url=str(request.form['url']).encode('ascii','ignore'))
session.add(P)
session.commit()
return redirect('/catalog')
else:
return render_template('new_product.html')
def categories():
"""
Function to handle the index page
and populate the Categories table if empty
Return render index template
"""
categories = get_categories()
latest_items = get_latest_items()
if not categories:
categories_list = ['Soccer',
'Basketball',
'Baseball',
'Frisbee',
'Snowboarding',
'Rock Climbing',
'Foosball',
'Skating',
'Hockey']
for category in categories_list:
new_category = Categories(name=category)
session.add(new_category)
session.commit()
categories = get_categories()
return render_template('index.html',
categories=get_categories(),
latest_items=get_latest_items(),
session_token=get_session_token()
)
def newCategory(): #display database content
if request.method == 'POST':
newItem = Categories(user_id=1, name=request.form['name'])
session.add(newItem)
session.commit()
return redirect(url_for('showCategories'))
else:
return render_template('newCategory.html')
def NewCat():
if request.method == 'POST':
new_cat = Categories(name = request.form['name'])
session.add(new_cat)
session.commit()
return redirect(url_for('Index'))
else:
return render_template('newcat.html', login_session = login_session)
def new_category():
if request.method == 'POST':
new_category = Categories(name=request.form['name'])
session.add(new_category)
session.commit()
return redirect(url_for('show_categories'))
else:
return render_template('new_category.html')
def newCategoryItem(main_page_id):
if request.method == 'POST':
newItem = Categories(
name=request.form['name'], main_page_id=main_page_id)
session.add(newItem)
session.commit()
return redirect(url_for('MainpageCategories', main_page_id=main_page_id))
else:
return render_template('NewCategoryItem.html', main_page_id=main_page_id)
def newCat():
if request.method == 'POST':
cat = Categories(cat_name=request.form.get('name'),
user_id=login_session['user_id'])
session.add(cat)
session.commit()
return redirect(url_for('showItems'))
else:
return render_template('newCat.html')
def newCategory():
if request.method == 'POST':
newCategory = Categories(name=request.form['name'])
session.add(newCategory)
flash('New Category %s Succesfully Created' % newCategory.name)
session.commit()
return redirect(url_for('showCatalog'))
else:
return render_template('newCategory.html')
def addCategoryRenderer():
if request.method == 'POST':
newCategory = Categories(
name=request.form['name'], user_id=login_session['user_id'])
session.add(newCategory)
flash('New Category %s Successfully Created' % newCategory.name)
session.commit()
return redirect(url_for('catalogMenu'))
else:
return render_template('newCategory.html')
def newCategory(name, user_id):
''' Creates a new category
Args:
cname = The name of the new category
user_id = The id of the user that created it
'''
category = Categories(name=name, user_id=user_id)
sess.add(category)
sess.commit()
def add_cat():
if 'username' not in login_session:
return redirect('/login')
if request.method == 'POST':
new_cat = Categories(name=request.form['name'],
u_id=login_session['user_id'])
session.add(new_cat)
session.commit()
return redirect(url_for('main_page'))
else:
return render_template("new_cat.html")
def Add_category():
if 'username' not in login_session:
return redirect('/login')
if request.method == 'POST':
newcategory = Categories(name=request.form['name'])
session.add(newcategory)
flash('New Category %s Successfully Created' % newcategory.name)
session.commit()
return redirect(url_for('Display_categories'))
else:
return render_template('newcategory.html')
def newCategorie():
if 'username' not in login_session:
return redirect('/login')
if request.method == 'POST':
newCategorie = Categories(title=request.form['name'],
description=request.form['description'],
user_id=login_session['user_id'])
session.add(newCategorie)
session.commit()
return redirect(url_for('showCategories'))
else:
return render_template('newcategorie.html')
def newcategories():
if 'username' not in login_session:
return redirect('/login')
if request.method == 'POST':
newcategories = Categories(
name=request.form['name'], user_id=login_session['user_id'])
session.add(newcategories)
flash('New categorie %s Successfully Created' % newcategories.name)
session.commit()
return redirect(url_for('categories.html'))
else:
return render_template('newcategories.html')
def newCategory():
if 'username' not in login_session:
return render_template("route_login.html")
if request.method == 'POST':
new_category = Categories(name=request.form['categname'],
user_id=login_session['user_id'])
session.add(new_category)
session.commit()
flash("New Category Created!")
return redirect(url_for('showCategories'))
else:
return render_template("newcategory.html")
def new_category():
# Get fnction for new category
if 'username' not in login_session:
return redirect('/login')
if request.method == 'POST':
new_category = Categories(name=request.form['name'])
session.add(new_category)
session.commit()
flash('New Restaurant %s Successfully Created' % new_category.name)
return redirect(url_for('show_categories'))
else:
return render_template('new_category.html')
def newCategory():
# if the user is not logged in, redirect to the home page
if 'username' not in login_session:
return redirect('/')
if request.method == 'POST':
newCategory = Categories(name=request.form['name'],
user_id=login_session['user_id'])
session.add(newCategory)
session.commit()
return redirect(url_for('catalogMenu'))
else:
return render_template('newcategory.html')
def newCategory():
if request.method == 'POST':
newCategory = Categories(
name=request.form['name'],
img=request.form['img'],
user_id=login_session['user_id'])
session.add(newCategory)
session.commit()
flash('New Category Created', 'positive')
return redirect(url_for('home'))
else:
return render_template('newCategory.html')
def newCat():
if 'username' not in login_session:
return redirect('/login')
if request.method == 'POST':
newCat = Categories(category=request.form['category'],
user_id=login_session['user_id'])
session.commit()
session.add(newCat)
flash("New category created!")
return redirect(url_for('astroCats'))
else:
return render_template('newcat.html')
def newCatalog():
if 'username' not in login_session:
return redirect('/login')
if request.method == 'POST':
newcategory = Categories(name=request.form['name'],
user_id=login_session['user_id'])
session.add(newcategory)
session.commit()
flash("New catalog was created!")
return redirect(url_for('showCatalog'))
else:
return render_template('newcategory.html')
def AddNewCategory():
"""Add new category to categories table"""
if 'username' not in login_session:
return redirect('/')
if request.method == 'POST':
newCategory = Categories(name=request.form['name'],
user_id=login_session['user_id'])
session.add(newCategory)
session.commit()
flash('New Category %s Successfully Created' % newCategory.name)
return redirect(url_for('ShowAllCategoriesPublic'))
else:
return render_template('new_category.html')
def newCategory():
if request.method == 'POST':
# printed login_session object to look at it :)
print login_session
newCategory = Categories(category=request.form['category'],
description=request.form['description'],
user_id=login_session['user_id'])
session.add(newCategory)
session.commit()
flash("new category created!")
return redirect(url_for('showCategories'))
else:
return render_template('newcategory.html')
def newCategory():
if 'username' not in login_session:
return redirect('/login')
if request.method == 'POST':
if request.form['name']:
newcategory = Categories(name=request.form['name'],
user_id=login_session['user_id'])
session.add(newcategory)
session.commit()
flash('"' + newcategory.name + '" has been added to the menu.')
return redirect(url_for('showCatalog'))
else:
return render_template('newCategories.html')
def addCategory():
if request.method == 'GET':
categories = session.query(Categories).all()
return render_template('addNewCategory.html', categories=categories)
else:
try:
newCategroy = Categories(name=request.form['category-name'])
session.add(newCategroy)
session.commit()
flash("New category has bean added !")
return redirect(url_for('catalogIndex'))
except:
abort(404)
def addCategory():
if 'username' not in login_session:
return redirect('/')
if request.method == 'POST':
newCategory = Categories(name=request.form['name'],
user_id=login_session['user_id'])
session.add(newCategory)
session.commit()
flash("Category successfully added.")
return redirect(url_for('showCatalog'))
else:
categories = session.query(Categories)
return render_template("addCategory.html", categories=categories)
def NewCategory():
""" This method is to add the category by authorized user.
If not a flash message will be displayed."""
if 'username' not in login_session:
return redirect('/login')
if request.method == 'POST':
newC = Categories(name=request.form['name'],
user_id=login_session['user_id'])
session.add(newC)
flash('New Category %s added.' % newC.name)
session.commit()
return redirect(url_for('HomePage'))
else:
return render_template('newcategory.html')
def newcategories():
if 'username' not in login_session:
return redirect('/login')
if request.method == 'POST':
session = DBSession()
ca = Categories(name=request.form['name'],
user_id=login_session['user_id'])
session.add(ca)
session.commit()
session.close()
flash("new category created !")
return redirect(url_for('listcategories'))
else:
return render_template('categoriesnew.html')