From ac3eeb30f40a225372c67cb33fe3396cf44770e4 Mon Sep 17 00:00:00 2001
From: sebdet <sd378r@intl.att.com>
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 <sd378r@intl.att.com>
---
 extra/sql/bulkload/clds-stored-procedures.sql | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

(limited to 'extra/sql/bulkload/clds-stored-procedures.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 

