>From the example here:

  http://www.sqlalchemy.org/docs/04/documentation.html#datamapping_manytomany

How can i construct a query that will return the keywords for posts
from
a particular user?

I'd expect this to work:

  session.query(Keyword).join(BlogPost.keywords) \
    .filter(BlogPost.author == wendy).all()

and it does with 0.5, but not with 0.4.7p1 :(

I can make this work by adding a backref on the keywords relation and
joining against it, but in "real life" (ie. my application) I'd like
to avoid this given the number of tables that link to it.

Any ideas?

Test code is here: http://paste.pocoo.org/show/85495/.


--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to