Question

有一个 sqlalchey 对象

class Employee(Base):
    __tablename__ = "employee"
    # Columns
    id = Column(Integer, primary_key=True, autoincrement=True)
    representative_id = Column(Integer, ForeignKey( employee.id ))
    parent_id = Column(Integer, ForeignKey( employee.id ))
    affiliate_id = Column(Integer, ForeignKey( employee.id ))

    # Relatonships
    representative = relationship("Employee", ????)
    parent = relationship("Employee", ????)
    affiliate = relationship("Employee", ????)

如果雇员能够拥有0或1个家长、子公司和代表,如何正确配置关系?知道这三种关系是不同的关系吗? DB - MySQL

Answer 1

我发现自己是如何做到的:

class Employee(Base):
    __tablename__ = "employee"
    # Columns
    id = Column(Integer, primary_key=True, autoincrement=True)
    representative_id = Column(Integer, ForeignKey( employee.id ))
    parent_id = Column(Integer, ForeignKey( employee.id ))
    affiliate_id = Column(Integer, ForeignKey( employee.id ))

    # Relatonships
    representative = relationship("Employee", 
                         primaryjoin="Employee.representative_id==Employee.id", 
                         remote_side=[id])
    parent = relationship("Employee",
                         primaryjoin="Employee.parent_id==Employee.id", 
                         remote_side=[id])
    affiliate = relationship("Employee",
                         primaryjoin="Employee.affiliate_id==Employee.id", 
                         remote_side=[id])

友情链接