def query_all_QA_RD(self):
try:
sql="""select distinct(startby) from tbl_test_management;"""
cnt=self.cursor.execute(sql)
ret=self.cursor.fetchall()
from SOAPpy import WSDL
from SOAPpy import headerType
wsdlUrl = 'http://itebeta.baidu.com:8102/ws/UserRemoteService?wsdl'
server = WSDL.Proxy(wsdlUrl)
hd = headerType(data={"appKey":"UICWSTestKey"})
server.soapproxy.header = hd
qa_list=[]
rd_list=[]
for item in ret:
user = server.getUserByUsername(arg0=item[0])
if(u'测试' in user.departmentName):
qa_list.append('\''+user.username+'\'')
else:
rd_list.append('\''+user.username+'\'')
#print user
return qa_list,rd_list
except Exception as e:
logging.error(str(e))
def __init__(self):
server = WSDL.Proxy(settings.UIC_SERVICE)
hd = headerType(data={"appKey": settings.UIC_KEY})
server.soapproxy.header = hd
self.server = server
# -*- coding: utf-8 -*-
#import sys
#reload(sys)
#sys.setdefaultencoding('utf8')
from SOAPpy import structType
from SOAPpy import headerType
from SOAPpy import SOAPProxy
n = 'http://WebXml.com.cn'
url = 'http://ws.webxml.com.cn/WebServices/WeatherWebService.asmx?wsdl'
ct = structType(data = {'Host' : 'www.webxml.com.cn',
'Content-Type':'text/xml; charset=utf-8',
'SOAPAction': "http://WebXml.com.cn/getWeatherbyCityName"})
ct._validURIs = []
ct._ns = ("ns1", "https://www.xxxxx.com/xxxx")
hd = headerType(data = {"AuthHeader" : ct})
server = SOAPProxy(url, namespace=n, soapaction="http://WebXml.com.cn/getWeatherbyCityName")
server.soapproxy.header = hd
server.config.dumpSOAPOut = 1
server.config.dumpSOAPIn = 1
server.getWeatherbyCityName(theCityName='58367')
def __init__(self):
server = WSDL.Proxy(settings.UIC_SERVICE)
hd = headerType(data={"appKey":settings.UIC_KEY})
server.soapproxy.header = hd
self.server = server
