execute(input) database = service "database_tasks" locked = database.first({ from: "Task (id)", where: { id: input.taskId, deleted: false }, locking: { type: "forUpdate" } }) if locked == null fail NotFound "Active task not found" end task = database.first({ from: "Task (id, deleted)", where: { id: input.taskId } }) // Preserve the stored identity and record; do not physically delete it. task.deleted = true task.save() return { taskId: task.id, deleted: true } end