我正在尝试为我的使用SQLAlchemy开发的项目之一实施林管理。 我已经按照以下结构定义了模型:
SupplierCategory = sqlalchemy.Table(
‘supplier_category’, Base.metadata,
Column(‘supplier_id’, UUID(as_uuid=True), sqlalchemy.ForeignKey(‘supplier.id’)),
Column(‘category_id’, UUID(as_uuid=True), sqlalchemy.ForeignKey(‘category.id’))
)
class Supplier(Base):
id = Column(UUID(as_uuid=True), primary_key=True, unique=True, default=uuid4, server_default=text(‘uuid_generate_v4()’))
name = Column(String)
categories = relationship(“Category”, secondary=SupplierCategory, back_populates=“suppliers”)
class Category(Base):
id = Column(UUID(as_uuid=True), primary_key=True, unique=True, default=uuid4, server_default=text(‘uuid_generate_v4()’))
name = Column(String)
suppliers = relationship(