On Sat, Apr 27, 2019 at 1:34 PM Michael Merickel <[email protected]> wrote: > > The session and sessionmaker are only necessary if you want to hook into > pyramid_tm, because zope.sqlalchemy requires a session object and won't work > with a simple connection. That being said, I would want to such that > pyramid_tm handles the commits for you.
'session.execute()' executes SQL like 'engine.execute()' does, so you can get the advantages of a request transaction without using ORM queries. I use that in my applications and unit tests, where some functions use the ORM queries and other functions use the underlying tables for efficiency when returning large search results. -- 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 [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/pylons-discuss/CAH9f%3DupM0fWC4Ai9z%2BfWa4AzmCyMF3UE%2BAwXGLWF7%2Bdc38x1Kw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
