I've been using the SA ORM for 3 months simply declaring tables as you see here:
https://docs.sqlalchemy.org/en/13/orm/tutorial.html#declare-a-mapping And then connecting to Oracle via oracle://user:pass@server with no problem. However, today, I was told that my auto-generated queries were failing because they were not qualified with the schema name. I.e, even though SELECT some_column FROM some_table was working, I am now being asked to make the query SELECT some_volumn FROM SCHEMA."some_table" and even though there are docs about specifying the schema for the SQLAlchemy core, I dont see similar docs for the ORM. I found an answer: https://stackoverflow.com/questions/62165654/set-current-schema-for-oracle-connection-using-sqlalchemy but I cannot believe that I need to manually issue this sort of query for this: session.execute(f"ALTER SESSION SET CURRENT_SCHEMA = {schema!s}") -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/2c9b94dc-3477-4a0e-b1a6-e31a229fd04fn%40googlegroups.com.
