Re: [sqlalchemy] Heads up on bizarre SQL Alchemy + pytest + cx_Oracle interaction

2020-12-06 Thread Mike Bayer
Hey there- I did not take it as any kind of dump on SQLAlchemy at all, it's very common that folks are not aware of the boundary between SQLAlchemy and their DBAPI and as it looks like you are having a shared library issue, I'm sure the cx_Oracle folks could give you some guidance and maybe

Re: [sqlalchemy] Heads up on bizarre SQL Alchemy + pytest + cx_Oracle interaction

2020-12-05 Thread douhet
Hi Mike. First, txs for your awesome package. This WAS NOT meant as a dump on SQLAlchemy to fix and you're in fact victim of your own success - I'm by now too lazy to connect directly to databases, but rely on SQLAlchemy to mediate even if I skip the ORM features and use raw sql. I suspect the

Re: [sqlalchemy] Heads up on bizarre SQL Alchemy + pytest + cx_Oracle interaction

2020-12-05 Thread Mike Bayer
hey there - this is a cx_Oracle issue. SQLAlchemy knows nothing about Oracle's native libraries. please report it at https://github.com/oracle/python-cx_Oracle/issues I'm sure they'll be glad to help as they are quite responsive. On Sat, Dec 5, 2020, at 1:10 PM, JL Peyret wrote: > I have

[sqlalchemy] Heads up on bizarre SQL Alchemy + pytest + cx_Oracle interaction

2020-12-05 Thread JL Peyret
I have some code that connects to Oracle via cx_Oracle + SQL Alchemy. This code works fine under unittest and in actual use. It fails when under pytest. The actual error message I get is: sqlalchemy.exc.DatabaseError: (cx_Oracle.DatabaseError) DPI-1047: Cannot locate a 64-bit Oracle