def __init__(self):
self.excel_obj = ExcelOpt()
self.res_title = {0: 'Case_ID',
1: 'URI',
2: 'Request_Info',
3: 'Expect_Result',
4: 'Actual_Result',
5: 'Test_Result'}
class TestCases():
def __init__(self):
self.excel_obj = ExcelOpt()
self.res_title = {0: 'Case_ID',
1: 'URI',
2: 'Request_Info',
3: 'Expect_Result',
4: 'Actual_Result',
5: 'Test_Result'}
def input_title(self, sheet_name):
for key, value in self.res_title.items():
self.excel_obj.write_data(sheet_name, 0, key, value, self.excel_obj.title_style())
def do(self, sheet_name):
res_sheet_name = self.excel_obj.res_book.add_sheet(sheet_name)
self.input_title(res_sheet_name)
case_exec.CaseExec(self.excel_obj).run(sheet_name, res_sheet_name, self.res_title)
def case_sheet1(self):
sheet_name = 'Sheet1'
self.do(sheet_name)
def case_sheet2(self):
sheet_name = 'Sheet2'
self.do(sheet_name)
def case_sheet3(self):
sheet_name = 'Sheet3'
self.do(sheet_name)
def save(self):
output_path = './output'
res_file = time.strftime('%Y-%m-%d %H-%M-%S', time.localtime(time.time()))
self.excel_obj.close(output_path + '/' + res_file + '.xls')
