设置数据库名称和位置
DATABASE = 'F:\\test.db'
DEBUG = True
SECRET_KEY = 'development key'
USERNAME =
PASSWORD =
配置
app = Flask(__name__)
app.config.from_object(__name__)
app.config.from_envvar('FLASKR_SETTINGS', silent=True)
连接数据库 初始化
connect_db():
sqlite3.connect(app.config[DATABASE])
init_db():
closing(connect_db()) as db:
app.open_resource('schema.sql') as f:
db.cursor().executescript(f.read())
db.commit()
@before_request():
g.db = connect_db()
@teardown_request():
g.db.close()
提交数据
@app.route('/add', methods=['POST'])
def add_entry():
if not session.get('logged_in'):
abort(401)
db = connect_db()
db.execute('insert into entries (title, text) values (?, ?)',
[request.form['title'], request.form['text']])
db.commit()
flash('New entry was successfully posted')
return redirect(url_for('show_entries'))