pythonflask留言板_python完成留言板功能

#-*- coding: utf-8 -*-

from __future__ importwith_statementimportsqlite3from flask importFlask, request, session, g, redirect, url_for, \

abort, render_template, flashfrom contextlib importclosing#configuration

DATABASE = 'D:\coding\py2.7\liuyan\guestbook.dat' #数据库存储路径

DEBUG =True

SECRET_KEY= 'development key'USERNAME= 'admin'PASSWORD= 'default'

#create our little application :)

app = Flask(__name__)

app.config.from_object(__name__)

app.config.from_envvar('FLASKR_SETTINGS', silent=True)def connect_db(): #快速连接到指定数据库的方法

return sqlite3.connect(app.config['DATABASE'])def init_db(): #初始化数据库

with closing(connect_db()) as db:

with app.open_resource('schema.sql') as f:

db.cursor().executescript(f.read())

db.commit()

@app.before_requestdefbe