class DependentData:
def __init__(self,case_id):
self.case_id=case_id
self.opera_excle=OperationExcle()
self.data=GetData()
#通过case_id去获取该case_id的整行数据
def get_case_line_data(self):
rows_data=self.opera_excle.get_rows_data(self.case_id)
return rows_data
#执行依赖测试，获取结果
def run_dependent(self):
run_method=RunMethod()
row_num=self.opera_excle.get_row_num(self.case_id)
# request_data=self.data.get_data_for_json(row_num)
request_data = self.data.get_request_data(row_num)
header=self.data.get_is_header(row_num)
method=self.data.get_request_method(row_num)
url=self.data.get_url(row_num)
res=run_method.run_main(method,url,request_data,header)
return json.loads(res)
#根据依赖key去获取执行依赖测试case的响应，然后返回
def get_data_for_key(self,row):
depend_data=self.get_data_for_key(row)
#response_data为依赖测试的执行结果
response_data=self.run_dependent()
#定义要获取的key
json_exe=parse(depend_data)
#定义响应数据,key从响应数据里获取
madle=json_exe.find(response_data)
#math.value返回的是一个list，可以使用索引访问特定的值jsonpath_rw的作用就相当于从json里面提取响应的字段值
return [math.value for math in madle][0]
class DependdentData:
def __init__(self, case_id):
self.case_id = case_id
self.opera_excel = OperationExcel()
self.data = GetData()
#通过case_id去获取该case_id的整行数据
def get_case_line_data(self):
rows_data = self.opera_excel.get_rows_data(self.case_id)
return rows_data
#执行依赖测试，获取结果
def run_dependent(self):
run_method = RunMethod()
row_num = self.opera_excel.get_row_num(self.case_id)
request_data = self.data.get_data_for_json(row_num)
#header = self.data.is_header(row_num)
method = self.data.get_request_method(row_num)
url = self.data.get_request_url(row_num)
res = run_method.run_main(method, url, request_data)
return json.loads(res)
#根据依赖的key去获取执行依赖测试case的响应,然后返回
def get_data_for_key(self, row):
depend_data = self.data.get_depend_key(row)
response_data = self.run_dependent()
json_exe = parse(depend_data)
madle = json_exe.find(response_data)
return [math.value for math in madle][0]
def write_dependSql(row):
Gd = GetData()
falg=Gd.get_sqlExecuteResult(row)
if falg:
execute_result = Gd.write_sqlExecuteResultToRequestData(row)
return execute_result
else:
return False
def __init__(self, case_id):
super().__init__()
# 实例依赖字段yaml文件
self.yamlField = OperationYaml('dependFieldInfo.yaml')
# 数据依赖字段实例
self.dependFieldYaml = ''
self.case_id = case_id
self.data = GetData()
self.depend_key_dict = {} #存放依赖key数据
def write_excle():
Gd = GetData()
row=Gd.get_case_line()
for i in range(2,row+1):
# for i in range(16,row+1):
caseid = Gd.get_caseId(i)
if caseid:
falg=write_dependField(i)
# print(falg)
if not falg:
write_dependSql(i)
def write_dependField(row):
Gd=GetData()
depend_case_id = Gd.is_depend(row)
if depend_case_id:
depend = DependentData(depend_case_id)
# 获取依赖key
depent_key=Gd.get_depent_key(row)
# print(depent_key)
# 将依赖数据写入请求数据
flag=depend.writeDependRequestDataToExcle(row)
# print(flag)
return flag
else:
return False
class Run_test:
def __init__(self):
self.data = GetData()
self.runMethod = RunMethod()
def run_case(self):
rows = self.data.get_case_lines()
#row = 0
for row in range(1, rows):
is_run = self.data.get_is_run(row)
print(is_run)
if is_run == True:
url = self.data.get_url(row)
print(url)
method = self.data.get_request_method(row)
print(method)
#header = self.data.get_header(row)
depend_case = self.data.is_depend(row)
print(depend_case)
#request_data = self.data.get_data_for_json(row)
request_data = self.data.get_request_data(row)
body = json.dumps(request_data)
print(request_data)
#method = 'post'
#url = 'http://10.128.0.150:8002/backend/user/login'
headers = {"Content-Type": "application/json;charset=UTF-8"}
#headers = json.dumps(headerstring)
'''bodystring = {"username" : "super", "password" : "Connext@0101"}
body = json.dumps(bodystring)'''
#res = self.runMethod.run_main(method, url, request_data, headers)
print("==========")
#print(res)
if depend_case != None:
depend_data = DependentData(depend_case)
depend_res = depend_data.run_dependent(depend_data.case_id)
print(depend_res)
#self.depend_data = DependentData(depend_case)
# 获取依赖响应数据
depend_response_key = depend_data.get_data_for_key(row)
# 获取依赖的key（数据依赖字段excel）
depend_key = self.data.get_depend_field(row)
print(depend_key)
#request_data[depend_key] = depend_response_key
#op_json = OperrationJson('../dataconfig/user.json')
# header = OperrationJson.get_data('token')
#headers = {'Content-Type': 'application/json;charset=UTF-8'}
#body = {'username': '******', 'password': '******'}
else:
res = self.runMethod.run_main(method, url, request_data, headers)
print(res)
else:
print("NO way")
def __init__(self):
self.run_method = RunMethod()
self.data = GetData()
self.com_util = CommonUtil()
self.send_mai = SendEmail()
class RunTest:
def __init__(self):
self.run_method = RunMethod()
self.data = GetData()
self.com_util = CommonUtil()
self.send_mai = SendEmail()
#程序执行的
def go_on_run(self):
res = None
pass_count = []
fail_count = []
#10 0,1,2,3
rows_count = self.data.get_case_lines()
for i in range(1, rows_count):
is_run = self.data.get_is_run(i)
if is_run:
url = self.data.get_request_url(i)
method = self.data.get_request_method(i)
request_data = self.data.get_data_for_json(i)
expect = self.data.get_expcet_data_for_mysql(i)
header = self.data.is_header(i)
depend_case = self.data.is_depend(i)
if depend_case != None:
self.depend_data = DependdentData(depend_case)
#获取的依赖响应数据
depend_response_data = self.depend_data.get_data_for_key(i)
#获取依赖的key
depend_key = self.data.get_depend_field(i)
request_data[depend_key] = depend_response_data
if header == 'write':
res = self.run_method.run_main(method, url, request_data)
op_header = OperationHeader(res)
op_header.write_cookie()
elif header == 'yes':
op_json = OperetionJson('../dataconfig/cookie.json')
cookie = op_json.get_data('apsid')
cookies = {'apsid': cookie}
res = self.run_method.run_main(method, url, request_data,
cookies)
else:
res = self.run_method.run_main(method, url, request_data)
# print(res)
if self.com_util.is_equal_dict(expect, res) == 0:
self.data.write_result(i, 'pass')
pass_count.append(i)
else:
self.data.write_result(i, res)
fail_count.append(i)
self.send_mai.send_main(pass_count, fail_count)
def __init__(self):
self.Ope = OperationExcle()
self.data = GetData()
class Write_testReport_excle():
global workbook, worksheet, chart, formatter, title_formatter, ave_formatter, now, filename
now = time.strftime("%Y-%m-%d %H-%M-%S")
workbook_path = "../report/excle_report/"
if not os.path.exists(workbook_path):
os.mkdir(workbook_path)
workbook = xlsxwriter.Workbook(workbook_path + now + '_test_report.xls')
filename = '../report/excle_report/' + now + '_test_report.xls'
worksheet = workbook.add_worksheet("测试报告")
# 创建一个图表对象,column:柱形图
chart = workbook.add_chart({'type': 'column'})
# # 定义平均值栏数据格式对象：边框加粗1像素，数字按2位小数显示
# ave_formatter = workbook.add_format()
# ave_formatter.set_border(1)
# ave_formatter.set_num_format('0.00')
def __init__(self):
self.Ope = OperationExcle()
self.data = GetData()
# self.workbook=workbook
# self.worksheet=worksheet
def create_TestReport(self):
worksheet.set_column("A:ZZ", 20)
# bold = workbook.add_format({"bold": True})
# 定义标题栏格式对象：边框加粗1像素，背景色为灰色，单元格内容居中、加粗，自动换行
formatter = workbook.add_format()
formatter.set_border(1)
formatter.set_text_wrap()
title_formatter = workbook.add_format()
title_formatter.set_border(1)
title_formatter.set_bg_color('#cccccc')
title_formatter.set_align('center')
title_formatter.set_bold()
title_formatter.set_text_wrap()
title = ['系统名称', '通过接口个数', '失败接口个数', '全部接口个数', '测试通过率', '测试失败率']
buname = ['SCM3.0', '居家小二app', '发货宝', '运营后台系统', '直营oms系统']
worksheet.write_row("A1", title, title_formatter)
worksheet.write_column("A2", buname, formatter)
def write_TestReport(self, pass_list, fail_list):
pass_num = float(len(pass_list))
fail_num = float(len(fail_list))
all_num = pass_num + fail_num
pass_result = "%.2f%%" % (pass_num / all_num * 100)
fail_result = "%.2f%%" % (fail_num / all_num * 100)
data = [[pass_num, fail_num, all_num, pass_result, fail_result],
[pass_num, fail_num, all_num, pass_result, fail_result],
[pass_num, fail_num, all_num, pass_result, fail_result],
[pass_num, fail_num, all_num, pass_result, fail_result],
[pass_num, fail_num, all_num, pass_result, fail_result]]
#添加柱形图
list1 = ('B', 'C', 'D')
for row_num in list1:
chart.add_series({
"name":
"=测试报告!${}$1".format(row_num, row_num),
"categories":
"=测试报告!$A$2:$A$6",
"values":
"=测试报告!${}$2:${}$6".format(row_num, row_num)
})
# 添加柱状图标题
chart.set_title({"name": "各个系统接口测试报告"})
# Y轴名称
chart.set_y_axis({"name": "接口数量明细"})
# X轴名称
chart.set_x_axis({"name": "系统名称"})
# 图表样式
chart.set_style(10)
#设置图表大小
chart.set_size({'width': 600, 'height': 400})
# 插入图表带偏移
worksheet.insert_chart('G2', chart, {'x_offset': 25, 'y_offset': 10})
# 定义标题栏格式对象：边框加粗1像素，背景色为灰色，单元格内容居中、加粗,自动换行
formatter = workbook.add_format()
formatter.set_border(1)
formatter.set_text_wrap()
# 写入第2到第6行的数据，并将第2~6行数据加入图表系列
for i in range(2, 7):
worksheet.write_row('B{}'.format(i), data[i - 2], formatter)
self.create_TestReport()
self.write_faild_to_excle()
# workbook.close()
def write_faild_to_excle(self):
rows_count = self.data.get_case_line()
#定义标题栏格式对象：边框加粗1像素，背景色为灰色，单元格内容居中、加粗,自动换行
formatter = workbook.add_format()
formatter.set_border(1)
formatter.set_font_color('red')
formatter.set_text_wrap()
for i in range(1, rows_count):
#将失败的用例写入测试报告中
if not self.data.get_result(i) == 'pass':
# print(self.Ope.get_row_values(i))
# print(self.data.get_result(i))
worksheet.write_row('A{}'.format(i + 8),
self.Ope.get_row_values(i), formatter)
else:
pass
# worksheet.write_row('A{}'.format(i+8+rows_count), self.Ope.get_row_values(i),formatter)
workbook.close()
def excle_to_html(self):
# 注意这里不能直接使用workbook,因为直接引用workbook返回的对象不是一个文件路径，而是:<class 'xlsxwriter.workbook.Workbook'>
fp = pandas.ExcelFile(filename)
df = fp.parse()
html_report_path = '../report/html_report/'
if not os.path.exists(html_report_path):
os.mkdir(html_report_path)
with codecs.open(html_report_path + now + '_test_report.html', 'w',
'utf-8') as html_file:
html_file.write(df.to_html(header=True, index=False))
class RunTest(GetData):
# 实例化前完成所有的请求数据依赖处理
@staticmethod
def write_depend_data():
options = input('是否需要执行用例依赖数据写入操作,确认执行请输入yes,不执行请输入其他任意字符:\n')
if options == 'yes':
write_excle()
print('依赖数据写入完成')
else:
print("跳过写入依赖数据，开始执行测试")
def __init__(self):
super().__init__()
self.data = GetData()
self.op_testReport = Write_testReport_excle()
# '''读取失败重试配置'''
self.Config_Try_Num = self.yaml['Config_Try_Num']
# 程序执行
def go_on_run(self):
global pass_count, fail_count
pass_count = []
fail_count = []
rows_count = self.data.get_case_line()
self.log.info(self.mylog.out_varname(rows_count))
for i in range(2, rows_count + 1):
# for i in range(19,19+1):
is_run = self.data.get_is_run(i)
if is_run is True:
# ''' 处理请求'''
response = self.data.request_info(i)
expect = self.data.expectData(i) # 断言，也就i是预期结果
# '''处理断言'''
self.assert_control(i, expect, response)
self.log.info(self.mylog.out_varname(expect))
self.log.info(self.mylog.out_varname(response))
# else:
# contine_info='当前用例为第{}条，跳过,is_run={}'.format(i-1,is_run)
# self.log.info(self.mylog.out_varname(contine_info)
#处理断言
def assert_control(self, row, expect, response):
expect_flag = self.Determine_assert_type(response)
if expect_flag == 'str':
# 调用srt判断方法处理断言
__assert = self.com_assert.is_contain(expect, response)
else:
# str断言处理
# 将expect转换为dict
if not isinstance(expect, dict):
# assert_pyobject:将断言转换为dict，并将true/false/null，转换为python对象
expect = self.requestDataDispose.assert_pyobject(expect)
__assert = self.com_assert.is_equal_dict(expect, response)
else:
# 针对sql断言特殊处理
res_dict = self.dict_assert_res(expect, response)
# print(expect)
# print(res_dict)
__assert = self.com_assert.is_equal_dict_sql_except(
expect, res_dict)
# print(__assert)
self.assert_result_write_excle(row, __assert)
# 根据sql执行结果生成对应的response数据，用于断言判断
def dict_assert_res(self, expect, response):
if isinstance(expect, dict) and isinstance(response, dict):
json_path = self.requestDataDispose.denpendKeyGenerate(
str_in=expect, join_str=self.yaml['recursive_joinstr'])
res_dict = {}
for __path in json_path:
res_result = self.requestDataDispose.depend_data_parse(
__path, response, index='all')
if isinstance(res_result, dict) and res_result:
res_dict.update(res_result)
return res_dict
return False
# 将断言结果写入excle
def assert_result_write_excle(self, row, __assert):
# 判断失败次数是否小于等于配置失败重试次数
errorNum = 0
while errorNum <= self.Config_Try_Num:
if __assert:
self.data.write_result(row, 'pass')
self.log.info('测试通过')
pass_count.append(row)
self.log.info(self.mylog.out_varname(pass_count))
errorNum = 0
self.log.info(self.mylog.out_varname(errorNum))
break
else:
self.data.write_result(row, 'Filed')
if errorNum < self.Config_Try_Num:
errorNum += 1
errorInfo = "测试失败，重试中,当前重试次数为第%s次" % (errorNum)
self.log.info(self.mylog.out_varname(errorInfo))
else:
self.log.info("重试次数已用完,测试失败")
fail_count.append(row)
self.log.info(self.mylog.out_varname(fail_count))
break
# 确认最终的断言类型
def Determine_assert_type(self, response):
expect_flag = None
if isinstance(response, str):
expect_flag = 'str'
else:
expect_flag = 'dict'
return expect_flag
# 发送邮件、生成测试报告
def create_test_report(self):
self.op_testReport.write_TestReport(pass_count,
fail_count) # 生成excel表格测试报告
self.op_testReport.excle_to_html() # 将测试报告转换为html输出
self.send_mail.send_main(pass_count, fail_count) # 发送测试报告邮件
def __init__(self):
self.data = GetData()
self.runMethod = RunMethod()
class RunTest:
def __init__(self):
self.run_method = RunMethod()
self.data = GetData()
self.com_util = CommonUtil()
self.send_mail = SendEmail()
self.op_testReport = Write_testReport_excle()
# 程序执行
def go_on_run(self):
global pass_count, fail_count
res = None
pass_count = []
fail_count = []
rows_count = self.data.get_case_line()
# print(rows_count)
for i in range(1, rows_count):
is_run = self.data.get_is_run(i)
# print(is_run)
url = self.data.get_url(i)
# print(url)
method = self.data.get_request_method(i)
request_data = self.data.request_data_type_change(i)
# print(request_data)
expect = self.data.get_expect_data(i)
# print(expect)
header = self.data.is_header(i)
select_str = 'select'
insert_str = 'INSERT'
update_str = 'UPDATE'
delete_str = 'DELETE'
for except_num in select_str, insert_str, update_str, delete_str:
except_str = self.com_util.is_contain(except_num, expect)
if except_str is True:
expect = self.data.get_sql_expect_data(i)
else:
expect = self.data.get_expect_data(i)
# print(expect)
errorNum = 0
if is_run is True:
while errorNum <= Config_Try_Num: # 判段失败次数是否小于等于配置失败重试次数
res = self.run_method.run_main(method, url, request_data,
header)
if except_str is False:
if self.com_util.is_contain(expect, res) == True:
self.data.write_result(i, 'pass')
print("测试通过")
pass_count.append(i)
errorNum = 0
break
else:
self.data.write_result(i, 'Filed')
# print('测试失败,重试中')
if errorNum < Config_Try_Num:
errorNum += 1
print("测试失败，重试中,当前重试次数为第%s次" % (errorNum))
else:
print("重试次数已用完,测试失败")
fail_count.append(i)
break
# print(res)
if except_str is True:
if self.com_util.is_equal_dict(
expect, res) == True: # 判断字典是否相等
self.data.write_result(i, 'pass')
pass_count.append(i)
print('测试通过')
else:
self.data.write_result(i, 'Filed')
# print('测试失败,重试中')
if errorNum < Config_Try_Num:
errorNum += 1
print("测试失败，重试中,当前重试次数为第%s次" % (errorNum))
else:
print("重试次数已用完,测试失败")
fail_count.append(i)
break
else:
pass
print(res)
# print(self.com_util.is_contain(expect,res)==True)
# 发送邮件、生成测试报告
def create_test_report(self):
self.op_testReport.write_TestReport(pass_count,
fail_count) # 生成excel表格测试报告
self.op_testReport.excle_to_html() # 将测试报告转换为html输出
self.send_mail.send_main(pass_count, fail_count) # 发送测试报告邮件
class DependentData(GetData):
def __init__(self, case_id):
super().__init__()
# 实例依赖字段yaml文件
self.yamlField = OperationYaml('dependFieldInfo.yaml')
# 数据依赖字段实例
self.dependFieldYaml = ''
self.case_id = case_id
self.data = GetData()
self.depend_key_dict = {} #存放依赖key数据
#执行依赖测试，并返回结果
def run_dependent(self):
row_num = self.opera_excle.get_row_num(self.case_id)
depend_response = self.data.request_info(row_num)
self.log.info(self.mylog.out_varname(depend_response))
return depend_response
#根据依赖key去获取执行依赖测试case的响应，然后返回
def get_data_for_key(self, row):
self.depend_data_dict = {} #执行前清空dict
yamlDepentKey = self.data.get_depent_key(row)
# print(yamlDepentKey)
depend_Field_dict = {} #数据依赖字段
# response_data为依赖测试的执行结果
response_data = self.run_dependent()
# print(response_data)
try:
# ''' 判断depend_data使用eval是否发生异常，如果异常当做单字符处理，
# 如果没异常判断是否是list且是否为空，满足条件循环处理，否则不处理'''
if isinstance(response_data, str):
response_data = eval(response_data)
if isinstance(yamlDepentKey, list) and yamlDepentKey:
for i in yamlDepentKey:
# print(i)
# print(self.depend_key_dict)
self.depend_data_parse(i, response_data)
else:
return None
except SyntaxError as syntaxerror:
print(syntaxerror)
self.log.error(self.mylog.out_varname(syntaxerror))
self.depend_data_parse(yamlDepentKey, response_data)
excleDepentKey = self.dependFiel_kw(row)
depend_Field_dict[excleDepentKey] = self.depend_key_dict
# print(self.depend_key_dict)
return depend_Field_dict
def depend_data_parse(self, depend_key, response_data):
'''处理依赖'''
if depend_key:
# 定义要获取的key
# 处理依赖时，只取响应中的第一个值
__dict = self.data.requestDataDispose.depend_data_parse(
depend_key, response_data, index='one')
# 合并字典
# 确保字典不能为空与类型必须时字典
if __dict and isinstance(__dict, dict):
self.depend_key_dict.update(__dict)
# 返回数据依赖字段
def dependFiel_kw(self, row):
col = int(data_config.get_field_depend())
depend_field = self.opera_excle.get_cell_value(row, col)
self.dependFieldYaml = '{}{}'.format(self.yaml['dependField'], row)
# print('self.data.writelist',self.data.writelist)
if not depend_field:
# 判断field关键字是否存在存实例中
if self.dependFieldYaml in self.data.writelist:
return self.dependFieldYaml
else:
return False
else:
return depend_field
# 获取数据依赖字段
def get_depend_field(self, row):
self.write_dependField(row)
depend_field = self.dependFiel_kw(row)
depend_field_data = self.yamlField.readforKey_onetier(key=depend_field)
# print(depend_field)
# print(depend_field_data)
if depend_field_data:
return depend_field_data
else:
return False
# 写入数据依赖字段信息至yaml
def write_dependField(self, row):
try:
dependFieldYaml = self.get_data_for_key(row)
if dependFieldYaml:
# '''这句代码用于处理yaml写入失败（浮点对象异常的问题）
value = eval(demjson.encode(dependFieldYaml))
# print(value)
self.yamlField.write_yaml(value)
return True
else:
return False
except BaseException as error:
print(error)
self.log.error(self.mylog.out_varname(error))
return False
# 将依赖处理完毕的请求数据写入excle
def writeDependRequestDataToExcle(self, row):
source_data = self.get_depend_field(row)
# print(self.mylog.out_varname(source_data))
falg = None
if source_data:
falg = self.data.writeDependFiledToRequestData(
row, source_data=source_data)
if falg:
return True
else:
return False
else:
return False
class login():
def __init__(self):
self.Opexl = OperationExcle('../dataCase/login.xls', 0)
self.data = GetData()
self.com_util = CommonUtil()
self.run_method = RunMethod()
def test_Login(self):
rownums = self.data.get_case_line()
for i in range(1, rownums):
is_run = self.data.get_is_run(i)
# print(is_run)
url = self.data.get_url(i)
# print(url)
method = self.data.get_request_method(i)
request_data = self.data.request_data_type_change(i)
# print(request_data)
expect = self.data.get_expect_data(i)
# print(expect)
header = self.data.is_header(i)
select_str = 'select'
insert_str = 'INSERT'
update_str = 'UPDATE'
delete_str = 'DELETE'
for except_num in select_str, insert_str, update_str, delete_str:
except_str = self.com_util.is_contain(except_num, expect)
if except_str is True:
expect = self.data.get_sql_expect_data(i)
else:
expect = self.data.get_expect_data(i)
# print(expect)
if is_run is True:
res = self.run_method.run_main(method, url, request_data,
header)
if except_str is False:
if self.com_util.is_contain(expect, res) == True:
self.data.write_result(i, 'pass')
print("测试通过")
else:
self.data.write_result(i, 'Filed')
print('测试失败')
# print(res)
if except_str is True:
if self.com_util.is_equal_dict(expect,
res) == True: # 判断字典是否相等
self.data.write_result(i, 'pass')
print('测试通过')
else:
self.data.write_result(i, res)
print('测试失败')
print(res)
else:
pass
def __init__(self):
self.Opexl = OperationExcle('../dataCase/login.xls', 0)
self.data = GetData()
self.com_util = CommonUtil()
self.run_method = RunMethod()
def __init__(self, case_id):
self.case_id = case_id
self.opera_excel = OperationExcel()
self.data = GetData()
def __init__(self):
self.run_method = RunMethod()
self.data = GetData()
self.com_util = CommonUtil()
self.send_mail = SendEmail()
self.op_testReport = Write_testReport_excle()
def __init__(self):
super().__init__()
self.data = GetData()
self.op_testReport = Write_testReport_excle()
# '''读取失败重试配置'''
self.Config_Try_Num = self.yaml['Config_Try_Num']
