python+excel数据驱动接口自动化测试（依赖excel生成测试报告）
2021/10/13 17:16:56
本文主要是介绍python+excel数据驱动接口自动化测试（依赖excel生成测试报告），对大家解决编程问题具有一定的参考价值，需要的程序猿们随着小编来一起学习吧！
测试报告效果：
1.类似htmltesrunner 的html文件
# -*- coding:utf-8 -*-
from xml.sax import saxutils
import sys
import datetime
import xlrd
import os
reload(sys)
sys.setdefaultencoding('utf8')
d = datetime.datetime.now()
HTML_TMPL = r"""<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>%(title)s</title>
<meta name="generator" content="%(generator)s"/>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
%(stylesheet)s
</head>
<body>
<script language="javascript" type="text/javascript"><!--
output_list = Array();
/*level 调整增加只显示通过用例的分类 --Findyou
0:Summary //all hiddenRow
1:Failed //pt hiddenRow, ft none
2:Pass //pt none, ft hiddenRow
3:All //pt none, ft none
*/
function showCase(level) {
trs = document.getElementsByTagName("tr");
for (var i = 0; i < trs.length; i++) {
tr = trs[i];
id = tr.id;
if (id.substr(0,2) == 'ft') {
if (level < 1) {
tr.className = 'hiddenRow';
}
else {
tr.className = '';
}
}
if (id.substr(0,2) == 'pt') {
if (level > 1) {
tr.className = '';
}
else {
tr.className = 'hiddenRow';
}
}
}
}
function showClassDetail(cid, count) {
var id_list = Array(count);
var toHide = 1;
for (var i = 0; i < count; i++) {
tid0 = 't' + cid.substr(1) + '.' + (i+1);
tid = 'f' + tid0;
tr = document.getElementById(tid);
if (!tr) {
tid = 'p' + tid0;
tr = document.getElementById(tid);
}
id_list[i] = tid;
if (tr.className) {
toHide = 0;
}
}
for (var i = 0; i < count; i++) {
tid = id_list[i];
if (toHide) {
document.getElementById('div_'+tid).style.display = 'none'
document.getElementById(tid).className = 'hiddenRow';
}
else {
document.getElementById(tid).className = '';
}
}
}
function showTestDetail(div_id){
var details_div = document.getElementById(div_id)
var displayState = details_div.style.display
// alert(displayState)
if (displayState != 'block' ) {
displayState = 'block'
details_div.style.display = 'block'
}
else {
details_div.style.display = 'none'
}
}
function html_escape(s) {
s = s.replace(/&/g,'&');
s = s.replace(/</g,'<');
s = s.replace(/>/g,'>');
return s;
}
/* obsoleted by detail in <div>
function showOutput(id, name) {
var w = window.open("", //url
name,
"resizable,scrollbars,status,width=800,height=450");
d = w.document;
d.write("<pre>");
d.write(html_escape(output_list[id]));
d.write("\n");
d.write("<a href='javascript:window.close()'>close</a>\n");
d.write("</pre>\n");
d.close();
}
*/
--></script>
%(heading)s
%(report)s
%(ending)s
</body>
</html>
"""
# variables: (title, generator, stylesheet, heading, report, ending)
# ------------------------------------------------------------------------
# Stylesheet
#
# alternatively use a <link> for external style sheet, e.g.
# <link rel="stylesheet" href="$url" type="text/css">
STYLESHEET_TMPL = """
<style type="text/css" media="screen">
body { font-family: verdana, arial, helvetica, sans-serif; font-size: 80%; }
table { font-size: 100%; }
pre { }
/* -- heading ---------------------------------------------------------------------- */
h1 {
font-size: 16pt;
color: gray;
}
.heading {
margin-top: 0ex;
margin-bottom: 1ex;
}
.heading .attribute {
margin-top: 1ex;
margin-bottom: 0;
}
.heading .description {
margin-top: 4ex;
margin-bottom: 6ex;
}
/* -- css div popup ------------------------------------------------------------------------ */
a.popup_link {
}
a.popup_link:hover {
color: red;
}
.popup_window {
display: none;
position: relative;
left: 0px;
top: 0px;
/*border: solid #627173 1px; */
padding: 10px;
background-color: #E6E6D6;
font-family: "Lucida Console", "Courier New", Courier, monospace;
text-align: left;
font-size: 8pt;
width: 500px;
}
}
/* -- report ------------------------------------------------------------------------ */
#show_detail_line {
margin-top: 3ex;
margin-bottom: 1ex;
}
#result_table {
width: 80%;
border-collapse: collapse;
border: 1px solid #777;
}
#header_row {
font-weight: bold;
color: white;
background-color: #777;
}
#result_table td {
border: 1px solid #777;
padding: 2px;
}
#total_row { font-weight: bold; }
.passClass { background-color: #6c6; }
.failClass { background-color: #c60; }
.errorClass { background-color: #c00; }
.passCase { color: #6c6; }
.failCase { color: #c60; font-weight: bold; }
.errorCase { color: #c00; font-weight: bold; }
.hiddenRow { display: none; }
.testcase { margin-left: 2em; }
/* -- ending ---------------------------------------------------------------------- */
#ending {
}
</style>
"""
# ------------------------------------------------------------------------
# Heading
#
HEADING_TMPL = """<div class='heading'>
<h1>%(title)s</h1>
%(parameters)s
<p class='description'>%(description)s</p>
</div>
""" # variables: (title, parameters, description)
HEADING_ATTRIBUTE_TMPL = """<p class='attribute'><strong>%(name)s:</strong> %(value)s</p>
""" # variables: (name, value)
# ------------------------------------------------------------------------
# Report
#
# <a href='javascript:showCase(0)'>Summary</a>
# <a href='javascript:showCase(1)'>Failed</a>
REPORT_TMPL = """
<p id='show_detail_line'>Show
<a href='javascript:showCase(0)'>收起</a>
<a href='javascript:showCase(1)'>失败</a>
<a href='javascript:showCase(2)'>展开</a>
</p>
<table id='result_table'>
<colgroup>
<col align='left' />
<col align='right' />
<col align='right' />
<col align='right' />
<col align='right' />
<col align='right' />
</colgroup>
<tr id='header_row'>
<td>%(Project_Name)s</td>
<td>总数</td>
<td>通过</td>
<td>失败</td>
<td>查看</td>
</tr>
%(test_list)s
<tr id='total_row'>
<td>合计</td>
<td>%(count)s</td>
<td>%(Pass)s</td>
<td>%(fail)s</td>
<td> </td>
</tr>
</table>
""" # variables: (test_list, count, Pass, fail, error)
REPORT_CLASS_TMPL = r"""
<tr class='%(style)s'>
<td>%(desc)s</td>
<td>%(count)s</td>
<td>%(Pass)s</td>
<td>%(fail)s</td>
<td><a href="javascript:showClassDetail('%(cid)s',%(count)s)">用例列表</a></td>
</tr>
""" # variables: (style, desc, count, Pass, fail, error, cid)
REPORT_TEST_WITH_OUTPUT_TMPL = r"""
<tr id='%(tid)s' class='%(Class)s'>
<td class='%(style)s'><div class='testcase'>%(desc)s</div></td>
<td colspan='5' align='center'>
<!--css div popup start-->
<a class="popup_link" onfocus='this.blur();' href="javascript:showTestDetail('div_%(tid)s')" >
%(status)s</a>
<div id='div_%(tid)s' class="popup_window">
<div style='text-align: right; color:red;cursor:pointer'>
<a onfocus='this.blur();' onclick="document.getElementById('div_%(tid)s').style.display = 'none' " >
[x]</a>
</div>
<pre>
<div style="WORD-BREAK: break-all; WORD-WRAP: break-word">
%(script)s
</div>
</pre>
</div>
<!--css div popup end-->
</td>
</tr>
""" # variables: (tid, Class, style, desc, status,script)
REPORT_TEST_NO_OUTPUT_TMPL = r"""
<tr id='%(tid)s' class='%(Class)s'>
<td class='%(style)s'><div class='testcase'>%(desc)s</div></td>
<td colspan='5' align='center'>%(status)s</td>
</tr>
""" # variables: (tid, Class, style, desc, status)
REPORT_TEST_OUTPUT_TMPL = r"""
%(id)s: %(output)s
""" # variables: (id, output)
# ------------------------------------------------------------------------
# ENDING
#
ENDING_TMPL = """<div id='ending'> </div>"""
2.执行文件：
# -*- coding:utf-8 -*-
from result.reporthtml import *
from xml.sax import saxutils
import time
import os
# os.path("D:/daima/ORSD/result/RE.py" )
# path = os.path.dirname(os.path.realpath(__file__))
# print path
path_res = "D:/daima/ORSD/result"
path = "D:/daima/ORSD/dataconfig"
# path = os.path.dirname(os.path.realpath(__file__))
# print path
# print (os.path.isdir(path))
# if True == os.path.isdir(path):
# path_res = path
# else:
# path_res = os.path.dirname(path)
def getReportAttributes(startTime,duration,success_count,failure_count):
"""
Return report attributes as a list of (name, value).
Override this to add custom attributes.
"""
status = []
status.append('通过数 %s' % success_count)
status.append('失败数 %s' % failure_count)
if status:
status = ' '.join(status)
else:
status = 'none'
print status
startTime = time.strftime("%Y_%M_%d_%H:%M:%S", time.localtime())
return [
('开始时间', startTime),
('持续时间', duration),
('运行状态', status),
]
def generateReport(excel,sheet_name,project_Name,title,duration):
report, pass_count, fail_count = generate_report(excel, sheet_name,project_Name)
report_attrs = getReportAttributes(str(),duration,pass_count,fail_count)
generator = 'Ports_1.0'
stylesheet = generate_stylesheet()
heading = generate_heading(title,report_attrs)
ending = generate_ending()
output = HTML_TMPL % dict(
title=saxutils.escape(title),
generator=generator,
stylesheet=stylesheet,
heading=heading,
report=report,
ending=ending,
)
# self.stream.write(output.encode('utf8'))
return output
def generate_stylesheet():
return STYLESHEET_TMPL
def generate_heading(title,report_attrs):
a_lines = []
for name, value in report_attrs:
line = HEADING_ATTRIBUTE_TMPL % dict(
name=saxutils.escape(name),
value=saxutils.escape(value),
)
a_lines.append(line)
heading = HEADING_TMPL % dict(
title=saxutils.escape(title),
parameters=''.join(a_lines),
description=saxutils.escape(u"执行情况"),
)
return heading
def exceldata(excel_path, sheet_name):
wb = xlrd.open_workbook(path + '/'+ excel_path)
sheet = wb.sheet_by_name(sheet_name)
return sheet
def Duplicate_removal(info_list):
if len(info_list) != 0:
Info = []
[Info.append(i) for i in info_list if not i in Info]
else:
Info = []
return Info
def getexceldata(excel,sheet_name):
sheet = exceldata(excel, sheet_name)
a = [];
b = [];
c = []
for x in range(sheet.nrows - 1):
cells = sheet.row_values(x + 1)
a.append(cells[0])
if cells[11] == 'pass':#统计成功
b.append("pass")
elif cells[11] != 'pass':#统计失败
c.append("FAIL")
#Info = Duplicate_removal(a)
return b,c,sheet
def generate_ending():
return ENDING_TMPL
def generate_report(excel,sheet_name,project_Name):
b, c,sheet=getexceldata(excel,sheet_name)
if "FAIL" in c:
style="failClass"
else:style="passClass"
rows = REPORT_CLASS_TMPL % dict(
style=style,
desc=u"用例名称",
count=len(b) + len(c),
Pass=len(b),
fail=len(c),
cid='c1',
)
# print "cccccc=========="
# print rows
rows_list = []
print rows_list
for x in range(0,sheet.nrows-1):
cells = sheet.row_values(x+1)
tmp1=REPORT_TEST_WITH_OUTPUT_TMPL
if cells[11] !='pass':
class_name=''
class_style='failCase'
status_res='fail'
f_t="ft1."
else:
class_name='hiddenRow'
class_style='passCase'
status_res = 'pass'
f_t = "pt1."
# x+1表示序号，script运行过程及结果
xx_res=f_t+str(x+1)+u":\ncase_id："+str(cells[0])+\
u"\n用例名称："+str(cells[1])+\
u"\n请求URL: "+str(cells[2])+\
u"\n请求方式："+str(cells[4])+\
u"\n请求参数："+str(cells[9])+\
u"\n返回报文：" + str(cells[11])
row = tmp1 % dict(tid=f_t+str(x+1),Class=class_name,style=class_style,desc=cells[1],script=saxutils.escape(xx_res),status=status_res)
# print row
rows_list.append(row)
# print rows_list
#excel.split(".xls")[0]
report = REPORT_TMPL % dict(
Project_Name=project_Name,
test_list=rows+''.join(rows_list),
count=str(len(b) + len(c)),
Pass=str(len(b)),
fail=str(len(c)),
)
# print report
pass_count = len(b)
fail_count = len(c)
return report,pass_count,fail_count
def c_htmlfile(result_name):
import io
f = io.open(path_res + '\\' + 'html.html', "a",encoding='utf-8')
f.close()
import time
time_report = time.strftime('%Y%m%d%H%M%S', time.localtime())
os.rename(path_res + '\\' + 'html.html',
path_res + '\\' + result_name + '_' + time_report + '.html')
html_result = result_name + '_' + time_report + '.html'
return html_result
def write_html(excel,sheet_name,project_Name,title,duration):#excel名，表名，测试项目名，标题，持续时间
if True== os.path.exists(path_res + '\\.html'):
os.remove(path_res + '\\.html')
output = generateReport(excel,sheet_name,project_Name,title,duration)
html_path=c_htmlfile("report")
import io
f = io.open(path_res + '\\'+html_path, "a",encoding='utf-8')
f.write(output)
f.close()
return html_path
write_html('interface.xls', u"测试详情","测试标题","接口自动化",'0.002')
file_all = os.listdir("D:/daima/ORSD/result")
path_res = "D:/daima/ORSD/result"
for a in file_all:
portion = os.path.splitext(a)
if portion[1] == ".html":
newname = portion[0] + ".html"
if newname != None:
print newname
os.remove(path_res + '/' + newname)
break
3.这里只保留最新生成的测试报告
# -*- coding:utf-8 -*-
import os
file_all = os.listdir("D:/daima/ORSD/result")
path_res = "D:/daima/ORSD/result"
days = set(fname[0:26] for fname in file_all)
# print days
for a in file_all:
portion = os.path.splitext(a)
if portion[1] == ".html":
newname = portion[0] + ".html"
if newname != None:
print newname
os.remove(path_res + '/' + newname)
break
这篇关于python+excel数据驱动接口自动化测试（依赖excel生成测试报告）的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！
- 2024-11-14Python编程入门指南
- 2024-11-13Python基础教程
- 2024-11-12Python编程基础指南
- 2024-11-12Python基础编程教程
- 2024-11-08Python编程基础与实践示例
- 2024-11-07Python编程基础指南
- 2024-11-06Python编程基础入门指南
- 2024-11-06怎么使用python 计算两个GPS的距离功能-icode9专业技术文章分享
- 2024-11-06Python 基础编程入门教程
- 2024-11-05Python编程基础：变量与类型
