flask_sqlalchemy_session not working in Query.with_session() context

[mzoll]

First of all, thanks for this nice wrapper. It really works like a charm.

However, I have a problem to get it going with session-less queries, like so

class MyORM(Base):
    __table__ = 'mytable'
    id = Column('Integer')
    name = Column('String')

from flask_sqlalchemy_session import current_session

@app.route("/home_alone")
def home_alone():
    bare_qry = Query(MyORM)
    rslt = bare_qry.with_session(current_session).all()

I will get the AttributeError: 'flask_scoped_session' object has no attribute '_autoflush'

I guess the problem is that your wrapper around the session does not let 'shine through' certain trickery of the native sqlaclhemy.Session.

I am using flask_sqlalchemy_session version 1.1.

[dtheodor]

The flask_scoped_session is an SQL Alchemy scoped session, so you can use it in exactly the same way you would use that. Your scenario should fail with the same error if you used a scoped session. I think what you might need is to get a hold of the actual underlying session by calling the scoped_session(). In your example, bare_qry.with_session(current_session()).all()