[sqlalchemy] Re: relation join problem

2008-12-04 Thread Dom
Thanks, that works. But now, with the attribute_mapped_collection, every language is queried and assigned to the dict (quite an overhead in my use-case). how could i achieve to load only a selected language which is dynamically assigned on the query? i thought of something like a

[sqlalchemy] Re: relation join problem

2008-12-03 Thread Simon
That would be desc = session.query(I18Product).filter_by(id=1183, lang=en).one() The Problem with your query is that you query() for Product, not for I18NProduct, so regardless of and filter and join functions you specify, you will always receice Product objects. Think of query (Product) as a