Esempio n. 1
0
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)
Esempio n. 2
0
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)