Re: [sqlalchemy] schema qualifying Oracle auto-generated queries for the ORM

2020-11-17 Thread Terrence-Monroe: Brannon
On Mon, Nov 16, 2020 at 3:14 PM Mike Bayer wrote: > > these seem to be mostly confusion over Oracle's specific difficulties with > a "default" schema so this is a different question to be answered.It is > cleaner to have the database connection set up so that the "default" schema > is the

Re: [sqlalchemy] schema qualifying Oracle auto-generated queries for the ORM

2020-11-16 Thread Mike Bayer
On Mon, Nov 16, 2020, at 2:58 PM, Terrence-Monroe: Brannon wrote: > > > > > > On Mon, Nov 16, 2020 at 2:45 PM Mike Bayer wrote: >> __ >> >> >> On Mon, Nov 16, 2020, at 1:32 PM, Terrence-Monroe: Brannon wrote: >>> >>> >>> On Mon, Nov 16, 2020 at 1:16 PM Mike Bayer wrote: __

Re: [sqlalchemy] schema qualifying Oracle auto-generated queries for the ORM

2020-11-16 Thread Terrence-Monroe: Brannon
On Mon, Nov 16, 2020 at 2:45 PM Mike Bayer wrote: > > > On Mon, Nov 16, 2020, at 1:32 PM, Terrence-Monroe: Brannon wrote: > > > > On Mon, Nov 16, 2020 at 1:16 PM Mike Bayer > wrote: > > > schema name for tables is set using the .schema parameter of the Table > object. > > > yes, Table() is a

Re: [sqlalchemy] schema qualifying Oracle auto-generated queries for the ORM

2020-11-16 Thread Mike Bayer
On Mon, Nov 16, 2020, at 1:32 PM, Terrence-Monroe: Brannon wrote: > > > On Mon, Nov 16, 2020 at 1:16 PM Mike Bayer wrote: >> __ >> schema name for tables is set using the .schema parameter of the Table >> object. > > yes, Table() is a core concept. I'm more interested in the ORM way of >

Re: [sqlalchemy] schema qualifying Oracle auto-generated queries for the ORM

2020-11-16 Thread Terrence-Monroe: Brannon
On Mon, Nov 16, 2020 at 1:16 PM Mike Bayer wrote: > schema name for tables is set using the .schema parameter of the Table > object. > yes, Table() is a core concept. I'm more interested in the ORM way of achieving this. > > The docs don't state this at once but you are essentially combining

Re: [sqlalchemy] schema qualifying Oracle auto-generated queries for the ORM

2020-11-16 Thread Mike Bayer
On Mon, Nov 16, 2020, at 12:36 PM, Terrence-Monroe: Brannon wrote: > 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 >

Re: [sqlalchemy] schema qualifying Oracle auto-generated queries for the ORM

2020-11-16 Thread Mike Bayer
schema name for tables is set using the .schema parameter of the Table object. The docs don't state this at once but you are essentially combining the information contained at https://docs.sqlalchemy.org/en/13/core/metadata.html#specifying-the-schema-name with

[sqlalchemy] schema qualifying Oracle auto-generated queries for the ORM

2020-11-16 Thread Terrence-Monroe: Brannon
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