summaryrefslogtreecommitdiffstats
path: root/extra/sql/bulkload/clds-stored-procedures.sql
diff options
context:
space:
mode:
authorsebdet <sd378r@intl.att.com>2018-09-21 17:46:12 +0200
committersebdet <sd378r@intl.att.com>2018-09-21 17:46:12 +0200
commitac3eeb30f40a225372c67cb33fe3396cf44770e4 (patch)
tree56ada2506f9e38776e476b9aab923d30b1e8c151 /extra/sql/bulkload/clds-stored-procedures.sql
parent4aea6da2620cf887fac4cd1158374174f6fc9152 (diff)
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 <sd378r@intl.att.com>
Diffstat (limited to 'extra/sql/bulkload/clds-stored-procedures.sql')
-rw-r--r--extra/sql/bulkload/clds-stored-procedures.sql5
1 files changed, 3 insertions, 2 deletions
diff --git a/extra/sql/bulkload/clds-stored-procedures.sql b/extra/sql/bulkload/clds-stored-procedures.sql
index 107717451..aa8edb81a 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),