class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
CreateExtension('postgis'),
CreateExtension('postgis_topology'),
CreateExtension('fuzzystrmatch'),
CreateExtension('postgis_tiger_geocoder'),
]
class Migration(migrations.Migration):
dependencies = [
('user', '0003_auto_20171016_1028'),
]
operations = [
CreateExtension('pg_trgm'),
CreateExtension('postgis'),
]
def test_drop_nonexistent_extension(self):
operation = CreateExtension('tablefunc')
project_state = ProjectState()
new_state = project_state.clone()
# Don't drop a nonexistent extension.
with CaptureQueriesContext(connection) as captured_queries:
with connection.schema_editor(atomic=False) as editor:
operation.database_backwards(self.app_label, editor,
project_state, new_state)
self.assertEqual(len(captured_queries), 1)
self.assertIn('SELECT', captured_queries[0]['sql'])
class Migration(migrations.Migration):
dependencies = [
('plant_database', '0002_auto_20190501_2109'),
]
operations = [
CreateExtension('postgis'),
CreateExtension('pgrouting'),
CreateExtension('postgis_topology'),
CreateExtension('fuzzystrmatch'),
CreateExtension('postgis_tiger_geocoder'),
]
class Migration(migrations.Migration):
dependencies = [
('rental', '0005_add_more_building_type'),
]
operations = [
CreateExtension('postgis'),
migrations.RemoveField(
model_name='house',
name='rough_gps',
),
migrations.RemoveField(
model_name='housets',
name='rough_gps',
),
migrations.AddField(
model_name='house',
name='rough_coordinate',
field=django.contrib.gis.db.models.fields.PointField(null=True,
srid=4326),
),
migrations.AddField(
model_name='housets',
name='rough_coordinate',
field=django.contrib.gis.db.models.fields.PointField(null=True,
srid=4326),
),
]
class Migration(migrations.Migration):
dependencies = []
operations = [
CreateExtension('pgcrypto'),
]
class Migration(migrations.Migration):
dependencies = [
("base", "0090_entity_date_created"),
]
operations = [
CreateExtension("btree_gin"),
TrigramExtension(),
migrations.AddField(
model_name="translation",
name="entity_document",
field=django.db.models.fields.TextField(blank=True),
),
migrations.RunSQL(
entity_document_update_sql,
migrations.RunSQL.noop,
),
migrations.RunSQL(
entity_document_update_trigger_create_sql,
entity_document_update_trigger_drop_sql,
),
MultiFieldTRGMIndex(
table="base_translation",
from_fields=["entity_document", "string"],
field="entity_document",
),
]
class Migration(migrations.Migration):
dependencies = [
("core", "0006_abstract_index"),
]
operations = [CreateExtension("ltree")]
class Migration(migrations.Migration):
dependencies = [
('sites', '0003_set_site_domain_and_name'),
]
operations = [CreateExtension('postgis')]
class Migration(migrations.Migration):
dependencies = []
operations = [
CreateExtension('postgis'),
]
class Migration(migrations.Migration):
dependencies = [
('api', '0074_auto_20200701_0939'),
]
operations = [
CreateExtension('postgis'),
migrations.AddField(
model_name='country',
name='bbox',
field=django.contrib.gis.db.models.fields.PolygonField(blank=True,
null=True,
srid=4326),
),
migrations.AddField(
model_name='country',
name='centroid',
field=django.contrib.gis.db.models.fields.PointField(blank=True,
null=True,
srid=4326),
),
migrations.AddField(
model_name='country',
name='geom',
field=django.contrib.gis.db.models.fields.MultiPolygonField(
blank=True, null=True, srid=4326),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
CreateExtension('postgis'),
migrations.CreateModel(
name='Customer',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('first_name', models.CharField(max_length=200, null=True)),
('last_name', models.CharField(max_length=200, null=True)),
('email', models.CharField(max_length=200, null=True)),
('date_created', models.DateTimeField(auto_now_add=True, null=True)),
('phone', models.CharField(max_length=12, null=True)),
('gender',
models.CharField(choices=[('Male', 'Male'), ('Female', 'Female'), ('Other', 'Other')], max_length=100,
null=True)),
('age', models.CharField(max_length=200, null=True)),
('profile_pic', models.ImageField(blank=True, default='profile_aBGztjN.png', null=True, upload_to='')),
('user', models.OneToOneField(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
]
class Migration(migrations.Migration):
dependencies = [
('airmozilla', '0002_auto_20180412_2227'),
]
operations = [
CreateExtension('unaccent'),
migrations.RunSQL(
"""
CREATE TEXT SEARCH CONFIGURATION english_unaccent (COPY = english);
ALTER TEXT SEARCH CONFIGURATION english_unaccent
ALTER MAPPING FOR hword, hword_part, word
WITH unaccent, english_stem;
""", """
DROP TEXT SEARCH CONFIGURATION english_unaccent;
"""),
migrations.AddField(
model_name='event',
name='fulltext',
field=django.contrib.postgres.search.SearchVectorField(default=''),
preserve_default=False,
),
migrations.AddIndex(
model_name='event',
index=django.contrib.postgres.indexes.GinIndex(
fields=['fulltext'], name='airmozilla__fulltex_fa87ab_gin'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
CreateExtension('postgis'),
migrations.CreateModel(
name='Coordinate',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('validation', models.BooleanField(default=True)),
('name',
models.CharField(blank=True, default='noname',
max_length=50)),
('rotation', models.FloatField()),
('geometry',
django.contrib.gis.db.models.fields.PointField(
default='SRID=3857;POINT(0.0 0.0)', srid=4326)),
],
),
]
class Migration(migrations.Migration):
dependencies = [
('base', '0090_entity_date_created'),
]
operations = [
CreateExtension('btree_gin'),
TrigramExtension(),
migrations.AddField(
model_name='translation',
name='entity_document',
field=django.db.models.fields.TextField(blank=True)),
migrations.RunSQL(
entity_document_update_sql,
migrations.RunSQL.noop,
),
migrations.RunSQL(
entity_document_update_trigger_create_sql,
entity_document_update_trigger_drop_sql,
),
MultiFieldTRGMIndex(table='base_translation',
from_fields=['entity_document', 'string'],
field='entity_document'),
]
class Migration(migrations.Migration):
dependencies = [
('busshaming', '0009_stop_position'),
]
operations = [
CreateExtension('uuid-ossp'),
migrations.CreateModel(
name='RealtimeEntry',
fields=[
('id',
models.UUIDField(default=uuid.uuid4,
primary_key=True,
serialize=False)),
('sequence', models.IntegerField()),
('arrival_time', models.DateTimeField()),
('arrival_delay', models.SmallIntegerField()),
('departure_time', models.DateTimeField()),
('departure_delay', models.SmallIntegerField()),
('stop',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='busshaming.Stop')),
('trip_date',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='busshaming.TripDate')),
],
),
migrations.AlterUniqueTogether(
name='realtimeentry',
unique_together=set([('trip_date', 'stop')]),
),
]
class Migration(migrations.Migration):
dependencies = [
('web', '0048_auto_20200709_1116'),
]
operations = [
CreateExtension('postgis'),
]
class Migration(migrations.Migration):
# PostGIS 3+ requires postgis_raster extension.
if pg_version[1:] >= (3, ):
operations = [
CreateExtension("postgis_raster"),
]
else:
operations = []
class Migration(migrations.Migration):
dependencies = [('auth', '0001_initial')]
operations = [
CreateExtension('postgis'),
migrations.RunPython(create_superuser)
]
class Migration(migrations.Migration):
dependencies = [
('AndroidRequests', '0906_transformation_20161102_1526'),
]
operations = [
CreateExtension('postgis'),
]
class Migration(migrations.Migration):
dependencies = [
('core', '0019_importerlog_king'),
]
operations = [
CreateExtension('unaccent'),
]
class Migration(migrations.Migration):
dependencies = [
('airport', '0005_auto_20181019_1900'),
]
operations = [
CreateExtension('postgis')
]
class Migration(migrations.Migration):
dependencies = [
('core_auth', '0004_auto_20180123_1602'),
]
operations = [
CreateExtension('postgis'),
]
class Migration(migrations.Migration):
dependencies = [
('tracking', '0001_initial'),
]
operations = [
CreateExtension('postgis'),
]
class Migration(migrations.Migration):
dependencies = [
('core', '0004_cities'),
]
operations = [
CreateExtension('postgis'),
]
class Migration(migrations.Migration):
dependencies = [
('climateconnect_api', '0043_merge_20201211_0751'),
]
operations = [
CreateExtension('postgis'),
]
class Migration(migrations.Migration):
operations = [
# Ensure CreateExtension quotes extension names by creating one with a
# dash in its name.
CreateExtension('uuid-ossp'),
HStoreExtension(),
UnaccentExtension(),
]
class Migration(migrations.Migration):
dependencies = [
('JON', '0033_auto_20170814_1252'),
]
operations = [
CreateExtension('postgis'),
]
class Migration(migrations.Migration):
'''
Our initial migration turns on extensions. Tables are created in the next migration.
'''
initial = True
dependencies = []
operations = [
CreateExtension('postgis'),
HStoreExtension(),
]
class Migration(migrations.Migration):
operations = [
BtreeGinExtension(),
CITextExtension(),
# Ensure CreateExtension quotes extension names by creating one with a
# dash in its name.
CreateExtension('uuid-ossp'),
CryptoExtension(),
HStoreExtension(),
TrigramExtension(),
UnaccentExtension(),
]
