Migration: for transaction to separe data and schema changes

1 files changed, 3 insertions, 1 deletions

diff --git a/archaeological_warehouse/migrations/0021_auto__chg_field_container_responsible.py b/archaeological_warehouse/migrations/0021_auto__chg_field_container_responsible.py
index 15c8ae7f9..65df3991b 100644
--- a/archaeological_warehouse/migrations/0021_auto__chg_field_container_responsible.py
+++ b/archaeological_warehouse/migrations/0021_auto__chg_field_container_responsible.py
@@ -8,8 +8,10 @@ from django.db import models
 class Migration(SchemaMigration):
 
     def forwards(self, orm):
+        db.start_transaction()
         sql = "update archaeological_warehouse_container set responsible_id = location_id;"
         db.execute(sql)
+        db.commit_transaction()
         # Changing field 'Container.responsible'
         db.alter_column('archaeological_warehouse_container', 'responsible_id', self.gf('django.db.models.fields.related.ForeignKey')(default=1, to=orm['archaeological_warehouse.Warehouse']))
 
@@ -293,4 +295,4 @@ class Migration(SchemaMigration):
         }
     }
 
-    complete_apps = ['archaeological_warehouse']
\ No newline at end of file
+    complete_apps = ['archaeological_warehouse']