soft-delete.ais
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
All examples