| 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() |