[Sqlalchemy-users] python version requirement?

2006-03-12 Thread Jonathan Ellis
Is there an official minimum python version SA wants to support?  Should patches avoid use of decorators, generator expressions, and other 2.4-specific code?This has probably been answered already, in which case, I plead suckiness of the SF search engine. :) -- Jonathan Ellishttp://spyced.blogspot.

Re: [Sqlalchemy-users] Subqueries in functions

2006-03-12 Thread Rick Morrision
Ah, never thought of the str() trickthanks!  This is a bit of an oddball case, and easy to work around, certainly not worth blocking for. SA is progressing and stabilizing nicely. I'm happy with the pace of things and quality of the code. After slinging Javscript all day, it's a joy to make

Re: [Sqlalchemy-users] Subqueries in functions

2006-03-12 Thread Michael Bayer
you know I am looking thru the docs as well as the unit tests and I am surprised that I dont seem to have ever even completed this functionality, i.e. being able to stick a SELECT inside the column clause of another select.  which is very strange since I was pretty sure I hit all these in at least

Re: [Sqlalchemy-users] Subqueries in functions

2006-03-12 Thread Rick Morrision
No, they're supposed to be subqueries -- correlated subqueries. That maybe got lost in simplifying and pasting the code. Note that the problem isn't the inclusion of the subqueries in the column clause -- that's correct. It's the repetition of those subqueries in the FROM clause that's the issue

Re: [Sqlalchemy-users] Subqueries in functions

2006-03-12 Thread Michael Bayer
youre sticking two select() objects in your column clause, inside the functionsso they come out as SELECT statements in your column clause, i.e. subqueries.what SQL are you looking to produce ?   maybe this ?q = db.sql.select([L.c.id, L.c.nm, Z.c.zipcode, db.sql.func.latlondist(Z.c.latitude, Z.

[Sqlalchemy-users] Subqueries in functions

2006-03-12 Thread Rick Morrision
SA seems intent on adding subqueries used in DB functions to the FROM list of a query:     Z = S.Table('zipcodes', dbeng,     S.Column('zipcode',  S.VARCHAR(5), nullable=False, primary_key=True),     S.Column('city', S.VARCHAR(30), nu

[Sqlalchemy-users] A long time for reflection...

2006-03-12 Thread Gambit
Hi guys -- Just svn'ed up the latest source and I noticed a return to the extremely long time for reflection, on the order of around 63 seconds for twenty odd tables, with a fair number of foreign keys and such. The backend is a PostgreSQL 8.1 server running on my WinXP workstation. Looking