New migrations: add views

1 files changed, 17 insertions, 1 deletions

diff --git a/archaeological_operations/models.py b/archaeological_operations/models.py
index bebeba240..0548c92e4 100644
--- a/archaeological_operations/models.py
+++ b/archaeological_operations/models.py
@@ -1,6 +1,6 @@
 #!/usr/bin/env python
 # -*- coding: utf-8 -*-
-# Copyright (C) 2012-2016 Étienne Loks  <etienne.loks_AT_peacefrogsDOTnet>
+# Copyright (C) 2012-2017 Étienne Loks  <etienne.loks_AT_peacefrogsDOTnet>
 
 # This program is free software: you can redistribute it and/or modify
 # it under the terms of the GNU Affero General Public License as
@@ -844,6 +844,22 @@ class OperationByDepartment(models.Model):
     """
     Database view for dashboard
     """
+    CREATE_SQL = """
+    CREATE VIEW operation_department (id, department_id, operation_id) as
+        select town."id", town."departement_id",
+               operation_towns."operation_id"
+                from ishtar_common_town town
+                inner join archaeological_operations_operation_towns
+                           operation_towns
+                    on operation_towns."town_id"=town."id"
+                order by town."departement_id";
+    CREATE RULE operation_department_delete
+              AS ON DELETE TO operation_department DO INSTEAD();
+    """
+    DELETE_SQL = """
+    DROP VIEW operation_department;
+    """
+
     operation = models.ForeignKey(Operation, verbose_name=_(u"Operation"))
     department = models.ForeignKey(Department, verbose_name=_(u"Department"),
                                    blank=True, null=True)