class Data:
col_case_id = 0
col_api = 1
col_is_live = 2
col_is_run = 3
col_method = 4
col_is_header = 5
col_depend_id = 6
col_depend_data = 7
col_depend_key = 8
col_request_data = 9
col_expect = 10
col_result = 11
def __init__(self):
self.data = Excel()
pass
def get_case_id(self, rowx):
colx = Data.col_case_id
return self.data.get_cell(rowx, colx)
def get_api(self, rowx):
colx = Data.col_api
return self.data.get_cell(rowx, colx)
def get_is_live(self, rowx):
colx = Data.col_is_live
return self.data.get_cell(rowx, colx)
def get_is_run(self, rowx):
colx = Data.col_is_run
return self.data.get_cell(rowx, colx)
def get_method(self, rowx):
colx = Data.col_method
return self.data.get_cell(rowx, colx)
def get_is_header(self, rowx):
colx = Data.col_is_header
return self.data.get_cell(rowx, colx)
def get_depend_id(self, rowx):
colx = Data.col_depend_id
return self.data.get_cell(rowx, colx)
def get_depend_data(self, rowx):
colx = Data.col_depend_data
return self.data.get_cell(rowx, colx)
def get_depend_key(self, rowx):
colx = Data.col_depend_key
return self.data.get_cell(rowx, colx)
def get_request_data(self, rowx):
colx = Data.col_request_data
return self.data.get_cell(rowx, colx)
def get_expect(self, rowx):
colx = Data.col_expect
return self.data.get_cell(rowx, colx)
def row_total(self):
return self.data.get_rows()
def write_passed_result(self, rowx):
# 设置样式
pattern = xlwt.Pattern()
pattern.pattern = xlwt.Pattern.SOLID_PATTERN
pattern.pattern_fore_colour = 3 # 5 背景颜色为黄色
# 1 = White, 2 = Red, 3 = Green, 4 = Blue, 5 = Yellow, 6 = Magenta, 7 = Cyan, 16 = Maroon,
# 17 = Dark Green, 18 = Dark Blue, 19 = Dark Yellow , almost brown), 20 = Dark Magenta, 21 = Teal,
# 22 = Light Gray, 23 = Dark Gray
style = xlwt.XFStyle()
style.pattern = pattern
# 写入数据并保存
colx = Data.col_result
self.data.write_data(rowx, colx, 'PASS', style)
def write_failed_result(self, rowx, actual_result):
# 设置样式
pattern = xlwt.Pattern()
pattern.pattern = xlwt.Pattern.SOLID_PATTERN
pattern.pattern_fore_colour = 2 # 5 背景颜色为黄色
# 1 = White, 2 = Red, 3 = Green, 4 = Blue, 5 = Yellow, 6 = Magenta, 7 = Cyan, 16 = Maroon,
# 17 = Dark Green, 18 = Dark Blue, 19 = Dark Yellow , almost brown), 20 = Dark Magenta, 21 = Teal,
# 22 = Light Gray, 23 = Dark Gray
style = xlwt.XFStyle()
style.pattern = pattern
# 写入数据并保存
colx = Data.col_result
self.data.write_data(rowx, colx, actual_result, style)
class GetData():
def __init__(self):
self.excel=Excel()
self.method=Method()
def get_case_lines(self):
return self.excel.get_lines()
def get_id(self,row):
col=DataConfig.id
return self.excel.get_cell_value(row,col)
def get_name(self,row):
col=DataConfig.name
return self.excel.get_cell_value(row,col)
def get_url(self,row):
col=DataConfig.url
return self.excel.get_cell_value(row,col)
def get_is_run(self,row):
col=DataConfig.is_run
flag=None
is_run=self.excel.get_cell_value(row,col)
if is_run=='yes':
flag=True
else:
flag=False
return flag
def get_request_method(self,row):
col=DataConfig.method
return self.excel.get_cell_value(row,col)
def get_request_data(self,row):
col=DataConfig.data
request_data=self.excel.get_cell_value(row,col)
return json.loads(request_data)
def get_expect(self,row):
col=DataConfig.expect
return self.excel.get_cell_value(row,col)
def write_result(self,row,value):
col=DataConfig.result
self.excel.write_data(row,col,value)
def write_response_data(self,row,value):
col=DataConfig.response
value=json.dumps(value)
self.excel.write_data(row,col,value)
def get_case_depend(self,row):
col=DataConfig.case_depend
case_depend=self.excel.get_cell_value(row,col)
if case_depend=='':
return None
else:
return case_depend
def get_data_depend(self,row):
col=DataConfig.data_depned
return self.excel.get_cell_value(row,col)
def get_data_key_depend(self,row):
col=DataConfig.data_key_depend
return self.excel.get_cell_value(row,col)