在看了twisted的reactor模式之后，结合WEB Service 和 DBConnection Pool 做了一下的例子
from twisted.web import server, resource,http
from twisted.internet import reactor
from twisted.enterprise import adbapi
import os
class dataprocess:
def __init__(self):
self.dbpool=adbapi.ConnectionPool("MySQLdb",db="test", user="root",passwd="111111")
def getAge(self,user):
print "getAge"
return self.dbpool.runQuery("SELECT age FROM users WHERE name = 'joe'")
def printResult(self,l):
print "print Result"
if l:
print l[0][0], "years old"
else:
print "No such user"
def errorHandler(self,error):
# this isn't a very effective handling of the error, we just print it out:
print "An error has occurred: <%s>" % str(error)
class Simple(resource.Resource):
isLeaf = True
# allowedMethods = ('GET',)
def __init__(self):
pass
def render_GET(self, request):
# headers = request.getAllHeaders()
uri = request.uri
print uri
print request.args,"/n",request.path
mysqldata = dataprocess()
d = mysqldata.getAge("joe")
d.addCallback(mysqldata.printResult)
d.addErrback(mysqldata.errorHandler)
# request.setResponseCode(http.NOT_FOUND)
# return ""
# request._sendError(404,'cann not found')
return "<html>Hello, world! /n you succeed</html>"
# equivalent of cursor.execute(statement), return cursor.fetchall():
if __name__=='__main__':
site = server.Site(Simple())
reactor.listenTCP(8000, site)
print "run"
reactor.run()
该例子是一个server程序，客户端的测试需要http://localhost:8000,服务器端在收到Get之后，马上去查询数据库，效果很好。
2588
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
