Debian Codegraph @

tests/postgres_tests/models.py

raw
1 from django.db import models
2
3 from .fields import (
4 ArrayField,
5 BigIntegerRangeField,
6 DateRangeField,
7 DateTimeRangeField,
8 DecimalRangeField,
9 EnumField,
10 HStoreField,
11 IntegerRangeField,
12 OffByOneField,
13 SearchVectorField,
14 )
15
16
17 class Tag:
18 def __init__(self, tag_id):
19 self.tag_id = tag_id
20
21 def __eq__(self, other):
22 return isinstance(other, Tag) and self.tag_id == other.tag_id
23
24
25 class TagField(models.SmallIntegerField):
26 def from_db_value(self, value, expression, connection):
27 if value is None:
28 return value
29 return Tag(int(value))
30
31 def to_python(self, value):
32 if isinstance(value, Tag):
33 return value
34 if value is None:
35 return value
36 return Tag(int(value))
37
38 def get_prep_value(self, value):
39 return value.tag_id
40
41
42 class PostgreSQLModel(models.Model):
43 class Meta:
44 abstract = True
45 required_db_vendor = "postgresql"
46
47
48 class IntegerArrayModel(PostgreSQLModel):
49 field = ArrayField(models.IntegerField(), default=list, blank=True)
50
51
52 class NullableIntegerArrayModel(PostgreSQLModel):
53 field = ArrayField(models.IntegerField(), blank=True, null=True)
54 field_nested = ArrayField(ArrayField(models.IntegerField(null=True)), null=True)
55 order = models.IntegerField(null=True)
56
57
58 class CharArrayModel(PostgreSQLModel):
59 field = ArrayField(models.CharField(max_length=10))
60
61
62 class DateTimeArrayModel(PostgreSQLModel):
63 datetimes = ArrayField(models.DateTimeField())
64 dates = ArrayField(models.DateField())
65 times = ArrayField(models.TimeField())
66
67
68 class WithSizeArrayModel(PostgreSQLModel):
69 field = ArrayField(models.FloatField(), size=3)
70
71
72 class NestedIntegerArrayModel(PostgreSQLModel):
73 field = ArrayField(ArrayField(models.IntegerField()))
74
75
76 class OtherTypesArrayModel(PostgreSQLModel):
77 ips = ArrayField(models.GenericIPAddressField(), default=list)
78 uuids = ArrayField(models.UUIDField(), default=list)
79 decimals = ArrayField(
80 models.DecimalField(max_digits=5, decimal_places=2), default=list
81 )
82 tags = ArrayField(TagField(), blank=True, null=True)
83 json = ArrayField(models.JSONField(default=dict), default=list)
84 int_ranges = ArrayField(IntegerRangeField(), blank=True, null=True)
85 bigint_ranges = ArrayField(BigIntegerRangeField(), blank=True, null=True)
86
87
88 class HStoreModel(PostgreSQLModel):
89 field = HStoreField(blank=True, null=True)
90 array_field = ArrayField(HStoreField(), null=True)
91
92
93 class ArrayEnumModel(PostgreSQLModel):
94 array_of_enums = ArrayField(EnumField(max_length=20))
95
96
97 class CharFieldModel(models.Model):
98 field = models.CharField(max_length=64)
99
100
101 class TextFieldModel(models.Model):
102 field = models.TextField()
103
104
105 class SmallAutoFieldModel(models.Model):
106 id = models.SmallAutoField(primary_key=True)
107
108
109 class BigAutoFieldModel(models.Model):
110 id = models.BigAutoField(primary_key=True)
111
112
113 # Scene/Character/Line models are used to test full text search. They're
114 # populated with content from Monty Python and the Holy Grail.
115 class Scene(models.Model):
116 scene = models.TextField()
117 setting = models.CharField(max_length=255)
118
119
120 class Character(models.Model):
121 name = models.CharField(max_length=255)
122
123
124 class Line(PostgreSQLModel):
125 scene = models.ForeignKey("Scene", models.CASCADE)
126 character = models.ForeignKey("Character", models.CASCADE)
127 dialogue = models.TextField(blank=True, null=True)
128 dialogue_search_vector = SearchVectorField(blank=True, null=True)
129 dialogue_config = models.CharField(max_length=100, blank=True, null=True)
130
131
132 class LineSavedSearch(PostgreSQLModel):
133 line = models.ForeignKey("Line", models.CASCADE)
134 query = models.CharField(max_length=100)
135
136
137 class RangesModel(PostgreSQLModel):
138 ints = IntegerRangeField(blank=True, null=True, db_default=(5, 10))
139 bigints = BigIntegerRangeField(blank=True, null=True)
140 decimals = DecimalRangeField(blank=True, null=True)
141 timestamps = DateTimeRangeField(blank=True, null=True)
142 timestamps_inner = DateTimeRangeField(blank=True, null=True)
143 timestamps_closed_bounds = DateTimeRangeField(
144 blank=True,
145 null=True,
146 default_bounds="[]",
147 )
148 dates = DateRangeField(blank=True, null=True)
149 dates_inner = DateRangeField(blank=True, null=True)
150
151
152 class RangeLookupsModel(PostgreSQLModel):
153 parent = models.ForeignKey(RangesModel, models.SET_NULL, blank=True, null=True)
154 integer = models.IntegerField(blank=True, null=True)
155 big_integer = models.BigIntegerField(blank=True, null=True)
156 float = models.FloatField(blank=True, null=True)
157 timestamp = models.DateTimeField(blank=True, null=True)
158 date = models.DateField(blank=True, null=True)
159 small_integer = models.SmallIntegerField(blank=True, null=True)
160 decimal_field = models.DecimalField(
161 max_digits=5, decimal_places=2, blank=True, null=True
162 )
163
164
165 class ArrayFieldSubclass(ArrayField):
166 def __init__(self, *args, **kwargs):
167 super().__init__(models.IntegerField())
168
169
170 class AggregateTestModel(PostgreSQLModel):
171 """
172 To test postgres-specific general aggregation functions
173 """
174
175 char_field = models.CharField(max_length=30, blank=True)
176 text_field = models.TextField(blank=True)
177 integer_field = models.IntegerField(null=True)
178 boolean_field = models.BooleanField(null=True)
179 json_field = models.JSONField(null=True)
180
181
182 class StatTestModel(PostgreSQLModel):
183 """
184 To test postgres-specific aggregation functions for statistics
185 """
186
187 int1 = models.IntegerField()
188 int2 = models.IntegerField()
189 related_field = models.ForeignKey(AggregateTestModel, models.SET_NULL, null=True)
190
191
192 class NowTestModel(models.Model):
193 when = models.DateTimeField(null=True, default=None)
194
195
196 class UUIDTestModel(models.Model):
197 uuid = models.UUIDField(default=None, null=True)
198
199
200 class Room(models.Model):
201 number = models.IntegerField(unique=True)
202
203
204 class HotelReservation(PostgreSQLModel):
205 room = models.ForeignKey("Room", on_delete=models.CASCADE)
206 datespan = DateRangeField()
207 start = models.DateTimeField()
208 end = models.DateTimeField()
209 cancelled = models.BooleanField(default=False)
210 requirements = models.JSONField(blank=True, null=True)
211
212
213 class OffByOneModel(PostgreSQLModel):
214 one_off = OffByOneField()