· 8 years ago · Sep 23, 2017, 06:50 PM
1DATABASE = '/tmp/flaskr.db'
2DEBUG = True
3SECRET_KEY = 'dev key'
4USERNAME = 'admin'
5PASSWORD = 'default'
6
7# inherit config from Flask obj
8app = Flask(__name__)
9app.config.from_object(__name__)
10app.config.from_envvar('FLASK_SETTING', silent=True)
11
12# Activate sqlite DB connection using /tmp/flaskr.db
13def connect_db():
14 return sqlite3.connect(app.config['DATABASE'])
15
16# execute script at cursor begining
17def init_db():
18 with closing(connect_db()) as db:
19 with app.open_resource('schema.sql') as f:
20 db.cursor().executescript(f.read())
21 db.commit()
22
23# run before request
24@app.before_request
25def before_request():
26 g.db = connect_db()
27
28# process request
29@app.after_request
30def after_request(response):
31 g.db.close()
32 return response
33
34# post-process request
35def tearDown(exception):
36 pass