From dd9915cbc67c1f33b94747f0fd4f072a6abe01d8 Mon Sep 17 00:00:00 2001 From: Étienne Loks Date: Thu, 12 Sep 2019 18:33:00 +0200 Subject: Optimize UUID migration -> use postgresql uuid gen --- archaeological_finds/migrations/0070_auto_20190904_1807.py | 13 +++++++------ archaeological_finds/migrations/0071_findbasket_uuid.py | 10 ++++++---- 2 files changed, 13 insertions(+), 10 deletions(-) (limited to 'archaeological_finds') diff --git a/archaeological_finds/migrations/0070_auto_20190904_1807.py b/archaeological_finds/migrations/0070_auto_20190904_1807.py index 0accfe82c..af7a167b8 100644 --- a/archaeological_finds/migrations/0070_auto_20190904_1807.py +++ b/archaeological_finds/migrations/0070_auto_20190904_1807.py @@ -6,8 +6,6 @@ import uuid from django.db import migrations, models -from ishtar_common.utils_migrations import set_uuid_helper - class Migration(migrations.Migration): @@ -36,10 +34,13 @@ class Migration(migrations.Migration): name='uuid', field=models.UUIDField(default=uuid.uuid4), ), - migrations.RunPython(set_uuid_helper('archaeological_finds', - 'BaseFind')), - migrations.RunPython(set_uuid_helper('archaeological_finds', - 'Find')), + migrations.RunSQL( + """ + CREATE EXTENSION IF NOT EXISTS "uuid-ossp"; + UPDATE archaeological_finds_basefind SET uuid = uuid_generate_v1(); + UPDATE archaeological_finds_find SET uuid = uuid_generate_v1(); + """ + ), migrations.AlterField( model_name='basefind', name='uuid', diff --git a/archaeological_finds/migrations/0071_findbasket_uuid.py b/archaeological_finds/migrations/0071_findbasket_uuid.py index 2098dfa02..0320d84c8 100644 --- a/archaeological_finds/migrations/0071_findbasket_uuid.py +++ b/archaeological_finds/migrations/0071_findbasket_uuid.py @@ -6,8 +6,6 @@ import uuid from django.db import migrations, models -from ishtar_common.utils_migrations import set_uuid_helper - class Migration(migrations.Migration): @@ -21,8 +19,12 @@ class Migration(migrations.Migration): name='uuid', field=models.UUIDField(blank=True, null=True), ), - migrations.RunPython(set_uuid_helper('archaeological_finds', - 'FindBasket')), + migrations.RunSQL( + """ + CREATE EXTENSION IF NOT EXISTS "uuid-ossp"; + UPDATE archaeological_finds_findbasket SET uuid = uuid_generate_v1(); + """ + ), migrations.AlterField( model_name='findbasket', name='uuid', -- cgit v1.2.3