Re: [sqlalchemy] Connection pooling uses connections rather than sessions

2020-12-09 Thread Mike Bayer
Oracle describes SessionPool at: https://cx-oracle.readthedocs.io/en/latest/user_guide/connection_handling.html#connpool This pool describes the connection lifecycle as first calling pool.acquire(), and then pool.release(connection), however the good news is that if connection.close() is called

Re: [sqlalchemy] Connection pooling uses connections rather than sessions

2020-12-09 Thread Anupama Goparaju
I have tried below approach in SQLAlchemy 1.3.16. Use a creator function - if you need to use special form when calling cx_oracle.connect(), a creator function will allow you to plug into the Engine how cx_oracle connections are established. The creator function, that i associated would interna

Re: [sqlalchemy] Connection pooling uses connections rather than sessions

2020-12-09 Thread Anupama Goparaju
Hi. I would like to know how to use a cx-oracle SessionPool with SQLAlchemy. We are leveraging the Session object of SQLAlchemy but we would like to use the driver level pooling instead of SQLAlchemy pool. Please advise. Thanks, Anupama On Monday, October 3, 2011 at 12:23:58 PM UTC-6 Mike Bayer

[sqlalchemy] Re: sqlacodegen generating Table objects in some cases

2020-12-09 Thread Larry Martell
On Wed, Dec 9, 2020 at 11:49 AM Larry Martell wrote: > > On Wed, Dec 9, 2020 at 11:44 AM Larry Martell wrote: > > > > When I run sqlacodegen on my DB it creates classes for most of the > > tables, but for some it creates only Table objects. I don't see any > > rhyme or reason as to why it does th

[sqlalchemy] Re: sqlacodegen generating Table objects in some cases

2020-12-09 Thread Larry Martell
On Wed, Dec 9, 2020 at 11:44 AM Larry Martell wrote: > > When I run sqlacodegen on my DB it creates classes for most of the > tables, but for some it creates only Table objects. I don't see any > rhyme or reason as to why it does this for some. How can I get to > generate classes for all the table

[sqlalchemy] sqlacodegen generating Table objects in some cases

2020-12-09 Thread Larry Martell
When I run sqlacodegen on my DB it creates classes for most of the tables, but for some it creates only Table objects. I don't see any rhyme or reason as to why it does this for some. How can I get to generate classes for all the tables? -- SQLAlchemy - The Python SQL Toolkit and Object Relation