def books_comment(id): book = Books.query.filter_by(id=id).first() comments_request = CommentsDetailed.query.filter_by(book_id=id).order_by(desc(CommentsDetailed.id)) comments, page, max_page = get_page_info(comments_request) comment_form = CommentForm() return render_template("books/comment.html", comment_data=comments, book=book, comment_form=comment_form, current_page=page, max_page=max_page)
def blog_filter_by_tag(tag): posts_with_tags = db.session.query(Tags).filter_by(tag=tag) posts_request = db.session.query(BlogDetailed)\ .filter_by(id=posts_with_tags.subquery().columns.blog_id)\ .order_by(desc(BlogDetailed.id)) posts, page, max_page = get_page_info(posts_request) return render_template("blog/main.html", posts=posts, current_page=page, max_page=max_page)
def main(): books_info_request = db.session.query(Books).order_by(desc(Books.id)) books_info, page, max_page = get_page_info(books_info_request) return render_template("books/main.html", books=books_info, current_page=page, max_page=max_page)
def blog_main(): all_posts_request = db.session.query(BlogDetailed).order_by(desc(BlogDetailed.id)) posts, page, max_page = get_page_info(all_posts_request) return render_template("blog/main.html", posts=posts, current_page=page, max_page=max_page)