CRITICAL7 最近的时间轴更新 CRITICAL7 最近的时间轴更新 |
CRITICAL7V2EX 第 245618 号会员，加入于 2017-07-30 19:48:03 +08:00 |
CRITICAL7 最近回复了
2020-06-03 01:31:19 +08:00 回复了 LennonChin 创建的主题 › Python › 请问， SQLAlchemy 无外键约束的多对多关系模型该怎么写啊？ |
emm 就是这么写吧大概。。官网 tutorial 改了改
```
class User(Base):
id = Column(Integer, primary_key=True)
class UserAddress(Base):
id = Column(Integer, primary_key=True)
user_id = Column(Integer)
address_id = Column(Integer)
user = relationship("User", primaryjoin="foreign(UserAddress.user_id) == User.id")
address = relationship("Address", primaryjoin="foreign(UserAddress.address_id) == Address.id")
class Address(Base):
id = Column(Integer, primary_key=True)
```
```
class User(Base):
id = Column(Integer, primary_key=True)
class UserAddress(Base):
id = Column(Integer, primary_key=True)
user_id = Column(Integer)
address_id = Column(Integer)
user = relationship("User", primaryjoin="foreign(UserAddress.user_id) == User.id")
address = relationship("Address", primaryjoin="foreign(UserAddress.address_id) == Address.id")
class Address(Base):
id = Column(Integer, primary_key=True)
```
Select Language