1 回答
TA貢獻1804條經驗 獲得超8個贊
根據官方網站,我是這樣實現的。
class Trends(Base):
? ? __tablename__ = "trends"
? ? __table_args__ = (
? ? ? ? UniqueConstraint(
? ? ? ? ? ? "name", "id_region", "language_iso", name="name_id_region_language"
? ? ? ? ),
? ? )
? ? id = Column(Integer, primary_key=True, index=True, unique=True)
? ? .
? ? .
? ? .
? ? # closest_trends = relationship("ClosestTrends", backref="Trends")
? ?
? ? def __str__(self):
? ? ? ? return "Trends"
class ClosestTrends(Base):
? ? __tablename__ = "closest_trends"
? ? __table_args__ = (
? ? ? ? UniqueConstraint(
? ? ? ? ? ? "id_trend_ref", "id_trend_close", name="id_trend_ref_id_trend_close"
? ? ? ? ),
? ? )
? ? id = Column(Integer, primary_key=True, index=True, unique=True)
? ? .
? ? .
? ? .
? ??
? ? id_trend_ref = Column(
? ? ? ? Integer, ForeignKey("trends.id", ondelete="CASCADE"), nullable=False
? ? )
? ? id_trend_close = Column(
? ? ? ? Integer, ForeignKey("trends.id", ondelete="CASCADE"), nullable=False
? ? )
? ??
? ? trend_ref = relationship("Trends", foreign_keys=[id_trend_ref])
? ? trend_close = relationship("Trends", foreign_keys=[id_trend_close])
? ? def __str__(self):
添加回答
舉報
