SAE (Sina App Engine) 限制應用寫入本地文件系統,導致 web.py 默認的文件式 Session 存儲失效。解決方案是將 Session 數據存入 SAE 提供的共享 MySQL 數據庫。
web.session.DBStore + MySQLsae.const 獲取連接信息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())
# 配置數據庫連接(settings.db 已在 settings.py 中初始化)
db = settings.db
store = web.session.DBStore(db, 'sessions') # 表名 sessions
# 初始化 Session,綁定到應用與全局配置
session = web.session.Session(app, store, initializer={'access_token': 'false'})
web.config._session = session
# SAE WSGI 入口
application = sae.create_wsgi_app(app.wsgifunc())
config/settings.py#!/usr/bin/env python
# coding: utf-8
import web
import sae.const
# 使用 SAE 內置常量自動獲取數據庫連接信息
db = web.database(
dbn='mysql',
user=sae.const.MYSQL_USER,
pw=sae.const.MYSQL_PASS,
host=sae.const.MYSQL_HOST,
port=3307, # SAE MySQL 端口
db=sae.const.MYSQL_DB
)
# 模板渲染器
render = web.template.render('templates/', cache=False)
# 站點配置
config = web.storage(
email='admin@example.com',
site_name='任務追蹤',
site_desc='',
static='/static',
)
web.template.Template.globals['config'] = config
web.template.Template.globals['render'] = render
config/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'
)
controllers/login.py#!/usr/bin/env python
# coding: utf-8
import web
from config import settings
render = settings.render
def load_session():
"""掛載全局 session 到局部變量"""
global session
session = web.config._session
class LoginUser:
def GET(self):
return render.LoginUser()
class CheckUser:
def POST(self):
load_session()
i = web.input()
username = i.get('txtUserName', '')
password = i.get('txtUserPass', '')
# 簡單驗證(生產環境應用哈希比對)
if username == 'chu888' and password == 'chu888':
session.access_token = 'true'
raise web.seeother('/')
else:
session.access_token = 'false'
raise web.seeother('/todo/login')
sessions 表,字段包括 session_id、atime (訪問時間)、data (pickle 序列化數據)。initializer 定義默認鍵值,避免 KeyError。web.config._session = session 使各處理器可通過 web.config._session 訪問。load_session() 在每個請求處理前調用,確保 session 變量可用。config.yaml 中聲明了 MySQL 服務。web.config.debug = False 並配置錯誤日誌。atime 過舊的記錄。通過 DBStore 將 Session 持久化到 MySQL,完美解決了 SAE 無本地寫入權限的限制。該方案遵循 web.py 設計模式,代碼改動最小,穩定可靠,適合生產環境使用。