Debian Codegraph @

tests/test_managers/test_join_manager.py

raw
1 from __future__ import annotations
2
3 from django.test import TestCase
4
5 from tests.models import BoxJoinModel, JoinItemForeignKey
6
7
8 class JoinManagerTest(TestCase):
9 def setUp(self) -> None:
10 for i in range(20):
11 BoxJoinModel.objects.create(name=f'name_{i}')
12
13 JoinItemForeignKey.objects.create(
14 weight=10, belonging=BoxJoinModel.objects.get(name='name_1')
15 )
16 JoinItemForeignKey.objects.create(weight=20)
17
18 def test_self_join(self) -> None:
19 a_slice = BoxJoinModel.objects.all()[0:10]
20 with self.assertNumQueries(1):
21 result = a_slice.join()
22 self.assertEqual(result.count(), 10)
23
24 def test_self_join_with_where_statement(self) -> None:
25 qs = BoxJoinModel.objects.filter(name='name_1')
26 result = qs.join()
27 self.assertEqual(result.count(), 1)
28
29 def test_join_with_other_qs(self) -> None:
30 item_qs = JoinItemForeignKey.objects.filter(weight=10)
31 boxes = BoxJoinModel.objects.all().join(qs=item_qs)
32 self.assertEqual(boxes.count(), 1)
33 self.assertEqual(boxes[0].name, 'name_1')
34
35 def test_reverse_join(self) -> None:
36 box_qs = BoxJoinModel.objects.filter(name='name_1')
37 items = JoinItemForeignKey.objects.all().join(box_qs)
38 self.assertEqual(items.count(), 1)
39 self.assertEqual(items[0].weight, 10)