def photo_list(request):
page_str = request.GET.get('page', '')
page = page_str.isdigit() and int(page_str) or 1
num_photos = DBSession.query(
func.count(Photo.id)
).filter(
Photo.published == True # noqa
).first()[0]
last_page = (num_photos + 8) // 9
if page > last_page:
raise HTTPNotFound()
photos = DBSession.query(
Photo
).filter(
Photo.published == True # noqa
).order_by(
Photo.created_at.desc()
).limit(
9
).offset(
(page - 1) * 9
).all()
return dict(photos=photos,
current_page=page,
last_page=last_page)
def photo_list(request):
page_str = request.GET.get('page', '')
page = page_str.isdigit() and int(page_str) or 1
num_photos = DBSession.query(func.count(
Photo.id)).filter(Photo.published == True # noqa
).first()[0]
last_page = (num_photos + 8) // 9
if page > last_page:
raise HTTPNotFound()
photos = DBSession.query(Photo).filter(
Photo.published == True # noqa
).order_by(Photo.created_at.desc()).limit(9).offset((page - 1) * 9).all()
return dict(photos=photos, current_page=page, last_page=last_page)
def photo_factory(request):
photo_id = request.matchdict['id']
photo = DBSession.query(Photo).filter(Photo.id == photo_id).first()
if photo is None:
raise HTTPNotFound()
return photo
def photo_factory(request):
photo_id = request.matchdict['id']
photo = DBSession.query(
Photo
).filter(
Photo.id == photo_id
).first()
if photo is None:
raise HTTPNotFound()
return photo
