Esempio n. 1
0
    def get_recommend_articles(category=None, limit=10):
        """
        返回推荐文章列表

        :param category:
            当前栏目,`None`或者`Category`实例
        :param limit:
            返回的个数,正整数,默认为10
        """
        _query = Article.query.public()
        if isinstance(category, Category):
            cate_ids = get_category_ids(category.longslug)
            _query = _query.filter(Article.category_id.in_(cate_ids))
        return _query.filter_by(recommend=True).limit(int(limit)).all()
Esempio n. 2
0
    def get_thumbnail_articles(category=None, limit=10):
        """
        返回有缩略图的文章列表

        :param category:
            当前栏目,`None`或者`Category`实例
        :param limit:
            返回的个数,正整数,默认为10
        """
        _query = Article.query.public()
        if isinstance(category, Category):
            cate_ids = get_category_ids(category.longslug)
            _query = _query.filter(Article.category_id.in_(cate_ids))
        return _query.filter(Article.thumbnail.isnot(None)).limit(int(limit)).all()
Esempio n. 3
0
    def get_recommend_articles(category=None, limit=10):
        """
        返回推荐文章列表

        :param category:
            当前栏目,`None`或者`Category`实例
        :param limit:
            返回的个数,正整数,默认为10
        """
        _query = Article.query.public()
        if isinstance(category, Category):
            cate_ids = get_category_ids(category.longslug)
            _query = _query.filter(Article.category_id.in_(cate_ids))
        return _query.filter_by(recommend=True).limit(int(limit)).all()
Esempio n. 4
0
    def get_latest_articles(category=None, limit=10):
        """
        返回最新文章列表

        :param category:
            当前栏目,`None`或者`Category`实例
        :param limit:
            返回的个数,正整数,默认为10
        """
        if isinstance(category, Category):
            cate_ids = get_category_ids(category.longslug)
            return Article.query.public().filter(Article.category_id.in_(cate_ids)) \
                                .limit(int(limit)).all()
        return Article.query.public().limit(int(limit)).all()
Esempio n. 5
0
    def get_thumbnail_articles(category=None, limit=10):
        """
        返回有缩略图的文章列表

        :param category:
            当前栏目,`None`或者`Category`实例
        :param limit:
            返回的个数,正整数,默认为10
        """
        _query = Article.query.public()
        if isinstance(category, Category):
            cate_ids = get_category_ids(category.longslug)
            _query = _query.filter(Article.category_id.in_(cate_ids))
        return _query.filter(Article.thumbnail.isnot(None)).limit(
            int(limit)).all()
Esempio n. 6
0
    def get_articles_by_category(longslug='', limit=10, expand=True):
        """
        根据栏目路径返回文章列表

        :param longslug:
            栏目路径,字符串,不要以`/`结尾
        :param limit:
            返回的个数,整数
        :param expand:
            是否返回子栏目文章,`False`则只返回当前栏目的文章
        """
        _query = Article.query.public()
        category = Category.query.filter_by(longslug=longslug).first()
        if category:
            if expand:
                cate_ids = get_category_ids(longslug)
                _query = _query.filter(Article.category_id.in_(cate_ids))
            else:
                _query = _query.filter_by(category_id=category.id)
        return _query.limit(int(limit)).all()
Esempio n. 7
0
    def get_articles_by_category(longslug='', limit=10, expand=True):
        """
        根据栏目路径返回文章列表

        :param longslug:
            栏目路径,字符串,不要以`/`结尾
        :param limit:
            返回的个数,整数
        :param expand:
            是否返回子栏目文章,`False`则只返回当前栏目的文章
        """
        _query = Article.query.public()
        category = Category.query.filter_by(longslug=longslug).first()
        if category:
            if expand:
                cate_ids = get_category_ids(longslug)
                _query = _query.filter(Article.category_id.in_(cate_ids))
            else:
                _query = _query.filter_by(category_id=category.id)
        return _query.limit(int(limit)).all()
Esempio n. 8
0
    def get_articles_by_category(longslug, limit=10, showall=True):
        """
        根据栏目路径返回文章列表

        :param longslug:
            栏目路径,字符串,不要以`/`结尾
        :param limit:
            返回的个数,整数
        :param showall:
            是否返回子栏目文章,`False`则只返回当前栏目的文章
        """
        category = Category.query.filter_by(longslug=longslug).first()
        if category:
            if showall:
                cate_ids = get_category_ids(longslug)
                return Article.query.public() \
                                    .filter(Article.category_id.in_(cate_ids)) \
                                    .limit(int(limit)).all()
            else:
                return Article.query.public() \
                                    .filter_by(category_id=category.id) \
                                    .limit(int(limit)).all()
        return []