Thanks for confirming this and all the info and links. I really appreciate it. It’s a big help.
Thank you too Theron for your help. I hadn’t quite made it that far in the docs yet, but I’ve had a chance to look at it again. Thank you both! > On Aug 13, 2021, at 1:14 PM, 'Jonathan Vanasco' via pylons-discuss > <pylons-discuss@googlegroups.com> wrote: > > > It looks like the `future` flag on Engine and the `future` flag on Session > > are two separate things. So you need to add `future=True` to either > > sessionmaker or the Session constructor. > > Confirming this. There is also a `future` on `Connection` objects, but that > is inherited from `Engine`. Session and Engine/Connection are entirely > unrelated. Please see: > > * > https://docs.sqlalchemy.org/en/14/changelog/migration_20.html#migration-to-2-0-step-four-use-the-future-flag-on-engine > * > https://docs.sqlalchemy.org/en/14/changelog/migration_20.html#migration-to-2-0-step-four-use-the-future-flag-on-session > > > However, I did find self.request.dbsession.bind._is_future. > > that is `Session.bind`, which will be an `Engine` or `Connection` object - > not the Session itself. > > If I use the code below in __init__.py:main() before settings is passed to > Configurator(): > > settings['sqlalchemy.future'] = True > > Assuming you are using the cookiecutter setup, this only affects the Engine. > Please see: > > https://github.com/Pylons/pyramid-cookiecutter-starter/blob/latest/%7B%7Bcookiecutter.repo_name%7D%7D/%7B%7Bcookiecutter.repo_name%7D%7D/sqlalchemy_models/__init__.py#L15-L16 > > So, if this is the correct flag SQLAlchemy sets/uses, it appears to be making > the trip all the way into the view, which is what I wanted to validate. > > Your Engine is in future mode, but your Session is not. As Theron noted, you > need to change your sessionmaker construction. If you are using the > cookiecutter setup, this is what must be adjusted: > > https://github.com/Pylons/pyramid-cookiecutter-starter/blob/latest/%7B%7Bcookiecutter.repo_name%7D%7D/%7B%7Bcookiecutter.repo_name%7D%7D/sqlalchemy_models/__init__.py#L19-L22 > > > > > -- > You received this message because you are subscribed to the Google Groups > "pylons-discuss" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to pylons-discuss+unsubscr...@googlegroups.com > <mailto:pylons-discuss+unsubscr...@googlegroups.com>. > To view this discussion on the web visit > https://groups.google.com/d/msgid/pylons-discuss/74d9b5e4-1006-4d70-b61b-af20d35c00bfn%40googlegroups.com > > <https://groups.google.com/d/msgid/pylons-discuss/74d9b5e4-1006-4d70-b61b-af20d35c00bfn%40googlegroups.com?utm_medium=email&utm_source=footer>. -- You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To unsubscribe from this group and stop receiving emails from it, send an email to pylons-discuss+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/pylons-discuss/C058ACAC-5CF8-48F2-999D-9613D128B0F0%40gmail.com.