python-snipets: web/code-webpyorg.wsgi@c6da061b21c4 (annotated)

web/code-webpyorg.wsgi@c6da061b21c4 (annotated)

Sat Jun 20 20:44:03 2009 +0900

profiling for web application

 import os
 import sqlite3
 import web
 import fapws._evwsgi as evwsgi
 from fapws import base
 DBPATH = '/var/www/app/hello/hello.sqlite'
 TEMPLATE_PATH = '/var/www/templates/'
 urls = (
     '/', 'index',
     '/(.*)', 'hello',
 )
 render = web.template.render(TEMPLATE_PATH)
 application = web.application(urls, globals()).wsgifunc()
 db = web.database(dbn='sqlite', db=DBPATH)
 class hello:
     def GET(self, username):
         users = db.select('hellouser', where="name = '%s'" % username)
         isFound = False
         for u in users:
             if u.name == username:
                 isFound = True
         if not isFound:
             db.query("INSERT INTO hellouser (name) VALUES ('%s')" % username)
         return render.hello(username, isFound)
 class index:
     def GET(self):
         return "Hello web.py"
 if __name__ == '__main__':
     if not os.path.exists(DBPATH):
         d = sqlite3.connect(DBPATH)
         c = d.cursor()
         c.execute("create table hellouser (userid integer primary key autoincrement, \
                    name text)")
     application = web.application(urls, globals())
     application.run()