Python sqlalchemy_utils.sort_query函数代码示例

    def test_column_property(self, session, TextItem):
        TextItem.item_count = sa.orm.column_property(
            sa.select([sa.func.count("1")]).select_from(TextItem.__table__).label("item_count")
        )

        query = sort_query(session.query(TextItem), "item_count")
        assert_contains("ORDER BY item_count", query)

 def test_relation_hybrid_property(self):
     query = (
         self.session.query(self.Article)
         .join(self.Article.category)
     ).group_by(self.Article.id)
     query = sort_query(query, '-category-articles_count')
     assert_contains('ORDER BY (SELECT count(article.id) AS count_1', query)

 def test_join(self, session, Article):
     query = (
         session.query(Article)
         .join(Article.category)
     )
     query = sort_query(query, 'name', silent=False)
     assert_contains('ORDER BY article.name ASC', query)

 def test_join(self):
     query = (
         self.session.query(self.Article)
         .join(self.Article.category)
     )
     query = sort_query(query, 'name', silent=False)
     assert 'ORDER BY article.name ASC' in str(query)

    def test_with_mapper_and_column_property(self):
        class Apple(self.Base):
            __tablename__ = 'apple'
            id = sa.Column(sa.Integer, primary_key=True)
            article_id = sa.Column(sa.Integer, sa.ForeignKey(self.Article.id))

        self.Article.apples = sa.orm.relationship(Apple)

        self.Article.apple_count = sa.orm.column_property(
            sa.select([sa.func.count(Apple.id)])
            .where(Apple.article_id == self.Article.id)
            .correlate(self.Article.__table__)
            .label('apple_count'),
            deferred=True
        )
        query = (
            self.session.query(sa.inspect(self.Article))
            .outerjoin(self.Article.apples)
            .options(
                sa.orm.undefer(self.Article.apple_count)
            )
            .options(sa.orm.contains_eager(self.Article.apples))
        )
        query = sort_query(query, 'apple_count')
        assert 'ORDER BY apple_count' in str(query)

 def test_hybrid_property_descending(self):
     query = self.session.query(self.Category)
     query = sort_query(query, '-articles_count')
     assert (
         'ORDER BY (SELECT count(article.id) AS count_1'
     ) in str(query)
     assert ' DESC' in str(query)

    def test_assigned_hybrid_property(self, session, Article):
        def getter(self):
            return self.name

        Article.some_hybrid = sa.ext.hybrid.hybrid_property(fget=getter)
        query = session.query(Article)
        query = sort_query(query, "some_hybrid")
        assert_contains("ORDER BY article.name ASC", query)

 def test_with_unknown_column(self):
     query = sort_query(
         self.session.query(
             sa.orm.with_polymorphic(self.TextItem, [self.BlogPost])
         ),
         'category'
     )
     assert 'ORDER BY' not in str(query)

 def test_with_existing_column(self):
     query = sort_query(
         self.session.query(
             sa.orm.with_polymorphic(self.TextItem, [self.Article])
         ),
         'category'
     )
     assert 'ORDER BY' in str(query)

 def test_without_sort_param_returns_the_query_object_untouched(
     self,
     session,
     Article
 ):
     query = session.query(Article)
     query = sort_query(query, '')
     assert query == query

 def test_relation_hybrid_property(self):
     query = (
         self.session.query(self.Article)
         .join(self.Article.category)
         .correlate(self.Article.__table__)
     )
     query = sort_query(query, '-category-articles_count')
     assert 'ORDER BY (SELECT count(article.id) AS count_1' in str(query)

    def test_column_property_descending(self, session, Article, Category):
        Category.article_count = sa.orm.column_property(
            sa.select([sa.func.count(Article.id)]).where(Article.category_id == Category.id).label("article_count")
        )

        query = session.query(Category)
        query = sort_query(query, "-article_count")
        assert_contains("article_count DESC", query)

 def test_aliased_joined_entity(self, session, Article, Category):
     alias = sa.orm.aliased(Category, name='categories')
     query = session.query(
         Article
     ).join(
         alias, Article.category
     )
     query = sort_query(query, '-categories-name')
     assert_contains('ORDER BY categories.name DESC', query)

 def test_aliased_hybrid_property(self):
     alias = sa.orm.aliased(self.Category, name="categories")
     query = (
         self.session.query(self.Article)
         .outerjoin(alias, self.Article.category)
         .options(sa.orm.contains_eager(self.Article.category, alias=alias))
     )
     query = sort_query(query, "-categories-articles_count")
     assert "ORDER BY (SELECT count(article.id) AS count_1" in str(query)

 def test_aliased_joined_entity(self):
     alias = sa.orm.aliased(self.Category, name='categories')
     query = self.session.query(
         self.Article
     ).join(
         alias, self.Article.category
     )
     query = sort_query(query, '-categories-name')
     assert 'ORDER BY categories.name DESC' in str(query)