From b6b7bef8bdcad15af01ac88a038dd763ce59f68f Mon Sep 17 00:00:00 2001
From: xg353y <xg353y@intl.att.com>
Date: Tue, 11 Apr 2017 13:30:42 +0200
Subject: [MSO-8] Update the maven dependency

Update the maven depenency for sdc-distribution-client to cooperate with the sdc changes.

Change-Id: I2da936e5c40cb68c7181bb78307192dd5655b5dc
Signed-off-by: xg353y <xg353y@intl.att.com>
---
 .../camunda/bpm/plugin/urnmap/queries/urnMap.xml   | 64 ++++++++++++++++++++++
 1 file changed, 64 insertions(+)
 create mode 100644 bpmn/MSOURN-plugin/src/main/resources/org/openecomp/camunda/bpm/plugin/urnmap/queries/urnMap.xml

(limited to 'bpmn/MSOURN-plugin/src/main/resources/org/openecomp')

diff --git a/bpmn/MSOURN-plugin/src/main/resources/org/openecomp/camunda/bpm/plugin/urnmap/queries/urnMap.xml b/bpmn/MSOURN-plugin/src/main/resources/org/openecomp/camunda/bpm/plugin/urnmap/queries/urnMap.xml
new file mode 100644
index 0000000000..d0b58618e4
--- /dev/null
+++ b/bpmn/MSOURN-plugin/src/main/resources/org/openecomp/camunda/bpm/plugin/urnmap/queries/urnMap.xml
@@ -0,0 +1,64 @@
+<?xml version="1.0" encoding="UTF-8" ?>
+<!--
+  ============LICENSE_START=======================================================
+  ECOMP MSO
+  ================================================================================
+  Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.
+  ================================================================================
+  Licensed under the Apache License, Version 2.0 (the "License");
+  you may not use this file except in compliance with the License.
+  You may obtain a copy of the License at
+  
+       http://www.apache.org/licenses/LICENSE-2.0
+  
+  Unless required by applicable law or agreed to in writing, software
+  distributed under the License is distributed on an "AS IS" BASIS,
+  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+  See the License for the specific language governing permissions and
+  limitations under the License.
+  ============LICENSE_END=========================================================
+  -->
+
+
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+
+<mapper namespace="cockpit.urnMap">
+  <resultMap id="urnDataMap" type="org.openecomp.camunda.bpm.plugin.urnmap.db.URNData">
+    <result property="URNName" column="URNNAME" jdbcType="VARCHAR"/>
+    <result property="URNValue" column="URNVALUE" jdbcType="VARCHAR" />
+  </resultMap>
+
+  <select id="retrieveUrnKeyValuePair" resultMap="urnDataMap">
+    select NAME_ URNName, VALUE_ URNValue from MSO_URN_MAPPING
+  </select>
+
+
+  <!-- INSERT cockpit.InsertURNData  keyProperty="NAME_" -->
+  <resultMap id="insertNewRow" type="org.openecomp.camunda.bpm.plugin.urnmap.db.URNData">
+    <result property="URNName" 	  column="NAME_" 	jdbcType="VARCHAR" />
+    <result property="URNValue"   column="VALUE_"   jdbcType="VARCHAR" />
+    <result property="1" 	      column="REV_" 	jdbcType="INTEGER"/>
+  </resultMap>
+  
+	<insert id="insertNewRow" parameterType="org.openecomp.camunda.bpm.plugin.urnmap.db.URNData">
+	    insert into MSO_URN_MAPPING (NAME_, VALUE_, REV_) 
+	    values (
+	    			#{URNName}, #{URNValue}, 1
+	          )
+	</insert>
+	
+<!-- UPDATE cockpit.InsertURNData -->
+  <resultMap id="saveURNMappingDataMap" type="org.openecomp.camunda.bpm.plugin.urnmap.db.URNData">
+    <result property="URNName" 	column="NAME_" 	jdbcType="VARCHAR" />
+    <result property="URNValue"   column="VALUE_" jdbcType="VARCHAR" />
+    <result property="1" 	    column="REV_" 	jdbcType="INTEGER"/>
+  </resultMap>
+  
+  <update id="persistURNData">
+  update  MSO_URN_MAPPING set
+    NAME_ = #{URNName},
+    VALUE_ = #{URNValue},
+    REV_ = 1
+    where NAME_=#{URNName}
+</update>
+</mapper>
-- 
cgit 1.2.3-korg