Function insertNote

packages/core/src/db/note-queries.ts:71–92

(note: Note)

}

export async function insertNote(note: Note): Promise<void> {
  const database = await getDB();
  const deviceId = await getDeviceId();
  const syncVersion = await nextSyncVersion(database, "notes");
  await database.execute(
    "INSERT INTO notes (id, book_id, highlight_id, cfi, title, content, chapter_title, tags, created_at, updated_at, sync_version, last_modified_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
    [
      note.id,
      note.bookId,
      note.highlightId || null,
      note.cfi || null,
      note.title,
      note.content,
      note.chapterTitle || null,
      JSON.stringify(note.tags),
      note.createdAt,
      note.updatedAt,
      syncVersion,
      deviceId,
    ],
  );
}

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