Re: [Sqlalchemy-users] select using predefined relationships

2006-05-04 Thread Michael Bayer
select_by should be able to handle going as deep as it goes. You cant put a > in there since select_by is just taking python keyword arguments. We also cant use select(), since that expects the full criterion, i.e. its the generalized case that lets you do anything. so right off thats an

[Sqlalchemy-users] select using predefined relationships

2006-05-04 Thread Randall Smith
One feature that caught my attention when I first started using sqlalchemy was this example: l = User.mapper.select_by(street='123 Green Street') This is in the section entitled 'Useful Feature: Creating Joins via select_by' and it touches on something I think is severely needed. If you're g