I recently updated Flask-SQLAlchemy, and now
db.create_all is raising
RuntimeError: working outside of application context. How do I call
from flask import Flask from flask_sqlalchemy import SQLAlchemy app = Flask(__name__) app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///project.db' db = SQLAlchemy(app) class User(db.Model): id = db.Column(db.Integer, primary_key=True) db.create_all()
This raises the following error:
Traceback (most recent call last): File "/home/david/Projects/flask-sqlalchemy/example.py", line 11, in <module> db.create_all() File "/home/david/Projects/flask-sqlalchemy/src/flask_sqlalchemy/extension.py", line 751, in create_all self._call_for_binds(bind_key, "create_all") File "/home/david/Projects/flask-sqlalchemy/src/flask_sqlalchemy/extension.py", line 722, in _call_for_binds engine = self.engines[key] File "/home/david/Projects/flask-sqlalchemy/src/flask_sqlalchemy/extension.py", line 583, in engines app = current_app._get_current_object() # type: ignore[attr-defined] File "/home/david/Projects/flask-sqlalchemy/.venv/lib/python3.10/site-packages/werkzeug/local.py", line 513, in _get_current_object raise RuntimeError(unbound_message) from None RuntimeError: Working outside of application context. This typically means that you attempted to use functionality that needed the current application. To solve this, set up an application context with app.app_context(). See the documentation for more information.
As of Flask-SQLAlchemy 3.0, all access to
db.session) requires an active Flask application context.
db.engine, so it requires an app context.
with app.app_context(): db.create_all()
When Flask handles requests or runs CLI commands, a context is automatically pushed. You only need to push one manually outside of those situations, such as while setting up the app.
Instead of calling
create_all in your code, you can also call it manually in the shell. Use
flask shell to start a Python shell that already has an app context and the
db object imported.
$ flask shell >>> db.create_all()