def __init__(self, file_name, sheet_name, desired_caps={}, server_url=''):
if desired_caps:
self.desired_caps = desired_caps
else:
self.desired_caps = {
'platformName': 'Desktop', 'browserName': 'Chrome'}
self.server_url = server_url
self.conditions = {}
g.plan_name = file_name.split('-')[0]
g.init(self.desired_caps, self.server_url)
log_path = Path('snapshot') / g.plan_name / g.start_time[1:]
for p in ('JUnit', 'report', 'snapshot', log_path, 'report/' + g.plan_name):
mkdir(p)
g.plan_data['log'] = set_log(logger, log_path)
self.testcase_file = str(
Path('testcase') / (file_name + '-' + _testcase + '.xlsx'))
self.elements_file = str(
Path('element') / (g.plan_name + '-' + _elements + '.xlsx'))
self.report_xml = str(
Path('JUnit') / (file_name + '-' + _report + g.start_time + '.xml'))
self.testcase_workbook = Excel(self.testcase_file, 'r')
self.sheet_names = self.testcase_workbook.get_sheet(sheet_name)
self.report_excel = str(Path(
'report') / g.plan_name / (file_name + '-' + _report + g.start_time + '.xlsx'))
self.report_workbook = Excel(self.report_excel, 'w')
self.report_data = {} # 测试报告详细数据
def run(self, sheet_name):
# 1.从 Excel 获取测试用例集
try:
data = self.testcase_workbook.read(sheet_name)
testsuite = testsuite_format(data)
# logger.info('Testsuite imported from Excel:\n' +
# json.dumps(testsuite, ensure_ascii=False, indent=4))
logger.info('From Excel import testsuite success')
except:
logger.exception('*** From Excel import testsuite fail ***')
self.code = -1
sys.exit(self.code)
# 2.初始化全局对象
try:
g.init(self.desired_caps, self.server_url)
g.set_driver()
# 如果测试数据文件存在，则从该文件里读取一行数据，赋值到全局变量列表里
data_file = path.join('data',
g.project_name + '-' + sheet_name + '.csv')
if path.exists(data_file):
g.var = get_record(data_file)
data_file = path.join(
'data', g.project_name + '-' + sheet_name + '-globle.txt')
if path.exists(data_file):
g.var.update(get_all_record(data_file))
w.init()
except:
logger.exception('*** Init global object fail ***')
self.code = -1
sys.exit(self.code)
# 3.解析测试用例集
try:
parse(testsuite)
logger.debug('testsuite has been parsed:\n' + str(testsuite))
except:
logger.exception('*** Parse testsuite fail ***')
self.code = -1
sys.exit(self.code)
# 4.执行测试套件
ts = TestSuite(testsuite, self.report_ts[sheet_name], self.conditions)
ts.run()
# 5.判断测试结果
if self.report_ts[sheet_name].high_errors + self.report_ts[sheet_name].medium_errors + \
self.report_ts[sheet_name].high_failures + self.report_ts[sheet_name].medium_failures:
self.code = -1
# 6.保存测试结果
try:
self.report_data[sheet_name] = testsuite2report(testsuite)
data = testsuite2data(testsuite)
self.report_workbook.write(data, sheet_name)
except:
logger.exception('*** Save the report is fail ***')
