Debian Codegraph @

tests/inspectdb/models.py

raw
1 from django.db import connection, models
2 from django.db.models.functions import Lower
3 from django.utils.functional import SimpleLazyObject
4
5
6 class People(models.Model):
7 name = models.CharField(max_length=255)
8 parent = models.ForeignKey("self", models.CASCADE)
9
10
11 class Message(models.Model):
12 from_field = models.ForeignKey(People, models.CASCADE, db_column="from_id")
13 author = models.ForeignKey(People, models.CASCADE, related_name="message_authors")
14
15
16 class PeopleData(models.Model):
17 people_pk = models.ForeignKey(People, models.CASCADE, primary_key=True)
18 ssn = models.CharField(max_length=11)
19
20
21 class PeopleMoreData(models.Model):
22 people_unique = models.ForeignKey(People, models.CASCADE, unique=True)
23 message = models.ForeignKey(Message, models.CASCADE, blank=True, null=True)
24 license = models.CharField(max_length=255)
25
26
27 class ForeignKeyToField(models.Model):
28 to_field_fk = models.ForeignKey(
29 PeopleMoreData,
30 models.CASCADE,
31 to_field="people_unique",
32 )
33
34
35 class DigitsInColumnName(models.Model):
36 all_digits = models.CharField(max_length=11, db_column="123")
37 leading_digit = models.CharField(max_length=11, db_column="4extra")
38 leading_digits = models.CharField(max_length=11, db_column="45extra")
39
40
41 class SpecialName(models.Model):
42 field = models.IntegerField(db_column="field")
43 # Underscores
44 field_field_0 = models.IntegerField(db_column="Field_")
45 field_field_1 = models.IntegerField(db_column="Field__")
46 field_field_2 = models.IntegerField(db_column="__field")
47 # Other chars
48 prc_x = models.IntegerField(db_column="prc(%) x")
49 non_ascii = models.IntegerField(db_column="tamaƱo")
50
51 class Meta:
52 db_table = "inspectdb_special.table name"
53
54
55 class PascalCaseName(models.Model):
56 class Meta:
57 db_table = "inspectdb_pascal.PascalCase"
58
59
60 class ColumnTypes(models.Model):
61 id = models.AutoField(primary_key=True)
62 big_int_field = models.BigIntegerField()
63 bool_field = models.BooleanField(default=False)
64 null_bool_field = models.BooleanField(null=True)
65 char_field = models.CharField(max_length=10)
66 null_char_field = models.CharField(max_length=10, blank=True, null=True)
67 date_field = models.DateField()
68 date_time_field = models.DateTimeField()
69 decimal_field = models.DecimalField(max_digits=6, decimal_places=1)
70 email_field = models.EmailField()
71 file_field = models.FileField(upload_to="unused")
72 file_path_field = models.FilePathField()
73 float_field = models.FloatField()
74 int_field = models.IntegerField()
75 gen_ip_address_field = models.GenericIPAddressField(protocol="ipv4")
76 pos_big_int_field = models.PositiveBigIntegerField()
77 pos_int_field = models.PositiveIntegerField()
78 pos_small_int_field = models.PositiveSmallIntegerField()
79 slug_field = models.SlugField()
80 small_int_field = models.SmallIntegerField()
81 text_field = models.TextField()
82 time_field = models.TimeField()
83 url_field = models.URLField()
84 uuid_field = models.UUIDField()
85
86
87 class JSONFieldColumnType(models.Model):
88 json_field = models.JSONField()
89 null_json_field = models.JSONField(blank=True, null=True)
90
91 class Meta:
92 required_db_features = {
93 "can_introspect_json_field",
94 "supports_json_field",
95 }
96
97
98 test_collation = SimpleLazyObject(
99 lambda: connection.features.test_collations.get("non_default")
100 )
101
102
103 class CharFieldDbCollation(models.Model):
104 char_field = models.CharField(max_length=10, db_collation=test_collation)
105
106 class Meta:
107 required_db_features = {"supports_collation_on_charfield"}
108
109
110 class TextFieldDbCollation(models.Model):
111 text_field = models.TextField(db_collation=test_collation)
112
113 class Meta:
114 required_db_features = {"supports_collation_on_textfield"}
115
116
117 class CharFieldUnlimited(models.Model):
118 char_field = models.CharField(max_length=None)
119
120 class Meta:
121 required_db_features = {"supports_unlimited_charfield"}
122
123
124 class UniqueTogether(models.Model):
125 field1 = models.IntegerField()
126 field2 = models.CharField(max_length=10)
127 from_field = models.IntegerField(db_column="from")
128 non_unique = models.IntegerField(db_column="non__unique_column")
129 non_unique_0 = models.IntegerField(db_column="non_unique__column")
130
131 class Meta:
132 unique_together = [
133 ("field1", "field2"),
134 ("from_field", "field1"),
135 ("non_unique", "non_unique_0"),
136 ]
137
138
139 class FuncUniqueConstraint(models.Model):
140 name = models.CharField(max_length=255)
141 rank = models.IntegerField()
142
143 class Meta:
144 constraints = [
145 models.UniqueConstraint(
146 Lower("name"), models.F("rank"), name="index_lower_name"
147 )
148 ]
149 required_db_features = {"supports_expression_indexes"}
150
151
152 class DbComment(models.Model):
153 rank = models.IntegerField(db_comment="'Rank' column comment")
154
155 class Meta:
156 db_table_comment = "Custom table comment"
157 required_db_features = {"supports_comments"}
158
159
160 class CompositePKModel(models.Model):
161 pk = models.CompositePrimaryKey("column_1", "column_2")
162 column_1 = models.IntegerField()
163 column_2 = models.IntegerField()