1 files changed, 64 insertions, 0 deletions
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>