python接口自动化
目录
1.前言
之前无聊，看了看好多大佬写的接口自动化的脚本，打算自己也写一个，准备动手！（其中参考了一些大佬写的东西，其实代码已经写完两个月了，一直没时间写到博客上，所以整篇文章没什么思路，乱七八糟的。。。有时间回来重新构思下吧，反正也没人看。。。）
2.创建工程目录
1.base包的内容是生成的测试报告与运行整个工程的主文件
2.case包的内容是我们调用的测试用例excel与调用测试用例的方法
3.utils包的内容是发送邮件的方法，封装请求参数，获取目录，生成报告的文件
3.封装请求方式
在utils里创建一个python文件“demo”，把请求方式封装一下，为了方便调用
import json
import requests
# 重新封装请求参数
class RunMain(object):
@staticmethod
def send_get(url, data, headers):
if data is not None:
res = requests.get(url=url, data=json.dumps(data), headers=headers)
else:
res = requests.get(url=url, headers=headers)
return res
@staticmethod
def send_post(url, data, headers):
res = requests.post(url=url, data=json.dumps(data), headers=headers)
return res
def run_main(self, url, method, data=None, headers=None):
if method.upper() == 'GET':
res = self.send_get(url, data, headers)
elif method.upper() == 'POST':
res = self.send_post(url, data, headers)
else:
return None
return res
3.创建excel
在case中创建excel，包含url，请求方式，请求的data，headers
特征是获取post请求中返回的参数是否包含重要提示的一个值，例如下图的errorcode这种
4.发送邮件
在utils创建一个文件，名为configEmail，这块代码直接从别人那里粘过来的
import os
import smtplib
import base64
from email.mime.text import MIMEText
from email.mime.multipart import MIMEMultipart
from interface.utils.getHtmlPath import get_htmlPath
# 发送邮件方法
class SendEmail(object):
def __init__(self, username, passwd, recv, title, content,
file=None, ssl=False,
email_host='smtp.163.com', port=25, ssl_port=465):
self.username = username
self.passwd = passwd
self.recv = recv
self.title = title
self.content = content
self.file = file
self.email_host = email_host
self.port = port
self.ssl = ssl
self.ssl_port = ssl_port
def send_email(self) -> None:
msg = MIMEMultipart()
if self.file:
file_name = os.path.split(self.file)[-1]
try:
f = open(self.file, 'rb').read()
except Exception as e:
raise Exception('附件打不开！！！！')
else:
att = MIMEText(f, "base64", "utf-8")
att["Content-Type"] = 'application/octet-stream'
# base64.b64encode(file_name.encode()).decode()
new_file_name = '=?utf-8?b?' + base64.b64encode(file_name.encode()).decode() + '?='
att["Content-Disposition"] = 'attachment; filename="%s"' % (new_file_name)
msg.attach(att)
msg.attach(MIMEText(self.content))
msg['Subject'] = self.title
msg['From'] = self.username
msg['To'] = ','.join(self.recv)
if self.ssl:
self.smtp = smtplib.SMTP_SSL(self.email_host, port=self.ssl_port)
else:
self.smtp = smtplib.SMTP(self.email_host, port=self.port)
self.smtp.login(self.username, self.passwd)
try:
self.smtp.sendmail(self.username, self.recv, msg.as_string())
pass
except Exception as e:
print('出错了。。', e)
else:
print('发送成功！')
self.smtp.quit()
def mail():
new_html = get_htmlPath()
htmlPath = new_html.html_list()
m = SendEmail(
username='邮箱地址',
passwd='这里不是邮箱密码，而是授权密码',
recv=['收邮箱的地址，多个人是列表'],
title='标题',
content='内容',
file=f'reports//{htmlPath}', # 此处是发送文件的路径，后面有获取路径的方法
ssl=True,
)
m.send_email()
5.获取地址
在utils创建一个文件，名为getHtmlPath
此文件用于获取当前工作目录与生成的html文件的路径
import os
class get_htmlPath(object):
# 获取当前工作目录
@staticmethod
def get_path():
return os.getcwd() + "\\reports"
def html_list(self):
# 获取生成html地址，删除旧的html文件
dir_list = os.listdir(self.get_path())
dir_list.sort(key=lambda x: os.path.getmtime(self.get_path() + '\\' + x))
for i in dir_list[:-1]:
os.remove(self.get_path() + "\\" + i)
return dir_list[-1]
6.修改HTMLTestRunner模板
在utils里面新建一个文件。默认的模板太难看了，网上找了个好看的（pytest的模板特别好看，可以使用下）
from io import StringIO
import datetime
import sys
import unittest
from xml.sax import saxutils
"""
A TestRunner for use with the Python unit testing framework. It
generates a HTML report to show the result at a glance.
The simplest way to use this is to invoke its main method. E.g.
import unittest
import HTMLTestRunner
... define your tests ...
if __name__ == '__main__':
HTMLTestRunner.main()
For more customization options, instantiates a HTMLTestRunner object.
HTMLTestRunner is a counterpart to unittest's TextTestRunner. E.g.
# output to a file
fp = file('my_report.html', 'wb')
runner = HTMLTestRunner.HTMLTestRunner(
stream=fp,
title='My unit test',
description='This demonstrates the report output by HTMLTestRunner.'
)
# Use an external stylesheet.
# See the Template_mixin class for more customizable options
runner.STYLESHEET_TMPL = '<link rel="stylesheet" href="my_stylesheet.css" type="text/css">'
# run the test
runner.run(my_test_suite)
------------------------------------------------------------------------
Copyright (c) 2004-2007, Wai Yip Tung
All rights reserved.
Redistribution and use in source and binary forms, with or without
modification, are permitted provided that the following conditions are
met:
* Redistributions of source code must retain the above copyright notice,
this list of conditions and the following disclaimer.
* Redistributions in binary form must reproduce the above copyright
notice, this list of conditions and the following disclaimer in the
documentation and/or other materials provided with the distribution.
* Neither the name Wai Yip Tung nor the names of its contributors may be
used to endorse or promote products derived from this software without
specific prior written permission.
THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS
IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED
TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A
PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER
OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR
PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF
LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
"""
# URL: http://tungwaiyip.info/software/HTMLTestRunner.html
__version__ = "0.8.3"
"""
Change History
Version 0.8.2
* Show output inline instead of popup window (Viorel Lupu).
Version in 0.8.1
* Validated XHTML (Wolfgang Borgert).
* Added description of test classes and test cases.
Version in 0.8.0
* Define Template_mixin class for customization.
* Workaround a IE 6 bug that it does not treat <script> block as CDATA.
Version in 0.7.1
* Back port to Python 2.3 (Frank Horowitz).
* Fix missing scroll bars in detail log (Podi).
"""
# TODO: color stderr
# TODO: simplify javascript using ,ore than 1 class in the class attribute?
# ------------------------------------------------------------------------
# The redirectors below are used to capture output during testing. Output
# sent to sys.stdout and sys.stderr are automatically captured. However
# in some cases sys.stdout is already cached before HTMLTestRunner is
# invoked (e.g. calling logging.basicConfig). In order to capture those
# output, use the redirectors for the cached stream.
#
# e.g.
# >>> logging.basicConfig(stream=HTMLTestRunner.stdout_redirector)
# >>>
class OutputRedirector(object):
""" Wrapper to redirect stdout or stderr """
def __init__(self, fp):
self.fp = fp
def write(self, s):
self.fp.write(s)
def writelines(self, lines):
self.fp.writelines(lines)
def flush(self):
self.fp.flush()
stdout_redirector = OutputRedirector(sys.stdout)
stderr_redirector = OutputRedirector(sys.stderr)
# ----------------------------------------------------------------------
# Template
class Template_mixin(object):
"""
Define a HTML template for report customerization and generation.
Overall structure of an HTML report
HTML
+------------------------+
|<html> |
| <head> |
| |
| STYLESHEET |
| +----------------+ |
| | | |
| +----------------+ |
| |
| </head> |
| |
| <body> |
| |
| HEADING |
| +----------------+ |
| | | |
| +----------------+ |
| |
| REPORT |
| +----------------+ |
| | | |
| +----------------+ |
| |
| ENDING |
| +----------------+ |
| | | |
| +----------------+ |
| |
| </body> |
|</html> |
+------------------------+
"""
STATUS = {
0: 'pass',
1: 'fail',
2: 'error',
}
DEFAULT_TITLE = 'Unit Test Report'
DEFAULT_DESCRIPTION = ''
# ------------------------------------------------------------------------
# HTML Template
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 style="background-color:#C0C0C0">
<script language="javascript" type="text/javascript"><!--
output_list = Array();
/* level - 0:Summary; 1:Pass; 2:Fail; 3:Error; 4:All */
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 == 2) {
tr.className = '';
}
else if(level == 4) {
tr.className = '';
}
else if(level == 5) {
tr.className = '';
}
else{
tr.className = 'hiddenRow';
}
}
if (id.substr(0,2) == 'Pt') {
if (level == 1) {
tr.className = '';
}
else if(level == 4 ) {
tr.className = '';
}
else{
tr.className = 'hiddenRow';
}
}
if (id.substr(0,2) == 'Et') {
if (level == 3) {
tr.className = '';
}
else if(level == 4 ) {
tr.className = '';
}
else if(level == 5 ) {
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);
if(!tr){
tid = 'E' + 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
%(chart)s
</body>
</html>
<script type="text/javascript">
function drawCircle(pass, fail, error){
var color = ["#6c6","#c60","#c00"];
var data = [pass,fail,error];
var canvas = document.getElementById("circle");
var ctx = canvas.getContext("2d");
var startPoint=0;
for(var i=0;i<data.length;i++){
ctx.fillStyle = color[i];
ctx.beginPath();
ctx.moveTo(112,84);
ctx.arc(112,84,84,startPoint,startPoint+Math.PI*2*(data[i]/(data[0]+data[1]+data[2])),false);
ctx.fill();
startPoint += Math.PI*2*(data[i]/(data[0]+data[1]+data[2]));
}
}
function FillRect(cxt, x1, y1, width, height, color) {
cxt.fillStyle = color;
cxt.fillRect(x1, y1, width, height);
}
function drawBar(pass, fail, error){
var color = ["#6c6","#c60","#c00"];
var data = [pass,fail,error];
var count = pass + fail + error;
var h =[10+(1 - pass/count)*148,10+(1 - fail/count)*148,10+(1 - error/count)*148];
var x = [30,90,150];
var y = [70,130,190];
var canvas = document.getElementById("bar");
var ctx = canvas.getContext("2d");
DrawString(ctx, 'Count(c)', '', '', '', '', 15, 10)
DrawLine(ctx,5,15,10,10,'black');
DrawLine(ctx,15,15,10,10,'black');
DrawLine(ctx,10,10,10,158,'black');
DrawLine(ctx,10,158,215,158,'black');
DrawLine(ctx,210,153,215,158,'black');
DrawLine(ctx,210,163,215,158,'black');
DrawString(ctx, 'Type(c)', '', '', '', '', 180, 160)
for(var i=0;i<3;i++) {
DrawLine(ctx,x[i],h[i],x[i],158,color[i]);
DrawLine(ctx,x[i],h[i],y[i],h[i],color[i]);
DrawLine(ctx,y[i],h[i],y[i],158,color[i]);
DrawLine(ctx,(y[i]+x[i])/2,153,(y[i]+x[i])/2,158,color[i]);
DrawString(ctx, data[i], '', color[i], '', '', (y[i]+x[i])/2, h[i]-15);
FillRect(ctx, x[i], h[i], 40, 158-h[i], color[i]);
}
}
function DrawP(ctx, P) {
with (ctx) {
moveTo(P[0],P[1]);
lineTo(P[0]+1,P[1]+1);
}
}
function DrawLine(cxt, x1, y1, x2, y2, color) {
cxt.strokeStyle = color;
cxt.beginPath();
cxt.moveTo(x1, y1);
cxt.lineTo(x2, y2);
cxt.stroke();
}
function DrawString(cxt, text, font, color, align, v_align, x, y) {
if (font == "") {
cxt.font = "10px";
}
else {
cxt.font = font;
}
if (color == "") {
cxt.fillStyle = "#000000";
}
else {
cxt.fillStyle = color;
}
if (align == "") {
cxt.textAlign = "left";
}
else {
cxt.textAlign = align;
}
if (v_align == "") {
cxt.textBaseline = "top";
}
else {
cxt.textBaseline = v_align;
}
cxt.fillText(text, x, y);
}
function drawline(pass, fail, error){
var color = ["#6c6","#c60","#c00"];
var data = [pass,fail,error];
var count = pass + fail + error;
var x = [30,90,150];
var y = [70,130,190];
var h =[10+(1 - pass/count)*148,10+(1 - fail/count)*148,10+(1 - error/count)*148];
var canvas = document.getElementById("line");
var ctx = canvas.getContext("2d");
DrawString(ctx, 'Count(c)', '', '', '', '', 15, 10)
DrawLine(ctx,5,15,10,10,'black');
DrawLine(ctx,15,15,10,10,'black');
DrawLine(ctx,10,10,10,158,'black');
DrawLine(ctx,10,158,215,158,'black');
DrawLine(ctx,210,153,215,158,'black');
DrawLine(ctx,210,163,215,158,'black');
DrawString(ctx, 'Type(c)', '', '', '', '', 180, 160)
for(var i=0;i<3;i++) {
p = Array((y[i]+x[i])/2,h[i]);
DrawP(ctx,p);
DrawLine(ctx,(y[i]+x[i])/2,153,(y[i]+x[i])/2,158,color[i]);
DrawString(ctx, data[i], '', color[i], '', '', (y[i]+x[i])/2, h[i]-15);
if(i < 2) {
DrawLine(ctx,(y[i]+x[i])/2,h[i],(y[i+1]+x[i+1])/2,h[i+1],'black');
}
}
}
</script>
"""
# 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;
}
.button{
border:1px solid #cccccc;
cursor:pointer;
margin:10px 5px;
height:40px;
text-align:center;
border-radius: 4px;
border-color: #636263 #464647 #A1A3A5;
text-shadow: 0 1px 1px #F6F6F6;
background-image: -moz-linear-gradient(center top, #D9D9D9, #A6A6A6 49%, #A6A6A6 50%);
background-image: -webkit-gradient(linear, left top, left bottom, color-stop(0, #D9D9D9),color-stop(1, #A6A6A6));
}
.buttonText{
position:relative;
font-weight:bold;
top:10px;
color:#58595B;
}
.heading .description {
margin-top: 4ex;
margin-bottom: 6ex;
}
.panel .description{
border:1px solid #CCCCCC;
border-color: #636263 #464647 #A1A3A5;
margin:10px 5px;
height:165px;
border-radius: 4px;
}
.scroll-item {
position: relative;
width: 100%;
height: 32px;
border-bottom:1px solid gray;
cursor: pointer;
}
.item-even {
background-color: #E7E8EC;
}
.item-odd {
background-color: #E0ECF6;
}
.rect {
float: left;
margin-top: 5px;
margin-left: 5px;
width: 20px;
height: 20px;
border-radius: 3px;
}
.item-text{
margin-left: 5px;
height: 100%;
float: left;
font-size: 14px;
vertical-align: middle;
display: inline-block;
line-height: 30px;
}
.bg{
position:absolute;
height:97%;
width:80%;
overflow-x: hidden;
overflow-y:hidden;
}
.panel{
position:absolute;
height:550px;
width:750px;
left:45px;
top:45px;
border-radius: 12px;
background-image: -moz-linear-gradient(top,#EBEBEB, #BFBFBF);
background-image: -webkit-gradient(linear, left top, left bottom, color-stop(0, #EBEBEB),color-stop(1, #BFBFBF));
}
.panel1{
position:absolute;
height:550px;
width:200px;
left:800px;
top:45px;
border-radius: 12px;
background-image: -moz-linear-gradient(top,#EBEBEB, #BFBFBF);
background-image: -webkit-gradient(linear, left top, left bottom, color-stop(0, #EBEBEB),color-stop(1, #BFBFBF));
}
.panelBg{
position:absolute;
height:600px;
width:1000px;
left:20px;
top:20px;
border-radius: 12px;
background-color:#000000;
opacity:0.5;
}
.title{
border:1px solid green;
position:relative;
margin:5px;
font-size:22px;
font-weight:bold;
text-align:center;
color:#58595B;
}
.piechart{
border:1px solid green;
margin:5px;
height:170px;
}
.barchart{
border:1px solid green;
margin:5px;
height:170px;
}
.linechart{
border:1px solid green;
margin:5px;
height:170px;
}
.subTitle{
border:1px solid green;
margin:5px;
font-size:14px;
height:70px;
font-weight:bold;
text-indent:2em;
color:#6D6E71;
}
/* -- 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: 2px solid #777;
padding: 3px;
}
#total_row { font-weight: bold; }
.passClass { background-color: #6c6; }
.failClass { background-color: #c60; }
.errorClass { background-color: #c00; }
.passCase { color: #6c6; font-weight: bold;}
.failCase { color: #c60; font-weight: bold; }
.errorCase { color: #c00; font-weight: bold; }
.hiddenRow { display: none; }
.testcase { margin-left: 2em; }
#section1{
border:1px solid green;
position:relative;
float:left;
width:235px;
height:530px;
top:10px;
left:10px;
}
#section2{
border:1px solid green;
position:relative;
float:left;
width:235px;
height:530px;
top:10px;
left:20px;
}
#section3{
border:1px solid green;
position:relative;
float:left;
width:235px;
height:530px;
top:10px;
left:30px;
}
#section4{
border:1px solid green;
position:relative;
float:left;
width:180px;
height:530px;
top:10px;
left:10px;
}
.loseeffect{
color:black;
text-decoration:none;
cursor:text;
}
/* -- 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
#
REPORT_TMPL = """
<p id='show_detail_line'>Show
<a href='javascript:showCase(0)'>Summary</a>
<a href='javascript:showCase(1)'>Pass</a>
<a href='javascript:showCase(2)'>Fail</a>
<a href='javascript:showCase(3)'>Error</a>
<a href='javascript:showCase(5)'>Fail&Error</a>
<a href='javascript:showCase(4)'>All</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>测试用例</td>
<td>总数</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>%(error)s</td>
<td>%(Pass)s/%(count)s</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>%(error)s</td>
<td><a href="javascript:showClassDetail('%(cid)s',%(count)s)">Detail</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='4' align='center'>
<!--css div popup start-->
<a class="popup_link" οnfοcus='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 οnfοcus='this.blur();' οnclick="document.getElementById('div_%(tid)s').style.display = 'none' " >
[x]</a>
</div>
<pre>
%(script_out)s
</pre>
</div>
<!--css div popup end-->
</td>
<td colspan='1' align='center'>%(script_info)s</td>
</tr>
""" # variables: (tid, Class, style, desc, status)
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='4' align='center'>
<a class="popup_link" οnfοcus='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 οnfοcus='this.blur();' οnclick="document.getElementById('div_%(tid)s').style.display = 'none' " >
[x]</a>
</div>
<pre>
%(script_out)s
</pre>
</div>
</td>
<td colspan='1' align='center'>%(script_info)s</td>
</tr>
""" # variables: (tid, Class, style, desc, status)
REPORT_TEST_OUTPUT_TMPL = r"""
%(id)s: %(output)s
""" # variables: (id, output)
CASEINFO_OUTPUT_TMPL = r"""
%(caseinfo)s
""" # variables: (caseinfo)
# ------------------------------------------------------------------------
# ENDING
#
ENDING_TMPL = """<div id='ending'> </div>"""
CHART_TMPL = """<div class="bg">
<div class="panelBg"></div>
<div class="panel">
<div id="section1">
<div class="title">Pie Chart</div>
<div class="subTitle">This chart is to show the rate that statis of test cases</div>
<div class="piechart">
<canvas id="circle" width="225" height="168" οnmοusemοve='javascript:drawCircle(%(Pass)s, %(fail)s, %(error)s)'>your browser does not support the canvas tag</canvas>
</div>
<div class="description">
<div class="scroll-item item-even">
<div class="rect" style="background-color: #6c6; "></div>
<div class="item-text">Passcase:%(Pass)s</div>
</div>
<div class="scroll-item item-odd">
<div class="rect" style="background-color: #c60; "></div>
<div class="item-text">failcase:%(fail)s</div>
</div>
<div class="scroll-item item-even">
<div class="rect" style="background-color: #c00; "></div>
<div class="item-text">errorcase:%(error)s</div>
</div>
<div class="scroll-item item-odd">
</div>
<div class="scroll-item item-even">
</div>
</div>
<div class="button" οnclick='javascript:drawCircle(%(Pass)s, %(fail)s, %(error)s)'><span class="buttonText">CLICK SEE PIE CHART</span></div>
</div>
<div id="section2">
<div class="title">Bar Chart</div>
<div class="subTitle">This chart is to show the count that statis of test cases</div>
<div class="barchart">
<canvas id="bar" width="225" height="168" οnclick='javascript:drawBar(%(Pass)s, %(fail)s, %(error)s)'>your browser does not support the canvas tag</canvas>
</div>
<div class="description">
<div class="scroll-item item-even">
<div class="rect" style="background-color: #6c6; "></div>
<div class="item-text">Passcase:%(Pass)s</div>
</div>
<div class="scroll-item item-odd">
<div class="rect" style="background-color: #c60; "></div>
<div class="item-text">failcase:%(fail)s</div>
</div>
<div class="scroll-item item-even">
<div class="rect" style="background-color: #c00; "></div>
<div class="item-text">errorcase:%(error)s</div>
</div>
<div class="scroll-item item-odd">
</div>
<div class="scroll-item item-even">
</div>
</div>
<div class="button" οnclick='javascript:drawBar(%(Pass)s, %(fail)s, %(error)s)'><span class="buttonText">CLICK SEE BAR CHART</span></div>
</div>
<div id="section3">
<div class="title">Line Chart</div>
<div class="subTitle">This chart is to show the rate that data of test cases</div>
<div class="linechart">
<canvas id="line" width="225" height="168" οnclick='javascript:drawline(%(Pass)s, %(fail)s, %(error)s)'>your browser does not support the canvas tag</canvas>
</div>
<div class="description">
<div class="scroll-item item-even">
<div class="rect" style="background-color: #6c6; "></div>
<div class="item-text">Passcase:%(Pass)s</div>
</div>
<div class="scroll-item item-odd">
<div class="rect" style="background-color: #c60; "></div>
<div class="item-text">failcase:%(fail)s</div>
</div>
<div class="scroll-item item-even">
<div class="rect" style="background-color: #c00; "></div>
<div class="item-text">errorcase:%(error)s</div>
</div>
<div class="scroll-item item-odd">
</div>
<div class="scroll-item item-even">
</div>
</div>
<div class="button" οnclick='javascript:drawline(%(Pass)s, %(fail)s, %(error)s)'><span class="buttonText">CLICK SEE BAR CHART</span></div>
</div>
</div>
<div class="panel1">
<div id="section4">
<a>%(Pass)s Pass cases, %(fail)s fail cases, %(error)s error cases.</a>
</div>
</div>
</div>"""
# -------------------- The end of the Template class -------------------
TestResult = unittest.TestResult
class _TestResult(TestResult):
# note: _TestResult is a pure representation of results.
# It lacks the output and reporting ability compares to unittest._TextTestResult.
def __init__(self, verbosity=1):
TestResult.__init__(self)
self.stdout0 = None
self.stderr0 = None
self.success_count = 0
self.failure_count = 0
self.error_count = 0
self.verbosity = verbosity
# result is a list of result in 4 tuple
# (
# result code (0: success; 1: fail; 2: error),
# TestCase object,
# Test output (byte string),
# stack trace,
# )
self.result = []
def startTest(self, test):
TestResult.startTest(self, test)
# just one buffer for both stdout and stderr
self.outputBuffer = StringIO()
stdout_redirector.fp = self.outputBuffer
stderr_redirector.fp = self.outputBuffer
self.stdout0 = sys.stdout
self.stderr0 = sys.stderr
sys.stdout = stdout_redirector
sys.stderr = stderr_redirector
def complete_output(self):
"""
Disconnect output redirection and return buffer.
Safe to call multiple times.
"""
if self.stdout0:
sys.stdout = self.stdout0
sys.stderr = self.stderr0
self.stdout0 = None
self.stderr0 = None
return self.outputBuffer.getvalue()
def stopTest(self, test):
# Usually one of addSuccess, addError or addFailure would have been called.
# But there are some path in unittest that would bypass this.
# We must disconnect stdout in stopTest(), which is guaranteed to be called.
self.complete_output()
def addSuccess(self, test):
self.success_count += 1
TestResult.addSuccess(self, test)
output = self.complete_output()
self.result.append((0, test, output, ''))
if self.verbosity > 1:
sys.stderr.write('ok ')
sys.stderr.write(str(test))
sys.stderr.write('\n')
else:
sys.stderr.write('.')
def addError(self, test, err):
self.error_count += 1
TestResult.addError(self, test, err)
_, _exc_str = self.errors[-1]
output = self.complete_output()
self.result.append((2, test, output, _exc_str))
if self.verbosity > 1:
sys.stderr.write('E ')
sys.stderr.write(str(test))
sys.stderr.write('\n')
else:
sys.stderr.write('E')
def addFailure(self, test, err):
self.failure_count += 1
TestResult.addFailure(self, test, err)
_, _exc_str = self.failures[-1]
output = self.complete_output()
self.result.append((1, test, output, _exc_str))
if self.verbosity > 1:
sys.stderr.write('F ')
sys.stderr.write(str(test))
sys.stderr.write('\n')
else:
sys.stderr.write('F')
class HTMLTestRunner(Template_mixin):
"""
"""
def __init__(self, stream=sys.stdout, verbosity=1, title=None, description=None):
self.stream = stream
self.verbosity = verbosity
if title is None:
self.title = self.DEFAULT_TITLE
else:
self.title = title
if description is None:
self.description = self.DEFAULT_DESCRIPTION
else:
self.description = description
self.startTime = datetime.datetime.now()
def run(self, test, caseinfo={}):
"Run the given test case or test suite."
result = _TestResult(self.verbosity)
test(result)
self.stopTime = datetime.datetime.now()
self.generateReport(test, result, caseinfo)
# print(>> sys.stderr, '\nTime Elapsed: %s' % (self.stopTime - self.startTime)
return result
def sortResult(self, result_list):
# unittest does not seems to run in any particular order.
# Here at least we want to group them together by class.
rmap = {}
classes = []
for n, t, o, e in result_list:
cls = t.__class__
if cls not in rmap:
rmap[cls] = []
classes.append(cls)
rmap[cls].append((n, t, o, e))
r = [(cls, rmap[cls]) for cls in classes]
return r
def getReportAttributes(self, result):
"""
Return report attributes as a list of (name, value).
Override this to add custom attributes.
"""
startTime = str(self.startTime)[:19]
duration = str(self.stopTime - self.startTime)
status = []
success = str(
"%.2f" % (result.success_count / (
result.success_count + result.failure_count + result.error_count) * 100)) + "%"
if result.success_count: status.append('Pass %s' % result.success_count)
if result.failure_count: status.append('Failure %s' % result.failure_count)
if result.error_count: status.append('Error %s' % result.error_count)
if status:
status = ' '.join(status)
else:
status = 'none'
return [
('开始时间', startTime),
('总耗时', duration),
('细节', status),
('成功率', success),
]
def generateReport(self, test, result, caseinfo):
report_attrs = self.getReportAttributes(result)
generator = 'HTMLTestRunner %s' % __version__
stylesheet = self._generate_stylesheet()
heading = self._generate_heading(report_attrs)
report = self._generate_report(result, caseinfo)
ending = self._generate_ending()
chart = self._generate_chart(result)
output = self.HTML_TMPL % dict(
title=saxutils.escape(self.title),
generator=generator,
stylesheet=stylesheet,
heading=heading,
report=report,
ending=ending,
chart=chart,
)
self.stream.write(output.encode('utf8'))
def _generate_stylesheet(self):
return self.STYLESHEET_TMPL
def _generate_heading(self, report_attrs):
a_lines = []
for name, value in report_attrs:
line = self.HEADING_ATTRIBUTE_TMPL % dict(
name=saxutils.escape(name),
value=saxutils.escape(value),
)
a_lines.append(line)
heading = self.HEADING_TMPL % dict(
title=saxutils.escape(self.title),
parameters=''.join(a_lines),
description=saxutils.escape(self.description),
)
return heading
def _generate_report(self, result, caseinfo):
rows = []
sortedResult = self.sortResult(result.result)
for cid, (cls, cls_results) in enumerate(sortedResult):
# subtotal for a class
np = nf = ne = 0
for n, t, o, e in cls_results:
if n == 0:
np += 1
elif n == 1:
nf += 1
elif n == 2:
ne += 1
# format class description
if cls.__module__ == "__main__":
name = cls.__name__
else:
name = "%s.%s" % (cls.__module__, cls.__name__)
doc = cls.__doc__ and cls.__doc__.split("\n")[0] or ""
desc = doc and '%s: %s' % (name, doc) or name
row = self.REPORT_CLASS_TMPL % dict(
style=ne > 0 and 'errorClass' or nf > 0 and 'failClass' or 'passClass',
desc=desc,
count=np + nf + ne,
Pass=np,
fail=nf,
error=ne,
cid='c%s' % (cid + 1),
)
rows.append(row)
for tid, (n, t, o, e) in enumerate(cls_results):
self._generate_report_test(rows, cid, tid, n, t, o, e, caseinfo)
report = self.REPORT_TMPL % dict(
test_list=''.join(rows),
count=str(result.success_count + result.failure_count + result.error_count),
Pass=str(result.success_count),
fail=str(result.failure_count),
error=str(result.error_count),
)
return report
def _generate_report_test(self, rows, cid, tid, n, t, o, e, caseinfo):
# e.g. 'Pt1.1', 'Ft1.1','E1.1,' etc
has_output = bool(o or e)
if n == 0:
tid = 'Pt%s.%s' % (cid + 1, tid + 1)
elif n == 1:
tid = 'Ft%s.%s' % (cid + 1, tid + 1)
else:
tid = 'Et%s.%s' % (cid + 1, tid + 1)
name = t.id().split('.')[-1]
doc = t.shortDescription() or ""
desc = doc and ('%s: %s' % (name, doc)) or name
tmpl = has_output and self.REPORT_TEST_WITH_OUTPUT_TMPL or self.REPORT_TEST_NO_OUTPUT_TMPL
# o and e should be byte string because they are collected from stdout and stderr?
if isinstance(o, str):
# TODO: some problem with 'string_escape': it escape \n and mess up formating
# uo = unicode(o.encode('string_escape'))
uo = o
else:
uo = o
if isinstance(e, str):
# TODO: some problem with 'string_escape': it escape \n and mess up formating
# ue = unicode(e.encode('string_escape'))
ue = e
else:
ue = e
output = saxutils.escape(uo + ue)
# print(output)
unum = str(output).find('screenshot')
# print(unum)
if (unum != -1):
hidde_status = ''
unum = str(output).find('screenshot')
image_url = '../screenshot/' + str(output)[unum + 11:unum + 36].replace(' ', '')
targets = '_blank'
loseeffect = ''
else:
hidde_status = ''
image_url = 'javascript:void(0)'
targets = ''
loseeffect = 'loseeffect'
script_out = self.REPORT_TEST_OUTPUT_TMPL % dict(
id=tid,
output=saxutils.escape(uo + ue),
)
script_info = self.CASEINFO_OUTPUT_TMPL % dict(
caseinfo=caseinfo.get(desc, ''),
)
row = tmpl % dict(
tid=tid,
Class=(n == 0 and 'hiddenRow' or 'none'),
style=(n == 2 and 'errorCase') or (n == 1 and 'failCase') or (n == 0 and 'passCase'),
desc=desc,
status=self.STATUS[n],
script_out=script_out,
script_info=script_info,
image_url=image_url,
hidde=hidde_status,
targets=targets,
loseeffect=loseeffect,
)
rows.append(row)
if not has_output:
return
def _generate_ending(self):
return self.ENDING_TMPL
def _generate_chart(self, result):
report = self.CHART_TMPL % dict(
Pass=str(result.success_count),
fail=str(result.failure_count),
error=str(result.error_count),
)
return report
##############################################################################
# Facilities for running tests from the command line
##############################################################################
# Note: Reuse unittest.TestProgram to launch test. In the future we may
# build our own launcher to support more specific command line
# parameters like test title, CSS, etc.
class TestProgram(unittest.TestProgram):
"""
A variation of the unittest.TestProgram. Please refer to the base
class for command line parameters.
"""
def __init__(self):
self.verbosity = None
def runTests(self):
# Pick HTMLTestRunner as the default test runner.
# base class's testRunner parameter is not useful because it means
# we have to instantiate HTMLTestRunner before we know self.verbosity.
if self.testRunner is None:
self.testRunner = HTMLTestRunner(verbosity=self.verbosity)
unittest.TestProgram.runTests(self)
main = TestProgram
##############################################################################
# Executing this module from the command line
##############################################################################
7.解析excel进行测试
在case目录下，创建test_case文件
1.在excel中新增接口后，再次在TestMethod类中创建一个新的方法即可，使用起来比较方便，但是局限性很大
import json
import os
import unittest
import xlrd
from interface.utils.demo import RunMain
index = 0
class Handle_Data(object):
def __init__(self):
# 创建请求对象实例
self.run = RunMain()
# 打开excel文档
self.excel_data = xlrd.open_workbook(os.path.dirname(__file__) + "\\" + "api.xlsx")
self.table = self.excel_data.sheets()[0]
# 行数
self.rows = self.table.nrows
# 列数
self.cols = self.table.ncols
self.url = self.table.row_values(index)[0]
self.method = self.table.row_values(index)[1]
self.res = ""
def request_data(self):
if index <= self.rows:
# 从excel中读取url，请求方法，请求参数，请求头
if self.table.row_values(index)[2] == "None" or "":
data = None
else:
data = json.loads(self.table.row_values(index)[2])
if self.table.row_values(index)[3] == "None" or "":
headers = None
else:
headers = eval(self.table.row_values(index)[3])
self.res = self.run.run_main(self.url, self.method, data, headers)
print(f"接口请求耗时:{self.res.elapsed.total_seconds()}秒")
def handle_excel(self):
# if self.table.row_values(index)[2] == "0":
if self.method.upper() == "POST":
res_json = self.res.json()
try:
# 先断言url返回的结果，一般为200才继续后面流程
assert (self.res.status_code == 200)
# 特征1必须有，判断特征1是否在返回的数据中
if self.table.row_values(index)[5] != "":
assert (self.table.row_values(index)[5] in json.dumps(res_json, ensure_ascii=False))
# 特征2，3可以有，判断特征2,3是否在返回的数据中
if self.table.row_values(index)[6] != "":
assert (self.table.row_values(index)[6] in json.dumps(res_json, ensure_ascii=False))
else:
assert True
if self.table.row_values(index)[7] != "":
assert (self.table.row_values(index)[7] in json.dumps(res_json, ensure_ascii=False))
else:
assert True
except Exception as e:
print(e)
# get请求只判断返回的code
elif self.method.upper() == "GET":
assert (self.res.status_code == 200)
class TestMethod(unittest.TestCase):
# 每次调用excel处理的方法使index的值，也就是行数+1
def test_01(self):
global index
index += 1
data = Handle_Data()
data.request_data()
data.handle_excel()
def test_02(self):
global index
index += 1
data = Handle_Data()
data.request_data()
data.handle_excel()
if __name__ == '__main__':
TestMethod().test_01()
TestMethod().test_02()
8.创建主运行文件
在base里创建主运行文件“test_method”
import os
import time
import unittest
import HtmlTestRunner
import datetime
from interface.utils.configEmail import mail
from interface.case.test_case import TestMethod
from interface.utils.HTMLTestRunner import HTMLTestRunner
path = os.path.abspath(os.path.dirname(os.getcwd()) + "\\" + "template" + "\\" + "report_template.html")
title = f"{datetime.date.today()}test case"
now_time = (time.strftime("%Y_%m_%d_%H_%M_%S", time.localtime()))
testcase_dir = os.getcwd() + f"\\reports\\{now_time}_result.html"
'''
主文件，运行所有测试用例
'''
if __name__ == '__main__':
# 测试用例实例化
t_case = TestMethod()
# 测试类实例化
suite = unittest.TestSuite()
suite.addTest(TestMethod("test_01"))
suite.addTest(TestMethod("test_02"))
suite.addTest(TestMethod("test_03"))
# 根据断言结果生成html测试报告
# runner = HtmlTestRunner.HTMLTestRunner(report_title=title, template=path)
# runner.run(suite)
with open(testcase_dir, 'wb') as f:
runner = HTMLTestRunner(stream=f, title='接口自动化测试报告', description='Test for Test')
runner.run(suite)
mail()
9.使用方法
运行test_method中的main方法，即可在base包的reports中创建出一个测试报告，调用mail()方法，自动发送到邮箱内，并且删除过期邮件。
10.后记
1.内容比较杂乱，有时间会重新写一遍2
2.其中用到不少别的大佬写的代码
3.目前不支持多线程压力测试，有时间会写上
4.有什么问题可以直接在下面留言，我会第一时间进行回复（没人看吧。。。）
扫一扫
1335
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
