From ac3eeb30f40a225372c67cb33fe3396cf44770e4 Mon Sep 17 00:00:00 2001 From: sebdet Date: Fri, 21 Sep 2018 17:46:12 +0200 Subject: Add delete test Add a test and fix the delete model code that was not working Issue-ID: CLAMP-217 Change-Id: I235200ee0e7dc25ed759b88568333882bfb90c50 Signed-off-by: sebdet --- extra/sql/bulkload/clds-stored-procedures.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'extra/sql') diff --git a/extra/sql/bulkload/clds-stored-procedures.sql b/extra/sql/bulkload/clds-stored-procedures.sql index 10771745..aa8edb81 100644 --- a/extra/sql/bulkload/clds-stored-procedures.sql +++ b/extra/sql/bulkload/clds-stored-procedures.sql @@ -450,7 +450,8 @@ BEGIN SET process_instance_id = v_process_instance_id WHERE event_id = v_event_id; END; -CREATE PROCEDURE del_model (IN v_model_name VARCHAR(80)) +CREATE PROCEDURE del_model +(IN v_model_name VARCHAR(80)) BEGIN DECLARE v_model_id VARCHAR(36); SELECT model_id INTO v_model_id from model where model_name = v_model_name; @@ -459,7 +460,7 @@ BEGIN DELETE from model_blueprint where model_id = v_model_id; DELETE from model_properties where model_id = v_model_id; DELETE from model where model_id = v_model_id; -END +END; CREATE PROCEDURE set_new_tosca_model_version (IN v_tosca_model_id VARCHAR(36), -- cgit 1.2.3-korg