From a27b447ae2c9afc73078dd9aedd7709145e1d537 Mon Sep 17 00:00:00 2001 From: Étienne Loks Date: Thu, 8 Jun 2023 14:31:50 +0200 Subject: ✨ models: default round and round z for each spatial reference system - 🐛 fix precise_town_id migration MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- .../migrations/0229_auto_20230608_1303.py | 101 +++++++++++++++++++++ 1 file changed, 101 insertions(+) create mode 100644 ishtar_common/migrations/0229_auto_20230608_1303.py (limited to 'ishtar_common/migrations') diff --git a/ishtar_common/migrations/0229_auto_20230608_1303.py b/ishtar_common/migrations/0229_auto_20230608_1303.py new file mode 100644 index 000000000..c33a42238 --- /dev/null +++ b/ishtar_common/migrations/0229_auto_20230608_1303.py @@ -0,0 +1,101 @@ +# Generated by Django 2.2.24 on 2023-06-08 13:03 + +from django.db import migrations, models + + +COPY_HISTORICALORGANIZATION = """ +UPDATE ishtar_common_historicalorganization +SET precise_town_id2 = precise_town_id +""" +COPY_ORGANIZATION = """ +UPDATE ishtar_common_organization +SET precise_town_id2 = precise_town_id +""" +COPY_HISTORICALPERSON = """ +UPDATE ishtar_common_historicalperson +SET precise_town_id2 = precise_town_id +""" +COPY_PERSON = """ +UPDATE ishtar_common_person +SET precise_town_id2 = precise_town_id +""" + + +class Migration(migrations.Migration): + + dependencies = [ + ('ishtar_common', '0228_auto_20230418_1622'), + ] + + operations = [ + migrations.AddField( + model_name='historicalorganization', + name='precise_town_id2', + field=models.PositiveIntegerField(blank=True, null=True, verbose_name='Town (precise)'), + ), + migrations.AddField( + model_name='historicalperson', + name='precise_town_id2', + field=models.PositiveIntegerField(blank=True, null=True, verbose_name='Town (precise)'), + ), + migrations.AddField( + model_name='organization', + name='precise_town_id2', + field=models.PositiveIntegerField(blank=True, null=True, verbose_name='Town (precise)'), + ), + migrations.AddField( + model_name='person', + name='precise_town_id2', + field=models.PositiveIntegerField(blank=True, null=True, verbose_name='Town (precise)'), + ), + migrations.RunSQL(COPY_PERSON), + migrations.RunSQL(COPY_HISTORICALPERSON), + migrations.RunSQL(COPY_ORGANIZATION), + migrations.RunSQL(COPY_HISTORICALORGANIZATION), + migrations.RemoveField( + model_name='historicalorganization', + name='precise_town', + ), + migrations.RemoveField( + model_name='historicalperson', + name='precise_town', + ), + migrations.RemoveField( + model_name='organization', + name='precise_town', + ), + migrations.RemoveField( + model_name='person', + name='precise_town', + ), + migrations.RenameField( + model_name='historicalorganization', + old_name='precise_town_id2', + new_name='precise_town_id' + ), + migrations.RenameField( + model_name='historicalperson', + old_name='precise_town_id2', + new_name='precise_town_id' + ), + migrations.RenameField( + model_name='organization', + old_name='precise_town_id2', + new_name='precise_town_id' + ), + migrations.RenameField( + model_name='person', + old_name='precise_town_id2', + new_name='precise_town_id' + ), + migrations.AddField( + model_name='spatialreferencesystem', + name='round', + field=models.IntegerField(default=5, verbose_name='Number of decimal places'), + ), + migrations.AddField( + model_name='spatialreferencesystem', + name='round_z', + field=models.IntegerField(default=3, verbose_name='Number of decimal places for Z'), + ), + ] -- cgit v1.2.3