Method updateTask

packages/memos-core/src/storage/sqlite.ts:1635–1648

(taskId: string, fields: { title?: string; summary?: string; status?: TaskStatus; endedAt?: number })

  }

  updateTask(taskId: string, fields: { title?: string; summary?: string; status?: TaskStatus; endedAt?: number }): boolean {
    const sets: string[] = [];
    const params: unknown[] = [];
    if (fields.title !== undefined) { sets.push("title = ?"); params.push(fields.title); }
    if (fields.summary !== undefined) { sets.push("summary = ?"); params.push(fields.summary); }
    if (fields.status !== undefined) { sets.push("status = ?"); params.push(fields.status); }
    if (fields.endedAt !== undefined) { sets.push("ended_at = ?"); params.push(fields.endedAt); }
    if (sets.length === 0) return false;
    sets.push("updated_at = ?");
    params.push(Date.now());
    params.push(taskId);
    const result = this.db.prepare(`UPDATE tasks SET ${sets.join(", ")} WHERE id = ?`).run(...params);
    return result.changes > 0;
  }

  getChunksByTask(taskId: string): Chunk[] {
    const rows = this.db.prepare("SELECT * FROM chunks WHERE task_id = ? ORDER BY created_at, seq").all(taskId) as ChunkRow[];