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