Doesn't correctly close flask-sqlachemy-lite transactions/sessions

[ddorian]

Hi,

Clone this minimal repo and follow the readme to reproduce https://github.com/ddorian/admin-sqlalite-bug

You will get the following traceback
full_traceback.txt

Environment: it's all in the repo.

• Python version: 3.10
• Flask version: 3.1.0
• Flask-Admin version: a4e7be8

Regards

[ddorian]

An alternative would be to pass a scoped session to the ModelView. Seems to work fine for now.

def get_scoped_session(db: SQLAlchemy, **options):
    """Scoped session for flask-admin.
    See https://github.com/pallets-eco/flask-admin/issues/2585
    """

    def _app_ctx_id() -> int:
        """Get the id of the current Flask application context for the session scope."""
        return id(app_ctx._get_current_object())  # type: ignore[attr-defined]

    scope = options.pop("scopefunc", _app_ctx_id)
    return scoped_session(db.sessionmaker, scope)