Update FulfillmentInfo with SO create intent API request response

Issue-ID: USECASEUI-795
Signed-off-by: xudan16 <xudan16@huawei.com>
Change-Id: Icc521a61f035c2780c802623902b9475e226813e

2 files changed, 14 insertions, 15 deletions

diff --git a/intentanalysis/src/main/resources/intent-analysis-init.sql b/intentanalysis/src/main/resources/intent-analysis-init.sql
index 4a349e7..ee7f8af 100644
--- a/intentanalysis/src/main/resources/intent-analysis-init.sql
+++ b/intentanalysis/src/main/resources/intent-analysis-init.sql
@@ -72,11 +72,11 @@ create table if not exists intent_management_function_reg_info(
     intent_function_type varchar(255)
     );
 
-create table if not exists intent_Event_Record(
+create table if not exists intent_event_record(
     id varchar(255) DEFAULT uuid_generate_v4 (),
-    intentId varchar(255),
-    intentName varchar(255),
-    intentStatus varchar (225),
-    operateType varchar (225),
+    intent_id varchar(255),
+    intent_name varchar(255),
+    intent_status varchar (225),
+    operate_type varchar (225),
     parent_id varchar(255)
-    );
\ No newline at end of file
+    );
diff --git a/intentanalysis/src/main/resources/mybatis/sql/IntentEventRecordMapper.xml b/intentanalysis/src/main/resources/mybatis/sql/IntentEventRecordMapper.xml
index bd86b9e..d10562d 100644
--- a/intentanalysis/src/main/resources/mybatis/sql/IntentEventRecordMapper.xml
+++ b/intentanalysis/src/main/resources/mybatis/sql/IntentEventRecordMapper.xml
@@ -5,20 +5,19 @@
 <mapper namespace="org.onap.usecaseui.intentanalysis.mapper.IntentEventRecordMapper">
 
     <insert id="insertIntentRecord">
-        insert into intent_Event_Record(intentId, intentName, intentStatus, operateType,parent_id)
+        insert into intent_event_record(intent_id, intent_name, intent_status, operate_type, parent_id)
         values(#{intentEventRecord.intentId}, #{intentEventRecord.intentName},
-               #{intentEventRecord.intentStatus},#{intentEventRecord.operateType},
+               #{intentEventRecord.intentStatus}, #{intentEventRecord.operateType},
                #{parentId})
     </insert>
 
-
-    <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 id="getIntentEventRecordByIntentId" flushCache="true" resultType="org.onap.usecaseui.intentanalysis.bean.models.IntentEventRecord">
+        select id id, intent_id intentId, intent_name intentName, intent_status intentStatus, operate_type operateType
+        from intent_event_record where intent_id = #{intentId} and operate_type=#{operateType};
     </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 id="getIntentEventRecordByPid" flushCache="true" resultType="org.onap.usecaseui.intentanalysis.bean.models.IntentEventRecord">
+        select id id, intent_id intentId, intent_name intentName, intent_status intentStatus, operate_type operateType
+        from intent_event_record where parent_id = #{parentId} and operate_type=#{operateType};
     </select>
 </mapper>