Perfect. Thanks! On Oct 6, 10:23 am, Vince Spicer <[email protected]> wrote: > On Tue, Oct 5, 2010 at 2:20 PM, pk1024 <[email protected]> wrote: > > I have two classes in my model. One is the definition for ledger > > accounts the other for account posting groups. > > > So for example I have 100 accounts defined in the "Accounts" class. > > > Now in my PostingCode class I have a couple fields that are trying to > > all relate to different accounts in the account class. > > > accounts_receivable_id = > > Column(Integer,ForeignKey('gl_account.account_id')) > > accounts_receivable = relation(Account) > > deposits_id = Column(Integer,ForeignKey('gl_account.account_id')) > > deposits = relation(Account) > > > I understand why this doesn't work but I don't understand how to do > > what I am trying to do or even what I would google for. > > > TIA, > > Paul > > > -- > > You received this message because you are subscribed to the Google Groups > > "TurboGears" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > > [email protected]<turbogears%[email protected]> > > . > > For more options, visit this group at > >http://groups.google.com/group/turbogears?hl=en. > > You can tell SQLAlchemy more information about the join, most times > 'primaryjoin' is enough. > More > info:http://www.sqlalchemy.org/docs/reference/orm/mapping.html?highlight=r... > > Example: > accounts_receivable_id = Column(Integer,ForeignKey('gl_account.account_id')) > accounts_receivable = relation(Account, > primaryjoin=accounts_receivable_id==Account.account_id) > deposits_id = Column(Integer,ForeignKey('gl_account.account_id')) > deposits = relation(Account, primaryjoin=deposits_id==Account.account_id) > > Hope that helps, > > -- > Vince Spicer > Lead Developer - MCE Computing > > -- > Sent from Ubuntu
-- You received this message because you are subscribed to the Google Groups "TurboGears" 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/turbogears?hl=en.
