Debian Codegraph @

tests/constraints/models.py

raw
1 from django.db import models
2 from django.db.models.functions import Coalesce, Lower
3
4
5 class Product(models.Model):
6 price = models.IntegerField(null=True)
7 discounted_price = models.IntegerField(null=True)
8 unit = models.CharField(max_length=15, null=True)
9
10 class Meta:
11 required_db_features = {
12 "supports_table_check_constraints",
13 }
14 constraints = [
15 models.CheckConstraint(
16 condition=models.Q(price__gt=models.F("discounted_price")),
17 name="price_gt_discounted_price",
18 ),
19 models.CheckConstraint(
20 condition=models.Q(price__gt=0),
21 name="%(app_label)s_%(class)s_price_gt_0",
22 ),
23 models.CheckConstraint(
24 condition=models.Q(
25 models.Q(unit__isnull=True) | models.Q(unit__in=["μg/mL", "ng/mL"])
26 ),
27 name="unicode_unit_list",
28 ),
29 ]
30
31
32 class GeneratedFieldStoredProduct(models.Model):
33 name = models.CharField(max_length=255, null=True)
34 price = models.IntegerField(null=True)
35 discounted_price = models.IntegerField(null=True)
36 rebate = models.GeneratedField(
37 expression=Coalesce("price", 0)
38 - Coalesce("discounted_price", Coalesce("price", 0)),
39 output_field=models.IntegerField(),
40 db_persist=True,
41 )
42 lower_name = models.GeneratedField(
43 expression=Lower(models.F("name")),
44 output_field=models.CharField(max_length=255, null=True),
45 db_persist=True,
46 )
47
48 class Meta:
49 required_db_features = {"supports_stored_generated_columns"}
50
51
52 class GeneratedFieldVirtualProduct(models.Model):
53 name = models.CharField(max_length=255, null=True)
54 price = models.IntegerField(null=True)
55 discounted_price = models.IntegerField(null=True)
56 rebate = models.GeneratedField(
57 expression=Coalesce("price", 0)
58 - Coalesce("discounted_price", Coalesce("price", 0)),
59 output_field=models.IntegerField(),
60 db_persist=False,
61 )
62 lower_name = models.GeneratedField(
63 expression=Lower(models.F("name")),
64 output_field=models.CharField(max_length=255, null=True),
65 db_persist=False,
66 )
67
68 class Meta:
69 required_db_features = {"supports_virtual_generated_columns"}
70
71
72 class UniqueConstraintProduct(models.Model):
73 name = models.CharField(max_length=255)
74 color = models.CharField(max_length=32, null=True)
75 age = models.IntegerField(null=True)
76 updated = models.DateTimeField(null=True)
77
78 class Meta:
79 constraints = [
80 models.UniqueConstraint(
81 fields=["name", "color"],
82 name="name_color_uniq",
83 )
84 ]
85
86
87 class ChildUniqueConstraintProduct(UniqueConstraintProduct):
88 pass
89
90
91 class UniqueConstraintConditionProduct(models.Model):
92 name = models.CharField(max_length=255)
93 color = models.CharField(max_length=32, null=True)
94
95 class Meta:
96 required_db_features = {"supports_partial_indexes"}
97 constraints = [
98 models.UniqueConstraint(
99 fields=["name"],
100 name="name_without_color_uniq",
101 condition=models.Q(color__isnull=True),
102 ),
103 ]
104
105
106 class UniqueConstraintDeferrable(models.Model):
107 name = models.CharField(max_length=255)
108 shelf = models.CharField(max_length=31)
109
110 class Meta:
111 required_db_features = {
112 "supports_deferrable_unique_constraints",
113 }
114 constraints = [
115 models.UniqueConstraint(
116 fields=["name"],
117 name="name_init_deferred_uniq",
118 deferrable=models.Deferrable.DEFERRED,
119 ),
120 models.UniqueConstraint(
121 fields=["shelf"],
122 name="sheld_init_immediate_uniq",
123 deferrable=models.Deferrable.IMMEDIATE,
124 ),
125 ]
126
127
128 class UniqueConstraintInclude(models.Model):
129 name = models.CharField(max_length=255)
130 color = models.CharField(max_length=32, null=True)
131
132 class Meta:
133 required_db_features = {
134 "supports_table_check_constraints",
135 "supports_covering_indexes",
136 }
137 constraints = [
138 models.UniqueConstraint(
139 fields=["name"],
140 name="name_include_color_uniq",
141 include=["color"],
142 ),
143 ]
144
145
146 class AbstractModel(models.Model):
147 age = models.IntegerField()
148
149 class Meta:
150 abstract = True
151 required_db_features = {
152 "supports_table_check_constraints",
153 }
154 constraints = [
155 models.CheckConstraint(
156 condition=models.Q(age__gte=18),
157 name="%(app_label)s_%(class)s_adult",
158 ),
159 ]
160
161
162 class ChildModel(AbstractModel):
163 pass
164
165
166 class JSONFieldModel(models.Model):
167 data = models.JSONField(null=True)
168
169 class Meta:
170 required_db_features = {"supports_json_field"}
171
172
173 class ModelWithDatabaseDefault(models.Model):
174 field = models.CharField(max_length=255)
175 field_with_db_default = models.CharField(
176 max_length=255, db_default=models.Value("field_with_db_default")
177 )