[sqlalchemy] Re: filter_by() related table columns

2007-12-28 Thread Michael Bayer


On Dec 28, 2007, at 9:01 AM, [EMAIL PROTECTED] wrote:


 theres a certain magical behavior in 0.3 which we've removed in
 filter_by(), which is that when you say description it searches
 downwards through orderstatus to find it.  0.4 wants you to be
 explicit and say
 session
 .query
 (PurchaseOrder
 ).join('orderstatus').filter_by(description='Shipped').all().

 Is there anyway to turn this magic back on in the .4 release or has
 it totally been removed. We have quite a few existing queries that use
 the concept of searching by related table columns and it would be
 quite an undertaking to change all of these. Thanks for you help.

obviously you'll have to migrate your code at some point but I believe  
you can call query._legacy_filter_by(**kwargs) to get the old behavior  
right now.

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---



[sqlalchemy] Re: filter_by() related table columns

2007-12-28 Thread [EMAIL PROTECTED]

 theres a certain magical behavior in 0.3 which we've removed in
 filter_by(), which is that when you say description it searches
 downwards through orderstatus to find it.  0.4 wants you to be
 explicit and say
 session
 .query
 (PurchaseOrder
 ).join('orderstatus').filter_by(description='Shipped').all().

Is there anyway to turn this magic back on in the .4 release or has
it totally been removed. We have quite a few existing queries that use
the concept of searching by related table columns and it would be
quite an undertaking to change all of these. Thanks for you help.

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---