excel+unittest

来源：互联网发布：高效程序员的狂暴之路编辑：程序博客网时间：2024/06/03 03:55

转自：http://www.thinksaas.cn/topics/0/436/436827.html

准备先利用之前整理的python自带的unittest框架

整合excel 实现接口自动化测试功能

先看看excel表格设置：

下来是对excel获取的代码：

 1 #!/usr/bin/env python 2 # -*- coding: utf_8 -*- 3  4 import xlrd 5 import json 6  7 class Create_excel: 8     def open_excel(self,path): 9         workbook = xlrd.open_workbook(path)10         table = workbook.sheets()[0]11         return table12     #获取sheet13 14     def get_nrows(self,table):15         nrows = table.nrows16         return nrows17     #获取行号18 19     def testname(self,table,nrows):20         TestName = []21         for i in range(1,nrows):22             TestName.append(table.cell(i,0).value)23         return TestName24     #获取用例name25 26     def testdata(self,table,nrows):27         TestData = []28         for i in range(1,nrows):29             data = json.loads(table.cell(i,1).value)30             TestData.append(data)31         return TestData32     #获取data接口参数33 34     def testurl(self,table,nrows):35         TestUrl = []36         for i in range(1,nrows):37             TestUrl.append(table.cell(i,2).value)38         return TestUrl39     #获取接口测试url40 41     def testpattern(self,table,nrows):42         TestPattern = []43         for i in range(1,nrows):44             TestPattern.append(table.cell(i,3).value)45         return TestPattern46     #获取接口期望响应结果47 48     def testreport(self,table,nrows):49         TestReport = []50         for i in range(1,nrows):51             TestReport.append(table.cell(i,4).value)52         return TestReport53     #获取用例期望的运行结果54 55 if __name__ == "__main__":56     Create_excel()

之后是unittest框架

 1 #!/usr/bin/env python 2 # -*- coding: utf_8 -*- 3  4 import requests 5 import re 6 import unittest 7 from myexcel import Create_excel 8  9 class Testapi():10     def testapi(self,url,data):11         results = requests.post(url,data)12         return results13 14 class Testcase(unittest.TestCase):15     def setUp(self):16         print "接口测试开始"17 18     def tearDown(self):19         print "接口测试结束"20 21     def test_post(self):22         global report23         api = Testapi()24         excel = Create_excel()25         testpath = "testcase.xls"26         testtable = excel.open_excel(testpath)27         testnrows = excel.get_nrows(testtable)28         for i in range(0,testnrows-1):29             testname = excel.testname(testtable,testnrows)[i]30             testdata = excel.testdata(testtable,testnrows)[i]31             testurl = excel.testurl(testtable,testnrows)[i]32             testpattern = excel.testpattern(testtable,testnrows)[i]33             testreport = excel.testreport(testtable,testnrows)[i]34             testresults = api.testapi(testurl,testdata)35             pattern = re.compile(testpattern)36             match = pattern.search(testresults.url)37             try:38                 if testresults.status_code == 200:39                     if match.group() == testpattern:40                         report = "pass"41                 else:42                     print "测试请求失败"43             except AttributeError:44                 report = "no"45             if report == testreport:46                 print "用例名称：",testname,"测试结果：测试通过"47             else:48                 print "用例名称：",testname,"测试结果：测试失败"49 50 if __name__ == "__main__":51     unittest.main()

利用循环执行所有用例

现在只要在excel里添加接口测试用例

运行脚本即可

0 0