models.py 文件源码

def prefix_autosearch(name, page, per_page):
        """ ??????? """
        Article = app.article.models.Article
        ArticleTopic = app.article.models.ArticleTopic
        topics = db.session.query(Topic).outerjoin(ArticleTopic, Article).filter(
                Topic.name.ilike(u"{0}%".format(name))).filter(Article.access=="public").group_by(
                Topic).order_by(func.count(ArticleTopic.topic_id).desc())
        return paginate(topics, page, per_page = per_page, error_out = False)