def get_ncols(self, iSheet): try: sht = self.book.Worksheets(iSheet) return sht.UsedRange.Columns.Count except: self.close() print('获取ncols失败') exit() def del_testrecord(self, suiteid): try: #为提升性能特别从For循环提取出来 nrows=self.get_nrows(suiteid)+1 ncols=self.get_ncols(suiteid)+1 begincol=self.argbegin+self.argcount #提升性能 sht = self.book.Worksheets(suiteid) for row in range(self.casebegin, nrows): for col in range(begincol, ncols): str=self.read_data(suiteid, row, col) #清除实际结果[] startpos = str.find('[') if startpos>0: str = str[0:startpos].strip() self.write_data(suiteid, row, col, str, OK_COLOR) else: #提升性能 sht.Cells(row, col).Interior.Color = OK_COLOR #清除TestResul列中的测试结果,设置为NT 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() #执行调用 def HTTPInvoke(IPPort, url): conn = httplib.HTTPConnection(IPPort) conn.request("GET", url) rsps = conn.getresponse() data = rsps.read() conn.close() return data #获取用例基本信息[Interface,argcount,[ArgNameList]] def get_caseinfo(Data, SuiteID): caseinfolist=[] sInterface=Data.read_data(SuiteID, 1, 2) argcount=int(Data.read_data(SuiteID, 2, 2)) #获取参数名存入ArgNameList ArgNameList=[] for i in range(0, argcount): ArgNameList.append(Data.read_data(SuiteID, Data.titleindex, Data.argbegin+i)) caseinfolist.append(sInterface) caseinfolist.append(argcount) caseinfolist.append(ArgNameList) return caseinfolist
#获取输入 def get_input(Data, SuiteID, CaseID, caseinfolist): sArge='' #参数组合 for j in range(0, caseinfolist[1]): if Data.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)+'&' #去掉结尾的&字符 if sArge[-1:]=='&': sArge = sArge[0:-1] sInput=caseinfolist[0]+sArge #组合全部参数 return sInput
-
- def assert_result(sReal, sExpect):
- sReal=str(sReal)
- sExpect=str(sExpect)
- if sReal==sExpect:
- return 'OK'
- else:
- return 'NG'
|