· 8 years ago · Oct 17, 2017, 09:10 AM
1with app.open_resource('schema.sql') as f:
2AttributeError: 'Flask' object has no attribute 'open_resourse'
3
4import sqlite3
5import os
6from flask import Flask, request, session, g, redirect, url_for,
7abort, render_template, flash
8from contextlib import closing
9
10DATABASE = '/tmp/flaskr.db'
11DEBUG = True
12SECRET_KEY = 'development key'
13USERNAME = 'admin'
14PASSWORD = 'default'
15
16app = Flask(__name__)
17app.config.from_object(__name__)
18
19app.config.update(dict(
20 DATABASE=os.path.join(app.root_path, 'flaskr.db'),
21 DEBUG=True,
22 SECRET_KEY='development key',
23 USERNAME='admin',
24 PASSWORD='default'
25))
26app.config.from_envvar('FLASKR_SETTINGS', silent=True)
27
28def connect_db():
29 rv = sqlite3.connect(app.config['DATABASE'])
30 rv.row_factory = sqlite3.Row
31 return rv
32
33def init_db():
34 with closing(connect_db()) as db:
35 with app.open_resource('schema.sql') as f:
36 db.cursor().executescript(f.read())
37 db.commit()
38
39def get_db():
40 if not hasattr(g, 'sqlite_db'):
41 g.sqlite_db = connect_db()
42 return g.sqlite_db
43
44@app.teardown_appcontext
45def close_db(error):
46 if hasattr(g, 'sqlite_db'):
47 g.sqlite_db.close()
48
49if __name__ == '__main__':
50 app.run()