def _search_movies_by_page(kw):
sql = "where name like '%%%s%%' "
sql = sql % (kw)
total = len(Movie.find_by(sql))
page = Page(total, _get_page_index())
sql = "where name like '%%%s%%' order by created_at desc limit %s,%s"
sql = sql % (kw, page.offset, page.limit)
movies = Movie.find_by(sql)
return movies, page
def _get_index_by_tags():
tag = ctx.request.get('tag', '')
sql = "where style like '%%%s%%' "
sql = sql % (tag)
movies = Movie.find_by(sql)
total = len(movies)
page = Page(total, _get_page_index())
sql = "where style like '%%%s%%' order by created_at desc limit %s,%s"
sql = sql % (tag, page.offset, page.limit)
movies = Movie.find_by(sql)
for movie in movies:
movie = _get_movie_details(movie)
return dict(movies=movies, tag=tag, page=page, user=ctx.request.user)
def _get_movies_by_page():
total = Movie.count_all()
page = Page(total, _get_page_index())
movies = Movie.find_by('order by created_at desc limit ?,?', page.offset,
page.limit)
return movies, page
