def GET(self): context = {} context["post_count"] = web.ctx.orm.query(Post).filter(Post.content_type == "post").count() context["comment_count"] = web.ctx.orm.query(Comment).count() # # context['spam_count'] # context['category_count'] = web.ctx.orm.query(Term).filter(Term.type=='category') # context['tag_count'] = web.ctx.orm.query(Term).filter(Term.type=='tag') context["recent_comments"] = web.ctx.orm.query(Comment).order_by("comments.created DESC").all()[:5] return admin_render.index(**context)
def GET(self): context = {} context["post_count"] = web.ctx.orm.query(Post).filter(Post.content_type == "post").count() context["comment_count"] = web.ctx.orm.query(Comment).count() context["spam_count"] = web.ctx.orm.query(Comment).filter(Comment.status == "spam").count() context["page_count"] = web.ctx.orm.query(Post).filter(Post.content_type == "page").count() context["category_count"] = web.ctx.orm.query(Term).filter(Term.type == "category").count() context["tag_count"] = web.ctx.orm.query(Term).filter(Term.type == "tag").count() context["recent_comments"] = ( web.ctx.orm.query(Comment).order_by("comments.created DESC").all()[:5] ) # the recent 10 comments return admin_render.index(**context)