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))
