From 55e02abfe37176a7dff42900794dc93f481da5bb Mon Sep 17 00:00:00 2001 From: Étienne Loks Date: Mon, 25 Aug 2025 12:27:29 +0200 Subject: ✨ finds: change donor to m2m MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- .../migrations/0138_donor_to_donors.py | 36 ++++++++++++++++++++++ 1 file changed, 36 insertions(+) create mode 100644 archaeological_finds/migrations/0138_donor_to_donors.py (limited to 'archaeological_finds/migrations') diff --git a/archaeological_finds/migrations/0138_donor_to_donors.py b/archaeological_finds/migrations/0138_donor_to_donors.py new file mode 100644 index 000000000..24ecf65d1 --- /dev/null +++ b/archaeological_finds/migrations/0138_donor_to_donors.py @@ -0,0 +1,36 @@ +# Generated by Django 2.2.24 on 2025-08-25 10:14 + +from django.db import migrations, models + + +SQL_MIGRATE = """ +INSERT INTO archaeological_finds_find_museum_donors + (find_id, biographicalnote_id) + SELECT id, museum_donor_id FROM archaeological_finds_find + WHERE museum_donor_id IS NOT NULL; +""" + + +class Migration(migrations.Migration): + + dependencies = [ + ('ishtar_common', '0263_media_exporter'), + ('archaeological_finds', '0137_data_migration_treatment_status_inputstatus'), + ] + + operations = [ + migrations.AddField( + model_name='find', + name='museum_donors', + field=models.ManyToManyField(blank=True, related_name='finds_donors', to='ishtar_common.BiographicalNote', verbose_name='Donors, testators or vendors'), + ), + migrations.RunSQL(SQL_MIGRATE), + migrations.RemoveField( + model_name='find', + name='museum_donor', + ), + migrations.RemoveField( + model_name='historicalfind', + name='museum_donor', + ), + ] -- cgit v1.2.3