class CaseDetail: def __init__(self, filename=None, sheetid=0): try: if filename: self.filename = filename else: self.filename = "../data_file/TestCase_zh.xlsx" self.op_excel = OperationExcel(self.filename, 0) except Exception as e: log.error("获取中文用例表类初始化信息出现异常,异常原因:{}".format(e)) def get_case_detail(self, caseid, col): ''' 获取用例描述信息 :return: ''' try: row_num = self.op_excel.get_row_num_for_value(caseid) case_detail = self.op_excel.get_cell_value(row_num, col) return case_detail except Exception as e: log.error("获取中文用例表信息方法出现异常,异常原因:{}".format(e)) def is_pass(self, exp, res, re): pass
class GetData: def __init__(self, excel_filename=None, json_filanme=None, excel_sheetid=0): self.excel_filename = excel_filename self.excel_sheetid = excel_sheetid self.json_filename = json_filanme self.ope_excel = OperationExcel(self.excel_filename, self.excel_sheetid) self.ope_json = OperationJson(self.json_filename) #获取excel表格行数 def excel_rows(self): return self.ope_excel.get_sheet_rows() #获取是否运行 def is_run(self, row): col = get_is_run_col() is_run = self.ope_excel.get_cell_value(row, col) if str(is_run).strip().lower() == 'yes': run_flag = True else: run_flag = False return run_flag #获取headers def is_header(self, row): col = get_is_header_col() is_header = self.ope_excel.get_cell_value(row, col) if str(is_header).strip().lower() == 'yes': headers = get_header() else: headers = None return headers #获取请求路径 def get_url(self, row): col = get_url_col() return self.ope_excel.get_cell_value(row, col) #获取请求方法 def get_req_method(self, row): col = get_request_method_col() return self.ope_excel.get_cell_value(row, col) #获取请求数据 def get_req_data(self, row): col = get_request_data_col() req_data_key = self.ope_excel.get_cell_value(row, col) res = self.ope_json.get_data_for_key(req_data_key) if res == '': #防止在excel用例里面直接写入的请求数据 res = req_data_key return res # 获取case数据依赖 def get_case_dep(self, row): col = get_case_dep_col() res = self.ope_excel.get_cell_value(row, col) return res # 获取依赖的返回值规则 def get_dep_ret_data_re(self, row): col = get_dep_ret_value_re_col() return self.ope_excel.get_cell_value(row, col) # 获取依赖的返回值 def get_dep_ret_data(self, row): col = get_dep_ret_value_col() return self.ope_excel.get_cell_value(row, col) # 获取依赖字段 def get_data_dep_key(self, row): col = get_data_dep_col() return self.ope_excel.get_cell_value(row, col) # 获取预期结果 def get_expect_res(self, row): col = get_expect_col() return self.ope_excel.get_cell_value(row, col) # 往excel表中写入按规则获取的依赖返回数据 def writer_dep_res_data(self, row, data): col = get_dep_ret_value_col() return self.ope_excel.writer_data(row, col, data) # 往excel表中写入实际运行结果 def writer_real_data(self, row, data): col = get_real_result_col() return self.ope_excel.writer_data(row, col, data) # 往excel表中写入用例通过状态 def writer_status(self, row, data): col = get_status_col() return self.ope_excel.writer_data(row, col, data)