def showCategory(category_name): db = DBConnect() categories = db.getAllCategories() items = db.getItemsByCategory(category_name) count = db.getItemCountByCategory(category_name) return render_template('showCategory.html', categories=categories, items=items, categoryName=category_name, numberOfItems=count)
def catalogJSON(): user = session.get('username') if user is None: return redirect(url_for('showLogin')) db = DBConnect() categories = db.getAllCategories() # Building the json object to be returned total = {'Category': []} for c in categories: items = db.getItemsByCategory(c.name) total['Category'].append({ 'id': c.id, 'name': c.name, 'items': [i.serialize for i in items] }) return jsonify(total)