web.py在SAE中的Session问题解决方法（使用mysql存储）

这段时间一直想尝试着在SAE中使用Python，初步选择了Web.py框架做为开发框架，但是可怜SAE上的资料少的可怜，有点问题基本上解决不了，今天解决一个Session在Session的存储问题,在SAE中不能直接用本地文件存储，好像是权限的原因，我现在采用的是保存在mysql中，效果也不错。希望对大家有帮助。直接上代码了。

index.wsgi

    #!/usr/bin/env python
    # coding: utf-8
    import os
    import web
    import sae
    from config.url import urls
    from config import settings

    #是否具有调试功能
    web.config.debug = False
    # app = web.application(urls, globals()).wsgifunc()
    # application = sae.create_wsgi_app(app)

    #解决Session在SAE中的问题
    app = web.application(urls, globals())

    #将session保存在数据库中
    db = settings.db
    store = web.session.DBStore(db, 'sessions')
    #session = web.session.Session(app, store, initializer={'access_token': 'true'})
    session = web.session.Session(app, store)
    web.config._session = session

    application = sae.create_wsgi_app(app.wsgifunc())
    url.py
    #!/usr/bin/env python
    # coding: utf-8

    pre_fix = 'controllers.'

    urls = (
      '/',          pre_fix + 'todo.Index',
      '/todo/new',      pre_fix + 'todo.New',
      '/todo/(\d+)',     pre_fix + 'todo.View',
      '/todo/(\d+)/edit',   pre_fix + 'todo.Edit',
      '/todo/(\d+)/delete',  pre_fix + 'todo.Delete',
      '/todo/(\d+)/finish',  pre_fix + 'todo.Finish',
      '/todo/login', pre_fix + 'login.LoginUser',
      '/todo/checkuser',pre_fix+'login.CheckUser',
      '/todo/reset',pre_fix+'todo.reset',
      '/todo/saveupload','mycontrollers.saveupload.SaveUpload'
    )
    setting.py
    #!/usr/bin/env python
    # coding: utf-8
    import web
    import sae.const
    #数据库设定
    db = web.database(dbn='mysql', user=sae.const.MYSQL_USER, pw=sae.const.MYSQL_PASS, host=sae.const.MYSQL_HOST, port=3307, db=sae.const.MYSQL_DB)
    #模板设定
    render = web.template.render('templates/', cache=False)

    config = web.storage(
      email='oooo@qq.com<script cf-hash="f9e31" type="text/javascript">
    /* <![CDATA[ */!function(){try{var t="currentScript"in document?document.currentScript:function(){for(var t=document.getElementsByTagName("script"),e=t.length;e--;)if(t[e].getAttribute("cf-hash"))return t[e]}();if(t&&t.previousSibling;){var e,r,n,i,c=t.previousSibling,a=c.getAttribute("data-cfemail");if(a){for(e="",r=parseInt(a.substr(0,2),16),n=2;a.length-n;n+=2)i=parseInt(a.substr(n,2),16)^r,e+=String.fromCharCode(i);e=document.createTextNode(e),c.parentNode.replaceChild(e,c)}}}catch(u){}}();/* ]]> */</script>',
      site_name = '任务跟踪',
      site_desc = '',
      static = '/static',
    )

    web.template.Template.globals['config'] = config
    web.template.Template.globals['render'] = render
    login.py
    #!/usr/bin/env python
    # coding: utf-8
    import web
    from config import settings
    render = settings.render
    def myloadhook():
      global session
      session = web.config._session
    class LoginUser:
      def GET(self):
        return render.LoginUser()
    class CheckUser:
      def POST(self):
        #获取Session相关信息
        myloadhook()
        #获取表单信息
        i = web.input()
        username =i.get('txtUserName',None)
        password=i.get('txtUserPass',None)
        #从全局配置文件中得到session
        session = web.config._session
        if username == 'chu888' and password == 'chu888':
          session.access_token = 'true'
          raise web.seeother('/')
        else:
          session.access_token = 'false'
          raise web.seeother('/todo/login')