From a5ce95ed18ef8d3f3bd9166908a037b5e21a120e Mon Sep 17 00:00:00 2001 From: Étienne Loks Date: Wed, 3 Jun 2020 13:10:50 +0200 Subject: Container trees: UPDATE rules --- archaeological_warehouse/models.py | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) 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; -- cgit v1.2.3