${totalBooks}

Books Tracked

${belowTarget}

At / Below Target

${lastCheck ? new Date(lastCheck + \"Z\").toLocaleString(\"en-US\", { dateStyle: \"medium\", timeStyle: \"short\" }) : \"Never\"}

Last Price Check

`;\n\n const cards = books.map((b) => {\n const safeTitle = escapeHtml(b.title);\n const safeIsbn = escapeHtml(b.isbn);\n\n let badgeClass: string;\n let badgeText: string;\n if (b.latestPrice === null) {\n badgeClass = \"badge-gray\";\n badgeText = \"No data\";\n } else if (b.latestPrice <= b.price_threshold) {\n badgeClass = \"badge-green\";\n badgeText = \"Below target\";\n } else {\n badgeClass = \"badge-red\";\n badgeText = \"Above target\";\n }\n\n const priceDisplay = b.latestPrice !== null ? `$${b.latestPrice.toFixed(2)}` : \"—\";\n\n const historyRows = b.history.slice(-10).map((h) => {\n const d = new Date(h.checked_at + \"Z\");\n const dateStr = d.toLocaleDateString(\"en-US\", { month: \"short\", day: \"numeric\" });\n const priceClass = h.price <= b.price_threshold ? \"price-good\" : \"price-high\";\n return `$${h.price.toFixed(2)} ${dateStr}`;\n }).join(\"\");\n\n const bookfinderUrl = `https://www.bookfinder.com/search/?isbn=${encodeURIComponent(b.isbn)}&mode=isbn&st=sr&ac=qr`;\n\n return `\n

${safeTitle}

\n ISBN: ${safeIsbn}\n

\n ${badgeText}\n

Latest Price

${priceDisplay}

Target

$${b.price_threshold.toFixed(2)}

\n ${b.history.length > 0 ? `

Recent Prices

${historyRows}

` : \"\"}\n

\n Search BookFinder\n \n

`;\n }).join(\"\");\n\n return `\n\n\n \n \n Book Price Tracker\n \n\n\n

Book Price Tracker

\n ${summaryBar}\n ${books.length > 0 ? cards : '

No books tracked yet. Add one below.

'}\n

Add a Book

\n \n

\n \n\n`;\n}\n\nexport default async function(req: Request): Promise {\n await ensureBooksTable();\n\n const url = new URL(req.url);\n const path = url.pathname;\n\n // GET / — Dashboard\n if (req.method === \"GET\" && (path === \"/\" || path === \"\")) {\n const booksResult = await sqlite.execute(`SELECT isbn, title, price_threshold FROM books`);\n const books = booksResult.rows as unknown as Book[];\n\n const historyResult = await sqlite.execute(\n `SELECT isbn, price, checked_at FROM price_history ORDER BY checked_at ASC`,\n );\n const history = historyResult.rows as unknown as PriceRecord[];\n\n const historyByIsbn = new Map();\n for (const h of history) {\n const list = historyByIsbn.get(h.isbn) || [];\n list.push(h);\n historyByIsbn.set(h.isbn, list);\n }\n\n const booksWithHistory: BookWithHistory[] = books.map((b) => {\n const bookHistory = historyByIsbn.get(b.isbn) || [];\n const latest = bookHistory.length > 0 ? bookHistory[bookHistory.length - 1] : null;\n return {\n ...b,\n history: bookHistory,\n latestPrice: latest ? latest.price : null,\n latestDate: latest ? latest.checked_at : null,\n };\n });\n\n const lastCheckRow = await sqlite.execute(\n `SELECT checked_at FROM price_history ORDER BY checked_at DESC LIMIT 1`,\n );\n const lastCheck = lastCheckRow.rows.length > 0\n ? (lastCheckRow.rows[0] as unknown as { checked_at: string }).checked_at\n : null;\n\n return new Response(html(booksWithHistory, lastCheck), {\n headers: { \"Content-Type\": \"text/html\" },\n });\n }\n\n // GET /api/books\n if (req.method === \"GET\" && path === \"/api/books\") {\n const books = await getBooks();\n return Response.json(books);\n }\n\n // GET /api/price-history\n if (req.method === \"GET\" && path === \"/api/price-history\") {\n const result = await sqlite.execute(\n `SELECT ph.isbn, b.title, ph.price, ph.checked_at\n FROM price_history ph\n LEFT JOIN books b ON b.isbn = ph.isbn\n ORDER BY ph.isbn, ph.checked_at ASC`,\n );\n const rows = result.rows as unknown as { isbn: string; title: string; price: number; checked_at: string }[];\n\n const grouped: Record = {};\n for (const r of rows) {\n if (!grouped[r.isbn]) {\n grouped[r.isbn] = { title: r.title, history: [] };\n }\n grouped[r.isbn].history.push({ price: r.price, checked_at: r.checked_at });\n }\n\n return Response.json(grouped);\n }\n\n // POST /api/books\n if (req.method === \"POST\" && path === \"/api/books\") {\n const { isbn, title, priceThreshold } = await req.json();\n if (!isbn || !title || priceThreshold == null) {\n return Response.json({ error: \"isbn, title, and priceThreshold are required\" }, { status: 400 });\n }\n await sqlite.execute({\n sql: `INSERT OR REPLACE INTO books (isbn, title, price_threshold) VALUES (?, ?, ?)`,\n args: [isbn, title, priceThreshold],\n });\n return Response.json({ ok: true });\n }\n\n // DELETE /api/books/:isbn\n if (req.method === \"DELETE\" && path.startsWith(\"/api/books/\")) {\n const isbn = decodeURIComponent(path.slice(\"/api/books/\".length));\n await sqlite.execute({\n sql: `DELETE FROM books WHERE isbn = ?`,\n args: [isbn],\n });\n return Response.json({ ok: true });\n }\n\n return Response.json({ error: \"Not found\" }, { status: 404 });\n}\n","deleted","label",[100],"permalink","https://www.val.town/x/dubin/used_book_price_check/code/ui.http.ts","extension","actionData","errors"]