def allItemsJSON(): categories = session.query(Category).all() catsSerialized = [] for c in categories: items = session.query(Item).filter_by(category_id=c.id).all() catsSerialized.append(c.serialize(items)) return jsonify(Categories=catsSerialized)
def get_categories(): """ Returns all categories, with a new variable (count) that shows how many items are in the category """ categories = session.query(Category).order_by(Category.name).all() for c in categories: c.count = session.query(Item).filter_by(category_id=c.id).count() return categories
def wrapper(category_id, category, item_id): try: item = session.query(Item).filter_by(id=item_id).one() except: flash('!E!The item ID (%s) does not exist' % item_id) return redirect(url_for('viewCategory', category_id=category_id)) return f(category_id, category, item_id, item)
def getUserID(email): """ Returns the user id based on email address """ try: user = session.query(User).filter_by(email=email).one() return user.id except: return None
def wrapper(category_id, item_id=None): try: category = session.query(Category).filter_by(id=category_id).one() except: flash('!E!The category ID (%s) does not exist' % category_id) return redirect(url_for('front')) if item_id: return f(category_id, category, item_id) else: return f(category_id, category)
def clearCategory(category_id, category): if request.method == 'POST': items = session.query(Item).filter_by(category=category).all() for item in items: session.delete(item) session.commit() flash('All items in category <b>%s</b> has been deleted' % category.name) return redirect(url_for('editCategories')) else: return render_template('clearcategory.html', category=category)
def getUserInfo(user_id): """ Returns the user based on user id """ user = session.query(User).filter_by(id=user_id).one() return user
def front(): recent = session.query(Item).order_by(desc(Item.time)).limit(10).all() return render_template('front.html', recent=recent)
def editCategories(): categories = session.query(Category).order_by(Category.name).all() return render_template('editcategories.html', categories=categories)
def categoryJSON(category_id, category): items = session.query(Item).filter_by(category_id=category_id).all() return jsonify(Category=category.serialize(items))