Debian Codegraph @

tests/composite_pk/test_create.py

raw
1 from django.db import IntegrityError
2 from django.test import TestCase, skipUnlessDBFeature
3
4 from .models import Post, Tenant, User
5
6
7 class CompositePKCreateTests(TestCase):
8 maxDiff = None
9
10 @classmethod
11 def setUpTestData(cls):
12 cls.tenant = Tenant.objects.create(id=1)
13 cls.user = User.objects.create(
14 tenant=cls.tenant,
15 id=1,
16 email="[email protected]",
17 )
18
19 def test_create_user(self):
20 test_cases = (
21 {"tenant": self.tenant, "id": 2412, "email": "[email protected]"},
22 {"tenant_id": self.tenant.id, "id": 5316, "email": "[email protected]"},
23 {"pk": (self.tenant.id, 7424), "email": "[email protected]"},
24 )
25
26 for fields in test_cases:
27 with self.subTest(fields=fields):
28 count = User.objects.count()
29 user = User(**fields)
30 obj = User.objects.create(**fields)
31 self.assertEqual(obj.tenant_id, self.tenant.id)
32 self.assertEqual(obj.id, user.id)
33 self.assertEqual(obj.pk, (self.tenant.id, user.id))
34 self.assertEqual(obj.email, user.email)
35 self.assertEqual(count + 1, User.objects.count())
36
37 def test_save_user(self):
38 test_cases = (
39 {"tenant": self.tenant, "id": 9241, "email": "[email protected]"},
40 {"tenant_id": self.tenant.id, "id": 5132, "email": "[email protected]"},
41 {"pk": (self.tenant.id, 3014), "email": "[email protected]"},
42 )
43
44 for fields in test_cases:
45 with self.subTest(fields=fields):
46 count = User.objects.count()
47 user = User(**fields)
48 self.assertIsNotNone(user.id)
49 self.assertIsNotNone(user.email)
50 user.save()
51 self.assertEqual(user.tenant_id, self.tenant.id)
52 self.assertEqual(user.tenant, self.tenant)
53 self.assertIsNotNone(user.id)
54 self.assertEqual(user.pk, (self.tenant.id, user.id))
55 self.assertEqual(user.email, fields["email"])
56 self.assertEqual(user.email, f"user{user.id}@example.com")
57 self.assertEqual(count + 1, User.objects.count())
58
59 def test_bulk_create_users(self):
60 objs = [
61 User(tenant=self.tenant, id=8291, email="[email protected]"),
62 User(tenant_id=self.tenant.id, id=4021, email="[email protected]"),
63 User(pk=(self.tenant.id, 8214), email="[email protected]"),
64 ]
65
66 obj_1, obj_2, obj_3 = User.objects.bulk_create(objs)
67
68 self.assertEqual(obj_1.tenant_id, self.tenant.id)
69 self.assertEqual(obj_1.id, 8291)
70 self.assertEqual(obj_1.pk, (obj_1.tenant_id, obj_1.id))
71 self.assertEqual(obj_1.email, "[email protected]")
72 self.assertEqual(obj_2.tenant_id, self.tenant.id)
73 self.assertEqual(obj_2.id, 4021)
74 self.assertEqual(obj_2.pk, (obj_2.tenant_id, obj_2.id))
75 self.assertEqual(obj_2.email, "[email protected]")
76 self.assertEqual(obj_3.tenant_id, self.tenant.id)
77 self.assertEqual(obj_3.id, 8214)
78 self.assertEqual(obj_3.pk, (obj_3.tenant_id, obj_3.id))
79 self.assertEqual(obj_3.email, "[email protected]")
80
81 @skipUnlessDBFeature(
82 "supports_update_conflicts",
83 "supports_update_conflicts_with_target",
84 )
85 def test_bulk_create_user_with_pk_field_in_update_fields(self):
86 objs = [User(tenant=self.tenant, id=8291, email="[email protected]")]
87 msg = "bulk_create() cannot be used with primary keys in update_fields."
88 with self.assertRaisesMessage(ValueError, msg):
89 User.objects.bulk_create(
90 objs,
91 update_conflicts=True,
92 update_fields=["tenant_id"],
93 unique_fields=["id", "tenant_id"],
94 )
95
96 def test_get_or_create_user(self):
97 test_cases = (
98 {
99 "pk": (self.tenant.id, 8314),
100 "defaults": {"email": "[email protected]"},
101 },
102 {
103 "tenant": self.tenant,
104 "id": 3142,
105 "defaults": {"email": "[email protected]"},
106 },
107 {
108 "tenant_id": self.tenant.id,
109 "id": 4218,
110 "defaults": {"email": "[email protected]"},
111 },
112 )
113
114 for fields in test_cases:
115 with self.subTest(fields=fields):
116 count = User.objects.count()
117 user, created = User.objects.get_or_create(**fields)
118 self.assertIs(created, True)
119 self.assertIsNotNone(user.id)
120 self.assertEqual(user.pk, (self.tenant.id, user.id))
121 self.assertEqual(user.tenant_id, self.tenant.id)
122 self.assertEqual(user.email, fields["defaults"]["email"])
123 self.assertEqual(user.email, f"user{user.id}@example.com")
124 self.assertEqual(count + 1, User.objects.count())
125
126 def test_update_or_create_user(self):
127 test_cases = (
128 {
129 "pk": (self.tenant.id, 2931),
130 "defaults": {"email": "[email protected]"},
131 },
132 {
133 "tenant": self.tenant,
134 "id": 6428,
135 "defaults": {"email": "[email protected]"},
136 },
137 {
138 "tenant_id": self.tenant.id,
139 "id": 5278,
140 "defaults": {"email": "[email protected]"},
141 },
142 )
143
144 for fields in test_cases:
145 with self.subTest(fields=fields):
146 count = User.objects.count()
147 user, created = User.objects.update_or_create(**fields)
148 self.assertIs(created, True)
149 self.assertIsNotNone(user.id)
150 self.assertEqual(user.pk, (self.tenant.id, user.id))
151 self.assertEqual(user.tenant_id, self.tenant.id)
152 self.assertEqual(user.email, fields["defaults"]["email"])
153 self.assertEqual(user.email, f"user{user.id}@example.com")
154 self.assertEqual(count + 1, User.objects.count())
155
156 def test_save_default_pk_not_set(self):
157 with self.assertNumQueries(1):
158 Post().save()
159
160 def test_save_default_pk_set(self):
161 post = Post.objects.create()
162 with self.assertRaises(IntegrityError):
163 Post(tenant_id=post.tenant_id, id=post.id).save()