CRITICAL7's recent timeline updates CRITICAL7's recent timeline updates |
CRITICAL7V2EX member #245618, joined on 2017-07-30 19:48:03 +08:00 |
 |
Per CRITICAL7's settings, the topics list is hidden |
Deals info, including closed deals, is not hidden
CRITICAL7's recent replies
Jun 3, 2020 Replied to a topic by 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