From 2fa5daf27d12a5f060dfc91a865078084b654bba 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 --- .../migrations/0061_auto_20190904_1440.py | 10 ++++++---- archaeological_operations/migrations/0063_parcel_uuid.py | 10 ++++++---- 2 files changed, 12 insertions(+), 8 deletions(-) (limited to 'archaeological_operations') diff --git a/archaeological_operations/migrations/0061_auto_20190904_1440.py b/archaeological_operations/migrations/0061_auto_20190904_1440.py index 3c6411c27..38a54c105 100644 --- a/archaeological_operations/migrations/0061_auto_20190904_1440.py +++ b/archaeological_operations/migrations/0061_auto_20190904_1440.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): @@ -26,8 +24,12 @@ class Migration(migrations.Migration): name='uuid', field=models.UUIDField(blank=True, null=True), ), - migrations.RunPython(set_uuid_helper('archaeological_operations', - 'Operation')), + migrations.RunSQL( + """ + CREATE EXTENSION IF NOT EXISTS "uuid-ossp"; + UPDATE archaeological_operations_operation SET uuid = uuid_generate_v1(); + """ + ), migrations.AlterField( model_name='operation', name='uuid', diff --git a/archaeological_operations/migrations/0063_parcel_uuid.py b/archaeological_operations/migrations/0063_parcel_uuid.py index 1393cff0d..3af9c34af 100644 --- a/archaeological_operations/migrations/0063_parcel_uuid.py +++ b/archaeological_operations/migrations/0063_parcel_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_operations', - 'Parcel')), + migrations.RunSQL( + """ + CREATE EXTENSION IF NOT EXISTS "uuid-ossp"; + UPDATE archaeological_operations_parcel SET uuid = uuid_generate_v1(); + """ + ), migrations.AlterField( model_name='parcel', name='uuid', -- cgit v1.2.3