import tornado.ioloop
import tornado.web
import tornado.gen
import asynctorndb

class MainHandler(tornado.web.RequestHandler):
    @tornado.gen.coroutine
    def get(self):
        conn = asynctorndb.Connect(user='demo', passwd='demo', database='demo')
        yield conn.connect()
        result = yield conn.query('select * from user')
        # do something with result
        self.write("Hello, world")

application = tornado.web.Application([
    (r"/", MainHandler),
])

if __name__ == "__main__":
    application.listen(8888)
    tornado.ioloop.IOLoop.instance().start()