class GetSheetData:
def __init__(self):
self.excel = OperationExcel()
self.data_config = global_var()
self.read = ReadIni(conftest.env_dir)
self.op_json = OperationJson()
"""获取case行数"""
def get_case_lines(self):
lines = self.excel.get_rows()
return lines
"""是否运行"""
def is_run(self, row):
col = self.data_config.get_col_run()
run_model = self.excel.get_cell_value(row, col)
flag = None
if run_model == 'yes':
flag = True
else:
flag = False
return flag
"""获取case id"""
def get_id(self, row):
col = self.data_config.get_col_id()
case_id = self.excel.get_cell_value(row, col)
return case_id
"""获取api，拼接接口地址"""
def get_url(self, row):
col = self.data_config.get_col_api()
api = self.excel.get_cell_value(row, col)
url = self.read.get_value('base_url', 'api') + api
return url
"""获取请求方法"""
def get_method(self, row):
col = self.data_config.get_col_method()
method = self.excel.get_cell_value(row, col)
return method
"""获取是否有header，是则从json数据中获取headers"""
def get_header(self, row):
col = self.data_config.get_col_header()
header = self.excel.get_cell_value(row, col)
header_data = self.op_json.get_data('headers')
if header == 'yes':
return header_data
else:
return None
"""获取依赖的case id"""
def get_depend_id(self, row):
col = self.data_config.get_col_depend_id()
depend_id = self.excel.get_cell_value(row, col)
if depend_id == '':
return None
else:
return depend_id
"""获取依赖的数据"""
def get_depend_data(self, row):
col = self.data_config.get_col_depend_data()
depend_data = self.excel.get_cell_value(row, col)
if depend_data == '':
return None
else:
return depend_data
"""获取依赖数据的字段"""
def get_depend_key(self, row):
col = self.data_config.get_col_depend_key()
depend_key = self.excel.get_cell_value(row, col)
if depend_key == '':
return None
else:
return depend_key
"""根据命名的请求json名，获取请求数据"""
def get_request_data(self, row):
col = self.data_config.get_col_request_data()
request_data_key = self.excel.get_cell_value(row, col)
request_data = self.op_json.get_data(request_data_key)
if request_data == '':
return None
else:
return request_data
"""根据sql语句，获取期望值"""
def get_expect(self, row):
col = self.data_config.get_col_expect()
expect = self.excel.get_cell_value(row, col)
return expect
"""把结果写入实际结果中"""
def write_result(self, row, result,):
col = self.data_config.get_col_result()
self.excel.write_data(row, col, result)
class GetData:
def __init__(self):
self.opera_excel = OperationExcel()
self.xls_config = XlsConfiger()
#获取excel行数（case个数）
def get_lines(self):
return self.opera_excel.get_lines()
#获取是否执行
def get_isrun(self, row):
flag = None
col = int(self.xls_config.col_isrun())
run_model = self.opera_excel.get_cell_value(row, col)
if run_model == 'yes':
flag = True
else:
flag = False
return flag
#获取项目名
def get_proname(self, row):
col = int(self.xls_config.col_name())
name = self.opera_excel.get_cell_value(row, col)
return name
#获取本地目录
def get_localdir(self, row):
col = int(self.xls_config.col_localdir())
localdir = self.opera_excel.get_cell_value(row, col)
return localdir
#获取ftp目录
def get_ftpdir(self, row):
col = int(self.xls_config.col_ftpdir())
ftpdir = self.opera_excel.get_cell_value(row, col)
return ftpdir
#获取remote上war包的目录
def get_remote_package(self, row):
col = int(self.xls_config.col_remote_package())
remote_package = self.opera_excel.get_cell_value(row, col)
return remote_package
#获取remote上config文件的目录
def get_remote_config(self, row):
col = int(self.xls_config.col_remote_config())
remote_config = self.opera_excel.get_cell_value(row, col)
return remote_config
#获取tomcat目录
def get_tomcatdir(self, row):
col = int(self.xls_config.col_tomcatdir())
tomcatdir = self.opera_excel.get_cell_value(row, col)
return tomcatdir
#获取war包文件名
def get_warname(self, row):
col = int(self.xls_config.col_warname())
warname = self.opera_excel.get_cell_value(row, col)
return warname
#获取配置文件名
def get_configname(self, row):
col = int(self.xls_config.col_configname())
configname = self.opera_excel.get_cell_value(row, col)
return configname
#获取remoteIP
def get_remoteIP(self, row):
col = int(self.xls_config.col_remoteIP())
remoteIP = self.opera_excel.get_cell_value(row, col)
return remoteIP
#获取remoteIP
def get_testurl(self, row):
col = int(self.xls_config.col_testurl())
testurl = self.opera_excel.get_cell_value(row, col)
return testurl