New migrations: add views

2 files changed, 19 insertions, 1 deletions

diff --git a/archaeological_context_records/migrations/0004_views.py b/archaeological_context_records/migrations/0004_views.py
new file mode 100644
index 000000000..d34b9e62b
--- /dev/null
+++ b/archaeological_context_records/migrations/0004_views.py
@@ -0,0 +1,15 @@
+# -*- coding: utf-8 -*-
+from __future__ import unicode_literals
+
+from django.db import models, migrations
+from archaeological_context_records.models import  RecordRelationView
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('archaeological_context_records', '0003_auto_20170414_2123'),
+    ]
+
+    operations = [
+        migrations.RunSQL(RecordRelationView.CREATE_SQL)
+    ]
diff --git a/archaeological_context_records/models.py b/archaeological_context_records/models.py
index 3fdc04f21..0a5ab7cbc 100644
--- a/archaeological_context_records/models.py
+++ b/archaeological_context_records/models.py
@@ -545,7 +545,7 @@ post_delete.connect(post_delete_record_relation, sender=RecordRelations)
 
 
 class RecordRelationView(models.Model):
-    """
+    CREATE_SQL = """
     CREATE VIEW record_relations AS
         SELECT DISTINCT right_record_id as id,
             right_record_id,
@@ -557,6 +557,9 @@ class RecordRelationView(models.Model):
     CREATE RULE record_relations_del AS ON DELETE TO record_relations
         DO INSTEAD DELETE FROM record_relations where id=NULL;
     """
+    DELETE_SQL = """
+        DROP VIEW record_relations;
+    """
     TABLE_COLS = [
         "relation_type",
         "right_record__label", "right_record__unit", "right_record__parcel",