Re: [sqlalchemy] Single table inheritance + join weirdness

2011-11-16 Thread Alex Grönholm
Yeah my bad, the original query does indeed query for (Z.id, B.name). I had just changed it to A.name to get the printout for the workaround query and forgot to change it back before pasting here. If there's something I can do to contribute (not sure I'm qualified to write those tests), do

[sqlalchemy] joinedload/subqueryload and friends

2011-11-16 Thread werner
In my application I have a user configured list control which is a bit slow, so I started experimenting with joinedload and friends. Looked at: http://www.sqlalchemy.org/docs/orm/loading.html This is working and cuts query time just about in half. drinks =

Re: [sqlalchemy] Single table inheritance + join weirdness

2011-11-16 Thread Michael Bayer
heh :) the thing about tests is that anyone who gets a couple of days of practice writing them in our style can be very productive...but everyone has just one issue they need so that threshold isn't passed ... I have a boatload of tests to write for the 0.7.4 milestone so I'll be blocking

Re: [sqlalchemy] joinedload/subqueryload and friends

2011-11-16 Thread Michael Bayer
On Nov 16, 2011, at 9:36 AM, werner wrote: In my application I have a user configured list control which is a bit slow, so I started experimenting with joinedload and friends. Looked at: http://www.sqlalchemy.org/docs/orm/loading.html This is working and cuts query time just about in

Re: [sqlalchemy] joinedload/subqueryload and friends

2011-11-16 Thread werner
Michael, On 11/16/2011 05:25 PM, Michael Bayer wrote: ... It shouldn't be too hard to roll a Python function that does what you want here, though.Then I looked and saw this is like a programming interview question - basically an unusual traversal. If i were asked this on an interview,

[sqlalchemy] Trouble getting started with SQLAlchemy on Jython

2011-11-16 Thread CamJackson
(First time poster here, sorry if I break any rules. I tried to find info on formatting code etc, but failed.) Versions used: Python 2.7, Jython 2.5.2 (w/ Java 1.6), SQLAlchemy 0.7.3, PostgreSQL 9.1 I'm having some trouble getting started with SQLAlchemy. I've been following along with this

Re: [sqlalchemy] Trouble getting started with SQLAlchemy on Jython

2011-11-16 Thread Michael Bayer
On Nov 17, 2011, at 1:04 AM, CamJackson wrote: (First time poster here, sorry if I break any rules. I tried to find info on formatting code etc, but failed.) However if I try to run the above code on Jython, with the only modification being to change the string passed to create_engine()

Re: [sqlalchemy] Trouble getting started with SQLAlchemy on Jython

2011-11-16 Thread Michael Bayer
On Nov 17, 2011, at 1:27 AM, Michael Bayer wrote: On Nov 17, 2011, at 1:04 AM, CamJackson wrote: (First time poster here, sorry if I break any rules. I tried to find info on formatting code etc, but failed.) However if I try to run the above code on Jython, with the only

Re: [sqlalchemy] Trouble getting started with SQLAlchemy on Jython

2011-11-16 Thread Philip Jenvey
On Nov 16, 2011, at 10:27 PM, Michael Bayer wrote: On Nov 17, 2011, at 1:04 AM, CamJackson wrote: (First time poster here, sorry if I break any rules. I tried to find info on formatting code etc, but failed.) However if I try to run the above code on Jython, with the only