def write_excel_value(self, dep_res):
'''
将依赖数据结果写回到excel表格指定的单元格中
:param dep_res:
:return:
'''
write_flag = False
ope_excel = OperationExcel(**self.case_config)
case_param_name_start = self.case_config.get("case_param_name_start",
0) #测试用例参数名开始行
case_row_value = ope_excel.get_sheet().row_values(
case_param_name_start)
row_num = self.case_rownum
dep_res_dict = self.deal_req_res(dep_res)
for update_param in dep_res_dict.keys():
for index, update_value in enumerate(case_row_value):
if update_param in str(update_value).split("-")[1]:
col_num = index
ope_excel.writer_data(row_num, col_num, update_value)
write_flag = True
return write_flag
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)