[sqlalchemy] Re: Problems with Oracle Express/sqlalchemy

2008-05-24 Thread Michael Bayer
On May 23, 2008, at 10:02 PM, Brandon Goldfedder wrote: Michael, Yes - that is what I am doing now : ForeignKey(schemaname.tablename.colname) and I have things working. (see example 3). My problem is these steps seem really ugly and a lot more work than it should be to get things

[sqlalchemy] Re: Select results to object help

2008-05-24 Thread Michael Bayer
On May 24, 2008, at 12:25 AM, Jeff Putsch wrote: Now, when I add the filter like this: print NisAccount.query().select_from(a1.join(a2, (a1.c.eid == a2.c.eid) (a1.c.uid != a2.c.uid))).filter(a1.c.eid.in_(s3) (a1.c.domain_id == 41)).compile() I get an infinite recursion error. 0.5 may

[sqlalchemy] Re: Problems with Oracle Express/sqlalchemy

2008-05-24 Thread Brandon Goldfedder
MIchael, Thanks for your help on this - I agree I want to get beyond a mess here regardless if it is 'working' Here are 3 tables that demostrate the issues (with the changes I needed to do use_alter, modify schema.py, hardcode in schema name to ForeignKey and tables). I want the model

[sqlalchemy] Re: Select results to object help

2008-05-24 Thread Jeff Putsch
On May 24, 2008, at 7:00 AM, Michael Bayer wrote: On May 24, 2008, at 12:25 AM, Jeff Putsch wrote: Now, when I add the filter like this: print NisAccount.query().select_from(a1.join(a2, (a1.c.eid == a2.c.eid) (a1.c.uid != a2.c.uid))).filter(a1.c.eid.in_(s3) (a1.c.domain_id ==

[sqlalchemy] Re: Problems with Oracle Express/sqlalchemy

2008-05-24 Thread Michael Bayer
thank you , this was an old ticket #709 and is fixed in r4814 of the 0.4 branch and r4813 of trunk. remove the usage of owner, it is synonymous with schema (as it is in oracle itself - http://www.dba-oracle.com/t_schema_components_owner_user.htm ) , as well as all the other hacks. On

[sqlalchemy] Re: Problems with Oracle Express/sqlalchemy

2008-05-24 Thread Brandon Goldfedder
Michael, Great - that handles the create_all(checkfirst issue) Any fix for the ix_ table name taking into account Oracle name limits in schema.py? Thx, Brandon On May 24, 7:37 pm, Michael Bayer [EMAIL PROTECTED] wrote: thank you , this was an old ticket #709 and is fixed in r4814 of the   0.4

[sqlalchemy] Re: Problems with Oracle Express/sqlalchemy

2008-05-24 Thread Michael Bayer
old bug, I think its #820. we generate a bad name in that case. Try using the schema.Index() or schema.DDL() construct for now as a workaround (I'm not entirely thrilled about the index=True option on Column in general). On May 24, 2008, at 8:20 PM, Brandon Goldfedder wrote:

[sqlalchemy] Can't figure out how to do query with sub-query and count through SA

2008-05-24 Thread gatto
been working all day long on this, and i don't feel like i've gotten any closer than when i started.. read all the related posts on this group and couldn't determine what to do based on those. hoping someone can shed some light. i'm attempting to convert the codebase of an existing project

[sqlalchemy] Re: Can't figure out how to do query with sub-query and count through SA

2008-05-24 Thread Michael Bayer
On May 25, 2008, at 1:04 AM, gatto wrote: been working all day long on this, and i don't feel like i've gotten any closer than when i started.. read all the related posts on this group and couldn't determine what to do based on those. hoping someone can shed some light. i'm attempting