diff options
Diffstat (limited to 'tests/annotations')
| -rw-r--r-- | tests/annotations/tests.py | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/tests/annotations/tests.py b/tests/annotations/tests.py index d2e2214db8..ee1c50cfdf 100644 --- a/tests/annotations/tests.py +++ b/tests/annotations/tests.py @@ -527,6 +527,24 @@ class NonAggregateAnnotationTestCase(TestCase): self.assertIs(book.is_pony, False) self.assertIsNone(book.is_none) + def test_annotation_in_f_grouped_by_annotation(self): + qs = ( + Publisher.objects.annotate(multiplier=Value(3)) + # group by option => sum of value * multiplier + .values('name') + .annotate(multiplied_value_sum=Sum(F('multiplier') * F('num_awards'))) + .order_by() + ) + self.assertCountEqual( + qs, [ + {'multiplied_value_sum': 9, 'name': 'Apress'}, + {'multiplied_value_sum': 0, 'name': "Jonno's House of Books"}, + {'multiplied_value_sum': 27, 'name': 'Morgan Kaufmann'}, + {'multiplied_value_sum': 21, 'name': 'Prentice Hall'}, + {'multiplied_value_sum': 3, 'name': 'Sams'}, + ] + ) + def test_arguments_must_be_expressions(self): msg = 'QuerySet.annotate() received non-expression(s): %s.' with self.assertRaisesMessage(TypeError, msg % BooleanField()): |