Python接口自动化实战---4.TestCase数据读取

TestCase数据读取

1.Testcase模板(Excel)

    Id = 'ID'
    request_model = '模块名称'
    request_method = '请求方式'
    url = '接口地址'
    is_run = '是否运行'
    header = 'Header'
    token = 'Token'
    case_depend = 'case依赖'
    data_depend = '数据依赖'
    request_data = '请求数据'
    response_data = '返回数据'
    expect = '预期结果'
    result = '实际结果'

2.依据caseid取出相应的case信息

    # 根据caseid获取到数据行信息
    def get_line_data(self, caseid):
        if type(self.get_data_lines()) is dict:
            # print("Testcase is only 1")
            if self.get_data_lines()[0]["ID"] == caseid:
                line_data = self.get_data_lines()
                return line_data
        else:
            for j in range(0, len(self.get_data_lines())):
                if self.get_data_lines()[j]["ID"] == caseid:
                    line_data = self.get_data_lines()[j]
                    return line_data

	# 获取模块信息
    @staticmethod
    def get_requset_model(caseid):
        request_model = operationExcelData().get_line_data(caseid)[operationExcelData().request_model]
        return request_model

    # 获取请求方式
    @staticmethod
    def get_requset_method(caseid):
        request_method = operationExcelData().get_line_data(caseid)[operationExcelData().request_method]
        return request_method

    # 获取api信息
    @staticmethod
    def get_api(caseid):
        request_api = operationExcelData().get_line_data(caseid)[operationExcelData().url]
        return request_api

    @staticmethod
    # 获取是否执行
    def get_is_run(caseid):
        flag = None
        run_module = operationExcelData().get_line_data(caseid)[operationExcelData().is_run]
        if run_module == 'yes':
            flag = False
        else:
            flag = True
        return flag

    # 是否需要header
    @staticmethod
    def get_header(caseid):
        flag = None
        run_header = operationExcelData().get_line_data(caseid)[operationExcelData().header]
        if run_header == 'yes':
            flag = True
        else:
            flag = False
        return flag

    # 是否需要token
    @staticmethod
    def get_token(caseid):
        flag = None
        run_token = operationExcelData().get_line_data(caseid)[operationExcelData().token]
        if run_token == 'yes':
            flag = True
        else:
            flag = False
        return flag

    # 是否有依赖case
    @staticmethod
    def get_depend_case(caseid):
        run_depend_case = operationExcelData().get_line_data(caseid)[operationExcelData().case_depend]
        return run_depend_case

    # 是否有依赖数据
    @staticmethod
    def get_depend_data(caseid):
        run_depend_data = operationExcelData().get_line_data(caseid)[operationExcelData.data_depend]
        return run_depend_data

    # 请求数据
    @staticmethod
    def get_request_data(caseid):
        if operationExcelData().get_line_data(caseid)[operationExcelData.request_data] == '':
            get_request_data = None
        else:
            get_request_data = operationExcelData().get_line_data(caseid)[operationExcelData.request_data]
        # get_request_data = OperationExcel().get_data_line(caseid)[global_var.get_requset_data()]
        return get_request_data

    # 返回数据
    @staticmethod
    def get_response_data(caseid):
        get_response_data = operationExcelData().get_line_data(caseid)[operationExcelData.response_data]
        return get_response_data

    # 预期结果
    @staticmethod
    def get_expect_data(caseid):
        get_expect_data = operationExcelData().get_line_data(caseid)[operationExcelData.expect]
        return get_expect_data

    # 实际结果
    @staticmethod
    def get_result_data(caseid):
        get_result_data = operationExcelData().get_line_data(caseid)[operationExcelData.result]
        return get_result_data

优化方向：(可以自己尝试动手一下，将自己的讲解在评论中表达)
	1.字段值可以通过dict存储
	2.case信息可以通过循环取值
	未完待续.......