[sqlalchemy] Re: in not implemented for queries?

2008-05-21 Thread az
what u want to accomplish? looks like u need one of the .any(..) or .has(..), check those also. or do u need a plain join? On Wednesday 21 May 2008 07:50, andrew cooke wrote: Hi, Just wanted to check: I am seeing a NotImplementedError (v 0.4.6 on Linux w Python 2.5) when I try to query some

[sqlalchemy] Re: in not implemented for queries?

2008-05-21 Thread andrew cooke
On May 21, 2:04 am, [EMAIL PROTECTED] wrote: what u want to accomplish? Well, it's the equivalent of the SQL IN. So i want to retrieve all Measurements which are associated with with a Time Series in the given list. The SQL equivalent would be something like: SELECT * from Measurement as M

[sqlalchemy] Re: in not implemented for queries?

2008-05-21 Thread Michael Bayer
On May 21, 2008, at 12:50 AM, andrew cooke wrote: Hi, Just wanted to check: I am seeing a NotImplementedError (v 0.4.6 on Linux w Python 2.5) when I try to query some objects with the filter in. Does that mean that the feature is not implemented, or is it more likely an error in my

[sqlalchemy] Re: in not implemented for queries?

2008-05-21 Thread andrew cooke
On May 21, 9:37 am, Michael Bayer [EMAIL PROTECTED] wrote: in_ is supported for column-based attributes. If you are getting NotImplemented, that's beacuse time_series is referencing either a collection or a many-to-one object reference. so SQL IN wouldn't work here.For the many-to-one