Re: [Sqlalchemy-users] mapper.select and limit=]

On Thu, May 04, 2006 at 11:43:21AM -0400, Michael Bayer wrote: > I juts commited a tweak in 1387 to make this easier. your test > program can do: > > ret = m.select("city_name = 'Rome'", from_obj=[cities], limit=10) > > or more correctly: > ret = m.select("city.city_name = 'Rome' a

Re: [Sqlalchemy-users] mapper.select and limit=

I juts commited a tweak in 1387 to make this easier. your test program can do: ret = m.select("city_name = 'Rome'", from_obj=[cities], limit=10) giving you: SELECT users.city_id AS users_city_id, users.user_name AS users_user_name, city_e54b.city_id AS city_e54b_city_id, city_e54

Re: [Sqlalchemy-users] mapper.select and limit=

well in this example youre not really getting what you want in any case. youre trying to depend upon the eager load conditions already joining in the "cities" table but thats not really how that was meant to be done; the eager/lazy load thing is meant to be as transparent as possible from

[Sqlalchemy-users] mapper.select and limit=

Hi everybody, in the script reported below mapper.select will fail in presence of 'limit' parameter if the condition is given as literal rather than with column object and the mapper is a join: ret = m.select(cities.c.city_name == 'Rome' , limit=10) #ret = m.select("city_name = 'Rome'" , li