Re: [sqlalchemy] Orm models, transaction and multiple binds

2019-01-15 Thread Jonathan Vanasco
On Friday, January 11, 2019 at 2:45:58 PM UTC-5, Mike Bayer wrote: > > if these "binds" point to exactly the same database schema and just > have different permissions you might find it much easier to use one > session with two binds.You can override get_bind() to use a > different engine

Re: [sqlalchemy] Orm models, transaction and multiple binds

2019-01-14 Thread tonthon
It should solve my problem. I'm still amazed by the very high quality of this mailing-list. The answers are always targeting very precisely the solutions to the problems I'm sharing. Thanks a lot !! Le ven. 11 janv. 2019 à 20:45, Mike Bayer a écrit : > On Fri, Jan 11, 2019 at 1:19 PM tonthon

Re: [sqlalchemy] Orm models, transaction and multiple binds

2019-01-11 Thread Mike Bayer
On Fri, Jan 11, 2019 at 1:19 PM tonthon wrote: > > Hi, > > We're using Sqlalchemy in a Pyramid web application, with the pyramid_tm > package (a transaction that wraps every web request inside a DB transaction). > It's very usefull and it works like a charm. > > In order to follow some security

[sqlalchemy] Orm models, transaction and multiple binds

2019-01-11 Thread tonthon
Hi, We're using Sqlalchemy in a Pyramid web application, with the pyramid_tm package (a transaction that wraps every web request inside a DB transaction). It's very usefull and it works like a charm. In order to follow some security rules and to be able to certify part of our app, we want to chan