diff options
Diffstat (limited to 'intentanalysis/src/main/resources')
| -rw-r--r-- | intentanalysis/src/main/resources/intent-analysis-init.sql | 3 | ||||
| -rw-r--r-- | intentanalysis/src/main/resources/mybatis/sql/IntentEventRecordMapper.xml | 15 |
2 files changed, 13 insertions, 5 deletions
diff --git a/intentanalysis/src/main/resources/intent-analysis-init.sql b/intentanalysis/src/main/resources/intent-analysis-init.sql index a3834f9..4c985e4 100644 --- a/intentanalysis/src/main/resources/intent-analysis-init.sql +++ b/intentanalysis/src/main/resources/intent-analysis-init.sql @@ -77,5 +77,6 @@ create table if not exists intent_Event_Record( intentId varchar(255), intentName varchar(255), intentStatus varchar (225), - operateType varchar (225) + operateType 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 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> |