Function claimProposedTask

notfair-cmo/src/server/db/tasks.ts:232–242

(id: string)

 * read-back here cannot race with a concurrent writer in this process.
 */
export function claimProposedTask(id: string): Task | null {
  const db = getDb();
  const now = new Date().toISOString();
  const info = db
    .prepare(
      "UPDATE tasks SET status = 'working', updated_at = ? WHERE id = ? AND status = 'proposed'",
    )
    .run(now, id);
  if (info.changes === 0) return null;
  return getTask(id);
}

/**
 * Flip a working task to `blocked` (waiting on an approval). Only transitions