Function updateNote

packages/core/src/db/note-queries.ts:94–125

(id: string, updates: Partial<Note>)

}

export async function updateNote(id: string, updates: Partial<Note>): Promise<void> {
  const database = await getDB();
  const sets: string[] = [];
  const values: unknown[] = [];

  if (updates.title !== undefined) {
    sets.push("title = ?");
    values.push(updates.title);
  }
  if (updates.content !== undefined) {
    sets.push("content = ?");
    values.push(updates.content);
  }
  if (updates.tags !== undefined) {
    sets.push("tags = ?");
    values.push(JSON.stringify(updates.tags));
  }
  // Add sync tracking
  const deviceId = await getDeviceId();
  const syncVersion = await nextSyncVersion(database, "notes");
  const updatedAt = await nextUpdatedAt(database, "notes", id);
  sets.push("updated_at = ?");
  values.push(updatedAt);
  sets.push("sync_version = ?");
  values.push(syncVersion);
  sets.push("last_modified_by = ?");
  values.push(deviceId);

  if (sets.length === 0) return;
  values.push(id);
  await database.execute(`UPDATE notes SET ${sets.join(", ")} WHERE id = ?`, values);
}

export async function deleteNote(id: string): Promise<void> {
  const database = await getDB();