diff options
Diffstat (limited to 'intentanalysis/src/main/resources/mybatis/sql')
| -rw-r--r-- | intentanalysis/src/main/resources/mybatis/sql/IntentReportFulfillmentInfoMapper.xml | 10 | ||||
| -rw-r--r-- | intentanalysis/src/main/resources/mybatis/sql/IntentReportMapper.xml | 10 |
2 files changed, 20 insertions, 0 deletions
diff --git a/intentanalysis/src/main/resources/mybatis/sql/IntentReportFulfillmentInfoMapper.xml b/intentanalysis/src/main/resources/mybatis/sql/IntentReportFulfillmentInfoMapper.xml index bfe413e..c090d5a 100644 --- a/intentanalysis/src/main/resources/mybatis/sql/IntentReportFulfillmentInfoMapper.xml +++ b/intentanalysis/src/main/resources/mybatis/sql/IntentReportFulfillmentInfoMapper.xml @@ -8,4 +8,14 @@ insert into intent_report_fulfillment_info(parent_id,fulfillment_info_id, fulfillment_info_status, not_fulfilled_state, not_fulfilled_reason,achieve_value) values (#{parentId},#{fulfillmentInfo.fulfillmentId}, #{fulfillmentInfo.fulfillmentStatus}, #{fulfillmentInfo.notFulfilledState}, #{fulfillmentInfo.notFulfilledReason},#{fulfillmentInfo.achieveValue}) </insert> + <select id="getFulfillmentInfosByParentId" + resultType="org.onap.usecaseui.intentanalysis.bean.models.FulfillmentInfo"> + select fulfillment_info_id fulfillmentId, + fulfillment_info_status fulfillmentStatus, + not_fulfilled_state notFulfilledState, + not_fulfilled_reason notFulfilledReason, + achieve_value achieveValue + from intent_report_fulfillment_info + where parent_id = #{parentId} + </select> </mapper> diff --git a/intentanalysis/src/main/resources/mybatis/sql/IntentReportMapper.xml b/intentanalysis/src/main/resources/mybatis/sql/IntentReportMapper.xml index 078ea9b..901055e 100644 --- a/intentanalysis/src/main/resources/mybatis/sql/IntentReportMapper.xml +++ b/intentanalysis/src/main/resources/mybatis/sql/IntentReportMapper.xml @@ -14,4 +14,14 @@ from intent_report where intent_reference = #{intentReference} </select> + + <select id="getIntentReportsByTime" resultType="org.onap.usecaseui.intentanalysis.bean.models.IntentReport"> + select intent_report_id intentReportId, + intent_reference intentReference, + to_char(report_time,'yyyy-mm-dd HH24:mi:ss') reportTime + from intent_report + where report_time >= to_timestamp(#{startTime},'yyyy-MM-dd HH24:mi:ss') + and report_time < to_timestamp(#{endTime},'yyyy-MM-dd HH24:mi:ss') + and intent_reference = #{intentInstanceId} + </select> </mapper> |