• Search by Module
• Search by Words
• Search Projects

• Java
• Python
• JavaScript
• TypeScript
• C++
• Scala
• Blog

• greentor-master
  • demo
    • application.py
    • demo
      • wsgi.py
      • urls.py
      • __init__.py
      • settings.py
    • manage.py
    • README.md
    • requirements.txt
    • core
      • __init__.py
      • handlers.py
      • monkey_patch.py
      • base.py
    • app
      • apps.py
      • models.py
      • urls.py
      • tests.py
      • __init__.py
      • migrations
        • 0001_initial.py
        • __init__.py
      • handlers.py
      • admin.py
  • LICENSE
  • setup.py
  • greentor
    • glocal.py
    • mysql.py
    • __init__.py
    • green.py
  • README.md
  • tests
    • hello.py
    • requirements.txt
  • .gitignore

# coding: utf-8

from greentor import green
# green.enable_debug()
from greentor import mysql
mysql.patch_pymysql()

import pymysql
pymysql.install_as_MySQLdb()

import MySQLdb

import tornado.httpserver
import tornado.ioloop
import tornado.options
import tornado.web
import tornado.gen

from tornado.options import define, options

define("port", default=8000, help="run on the given port", type=int)


class MainHandler(tornado.web.RequestHandler):
    @green.green
    def get(self):
        connect = MySQLdb.connect(user='root',
                                  passwd='',
                                  db='test',
                                  host='localhost',
                                  port=3306,
                                  charset='utf8')
        cursor = connect.cursor()
        cursor.execute('SELECT * FROM app_blog LIMIT 1')
        result = cursor.fetchone()
        cursor.close()
        connect.close()
        self.finish(u'<p>{}</p><p>{}</p>'.format(result[1], result[2]))


pool = mysql.ConnectionPool(mysql_params={
    'user': 'root',
    'passwd': '',
    'db': 'test',
    'host': 'localhost',
    'port': 3306,
    'charset': 'utf8'
})


class ConnectionPoolHandler(tornado.web.RequestHandler):
    @green.green
    def get(self):
        connect = pool.get_conn()
        cursor = connect.cursor()
        cursor.execute('SELECT * FROM app_blog LIMIT 1')
        result = cursor.fetchone()
        cursor.close()
        pool.release(connect)
        self.finish(u'<p>{}</p><p>{}</p>'.format(result[1], result))


def main():
    tornado.options.parse_command_line()
    application = tornado.web.Application([(r"/", MainHandler),
                                           (r"/pool/", ConnectionPoolHandler)],
                                          debug=True)
    http_server = tornado.httpserver.HTTPServer(application)
    http_server.listen(options.port)
    tornado.ioloop.IOLoop.instance().start()


if __name__ == "__main__":
    main()