aboutsummaryrefslogtreecommitdiffstats
path: root/intentanalysis/src/main/resources/mybatis/sql
diff options
context:
space:
mode:
authorhekeguang <hekeguang@chinamobile.com>2022-09-26 16:57:55 +0800
committerhekeguang <hekeguang@chinamobile.com>2022-09-26 16:58:32 +0800
commitead03c73657e3c46f87d82a34939b84ae35e8417 (patch)
tree98d434ad3be8930234e2c7e01928e3d76063318a /intentanalysis/src/main/resources/mybatis/sql
parent1d3d6092e9db1daaac382eb0e859da65dc98a712 (diff)
Add ImfRegInfo code .
Issue-ID: USECASEUI-696 Change-Id: I143d9c9aada3d9c0dfdbf5dae8cd04be0a2a3c5a Signed-off-by: hekeguang <hekeguang@chinamobile.com>
Diffstat (limited to 'intentanalysis/src/main/resources/mybatis/sql')
-rw-r--r--intentanalysis/src/main/resources/mybatis/sql/ConditionMapper.xml4
-rw-r--r--intentanalysis/src/main/resources/mybatis/sql/IMFRegInfoMapper.xml11
2 files changed, 6 insertions, 9 deletions
diff --git a/intentanalysis/src/main/resources/mybatis/sql/ConditionMapper.xml b/intentanalysis/src/main/resources/mybatis/sql/ConditionMapper.xml
index 012dfca..ccce147 100644
--- a/intentanalysis/src/main/resources/mybatis/sql/ConditionMapper.xml
+++ b/intentanalysis/src/main/resources/mybatis/sql/ConditionMapper.xml
@@ -27,13 +27,13 @@
</insert>
<!-- 这里的查询有问题-->
<select id="selectConditionList" resultType="org.onap.usecaseui.intentanalysis.bean.models.Condition">
- select condition_id conditionId, condition_name conditionName, operator_type operator, condition_value conditionValue
+ select condition_id conditionId, condition_name conditionName, operator_type "operator", condition_value conditionValue
from condition
where parent_id = #{parentId}
</select>
<select id="selectCondition" resultType="org.onap.usecaseui.intentanalysis.bean.models.Condition">
- select condition_id conditionId, condition_name conditionName, operator_type operator, condition_value conditionValue
+ select condition_id conditionId, condition_name conditionName, operator_type "operator", condition_value conditionValue
from condition
where condition_id = #{conditionId}
</select>
diff --git a/intentanalysis/src/main/resources/mybatis/sql/IMFRegInfoMapper.xml b/intentanalysis/src/main/resources/mybatis/sql/IMFRegInfoMapper.xml
index fd632b3..504c244 100644
--- a/intentanalysis/src/main/resources/mybatis/sql/IMFRegInfoMapper.xml
+++ b/intentanalysis/src/main/resources/mybatis/sql/IMFRegInfoMapper.xml
@@ -5,19 +5,16 @@
<mapper namespace="org.onap.usecaseui.intentanalysis.mapper.IMFRegInfoMapper">
- <resultMap id="mapIMFRInfo" type="org.onap.usecaseui.intentanalysis.bean.models.IntentManagementFunctionRegInfo">
- <result column="support_area" property="supportArea" typeHandler="org.onap.usecaseui.intentanalysis.util.ListArrayTypeHandler" jdbcType="ARRAY" javaType="java.util.List"/>
- <result column="support_interfaces" property="supportInterfaces" typeHandler="org.onap.usecaseui.intentanalysis.util.ListArrayTypeHandler" jdbcType="ARRAY" javaType="java.util.List"/>
- </resultMap>
-
<insert id="insertIMFRegInfoRegInfo">
insert into intent_management_function_reg_info(imfr_info_id,imfr_info_description,support_area,support_model,support_interfaces,handle_name,intent_function_type)
values
(#{imfregInfo.id}, #{imfregInfo.description},#{imfregInfo.supportArea} , #{imfregInfo.supportModel},#{imfregInfo.supportInterfaces},#{imfregInfo.handleName},#{imfregInfo.intentFunctionType})
</insert>
- <select id="getImfRegInfoList" resultMap="mapIMFRInfo">
- select * from intent_management_function_reg_info
+ <select id="getImfRegInfoList" resultType="org.onap.usecaseui.intentanalysis.bean.models.IntentManagementFunctionRegInfo">
+ select imfr_info_id id,imfr_info_description description,support_area supportArea, support_model supportModel,
+ support_interfaces supportInterfaces,handle_name handleName,intent_function_type intentFunctionType
+ from intent_management_function_reg_info
</select>
</mapper>