From 4c91cd3e52050c2f36f533a57661d770259f5973 Mon Sep 17 00:00:00 2001
From: kaixiliu <liukaixi@chinamobile.com>
Date: Tue, 4 Apr 2023 14:21:46 +0800
Subject: update intent process code

Issue-ID: USECASEUI-785
Signed-off-by: kaixiliu <liukaixi@chinamobile.com>
Change-Id: Iee30fea33ff357a792f342166c9ddec26ad4feba
---
 .../resources/mybatis/sql/IntentEventRecordMapper.xml     | 15 +++++++++++----
 1 file changed, 11 insertions(+), 4 deletions(-)

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

diff --git a/intentanalysis/src/main/resources/mybatis/sql/IntentEventRecordMapper.xml b/intentanalysis/src/main/resources/mybatis/sql/IntentEventRecordMapper.xml
index 296fc43..bd86b9e 100644
--- a/intentanalysis/src/main/resources/mybatis/sql/IntentEventRecordMapper.xml
+++ b/intentanalysis/src/main/resources/mybatis/sql/IntentEventRecordMapper.xml
@@ -5,13 +5,20 @@
 <mapper namespace="org.onap.usecaseui.intentanalysis.mapper.IntentEventRecordMapper">
 
     <insert id="insertIntentRecord">
-        insert into intent_Event_Record(intentId, intentName, intentStatus, operateType)
+        insert into intent_Event_Record(intentId, intentName, intentStatus, operateType,parent_id)
         values(#{intentEventRecord.intentId}, #{intentEventRecord.intentName},
-               #{intentEventRecord.intentStatus},#{intentEventRecord.operateType})
+               #{intentEventRecord.intentStatus},#{intentEventRecord.operateType},
+               #{parentId})
     </insert>
 
 
-    <select id="getIntentEventRecordByntentId"  resultType="org.onap.usecaseui.intentanalysis.bean.models.IntentEventRecord">
-       select * from intent_Event_Record where intentId = #{intentId};
+    <select id="getIntentEventRecordByIntentId"  resultType="org.onap.usecaseui.intentanalysis.bean.models.IntentEventRecord">
+       select id,intentId,intentName,intentStatus,operateType,parent_id parentId
+       from intent_Event_Record where intentId = #{intentId};
+    </select>
+
+    <select id="getIntentEventRecordByPid"  resultType="org.onap.usecaseui.intentanalysis.bean.models.IntentEventRecord">
+        select id,intentId,intentName,intentStatus,operateType,parent_id
+        from intent_Event_Record where parent_id = #{parentId} and operateType=#{operateType};
     </select>
 </mapper>
-- 
cgit 1.2.3-korg