将两个关系SQLAlchemy到同一个表

from sqlalchemy import Table, Column, Integer, ForeignKey
from sqlalchemy.orm import relationship
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

# 定义中间表
association_table = Table('association', Base.metadata,
    Column('model1_id', Integer, ForeignKey('model1.id')),
    Column('model2_id', Integer, ForeignKey('model2.id'))
)

# 定义模型1
class Model1(Base):
    __tablename__ = 'model1'
    id = Column(Integer, primary_key=True)
    model2s = relationship("Model2", secondary=association_table, back_populates="model1s")

# 定义模型2
class Model2(Base):
    __tablename__ = 'model2'
    id = Column(Integer, primary_key=True)
    model1s = relationship("Model1", secondary=association_table, back_populates="model2s")