Simple Web Application using Cherrypy in Python 3.3 with MySQL

1402 ワード

import cherrypy
import mysql.connector as mconnector
import sys

# Global
global conn
global cur

try:
    conn = mconnector.connect(user='test',
                              password='test1234',
                              host='localhost',
                              database='test')

    cur = conn.cursor()

except:
    print(sys.exc_info()[1])


class HelloWorld(object):

    @cherrypy.expose
    def index(self):
        cherrypy.session["abc"] = "abc"
        return "Hello World!"

    @cherrypy.expose
    def test(self):
        return "Hello world2!"

    @cherrypy.expose
    def say(self, name):
        return "Hello, %s" % name

    @cherrypy.expose
    def getsession(self):
        return cherrypy.session["abc"]

    @cherrypy.expose
    def loaddata(self):
        try:
                cur.execute('select * from testtable1')
                rows = cur.fetchall()

                str = "
".join("%d %s" %(row[0], row[1].decode("utf-8")) for row in rows ) return str; except: return "Error while processing data
" + sys.exc_info()[1]; conf = { '/': { 'tools.sessions.on': True } } cherrypy.quickstart(HelloWorld(),'/', conf)