scott wrote:
>
> Is there a way to filter a query involving an association_proxy?
>
> For example, say I have a one to many relation between Pages and Tags,
> and an association_proxy like this to let me represent tags as a list
> of strings.
>
> tag_objects = orm.relation('Tag')
> tags = association_proxy('tag_objects', 'name')
>
> Now I want to find all the pages tagged with 'foo'. As far as I know I
> have to break the abstraction barrier provided by the
> association_proxy and do something like:
>
> sess.query(Page.tag_objects.any(name='foo'))
>
> Is there any mechanism for doing something like this instead?
>
> sess.query(Page.tags.any('foo'))
>
> If there's nothing similar already existing, is this functionality
> desirable? It seems like it could be really useful for clarifying
> complex filtering, especially involving many to many relations with
> association objects. I wrote an example patch implementing this
> for .any() and .has(), with tests. I'm happy to post a ticket and
> flesh it out more if it seems reasonable.
>
> http://web.mit.edu/storborg/Public/better-associationproxy-filtering.patchwe absolutely would want associationproxy to provide the standard comparison functions for free - right now its a do-it-yourself thing. If you want to work on that that would be great ! > > Thanks, > Scott > > > --~--~---------~--~----~------------~-------~--~----~ 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 sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
