Debian Codegraph @

tests/composite_pk/test_values.py

raw
1 from collections import namedtuple
2 from uuid import UUID
3
4 from django.test import TestCase
5
6 from .models import Comment, Post, Tenant, User
7
8
9 class CompositePKValuesTests(TestCase):
10 USER_1_EMAIL = "[email protected]"
11 USER_2_EMAIL = "[email protected]"
12 USER_3_EMAIL = "[email protected]"
13 POST_1_ID = "77777777-7777-7777-7777-777777777777"
14 POST_2_ID = "bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb"
15 POST_3_ID = "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa"
16
17 @classmethod
18 def setUpTestData(cls):
19 super().setUpTestData()
20 cls.tenant_1 = Tenant.objects.create()
21 cls.tenant_2 = Tenant.objects.create()
22 cls.user_1 = User.objects.create(
23 tenant=cls.tenant_1, id=1, email=cls.USER_1_EMAIL
24 )
25 cls.user_2 = User.objects.create(
26 tenant=cls.tenant_1, id=2, email=cls.USER_2_EMAIL
27 )
28 cls.user_3 = User.objects.create(
29 tenant=cls.tenant_2, id=3, email=cls.USER_3_EMAIL
30 )
31 cls.post_1 = Post.objects.create(tenant=cls.tenant_1, id=cls.POST_1_ID)
32 cls.post_2 = Post.objects.create(tenant=cls.tenant_1, id=cls.POST_2_ID)
33 cls.post_3 = Post.objects.create(tenant=cls.tenant_2, id=cls.POST_3_ID)
34
35 def test_values_list(self):
36 with self.subTest('User.objects.values_list("pk")'):
37 self.assertSequenceEqual(
38 User.objects.values_list("pk").order_by("pk"),
39 (
40 (self.user_1.pk,),
41 (self.user_2.pk,),
42 (self.user_3.pk,),
43 ),
44 )
45 with self.subTest('User.objects.values_list("pk", "email")'):
46 self.assertSequenceEqual(
47 User.objects.values_list("pk", "email").order_by("pk"),
48 (
49 (self.user_1.pk, self.USER_1_EMAIL),
50 (self.user_2.pk, self.USER_2_EMAIL),
51 (self.user_3.pk, self.USER_3_EMAIL),
52 ),
53 )
54 with self.subTest('User.objects.values_list("pk", "id")'):
55 self.assertSequenceEqual(
56 User.objects.values_list("pk", "id").order_by("pk"),
57 (
58 (self.user_1.pk, self.user_1.id),
59 (self.user_2.pk, self.user_2.id),
60 (self.user_3.pk, self.user_3.id),
61 ),
62 )
63 with self.subTest('User.objects.values_list("pk", "tenant_id", "id")'):
64 self.assertSequenceEqual(
65 User.objects.values_list("pk", "tenant_id", "id").order_by("pk"),
66 (
67 (self.user_1.pk, self.user_1.tenant_id, self.user_1.id),
68 (self.user_2.pk, self.user_2.tenant_id, self.user_2.id),
69 (self.user_3.pk, self.user_3.tenant_id, self.user_3.id),
70 ),
71 )
72 with self.subTest('User.objects.values_list("pk", flat=True)'):
73 self.assertSequenceEqual(
74 User.objects.values_list("pk", flat=True).order_by("pk"),
75 (
76 self.user_1.pk,
77 self.user_2.pk,
78 self.user_3.pk,
79 ),
80 )
81 with self.subTest('Post.objects.values_list("pk", flat=True)'):
82 self.assertSequenceEqual(
83 Post.objects.values_list("pk", flat=True).order_by("pk"),
84 (
85 (self.tenant_1.id, UUID(self.POST_1_ID)),
86 (self.tenant_1.id, UUID(self.POST_2_ID)),
87 (self.tenant_2.id, UUID(self.POST_3_ID)),
88 ),
89 )
90 with self.subTest('Post.objects.values_list("pk")'):
91 self.assertSequenceEqual(
92 Post.objects.values_list("pk").order_by("pk"),
93 (
94 ((self.tenant_1.id, UUID(self.POST_1_ID)),),
95 ((self.tenant_1.id, UUID(self.POST_2_ID)),),
96 ((self.tenant_2.id, UUID(self.POST_3_ID)),),
97 ),
98 )
99 with self.subTest('Post.objects.values_list("pk", "id")'):
100 self.assertSequenceEqual(
101 Post.objects.values_list("pk", "id").order_by("pk"),
102 (
103 ((self.tenant_1.id, UUID(self.POST_1_ID)), UUID(self.POST_1_ID)),
104 ((self.tenant_1.id, UUID(self.POST_2_ID)), UUID(self.POST_2_ID)),
105 ((self.tenant_2.id, UUID(self.POST_3_ID)), UUID(self.POST_3_ID)),
106 ),
107 )
108 with self.subTest('Post.objects.values_list("id", "pk")'):
109 self.assertSequenceEqual(
110 Post.objects.values_list("id", "pk").order_by("pk"),
111 (
112 (UUID(self.POST_1_ID), (self.tenant_1.id, UUID(self.POST_1_ID))),
113 (UUID(self.POST_2_ID), (self.tenant_1.id, UUID(self.POST_2_ID))),
114 (UUID(self.POST_3_ID), (self.tenant_2.id, UUID(self.POST_3_ID))),
115 ),
116 )
117 with self.subTest('User.objects.values_list("pk", named=True)'):
118 Row = namedtuple("Row", ["pk"])
119 self.assertSequenceEqual(
120 User.objects.values_list("pk", named=True).order_by("pk"),
121 (
122 Row(pk=self.user_1.pk),
123 Row(pk=self.user_2.pk),
124 Row(pk=self.user_3.pk),
125 ),
126 )
127 with self.subTest('User.objects.values_list("pk", "pk")'):
128 self.assertSequenceEqual(
129 User.objects.values_list("pk", "pk").order_by("pk"),
130 (
131 (self.user_1.pk, self.user_1.pk),
132 (self.user_2.pk, self.user_2.pk),
133 (self.user_3.pk, self.user_3.pk),
134 ),
135 )
136 with self.subTest('User.objects.values_list("pk", "id", "pk", "id")'):
137 self.assertSequenceEqual(
138 User.objects.values_list("pk", "id", "pk", "id").order_by("pk"),
139 (
140 (self.user_1.pk, self.user_1.id, self.user_1.pk, self.user_1.id),
141 (self.user_2.pk, self.user_2.id, self.user_2.pk, self.user_2.id),
142 (self.user_3.pk, self.user_3.id, self.user_3.pk, self.user_3.id),
143 ),
144 )
145
146 def test_values(self):
147 with self.subTest('User.objects.values("pk")'):
148 self.assertSequenceEqual(
149 User.objects.values("pk").order_by("pk"),
150 (
151 {"pk": self.user_1.pk},
152 {"pk": self.user_2.pk},
153 {"pk": self.user_3.pk},
154 ),
155 )
156 with self.subTest('User.objects.values("pk", "email")'):
157 self.assertSequenceEqual(
158 User.objects.values("pk", "email").order_by("pk"),
159 (
160 {"pk": self.user_1.pk, "email": self.USER_1_EMAIL},
161 {"pk": self.user_2.pk, "email": self.USER_2_EMAIL},
162 {"pk": self.user_3.pk, "email": self.USER_3_EMAIL},
163 ),
164 )
165 with self.subTest('User.objects.values("pk", "id")'):
166 self.assertSequenceEqual(
167 User.objects.values("pk", "id").order_by("pk"),
168 (
169 {"pk": self.user_1.pk, "id": self.user_1.id},
170 {"pk": self.user_2.pk, "id": self.user_2.id},
171 {"pk": self.user_3.pk, "id": self.user_3.id},
172 ),
173 )
174 with self.subTest('User.objects.values("pk", "tenant_id", "id")'):
175 self.assertSequenceEqual(
176 User.objects.values("pk", "tenant_id", "id").order_by("pk"),
177 (
178 {
179 "pk": self.user_1.pk,
180 "tenant_id": self.user_1.tenant_id,
181 "id": self.user_1.id,
182 },
183 {
184 "pk": self.user_2.pk,
185 "tenant_id": self.user_2.tenant_id,
186 "id": self.user_2.id,
187 },
188 {
189 "pk": self.user_3.pk,
190 "tenant_id": self.user_3.tenant_id,
191 "id": self.user_3.id,
192 },
193 ),
194 )
195 with self.subTest('User.objects.values("pk", "pk")'):
196 self.assertSequenceEqual(
197 User.objects.values("pk", "pk").order_by("pk"),
198 (
199 {"pk": self.user_1.pk},
200 {"pk": self.user_2.pk},
201 {"pk": self.user_3.pk},
202 ),
203 )
204 with self.subTest('User.objects.values("pk", "id", "pk", "id")'):
205 self.assertSequenceEqual(
206 User.objects.values("pk", "id", "pk", "id").order_by("pk"),
207 (
208 {"pk": self.user_1.pk, "id": self.user_1.id},
209 {"pk": self.user_2.pk, "id": self.user_2.id},
210 {"pk": self.user_3.pk, "id": self.user_3.id},
211 ),
212 )
213
214 def test_foreign_object_values(self):
215 Comment.objects.create(id=1, user=self.user_1, integer=42)
216 testcases = {
217 "all": Comment.objects.all(),
218 "exclude_user_email": Comment.objects.exclude(user__email__endswith="net"),
219 }
220 for name, queryset in testcases.items():
221 with self.subTest(name=name):
222 values = list(queryset.values("user", "integer"))
223 self.assertEqual(
224 values[0]["user"], (self.user_1.tenant_id, self.user_1.id)
225 )
226 self.assertEqual(values[0]["integer"], 42)