diff options
Diffstat (limited to 'bpmn/MSOURN-plugin/src/main/resources/org/openecomp/camunda/bpm/plugin/urnmap/queries')
-rw-r--r-- | bpmn/MSOURN-plugin/src/main/resources/org/openecomp/camunda/bpm/plugin/urnmap/queries/urnMap.xml | 64 |
1 files changed, 0 insertions, 64 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 deleted file mode 100644 index d0b58618e4..0000000000 --- a/bpmn/MSOURN-plugin/src/main/resources/org/openecomp/camunda/bpm/plugin/urnmap/queries/urnMap.xml +++ /dev/null @@ -1,64 +0,0 @@ -<?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> |