the simple answer is yes, just handwire it. there is a desire for a generator to be stuck on relations the way SQLObject does it, so that x.y[3:5] would set up LIMIT and OFFSET appropriate to the criterion. this would only work with lazy loading. im not really sure if that paricular interface is workable, since once a lazy loader executes, its done. im sure people would want to call the thing over and over again. it would in fact be a pretty involved addition in the case of relations. but it may be worth it.
i would very much appreciate it the community could determine what they really want to see with this idea and create a ticket for it (and contribute patches if possible). Florian Boesch wrote: > With 1:m or n:m relationships served up by a relation property on a > mapper, is > there any way not selecting everything that relates, but with a > limit/offset. > > For example. mytable.somerelation[offset:offset+x]. > > I guess not, I've seen this beeing mentioned here I think. So what's right > now > my best option to do that, handwiring the property that does this? > > > > > ------------------------------------------------------- > This SF.Net email is sponsored by xPML, a groundbreaking scripting > language > that extends applications into web and mobile media. Attend the live > webcast > and join the prime developer group breaking into this new coding > territory! > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 > _______________________________________________ > Sqlalchemy-users mailing list > Sqlalchemy-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users > ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
