From d9fcd45a713ba35f4e56230313e752738da93534 Mon Sep 17 00:00:00 2001 From: Étienne Loks Date: Mon, 7 Aug 2023 11:20:35 +0200 Subject: 🗃️ fix migration script (warehouse - precise_town_id) MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- .../migrations/0118_auto_20230807_1106.py | 53 ++++++++++++++++++++++ 1 file changed, 53 insertions(+) create mode 100644 archaeological_warehouse/migrations/0118_auto_20230807_1106.py diff --git a/archaeological_warehouse/migrations/0118_auto_20230807_1106.py b/archaeological_warehouse/migrations/0118_auto_20230807_1106.py new file mode 100644 index 000000000..de3ae7139 --- /dev/null +++ b/archaeological_warehouse/migrations/0118_auto_20230807_1106.py @@ -0,0 +1,53 @@ +# Generated by Django 2.2.24 on 2023-08-07 11:06 + +from django.db import migrations, models + + +COPY_HISTORICALWAREHOUSE = """ +UPDATE archaeological_warehouse_historicalwarehouse +SET precise_town_id2 = precise_town_id +""" +COPY_WAREHOUSE = """ +UPDATE archaeological_warehouse_warehouse +SET precise_town_id2 = precise_town_id +""" + + +class Migration(migrations.Migration): + + dependencies = [ + ('archaeological_warehouse', '0117_migrate_created'), + ] + + operations = [ + migrations.AddField( + model_name='historicalwarehouse', + name='precise_town_id2', + field=models.PositiveIntegerField(blank=True, null=True, verbose_name='Town (precise)'), + ), + migrations.AddField( + model_name='warehouse', + name='precise_town_id2', + field=models.PositiveIntegerField(blank=True, null=True, verbose_name='Town (precise)'), + ), + migrations.RunSQL(COPY_WAREHOUSE), + migrations.RunSQL(COPY_HISTORICALWAREHOUSE), + migrations.RemoveField( + model_name='historicalwarehouse', + name='precise_town', + ), + migrations.RemoveField( + model_name='warehouse', + name='precise_town', + ), + migrations.RenameField( + model_name='historicalwarehouse', + old_name='precise_town_id2', + new_name='precise_town_id', + ), + migrations.RenameField( + model_name='warehouse', + old_name='precise_town_id2', + new_name='precise_town_id', + ), + ] -- cgit v1.2.3