*** Settings ***
Library           urllib3
Library           String
Library           Collections
Library           RequestsLibrary
Library           DatabaseLibrary

*** Keywords ***
查询${dating}用户资料
    ${miId_list}    Create List
    FOR    ${userId}    ${client_header}    IN ZIP    ${userid_list}    ${Cheader_list}
        Disable Warnings
        Create Session    dating    ${${dating}.dating域名}    ${client_header}
        ${reps}    GET On Session    dating    /dating-agency-service/user/get/first/fill/marriage/information/details    params=userId=${userId}
        ${miId}    Get From Dictionary    ${reps.json()['data']}    id    #资料id
        Append To List    ${miId_list}    ${miId}
        Set Global Variable    ${userId}
        Set Global Variable    ${miId_list}
    END

查询${dating}征婚人发榜详情
    #通过miId查询征婚人发榜详情
    FOR    ${miId}    ${client_header}    IN ZIP    ${miId_list}    ${Cheader_list}
        Create Session    dating    ${${dating}.dating域名}    ${client_header}
        ${reps}    GET On Session    dating    dating-agency-service/user/get/marriage/seeking/reward/to/be/announced/detail    params=miId=${miId}
        ${userId}    Get From Dictionary    ${reps.json()['data']}    userId    #获取征婚人userId
        ${matchmaker}    Get From Dictionary    ${reps.json()['data']}    matchmaker    #嘉宾绑定的红娘
        ${matchmakerId}    Get From Dictionary    ${matchmaker}    id    #红娘id
        ${matchmakerUserId}    Get From Dictionary    ${matchmaker}    userId    #红娘userId
        Run Keyword If    ${matchmakerId}==None    红娘邀请婚介用户成为嘉宾
        ...    ELSE    log    ${matchmaker}
        Set Global Variable    ${userId}
    END

红娘邀请${dating}用户成为嘉宾
    #红娘邀请嘉宾
    FOR    ${userId}    ${client_header}    IN ZIP    ${userid_list}    ${Cheader_list}
        Create Session    dating    ${${dating}.dating域名}    ${client_header}
        ${matchmakerUserId}    Set Variable    988491861142409216    #红娘userid，就是不吃饭：978668013433786368；15121074365：977568001438126080    生产环境：988491861142409216
        ${data}    Set Variable    {"initiatorUserId":${matchmakerUserId}}
        ${reps}    Post Request    dating    dating-agency-service/user/save/matchmaker/invite/user?userId=${userId}    ${data.encode('utf-8')}
        ${message}    Get From Dictionary    ${reps.json()}    message    #获取响应信息
        Should Be Equal As Strings    ${message}    successful    #断言
    END
    Set Global Variable    ${matchmakerUserId}

后台查询${dating}红娘列表
    #查询红娘列表，找到红娘后获取红娘ID
    FOR    ${admin_header}    IN    @{Aheader_list}
        Create Session    dating    ${${dating}.dating域名}    ${admin_header}
        ${reps}    GET On Session    dating    dating-agency-uec/user/page/matchmaker    params=pageSize=10&pageNum=1
        ${matchmaker_list}    Get From Dictionary    ${reps.json()['data']}    records    #红娘列表
        Set Global Variable    ${matchmaker_list}
        遍历红娘列表
    END

遍历红娘列表
    #遍历红娘列表
    FOR    ${matchmaker}    IN    @{matchmaker_list}
        ${matchmakerId}    Get From Dictionary    ${matchmaker}    id    #获取红娘Id
        ${userId}    Get From Dictionary    ${matchmaker}    userId    #获取红娘userId
        Exit For Loop If    ${userId}==${matchmakerUserId}
    END
    Set Global Variable    ${matchmakerId}

查询${dating}后台红娘详情
    #查看红娘详情-嘉宾列表
    FOR    ${client_header}    IN    @{Cheader_list}
        Create Session    dating    ${${dating}.dating域名}    ${client_header}
        ${reps}    GET On Session    dating    dating-agency-service/user/get/matchmaker/guest/page    params=pageSize=10&matchmakerId=${matchmakerId}&pageNum=1
        ${records}    Get From Dictionary    ${reps.json()['data']}    records    #嘉宾列表
        Set Global Variable    ${records}
        遍历嘉宾列表
    END

遍历嘉宾列表
    FOR    ${records}    IN    @{records}
        ${MIID}    Get From Dictionary    ${records}    miId    #嘉宾资料id
        Exit For Loop If    ${MIID}==${miId}
        Set Global Variable    ${MIID}
    END

数据库查询是否邀请成功
    #查询数据库数据
    FOR    ${userId}    IN    @{userid_list}
        Connect To Database Using Custom Params    pymysql    database='dating_agency_service',user='root',password='qniaothreetwoonego',host='8.135.8.221'
        ${check}    Query    SELECT matchmaker_id FROM `dating_agency_service`.`da_matchmaker_marriage_information` WHERE `user_id` = '${userId}' AND `matchmaker_id` = '${matchmakerId}' AND `is_delete` = '0' AND `relation_type` = '1'    #数据库查询数据
        ${matchmaker_id}    Set Variable    ${check[0][0]}
        Should Be Equal    ${matchmaker_id}    ${matchmakerId}
    END