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 __init__(self, file_name, sheet_name, desired_caps={}, server_url=''):
g.start_time = time.strftime("@%Y%m%d_%H%M%S", time.localtime())
if desired_caps:
self.desired_caps = desired_caps
else:
self.desired_caps = {
'platformName': 'Desktop',
'browserName': 'Chrome'
}
self.server_url = server_url
self.conditions = {}
g.project_name = file_name.split('-')[0]
self.testcase_file = path.join('testcase',
file_name + '-' + _testcase + '.xlsx')
self.elements_file = path.join(
'element', g.project_name + '-' + _elements + '.xlsx')
self.report_xml = path.join(
'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_workbook = Excel(
path.join('report',
file_name + '-' + _report + g.start_time + '.xlsx'), 'w')
self.report_data = {} # 测试报告详细数据
def __init__(self, file_name, sheet_name, desired_caps={}, server_url=''):
g.start_time = time.strftime("@%Y%m%d_%H%M%S", time.localtime())
if desired_caps:
self.desired_caps = desired_caps
desired_caps_init = {
"noReset": True,
"unicodeKeyboard": True,
"newCommandTimeout": "600",
}
self.desired_caps.update(desired_caps_init)
else:
self.desired_caps = {
'platformName': 'Desktop',
'browserName': 'Chrome'
}
self.server_url = server_url
self.conditions = {}
g.project_name = file_name.split('-')[0]
self.testcase_file = path.join('testcase',
file_name + '-' + _testcase + '.xlsx')
self.elements_file = path.join(
'element', g.project_name + '-' + _elements + '.xlsx')
if not path.exists('junit'):
os.mkdir('junit')
self.report_xml = path.join(
'junit', file_name + '-' + _report + g.start_time + '.xml')
#打开excel
self.testcase_workbook = Excel(self.testcase_file, 'r')
#获取列表
self.sheet_names = self.testcase_workbook.get_sheet(sheet_name)
if not path.exists('report'):
os.mkdir('report')
#写方式打开report-excel
self.report_workbook = Excel(
path.join('report',
file_name + '-' + _report + g.start_time + '.xlsx'), 'w')
self.report_data = {} # 测试报告详细数据
def __init__(self, file_name, sheet_name, platform='Web', app='Chrome'):
g.start_time = time.strftime("@%Y%m%d_%H%M%S", time.localtime())
self.platform = platform
self.app = app
g.project_name = file_name.split('-')[0]
self.testcase_file = path.join('testcase',
file_name + '-' + _testcase + '.xlsx')
self.elements_file = path.join(
'element', g.project_name + '-' + _elements + '.xlsx')
self.report_file = path.join('report',
file_name + '-' + _report + '.xlsx')
self.report_xml = path.join('junit',
file_name + '-' + _report + '.xml')
self.testcase_workbook = Excel(self.testcase_file, 'r')
self.sheet_names = self.testcase_workbook.get_sheet(sheet_name)
self.report_workbook = Excel(
self.report_file.split('.')[0] + g.start_time + '.xlsx', 'w')
def get_elements(self, elements_file):
d = Excel(elements_file)
self.elements = elements_format(data2dict(d.read('elements')))
class Autotest:
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 fliter(self, **kwargs):
# 筛选要执行的测试用例
self.conditions = kwargs
def plan(self):
self.code = 0 # 返回码
# 1.解析配置文件
try:
e.get_elements(self.elements_file)
except:
logger.exception('*** Parse config file failure ***')
self.code = -1
sys.exit(self.code)
self.junit = JUnit()
self.junit_suite = {}
# 2.逐个执行测试套件
for sheet_name in self.sheet_names:
g.sheet_name = sheet_name
# xml 测试报告初始化
self.junit_suite[sheet_name] = self.junit.create_suite(
g.plan_name, sheet_name)
self.junit_suite[sheet_name].start()
self.run(sheet_name)
self.plan_data = g.plan_end()
self.testsuite_data = g.testsuite_data
summary_data = summary(
self.plan_data, self.testsuite_data, self.report_data, {})
self.report_workbook.write(summary_data, '_Summary_')
self.report_workbook.close()
with open(self.report_xml, 'w', encoding='utf-8') as f:
self.junit.write(f)
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 failure ***')
self.code = -1
sys.exit(self.code)
# 2.初始化全局对象
try:
g.set_driver()
# 如果测试数据文件存在，则从该文件里读取数据，赋值到全局变量列表里
data_file = Path('data') / (g.plan_name +
'-' + sheet_name + '.csv')
if data_file.is_file():
g.var = get_record(str(data_file))
w.init()
except:
logger.exception('*** Init global object failure ***')
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 failure ***')
self.code = -1
sys.exit(self.code)
# 4.执行测试套件
ts = TestSuite(testsuite, sheet_name,
self.junit_suite[sheet_name], self.conditions)
ts.run()
# 5.判断测试结果
if self.junit_suite[sheet_name].high_errors + self.junit_suite[sheet_name].medium_errors + \
self.junit_suite[sheet_name].high_failures + self.junit_suite[sheet_name].medium_failures:
self.code = -1
# 6.保存测试结果
try:
data = testsuite2data(testsuite)
self.report_workbook.write(data, sheet_name)
self.report_data[sheet_name] = testsuite2report(testsuite)
except:
logger.exception('*** Save the report is failure ***')
class Autotest:
def __init__(self, file_name, sheet_name, platform='Web', app='Chrome'):
g.start_time = time.strftime("@%Y%m%d_%H%M%S", time.localtime())
self.platform = platform
self.app = app
g.project_name = file_name.split('-')[0]
self.testcase_file = path.join('testcase',
file_name + '-' + _testcase + '.xlsx')
self.elements_file = path.join(
'element', g.project_name + '-' + _elements + '.xlsx')
self.report_file = path.join('report',
file_name + '-' + _report + '.xlsx')
self.report_xml = path.join('junit',
file_name + '-' + _report + '.xml')
self.testcase_workbook = Excel(self.testcase_file, 'r')
self.sheet_names = self.testcase_workbook.get_sheet(sheet_name)
self.report_workbook = Excel(
self.report_file.split('.')[0] + g.start_time + '.xlsx', 'w')
def plan(self):
self.code = 0 # 返回码
# 1.解析配置文件
try:
e.get_elements(self.elements_file)
except:
logger.exception('*** Parse config file fail ***')
self.code = -1
sys.exit(self.code)
self.report = Report()
self.report_ts = {}
# 2.逐个执行测试套件
for sheet_name in self.sheet_names:
g.sheet_name = sheet_name
# xml 测试报告初始化
self.report_ts[sheet_name] = self.report.create_suite(
g.project_name, sheet_name)
self.report_ts[sheet_name].start()
self.run(sheet_name)
self.report_workbook.close()
with open(self.report_xml, 'w', encoding='utf-8') as f:
self.report.write(f)
sys.exit(self.code)
def run(self, sheet_name):
# 1.从 Excel 获取测试用例集
try:
data = self.testcase_workbook.read(sheet_name)
testsuite = testsuite_format(data)
logger.info('Testsuite imported from Excle:\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.set_driver(self.platform, self.app)
# 如果测试数据文件存在，则从该文件里读取一行数据，赋值到全局变量列表里
data_file = path.join('data',
g.project_name + '-' + sheet_name + '.csv')
if path.exists(data_file):
g.var = get_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])
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:
data = testsuite2data(testsuite)
self.report_workbook.write(data, sheet_name)
except:
logger.exception('*** Save the report is fail ***')
def testsuite_from_excel(file_name, sheet_name):
d = Excel(file_name)
return testsuite_format(data2dict(d.read(sheet_name)))
class Autotest:
def __init__(self, file_name, sheet_name, desired_caps={}, server_url=''):
g.start_time = time.strftime("@%Y%m%d_%H%M%S", time.localtime())
if desired_caps:
self.desired_caps = desired_caps
desired_caps_init = {
"noReset": True,
"unicodeKeyboard": True,
"newCommandTimeout": "600",
}
self.desired_caps.update(desired_caps_init)
else:
self.desired_caps = {
'platformName': 'Desktop',
'browserName': 'Chrome'
}
self.server_url = server_url
self.conditions = {}
g.project_name = file_name.split('-')[0]
self.testcase_file = path.join('testcase',
file_name + '-' + _testcase + '.xlsx')
self.elements_file = path.join(
'element', g.project_name + '-' + _elements + '.xlsx')
if not path.exists('junit'):
os.mkdir('junit')
self.report_xml = path.join(
'junit', file_name + '-' + _report + g.start_time + '.xml')
#打开excel
self.testcase_workbook = Excel(self.testcase_file, 'r')
#获取列表
self.sheet_names = self.testcase_workbook.get_sheet(sheet_name)
if not path.exists('report'):
os.mkdir('report')
#写方式打开report-excel
self.report_workbook = Excel(
path.join('report',
file_name + '-' + _report + g.start_time + '.xlsx'), 'w')
self.report_data = {} # 测试报告详细数据
def fliter(self, **kwargs):
# 筛选要执行的测试用例
self.conditions = kwargs
#测试套件执行
def plan(self):
self.code = 0 # 返回码
# 1.解析配置文件
try:
e.get_elements(self.elements_file)
except:
logger.exception('*** Parse config file fail ***')
self.code = -1
sys.exit(self.code)
self.report = Report()
self.report_ts = {}
# 2.逐个执行测试套件
for sheet_name in self.sheet_names:
g.sheet_name = sheet_name
# xml 测试报告初始化
self.report_ts[sheet_name] = self.report.create_suite(
g.project_name, sheet_name)
self.report_ts[sheet_name].start()
self.run(sheet_name)
self.report_workbook.close()
with open(self.report_xml, 'w', encoding='utf-8') as f:
self.report.write(f)
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 ***')
