Function getAllNotes

packages/core/src/db/note-queries.ts:43–69

(limit = 50)

/** Get all notes across all books (for general chat without bookId) */
export async function getAllNotes(limit = 50): Promise<Note[]> {
  const database = await getDB();
  const rows = await database.select<{
    id: string;
    book_id: string;
    highlight_id: string | null;
    cfi: string | null;
    title: string;
    content: string;
    chapter_title: string | null;
    tags: string;
    created_at: number;
    updated_at: number;
  }>("SELECT * FROM notes ORDER BY created_at DESC LIMIT ?", [limit]);
  return rows.map((r) => ({
    id: r.id,
    bookId: r.book_id,
    highlightId: r.highlight_id || undefined,
    cfi: r.cfi || undefined,
    title: r.title,
    content: r.content,
    chapterTitle: r.chapter_title || undefined,
    tags: parseJSON(r.tags, []),
    createdAt: r.created_at,
    updatedAt: r.updated_at,
  }));
}

export async function insertNote(note: Note): Promise<void> {
  const database = await getDB();