class Dealer(Base):
__tablename__ = 'dealers'
id_ = Column(Integer, primary_key=True)
reps = relationship('Rep', order_by='Rep.lname', backref="dealer")
banks = relationship('Bank', order_by='Bank.id_', backref="dealer")
class Bank(Base):
__tablename__ = 'banks'
id_ = Column(Integer, primary_key=True)
dealer_id = Column(Integer, ForeignKey('dealers.id_'))
dealer = relationship(Dealer, backref=backref('banks', order_by=id_))
class Rep(Base):
__tablename__ = 'reps'
id_ = Column(Integer, primary_key=True)
dealer_id = Column(Integer, ForeignKey('dealers.id_'))
dealer = relationship(Dealer, backref=backref('reps', order_by=id_))
I'm attempting to do this exactly like:
http://www.sqlalchemy.org/docs/ormtutorial.html#building-a-relationship
But when I run it it gives:
sqlalchemy.exc.ArgumentError: Error creating backref 'dealer' on
relationship 'Dealer.reps': property of that name exists on mapper
'Mapper|Rep|reps'
Any help?
Thanks,
Michael
I think I figured it out, it's not necessary to put the backref on both ends.
Michael