summaryrefslogtreecommitdiffstats
path: root/bpmn/MSOURN-plugin/src/main/resources/org
diff options
context:
space:
mode:
Diffstat (limited to 'bpmn/MSOURN-plugin/src/main/resources/org')
-rw-r--r--bpmn/MSOURN-plugin/src/main/resources/org/openecomp/camunda/bpm/plugin/urnmap/queries/urnMap.xml64
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>