flask框架:
#all the imports
import sqlite3
from flask import Flask,request,session,g,redirect,url_for,\
abort,render_template,flash
#configration
DATEBASE = '/temp/flaskr.db'
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'])
if __name__ == '__main__':
app.run()
from contextlib import closing
def init_db():
with closing(connect_db()) as db:
with app.open_resource('schema.sql') as f:
db.cursor().executescript(f.read())
db.commit()
显示>>> from flaskr import init_db
>>> init_db()
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "flaskr.py", line 28, in init_db
with closing(connect_db()) as db:
File "flaskr.py", line 20, in connect_db
return sqlite3.connect(app.config['DATABASE'])
KeyError: 'DATABASE'