3 请求入口

# 请求入口
def do_request(id):
    # 查询接口信息
    result = su.exec_sql("select * from t_request where id=" + str(id))
    # print(result)

    # 获取所需数据
    name = result[0][1]
    method = result[0][2]
    host = result[0][3]
    path = result[0][4]
    headers = result[0][5]
    datas = result[0][6]
    relate_headers = result[0][7]
    relate_datas = result[0][8]
    check_str = result[0][9]
    resp_str = result[0][10]

    # headers 关联
    if relate_headers != None:
        headers = headers.replace('${' + relate_headers + '}', relate_dict[relate_headers])
        result_dict['headers'] = headers    # 用于结果收集
    else:
        result_dict['headers'] = headers
    headers = json.loads(headers)  # 转字典
    # print(headers)
    # print(type(headers))

    # datas 关联
    if relate_datas != None:
        datas = datas.replace('${' + relate_datas + '}', relate_dict[relate_datas])
        result_dict['datas'] = datas    # 用于结果收集
    else:
        result_dict['datas'] = datas
    datas = json.loads(datas)     # 转字典
    # print(datas)
    # print(type(datas))

    # 发送对应请求
    if method.lower() == 'post':
        do_post(name, host, path, headers, datas, check_str, resp_str)
    if method.lower() == 'get':
        do_get(name, host, path, headers, datas, check_str, resp_str)

    # print("This is result dict!!!!")
    # print(result_dict)
    # 结果收集
    su.exec_sql("insert into t_result values('{}','{}','{}','{}','{}','{}','{}','{}','{}','{}')"
                      .format(id,name,result_dict['result'],method,host,path,result_dict['headers'],result_dict['datas'],result_dict['response'],do_time))
    su.commit()