From 6433005256513ec2943ee2ea52f2844711e4d62f Mon Sep 17 00:00:00 2001
From: hekeguang <hekeguang@chinamobile.com>
Date: Mon, 22 Aug 2022 21:16:25 +0800
Subject: Add database code.

Issue-ID: USECASEUI-696
Change-Id: I1c8ce807ca1f2aaeebc8646d8a14df9f4b27a436
Signed-off-by: hekeguang <hekeguang@chinamobile.com>
---
 .../main/resources/mybatis/sql/ConditionMapper.xml | 30 ++++++++++++++++++++++
 .../main/resources/mybatis/sql/ContextMapper.xml   |  6 ++---
 .../mybatis/sql/ExpectationTargetMapper.xml        |  4 +--
 .../resources/mybatis/sql/IMFRegInfoMapper.xml     | 13 ++++++++++
 4 files changed, 48 insertions(+), 5 deletions(-)
 create mode 100644 intentanalysis/src/main/resources/mybatis/sql/ConditionMapper.xml
 create mode 100644 intentanalysis/src/main/resources/mybatis/sql/IMFRegInfoMapper.xml

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

diff --git a/intentanalysis/src/main/resources/mybatis/sql/ConditionMapper.xml b/intentanalysis/src/main/resources/mybatis/sql/ConditionMapper.xml
new file mode 100644
index 0000000..d77c06a
--- /dev/null
+++ b/intentanalysis/src/main/resources/mybatis/sql/ConditionMapper.xml
@@ -0,0 +1,30 @@
+<?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.ConditionMapper">
+
+    <insert id="insertConditionList">
+        insert into condition(condition_id, condition_name, operator_type, condition_value)
+        values
+        <foreach collection="contextList" index="index" item="item" separator=",">
+            (#{item.conditionId}, #{item.conditionName}, #{item.operatorType}, #{item.conditionValue})
+        </foreach>
+    </insert>
+
+    <insert id="insertConditionParentList">
+        insert into condition_mapping(condition_id, parent_type, parent_id)
+        values
+        <foreach collection="conditionList" index="index" item="item" separator=",">
+            (#{item.conditionId}, #{parentType}, #{parentId})
+        </foreach>
+    </insert>
+
+<!--    这里的查询有问题-->
+    <select id="selectConditionByParentId" resultType="org.onap.usecaseui.intentanalysis.bean.models.Context">
+        select condition_id conditionId, condition_name conditiontName, operator_type operatorType
+        from condition
+        where condition_id = #{parentId}
+    </select>
+
+</mapper>
\ No newline at end of file
diff --git a/intentanalysis/src/main/resources/mybatis/sql/ContextMapper.xml b/intentanalysis/src/main/resources/mybatis/sql/ContextMapper.xml
index 450721d..56569e4 100644
--- a/intentanalysis/src/main/resources/mybatis/sql/ContextMapper.xml
+++ b/intentanalysis/src/main/resources/mybatis/sql/ContextMapper.xml
@@ -6,10 +6,10 @@
 
 
     <insert id="insertContextList">
-        insert into context(context_id, context_name, context_type, context_condition)
+        insert into context(context_id, context_name)
         values
         <foreach collection="contextList" index="index" item="item" separator=",">
-            (#{item.contextId}, #{item.contextName}, #{item.contextType}, #{item.contextCondition})
+            (#{item.contextId}, #{item.contextName})
         </foreach>
     </insert>
 
@@ -22,7 +22,7 @@
     </insert>
 
     <select id="selectContextByParentId" resultType="org.onap.usecaseui.intentanalysis.bean.models.Context">
-        select context_id contextId, context_name contextName, context_type contextType, context_condition contextCondition
+        select context_id contextId, context_name contextName
         from context
         where intent_id = #{parentId}
     </select>
diff --git a/intentanalysis/src/main/resources/mybatis/sql/ExpectationTargetMapper.xml b/intentanalysis/src/main/resources/mybatis/sql/ExpectationTargetMapper.xml
index 0a915bf..89648b5 100644
--- a/intentanalysis/src/main/resources/mybatis/sql/ExpectationTargetMapper.xml
+++ b/intentanalysis/src/main/resources/mybatis/sql/ExpectationTargetMapper.xml
@@ -6,9 +6,9 @@
 
 
     <insert id="insertExpectationTarget">
-        insert into expectation_target(target_id, target_name, target_condition, expectation_id)
+        insert into expectation_target(target_id, target_name, expectation_id)
         values
-        (#{expectationTarget.targetId}, #{expectationTarget.targetName}, #{expectationTarget.targetCondition}, #{expectationId})
+        (#{expectationTarget.targetId}, #{expectationTarget.targetName},  #{expectationId})
     </insert>
 
 </mapper>
diff --git a/intentanalysis/src/main/resources/mybatis/sql/IMFRegInfoMapper.xml b/intentanalysis/src/main/resources/mybatis/sql/IMFRegInfoMapper.xml
new file mode 100644
index 0000000..8f6cd3c
--- /dev/null
+++ b/intentanalysis/src/main/resources/mybatis/sql/IMFRegInfoMapper.xml
@@ -0,0 +1,13 @@
+<?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.IMFRegInfoMapper">
+
+    <insert id="insertIMFRegInfoRegInfo">
+        insert into intent_management_function_reg_info(imfr_info_id, imfr_info_description, support_model,handle_name,intent_function_type)
+        values
+            (#{imfregInfo.id}, #{imfregInfo.description},  #{imfregInfo.supportArea},#{imfregInfo.handleName},#{imfregInfo.intentFunctionType})
+    </insert>
+
+</mapper>
-- 
cgit 1.2.3-korg