As theres a lot of clamor for this lately, FYI to those looking for a
more flexible "select_by". the SelectResults extension can give you
a lot of what youre looking for.
from sqlalchemy.ext.selectresults import SelectResultsExt
addressmapper = mapper(Address, addresstable)
usermapper = mapper(User, usertable, properties=
{'addresses':addressmapper}, ext=SelectResultsExt())
result = usermapper.select_by(address='[EMAIL PROTECTED]').order_by
(addresstable.c.address)[4:15]
will add "LIMIT 4 OFFSET 15 ORDER BY addresses.address" to the
generated query before executing.
-------------------------------------------------------
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
