Container trees: UPDATE rules

1 files changed, 7 insertions, 1 deletions

diff --git a/archaeological_warehouse/models.py b/archaeological_warehouse/models.py
index 951830d95..2df5cbe77 100644
--- a/archaeological_warehouse/models.py
+++ b/archaeological_warehouse/models.py
@@ -451,13 +451,19 @@ class ContainerTree(models.Model):
           FROM (SELECT * FROM containers_tree) y
         ORDER BY y.container_id, y.container_parent_id;
 
-    -- deactivate deletion
+    -- deactivate deletion, update
     CREATE RULE containers_tree_del AS
         ON DELETE TO containers_tree
         DO INSTEAD DELETE FROM archaeological_warehouse_container where id=NULL;
     CREATE RULE container_tree_del AS
         ON DELETE TO container_tree
         DO INSTEAD DELETE FROM archaeological_warehouse_container where id=NULL;
+    CREATE RULE containers_tree_update AS
+        ON UPDATE TO containers_tree
+        DO INSTEAD UPDATE archaeological_warehouse_container set id=id WHERE id=NULL;
+    CREATE RULE container_tree_update AS
+        ON UPDATE TO container_tree
+        DO INSTEAD UPDATE archaeological_warehouse_container set id=id WHERE id=NULL;
     """
     DELETE_SQL = """
     DROP VIEW IF EXISTS container_tree;