Debian Codegraph @

tests/prefetch_related/test_uuid.py

raw
1 from django.test import TestCase
2
3 from .models import Flea, House, Person, Pet, Room
4
5
6 class UUIDPrefetchRelated(TestCase):
7 def test_prefetch_related_from_uuid_model(self):
8 Pet.objects.create(name="Fifi").people.add(
9 Person.objects.create(name="Ellen"),
10 Person.objects.create(name="George"),
11 )
12
13 with self.assertNumQueries(2):
14 pet = Pet.objects.prefetch_related("people").get(name="Fifi")
15 with self.assertNumQueries(0):
16 self.assertEqual(2, len(pet.people.all()))
17
18 def test_prefetch_related_to_uuid_model(self):
19 Person.objects.create(name="Bella").pets.add(
20 Pet.objects.create(name="Socks"),
21 Pet.objects.create(name="Coffee"),
22 )
23
24 with self.assertNumQueries(2):
25 person = Person.objects.prefetch_related("pets").get(name="Bella")
26 with self.assertNumQueries(0):
27 self.assertEqual(2, len(person.pets.all()))
28
29 def test_prefetch_related_from_uuid_model_to_uuid_model(self):
30 fleas = [Flea.objects.create() for i in range(3)]
31 Pet.objects.create(name="Fifi").fleas_hosted.add(*fleas)
32 Pet.objects.create(name="Bobo").fleas_hosted.add(*fleas)
33
34 with self.assertNumQueries(2):
35 pet = Pet.objects.prefetch_related("fleas_hosted").get(name="Fifi")
36 with self.assertNumQueries(0):
37 self.assertEqual(3, len(pet.fleas_hosted.all()))
38
39 with self.assertNumQueries(2):
40 flea = Flea.objects.prefetch_related("pets_visited").get(pk=fleas[0].pk)
41 with self.assertNumQueries(0):
42 self.assertEqual(2, len(flea.pets_visited.all()))
43
44 def test_prefetch_related_from_uuid_model_to_uuid_model_with_values_flat(self):
45 pet = Pet.objects.create(name="Fifi")
46 pet.people.add(
47 Person.objects.create(name="Ellen"),
48 Person.objects.create(name="George"),
49 )
50 self.assertSequenceEqual(
51 Pet.objects.prefetch_related("fleas_hosted").values_list("id", flat=True),
52 [pet.id],
53 )
54
55
56 class UUIDPrefetchRelatedLookups(TestCase):
57 @classmethod
58 def setUpTestData(cls):
59 house = House.objects.create(name="Redwood", address="Arcata")
60 room = Room.objects.create(name="Racoon", house=house)
61 fleas = [Flea.objects.create(current_room=room) for i in range(3)]
62 pet = Pet.objects.create(name="Spooky")
63 pet.fleas_hosted.add(*fleas)
64 person = Person.objects.create(name="Bob")
65 person.houses.add(house)
66 person.pets.add(pet)
67 person.fleas_hosted.add(*fleas)
68
69 def test_from_uuid_pk_lookup_uuid_pk_integer_pk(self):
70 # From uuid-pk model, prefetch <uuid-pk model>.<integer-pk model>:
71 with self.assertNumQueries(4):
72 spooky = Pet.objects.prefetch_related(
73 "fleas_hosted__current_room__house"
74 ).get(name="Spooky")
75 with self.assertNumQueries(0):
76 self.assertEqual("Racoon", spooky.fleas_hosted.all()[0].current_room.name)
77
78 def test_from_uuid_pk_lookup_integer_pk2_uuid_pk2(self):
79 # From uuid-pk model, prefetch
80 # <integer-pk model>.<integer-pk model>.<uuid-pk model>.<uuid-pk model>:
81 with self.assertNumQueries(5):
82 spooky = Pet.objects.prefetch_related("people__houses__rooms__fleas").get(
83 name="Spooky"
84 )
85 with self.assertNumQueries(0):
86 self.assertEqual(
87 3,
88 len(spooky.people.all()[0].houses.all()[0].rooms.all()[0].fleas.all()),
89 )
90
91 def test_from_integer_pk_lookup_uuid_pk_integer_pk(self):
92 # From integer-pk model, prefetch <uuid-pk model>.<integer-pk model>:
93 with self.assertNumQueries(3):
94 racoon = Room.objects.prefetch_related("fleas__people_visited").get(
95 name="Racoon"
96 )
97 with self.assertNumQueries(0):
98 self.assertEqual("Bob", racoon.fleas.all()[0].people_visited.all()[0].name)
99
100 def test_from_integer_pk_lookup_integer_pk_uuid_pk(self):
101 # From integer-pk model, prefetch <integer-pk model>.<uuid-pk model>:
102 with self.assertNumQueries(3):
103 redwood = House.objects.prefetch_related("rooms__fleas").get(name="Redwood")
104 with self.assertNumQueries(0):
105 self.assertEqual(3, len(redwood.rooms.all()[0].fleas.all()))
106
107 def test_from_integer_pk_lookup_integer_pk_uuid_pk_uuid_pk(self):
108 # From integer-pk model, prefetch
109 # <integer-pk model>.<uuid-pk model>.<uuid-pk model>:
110 with self.assertNumQueries(4):
111 redwood = House.objects.prefetch_related("rooms__fleas__pets_visited").get(
112 name="Redwood"
113 )
114 with self.assertNumQueries(0):
115 self.assertEqual(
116 "Spooky",
117 redwood.rooms.all()[0].fleas.all()[0].pets_visited.all()[0].name,
118 )