def get_paginator(cls, request, page=1): query = DBSession.query(Entry).order_by(sa.desc(Entry.created)) query_params = request.GET.mixed() def url_maker(link_page): query_params['page'] = link_page return request.current_route_url(_query=query_params) return SqlalchemyOrmPage(query, page, items_per_page=5, url_maker=url_maker)
def by_name(cls, name): return DBSession.query(User).filter(User.name == name).first()
def by_id(cls, id): return DBSession.query(Entry).filter(Entry.id == id).first()
def all(cls): return DBSession.query(Entry).order_by(sa.desc(Entry.created))