models.py 文件源码

def get_article_topics(num):
        """ ????????? 
        @param num: ??????
        """
        ArticleTopic = app.article.models.ArticleTopic
        Article = app.article.models.Article
        topics = db.session.query(Topic)
        topics = topics.outerjoin(ArticleTopic).filter(
                ArticleTopic.article.has(Article.access=="public")
                ).group_by(Topic).order_by(
                func.count(ArticleTopic.topic_id).desc())
        return topics.limit(num).all(), topics.count()