Re: [sqlalchemy] Binding a connection to a SQLAlchemy session object

2021-05-18 Thread Anupama Goparaju
ok great! thanks again! On Monday, May 17, 2021 at 4:32:02 PM UTC-6 Mike Bayer wrote: > > > On Mon, May 17, 2021, at 6:22 PM, Anupama Goparaju wrote: > > Thanks for the quick reply. Correct, using the same recipe of cx_Oracle > SessionPool + SQLAlchemy NullPool. > If we handle the connection

Re: [sqlalchemy] Binding a connection to a SQLAlchemy session object

2021-05-17 Thread Mike Bayer
On Mon, May 17, 2021, at 6:22 PM, Anupama Goparaju wrote: > Thanks for the quick reply. Correct, using the same recipe of cx_Oracle > SessionPool + SQLAlchemy NullPool. > If we handle the connection close explicitly to release to the pool, will > that skip any exception handling on

Re: [sqlalchemy] Binding a connection to a SQLAlchemy session object

2021-05-17 Thread Anupama Goparaju
Thanks for the quick reply. Correct, using the same recipe of cx_Oracle SessionPool + SQLAlchemy NullPool. If we handle the connection close explicitly to release to the pool, will that skip any exception handling on connections that Session object handles internally for db connections and

Re: [sqlalchemy] Binding a connection to a SQLAlchemy session object

2021-05-17 Thread Mike Bayer
On Mon, May 17, 2021, at 4:21 PM, Anupama Goparaju wrote: > Hi, > > I see in the documentation > that we can bind > a connection to a SQLAlchemy session object: > > *# at the module level, the global sessionmaker,* *# bound to a

[sqlalchemy] Binding a connection to a SQLAlchemy session object

2021-05-17 Thread Anupama Goparaju
Hi, I see in the documentation that we can bind a connection to a SQLAlchemy session object: # at the module level, the global sessionmaker, # bound to a specific Engine Session = sessionmaker(bind=engine) # later, some unit of