Function getNotes

packages/core/src/db/note-queries.ts:12–40

(bookId: string)

} from "./db-core";

export async function getNotes(bookId: string): 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 WHERE book_id = ? ORDER BY created_at DESC", [bookId]);
  return sortAnnotationsByPosition(
    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,
    })),
  );
}

/** Get all notes across all books (for general chat without bookId) */
export async function getAllNotes(limit = 50): Promise<Note[]> {