summaryrefslogtreecommitdiff
path: root/tests/ordering
diff options
context:
space:
mode:
authorTomer Chachamu <tomer@festicket.com>2017-10-18 14:09:45 +0100
committerTim Graham <timograham@gmail.com>2017-10-21 20:55:45 -0400
commit21a3a29dc9d138c248fd7922923b3ec710735c6c (patch)
tree585f5847180fb709c26eb2241c342d04585a0bee /tests/ordering
parent6c3104221b2cb9f068c07adf3ef24c9f49627834 (diff)
Fixed #28722 -- Made QuerySet.reverse() affect nulls_first/nulls_last.
Diffstat (limited to 'tests/ordering')
-rw-r--r--tests/ordering/tests.py36
1 files changed, 20 insertions, 16 deletions
diff --git a/tests/ordering/tests.py b/tests/ordering/tests.py
index dbc924b06b..07c319b4c3 100644
--- a/tests/ordering/tests.py
+++ b/tests/ordering/tests.py
@@ -92,24 +92,28 @@ class OrderingTests(TestCase):
with self.assertRaisesMessage(ValueError, msg):
Article.objects.order_by(F("author").desc(nulls_last=True, nulls_first=True))
+ def assertQuerysetEqualReversible(self, queryset, sequence):
+ self.assertSequenceEqual(queryset, sequence)
+ self.assertSequenceEqual(queryset.reverse(), list(reversed(sequence)))
+
def test_order_by_nulls_last(self):
Article.objects.filter(headline="Article 3").update(author=self.author_1)
Article.objects.filter(headline="Article 4").update(author=self.author_2)
# asc and desc are chainable with nulls_last.
- self.assertSequenceEqual(
- Article.objects.order_by(F("author").desc(nulls_last=True)),
+ self.assertQuerysetEqualReversible(
+ Article.objects.order_by(F("author").desc(nulls_last=True), 'headline'),
[self.a4, self.a3, self.a1, self.a2],
)
- self.assertSequenceEqual(
- Article.objects.order_by(F("author").asc(nulls_last=True)),
+ self.assertQuerysetEqualReversible(
+ Article.objects.order_by(F("author").asc(nulls_last=True), 'headline'),
[self.a3, self.a4, self.a1, self.a2],
)
- self.assertSequenceEqual(
- Article.objects.order_by(Upper("author__name").desc(nulls_last=True)),
+ self.assertQuerysetEqualReversible(
+ Article.objects.order_by(Upper("author__name").desc(nulls_last=True), 'headline'),
[self.a4, self.a3, self.a1, self.a2],
)
- self.assertSequenceEqual(
- Article.objects.order_by(Upper("author__name").asc(nulls_last=True)),
+ self.assertQuerysetEqualReversible(
+ Article.objects.order_by(Upper("author__name").asc(nulls_last=True), 'headline'),
[self.a3, self.a4, self.a1, self.a2],
)
@@ -117,20 +121,20 @@ class OrderingTests(TestCase):
Article.objects.filter(headline="Article 3").update(author=self.author_1)
Article.objects.filter(headline="Article 4").update(author=self.author_2)
# asc and desc are chainable with nulls_first.
- self.assertSequenceEqual(
- Article.objects.order_by(F("author").asc(nulls_first=True)),
+ self.assertQuerysetEqualReversible(
+ Article.objects.order_by(F("author").asc(nulls_first=True), 'headline'),
[self.a1, self.a2, self.a3, self.a4],
)
- self.assertSequenceEqual(
- Article.objects.order_by(F("author").desc(nulls_first=True)),
+ self.assertQuerysetEqualReversible(
+ Article.objects.order_by(F("author").desc(nulls_first=True), 'headline'),
[self.a1, self.a2, self.a4, self.a3],
)
- self.assertSequenceEqual(
- Article.objects.order_by(Upper("author__name").asc(nulls_first=True)),
+ self.assertQuerysetEqualReversible(
+ Article.objects.order_by(Upper("author__name").asc(nulls_first=True), 'headline'),
[self.a1, self.a2, self.a3, self.a4],
)
- self.assertSequenceEqual(
- Article.objects.order_by(Upper("author__name").desc(nulls_first=True)),
+ self.assertQuerysetEqualReversible(
+ Article.objects.order_by(Upper("author__name").desc(nulls_first=True), 'headline'),
[self.a1, self.a2, self.a4, self.a3],
)