gfwleak/dongxiaoyan-tsg-autotest
Archived
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
This repository has been archived on 2025-09-14. You can view files and clone it, but cannot push or open issues or pull requests.
Files
20-06dev
dongxiaoyan-tsg-autotest/01-TestCase/tsg_bfapi/offline_stat_report/ReportResult.robot
liuyuanfang 2d673f6711 上传Report的增删改查case
2020-06-17 18:45:01 +08:00

235 lines
22 KiB
Plaintext
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

*** Settings ***
Test Teardown TeardownDelete ${reportId} ${report_url} ${chartId} ${chart_url} ${datasetId} ${dataset_url} ${resultId} ${result_url}
Force Tags tsg_bf_api chartlibrary_create report
Library OperatingSystem
Resource ../../../03-Variable/BifangApiVariable.txt
Resource ../../../02-Keyword/tsg_bfapi/offline_stat_report/ApiRequest1.robot
*** Variables ***
${dataset_url} /report/dataset
${datasetId} ${EMPTY}
${reportId} ${EMPTY}
${report_url} /report/offlinejob
${chartId} ${EMPTY}
${chart_url} /report/chart
${result_url} /report/offlinejob/result
${resultId} ${EMPTY}
*** Test Cases ***
Report_Result-001
#新建DataSet
${name} Set Variable Report_Result-001
Post-Request ${dataset_url} {"list":{"name":"${name}","logType":"security_event_log","filterConnector":"and","groupColumnList":[{"name":"common_recv_time"}],"queryColumnList":[{"name":"common_client_ip","expression":"count","label":"Client IP","expressionList":[{"label":"count","value":"count"},{"label":"Count Distinct","value":"count_distinct"}]},{"name":"common_log_id","expression":"count","label":"sessions","expressionList":[]},{"name":"common_server_ip","expression":"count","label":"Server IP","expressionList":[{"label":"count","value":"count"},{"label":"Count Distinct","value":"count_distinct"}]},{"name":"common_recv_time","expression":"","label":"Receive Time"}],"filterConditionList":[]}}
#根据name查询出该Dataset的id
${response} Get-Request ${dataset_url}?pageSize=20&pageNo=1&id=&name=${name}&logType=&opStartTime=&opEndTime=&opUser=
${datasetId} Set Variable ${response}[data][list][0][id]
#根据DataSet的id，新建Chart，Lien图形表
Post-Request ${chart_url} {"list":{"id":null,"name":"${name}","description":"","datasetId":${datasetId},"chartType":"line","dataTop":0,"orderBy":"","orderDesc":1,"drilldownTop":0,"includeOther":false,"timeline":{"dataBinding":"Receive Time","label":"","format":"Time"},"line":[{"dataBinding":"Client IP","type":"Line Up","format":"Default","legend":""},{"dataBinding":"Server IP","type":"Line Up","format":"Default","legend":""},{"dataBinding":"sessions","type":"Line Up","format":"Default","legend":""}]}}
#根据name查询出该Chart的id
${response1} Get-Request ${chart_url}?pageSize=20&pageNo=1&id=&name=${name}&opUser=
${chartId} Set Variable ${response1}[data][list][0][id]
#新建Report，时间计划为Today，图表引用Line。
Post-Request ${report_url} {"reportJobList":{"rangeType":"last","rangeInterval":1,"jobName":"${name}","scheduleId":"","chartList":[{"chartId":${chartId},"timeGranulartiy":1,"timeUnit":"","disabled":true}],"isNotice":0,"noticeMethod":"","receiver":[],"startTime":"","endTime":"","filterConnector":"and","filterCondition":[],"rangeUnit":"minute"}}
#查询Report的id
${response1} Get-Request ${report_url}?pageSize=20&pageNo=1&jobIds=&jobName=${name}&opStartTime=&opEndTime=&opUser=&scheduleId=
${reportId} Set Variable ${response1}[data][list][0][jobId]
#查询Report结果的状态，并判断状态结果，如果状态是执行成功，查看report结果内容
FOR ${i} IN RANGE 50
sleep 10
#report执行状态查询
${response1} Get-Request ${result_url}?jobId=${reportId}
${status} Set Variable ${response1}[data][list][0][status]
${resultId} Set Variable ${response1}[data][list][0][resultId]
run keyword if "${status}"=="0" log non-execution
... ELSE IF "${status}"=="1" log executing
... ELSE IF "${status}"=="2" Exit For Loop
... ELSE log Exec failure
END
#Report报表详情查询
${response1} Get-Request ${result_url}?resultId=${resultId}&jobId=${reportId}
Report_Result-002
#新建DataSet
${name} Set Variable Report_Result-002
Post-Request ${dataset_url} {"list":{"name":"${name}","logType":"proxy_event_log","filterConnector":"and","groupColumnList":[{"name":"common_recv_time"}],"queryColumnList":[{"name":"common_server_ip","expression":"count","label":"Server IP","expressionList":[{"label":"count","value":"count"},{"label":"Count Distinct","value":"count_distinct"}]},{"name":"common_client_ip","expression":"count","label":"Client IP","expressionList":[{"label":"count","value":"count"},{"label":"Count Distinct","value":"count_distinct"}]},{"name":"common_log_id","expression":"count","label":"sessions","expressionList":[]},{"name":"common_recv_time","expression":"","label":"Receive Time"}],"filterConditionList":[]}}
#根据name查询出该Dataset的id
${response} Get-Request ${dataset_url}?pageSize=20&pageNo=1&id=&name=${name}&logType=&opStartTime=&opEndTime=&opUser=
${datasetId} Set Variable ${response}[data][list][0][id]
#根据DataSet的id，新建Chart，Area图形表
Post-Request ${chart_url} {"list":{"id":null,"name":"${name}","description":"","datasetId":${datasetId},"chartType":"area","dataTop":0,"orderBy":"","orderDesc":1,"drilldownTop":0,"includeOther":false,"timeline":{"dataBinding":"Receive Time","label":"","format":"Time"},"line":[{"dataBinding":"Server IP","type":"Line Up","format":"Default","legend":""},{"dataBinding":"Client IP","type":"Line Down","format":"Default","legend":""},{"dataBinding":"sessions","type":"Line Up","format":"Default","legend":""}]}}
#根据name查询出该Chart的id
${response1} Get-Request ${chart_url}?pageSize=20&pageNo=1&id=&name=${name}&opUser=
${chartId} Set Variable ${response1}[data][list][0][id]
#新建Report，时间计划为yesterday，图表引用Area。
Post-Request ${report_url} {"reportJobList":{"rangeType":"yesterday","rangeInterval":1,"jobName":"${name}","scheduleId":"","chartList":[{"chartId":${chartId},"timeGranulartiy":5,"timeUnit":"hour","disabled":false}],"isNotice":0,"noticeMethod":"","receiver":[],"startTime":"","endTime":"","filterConnector":"and","filterCondition":[]}}
#查询Report的id
${response1} Get-Request ${report_url}?pageSize=20&pageNo=1&jobIds=&jobName=${name}&opStartTime=&opEndTime=&opUser=&scheduleId=
${reportId} Set Variable ${response1}[data][list][0][jobId]
#查询Report结果的状态，并判断状态结果，如果状态是执行成功，查看report结果内容
FOR ${i} IN RANGE 50
sleep 10
#report执行状态查询
${response1} Get-Request ${result_url}?jobId=${reportId}
${status} Set Variable ${response1}[data][list][0][status]
${resultId} Set Variable ${response1}[data][list][0][resultId]
run keyword if "${status}"=="0" log non-execution
... ELSE IF "${status}"=="1" log executing
... ELSE IF "${status}"=="2" Exit For Loop
... ELSE log Exec failure
END
#Report报表详情查询
${response1} Get-Request ${result_url}?resultId=${resultId}&jobId=${reportId}
Report_Result-003
#新建DataSet
${name} Set Variable Report_Result-003
Post-Request ${dataset_url} {"list":{"name":"${name}","logType":"connection_record_log","filterConnector":"and","groupColumnList":[{"name":"common_client_ip"}],"queryColumnList":[{"name":"common_log_id","expression":"count","label":"sessions","expressionList":[]},{"name":"common_client_ip","expression":"","label":"Client IP"}],"filterConditionList":[{"name":"common_address_type","expression":"!=","expressionList":["=","!=",">","<",">=","<="],"value":[6],"type":"int"}]}}
${response} Get-Request ${dataset_url}?pageSize=20&pageNo=1&id=&name=${name}&logType=&opStartTime=&opEndTime=&opUser=
${datasetId} Set Variable ${response}[data][list][0][id]
#根据DataSet的id，新建Chart，Pie图形表
Post-Request ${chart_url} {"list":{"id":null,"name":"${name}","description":"","datasetId":${datasetId},"chartType":"pie","dataTop":0,"orderBy":"","orderDesc":"","includeOther":true,"xAxis":{"dataBinding":"Client IP","label":"Client IP","dataTop":5,"dataType":""},"yAxis":[{"dataBinding":"sessions","format":"Default","legend":""}]}}
${response1} Get-Request ${chart_url}?pageSize=20&pageNo=1&id=&name=${name}&opUser=
${chartId} Set Variable ${response1}[data][list][0][id]
#新建Report，时间计划为This，图表引用Pie。
Post-Request ${report_url} {"reportJobList":{"rangeType":"yesterday","rangeInterval":1,"jobName":"${name}","scheduleId":"","chartList":[{"chartId":${chartId},"timeGranulartiy":1,"timeUnit":"","disabled":true}],"isNotice":0,"noticeMethod":"","receiver":[],"startTime":"","endTime":"","filterConnector":"and","filterCondition":[],"rangeUnit":"week"}}
#查询Report的id
${response1} Get-Request ${report_url}?pageSize=20&pageNo=1&jobIds=&jobName=${name}&opStartTime=&opEndTime=&opUser=&scheduleId=
${reportId} Set Variable ${response1}[data][list][0][jobId]
#查询Report结果的状态，并判断状态结果，如果状态是执行成功，查看report结果内容
FOR ${i} IN RANGE 50
sleep 10
#report执行状态查询
${response1} Get-Request ${result_url}?jobId=${reportId}
${status} Set Variable ${response1}[data][list][0][status]
${resultId} Set Variable ${response1}[data][list][0][resultId]
run keyword if "${status}"=="0" log non-execution
... ELSE IF "${status}"=="1" log executing
... ELSE IF "${status}"=="2" Exit For Loop
... ELSE log Exec failure
END
#Report报表详情查询
${response1} Get-Request ${result_url}?resultId=${resultId}&jobId=${reportId}
Report_Result-004
#新建DataSet
${name} Set Variable Report_Result-004
Post-Request ${dataset_url} {"list":{"name":"${name}","logType":"connection_record_log","filterConnector":"and","groupColumnList":[{"name":"common_client_ip"}],"queryColumnList":[{"name":"common_log_id","expression":"count","label":"sessions","expressionList":[]},{"name":"common_client_ip","expression":"","label":"Client IP"}],"filterConditionList":[{"name":"common_address_type","expression":"!=","expressionList":["=","!=",">","<",">=","<="],"value":[6],"type":"int"}]}}
${response} Get-Request ${dataset_url}?pageSize=20&pageNo=1&id=&name=${name}&logType=&opStartTime=&opEndTime=&opUser=
${datasetId} Set Variable ${response}[data][list][0][id]
#根据DataSet的id，新建Chart，Bra图形表
Post-Request ${chart_url} {"list":{"id":null,"name":"${name}","description":"","datasetId":${datasetId},"chartType":"bar","dataTop":0,"orderBy":"","orderDesc":"","includeOther":true,"xAxis":{"dataBinding":"Client IP","label":"Client IP","dataTop":5,"dataType":""},"yAxis":[{"dataBinding":"sessions","format":"Default","legend":""}]}}
#根据name查询出该Chart的id
${response1} Get-Request ${chart_url}?pageSize=20&pageNo=1&id=&name=${name}&opUser=
${chartId} Set Variable ${response1}[data][list][0][id]
#新建Report，时间计划为last，图表引用Bra。
Post-Request ${report_url} {"reportJobList":{"rangeType":"last","rangeInterval":1,"jobName":"${name}","scheduleId":"","chartList":[{"chartId":${chartId},"timeGranulartiy":1,"timeUnit":"","disabled":true}],"isNotice":0,"noticeMethod":"","receiver":[],"startTime":"","endTime":"","filterConnector":"and","filterCondition":[],"rangeUnit":"day"}}
#查询Report的id
${response1} Get-Request ${report_url}?pageSize=20&pageNo=1&jobIds=&jobName=${name}&opStartTime=&opEndTime=&opUser=&scheduleId=
${reportId} Set Variable ${response1}[data][list][0][jobId]
#查询Report结果的状态，并判断状态结果，如果状态是执行成功，查看report结果内容
FOR ${i} IN RANGE 50
sleep 10
#report执行状态查询
${response1} Get-Request ${result_url}?jobId=${reportId}
${status} Set Variable ${response1}[data][list][0][status]
${resultId} Set Variable ${response1}[data][list][0][resultId]
run keyword if "${status}"=="0" log non-execution
... ELSE IF "${status}"=="1" log executing
... ELSE IF "${status}"=="2" Exit For Loop
... ELSE log Exec failure
END
#Report报表详情查询
${response1} Get-Request ${result_url}?resultId=${resultId}&jobId=${reportId}
Report_Result-005
#新建DataSet
${name} Set Variable Report_Result-005
Post-Request ${dataset_url} {"list":{"name":"${name}","logType":"connection_record_log","filterConnector":"and","groupColumnList":[{"name":"common_client_ip"}],"queryColumnList":[{"name":"common_log_id","expression":"count","label":"sessions","expressionList":[]},{"name":"common_client_ip","expression":"","label":"Client IP"}],"filterConditionList":[{"name":"common_address_type","expression":"!=","expressionList":["=","!=",">","<",">=","<="],"value":[6],"type":"int"}]}}
${response} Get-Request ${dataset_url}?pageSize=20&pageNo=1&id=&name=${name}&logType=&opStartTime=&opEndTime=&opUser=
${datasetId} Set Variable ${response}[data][list][0][id]
#根据DataSet的id，新建Chart,tableb表，普通
Post-Request ${chart_url} {"list":{"id":null,"name":"${name}","description":"","datasetId":${datasetId},"chartType":"table","dataTop":10,"orderBy":"sessions","orderDesc":0,"drilldownTop":null,"includeOther":false,"tableType":"Regular","columns":[{"title":"Client IP","width":20,"dataBindings":[{"dataType":false,"dataBinding":"Client IP","format":"Default","legend":"","name":"common_client_ip"}]},{"title":"sessions","width":20,"dataBindings":[{"dataType":false,"dataBinding":"sessions","format":"Default","legend":"","name":"common_log_id"}]}]}}
#根据name查询出该Chart的id
${response1} Get-Request ${chart_url}?pageSize=20&pageNo=1&id=&name=${name}&opUser=
${chartId} Set Variable ${response1}[data][list][0][id]
#新建Report，时间计划为customize，图表引用Table。
Post-Request ${report_url} {"reportJobList":{"rangeType":"customize","rangeInterval":1,"jobName":"${name}","scheduleId":"","chartList":[{"chartId":${chartId},"timeGranulartiy":1,"timeUnit":"","disabled":true}],"isNotice":0,"noticeMethod":"","receiver":[],"startTime":"2020-06-15 00:00:00","endTime":"2020-06-17 00:00:00","filterConnector":"and","filterCondition":[]}}
#查询Report的id
${response1} Get-Request ${report_url}?pageSize=20&pageNo=1&jobIds=&jobName=${name}&opStartTime=&opEndTime=&opUser=&scheduleId=
${reportId} Set Variable ${response1}[data][list][0][jobId]
#查询Report结果的状态，并判断状态结果，如果状态是执行成功，查看report结果内容
FOR ${i} IN RANGE 50
sleep 10
#report执行状态查询
${response1} Get-Request ${result_url}?jobId=${reportId}
${status} Set Variable ${response1}[data][list][0][status]
${resultId} Set Variable ${response1}[data][list][0][resultId]
run keyword if "${status}"=="0" log non-execution
... ELSE IF "${status}"=="1" log executing
... ELSE IF "${status}"=="2" Exit For Loop
... ELSE log Exec failure
END
#Report报表详情查询
${response1} Get-Request ${result_url}?resultId=${resultId}&jobId=${reportId}
Report_Result-006
#新建DataSet
${name} Set Variable Report_Result-006
Post-Request ${dataset_url} {"list":{"name":"${name}","logType":"connection_record_log","filterConnector":"and","groupColumnList":[{"name":"common_client_ip"}],"queryColumnList":[{"name":"common_log_id","expression":"count","label":"sessions","expressionList":[]},{"name":"common_client_ip","expression":"","label":"Client IP"}],"filterConditionList":[{"name":"common_address_type","expression":"!=","expressionList":["=","!=",">","<",">=","<="],"value":[6],"type":"int"}]}}
${response} Get-Request ${dataset_url}?pageSize=20&pageNo=1&id=&name=${name}&logType=&opStartTime=&opEndTime=&opUser=
${datasetId} Set Variable ${response}[data][list][0][id]
#根据DataSet的id，新建Chart,tableb表，下钻
Post-Request ${chart_url} {"list":{"id":null,"name":"${name}","description":"","datasetId":${datasetId},"chartType":"table","dataTop":10,"orderBy":"sessions","orderDesc":0,"drilldownTop":null,"includeOther":false,"tableType":"Regular","columns":[{"title":"Client IP","width":20,"dataBindings":[{"dataType":false,"dataBinding":"Client IP","format":"Default","legend":"","name":"common_client_ip"}]},{"title":"sessions","width":20,"dataBindings":[{"dataType":false,"dataBinding":"sessions","format":"Default","legend":"","name":"common_log_id"}]}]}}
#根据name查询出该Chart的id
${response1} Get-Request ${chart_url}?pageSize=20&pageNo=1&id=&name=${name}&opUser=
${chartId} Set Variable ${response1}[data][list][0][id]
#新建Report，时间计划为this，图表引用Table。发送邮件
Post-Request ${report_url} {"reportJobList":{"rangeType":"yesterday","rangeInterval":1,"jobName":"${name}","scheduleId":"","chartList":[{"chartId":${chartId},"timeGranulartiy":1,"timeUnit":"","disabled":true}],"isNotice":1,"noticeMethod":1,"receiver":"check@test.com","startTime":"","endTime":"","filterConnector":"and","filterCondition":[],"rangeUnit":"day"}}
#查询Report的id
${response1} Get-Request ${report_url}?pageSize=20&pageNo=1&jobIds=&jobName=${name}&opStartTime=&opEndTime=&opUser=&scheduleId=
${reportId} Set Variable ${response1}[data][list][0][jobId]
#查询Report结果的状态，并判断状态结果，如果状态是执行成功，查看report结果内容
FOR ${i} IN RANGE 50
sleep 10
#report执行状态查询
${response1} Get-Request ${result_url}?jobId=${reportId}
${status} Set Variable ${response1}[data][list][0][status]
${resultId} Set Variable ${response1}[data][list][0][resultId]
run keyword if "${status}"=="0" log non-execution
... ELSE IF "${status}"=="1" log executing
... ELSE IF "${status}"=="2" Exit For Loop
... ELSE log Exec failure
END
#Report报表详情查询
${response1} Get-Request ${result_url}?resultId=${resultId}&jobId=${reportId}
Report_Result-007
#新建DataSet
${name} Set Variable Report_Result-007
Post-Request ${dataset_url} {"list":{"name":"${name}","logType":"connection_record_log","filterConnector":"and","groupColumnList":[{"name":"common_client_ip"}],"queryColumnList":[{"name":"common_log_id","expression":"count","label":"sessions","expressionList":[]},{"name":"common_client_ip","expression":"","label":"Client IP"}],"filterConditionList":[{"name":"common_address_type","expression":"!=","expressionList":["=","!=",">","<",">=","<="],"value":[6],"type":"int"}]}}
${response} Get-Request ${dataset_url}?pageSize=20&pageNo=1&id=&name=${name}&logType=&opStartTime=&opEndTime=&opUser=
${datasetId} Set Variable ${response}[data][list][0][id]
#根据DataSet的id，新建Chart,tableb表，下钻
Post-Request ${chart_url} {"list":{"id":null,"name":"${name}","description":"","datasetId":${datasetId},"chartType":"table","dataTop":10,"orderBy":"sessions","orderDesc":0,"drilldownTop":null,"includeOther":false,"tableType":"Regular","columns":[{"title":"Client IP","width":20,"dataBindings":[{"dataType":false,"dataBinding":"Client IP","format":"Default","legend":"","name":"common_client_ip"}]},{"title":"sessions","width":20,"dataBindings":[{"dataType":false,"dataBinding":"sessions","format":"Default","legend":"","name":"common_log_id"}]}]}}
#根据name查询出该Chart的id
${response1} Get-Request ${chart_url}?pageSize=20&pageNo=1&id=&name=${name}&opUser=
${chartId} Set Variable ${response1}[data][list][0][id]
#新建Report，时间计划为this，图表引用Table。发送邮件
Post-Request ${report_url} {"reportJobList":{"rangeType":"yesterday","rangeInterval":1,"jobName":"${name}","scheduleId":"","chartList":[{"chartId":${chartId},"timeGranulartiy":1,"timeUnit":"","disabled":true}],"isNotice":1,"noticeMethod":2,"receiver":[{"server":"192.168.40.204","port":"21","user":"wxs","password":"111111","directory":"/"}],"startTime":"","endTime":"","filterConnector":"and","filterCondition":[]}}
#查询Report的id
${response1} Get-Request ${report_url}?pageSize=20&pageNo=1&jobIds=&jobName=${name}&opStartTime=&opEndTime=&opUser=&scheduleId=
${reportId} Set Variable ${response1}[data][list][0][jobId]
#查询Report结果的状态，并判断状态结果，如果状态是执行成功，查看report结果内容
FOR ${i} IN RANGE 50
sleep 10
#report执行状态查询
${response1} Get-Request ${result_url}?jobId=${reportId}
${status} Set Variable ${response1}[data][list][0][status]
${resultId} Set Variable ${response1}[data][list][0][resultId]
run keyword if "${status}"=="0" log non-execution
... ELSE IF "${status}"=="1" log executing
... ELSE IF "${status}"=="2" Exit For Loop
... ELSE log Exec failure
END
#Report报表详情查询
${response1} Get-Request ${result_url}?resultId=${resultId}&jobId=${reportId}
Reference in New Issue View Git Blame Copy Permalink