RF接口自动化测试实践与案例解析

接口自动化详解
*** Settings ***
Library           RequestsLibrary
Library           Collections
Resource          env.txt    # 环境变量
Library           SSHLibrary
Library           HttpLibrary
Library           HttpLibrary.HTTP
Library           DatabaseLibrary
Resource          业务关键字.txt

*** Test Cases ***
新增数据集
    create session    api    ${sit}
    ${json}    Set Variable    {"system_id": "olap","database": "olap","tablename": "test_day_data_0119","type": "FACT","ide_job_id": "1040874","granularity": "P1D","ttl": 10,"meta": {"dimensions":[{"dimension": "id","is_time": false,"is_key": false,"is_multivalue": false}, {"dimension": "trans1","is_time": false,"is_key": false,"is_multivalue":false}, {"dimension": "province","is_time": false,"is_key": false,"is_multivalue": true}, {"dimension": "trans2","is_time": false,"is_key": false,"is_multivalue": false}, {"dimension": "money1","is_time": false,"is_key": false,"is_multivalue": false}, {"dimension": "custname","is_time": false,"is_key": false,"is_multivalue": false}, {"dimension": "booksnumber","is_time": false,"is_key": false,"is_multivalue": false}, {"dimension": "version__","is_time": false,"is_key": false,"is_multivalue": false}, {"dimension": "date","is_partition": false,"is_time": true,"time_format": "yyyy:MM:dd HHmmss","is_key": false,"is_multivalue": false}, {"dimension": "dates","is_partition": true,"is_time": true,"time_format": "yyyyMMddHHmmss","is_key": false,"is_multivalue": false}],"measures": ["sales"]},"is_timeline": true,"back_start": 2,"back_end": 1}
    ${result}    post request    api    /api/bigquery/datamanager/migrate    data=${json}
    log    ${result}
    should be equal as strings    ${result.status_code}    200
    log    ${result.text}
    ${dict}    Set Variable    ${result.json()}
    #以下断言
    ${error_msg}    get from dictionary    ${dict}    error_msg
    should be equal    ${error_msg}    success
    #校验数据库
    连接数据库    ${database}    ${user}    ${passwd}    ${host}
    ${q_result}    query    select * from bigquery_dataset \ where tableName='${tablename}'
    ${q_result_tostr}    convert to string    ${q_result}
    should contain    ${q_result_tostr}    ${tablename}
    ${id}    set variable    ${q_result[0][0]}
    log    ${id}

    : FOR    ${index}    IN RANGE    30
    \    sleep    10
    \    ${rc}    Row Count    SELECT * from bigquery_task where relationId ='${id}'
    \    run keyword if    ${rc} > 0    sleep    30
    \    ${sa}    Run Keyword If    ${rc} > 0    query    SELECT * from bigquery_task where relationId ='${id}'
    \    ...    ELSE    Continue For Loop
    \    run keyword if    '${sa[0][7]}' == 'SUCCEEDED' and '${sa[1][7]}' == 'SUCCEEDED'    log    执行成功
    \    ...    ELSE    FAIL    log    状态错误
    \    exit for loop
    run keyword if    '${rc}'=='0'    RUN KEYWORDS    log    task表无数据，请检查
    ...    AND    FAIL
    disconnect from database

查询数据集列表
    ${dict}    Create Dictionary    database=olap    tablename=${tablename}
    Create Session    api    ${sit}
    ${result}    Get Request    api    /api/bigquery/migrate/list    params=${dict}
    Should Be Equal As Strings    ${result.status_code}    200
    #断言
    ${var1}    get json value    ${result.content}    /error_msg
    ${var2}    get json value    ${result.content}    /result
    ${var3}    get json value    ${result.content}    /result/items
    ${var1todict}    to json    ${var3}
    ${gets}    get from dictionary    ${var1todict[0]}    table_name
    should be equal    ${gets}    ${tablename}
    Comment    ${demm}    Evaluate    demjson.decode(u'${result}')    demjson
    Comment    ${tyype}    evaluate    type($result)
    Comment    log    ${tyype}

新增维表