Method getNotesList

src/durable-objects/user-notes.ts:992–1004

()

        // Public notes (no auth required — used by public page renderer)
        if (request.method === "GET" && path === "/public-notes") {
            const rows = this.sql.exec(
                `SELECT n.id, n.title, n.content, n.published_at, n.created_at, f.name as folder_name
                 FROM notes n LEFT JOIN folders f ON n.folder_id = f.id
                 WHERE n.published = 1 AND n.deleted_at IS NULL ORDER BY n.published_at DESC`
            ).toArray();
            // Derive the title from content when the stored column is stale —
            // the public page and RSS should never show "Untitled" for a note
            // that has real text.
            return Response.json(rows.map((row: any) => ({
                ...row,
                title: (row.title && row.title !== "Untitled") ? row.title : deriveTitleAndPreview(row.content).title || row.title || "Untitled",
            })));
        }

        // --- Media routes ---
        if (request.method === "GET" && path === "/media") {