一、测试需求描述
对服务后台一系列的http接口功能测试。
输入:根据接口描述构造不同的参数输入值
输出:XML文件
eg:http://xxx.com/xxx_product/test/content_book_list.jsp?listid=1
二、实现方法
1、选用Python脚本来驱动测试
2、采用Excel表格管理测试数据,包括用例的管理、测试数据录入、测试结果显示等等,这个需要封装一个Excel的类即可。
3、调用http接口采用Python封装好的API即可
4、测试需要的http组装字符转处理即可
5、设置2个检查点,XML文件中的返回值字段(通过解析XML得到);XML文件的正确性(文件对比)
6、首次执行测试采用半自动化的方式,即人工检查输出的XML文件是否正确,一旦正确将封存XML文件,为后续回归测试的预期结果,如果发现错误手工修正为预期文件。(注意不是每次测试都人工检查该文件,只首次测试的时候才检查)
三、Excel表格样式
四、实现代码(代码才是王道,有注释很容易就能看明白的)
1、测试框架代码
- importos,sys, urllib, httplib, profile, datetime, time
- fromxml2dictimportXML2Dict
- importwin32com.client
- fromwin32com.clientimportDispatch
- importxml.etree.ElementTree as et
- OK_COLOR=0xffffff
- NG_COLOR=0xff
- NT_COLOR=0xC0C0C0
- TESTTIME=[1,14]
- TESTRESULT=[2,14]
- classcreate_excel:
- def__init__(self, sFile, dtitleindex=3, dcasebegin=4, dargbegin=3, dargcount=8):
- self.xlApp = win32com.client.Dispatch('et.Application')
- try:
- self.book =self.xlApp.Workbooks.Open(sFile)
- except:
- print_error_info()
- print"打开文件失败"
- exit()
- self.file=sFile
- self.titleindex=dtitleindex
- self.casebegin=dcasebegin
- self.argbegin=dargbegin
- self.argcount=dargcount
- self.allresult=[]
- self.retCol=self.argbegin+self.argcount
- self.xmlCol=self.retCol+1
- self.resultCol=self.xmlCol+1
- defclose(self):
- self.book.Save()
- self.book.Close()
- delself.xlApp
- defread_data(self, iSheet, iRow, iCol):
- try:
- sht =self.book.Worksheets(iSheet)
- sValue=str(sht.Cells(iRow, iCol).Value)
- except:
- self.close()
- print('读取数据失败')
- exit()
- ifsValue[-2:]=='.0':
- sValue = sValue[0:-2]
- returnsValue
- defwrite_data(self, iSheet, iRow, iCol, sData, color=OK_COLOR):
- try:
- sht =self.book.Worksheets(iSheet)
- sht.Cells(iRow, iCol).Value = sData.decode("utf-8")
- sht.Cells(iRow, iCol).Interior.Color=color
- self.book.Save()
- except:
- self.close()
- print('写入数据失败')
- exit()
- defget_ncase(self, iSheet):
- try:
- returnself.get_nrows(iSheet)-self.casebegin+1
- except:
- self.close()
- print('获取Case个数失败')
- exit()
- defget_nrows(self, iSheet):
- try:
- sht =self.book.Worksheets(iSheet)
- returnsht.UsedRange.Rows.Count
- except:
- self.close()
- print('获取nrows失败')
- exit()
- defget_ncols(self, iSheet):
- try:
- sht =self.book.Worksheets(iSheet)
- returnsht.UsedRange.Columns.Count
- except:
- self.close()
- print('获取ncols失败')
- exit()
- defdel_testrecord(self, suiteid):
- try:
- nrows=self.get_nrows(suiteid)+1
- ncols=self.get_ncols(suiteid)+1
- begincol=self.argbegin+self.argcount
- sht =self.book.Worksheets(suiteid)
- forrowinrange(self.casebegin, nrows):
- forcolinrange(begincol, ncols):
- str=self.read_data(suiteid, row, col)
- startpos = str.find('[')
- ifstartpos>0:
- str = str[0:startpos].strip()
- self.write_data(suiteid, row, col, str, OK_COLOR)
- else:
- sht.Cells(row, col).Interior.Color = OK_COLOR
- self.write_data(suiteid, row,self.argbegin+self.argcount+1,' ', OK_COLOR)
- self.write_data(suiteid, row,self.resultCol,'NT', NT_COLOR)
- except:
- self.close()
- print('清除数据失败')
- exit()
- defHTTPInvoke(IPPort, url):
- conn = httplib.HTTPConnection(IPPort)
- conn.request("GET", url)
- rsps = conn.getresponse()
- data = rsps.read()
- conn.close()
- returndata
- defget_caseinfo(Data, SuiteID):
- caseinfolist=[]
- sInterface=Data.read_data(SuiteID,1,2)
- argcount=int(Data.read_data(SuiteID,2,2))
- ArgNameList=[]
- foriinrange(0, argcount):
- ArgNameList.append(Data.read_data(SuiteID, Data.titleindex, Data.argbegin+i))
- caseinfolist.append(sInterface)
- caseinfolist.append(argcount)
- caseinfolist.append(ArgNameList)
- returncaseinfolist
- defget_input(Data, SuiteID, CaseID, caseinfolist):
- sArge=''
- forjinrange(0, caseinfolist[1]):
- ifData.read_data(SuiteID, Data.casebegin+CaseID, Data.argbegin+j) !="None":
- sArge=sArge+caseinfolist[2][j]+'='+Data.read_data(SuiteID, Data.casebegin+CaseID, Data.argbegin+j)+'&'
- ifsArge[-1:]=='&':
- sArge = sArge[0:-1]
- sInput=caseinfolist[0]+sArge
- returnsInput
- defassert_result(sReal, sExpect):
- sReal=str(sReal)
- sExpect=str(sExpect)
- ifsReal==sExpect:
- return'OK'
- else:
- return'NG'
- defwrite_result(Data, SuiteId, CaseId, resultcol, *result):
- iflen(result)>1:
- ret='OK'
- foriinrange(0, len(result)):
- ifresult[i]=='NG':
- ret='NG'
- break
- ifret=='NG':
- Data.write_data(SuiteId, Data.casebegin+CaseId, resultcol,ret, NG_COLOR)
- else:
- Data.write_data(SuiteId, Data.casebegin+CaseId, resultcol,ret, OK_COLOR)
- Data.allresult.append(ret)
- else:
- ifresult[0]=='NG':
- Data.write_data(SuiteId, Data.casebegin+CaseId, resultcol,result[0], NG_COLOR)
- elifresult[0]=='OK':
- Data.write_data(SuiteId, Data.casebegin+CaseId, resultcol,result[0], OK_COLOR)
- else:
- Data.write_data(SuiteId, Data.casebegin+CaseId, resultcol,result[0], NT_COLOR)
- Data.allresult.append(result[0])
- print'case'+str(CaseId+1)+':', Data.allresult[-1]
- defstatisticresult(excelobj):
- allresultlist=excelobj.allresult
- count=[0,0,0]
- foriinrange(0, len(allresultlist)):
- count=countflag(allresultlist[i],count[0], count[1], count[2])
- print'Statistic result as follow:'
- print'OK:', count[0]
- print'NG:', count[1]
- print'NT:', count[2]
- defget_xmlstring_dict(xml_string):
- xml = XML2Dict()
- returnxml.fromstring(xml_string)
- defget_xmlfile_dict(xml_file):
- xml = XML2Dict()
- returnxml.parse(xml_file)
- defdelcomment(excelobj, suiteid, iRow, iCol, str):
- startpos = str.find('[')
- ifstartpos>0:
- str = str[0:startpos].strip()
- excelobj.write_data(suiteid, iRow, iCol, str, OK_COLOR)
- returnstr
- defcheck_item(excelobj, suiteid, caseid,real_dict, checklist, begincol):
- ret='OK'
- forcheckidinrange(0, len(checklist)):
- real=real_dict[checklist[checkid]]['value']
- expect=excelobj.read_data(suiteid, excelobj.casebegin+caseid, begincol+checkid)
- result=assert_result(real, expect)
- ifresult=='NG':
- writestr=expect+'['+real+']'
- excelobj.write_data(suiteid, excelobj.casebegin+caseid, begincol+checkid, writestr, NG_COLOR)
- ret='NG'
- returnret
- defcheck_struct_item(excelobj, suiteid, caseid,real_struct_dict, structlist, structbegin, structcount):
- ret='OK'
- ifstructcount>1:
- forstructidinrange(0, structcount):
- structdict=real_struct_dict[structid]
- temp=check_item(excelobj, suiteid, caseid,structdict, structlist, structbegin+structid*len(structlist))
- iftemp=='NG':
- ret='NG'
- else:
- temp=check_item(excelobj, suiteid, caseid,real_struct_dict, structlist, structbegin)
- iftemp=='NG':
- ret='NG'
- returnret
- defprint_error_info():
- try:
- raiseException
- except:
- f = sys.exc_info()[2].tb_frame.f_back
- print(f.f_code.co_name, f.f_lineno)
- defcountflag(flag,ok, ng, nt):
- calculation = {'OK':lambda:[ok+1, ng, nt],
- 'NG':lambda:[ok, ng+1, nt],
- 'NT':lambda:[ok, ng, nt+1]}
- returncalculation[flag]()
2、项目测试代码
- fromtestframe.import*
- fromcommon_libimport*
- httpString='http://xxx.com/xxx_product/test/'
- expectXmldir=os.getcwd()+'/TestDir/expect/'
- realXmldir=os.getcwd()+'/TestDir/real/'
- defrun(interface_name, suiteid):
- print'【'+interface_name+'】'+' Test Begin,please waiting...'
- globalexpectXmldir, realXmldir
- expectDir=expectXmldir+interface_name
- realDir=realXmldir+interface_name
- ifos.path.exists(expectDir) ==0:
- os.makedirs(expectDir)
- ifos.path.exists(realDir) ==0:
- os.makedirs(realDir)
- excelobj.del_testrecord(suiteid)
- casecount=excelobj.get_ncase(suiteid)
- caseinfolist=get_caseinfo(excelobj, suiteid)
- forcaseidinrange(0, casecount):
- ifexcelobj.read_data(suiteid,excelobj.casebegin+caseid,2)=='N':
- write_result(excelobj, suiteid, caseid, excelobj.resultCol,'NT')
- continue
- sInput=httpString+get_input(excelobj, suiteid, caseid, caseinfolist)
- XmlString=HTTPInvoke(com_ipport, sInput)
- result_code=et.fromstring(XmlString).find("result_code").text
- ret1=check_result(excelobj, suiteid, caseid,result_code, excelobj.retCol)
- expectPath=expectDir+'/'+str(caseid+1)+'.xml'
- realPath=realDir+'/'+str(caseid+1)+'.xml'
- saveXmlfile(realPath, XmlString)
- ret2= check_xmlfile(excelobj, suiteid, caseid,expectPath, realPath)
- write_result(excelobj, suiteid, caseid, excelobj.resultCol, ret1, ret2)
- print'【'+interface_name+'】'+' Test End!'
3、测试入口
- fromtestframe.import*
- fromxxx_server_caseimport*
- importxxx_server_case
- xxx_server_case.excelobj=create_excel(os.getcwd()+'/TestDir/xxx_Testcase.xls')
- xxx_server_case.com_ipport=xxx.com'
- run("xxx_book_list",4)
- statisticresult(xxx_server_case.excelobj)
- xxx_server_case.excelobj.close()
最后感谢我的同事Roger为此做了一些优化,后续优化的东东还很多,我们一直在努力!
欢迎转载此文,转载时请注明文章来源:张元礼的博客http://blog.csdn.net/vincetest