Hey Sandro, Just to make sure, but you're not looking for something like this, are you? Specifically the mapping against an arbitrary select bit towards the end?
http://www.sqlalchemy.org/trac/wiki/UsageRecipes/OuterLeftJoin Cheers, -G On Monday, May 8, 2006, 7:27:01 PM, you wrote: > 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 ------------------------------------------------------- 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
