Re: [sqlalchemy] correlate() with aliases having no effect on FROM clause in 1.0.8?

2015-10-02 Thread Mike Bayer
On 9/29/15 8:47 PM, Charles Duffy wrote: From a StackOverflow answer describing use of the correlate() call in SQLALchemy, at http://stackoverflow.com/questions/13056049/how-to-specify-the-from-tables-in-sqlalchemy-subqueries: |>>>printstr(q1)SELECT t3.id AS t3_id FROM tbl AS t3,tbl AS t1

[sqlalchemy] correlate() with aliases having no effect on FROM clause in 1.0.8?

2015-10-02 Thread Charles Duffy
>From a StackOverflow answer describing use of the correlate() call in SQLALchemy, at http://stackoverflow.com/questions/13056049/how-to-specify-the-from-tables-in-sqlalchemy-subqueries : >>> print str(q1) SELECT t3.id AS t3_id FROM tbl AS t3, tbl AS t1 WHERE t3.id < t1.id ORDER BY t3.id DESC

Re: [sqlalchemy] lowercase identifiers in Oracle

2015-10-02 Thread Mike Bayer
On 10/2/15 9:44 AM, Massimiliano della Rovere wrote: cx-Oracle==5.2 SQLAlchemy==1.0.8 I'm in the weird situation of dealing with an Oracle database with lowercase identifiers (they were created by another software that escapes always table/schema/index identifiers). I get a "NoSuchTableErr

[sqlalchemy] lowercase identifiers in Oracle

2015-10-02 Thread Massimiliano della Rovere
cx-Oracle==5.2 SQLAlchemy==1.0.8 I'm in the weird situation of dealing with an Oracle database with lowercase identifiers (they were created by another software that escapes always table/schema/index identifiers). I get a "NoSuchTableError" whenever I issue a MetaData(bind=engine, reflect=Tr

Re: [sqlalchemy] Is there a better and more idiomatic way to accomplish this?

2015-10-02 Thread Massimiliano della Rovere
Il giorno giovedì 1 ottobre 2015 17:57:45 UTC+2, Michael Bayer ha scritto: > > > > On 10/1/15 11:41 AM, Massimiliano della Rovere wrote: > > [...] > > Second question: > The "postgresql_ops" parameter of the Index class [1] requires that the > keys of the dict must equal the .key attributes of t