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