On Aug 2, 2013, at 2:32 PM, Ams Fwd <ams....@gmail.com> wrote:
> 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.on UserModel you'd have an association proxy from "org_membership" to "org". Not sure what "org_member" is.
signature.asc
Description: Message signed with OpenPGP using GPGMail
