正在处理SQLAlchemy和foreignkey

Question

我正在努力与SQLAlchemy和外键。我不知道为什么我得到这个错误:

sqlalchemy.exc。NoReferencedTableError:与列'('workers'，)关联的外键。Planning_id '找不到表'planning'来生成目标列'id'的外键

下面是我的代码:

class Workers(Base):
__tablename__ = "workers",
id = sqlalchemy.Column(sqlalchemy.Integer, primary_key=True)
uuid = sqlalchemy.Column(sqlalchemy.String(32), default=lambda: str(uuid4))
first_name = sqlalchemy.Column(sqlalchemy.String(500), nullable=True)
last_name = sqlalchemy.Column(sqlalchemy.String(500), nullable=True)
job_uuid = sqlalchemy.Column(sqlalchemy.String(32), default=lambda: str(uuid4), nullable=True)
arrival_date = sqlalchemy.Column(sqlalchemy.DateTime, nullable=True)
updated_at = sqlalchemy.Column(sqlalchemy.DateTime, nullable=False)
created_at = sqlalchemy.Column(sqlalchemy.DateTime, nullable=False)
planning_id = sqlalchemy.Column(sqlalchemy.Integer, ForeignKey("planning.id"))

# Parent
class Planning(Base):
__tablename__ = "planning",
id = sqlalchemy.Column(sqlalchemy.Integer, primary_key=True)
uuid = sqlalchemy.Column(sqlalchemy.String(32), default=lambda: str(uuid4))
day = sqlalchemy.Column(sqlalchemy.Integer)
job_uuid = sqlalchemy.Column(sqlalchemy.String(32), default=lambda: str(uuid4), nullable=True)
worker_uuid = sqlalchemy.Column(sqlalchemy.String(32), default=lambda: str(uuid4))
created_at = sqlalchemy.Column(sqlalchemy.DateTime)
updated_at = sqlalchemy.Column(sqlalchemy.DateTime)
schedule = sqlalchemy.Column(sqlalchemy.JSON)
workers = relationship("Workers", backref="planning")

Answer 1

刚刚找到问题所在。它是表名后面的逗号.