I only recommend using this package if your project is already heavily invested in Storm. Instead use SQLAlchemy and Flask-SQLAlchemy.
Flask-Storm is an extension for Flask that adds support for Canonical's ORM Storm to your application. Flask-Storm automatically opens and closes database connections on demand when requests need them.
Access to the database is done using the store application context local. Within an application context this variable holds a reference to a Storm Store instance. If no connection is opened it will automatically open one. When the application context is torn down, normally after the request has returned, the store is closed.
from flask_storm import store
from storm.locals import Int, Unicode
class User(object):
__storm_table__ = "users"
id = Int(primary=True)
name = Unicode()
@app.route("/")
def index():
# Get name of user with ID 1
return store.get(User, 1).name
$ pip install flask_storm[fancy]
This installs Flask-Storm with SQL highlighting and reformatting support. If you do not want this drop the fancy
.
$ pip install flask_storm
Documentation is available on http://flask-storm.readthedocs.io/