On Mon, May 08, 2006 at 11:30:54AM -0400, Michael Bayer wrote:
> you mean you want this:
>
> m = mapper(SomeClass, mytable)
> result = m.select_by(someothertable.c.something>45)
>
> which will automatically create a JOIN from 'mytable' to
> 'someothertable'.
no I was rather thinking at what is provided by select_by: ie: an implicit
join on the tables.
If I use select_by, I cannot use limit= and parameters= so I tried to use
select but I see all the time I need to specify the join condition that I
already put into the mapper (via properties = relation(...)).
So I wander:
1. why the implicit behaviour of select_by (ie: join) isn't the default
of a mapper that was already prepared to be a join? As I told in a
prevuous message and if I undertsand it correctly this leads to a CROSS
JOIN that is probably not what anybody looks for...
2. alternatively: why can't I use limit= and parameters= for select_by?
Thanks again...
*:-)
-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
