|
5鱼币
我在网上拷了分现成的代码,但是运行的时候报错,报错如下:
listid,listkey,listconeent,listurl,listfangshi,listqiwang,listname=f
TypeError: 'NoneType' object is not iterable
但是我单独去测试这种写法,又是没问题的,见第二段代码 ,请有空的大神帮忙看下
- from Interface.testFengzhuang import TestApi
- from Public.get_excel import datacel
- from Public.log import LOG,logger
- import os
- path=os.getcwd()+'\\test_case_data\\case.xlsx'
- f= datacel(path)
- listid,listkey,listconeent,listurl,listfangshi,listqiwang,listname=f
- from Public.panduan import assert_in
- @logger('测试')
- def testinterface():
- list_pass = 0
- list_fail = 0
- list_json = []
- listrelust= []
- list_weizhi=0
- list_exption=0
- for i in range(len(listurl)):
- api=TestApi(url=listurl[i],key=listkey[i],connent=listconeent[i],fangshi=listfangshi[i])
- apijson=api.getJson()
- if apijson['code']==0:
- LOG.info('inputdata> 参数:%s, url:%s ,返回:%s,预期:%s'%(listconeent[i],listurl[i],apijson,listqiwang[i]))
- assert_re=assert_in(asserqiwang=listqiwang[i],fanhuijson=apijson)
- if assert_re['code']==0:
- list_json.append(apijson['result'])
- listrelust.append('pass')
- list_pass += 1
- elif assert_re['code']==1:
- list_fail+=1
- listrelust.append('fail')
- list_json.append(apijson['result'])
- elif assert_re['code']==2:
- list_exption+=1
- listrelust.append('exception')
- list_json.append(assert_re['result'])
- else:
- list_weizhi+=1
- listrelust.append('未知错误')
- list_json.append('未知错误')
- else:
- list_exption += 1
- listrelust.append('exception')
- list_json.append(apijson['result'])
- continue
- return listrelust,list_fail,list_pass,list_json,list_exption,list_weizhi
复制代码
- import xlrd
- def datacel(filrpath):
- file = xlrd.open_workbook(filrpath)
- me = file.sheets()[0]
- nrows = me.nrows
- listid = []
- listkey = []
- listconeent = []
- listurl = []
- listfangshi = []
- listqiwang = []
- listrelut = []
- listname = []
- for i in range(1, nrows):
- listid.append(me.cell(i, 0).value)
- listkey.append(me.cell(i, 2).value)
- listconeent.append(me.cell(i, 3).value)
- listurl.append(me.cell(i, 4).value)
- listname.append(me.cell(i, 1).value)
- listfangshi.append((me.cell(i, 5).value))
- listqiwang.append((me.cell(i, 6).value))
- return listid, listkey, listconeent, listurl, listfangshi, listqiwang, listname
- import os
- filrpath = os.getcwd() + '\\test_case_data\\case.xlsx'
- f = datacel(filrpath)
- print(f)
- listid, listkey, listconeent, listurl, listfangshi, listqiwang, listname = f
- print(listid)
- make_data=[]
- for i in range(len(listid)):
- make_data.append({'url':listurl[i],'key':listkey[i],'coneent':listconeent[i],'fangshi':listfangshi[i],'qiwang':listqiwang[i]})
- i+=1
- print(make_data)
复制代码
|
|