def most_rated(page_number=1, column='rating', order='desc'):
count = queries.get_show_count()
page_count = math.ceil(count[0]['count'] / SHOWS_PER_PAGE)
shows = queries.get_shows_by_parm(column, order, SHOWS_PER_PAGE,
(page_number - 1) * SHOWS_PER_PAGE)
return render_template('shows.html', shows=shows)
def shows(page_number=1, order_by="rating", order="DESC"):
count = queries.get_show_count()
pages_count = math.ceil(count[0]['count'] / SHOWS_PER_PAGE)
shows = queries.get_shows_limited(order_by, order, SHOWS_PER_PAGE,
(page_number - 1) * SHOWS_PER_PAGE)
shown_pages_start = int(page_number - ((SHOWN_PAGE_NUMBERS - 1) / 2))
shown_pages_end = int(page_number + ((SHOWN_PAGE_NUMBERS - 1) / 2))
if shown_pages_start < 1:
shown_pages_start = 1
shown_pages_end = SHOWN_PAGE_NUMBERS
elif shown_pages_end > pages_count:
shown_pages_start = pages_count - SHOWN_PAGE_NUMBERS + 1
shown_pages_end = pages_count
return render_template('shows.html',
shows=shows,
pages_count=pages_count,
page_number=page_number,
shown_pages_start=shown_pages_start,
shown_pages_end=shown_pages_end,
order_by=order_by,
order=order)