From 54e7ca4ddf183cd15bd7afff0c53b1970698432b Mon Sep 17 00:00:00 2001
From: zhangfan345 <zhangfan345@huawei.com>
Date: Thu, 1 Sep 2022 11:24:47 +0800
Subject: Add UT to intent service

Issue-ID: USECASEUI-716
Signed-off-by: zhangfan345 <zhangfan345@huawei.com>
Change-Id: I45b7faf76bf899510d11939021fd1d788c95a4bf
---
 .../main/resources/mybatis/sql/IntentMapper.xml    |  2 +-
 .../src/main/resources/mybatis/sql/StateMapper.xml | 53 ----------------------
 2 files changed, 1 insertion(+), 54 deletions(-)
 delete mode 100644 intentanalysis/src/main/resources/mybatis/sql/StateMapper.xml

(limited to 'intentanalysis/src/main/resources/mybatis')

diff --git a/intentanalysis/src/main/resources/mybatis/sql/IntentMapper.xml b/intentanalysis/src/main/resources/mybatis/sql/IntentMapper.xml
index c5d3b3d..57c8952 100644
--- a/intentanalysis/src/main/resources/mybatis/sql/IntentMapper.xml
+++ b/intentanalysis/src/main/resources/mybatis/sql/IntentMapper.xml
@@ -34,7 +34,7 @@
 
     <select id="getIntentByName" resultType="org.onap.usecaseui.intentanalysis.bean.models.Intent">
         select intent_id intentId, intent_name intentName from intent
-        where intent_name like  "%"#{intent.intentName}"%"
+        where intent_name like  #{intentName}
     </select>
 
 </mapper>
\ No newline at end of file
diff --git a/intentanalysis/src/main/resources/mybatis/sql/StateMapper.xml b/intentanalysis/src/main/resources/mybatis/sql/StateMapper.xml
deleted file mode 100644
index d103015..0000000
--- a/intentanalysis/src/main/resources/mybatis/sql/StateMapper.xml
+++ /dev/null
@@ -1,53 +0,0 @@
-<?xml version="1.0" encoding="UTF-8" ?>
-<!DOCTYPE mapper
-        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
-        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
-<mapper namespace="org.onap.usecaseui.intentanalysis.mapper.StateMapper">
-
-    <select id="selectStateByExpectation" resultType="org.onap.usecaseui.intentanalysis.bean.models.State">
-        select state_id stateId, state_name stateName, condition,
-               is_satisfied isSatisfied
-        from state
-        where expectation_id = #{expectationId}
-    </select>
-
-    <insert id="insertStateList" parameterType="java.util.ArrayList">
-        <if test="stateList != null">
-            insert into state(state_id, state_name, expectation_id, is_satisfied, condition)
-            values
-            <foreach collection="stateList" index="index" item="item" separator=",">
-                (#{item.stateId}, #{item.stateName}, #{expectationId}, #{item.isSatisfied}, #{item.condition})
-            </foreach>
-        </if>
-    </insert>
-
-    <delete id="deleteStateByExpectationId">
-        delete
-        from state
-        where expectation_id = #{expectationId}
-    </delete>
-
-    <insert id="insertState">
-        <if test="state != null">
-            insert into state(state_id, state_name, expectation_id, is_satisfied, condition)
-            values (#{state.stateId}, #{state.stateName}, #{expectationId}, #{state.isSatisfied}, #{state.condition})
-        </if>
-    </insert>
-
-    <update id="updateState" parameterType="java.util.List">
-        update state
-        <trim prefix="set" suffixOverrides=",">
-            <if test="stateName != null">state_name = #{stateName},</if>
-            <if test="isSatisfied != null">is_satisfied = #{isSatisfied},</if>
-            <if test="condition != null">condition = #{condition},</if>
-        </trim>
-        where state_id = #{stateId}
-    </update>
-
-    <delete id="deleteStateById">
-        delete
-        from state
-        where state_id = #{stateId}
-    </delete>
-
-</mapper>
\ No newline at end of file
-- 
cgit 1.2.3-korg