SQLAlchemy：我无法从表中删除记录-违反not-null约束

Question

如果添加“relationship”，则会出现以下错误：

(Psycopg2.integrityError）列\“robot_id\”中的null值违反了not-null约束\n详细信息：失败的行包含（25,p-svwd5sx_cjxuydm41ohhcwkxycsog33vmrtxbbvi,null）

class Robot(Base, SQLTableJsonEncoder):
    __tablename__ = 'robots'

    id = sa.Column(sa.Integer, primary_key=True)
    name = sa.Column(sa.String, nullable=False)
    hmac_secret = sa.Column(sa.String, nullable=False)
    user_id = sa.Column(sa.String, sa.ForeignKey('users.public_id', ondelete='CASCADE'))
    api_key = relationship('ApiKey', uselist=False)

class ApiKey(Base):
    __tablename__ = 'api_keys'

    id = sa.Column(sa.Integer, primary_key=True)
    key = sa.Column(sa.String, nullable=False)
    robot_id = sa.Column(sa.Integer, sa.ForeignKey('robots.id', ondelete='CASCADE'))

服务：

    async def delete_robot(self, user, robot_id):
        robot = super().get_first(mapped=Robot, user_id=user.public_id, id=robot_id)
        if not robot:
            raise NotFound(payload='Check your robot id')
        super().delete(robot)

        return robot.id

Answer 1

我的情况的解决方案：在'relationship'中添加设置'cascade':

class Robot(Base, SQLTableJsonEncoder):
    __tablename__ = 'robots'

    id = sa.Column(sa.Integer, primary_key=True)
    name = sa.Column(sa.String, nullable=False)
    hmac_secret = sa.Column(sa.String, nullable=False)
    user_id = sa.Column(sa.String, sa.ForeignKey('users.public_id', ondelete='CASCADE'))
    api_key = relationship('ApiKey', uselist=False, cascade='delete')