diff options
Diffstat (limited to 'tests')
| -rw-r--r-- | tests/filtered_relation/tests.py | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/tests/filtered_relation/tests.py b/tests/filtered_relation/tests.py index cbf77752df..a9c6e00567 100644 --- a/tests/filtered_relation/tests.py +++ b/tests/filtered_relation/tests.py @@ -582,6 +582,28 @@ class FilteredRelationTests(TestCase): lambda x: (x.author, x.book_title, x.preferred_by_author_pk), ) + def test_three_level_nested_chained_relations(self): + borrower = Borrower.objects.create(name="Jenny") + Reservation.objects.create( + borrower=borrower, + book=self.book1, + state=Reservation.STOPPED, + ) + qs = Author.objects.annotate( + my_books=FilteredRelation("book"), + my_reserved_books=FilteredRelation( + "my_books__reservation", + condition=Q(my_books__reservation__state=Reservation.STOPPED), + ), + my_readers=FilteredRelation( + "my_reserved_books__borrower", + condition=Q(my_reserved_books__borrower=borrower), + ), + ) + self.assertSequenceEqual( + qs.filter(my_readers=borrower).values_list("name", flat=True), ["Alice"] + ) + def test_deep_nested_foreign_key(self): qs = ( Book.objects.annotate( |