I have a question about the Association Pattern
http://docs.sqlalchemy.org/en/latest/orm/relationships.html#association-object
I have a structure as such:
useraccount
group
useraccount_2_group ( useraccount_id , group_id , metadata like
relation type / date / etc )
Is it possible to query the Groups based on the association ?
For example, in a webapp I have the useraccount_id from the session.
I don't want to load the useraccount object , i might just want the
groups...
"""SELECT
g.*
FROM
useraccount_2_group u2g
LEFT JOIN group g ON ( u2g.group_id = group.id )
WHERE
u2g.useraccount_id = :useraccount_id"""
I guess I'm wondering if its possible to do:
dbSession.query( Group ).filter_or_join_or_whatever()
Similarly, I might want to access the 'relationship' as well. From
the docs, I don't understand if it would make more sense to load the
Relationship and then eagerly pull in the Group -- or to use a join
and grab a tuple [
http://docs.sqlalchemy.org/en/latest/orm/tutorial.html#selecting-entities-from-subqueries
]. Does anyone have a preference for a reason ?
--
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.
