Hi All.
Is there any way to transparently add the properties of the associated
object to the association proxy?
For e.g. if I have the following setup
class UserModel(Base):
name = sa.Column(sa.String(512))
orgs = association_proxy('org_member', 'org')
class OrgModel(Base):
name = sa.Column(sa.String(256), unique=True)
class OrgMemberModel(Base):
__tablename__ = 'org_member'
user_id = sa.Column(sa.Integer, sa.ForeignKey('user.id'),
primary_key=True)
org_id = sa.Column(sa.Integer, sa.ForeignKey('org.id'),
primary_key=True)
active = sa.Column(sa.Boolean, nullable=False, default=True)
role = sa.Column(sa.String(64), nullable=False, default='member')
user = relationship('UserModel', backref=backref('org_membership',
cascade='all, delete-orphan'))
org = relationship('OrgModel')
What I would like to be able to do is access the properties of the OrgModel
& OrgMemberModel via the org_membership[i] object.
Currently I have to do the following:
user.org_membership[0].organization.name
user.org_membership[0].role
Ideally I would like to be able to do:
user.org_membership[0].name
user.org_membership[0].role
Any help would be greatly appreciated.
Thanks.
AM
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/groups/opt_out.
