summaryrefslogtreecommitdiff
path: root/tests/postgres_tests/migrations/0002_create_test_models.py
diff options
context:
space:
mode:
Diffstat (limited to 'tests/postgres_tests/migrations/0002_create_test_models.py')
-rw-r--r--tests/postgres_tests/migrations/0002_create_test_models.py535
1 files changed, 387 insertions, 148 deletions
diff --git a/tests/postgres_tests/migrations/0002_create_test_models.py b/tests/postgres_tests/migrations/0002_create_test_models.py
index 1ce875441b..dc330675fc 100644
--- a/tests/postgres_tests/migrations/0002_create_test_models.py
+++ b/tests/postgres_tests/migrations/0002_create_test_models.py
@@ -1,9 +1,18 @@
from django.db import migrations, models
from ..fields import (
- ArrayField, BigIntegerRangeField, CICharField, CIEmailField, CITextField,
- DateRangeField, DateTimeRangeField, DecimalRangeField, EnumField,
- HStoreField, IntegerRangeField, SearchVectorField,
+ ArrayField,
+ BigIntegerRangeField,
+ CICharField,
+ CIEmailField,
+ CITextField,
+ DateRangeField,
+ DateTimeRangeField,
+ DecimalRangeField,
+ EnumField,
+ HStoreField,
+ IntegerRangeField,
+ SearchVectorField,
)
from ..models import TagField
@@ -11,303 +20,533 @@ from ..models import TagField
class Migration(migrations.Migration):
dependencies = [
- ('postgres_tests', '0001_setup_extensions'),
+ ("postgres_tests", "0001_setup_extensions"),
]
operations = [
migrations.CreateModel(
- name='CharArrayModel',
+ name="CharArrayModel",
fields=[
- ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
- ('field', ArrayField(models.CharField(max_length=10), size=None)),
+ (
+ "id",
+ models.AutoField(
+ verbose_name="ID",
+ serialize=False,
+ auto_created=True,
+ primary_key=True,
+ ),
+ ),
+ ("field", ArrayField(models.CharField(max_length=10), size=None)),
],
options={
- 'required_db_vendor': 'postgresql',
+ "required_db_vendor": "postgresql",
},
bases=(models.Model,),
),
migrations.CreateModel(
- name='DateTimeArrayModel',
+ name="DateTimeArrayModel",
fields=[
- ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
- ('datetimes', ArrayField(models.DateTimeField(), size=None)),
- ('dates', ArrayField(models.DateField(), size=None)),
- ('times', ArrayField(models.TimeField(), size=None)),
+ (
+ "id",
+ models.AutoField(
+ verbose_name="ID",
+ serialize=False,
+ auto_created=True,
+ primary_key=True,
+ ),
+ ),
+ ("datetimes", ArrayField(models.DateTimeField(), size=None)),
+ ("dates", ArrayField(models.DateField(), size=None)),
+ ("times", ArrayField(models.TimeField(), size=None)),
],
options={
- 'required_db_vendor': 'postgresql',
+ "required_db_vendor": "postgresql",
},
bases=(models.Model,),
),
migrations.CreateModel(
- name='HStoreModel',
+ name="HStoreModel",
fields=[
- ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
- ('field', HStoreField(blank=True, null=True)),
- ('array_field', ArrayField(HStoreField(), null=True)),
+ (
+ "id",
+ models.AutoField(
+ verbose_name="ID",
+ serialize=False,
+ auto_created=True,
+ primary_key=True,
+ ),
+ ),
+ ("field", HStoreField(blank=True, null=True)),
+ ("array_field", ArrayField(HStoreField(), null=True)),
],
options={
- 'required_db_vendor': 'postgresql',
+ "required_db_vendor": "postgresql",
},
bases=(models.Model,),
),
migrations.CreateModel(
- name='OtherTypesArrayModel',
+ name="OtherTypesArrayModel",
fields=[
- ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
- ('ips', ArrayField(models.GenericIPAddressField(), size=None, default=list)),
- ('uuids', ArrayField(models.UUIDField(), size=None, default=list)),
- ('decimals', ArrayField(models.DecimalField(max_digits=5, decimal_places=2), size=None, default=list)),
- ('tags', ArrayField(TagField(), blank=True, null=True, size=None)),
- ('json', ArrayField(models.JSONField(default={}), default=[])),
- ('int_ranges', ArrayField(IntegerRangeField(), null=True, blank=True)),
- ('bigint_ranges', ArrayField(BigIntegerRangeField(), null=True, blank=True)),
+ (
+ "id",
+ models.AutoField(
+ verbose_name="ID",
+ serialize=False,
+ auto_created=True,
+ primary_key=True,
+ ),
+ ),
+ (
+ "ips",
+ ArrayField(models.GenericIPAddressField(), size=None, default=list),
+ ),
+ ("uuids", ArrayField(models.UUIDField(), size=None, default=list)),
+ (
+ "decimals",
+ ArrayField(
+ models.DecimalField(max_digits=5, decimal_places=2),
+ size=None,
+ default=list,
+ ),
+ ),
+ ("tags", ArrayField(TagField(), blank=True, null=True, size=None)),
+ ("json", ArrayField(models.JSONField(default={}), default=[])),
+ ("int_ranges", ArrayField(IntegerRangeField(), null=True, blank=True)),
+ (
+ "bigint_ranges",
+ ArrayField(BigIntegerRangeField(), null=True, blank=True),
+ ),
],
options={
- 'required_db_vendor': 'postgresql',
+ "required_db_vendor": "postgresql",
},
bases=(models.Model,),
),
migrations.CreateModel(
- name='IntegerArrayModel',
+ name="IntegerArrayModel",
fields=[
- ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
- ('field', ArrayField(models.IntegerField(), size=None)),
+ (
+ "id",
+ models.AutoField(
+ verbose_name="ID",
+ serialize=False,
+ auto_created=True,
+ primary_key=True,
+ ),
+ ),
+ ("field", ArrayField(models.IntegerField(), size=None)),
],
options={
- 'required_db_vendor': 'postgresql',
+ "required_db_vendor": "postgresql",
},
bases=(models.Model,),
),
migrations.CreateModel(
- name='NestedIntegerArrayModel',
+ name="NestedIntegerArrayModel",
fields=[
- ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
- ('field', ArrayField(ArrayField(models.IntegerField(), size=None), size=None)),
+ (
+ "id",
+ models.AutoField(
+ verbose_name="ID",
+ serialize=False,
+ auto_created=True,
+ primary_key=True,
+ ),
+ ),
+ (
+ "field",
+ ArrayField(ArrayField(models.IntegerField(), size=None), size=None),
+ ),
],
options={
- 'required_db_vendor': 'postgresql',
+ "required_db_vendor": "postgresql",
},
bases=(models.Model,),
),
migrations.CreateModel(
- name='NullableIntegerArrayModel',
+ name="NullableIntegerArrayModel",
fields=[
- ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
- ('field', ArrayField(models.IntegerField(), size=None, null=True, blank=True)),
(
- 'field_nested',
- ArrayField(ArrayField(models.IntegerField(), size=None, null=True), size=None, null=True),
+ "id",
+ models.AutoField(
+ verbose_name="ID",
+ serialize=False,
+ auto_created=True,
+ primary_key=True,
+ ),
),
- ('order', models.IntegerField(null=True)),
+ (
+ "field",
+ ArrayField(models.IntegerField(), size=None, null=True, blank=True),
+ ),
+ (
+ "field_nested",
+ ArrayField(
+ ArrayField(models.IntegerField(), size=None, null=True),
+ size=None,
+ null=True,
+ ),
+ ),
+ ("order", models.IntegerField(null=True)),
],
options={
- 'required_db_vendor': 'postgresql',
+ "required_db_vendor": "postgresql",
},
bases=(models.Model,),
),
migrations.CreateModel(
- name='CharFieldModel',
+ name="CharFieldModel",
fields=[
- ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
- ('field', models.CharField(max_length=64)),
+ (
+ "id",
+ models.AutoField(
+ verbose_name="ID",
+ serialize=False,
+ auto_created=True,
+ primary_key=True,
+ ),
+ ),
+ ("field", models.CharField(max_length=64)),
],
options=None,
bases=None,
),
migrations.CreateModel(
- name='TextFieldModel',
+ name="TextFieldModel",
fields=[
- ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
- ('field', models.TextField()),
+ (
+ "id",
+ models.AutoField(
+ verbose_name="ID",
+ serialize=False,
+ auto_created=True,
+ primary_key=True,
+ ),
+ ),
+ ("field", models.TextField()),
],
options=None,
bases=None,
),
migrations.CreateModel(
- name='SmallAutoFieldModel',
+ name="SmallAutoFieldModel",
fields=[
- ('id', models.SmallAutoField(verbose_name='ID', serialize=False, primary_key=True)),
+ (
+ "id",
+ models.SmallAutoField(
+ verbose_name="ID", serialize=False, primary_key=True
+ ),
+ ),
],
options=None,
),
migrations.CreateModel(
- name='BigAutoFieldModel',
+ name="BigAutoFieldModel",
fields=[
- ('id', models.BigAutoField(verbose_name='ID', serialize=False, primary_key=True)),
+ (
+ "id",
+ models.BigAutoField(
+ verbose_name="ID", serialize=False, primary_key=True
+ ),
+ ),
],
options=None,
),
migrations.CreateModel(
- name='Scene',
+ name="Scene",
fields=[
- ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
- ('scene', models.CharField(max_length=255)),
- ('setting', models.CharField(max_length=255)),
+ (
+ "id",
+ models.AutoField(
+ verbose_name="ID",
+ serialize=False,
+ auto_created=True,
+ primary_key=True,
+ ),
+ ),
+ ("scene", models.CharField(max_length=255)),
+ ("setting", models.CharField(max_length=255)),
],
options=None,
bases=None,
),
migrations.CreateModel(
- name='Character',
+ name="Character",
fields=[
- ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
- ('name', models.CharField(max_length=255)),
+ (
+ "id",
+ models.AutoField(
+ verbose_name="ID",
+ serialize=False,
+ auto_created=True,
+ primary_key=True,
+ ),
+ ),
+ ("name", models.CharField(max_length=255)),
],
options=None,
bases=None,
),
migrations.CreateModel(
- name='CITestModel',
+ name="CITestModel",
fields=[
- ('name', CICharField(primary_key=True, max_length=255)),
- ('email', CIEmailField()),
- ('description', CITextField()),
- ('array_field', ArrayField(CITextField(), null=True)),
+ ("name", CICharField(primary_key=True, max_length=255)),
+ ("email", CIEmailField()),
+ ("description", CITextField()),
+ ("array_field", ArrayField(CITextField(), null=True)),
],
options={
- 'required_db_vendor': 'postgresql',
+ "required_db_vendor": "postgresql",
},
bases=None,
),
migrations.CreateModel(
- name='Line',
+ name="Line",
fields=[
- ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
- ('scene', models.ForeignKey('postgres_tests.Scene', on_delete=models.SET_NULL)),
- ('character', models.ForeignKey('postgres_tests.Character', on_delete=models.SET_NULL)),
- ('dialogue', models.TextField(blank=True, null=True)),
- ('dialogue_search_vector', SearchVectorField(blank=True, null=True)),
- ('dialogue_config', models.CharField(max_length=100, blank=True, null=True)),
+ (
+ "id",
+ models.AutoField(
+ verbose_name="ID",
+ serialize=False,
+ auto_created=True,
+ primary_key=True,
+ ),
+ ),
+ (
+ "scene",
+ models.ForeignKey(
+ "postgres_tests.Scene", on_delete=models.SET_NULL
+ ),
+ ),
+ (
+ "character",
+ models.ForeignKey(
+ "postgres_tests.Character", on_delete=models.SET_NULL
+ ),
+ ),
+ ("dialogue", models.TextField(blank=True, null=True)),
+ ("dialogue_search_vector", SearchVectorField(blank=True, null=True)),
+ (
+ "dialogue_config",
+ models.CharField(max_length=100, blank=True, null=True),
+ ),
],
options={
- 'required_db_vendor': 'postgresql',
+ "required_db_vendor": "postgresql",
},
bases=None,
),
migrations.CreateModel(
- name='LineSavedSearch',
+ name="LineSavedSearch",
fields=[
- ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
- ('line', models.ForeignKey('postgres_tests.Line', on_delete=models.CASCADE)),
- ('query', models.CharField(max_length=100)),
+ (
+ "id",
+ models.AutoField(
+ verbose_name="ID",
+ serialize=False,
+ auto_created=True,
+ primary_key=True,
+ ),
+ ),
+ (
+ "line",
+ models.ForeignKey("postgres_tests.Line", on_delete=models.CASCADE),
+ ),
+ ("query", models.CharField(max_length=100)),
],
options={
- 'required_db_vendor': 'postgresql',
+ "required_db_vendor": "postgresql",
},
),
migrations.CreateModel(
- name='AggregateTestModel',
+ name="AggregateTestModel",
fields=[
- ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
- ('boolean_field', models.BooleanField(null=True)),
- ('char_field', models.CharField(max_length=30, blank=True)),
- ('integer_field', models.IntegerField(null=True)),
- ('json_field', models.JSONField(null=True)),
+ (
+ "id",
+ models.AutoField(
+ verbose_name="ID",
+ serialize=False,
+ auto_created=True,
+ primary_key=True,
+ ),
+ ),
+ ("boolean_field", models.BooleanField(null=True)),
+ ("char_field", models.CharField(max_length=30, blank=True)),
+ ("integer_field", models.IntegerField(null=True)),
+ ("json_field", models.JSONField(null=True)),
],
options={
- 'required_db_vendor': 'postgresql',
+ "required_db_vendor": "postgresql",
},
),
migrations.CreateModel(
- name='StatTestModel',
+ name="StatTestModel",
fields=[
- ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
- ('int1', models.IntegerField()),
- ('int2', models.IntegerField()),
- ('related_field', models.ForeignKey(
- 'postgres_tests.AggregateTestModel',
- models.SET_NULL,
- null=True,
- )),
+ (
+ "id",
+ models.AutoField(
+ verbose_name="ID",
+ serialize=False,
+ auto_created=True,
+ primary_key=True,
+ ),
+ ),
+ ("int1", models.IntegerField()),
+ ("int2", models.IntegerField()),
+ (
+ "related_field",
+ models.ForeignKey(
+ "postgres_tests.AggregateTestModel",
+ models.SET_NULL,
+ null=True,
+ ),
+ ),
],
options={
- 'required_db_vendor': 'postgresql',
+ "required_db_vendor": "postgresql",
},
),
migrations.CreateModel(
- name='NowTestModel',
+ name="NowTestModel",
fields=[
- ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
- ('when', models.DateTimeField(null=True, default=None)),
- ]
+ (
+ "id",
+ models.AutoField(
+ verbose_name="ID",
+ serialize=False,
+ auto_created=True,
+ primary_key=True,
+ ),
+ ),
+ ("when", models.DateTimeField(null=True, default=None)),
+ ],
),
migrations.CreateModel(
- name='UUIDTestModel',
+ name="UUIDTestModel",
fields=[
- ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
- ('uuid', models.UUIDField(default=None, null=True)),
- ]
+ (
+ "id",
+ models.AutoField(
+ verbose_name="ID",
+ serialize=False,
+ auto_created=True,
+ primary_key=True,
+ ),
+ ),
+ ("uuid", models.UUIDField(default=None, null=True)),
+ ],
),
migrations.CreateModel(
- name='RangesModel',
+ name="RangesModel",
fields=[
- ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
- ('ints', IntegerRangeField(null=True, blank=True)),
- ('bigints', BigIntegerRangeField(null=True, blank=True)),
- ('decimals', DecimalRangeField(null=True, blank=True)),
- ('timestamps', DateTimeRangeField(null=True, blank=True)),
- ('timestamps_inner', DateTimeRangeField(null=True, blank=True)),
- ('dates', DateRangeField(null=True, blank=True)),
- ('dates_inner', DateRangeField(null=True, blank=True)),
+ (
+ "id",
+ models.AutoField(
+ verbose_name="ID",
+ serialize=False,
+ auto_created=True,
+ primary_key=True,
+ ),
+ ),
+ ("ints", IntegerRangeField(null=True, blank=True)),
+ ("bigints", BigIntegerRangeField(null=True, blank=True)),
+ ("decimals", DecimalRangeField(null=True, blank=True)),
+ ("timestamps", DateTimeRangeField(null=True, blank=True)),
+ ("timestamps_inner", DateTimeRangeField(null=True, blank=True)),
+ ("dates", DateRangeField(null=True, blank=True)),
+ ("dates_inner", DateRangeField(null=True, blank=True)),
],
- options={
- 'required_db_vendor': 'postgresql'
- },
- bases=(models.Model,)
+ options={"required_db_vendor": "postgresql"},
+ bases=(models.Model,),
),
migrations.CreateModel(
- name='RangeLookupsModel',
+ name="RangeLookupsModel",
fields=[
- ('parent', models.ForeignKey(
- 'postgres_tests.RangesModel',
- models.SET_NULL,
- blank=True, null=True,
- )),
- ('integer', models.IntegerField(blank=True, null=True)),
- ('big_integer', models.BigIntegerField(blank=True, null=True)),
- ('float', models.FloatField(blank=True, null=True)),
- ('timestamp', models.DateTimeField(blank=True, null=True)),
- ('date', models.DateField(blank=True, null=True)),
- ('small_integer', models.SmallIntegerField(blank=True, null=True)),
- ('decimal_field', models.DecimalField(max_digits=5, decimal_places=2, blank=True, null=True)),
+ (
+ "parent",
+ models.ForeignKey(
+ "postgres_tests.RangesModel",
+ models.SET_NULL,
+ blank=True,
+ null=True,
+ ),
+ ),
+ ("integer", models.IntegerField(blank=True, null=True)),
+ ("big_integer", models.BigIntegerField(blank=True, null=True)),
+ ("float", models.FloatField(blank=True, null=True)),
+ ("timestamp", models.DateTimeField(blank=True, null=True)),
+ ("date", models.DateField(blank=True, null=True)),
+ ("small_integer", models.SmallIntegerField(blank=True, null=True)),
+ (
+ "decimal_field",
+ models.DecimalField(
+ max_digits=5, decimal_places=2, blank=True, null=True
+ ),
+ ),
],
options={
- 'required_db_vendor': 'postgresql',
+ "required_db_vendor": "postgresql",
},
bases=(models.Model,),
),
migrations.CreateModel(
- name='ArrayEnumModel',
+ name="ArrayEnumModel",
fields=[
- ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
- ('array_of_enums', ArrayField(EnumField(max_length=20), null=True, blank=True)),
+ (
+ "id",
+ models.AutoField(
+ verbose_name="ID",
+ serialize=False,
+ auto_created=True,
+ primary_key=True,
+ ),
+ ),
+ (
+ "array_of_enums",
+ ArrayField(EnumField(max_length=20), null=True, blank=True),
+ ),
],
options={
- 'required_db_vendor': 'postgresql',
+ "required_db_vendor": "postgresql",
},
bases=(models.Model,),
),
migrations.CreateModel(
- name='Room',
+ name="Room",
fields=[
- ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
- ('number', models.IntegerField(unique=True)),
+ (
+ "id",
+ models.AutoField(
+ verbose_name="ID",
+ serialize=False,
+ auto_created=True,
+ primary_key=True,
+ ),
+ ),
+ ("number", models.IntegerField(unique=True)),
],
),
migrations.CreateModel(
- name='HotelReservation',
+ name="HotelReservation",
fields=[
- ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
- ('room', models.ForeignKey('postgres_tests.Room', models.CASCADE)),
- ('datespan', DateRangeField()),
- ('start', models.DateTimeField()),
- ('end', models.DateTimeField()),
- ('cancelled', models.BooleanField(default=False)),
- ('requirements', models.JSONField(blank=True, null=True)),
+ (
+ "id",
+ models.AutoField(
+ verbose_name="ID",
+ serialize=False,
+ auto_created=True,
+ primary_key=True,
+ ),
+ ),
+ ("room", models.ForeignKey("postgres_tests.Room", models.CASCADE)),
+ ("datespan", DateRangeField()),
+ ("start", models.DateTimeField()),
+ ("end", models.DateTimeField()),
+ ("cancelled", models.BooleanField(default=False)),
+ ("requirements", models.JSONField(blank=True, null=True)),
],
options={
- 'required_db_vendor': 'postgresql',
+ "required_db_vendor": "postgresql",
},
),
]
generated by cgit v1.3 (git 2.53.0) at 2026-05-02 00:20:31 +0000