Flask-SQLAlchemy ERROR: 'No application found. Either work inside a view function or push'

Question

I am in the process of trying to use flask-sqlalchemy, and I have followed numerous examples in the documentation of how to get the Flask application setup. However, I am not able to get the app context for some reason. I am currently using the app.app_context().push() method. Is there some other way to get this to work? What am I doing wrong? Any help would be appreciated.

Currently running:

Python==3.6.3
Flask==0.12.2
Flask-Compress==1.4.0
Flask-SQLAlchemy==2.3.2

model.py

from flask_sqlalchemy import SQLAlchemy
from sqlalchemy.orm import relationship


db = SQLAlchemy()


class Property(db.Model):
    __tablename__ = 'vt_property'

    id = db.Column(db.BigInteger, primary_key=True)
    name = db.Column(db.String(32))
    value = db.Column(db.LargeBinary)
    client_tag = db.Column(db.String(16))

index.py

from flask import Flask, jsonify, request
from flask_compress import Compress

from database.model import *
from manager.some_util import some_user, some_url, some_pass


# App config.
DEBUG = True
app = Flask(__name__)
app.config.from_object(__name__)
Compress(app)
app.secret_key = secret_key
app.config['SQLALCHEMY_DATABASE_URI'] = 'postgresql+psycopg2://connection_string'
db.init_app(app)
app.app_context().push()

some_util.py

from database.model import Property
from helpers.util import secret_key


def load_some_config():
    from secure.secure import read_encrypted_text
    some_configs = Property.query.filter(Property.name.contains('MANAGER')).all()
    some_url = ''
    some_user = ''
    some_pass = ''
    for c in some_configs:
        if 'URL' in c.name:
            some_url = c.value.decode('utf-8')
        if 'USER' in c.name:
            some_user = c.value.decode('utf-8')
        if 'PASS' in c.name:
            some_pass = read_encrypted_text(c.value).decode('utf-8')
    return some_url, some_user, some_pass

When I try to run my API, I get this error:

*/venv/bin/python */src/api/index.py
Traceback (most recent call last):
  File "*/venv/lib/python3.6/site-packages/sqlalchemy/util/_collections.py", line 988, in __call__
    return self.registry[key]
KeyError: <greenlet.greenlet object at 0xXXXXXXXX>

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "*/src/api/index.py", line 16, in <module>
    from manager.some_util import some_user, some_url, some_pass
  File "*/src/manager/some_util.py", line 23, in <module>
    some_url, some_user, some_pass = load_some_config()
  File "*/src/manager/some_util.py", line 9, in load_some_config
    some_configs = Property.query.filter(Property.name.contains(‘MANAGER’)).all()
  File "*/venv/lib/python3.6/site-packages/flask_sqlalchemy/__init__.py", line 514, in __get__
    return type.query_class(mapper, session=self.sa.session())
  File "*/venv/lib/python3.6/site-packages/sqlalchemy/orm/scoping.py", line 78, in __call__
    return self.registry()
  File "*/venv/lib/python3.6/site-packages/sqlalchemy/util/_collections.py", line 990, in __call__
    return self.registry.setdefault(key, self.createfunc())
  File "*/venv/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2882, in __call__
    return self.class_(**local_kw)
  File "*/venv/lib/python3.6/site-packages/flask_sqlalchemy/__init__.py", line 141, in __init__
    self.app = app = db.get_app()
  File "*/venv/lib/python3.6/site-packages/flask_sqlalchemy/__init__.py", line 912, in get_app
    'No application found. Either work inside a view function or push'
RuntimeError: No application found. Either work inside a view function or push an application context. See http://flask-sqlalchemy.pocoo.org/contexts/.

david david · Accepted Answer · 2020-06-26T23:53:01

To execute some code within the Flask app context, the most simple way is doing this:

with self.app.app_context():

    # ... your code here ...

Note that app is your Flask application object. The variable name might be different in your case.

Flask-SQLAlchemy ERROR: 'No application found. Either work inside a view function or push'

1 Answers