I am using SA 0.3.11 and I would like to know if there is a way to get
a query object from a relation property. I have several one-to-many
relationships in my application. These are all setup and work very
well, but I find that I often want to perform further filtering of the
objects in the relationship list property. I could write python code
to do it, but if I could get SA to do it on the server, then all the
better.
To be more specific, here is an example from the SA documentation:
mapper(Address, addresses_table)
mapper(User, users_table, properties = {
'addresses' : relation(Address)
}
)
user_fred = session.query(User).filter_by(user_name="fred")
# Is it possible to do something like this?
fred_ny_addresses = getQuery(user_fred.addresses).filter_by(state="NY")
I know that SA 0.4 has support for dynamic_loader properties which
would be fairly similar to this, but I am stuck with 0.3.11 for now.
I think what I want is also a bit different then a dynamic_loader
because 95% of the time I want to use it as a standard relation
property and the performance is not such that I am worried about
loading the entire list of Address entities. All I want is a shortcut
for creating a query object with the same settings as those used for
the query used to create the list for the relation property.
Is this possible in any way?
Thanks,
Allen
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---
