From 006a33f7be51d968aef0795cdf4f6f4fd1e5ba2f Mon Sep 17 00:00:00 2001 From: Étienne Loks Date: Wed, 3 Jun 2020 13:32:20 +0200 Subject: Container trees: INSERT rules --- archaeological_warehouse/models.py | 14 ++++++++++++-- 1 file changed, 12 insertions(+), 2 deletions(-) (limited to 'archaeological_warehouse/models.py') diff --git a/archaeological_warehouse/models.py b/archaeological_warehouse/models.py index 2df5cbe77..5cadc46da 100644 --- a/archaeological_warehouse/models.py +++ b/archaeological_warehouse/models.py @@ -460,10 +460,20 @@ class ContainerTree(models.Model): 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; + 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; + DO INSTEAD UPDATE archaeological_warehouse_container set id=id + WHERE id=NULL; + CREATE RULE containers_tree_insert AS + ON INSERT TO containers_tree + DO INSTEAD UPDATE archaeological_warehouse_container set id=id + WHERE id=NULL; + CREATE RULE container_tree_insert AS + ON INSERT 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