| 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) |