momoko tornado 连接池异步

来源：互联网发布：linux 删除svn信息编辑：程序博客网时间：2024/04/28 00:52

import tornado.ioloop

import tornado.web

import momoko

from tornado import gen

class BaseHandler(tornado.web.RequestHandler):

@property

def db(self):

# Create a database connection when a request handler is called

# and store the connection in the application object.

if not hasattr(self.application,'db'):

self.application.db = momoko.AsyncClient({

'host':'',

'database': '',

'user': '',

'password': '',

'min_conn': 1,

'max_conn': 20,

'cleanup_timeout': 10

})

return self.application.db

class SingleQueryHandler(BaseHandler):

@tornado.web.asynchronous

@gen.engine

def get(self):

# One simple query

cursor = yield gen.Task(self.db.execute,'SELECT 42, 12, %s, 11;', (25,))

self.write('Query results: %s' % cursor.fetchall())

self.finish()

class LSingleQueryHandler(BaseHandler):

@tornado.web.asynchronous

@gen.engine

def get(self):

# One simple query

cursor = yield gen.Task(self.db.execute,'select count(*) from asd a,asd b,asd c')

self.write('Query results: %s' % cursor.fetchall())

self.finish()

class BatchQueryHandler(BaseHandler):

@tornado.web.asynchronous

@gen.engine

def get(self):

# These queries are executed all at once and therefore they need to be

# stored in an dictionary so you know where the resulting cursors

# come from, because they won't arrive in the same order.

cursors = yield gen.Task(self.db.batch, {

'query1': ['SELECT 42, 12, %s, %s;', (23,56)],

'query2':'SELECT 1, 2, 3, 4, 5;',

'query3':'SELECT 465767, 4567, 3454;'

})

for key, cursor in cursors.items():

self.write('Query results: %s = %s ' % (key, cursor.fetchall()))

self.finish()

class QueryChainHandler(BaseHandler):

@tornado.web.asynchronous

@gen.engine

def get(self):

# Execute a list of queries in the order you specified

cursors = yield gen.Task(self.db.chain, (

['SELECT 42, 12, %s, 11;', (23,)],

'SELECT 1, 2, 3, 4, 5;'

))

for cursor in cursors:

self.write('Query results: %s ' % cursor.fetchall())

self.finish()

class MultiQueryHandler(BaseHandler):

@tornado.web.asynchronous

@gen.engine

def get(self):

cursor1, cursor2, cursor3 = yield [

gen.Task(self.db.execute, 'SELECT 42, 12, %s, 11;', (25,)),

gen.Task(self.db.execute, 'SELECT 42, 12, %s, %s;', (23,56)),

gen.Task(self.db.execute, 'SELECT 465767, 4567, 3454;')

]

self.write('Query 1 results: %s ' % cursor1.fetchall())

self.write('Query 2 results: %s ' % cursor2.fetchall())

self.write('Query 3 results: %s' % cursor3.fetchall())

self.finish()

class CallbackWaitHandler(BaseHandler):

@tornado.web.asynchronous

@gen.engine

def get(self):

self.db.execute('SELECT 42, 12, %s, 11;', (25,),

callback=(yield gen.Callback('q1')))

self.db.execute('SELECT 42, 12, %s, %s;', (23,56),

callback=(yield gen.Callback('q2')))

self.db.execute('SELECT 465767, 4567, 3454;',

callback=(yield gen.Callback('q3')))

cursor1 = yield gen.Wait('q1')

cursor2 = yield gen.Wait('q2')

cursor3 = yield gen.Wait('q3')

self.write('Query 1 results: %s ' % cursor1.fetchall())

self.write('Query 2 results: %s ' % cursor2.fetchall())

self.write('Query 3 results: %s' % cursor3.fetchall())

self.finish()

class MainHandler(tornado.web.RequestHandler):

def get(self):

self.write("You requested the main page")

class StoryHandler(tornado.web.RequestHandler):

def get(self, story_id):

self.write(str(story_id))

application = tornado.web.Application([

(r"/", MainHandler),

(r"/story/([0-9]+)", StoryHandler),

(r"/test", SingleQueryHandler),

(r"/ltest", LSingleQueryHandler),

])

if __name__ == "__main__":

application.listen(8888)

tornado.ioloop.IOLoop.instance().start()

momoko tornado 连接池 异步

momoko tornado 连接池异步