Hi

\"\n});\n```\n\n## Val Town Utility Functions\n\nVal Town provides several utility functions to help with common project tasks.\n\n### Importing Utilities\n\nAlways import utilities with version pins to avoid breaking changes:\n\n```ts\nimport { parseProject, readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n```\n\n### Available Utilities\n\n\n#### **serveFile** - Serve project files with proper content types\n\nFor example, in Hono:\n\n```ts\n// serve all files in frontend/ and shared/\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n```\n\n#### **readFile** - Read files from within the project:\n\n```ts\n// Read a file from the project\nconst fileContent = await readFile(\"/frontend/index.html\", import.meta.url);\n```\n\n#### **listFiles** - List all files in the project\n\n```ts\nconst files = await listFiles(import.meta.url);\n```\n\n#### **parseProject** - Extract information about the current project from import.meta.url\n\nThis is useful for including info for linking back to a val, ie in \"view source\" urls:\n\n```ts\nconst projectVal = parseProject(import.meta.url);\nconsole.log(projectVal.username); // Owner of the project\nconsole.log(projectVal.name); // Project name\nconsole.log(projectVal.version); // Version number\nconsole.log(projectVal.branch); // Branch name\nconsole.log(projectVal.links.self.project); // URL to the project page\n```\n\nHowever, it's *extremely importing* to note that `parseProject` and other Standard Library utilities ONLY RUN ON THE SERVER.\nIf you need access to this data on the client, run it in the server and pass it to the client by splicing it into the HTML page\nor by making an API request for it.\n\n## Val Town Platform Specifics\n\n- **Redirects:** Use `return new Response(null, { status: 302, headers: { Location: \"/place/to/redirect\" }})` instead of `Response.redirect` which is broken\n- **Images:** Avoid external images or base64 images. Use emojis, unicode symbols, or icon fonts/libraries instead\n- **AI Image:** To inline generate an AI image use: `

`\n- **Storage:** DO NOT use the Deno KV module for storage\n- **Browser APIs:** DO NOT use the `alert()`, `prompt()`, or `confirm()` methods\n- **Weather Data:** Use open-meteo for weather data (doesn't require API keys) unless otherwise specified\n- **View Source:** Add a view source link by importing & using `import.meta.url.replace(\"ems.sh\", \"val.town)\"` (or passing this data to the client) and include `target=\"_top\"` attribute\n- **Error Debugging:** Add `` to HTML to capture client-side errors\n- **Error Handling:** Only use try...catch when there's a clear local resolution; Avoid catches that merely log or return 500s. Let errors bubble up with full context\n- **Environment Variables:** Use `Deno.env.get('keyname')` when you need to, but generally prefer APIs that don't require keys\n- **Imports:** Use `https://esm.sh` for npm and Deno dependencies to ensure compatibility on server and browser\n- **Storage Strategy:** Only use backend storage if explicitly required; prefer simple static client-side sites\n- **React Configuration:** When using React libraries, pin versions with `?deps=react@18.2.0,react-dom@18.2.0` and start the file with `/** @jsxImportSource https://esm.sh/react@18.2.0 */`\n- Ensure all React dependencies and sub-dependencies are pinned to the same version\n- **Styling:** Default to using TailwindCSS via `` unless otherwise specified\n\n## Project Structure and Design Patterns\n\n### Recommended Directory Structure\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Schema definitions\n│ │ ├── queries.ts # DB query functions\n│ │ └── README.md\n│ └── routes/ # Route modules\n│ ├── [route].ts\n│ └── static.ts # Static file serving\n│ ├── index.ts # Main entry point\n│ └── README.md\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx\n│ │ └── [Component].tsx\n│ ├── favicon.svg\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # Frontend JS entry point\n│ ├── README.md\n│ └── style.css\n├── README.md\n└── shared/\n ├── README.md\n └── utils.ts # Shared types and functions\n```\n\n### Backend (Hono) Best Practices\n\n- Hono is the recommended API framework\n- Main entry point should be `backend/index.ts`\n- **Static asset serving:** Use the utility functions to read and serve project files:\n ```ts\n import { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n \n // serve all files in frontend/ and shared/\n app.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\n app.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n \n // For index.html, often you'll want to bootstrap with initial data\n app.get(\"/\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject data to avoid extra round-trips\n const initialData = await fetchInitialData();\n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n });\n ```\n- Create RESTful API routes for CRUD operations\n- Always include this snippet at the top-level Hono app to re-throwing errors to see full stack traces:\n ```ts\n // Unwrap Hono errors to see original error details\n app.onError((err, c) => {\n throw err;\n });\n ```\n\n### Database Patterns\n- Run migrations on startup or comment out for performance\n- Change table names when modifying schemas rather than altering\n- Export clear query functions with proper TypeScript typing\n\n## Common Gotchas and Solutions\n\n1. **Environment Limitations:** \n - Val Town runs on Deno in a serverless context, not Node.js\n - Code in `shared/` must work in both frontend and backend environments\n - Cannot use `Deno` keyword in shared code\n - Use `https://esm.sh` for imports that work in both environments\n\n2. **SQLite Peculiarities:**\n - Limited support for ALTER TABLE operations\n - Create new tables with updated schemas and copy data when needed\n - Always run table creation before querying\n\n3. **React Configuration:**\n - All React dependencies must be pinned to 18.2.0\n - Always include `@jsxImportSource https://esm.sh/react@18.2.0` at the top of React files\n - Rendering issues often come from mismatched React versions\n\n4. **File Handling:**\n - Val Town only supports text files, not binary\n - Use the provided utilities to read files across branches and forks\n - For files in the project, use `readFile` helpers\n\n5. **API Design:**\n - `fetch` handler is the entry point for HTTP vals\n - Run the Hono app with `export default app.fetch // This is the entry point for HTTP vals`\n\n",[],[172],{"_103":180,"_95":181,"_152":182,"_154":-5,"_155":137,"_156":183,"_158":159,"_105":184,"_100":185,"_161":186,"_163":187,"_165":22,"_166":-5,"_167":188,"_98":189},"4fd8a62a-b8cf-11f0-a304-0224a6c84d84","api.ts","a44b9da8-b8ce-11f0-a09c-0224a6c84d84",104,["D",1762186098568],1,"script","import { Context } from \"https://esm.sh/hono\";\nimport {\n getAllNotes,\n getNoteById,\n createNote,\n updateNote,\n deleteNote,\n searchNotes,\n getNotesByTag,\n getNoteTags,\n} from \"./notes.ts\";\nimport {\n getAllTodos,\n getTodoById,\n createTodo,\n updateTodo,\n toggleTodo,\n deleteTodo,\n getTodosByTag,\n getTodoTags,\n} from \"./todos.ts\";\nimport {\n getAllBookmarks,\n getBookmarkByUrl,\n createOrUpdateBookmark,\n deleteBookmark,\n} from \"./bookmarks.ts\";\nimport {\n getAllComics,\n getComicByNumber,\n markComicAsRead,\n refreshComicsFromArchive,\n} from \"./dinocomics.ts\";\n\n// Notes API endpoints\n\nexport async function apiGetNotes(c: Context) {\n const notes = await getAllNotes();\n\n // Get tags for each note\n const notesWithTags = await Promise.all(\n notes.map(async (note) => {\n const tags = await getNoteTags(note.id);\n return {\n id: note.id,\n content: note.content,\n created_at: note.created_at,\n tags: tags\n };\n })\n );\n\n return c.json({ notes: notesWithTags });\n}\n\nexport async function apiCreateNote(c: Context) {\n const body = await c.req.json();\n const { content, tags = [] } = body;\n\n if (!content) {\n return c.json({ error: \"Content is required\" }, 400);\n }\n\n const noteId = await createNote(content, tags);\n return c.json({ id: noteId, content, tags }, 201);\n}\n\nexport async function apiGetNote(c: Context) {\n const id = c.req.param(\"id\");\n const note = await getNoteById(id);\n\n if (!note) {\n return c.json({ error: \"Note not found\" }, 404);\n }\n\n const tags = await getNoteTags(note.id);\n return c.json({\n id: note.id,\n content: note.content,\n created_at: note.created_at,\n tags: tags\n });\n}\n\nexport async function apiUpdateNote(c: Context) {\n const id = c.req.param(\"id\");\n const body = await c.req.json();\n const { content, tags = [] } = body;\n\n if (!content) {\n return c.json({ error: \"Content is required\" }, 400);\n }\n\n await updateNote(id, content, tags);\n return c.json({ id, content, tags });\n}\n\nexport async function apiDeleteNote(c: Context) {\n const id = c.req.param(\"id\");\n await deleteNote(id);\n return c.json({ success: true, id });\n}\n\nexport async function apiSearchNotes(c: Context) {\n const query = c.req.query('q') || '';\n\n if (!query.trim()) {\n return c.json({ notes: [] });\n }\n\n const notes = await searchNotes(query);\n\n // Get tags for each note\n const notesWithTags = await Promise.all(\n notes.map(async (note) => {\n const tags = await getNoteTags(note.id);\n return {\n id: note.id,\n content: note.content,\n created_at: note.created_at,\n tags: tags\n };\n })\n );\n\n return c.json({ notes: notesWithTags, query });\n}\n\nexport async function apiGetNotesByTag(c: Context) {\n const tag = c.req.param(\"tag\");\n const notes = await getNotesByTag(tag);\n\n // Get all tags for each note\n const notesWithTags = await Promise.all(\n notes.map(async (note) => {\n const tags = await getNoteTags(note.id);\n return {\n id: note.id,\n content: note.content,\n created_at: note.created_at,\n tags: tags\n };\n })\n );\n\n return c.json({ notes: notesWithTags, tag });\n}\n\n// Todos API endpoints\n\nexport async function apiGetTodos(c: Context) {\n const todos = await getAllTodos();\n\n // Get tags for each todo\n const todosWithTags = await Promise.all(\n todos.map(async (todo) => {\n const tags = await getTodoTags(todo.id);\n return {\n id: todo.id,\n text: todo.text,\n done: todo.done === 1,\n created_at: todo.created_at,\n tags: tags\n };\n })\n );\n\n return c.json({ todos: todosWithTags });\n}\n\nexport async function apiCreateTodos(c: Context) {\n const body = await c.req.json();\n const { todos, tags = [] } = body;\n\n if (!todos || !Array.isArray(todos)) {\n return c.json({ error: \"Todos array is required\" }, 400);\n }\n\n const createdTodos = [];\n\n for (const todoText of todos) {\n if (todoText.trim()) {\n const todoId = await createTodo(todoText.trim(), tags);\n createdTodos.push({ id: todoId, text: todoText.trim(), done: false, tags });\n }\n }\n\n return c.json({ todos: createdTodos }, 201);\n}\n\nexport async function apiGetTodo(c: Context) {\n const id = c.req.param(\"id\");\n const todo = await getTodoById(id);\n\n if (!todo) {\n return c.json({ error: \"Todo not found\" }, 404);\n }\n\n const tags = await getTodoTags(todo.id);\n return c.json({\n id: todo.id,\n text: todo.text,\n done: todo.done === 1,\n created_at: todo.created_at,\n tags: tags\n });\n}\n\nexport async function apiToggleTodo(c: Context) {\n const id = c.req.param(\"id\");\n const todo = await getTodoById(id);\n\n if (!todo) {\n return c.json({ error: \"Todo not found\" }, 404);\n }\n\n await toggleTodo(id);\n const newDone = todo.done === 0 ? 1 : 0;\n return c.json({ id, done: newDone === 1 });\n}\n\nexport async function apiUpdateTodo(c: Context) {\n const id = c.req.param(\"id\");\n const body = await c.req.json();\n const { text, done, tags } = body;\n\n await updateTodo(id, text, done, tags);\n return c.json({ id, text, done, tags });\n}\n\nexport async function apiDeleteTodo(c: Context) {\n const id = c.req.param(\"id\");\n await deleteTodo(id);\n return c.json({ success: true, id });\n}\n\nexport async function apiGetTodosByTag(c: Context) {\n const tag = c.req.param(\"tag\");\n const todos = await getTodosByTag(tag);\n\n // Get all tags for each todo\n const todosWithTags = await Promise.all(\n todos.map(async (todo) => {\n const tags = await getTodoTags(todo.id);\n return {\n id: todo.id,\n text: todo.text,\n done: todo.done === 1,\n created_at: todo.created_at,\n tags: tags\n };\n })\n );\n\n return c.json({ todos: todosWithTags, tag });\n}\n\n// Bookmarks API endpoints\n\nexport async function apiGetBookmarks(c: Context) {\n const page = parseInt(c.req.query(\"page\") || \"1\");\n const limit = parseInt(c.req.query(\"limit\") || \"25\");\n\n const { bookmarks, total, totalPages } = await getAllBookmarks(page, limit);\n\n const bookmarksList = bookmarks.map(row => ({\n url: row.url,\n added: row.added,\n title: row.title,\n summary: row.summary\n }));\n\n return c.json({\n bookmarks: bookmarksList,\n pagination: {\n page,\n limit,\n total,\n totalPages\n }\n });\n}\n\nexport async function apiCreateBookmark(c: Context) {\n const body = await c.req.json();\n const { url, title, summary = \"\" } = body;\n\n if (!url || !title) {\n return c.json({ error: \"URL and title are required\" }, 400);\n }\n\n try {\n const result = await createOrUpdateBookmark(url, title, summary);\n return c.json(result, result.updated ? 200 : 201);\n } catch (error) {\n const message = error instanceof Error ? error.message : \"Unknown error\";\n return c.json({ error: message }, 500);\n }\n}\n\nexport async function apiGetBookmark(c: Context) {\n const url = c.req.query(\"url\");\n\n if (!url) {\n return c.json({ error: \"URL parameter is required\" }, 400);\n }\n\n const bookmark = await getBookmarkByUrl(url);\n\n if (!bookmark) {\n return c.json({ error: \"Bookmark not found\" }, 404);\n }\n\n return c.json({\n url: bookmark.url,\n added: bookmark.added,\n title: bookmark.title,\n summary: bookmark.summary\n });\n}\n\nexport async function apiDeleteBookmark(c: Context) {\n const body = await c.req.json();\n const { url } = body;\n\n if (!url) {\n return c.json({ error: \"URL is required\" }, 400);\n }\n\n try {\n await deleteBookmark(url);\n return c.json({ success: true, url });\n } catch (error) {\n const message = error instanceof Error ? error.message : \"Unknown error\";\n return c.json({ error: message }, 500);\n }\n}\n\n// Dinocomics API endpoints\n\nexport async function apiGetDinocomics(c: Context) {\n const comics = await getAllComics();\n\n const comicsList = comics.map(row => ({\n number: row.number,\n date: row.date,\n title: row.title,\n read: row.read === 1 || row.read === true\n }));\n\n return c.json({ comics: comicsList });\n}\n\nexport async function apiGetDinocomic(c: Context) {\n const number = parseInt(c.req.param(\"number\"));\n\n const comic = await getComicByNumber(number);\n\n if (!comic) {\n return c.json({ error: \"Comic not found\" }, 404);\n }\n\n return c.json({\n number: comic.number,\n date: comic.date,\n title: comic.title,\n read: comic.read === 1 || comic.read === true\n });\n}\n\nexport async function apiMarkComicRead(c: Context) {\n const number = parseInt(c.req.param(\"number\"));\n await markComicAsRead(number);\n return c.json({ success: true, number, read: true });\n}\n\nexport async function apiRefreshDinocomics(c: Context) {\n try {\n const count = await refreshComicsFromArchive();\n return c.json({\n success: true,\n processed: count,\n message: `Processed ${count} comics from Qwantz archive`\n });\n } catch (error) {\n const message = error instanceof Error ? error.message : \"Unknown error\";\n return c.json({ error: message }, 500);\n }\n}\n",[],[181],{"_103":191,"_95":99,"_152":192,"_154":-5,"_155":137,"_156":193,"_158":159,"_105":194,"_100":157,"_161":195,"_163":196,"_165":22,"_166":-5,"_167":197,"_98":198},"4e6258ac-ba5c-11f0-9d8a-0224a6c84d84","bff9a56c-ba5a-11f0-9ca8-0224a6c84d84",242,["D",1762356606318],"interval","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport * as cheerio from \"https://esm.sh/cheerio@1.0.0-rc.12\";\n\nconst TABLE_NAME = \"bookmarks\";\n\n// Extract server component (hostname) from a URL\nfunction getServerComponent(url: string): string {\n try {\n const urlObj = new URL(url);\n return urlObj.hostname;\n } catch (error) {\n return '';\n }\n}\n\n// Search function using DuckDuckGo HTML\nasync function searchDuckDuckGo(query: string, targetServer: string) {\n const url = `https://html.duckduckgo.com/html/?q=${encodeURIComponent(query)}`;\n\n const response = await fetch(url, {\n headers: {\n 'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36'\n }\n });\n\n const html = await response.text();\n const $ = cheerio.load(html);\n\n // Parse all results\n const results = $('.result');\n\n if (results.length === 0) {\n return null;\n }\n\n // Look for a result that matches the target server\n for (let i = 0; i < results.length; i++) {\n const result = results.eq(i);\n const link = result.find('.result__a').attr('href');\n const snippet = result.find('.result__snippet').text().trim();\n\n if (link && snippet) {\n const resultServer = getServerComponent(link);\n if (resultServer === targetServer) {\n return snippet;\n }\n }\n }\n\n // No matching server found\n return null;\n}\n\n// Get bookmarks with blank summaries\nasync function getBookmarksWithoutSummary(limit: number = 3) {\n const result = await sqlite.execute(\n `SELECT url, title FROM ${TABLE_NAME} WHERE summary IS NULL OR summary = '' ORDER BY added DESC LIMIT ?`,\n [limit]\n );\n return result.rows;\n}\n\n// Update bookmark summary (without touching timestamp)\nasync function updateBookmarkSummary(url: string, summary: string) {\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} SET summary = ? WHERE url = ?`,\n [summary, url]\n );\n}\n\n// Main cron function\nexport default async function() {\n console.log(\"Starting bookmark summary update cron...\");\n\n try {\n // Get 3 most recent bookmarks with blank summaries\n const bookmarks = await getBookmarksWithoutSummary(3);\n\n console.log(`Found ${bookmarks.length} bookmarks without summaries`);\n\n for (const bookmark of bookmarks) {\n const url = String(bookmark[0]);\n const title = String(bookmark[1]);\n\n console.log(`Processing bookmark: ${title} - ${url}`);\n\n try {\n // Extract server component from URL\n const serverComponent = getServerComponent(url);\n\n // Search for \"{TITLE} {SERVER}\"\n const query = `${title} ${serverComponent}`;\n console.log(`Searching for: ${query}`);\n\n const snippet = await searchDuckDuckGo(query, serverComponent);\n\n if (snippet) {\n // Update the summary field\n await updateBookmarkSummary(url, snippet);\n console.log(`Updated summary for ${url}: ${snippet.substring(0, 50)}...`);\n } else {\n // No matching result found, set to \"No summary\"\n await updateBookmarkSummary(url, \"No summary\");\n console.log(`No matching search results found for ${url}, set to \"No summary\"`);\n }\n\n // Add a small delay to avoid rate limiting\n await new Promise(resolve => setTimeout(resolve, 2000));\n } catch (error) {\n console.error(`Error processing bookmark ${url}:`, error);\n // Set to \"No summary\" on error\n try {\n await updateBookmarkSummary(url, \"No summary\");\n } catch (updateError) {\n console.error(`Failed to update summary for ${url}:`, updateError);\n }\n }\n }\n\n console.log(\"Bookmark summary update cron completed\");\n } catch (error) {\n console.error(\"Error in bookmark summary cron:\", error);\n }\n}\n",[],[99],{"_103":200,"_95":201,"_152":202,"_154":-5,"_155":137,"_156":203,"_158":159,"_105":204,"_100":205,"_161":186,"_163":206,"_165":22,"_166":-5,"_167":207,"_98":208},"0d386474-ba5d-11f0-9bb8-0224a6c84d84","bookmarks.ts","7816050a-b8c1-11f0-ac5c-0224a6c84d84",248,["D",1762356926487],21,"import { Context } from \"https://esm.sh/hono\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport moment from \"https://esm.sh/moment-timezone@0.5.43\";\nimport Parser from \"npm:rss-parser\";\n\n// Database setup\nconst TABLE_NAME = \"bookmarks\";\n\n// Initialize database table\nexport async function initializeBookmarksDatabase() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n url TEXT PRIMARY KEY,\n added DATETIME DEFAULT CURRENT_TIMESTAMP,\n title TEXT NOT NULL,\n summary TEXT\n )`);\n}\n\n// Utility functions\n\nasync function findFeed(url: string): Promise {\n const { getRssUrlsFromUrl } = await import(\"npm:rss-url-finder\");\n const feedUrls = await getRssUrlsFromUrl(url);\n let feedUrl = feedUrls[0]?.url ?? url;\n\n // Fix URL construction if the feed URL is relative\n if (!feedUrl.includes(\"http\")) {\n // Ensure proper URL joining\n const baseUrl = url.endsWith(\"/\") ? url.slice(0, -1) : url;\n const feedPath = feedUrl.startsWith(\"/\") ? feedUrl : \"/\" + feedUrl;\n feedUrl = baseUrl + feedPath;\n }\n\n console.log(feedUrl);\n return feedUrl;\n}\n\nasync function addSubscription(url: string) {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n let parser = new Parser({\n timeout: 5000,\n });\n console.log(\"getting feed\");\n let feedFile = await fetch(url);\n console.log(\"got feed file\");\n let feedText = await feedFile.text();\n console.log(\"got feed file text\");\n console.log(feedText);\n let feed = await parser.parseString(feedText);\n console.log(\"got feed\");\n const title = feed.title;\n console.log(title);\n\n await sqlite.execute({\n sql: `insert into rssSubscriptions(url, title) values (:feedUrl, :title)`,\n args: { feedUrl: url, title: title || \"\" },\n });\n}\n\nasync function getRecentArticles(feedUrl: string) {\n try {\n const parser = new Parser();\n\n const feed = await parser.parseURL(feedUrl);\n\n const articles: Array<{\n title: string;\n link: string;\n description: string;\n pubDate: string;\n }> = [];\n const itemsToProcess = Math.min(3, feed.items?.length || 0);\n\n for (let i = 0; i < itemsToProcess; i++) {\n const item = feed.items[i];\n\n const title = item.title?.trim() || \"Untitled\";\n const link = item.link?.trim() || \"\";\n const description = item.contentSnippet || item.content || item.summary ||\n \"\";\n const pubDate = item.pubDate || item.isoDate || \"\";\n\n // Clean up description (limit length)\n const cleanDescription = description\n .replace(/\\s+/g, \" \") // Normalize whitespace\n .trim()\n .substring(0, 200) + (description.length > 200 ? \"...\" : \"\");\n\n // Format date\n let formattedDate = \"\";\n if (pubDate) {\n try {\n const date = new Date(pubDate);\n if (!isNaN(date.getTime())) {\n formattedDate = date.toLocaleDateString(\"en-US\", {\n year: \"numeric\",\n month: \"short\",\n day: \"numeric\",\n });\n }\n } catch (e) {\n formattedDate = pubDate.toString().substring(0, 20);\n }\n }\n\n articles.push({\n title: title,\n link: link,\n description: cleanDescription,\n pubDate: formattedDate,\n });\n }\n\n return articles;\n } catch (error) {\n console.error(\"Error fetching articles:\", error);\n throw error;\n }\n}\n\n// Render HTML page layout\nfunction renderPageLayout(title: string, styles: string, body: string): string {\n return `\n \n \n \n \n \n ${title}\n \n \n \n \n \n ${body}\n \n \n `;\n}\n\n// Render the bookmarks list page\nfunction renderBookmarksListPage(bookmarkRows: string, page: number, totalPages: number, totalBookmarks: number, offset: number, limit: number, baseUrl: string): string {\n const styles = `\n table { width: 100%; }\n td:first-child { width: 40%; }\n td:nth-child(2) { width: 15%; white-space: nowrap; }\n td:nth-child(3) { width: auto; }\n td:last-child { width: 1%; text-align: right; white-space: nowrap; }\n .pagination { margin-top: 20px; }\n .pagination a { margin: 0 5px; }\n `;\n\n const paginationHtml = totalPages > 1\n ? `\n

\n Showing ${offset + 1} to ${Math.min(offset + limit, totalBookmarks)} of ${totalBookmarks} bookmarks\n

\n ${page > 1 ? `\n First\n Previous\n ` : \"\"}\n\n ${Array.from({ length: Math.min(5, totalPages) }, (_, i) => {\n let pageNum: number;\n if (totalPages <= 5) {\n pageNum = i + 1;\n } else if (page <= 3) {\n pageNum = i + 1;\n } else if (page >= totalPages - 2) {\n pageNum = totalPages - 4 + i;\n } else {\n pageNum = page - 2 + i;\n }\n\n return `${pageNum}`;\n }).join(\"\")}\n\n ${page < totalPages ? `\n Next\n Last\n ` : \"\"}\n

\n ` : \"\";\n\n const body = `\n

My Bookmarks

\n Back to Home |\n Add Bookmark |\n Bookmarklet |\n Search\n

${totalBookmarks} total bookmarks

\n\n \n \n \n \n \n \n \n \n \n \n ${bookmarkRows || ''}\n \n

Title	Added	Summary
No bookmarks yet

\n\n ${paginationHtml}\n `;\n\n return renderPageLayout('Bookmarks', styles, body);\n}\n\n// Render the add bookmark form page\nfunction renderAddBookmarkFormPage(): string {\n const styles = `\n input[type=\"url\"], input[type=\"text\"] { width: 100%; }\n textarea { width: 100%; min-height: 100px; }\n `;\n\n const body = `\n

Add Bookmark

← Back to Bookmarks

\n\n \n `;\n\n return renderPageLayout('Add Bookmark', styles, body);\n}\n\n// Render the delete confirmation page\nfunction renderDeleteConfirmationPage(bookmark: any): string {\n const styles = ``;\n\n const body = `\n

Delete Bookmark

← Back to Bookmarks

\n\n

Confirm Deletion

Are you sure you want to delete this bookmark? This action cannot be undone.

\n\n

${bookmark.title || \"Untitled\"}

${bookmark.url}

\n ${bookmark.summary ? `

${bookmark.summary}

` : \"\"}\n

\n\n

\n \n \n

\n `;\n\n return renderPageLayout('Delete Bookmark', styles, body);\n}\n\n// Render the bookmark added success page\nfunction renderBookmarkAddedPage(title: string): string {\n const styles = ``;\n\n const body = `\n

Bookmark Added!

${title} has been saved to your bookmarks.

\n View All Bookmarks\n \n

\n \n `;\n\n return renderPageLayout('Bookmark Added', styles, body);\n}\n\n// Render the bookmark deleted success page\nfunction renderBookmarkDeletedPage(): string {\n const styles = ``;\n\n const body = `\n

Bookmark Deleted

The bookmark has been successfully removed.

\n Back to Bookmarks\n

\n \n `;\n\n return renderPageLayout('Bookmark Deleted', styles, body);\n}\n\n// Render the RSS feed discovery page\nfunction renderFindRssPage(url: string, feedUrl: string, error: string, loading: boolean, recentArticles: any[]): string {\n const styles = `\n .feed-url-container { margin: 10px 0; }\n .feed-url-container input { width: 70%; }\n .feed-url-container button { margin-left: 10px; }\n .article { margin: 20px 0; padding: 10px; border: 1px solid #ccc; }\n `;\n\n const body = `\n

RSS Feed Discovery

← Back to Bookmarks

\n\n

Source URL

${url}

\n\n ${loading ? `\n

Searching for RSS feeds...

\n ` : error ? `\n

Error

${error}

\n ` : feedUrl ? `\n

RSS Feed Found

\n Feed URL:\n

\n \n \n

\n View RSS Feed\n \n

\n\n ${recentArticles.length > 0 ? `\n

No RSS Feed Found

No RSS or Atom feeds were discovered for this URL.

\n `}\n\n \n `;\n\n return renderPageLayout('RSS Feed Discovery', styles, body);\n}\n\n// Render subscription added success page\nfunction renderSubscriptionAddedPage(): string {\n const styles = ``;\n\n const body = `\n

Subscription Added!

You have successfully subscribed to the RSS feed.

\n Back to Bookmarks\n

\n \n `;\n\n return renderPageLayout('Subscription Added', styles, body);\n}\n\n// Render the edit bookmark form page\nfunction renderEditBookmarkFormPage(bookmark: any): string {\n const styles = `\n input[type=\"url\"], input[type=\"text\"] { width: 100%; }\n textarea { width: 100%; min-height: 100px; }\n `;\n\n const body = `\n

Edit Bookmark

← Back to Bookmarks

\n\n \n `;\n\n return renderPageLayout('Edit Bookmark', styles, body);\n}\n\n// Render the search bookmarks page\nfunction renderSearchBookmarksPage(query: string, bookmarkRows: string, resultCount: number): string {\n const styles = `\n table { width: 100%; }\n td:first-child { width: 40%; }\n td:nth-child(2) { width: 15%; white-space: nowrap; }\n td:nth-child(3) { width: auto; }\n td:last-child { width: 1%; text-align: right; white-space: nowrap; }\n input[type=\"text\"] { width: 100%; }\n `;\n\n const body = `\n

Search Bookmarks

← Back to Bookmarks

\n\n \n\n ${query ? `\n

Search Results

${resultCount} bookmark${resultCount === 1 ? '' : 's'} found for \"${query}\"

\n\n ${resultCount > 0 ? `\n \n \n \n \n \n \n \n \n \n \n ${bookmarkRows}\n \n

Title	Added	Summary

\n ` : '

No bookmarks match your search query.

'}\n ` : ''}\n `;\n\n return renderPageLayout('Search Bookmarks', styles, body);\n}\n\n// Database operations - exported for use in API\n\nexport async function getAllBookmarks(page: number = 1, limit: number = 25) {\n const offset = (page - 1) * limit;\n\n const countResult = await sqlite.execute(\n `SELECT COUNT(*) as total FROM ${TABLE_NAME}`,\n );\n const total = Number(countResult.rows[0].total || 0);\n\n const result = await sqlite.execute(\n `SELECT url, added, title, summary FROM ${TABLE_NAME} ORDER BY added DESC LIMIT ? OFFSET ?`,\n [limit, offset],\n );\n\n return {\n bookmarks: result.rows,\n total,\n totalPages: Math.ceil(total / limit)\n };\n}\n\nexport async function getBookmarkByUrl(url: string) {\n const result = await sqlite.execute(\n `SELECT url, added, title, summary FROM ${TABLE_NAME} WHERE url = ?`,\n [url],\n );\n return result.rows.length > 0 ? result.rows[0] : null;\n}\n\nexport async function createOrUpdateBookmark(url: string, title: string, summary: string = \"\") {\n const existing = await getBookmarkByUrl(url);\n\n if (existing) {\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} SET title = ?, summary = ? WHERE url = ?`,\n [title, summary, url],\n );\n return { url, title, summary, updated: true };\n } else {\n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (url, title, summary) VALUES (?, ?, ?)`,\n [url, title, summary],\n );\n return { url, title, summary, updated: false };\n }\n}\n\nexport async function updateBookmarkDetails(url: string, newTitle: string, newSummary: string) {\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} SET title = ?, summary = ? WHERE url = ?`,\n [newTitle, newSummary, url],\n );\n}\n\nexport async function deleteBookmark(url: string) {\n await sqlite.execute(\n `DELETE FROM ${TABLE_NAME} WHERE url = ?`,\n [url],\n );\n}\n\nexport async function searchBookmarks(query: string) {\n const searchPattern = `%${query}%`;\n\n // Search title first, then summary\n const titleMatches = await sqlite.execute(\n `SELECT url, added, title, summary FROM ${TABLE_NAME} WHERE title LIKE ? ORDER BY added DESC`,\n [searchPattern],\n );\n\n const summaryMatches = await sqlite.execute(\n `SELECT url, added, title, summary FROM ${TABLE_NAME} WHERE summary LIKE ? AND title NOT LIKE ? ORDER BY added DESC`,\n [searchPattern, searchPattern],\n );\n\n // Combine results - title matches first, then summary matches\n return [...titleMatches.rows, ...summaryMatches.rows];\n}\n\n// Route handler functions\n\n// GET /bookmarks - Display all bookmarks with pagination\nexport async function handleGetBookmarks(c: Context) {\n const baseUrl = c.req.url.split(\"/\")[0] + \"//\" + c.req.url.split(\"/\")[2];\n const page = parseInt(c.req.query(\"page\") || \"1\");\n const limit = 25;\n\n const { bookmarks, total: totalBookmarks, totalPages } = await getAllBookmarks(page, limit);\n const offset = (page - 1) * limit;\n\n const bookmarkRows = bookmarks.map((bookmark) => `\n \n \n \n ${String(bookmark.title || bookmark.url || '')}\n \n \n \n ${moment.tz(String(bookmark.added || ''), \"America/New_York\").fromNow()}\n \n \n ${String(bookmark.summary || '')}\n \n \n \n \n \n \n \n \n \n \n \n \n \n `).join(\"\");\n\n return c.html(renderBookmarksListPage(bookmarkRows, page, totalPages, totalBookmarks, offset, limit, baseUrl));\n}\n\n// GET /bookmarks/form - Show add bookmark form\nexport async function handleAddBookmarkForm(c: Context) {\n return c.html(renderAddBookmarkFormPage());\n}\n\n// GET /bookmarks/add - Add or update a bookmark\nexport async function handleAddBookmark(c: Context) {\n const url = c.req.query(\"url\");\n const title = c.req.query(\"title\");\n const summary = c.req.query(\"summary\") || \"\";\n\n if (!url || !title) {\n return c.html(\n `\n \n \n

Error

URL and title are required.

\n Go back\n \n \n `,\n 400,\n );\n }\n\n try {\n await createOrUpdateBookmark(url, title, summary);\n return c.html(renderBookmarkAddedPage(title));\n } catch (error) {\n console.error(\"Error adding bookmark:\", error);\n const message = error instanceof Error ? error.message : \"Unknown error\";\n return c.html(\n `\n \n \n

Error

Failed to add bookmark: ${message}

\n Go back\n \n \n `,\n 500,\n );\n }\n}\n\n// GET /bookmarks/delete - Show delete confirmation\nexport async function handleDeleteConfirmation(c: Context) {\n const url = c.req.query(\"url\");\n\n if (!url) {\n return c.redirect(\"/bookmarks\");\n }\n\n // Get bookmark details for confirmation\n const bookmark = await getBookmarkByUrl(url);\n\n if (!bookmark) {\n return c.html(\n `\n \n \n

Bookmark Not Found

The bookmark you're trying to delete doesn't exist.

\n Back to Bookmarks\n \n \n `,\n 404,\n );\n }\n\n return c.html(renderDeleteConfirmationPage(bookmark));\n}\n\n// GET /bookmarks/delete/confirm - Actually delete the bookmark\nexport async function handleDeleteConfirm(c: Context) {\n const url = c.req.query(\"url\");\n\n if (!url) {\n return c.redirect(\"/bookmarks\");\n }\n\n try {\n await deleteBookmark(url);\n return c.html(renderBookmarkDeletedPage());\n } catch (error) {\n console.error(\"Error deleting bookmark:\", error);\n const message = error instanceof Error ? error.message : \"Unknown error\";\n return c.html(\n `\n \n \n

Error

Failed to delete bookmark: ${message}

\n Back to Bookmarks\n \n \n `,\n 500,\n );\n }\n}\n\n// GET /bookmarks/find-rss - Find RSS feed for a URL\nexport async function handleFindRss(c: Context) {\n const url = c.req.query(\"url\");\n\n if (!url) {\n return c.redirect(\"/bookmarks\");\n }\n\n let feedUrl = \"\";\n let error = \"\";\n let loading = true;\n let recentArticles = [];\n\n try {\n feedUrl = await findFeed(url);\n\n // If we found a feed, try to fetch recent articles\n if (feedUrl) {\n try {\n recentArticles = await getRecentArticles(feedUrl);\n } catch (articleError) {\n const msg = articleError instanceof Error ? articleError.message : \"Unknown error\";\n console.log(\"Could not fetch articles:\", msg);\n // Don't fail the whole page if we can't fetch articles\n }\n }\n\n loading = false;\n } catch (err) {\n error = err instanceof Error ? err.message : \"Failed to find RSS feed\";\n loading = false;\n }\n\n return c.html(renderFindRssPage(url, feedUrl, error, loading, recentArticles));\n}\n\n// GET /bookmarks/subscribe - Subscribe to an RSS feed\nexport async function handleSubscribe(c: Context) {\n const feedUrl = c.req.query(\"feedUrl\");\n\n if (!feedUrl) {\n return c.redirect(\"/bookmarks\");\n }\n\n try {\n await addSubscription(feedUrl);\n return c.html(renderSubscriptionAddedPage());\n } catch (error) {\n console.error(\"Error adding subscription:\", error);\n const message = error instanceof Error ? error.message : \"Unknown error\";\n return c.html(\n `\n \n \n

Error

Failed to add subscription: ${message}

\n Back to Bookmarks\n \n \n `,\n 500,\n );\n }\n}\n\n// GET /bookmarks/edit - Show edit bookmark form\nexport async function handleGetEditBookmarkForm(c: Context) {\n const url = c.req.query(\"url\");\n\n if (!url) {\n return c.redirect(\"/bookmarks\");\n }\n\n const bookmark = await getBookmarkByUrl(url);\n\n if (!bookmark) {\n return c.html(\n `\n \n \n

Bookmark Not Found

The bookmark you're trying to edit doesn't exist.

\n Back to Bookmarks\n \n \n `,\n 404,\n );\n }\n\n return c.html(renderEditBookmarkFormPage(bookmark));\n}\n\n// POST /bookmarks/edit - Update bookmark\nexport async function handleUpdateBookmark(c: Context) {\n const formData = await c.req.formData();\n const url = formData.get(\"url\") as string;\n const title = formData.get(\"title\") as string;\n const summary = formData.get(\"summary\") as string || \"\";\n\n if (!url || !title) {\n return c.html(\n `\n \n \n

Error

URL and title are required.

\n Go back\n \n \n `,\n 400,\n );\n }\n\n try {\n await updateBookmarkDetails(url, title, summary);\n return c.redirect(\"/bookmarks\");\n } catch (error) {\n console.error(\"Error updating bookmark:\", error);\n const message = error instanceof Error ? error.message : \"Unknown error\";\n return c.html(\n `\n \n \n

Error

Failed to update bookmark: ${message}

\n Go back\n \n \n `,\n 500,\n );\n }\n}\n\n// GET /bookmarks/search - Show search form\nexport async function handleGetSearchBookmarks(c: Context) {\n return c.html(renderSearchBookmarksPage('', '', 0));\n}\n\n// POST /bookmarks/search - Perform search\nexport async function handleSearchBookmarksPost(c: Context) {\n const formData = await c.req.formData();\n const query = formData.get(\"query\") as string;\n\n if (!query) {\n return c.html(renderSearchBookmarksPage('', '', 0));\n }\n\n try {\n const results = await searchBookmarks(query);\n\n const bookmarkRows = results.map((bookmark) => `\n \n \n \n ${String(bookmark[2] || bookmark[0] || '')}\n \n \n \n ${moment.tz(String(bookmark[1] || ''), \"America/New_York\").fromNow()}\n \n \n ${String(bookmark[3] || '')}\n \n \n \n \n \n \n \n \n \n \n \n \n \n `).join(\"\");\n\n return c.html(renderSearchBookmarksPage(query, bookmarkRows, results.length));\n } catch (error) {\n console.error(\"Error searching bookmarks:\", error);\n const message = error instanceof Error ? error.message : \"Unknown error\";\n return c.html(\n `\n \n \n

Error

Failed to search bookmarks: ${message}

\n Go back\n \n \n `,\n 500,\n );\n }\n}\n",[],[201],{"_103":210,"_95":211,"_152":212,"_154":-5,"_155":137,"_156":213,"_158":159,"_105":214,"_100":185,"_161":195,"_163":215,"_165":22,"_166":-5,"_167":216,"_98":217},"d739e66a-ba5f-11f0-baf7-0224a6c84d84","bookmarksEmailCron.ts","c9e0549a-ba5f-11f0-b82a-0224a6c84d84",258,["D",1762358124389],"import { email } from \"https://esm.town/v/std/email\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nexport default async function (interval: Interval) {\n // Calculate date 7 days ago\n const sevenDaysAgo = new Date(Date.now() - 7 * 24 * 60 * 60 * 1000);\n const formattedDate = sevenDaysAgo.toISOString().split(\"T\")[0];\n\n try {\n // Fetch recent bookmarks from the last 7 days, limited to 50\n // Using common bookmark table column names - adjust if your schema is different\n const result = await sqlite.execute(\n `SELECT * FROM bookmarks \n WHERE DATE(added) >= ? \n ORDER BY added DESC \n LIMIT 50`,\n [formattedDate],\n );\n\n // SQLite returns an object with rows property containing the actual array\n const bookmarks = result.rows || [];\n\n if (bookmarks.length === 0) {\n console.log(\"No bookmarks found from the last 7 days\");\n return;\n }\n\n // Convert links to markdown - adjust field names based on your table structure\n const markdownLinks = bookmarks.map((bookmark) => {\n return `- [${bookmark.title}](${bookmark.url})`;\n }).join(\"\\n\");\n\n // Send email with markdown links\n await email({\n to: Deno.env.get(\"EMAIL\"),\n subject: `Bookmarks from ${formattedDate} (${bookmarks.length} links)`,\n text: markdownLinks,\n html: `

${markdownLinks}

`,\n });\n\n console.log(`Sent email with ${bookmarks.length} bookmarks`);\n console.log(`to ${Deno.env.get(\"EMAIL\")}`);\n console.log(`${markdownLinks}`);\n } catch (error) {\n console.error(\"Error fetching or processing bookmarks:\", error);\n }\n}",[],[211],{"_103":219,"_95":220,"_152":221,"_154":-5,"_155":137,"_156":222,"_158":159,"_105":223,"_100":32,"_161":186,"_163":224,"_165":22,"_166":-5,"_167":225,"_98":226},"d7292298-ba6f-11f0-a0f6-0224a6c84d84","bruinsScoreCron.ts","d7292342-ba6f-11f0-a0f6-0224a6c84d84",268,["D",1762364996232],"import { subDays } from \"https://esm.sh/date-fns\";\n\nasync function sendNtfyNotification(topic: string, message: string, title: string) {\n const url = `https://ntfy.sh/${topic}`;\n const response = await fetch(url, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"title\": title,\n \"tags\": \"hockey\",\n \"Click\": \"https://plaintextsports.com/#nhl\",\n },\n body: message,\n });\n\n if (!response.ok) {\n throw new Error(`Failed to send notification: ${response.statusText}`);\n }\n}\n\nexport default async function getBruinsScore(interval: Interval) {\n const yesterday = subDays(new Date(), 1);\n const formattedDate = yesterday.toISOString().split(\"T\")[0];\n\n const apiUrl = `https://api-web.nhle.com/v1/score/${formattedDate}`;\n\n try {\n const response = await fetch(apiUrl);\n if (!response.ok) {\n throw new Error(`HTTP error! status: ${response.status}`);\n }\n const data = await response.json();\n\n const bruinsGame = data.games.find(game =>\n game.homeTeam.name.default == \"Bruins\" || game.awayTeam.name.default == \"Bruins\"\n );\n\n if (!bruinsGame) {\n return;\n }\n\n const bruinsTeam = bruinsGame.homeTeam.name.default === \"Bruins\" ? bruinsGame.homeTeam : bruinsGame.awayTeam;\n const opposingTeam = bruinsGame.homeTeam.name.default === \"Bruins\"\n ? bruinsGame.awayTeam\n : bruinsGame.homeTeam;\n\n const scoreText =\n `Last night's score: Boston Bruins ${bruinsTeam.score}, ${opposingTeam.name.default} ${opposingTeam.score}`;\n\n sendNtfyNotification(Deno.env.get(\"BRUINS_TOPIC\"), scoreText, \"Boston Bruins\");\n } catch (error) {\n return;\n }\n}",[],[220],{"_103":228,"_95":229,"_152":230,"_154":-5,"_155":137,"_156":231,"_158":159,"_105":232,"_100":233,"_161":186,"_163":234,"_165":22,"_166":-5,"_167":235,"_98":236},"021e504c-b997-11f0-864c-0224a6c84d84","budget.ts","8e80907c-b8ed-11f0-9b46-0224a6c84d84",201,["D",1762271867171],6,"import { Context } from \"https://esm.sh/hono\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst TABLE_NAME = `budgetUpdater_budget`;\n\n// Initialize database table\nexport async function initializeBudgetDatabase() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n category TEXT PRIMARY KEY,\n value INTEGER NOT NULL\n )\n `);\n\n // Initialize with default values if empty\n const result = await sqlite.execute(`SELECT COUNT(*) as count FROM ${TABLE_NAME}`);\n if (result.rows[0].count === 0) {\n await sqlite.execute(`INSERT INTO ${TABLE_NAME} (category, value) VALUES ('games', 0)`);\n await sqlite.execute(`INSERT INTO ${TABLE_NAME} (category, value) VALUES ('gadgets', 0)`);\n }\n}\n\n// Render HTML page layout\nfunction renderPageLayout(title: string, styles: string, body: string): string {\n return `\n \n \n \n \n \n ${title}\n \n \n \n \n ${body}\n \n \n `;\n}\n\n// Database operations - exported for use in API\n\nexport async function getBudgetData() {\n const result = await sqlite.execute(`SELECT * FROM ${TABLE_NAME}`);\n const gamesBudget = result.rows.find(item => item.category === \"games\")?.value || 0;\n const gadgetsBudget = result.rows.find(item => item.category === \"gadgets\")?.value || 0;\n return { gamesBudget, gadgetsBudget };\n}\n\nexport async function updateBudget(gamesSpent: number, gadgetsSpent: number) {\n const { gamesBudget, gadgetsBudget } = await getBudgetData();\n\n const newGamesValue = Math.max(0, gamesBudget - gamesSpent);\n const newGadgetsValue = Math.max(0, gadgetsBudget - gadgetsSpent);\n\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} SET value = ? WHERE category = 'games'`,\n [newGamesValue],\n );\n\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} SET value = ? WHERE category = 'gadgets'`,\n [newGadgetsValue],\n );\n\n return { newGamesValue, newGadgetsValue };\n}\n\n// Route handlers\n\nexport async function handleGetBudget(c: Context) {\n const { gamesBudget, gadgetsBudget } = await getBudgetData();\n\n const styles = `\n body {\n display: flex;\n justify-content: center;\n align-items: center;\n min-height: 100vh;\n }\n .budget-container {\n display: flex;\n gap: 40px;\n text-align: center;\n }\n .budget-item {\n background: white;\n padding: 20px;\n border-radius: 8px;\n box-shadow: 0 4px 6px rgba(0,0,0,0.1);\n }\n .budget-value {\n font-size: 120px;\n font-weight: bold;\n color: #333;\n }\n .budget-label {\n font-size: 16px;\n text-transform: uppercase;\n color: #666;\n letter-spacing: 1px;\n }\n .spend-link {\n display: block;\n margin-top: 40px;\n text-decoration: none;\n padding: 10px 20px;\n background-color: #4CAF50;\n color: white;\n border-radius: 5px;\n text-align: center;\n }\n `;\n\n const body = `\n

← Back to Home

$${gamesBudget}

Games

$${gadgetsBudget}

Gadgets

\n Spend 💸\n

\n `;\n\n return c.html(renderPageLayout('Budget Tracker', styles, body));\n}\n\nexport async function handleGetSpendForm(c: Context) {\n const { gamesBudget, gadgetsBudget } = await getBudgetData();\n\n const styles = `\n body {\n display: flex;\n justify-content: center;\n align-items: center;\n min-height: 100vh;\n }\n form {\n background: white;\n padding: 30px;\n border-radius: 8px;\n box-shadow: 0 4px 6px rgba(0,0,0,0.1);\n width: 300px;\n }\n input {\n width: 100%;\n padding: 10px;\n margin: 10px 0;\n border: 1px solid #ddd;\n border-radius: 4px;\n }\n button {\n width: 100%;\n padding: 10px;\n background-color: #4CAF50;\n color: white;\n border: none;\n border-radius: 4px;\n cursor: pointer;\n }\n .cancel {\n display: block;\n text-align: center;\n margin-top: 15px;\n color: #666;\n text-decoration: none;\n }\n `;\n\n const body = `\n \n `;\n\n return c.html(renderPageLayout('Spend Budget', styles, body));\n}\n\nexport async function handleUpdateBudget(c: Context) {\n const formData = await c.req.formData();\n const games = Number(formData.get(\"games\") || 0);\n const gadgets = Number(formData.get(\"gadgets\") || 0);\n\n await updateBudget(games, gadgets);\n\n return c.redirect(\"/budget\");\n}",[],[229],{"_103":238,"_95":239,"_152":240,"_154":-5,"_155":137,"_156":241,"_158":159,"_105":242,"_100":185,"_161":195,"_163":243,"_165":22,"_166":-5,"_167":244,"_98":245},"ad940586-b8f0-11f0-8b20-0224a6c84d84","budgetCron.ts","a1d90bce-b8f0-11f0-aa23-0224a6c84d84",163,["D",1762200429213],"export default async function(interval: Interval) {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const KEY = \"budgetUpdater\";\n const TABLE_NAME = `${KEY}_budget`;\n\n // Ensure table exists\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n category TEXT PRIMARY KEY,\n value INTEGER NOT NULL\n )\n `);\n\n // Insert or update rows\n await sqlite.execute(`\n INSERT OR REPLACE INTO ${TABLE_NAME} (category, value)\n VALUES \n ('games', COALESCE((SELECT value FROM ${TABLE_NAME} WHERE category = 'games'), 0) + 1),\n ('gadgets', COALESCE((SELECT value FROM ${TABLE_NAME} WHERE category = 'gadgets'), 0) + 1)\n `);\n\n // Optional: Log the current state\n const result = await sqlite.execute(`SELECT * FROM ${TABLE_NAME}`);\n console.log(\"Budget updated:\", result.rows);\n}",[],[239],{"_103":247,"_95":248,"_152":249,"_154":-5,"_155":137,"_156":250,"_158":159,"_105":251,"_100":252,"_161":186,"_163":253,"_165":22,"_166":-5,"_167":254,"_98":255},"01f2ef10-b997-11f0-847c-0224a6c84d84","bugs.ts","353fa2b0-b996-11f0-8d88-0224a6c84d84",198,["D",1762271867140],7,"import { Context } from \"https://esm.sh/hono\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { markdownToHtml } from \"https://esm.town/v/xkonti/markdownToHtml\";\n\nconst TABLE_NAME = \"bugs\";\n\n// Initialize database table\nexport async function initializeBugsDatabase() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n description TEXT,\n type TEXT NOT NULL,\n project TEXT NOT NULL,\n status TEXT NOT NULL DEFAULT 'open',\n parent INTEGER,\n createdtime TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n closedtime TIMESTAMP\n )\n `);\n}\n\n// Render HTML page layout\nfunction renderPageLayout(title: string, styles: string, body: string): string {\n return `\n \n \n \n \n \n ${title}\n \n \n \n \n \n ${body}\n \n \n `;\n}\n\n// Database operations - exported for use in API\n\nexport async function getAllBugs(status?: string) {\n if (status === \"open\") {\n return await sqlite.execute(`SELECT * FROM ${TABLE_NAME} WHERE status='open'`);\n }\n return await sqlite.execute(`SELECT * FROM ${TABLE_NAME}`);\n}\n\nexport async function getBugById(id: string | number) {\n const result = await sqlite.execute(`SELECT * FROM ${TABLE_NAME} WHERE id = ?`, [id]);\n return result.rows[0];\n}\n\nexport async function getBugsByProject(project: string) {\n return await sqlite.execute(`SELECT * FROM ${TABLE_NAME} WHERE project = ?`, [project]);\n}\n\nexport async function getDistinctProjects() {\n return await sqlite.execute(`SELECT DISTINCT project FROM ${TABLE_NAME} ORDER BY project ASC`);\n}\n\nexport async function createBug(title: string, description: string, type: string, project: string, status: string, parent?: string) {\n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (title, description, type, project, status, parent) VALUES (?, ?, ?, ?, ?, ?)`,\n [title, description, type, project, status, parent || null]\n );\n}\n\nexport async function updateBugStatus(id: string | number, status: string) {\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} SET status = ?, closedtime = CURRENT_TIMESTAMP WHERE id = ?`,\n [status, id]\n );\n}\n\n// Helper functions\n\nasync function getTable(rows: any) {\n let html = \"\";\n for (const row of rows.rows) {\n html += ``;\n }\n html += \"

ID	Title	Project	Type	Status
${row[0]}	${row[1]}	${\n row[4]\n }	${row[3]}	${row[5]}

\";\n return html;\n}\n\n// Route handlers\n\nexport async function handleGetBugsList(c: Context) {\n const rows = await getAllBugs(\"open\");\n let tableHtml = await getTable(rows);\n\n const styles = `\n td:last-child { width: 1%; text-align: right; white-space: nowrap; }\n `;\n\n const body = `\n

Bug Tracker

← Back to Home

\n ${tableHtml}\n

\n Show All |\n Show Open |\n New |\n Show Projects\n

\n `;\n\n return c.html(renderPageLayout('Bug Tracker', styles, body));\n}\n\nexport async function handleGetAllBugs(c: Context) {\n const rows = await getAllBugs();\n let tableHtml = await getTable(rows);\n\n const styles = `\n td:last-child { width: 1%; text-align: right; white-space: nowrap; }\n `;\n\n const body = `\n

Bug Tracker

← Back to Home

\n ${tableHtml}\n

\n Show All |\n Show Open |\n New |\n Show Projects\n

\n `;\n\n return c.html(renderPageLayout('Bug Tracker - All', styles, body));\n}\n\nexport async function handleGetBug(c: Context) {\n const id = c.req.param(\"id\");\n const bug = await getBugById(id);\n const rows = { rows: [bug] };\n let tableHtml = await getTable(rows);\n const descriptionHtml = await markdownToHtml(String(bug[2] || \"\"));\n\n const styles = `\n td:last-child { width: 1%; text-align: right; white-space: nowrap; }\n `;\n\n const body = `\n

Bug #${id}

← Back to Bugs

\n ${tableHtml}\n

Description

\n ${descriptionHtml}\n `;\n\n return c.html(renderPageLayout(`Bug #${id}`, styles, body));\n}\n\nexport async function handleGetProjects(c: Context) {\n const rows = await getDistinctProjects();\n\n const styles = ``;\n\n let tableHtml = \"\";\n for (const row of rows.rows) {\n tableHtml += ``;\n }\n tableHtml += \"

Project
${row[0]}

\";\n\n const body = `\n

Projects

← Back to Bugs

\n ${tableHtml}\n `;\n\n return c.html(renderPageLayout('Projects', styles, body));\n}\n\nexport async function handleGetProject(c: Context) {\n const name = c.req.param(\"name\");\n const rows = await getBugsByProject(name);\n let tableHtml = await getTable(rows);\n\n const styles = `\n td:last-child { width: 1%; text-align: right; white-space: nowrap; }\n `;\n\n const body = `\n

Project: ${name}

← Back to Projects

\n ${tableHtml}\n `;\n\n return c.html(renderPageLayout(`Project: ${name}`, styles, body));\n}\n\nexport async function handleGetNewBugForm(c: Context) {\n const parent = c.req.query(\"parent\");\n\n let parentHTML = `Parent:\n `;\n let datalist = ``;\n const rows = await getDistinctProjects();\n for (const row of rows.rows) {\n datalist += `\";\n let projectHTML = `Project:\n ${datalist}`;\n\n if (parent != null) {\n parentHTML = ``;\n const bug = await getBugById(parent);\n projectHTML = ``;\n }\n\n const styles = ``;\n\n const body = `\n

Create New Bug

← Back to Bugs

\n \n `;\n\n return c.html(renderPageLayout('New Bug', styles, body));\n}\n\nexport async function handleCreateBug(c: Context) {\n const formData = await c.req.formData();\n const title = formData.get(\"title\") as string;\n const description = formData.get(\"description\") as string;\n const type = formData.get(\"type\") as string;\n const project = formData.get(\"project\") as string;\n const status = formData.get(\"status\") as string;\n const parent = formData.get(\"parent\") as string;\n\n await createBug(title, description, type, project, status, parent);\n\n return c.redirect(\"/bugs\");\n}\n\nexport async function handleCloseBug(c: Context) {\n const id = c.req.param(\"id\");\n await updateBugStatus(id, \"closed\");\n return c.redirect(\"/bugs\");\n}\n\nexport async function handleWontfixBug(c: Context) {\n const id = c.req.param(\"id\");\n await updateBugStatus(id, \"wontfix\");\n return c.redirect(\"/bugs\");\n}",[],[248],{"_103":257,"_95":258,"_152":259,"_154":-5,"_155":137,"_156":260,"_158":159,"_105":261,"_100":32,"_161":162,"_163":262,"_165":22,"_166":-5,"_167":263,"_98":264},"23c2ca1e-b8b8-11f0-8c05-0224a6c84d84","deno.json","23c2cabe-b8b8-11f0-8c05-0224a6c84d84",4,["D",1762176146025],"{\n \"$schema\": \"https://raw.githubusercontent.com/denoland/deno/98f62cee78e85bfc47c62ed703777c6bc8794f1c/cli/schemas/config-file.v1.json\",\n \"lock\": false,\n \"compilerOptions\": {\n \"noImplicitAny\": false,\n \"strict\": true,\n \"types\": [\"https://www.val.town/types/valtown.d.ts\"],\n \"lib\": [\n \"dom\",\n \"dom.iterable\",\n \"dom.asynciterable\",\n \"deno.ns\",\n \"deno.unstable\"\n ]\n },\n \"lint\": {\n \"include\": [\"deno:/https/esm.town/**/*\"],\n \"rules\": {\n \"exclude\": [\"no-explicit-any\"]\n }\n },\n \"node_modules_dir\": false,\n \"experimental\": {\n \"unstable-node-globals\": true,\n \"unstable-temporal\": true,\n \"unstable-worker-options\": true,\n \"unstable-sloppy-imports\": true\n }\n}",[],[258],{"_103":266,"_95":267,"_152":268,"_154":-5,"_155":137,"_156":269,"_158":159,"_105":270,"_100":233,"_161":186,"_163":271,"_165":22,"_166":-5,"_167":272,"_98":273},"01f9d956-b997-11f0-98be-0224a6c84d84","dinocomics.ts","f1b87b02-b8cd-11f0-afd3-0224a6c84d84",199,["D",1762271867104],"import { Context } from \"https://esm.sh/hono\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport cheerio from \"https://esm.sh/cheerio@1.0.0-rc.12\";\n\nconst TABLE_NAME = \"dinocomics\";\n\n// Initialize database table\nexport async function initializeDinocomicsDatabase() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n number INTEGER PRIMARY KEY,\n date TEXT NOT NULL,\n title TEXT NOT NULL,\n read BOOLEAN DEFAULT 0\n )\n `);\n}\n\n// Render HTML page layout\nfunction renderPageLayout(title: string, styles: string, body: string): string {\n return `\n \n \n \n \n \n ${title}\n \n \n \n \n ${body}\n \n \n `;\n}\n\n// Database operations - exported for use in API\n\nexport async function getAllComics() {\n const comics = await sqlite.execute(`\n SELECT number, date, title, read\n FROM ${TABLE_NAME}\n ORDER BY number ASC\n `);\n return comics.rows;\n}\n\nexport async function getComicByNumber(number: number) {\n const result = await sqlite.execute(`\n SELECT number, date, title, read\n FROM ${TABLE_NAME}\n WHERE number = ?\n `, [number]);\n return result.rows.length > 0 ? result.rows[0] : null;\n}\n\nexport async function markComicAsRead(number: number) {\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} SET read = true WHERE number = ?`,\n [number],\n );\n}\n\nexport async function refreshComicsFromArchive() {\n const cheerio = (await import(\"https://esm.sh/cheerio@1.0.0-rc.12\")).default;\n\n // Fetch archive page\n const response = await fetch(\"https://www.qwantz.com/archive.php\");\n const html = await response.text();\n\n // Parse HTML with cheerio\n const $ = cheerio.load(html);\n\n // Collect comics to insert\n const comicsToInsert: Array<{\n number: number;\n date: string;\n title: string;\n }> = [];\n\n // Find archive lists\n $(\"ul.archive\").each((_listIndex, list) => {\n $(list).find(\"li\").each((_itemIndex, item) => {\n const link = $(item).find(\"a\");\n const href = link.attr(\"href\") || \"\";\n const comicNumberMatch = href.match(/comic=(\\d+)/);\n\n if (comicNumberMatch) {\n const number = parseInt(comicNumberMatch[1], 10);\n if (number < 4289) {\n return;\n }\n const date = link.text().trim() || \"\";\n\n // Capture ALL text after removing the date link\n const tempItem = $(item).clone();\n tempItem.find(\"a\").first().remove();\n let title = tempItem.text().trim() || \"\";\n\n // Remove leading colon and trim again\n title = title.replace(/^:\\s*/, \"\").trim();\n\n comicsToInsert.push({ number, date, title });\n }\n });\n });\n\n // Perform batch insert\n const insertQuery = `\n INSERT OR IGNORE INTO ${TABLE_NAME} (number, date, title, read)\n VALUES (?, ?, ?, ?)\n `;\n\n for (const comic of comicsToInsert) {\n await sqlite.execute(insertQuery, [comic.number, comic.date, comic.title, false]);\n }\n\n return comicsToInsert.length;\n}\n\n// Render the comics list page\nfunction renderComicsListPage(comicsRows: string): string {\n const styles = `\n .read {\n color: gray;\n text-decoration: line-through;\n }\n `;\n\n const body = `\n

Dino Comics

Back to Home

\n ${comicsRows}\n \n `;\n\n return renderPageLayout('Dino Comics', styles, body);\n}\n\n// GET /dinocomics - Display all comics\nexport async function handleGetDinocomics(c: Context) {\n const comics = await getAllComics();\n\n const comicsRows = comics.map(comic => `\n

\n ${comic.date}\n ${comic.title}\n

\n `).join(\"\");\n\n return c.html(renderComicsListPage(comicsRows));\n}\n\n// GET /dinocomics/:comic - Redirect to comic and mark as read\nexport async function handleReadComic(c: Context) {\n const comicNumber = Number(c.req.param(\"comic\"));\n\n if (comicNumber && !isNaN(comicNumber)) {\n await markComicAsRead(comicNumber);\n return c.redirect(`https://qwantz.com/index.php?comic=${comicNumber}`);\n }\n\n return c.redirect(\"/dinocomics\");\n}\n\n// GET /dinocomics/refresh - Refresh comics from archive\nexport async function handleRefreshComics(c: Context) {\n try {\n const count = await refreshComicsFromArchive();\n\n const styles = ``;\n const body = `\n

Comics Refreshed

Processed ${count} comics from Qwantz archive

\n Back to Comics\n `;\n\n return c.html(renderPageLayout('Comics Refreshed', styles, body));\n } catch (error) {\n console.error(\"Error refreshing comics:\", error);\n const message = error instanceof Error ? error.message : \"Unknown error\";\n\n const styles = ``;\n const body = `\n

Error

Failed to refresh comics: ${message}

\n Back to Comics\n `;\n\n return c.html(renderPageLayout('Error', styles, body), 500);\n }\n}\n",[],[267],{"_103":275,"_95":276,"_152":277,"_154":-5,"_155":137,"_156":278,"_158":159,"_105":279,"_100":280,"_161":186,"_163":281,"_165":22,"_166":-5,"_167":282,"_98":283},"937c0fa6-b998-11f0-8a26-0224a6c84d84","feeds.ts","a799e482-b997-11f0-8431-0224a6c84d84",219,["D",1762272540886],9,"import { Context } from \"https://esm.sh/hono\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport Parser from \"npm:rss-parser\";\n\n// Initialize database tables\nexport async function initializeFeedsDatabase() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS rssSubscriptions (\n url TEXT PRIMARY KEY NOT NULL,\n title TEXT NOT NULL,\n icon TEXT DEFAULT \"rss\",\n odds INTEGER DEFAULT 2048\n )\n `);\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS rssPosts (\n url TEXT PRIMARY KEY NOT NULL,\n title TEXT NOT NULL,\n feed INTEGER NOT NULL,\n Timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n}\n\n// Render HTML page layout\nfunction renderPageLayout(title: string, styles: string, body: string): string {\n return `\n \n \n \n \n \n ${title}\n \n \n \n \n \n ${body}\n \n \n `;\n}\n\n// Database operations - exported for use in API\n\nexport async function getAllFeedsWithLatestPost() {\n const rows = await sqlite.execute(\n \"SELECT s.title, s.url, max(p.Timestamp) as stamp, s.odds, p.title as ptitle, p.url as purl FROM rssSubscriptions as s, rssPosts as p WHERE s.rowid = p.feed GROUP BY s.rowid ORDER BY stamp DESC\"\n );\n return rows.rows;\n}\n\nexport async function getAllPosts(limit: number = 300) {\n const feeds = await sqlite.execute(\n \"SELECT p.url, p.title, s.title, s.icon FROM rssSubscriptions as s, rssPosts as p WHERE p.feed = s.rowid ORDER BY p.Timestamp DESC LIMIT ?\",\n [limit]\n );\n return feeds.rows;\n}\n\nexport async function findFeedUrl(url: string): Promise {\n const { getRssUrlsFromUrl } = await import(\"npm:rss-url-finder\");\n const feedUrls = await getRssUrlsFromUrl(url);\n let feedUrl = feedUrls[0]?.url ?? url;\n if (!feedUrl.includes(\"http\")) {\n feedUrl = url + feedUrl;\n }\n return feedUrl;\n}\n\nexport async function addSubscription(url: string) {\n let parser = new Parser({\n timeout: 5000,\n });\n let feedFile = await fetch(url);\n let feedText = await feedFile.text();\n let feed = await parser.parseString(feedText);\n const title = feed.title || \"Untitled Feed\";\n\n await sqlite.execute(\n `INSERT INTO rssSubscriptions(url, title) VALUES (?, ?)`,\n [url, title]\n );\n}\n\nexport async function updatePosts() {\n let parser = new Parser({\n timeout: 5000,\n });\n const feeds = await sqlite.execute(\"SELECT url, odds, rowid FROM rssSubscriptions ORDER BY odds ASC\");\n let checked = 0;\n\n for (const f of feeds.rows) {\n if (checked > 19) {\n break;\n }\n const r = Math.random() * 2048;\n let odds = f[1] as number;\n\n if (r < odds) {\n try {\n let feedFile = await fetch(f[0] as string);\n let feedText = await feedFile.text();\n let feedData = await parser.parseString(feedText);\n let title = feedData.items[0]?.title ?? feedData.items[0].link;\n let url = feedData.items[0].link;\n let feedid = f[2];\n\n try {\n await sqlite.execute(\n `INSERT INTO rssPosts(url, title, feed) VALUES (?, ?, ?)`,\n [url, title ?? \"Untitled\", Number(feedid)]\n );\n odds = odds * 2;\n } catch (error) {\n if (odds > 1) {\n odds = odds / 2;\n }\n }\n\n await sqlite.execute(\"UPDATE rssSubscriptions SET odds = ? WHERE rowid = ?\", [odds, Number(f[2])]);\n checked++;\n } catch (error) {\n if (odds > 1) {\n odds = odds / 2;\n }\n await sqlite.execute(\"UPDATE rssSubscriptions SET odds = ? WHERE rowid = ?\", [odds, Number(f[2])]);\n checked++;\n }\n }\n }\n}\n\n// Route handlers\n\nexport async function handleGetFeeds(c: Context) {\n const feeds = await getAllFeedsWithLatestPost();\n\n const styles = `\n table { width: 100%; }\n `;\n\n let tableHtml = \"\";\n for (const row of feeds) {\n tableHtml += ``;\n }\n tableHtml += \"

Feed	URL	Updated	Odds	Last Post
${row[0]}	${row[1]}	${row[2]}	${row[3]}	${row[4]}

\";\n\n const body = `\n

RSS Subscriptions

\n ← Back to Posts |\n Find Feed |\n Subscribe\n

\n ${tableHtml}\n `;\n\n return c.html(renderPageLayout('RSS Subscriptions', styles, body));\n}\n\nexport async function handleGetPosts(c: Context) {\n const posts = await getAllPosts(300);\n\n const styles = `\n .posttitle { font-weight: bold; }\n .feedtitle { color: #666; font-size: 0.9em; }\n ul { list-style: none; padding: 0; }\n li { margin: 10px 0; padding: 10px; border-bottom: 1px solid #ddd; }\n `;\n\n let postsHtml = \"

${f[1] || f[0]} | ${f[2]}

\";\n\n const body = `\n

RSS Posts

\n ← Back to Home |\n Manage Subscriptions |\n Find Feed |\n Subscribe\n

\n ${postsHtml}\n `;\n\n return c.html(renderPageLayout('RSS Posts', styles, body));\n}\n\nexport async function handleGetFindForm(c: Context) {\n const styles = ``;\n\n const body = `\n

Find a Feed for a URL

← Back to Posts

\n \n `;\n\n return c.html(renderPageLayout('Find Feed', styles, body));\n}\n\nexport async function handleFindFeed(c: Context) {\n const formData = await c.req.formData();\n const url = formData.get(\"url\") as string;\n\n try {\n const feedUrl = await findFeedUrl(url);\n return c.redirect(`/feeds/subscribe?url=${encodeURIComponent(feedUrl)}`);\n } catch (error) {\n const message = error instanceof Error ? error.message : \"Unknown error\";\n return c.html(`

Error finding feed: ${message}

`, 500);\n }\n}\n\nexport async function handleGetFeedSubscribeForm(c: Context) {\n const url = c.req.query(\"url\") || \"\";\n\n const styles = ``;\n\n const body = `\n

Subscribe to a Feed

← Back to Posts

\n \n `;\n\n return c.html(renderPageLayout('Subscribe to Feed', styles, body));\n}\n\nexport async function handleFeedSubscribe(c: Context) {\n const formData = await c.req.formData();\n const url = formData.get(\"url\") as string;\n\n try {\n await addSubscription(url);\n return c.redirect(\"/feeds\");\n } catch (error) {\n const message = error instanceof Error ? error.message : \"Unknown error\";\n return c.html(`

Error subscribing to feed: ${message}

`, 500);\n }\n}",[],[276],{"_103":285,"_95":286,"_152":287,"_154":-5,"_155":137,"_156":288,"_158":159,"_105":289,"_100":290,"_161":162,"_163":291,"_165":22,"_166":-5,"_167":292,"_98":293},"5956f21c-ba6c-11f0-a5e7-0224a6c84d84","index.html","d118df78-b8b8-11f0-bab9-0224a6c84d84",265,["D",1762363496645],13,"\n\n \n \n \n \n Home\n \n \n

Welcome

\n \n\n",[],[286],{"_103":295,"_95":296,"_152":297,"_154":-5,"_155":137,"_156":298,"_158":159,"_105":299,"_100":300,"_161":186,"_163":301,"_165":22,"_166":-5,"_167":302,"_98":303},"f93b99b8-b8eb-11f0-9f49-0224a6c84d84","lounge.ts","090f8e4a-b8e6-11f0-b76d-0224a6c84d84",135,["D",1762198408660],25,"import { Context } from \"https://esm.sh/hono\";\n\n// Helper function to get API key\nfunction getApiKey(): string {\n const API_KEY = Deno.env.get(\"LOUNGE\");\n\n if (!API_KEY) {\n throw new Error(\"LOUNGE environment variable is required\");\n }\n\n return API_KEY;\n}\n\n// API functions - exported for use in API and handlers\n\nexport async function getDiscussions() {\n const API_KEY = getApiKey();\n\n const response = await fetch(\"https://thebaseballlounge.com/public/api/discussions\", {\n headers: {\n \"Authorization\": `Token ${API_KEY}`,\n },\n });\n\n if (!response.ok) {\n throw new Error(`API request failed: ${response.status}`);\n }\n\n const rawResponse = await response.text();\n const discussions = JSON.parse(rawResponse);\n\n // Check if discussions is an array or has a data property that is an array\n return Array.isArray(discussions) ? discussions : (discussions.data || []);\n}\n\nexport async function getThreadPosts(id: number): Promise {\n const API_KEY = getApiKey();\n\n const response = await fetch(`https://thebaseballlounge.com/public/api/discussions/${id}`, {\n headers: {\n \"Authorization\": `Token ${API_KEY}`,\n },\n });\n\n if (!response.ok) {\n throw new Error(`Thread API request failed: ${response.status}`);\n }\n\n const threadData = await response.json();\n\n // Extract post IDs from the relationships.posts.data array\n const postIds = threadData.data.relationships.posts.data.map((post: { id: number }) => post.id);\n\n return postIds;\n}\n\nexport async function getThreadPostsInRange(id: number, startPost: number) {\n const API_KEY = getApiKey();\n\n // Get all post IDs for the thread\n const allPostIds = await getThreadPosts(id);\n\n // Slice the list of post IDs from startPost to startPost+19\n const rangePostIds = allPostIds.slice(startPost, startPost + 20);\n\n // If no posts in the range, return empty\n if (rangePostIds.length === 0) {\n return { posts: [], users: new Map(), totalPosts: allPostIds.length, pageSize: 20 };\n }\n\n // Join post IDs with commas for the API request\n const postIdsParam = rangePostIds.join(\",\");\n\n // Fetch posts for the specified range\n const response = await fetch(`https://thebaseballlounge.com/public/api/posts?filter[id]=${postIdsParam}`, {\n headers: {\n \"Authorization\": `Token ${API_KEY}`,\n },\n });\n\n if (!response.ok) {\n throw new Error(`Posts API request failed: ${response.status}`);\n }\n\n const postsData = await response.json();\n\n // Create a map of user IDs to display names\n const usersMap = new Map();\n\n // Filter and map users from the included array\n if (postsData.included) {\n postsData.included\n .filter((included: { type: string }) => included.type === \"users\")\n .forEach((user: { id: string; attributes: { displayName: string } }) => {\n usersMap.set(user.id, user.attributes.displayName);\n });\n }\n\n return {\n posts: postsData.data,\n users: usersMap,\n totalPosts: allPostIds.length,\n pageSize: 20\n };\n}\n\nexport async function getSinglePost(postId: number) {\n const API_KEY = getApiKey();\n\n const response = await fetch(`https://thebaseballlounge.com/public/api/posts/${postId}`, {\n headers: {\n \"Authorization\": `Token ${API_KEY}`,\n },\n });\n\n if (!response.ok) {\n throw new Error(`Post API request failed: ${response.status}`);\n }\n\n const postData = await response.json();\n\n // Create a map of user IDs to display names\n const usersMap = new Map();\n\n // Filter and map users from the included array\n if (postData.included) {\n postData.included\n .filter((included: { type: string }) => included.type === \"users\")\n .forEach((user: { id: string; attributes: { displayName: string } }) => {\n usersMap.set(user.id, user.attributes.displayName);\n });\n }\n\n return {\n post: postData.data,\n users: usersMap\n };\n}\n\nexport async function submitPost(threadId: string, content: string): Promise {\n const API_KEY = getApiKey();\n\n if (!content || content.trim() === \"\") {\n throw new Error(\"Post content cannot be empty\");\n }\n\n const payload = {\n data: {\n type: \"posts\",\n attributes: {\n content: content.trim(),\n },\n relationships: {\n discussion: {\n data: {\n type: \"discussions\",\n id: threadId,\n },\n },\n },\n },\n };\n\n const response = await fetch(\"https://thebaseballlounge.com/public/api/posts\", {\n method: \"POST\",\n headers: {\n \"Authorization\": `Token ${API_KEY}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(payload),\n });\n\n if (!response.ok) {\n const errorText = await response.text();\n throw new Error(`API request failed: ${response.status} - ${errorText}`);\n }\n\n console.log(\"Post submitted successfully\");\n}\n\n// Render HTML page layout\nfunction renderPageLayout(title: string, styles: string, body: string): string {\n return `\n \n \n \n \n \n ${title}\n \n \n \n \n ${body}\n \n \n `;\n}\n\n// Route handlers\n\n// GET /lounge - Display all discussions\nexport async function handleGetLounge(c: Context) {\n try {\n const discussions = await getDiscussions();\n\n const styles = `\n table { width: 100%; }\n `;\n\n const body = `\n

Lounge Discussions

Back to Home

\n \n \n \n \n \n \n \n ${discussions.map((d: any) => `\n \n \n \n `).join(\"\")}\n \n

Discussion Title
\n \n ${d.attributes?.title \|\| d.title \|\| \"Untitled Discussion\"}\n \n

\n `;\n\n return c.html(renderPageLayout('Lounge', styles, body));\n } catch (error) {\n const message = error instanceof Error ? error.message : \"Unknown error\";\n return c.html(`

Error fetching discussions: ${message}

`, 500);\n }\n}\n\n// GET /lounge/:thread/:first - Display thread posts\nexport async function handleGetThreadPosts(c: Context) {\n const id = parseInt(c.req.param(\"thread\"));\n const startPost = parseInt(c.req.param(\"first\"));\n\n try {\n const { posts, users, totalPosts, pageSize } = await getThreadPostsInRange(id, startPost);\n\n if (posts.length === 0) {\n return c.html(renderPageLayout('Lounge', '', '

No posts found in this range.

'));\n }\n\n // Calculate page links\n const pageLinks = [];\n for (let i = 0; i < totalPosts; i += pageSize) {\n pageLinks.push(`${i}-${Math.min(i + pageSize, totalPosts)}`);\n }\n\n const styles = `\n .post { margin-bottom: 20px; padding: 15px; border: 1px solid #ddd; border-radius: 4px; }\n .post-author { font-weight: bold; margin-bottom: 10px; }\n .post-content { margin-top: 10px; }\n .page-nav { margin: 20px 0; }\n .page-nav ul { list-style: none; padding: 0; }\n .page-nav li { display: inline; margin-right: 10px; }\n .create-post-btn { background-color: #28a745; color: white; padding: 10px 20px; text-decoration: none; border-radius: 4px; display: inline-block; margin-bottom: 20px; }\n `;\n\n // Calculate the last page start position\n const lastPageStart = Math.floor((totalPosts - 1) / pageSize) * pageSize;\n\n const body = `\n

Thread Discussion

\n ← Back to Discussions\n | Last Page\n

\n\n Create New Post\n\n ${posts.map((post: any) => {\n const userId = post.relationships.user.data.id;\n const userName = users.get(userId) || \"Unknown User\";\n const postId = post.id;\n\n // Process content to convert PostMention links to local post pages\n let contentHtml = post.attributes.contentHtml;\n contentHtml = contentHtml.replace(\n /]*?\\s+)?href=\"[^\"]*\"([^>]*?\\s+)?class=\"PostMention\"([^>]*?\\s+)?data-id=\"(\\d+)\"([^>]*)>(.*?)<\\/a>/g,\n (_match: string, _1: string, _2: string, _3: string, dataId: string, rest: string, linkText: string) => {\n return `${linkText}`;\n }\n );\n\n return `\n

\n ${userName}\n [reply]\n

${contentHtml}

\n `;\n }).join(\"\")}\n\n

Page Navigation:

${link}

\n `;\n\n return c.html(renderPageLayout('Lounge', styles, body));\n } catch (error) {\n const message = error instanceof Error ? error.message : \"Unknown error\";\n return c.html(`

Error fetching thread posts: ${message}

`, 500);\n }\n}\n\n// GET /lounge/:thread/post - Show post form\nexport async function handleGetPostForm(c: Context) {\n const threadId = c.req.param(\"thread\");\n const replyToPostId = c.req.query(\"reply\");\n const replyToUser = c.req.query(\"user\");\n\n // Pre-populate content if this is a reply\n let defaultContent = \"\";\n if (replyToPostId && replyToUser) {\n defaultContent = `@\"${replyToUser}\"#p${replyToPostId} `;\n }\n\n const styles = `\n textarea { width: 100%; padding: 10px; border: 1px solid #ccc; border-radius: 4px; }\n button { background-color: #007bff; color: white; padding: 10px 20px; border: none; border-radius: 4px; cursor: pointer; }\n .cancel-btn { margin-left: 10px; padding: 10px 20px; background-color: #6c757d; color: white; text-decoration: none; border-radius: 4px; display: inline-block; }\n `;\n\n const body = `\n

${replyToPostId ? 'Reply to Post' : 'Create New Post'}

\n \n `;\n\n return c.html(renderPageLayout(replyToPostId ? 'Reply to Post' : 'Create Post', styles, body));\n}\n\n// POST /lounge/:thread/post - Submit post\nexport async function handleSubmitPost(c: Context) {\n const threadId = c.req.param(\"thread\");\n const formData = await c.req.formData();\n const content = formData.get(\"content\") as string;\n\n try {\n await submitPost(threadId, content);\n return c.redirect(`/lounge/${threadId}/0`);\n } catch (error) {\n const message = error instanceof Error ? error.message : \"Unknown error\";\n return c.html(`

Error submitting post: ${message}

`, 500);\n }\n}\n\n// GET /lounge/post/:postId - Display single post\nexport async function handleGetSinglePost(c: Context) {\n const postId = parseInt(c.req.param(\"postId\"));\n\n try {\n const { post, users } = await getSinglePost(postId);\n\n const userId = post.relationships.user.data.id;\n const userName = users.get(userId) || \"Unknown User\";\n\n // Process content to convert PostMention links to local post pages\n let processedContentHtml = post.attributes.contentHtml;\n processedContentHtml = processedContentHtml.replace(\n /]*?\\s+)?href=\"[^\"]*\"([^>]*?\\s+)?class=\"PostMention\"([^>]*?\\s+)?data-id=\"(\\d+)\"([^>]*)>(.*?)<\\/a>/g,\n (_match: string, _1: string, _2: string, _3: string, dataId: string, rest: string, linkText: string) => {\n return `${linkText}`;\n }\n );\n\n const styles = `\n .post { margin-bottom: 20px; padding: 15px; border: 1px solid #ddd; border-radius: 4px; }\n .post-author { font-weight: bold; margin-bottom: 10px; }\n .post-content { margin-top: 10px; }\n `;\n\n const body = `\n

Post #${postId}

← Back to Discussions

\n\n

${userName}

${processedContentHtml}

\n `;\n\n return c.html(renderPageLayout('Post', styles, body));\n } catch (error) {\n const message = error instanceof Error ? error.message : \"Unknown error\";\n return c.html(`

Error fetching post: ${message}

`, 500);\n }\n}\n",[],[296],{"_103":305,"_95":306,"_152":307,"_154":-5,"_155":137,"_156":308,"_158":159,"_105":309,"_100":310,"_161":186,"_163":311,"_165":22,"_166":-5,"_167":312,"_98":313},"01dfff04-b997-11f0-b4f3-0224a6c84d84","notes.ts","9f74530a-b8bb-11f0-8a08-0224a6c84d84",196,["D",1762271867101],27,"import { Context } from \"https://esm.sh/hono\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Initialize tables\nexport async function initializeNotesDatabase() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS notes (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n content TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS notes_tags (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n note_id INTEGER NOT NULL,\n tag TEXT NOT NULL,\n FOREIGN KEY (note_id) REFERENCES notes(id) ON DELETE CASCADE\n )\n `);\n}\n\n// Helper function to extract tags from last line\nfunction extractTags(content: string): { cleanContent: string; tags: string[] } {\n // Remove trailing blank lines first\n const lines = content.trim().split('\\n').filter(line => line.trim());\n\n if (lines.length === 0) {\n return { cleanContent: '', tags: [] };\n }\n\n const lastLine = lines[lines.length - 1];\n\n if (lastLine.startsWith('#')) {\n const tags = lastLine.match(/#\\w+/g)?.map(tag => tag.substring(1)) || [];\n const cleanContent = lines.slice(0, -1).join('\\n');\n return { cleanContent, tags };\n }\n\n return { cleanContent: lines.join('\\n'), tags: [] };\n}\n\n// Helper function to render gemtext to HTML\nfunction renderGemtext(text: string): string {\n const lines = text.split('\\n');\n let html = '';\n\n for (const line of lines) {\n if (line.startsWith('# ')) {\n html += `

${line.substring(2)}

`;\n } else if (line.startsWith('## ')) {\n html += `

${line.substring(3)}

`;\n } else if (line.startsWith('### ')) {\n html += `

${line.substring(4)}

`;\n } else if (line.startsWith('* ')) {\n html += `

${line.substring(2)}

`;\n } else if (line.startsWith('=>')) {\n const parts = line.substring(2).trim().split(/\\s+/, 2);\n const url = parts[0];\n const label = parts[1] || url;\n html += `

${label}

`;\n } else if (line.startsWith('> ')) {\n html += `

${line.substring(2)}

`;\n } else if (line.trim() === '') {\n html += '
';\n } else {\n html += `

${line}

`;\n }\n }\n\n return html;\n}\n\n// Render HTML page layout\nfunction renderPageLayout(title: string, styles: string, body: string): string {\n return `\n \n \n \n \n \n ${title}\n \n \n \n \n \n ${body}\n \n \n `;\n}\n\n// Render the notes list page\nfunction renderNotesListPage(notesTableRows: string): string {\n const styles = `\n table { width: 100%; }\n td:first-child { width: auto; }\n td:last-child { width: 1%; text-align: right; white-space: nowrap; }\n textarea { width: 100%; min-height: 100px; }\n form { display: inline-block; margin: 0; }\n button { margin: 0 2px; }\n `;\n\n const body = `\n

Notes

\n Back to Home |\n Search\n

\n\n \n\n

All Notes

\n \n \n \n \n \n \n \n \n ${notesTableRows}\n \n

Note

\n `;\n\n return renderPageLayout('Notes', styles, body);\n}\n\n// Render the search page\nfunction renderSearchPage(notesTableRows: string, searchQuery: string): string {\n const styles = `\n table { width: 100%; }\n td:first-child { width: auto; }\n td:last-child { width: 1%; text-align: right; white-space: nowrap; }\n input[type=\"text\"] { width: 100%; max-width: 500px; }\n `;\n\n const body = `\n

Search Notes

Back to Notes

\n\n \n\n ${searchQuery ? `\n

Search results for \"${searchQuery}\"

\n \n \n \n \n \n \n \n \n ${notesTableRows}\n \n

Note

\n ` : ''}\n `;\n\n return renderPageLayout('Search Notes', styles, body);\n}\n\n// Render the edit note page\nfunction renderEditNotePage(id: string, content: string): string {\n const styles = `\n textarea { width: 100%; min-height: 200px; }\n `;\n\n const body = `\n

Edit Note

\n \n `;\n\n return renderPageLayout('Edit Note', styles, body);\n}\n\n// Render the tag filter page\nfunction renderTagFilterPage(tag: string, notesTableRows: string): string {\n const styles = `\n table { width: 100%; }\n td:first-child { width: auto; }\n td:last-child { width: 1%; text-align: right; white-space: nowrap; }\n `;\n\n const body = `\n

Notes tagged #${tag}

Back to All Notes

\n\n \n \n \n \n \n \n \n \n ${notesTableRows}\n \n

Note

\n `;\n\n return renderPageLayout(`Notes tagged #${tag}`, styles, body);\n}\n\n// Database operations - exported for use in API\n\nexport async function getAllNotes() {\n const notes = await sqlite.execute(\"SELECT * FROM notes ORDER BY created_at DESC\");\n return notes.rows;\n}\n\nexport async function getNoteById(id: string | number) {\n const result = await sqlite.execute(\"SELECT * FROM notes WHERE id = ?\", [id]);\n return result.rows.length > 0 ? result.rows[0] : null;\n}\n\nexport async function createNote(content: string, tags: string[]) {\n const result = await sqlite.execute(\n \"INSERT INTO notes (content) VALUES (?)\",\n [content]\n );\n\n const noteId = result.lastInsertRowid;\n\n if (noteId !== undefined) {\n for (const tag of tags) {\n await sqlite.execute(\n \"INSERT INTO notes_tags (note_id, tag) VALUES (?, ?)\",\n [Number(noteId), tag]\n );\n }\n }\n\n return noteId;\n}\n\nexport async function updateNote(id: string | number, content: string, tags: string[]) {\n await sqlite.execute(\n \"UPDATE notes SET content = ? WHERE id = ?\",\n [content, id]\n );\n\n await sqlite.execute(\"DELETE FROM notes_tags WHERE note_id = ?\", [id]);\n for (const tag of tags) {\n await sqlite.execute(\n \"INSERT INTO notes_tags (note_id, tag) VALUES (?, ?)\",\n [id, tag]\n );\n }\n}\n\nexport async function deleteNote(id: string | number) {\n await sqlite.execute(\"DELETE FROM notes_tags WHERE note_id = ?\", [id]);\n await sqlite.execute(\"DELETE FROM notes WHERE id = ?\", [id]);\n}\n\nexport async function searchNotes(query: string) {\n const result = await sqlite.execute(`\n SELECT * FROM notes\n WHERE content LIKE ?\n ORDER BY created_at DESC\n `, [`%${query}%`]);\n return result.rows;\n}\n\nexport async function getNotesByTag(tag: string) {\n const result = await sqlite.execute(`\n SELECT n.* FROM notes n\n INNER JOIN notes_tags nt ON n.id = nt.note_id\n WHERE nt.tag = ?\n ORDER BY n.created_at DESC\n `, [tag]);\n return result.rows;\n}\n\nexport async function getNoteTags(noteId: string | number) {\n const tagsResult = await sqlite.execute(\n \"SELECT tag FROM notes_tags WHERE note_id = ?\",\n [Number(noteId)]\n );\n return tagsResult.rows.map(row => String(row.tag));\n}\n\n// Helper to build note table rows with tags\nasync function buildNoteTableRows(notes: any[]): Promise {\n let notesTableRows = '';\n\n for (const note of notes) {\n const renderedContent = renderGemtext(String(note.content || ''));\n const tags = await getNoteTags(note.id);\n\n // Render tags as links\n const tagsHtml = tags.length > 0\n ? `

\n ${tags.map(tag => `#${tag}`).join('')}\n

`\n : '';\n\n notesTableRows += `\n \n ${renderedContent}${tagsHtml}\n \n \n \n \n \n `;\n }\n\n return notesTableRows;\n}\n\n// Export extractTags for use in API\nexport { extractTags };\n\n// GET /notes - Display all notes\nexport async function handleGetNotes(c: Context) {\n const notes = await getAllNotes();\n const notesTableRows = await buildNoteTableRows(notes);\n return c.html(renderNotesListPage(notesTableRows));\n}\n\n// POST /notes - Create a new note\nexport async function handleCreateNote(c: Context) {\n const body = await c.req.parseBody();\n const content = body.content as string;\n\n const { cleanContent, tags } = extractTags(content);\n await createNote(cleanContent, tags);\n\n return c.redirect(\"/notes\");\n}\n\n// GET /notes/:id/delete - Delete a note\nexport async function handleDeleteNote(c: Context) {\n const id = c.req.param(\"id\");\n await deleteNote(id);\n return c.redirect(\"/notes\");\n}\n\n// GET /notes/:id/edit - Show edit form\nexport async function handleEditNoteForm(c: Context) {\n const id = c.req.param(\"id\");\n const note = await getNoteById(id);\n\n if (!note) {\n return c.redirect(\"/notes\");\n }\n\n return c.html(renderEditNotePage(id, String(note.content || '')));\n}\n\n// POST /notes/:id/update - Update a note\nexport async function handleUpdateNote(c: Context) {\n const id = c.req.param(\"id\");\n const body = await c.req.parseBody();\n const content = body.content as string;\n\n const { cleanContent, tags } = extractTags(content);\n await updateNote(id, cleanContent, tags);\n\n return c.redirect(\"/notes\");\n}\n\n// GET /notes/search - Search notes\nexport async function handleSearchNotes(c: Context) {\n const query = c.req.query('q') || '';\n\n if (!query.trim()) {\n return c.html(renderSearchPage('', ''));\n }\n\n const notes = await searchNotes(query);\n const notesTableRows = await buildNoteTableRows(notes);\n return c.html(renderSearchPage(notesTableRows, query));\n}\n\n// GET /tags/:tag - Display all notes with a specific tag\nexport async function handleGetNotesByTag(c: Context) {\n const tag = c.req.param(\"tag\");\n const notes = await getNotesByTag(tag);\n const notesTableRows = await buildNoteTableRows(notes);\n return c.html(renderTagFilterPage(tag, notesTableRows));\n}\n",[],[306],{"_103":315,"_95":316,"_152":317,"_154":-5,"_155":137,"_156":318,"_158":159,"_105":319,"_100":185,"_161":195,"_163":320,"_165":22,"_166":-5,"_167":321,"_98":322},"98966874-ba6f-11f0-92e7-0224a6c84d84","soxScoreCron.ts","8ed28d5e-ba6f-11f0-938c-0224a6c84d84",267,["D",1762364891248],"// This val will fetch the previous day's Boston Red Sox game results from the MLB API\n// and send a notification with the final score to a ntfy.sh topic if a game was played.\n\nasync function sendNtfyNotification(topic: string, message: string, title: string) {\n const url = `https://ntfy.sh/${topic}`;\n const response = await fetch(url, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"title\": title,\n \"tags\": \"baseball\",\n \"Click\": \"https://plaintextsports.com/#mlb\",\n },\n body: message,\n });\n\n if (!response.ok) {\n throw new Error(`Failed to send notification: ${response.statusText}`);\n }\n}\n\nasync function checkRedSoxGame() {\n const yesterday = new Date();\n yesterday.setDate(yesterday.getDate() - 1);\n const dateString = yesterday.toISOString().split(\"T\")[0];\n\n const response = await fetch(`https://statsapi.mlb.com/api/v1/schedule?sportId=1&date=${dateString}&teamId=111`);\n const data = await response.json();\n\n if (data.dates.length > 0 && data.dates[0].games.length > 0) {\n const game = data.dates[0].games[0];\n if (game.status.codedGameState === \"F\") {\n const homeTeam = game.teams.home.team.name;\n const awayTeam = game.teams.away.team.name;\n const homeScore = game.teams.home.score;\n const awayScore = game.teams.away.score;\n\n const message = `Final Score: ${awayTeam} ${awayScore}, ${homeTeam} ${homeScore}`;\n\n await sendNtfyNotification(\n Deno.env.get(\"SOX_SCORE_TOPIC\"),\n message,\n \"Boston Red Sox Game Result\",\n );\n\n return `Notification sent: ${message}`;\n }\n }\n\n return \"No completed game found for yesterday\";\n}\n\nexport default async function server(interval: Interval) {\n try {\n const result = await checkRedSoxGame();\n } catch (error) {\n console.error(\"Error:\", error);\n }\n}",[],[316],{"_103":324,"_95":325,"_152":326,"_154":-5,"_155":137,"_156":327,"_158":159,"_105":328,"_100":329,"_161":186,"_163":330,"_165":22,"_166":-5,"_167":331,"_98":332},"051ae198-b997-11f0-98be-0224a6c84d84","sql.ts","3c4696ac-b8ee-11f0-9c13-0224a6c84d84",202,["D",1762271872515],15,"import { Context } from \"https://esm.sh/hono\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Render HTML page layout\nfunction renderPageLayout(title: string, body: string): string {\n return `\n \n \n \n \n \n ${title}\n \n \n \n ${body}\n \n \n `;\n}\n\n// Database operations - exported for use in API\n\nexport async function executeQuery(query: string) {\n return await sqlite.execute(query);\n}\n\nexport async function getTables() {\n const tablesResult = await sqlite.execute(`\n SELECT name FROM sqlite_master\n WHERE type='table' AND name NOT LIKE 'sqlite_%'\n ORDER BY name\n `);\n return tablesResult.rows || [];\n}\n\n// Route handlers\n\nexport async function handleGetSql(c: Context) {\n const query = c.req.query(\"q\");\n\n try {\n let queryResult: any = null;\n let queryError: string | null = null;\n\n // If there's a query parameter, execute it\n if (query) {\n try {\n queryResult = await executeQuery(query);\n } catch (error) {\n queryError = error instanceof Error ? error.message : \"Unknown error\";\n }\n }\n\n const tables = await getTables();\n\n const body = `\n

SQLite Query Interface

← Back to Home

\n\n

SQL Query

\n\n ${queryError ? `\n

\n Error: ${queryError}\n

\n ` : \"\"}\n\n ${queryResult ? `\n

Query Results

\n ${queryResult.rows && queryResult.rows.length > 0 ? `\n \n \n \n ${queryResult.columns ? queryResult.columns.map((col: string) => ``).join(\"\") : \"\"}\n \n \n \n ${queryResult.rows.map((row: any) => `\n \n ${Array.isArray(row)\n ? row.map(cell => ``).join(\"\")\n : Object.values(row).map(cell => ``).join(\"\")\n }\n \n `).join(\"\")}\n \n

${col}
${cell !== null ? cell : \"NULL\"}	${cell !== null ? cell : \"NULL\"}

\n ${queryResult.rows.length} row(s) returned\n

\n ` : `\n

Query executed successfully. No rows returned.

\n `}\n

\n ` : \"\"}\n\n ${!query ? `\n

Available Tables

Below are all the tables in the SQLite database:

\n\n ${tables.length > 0 ? `\n \n \n \n \n \n \n \n ${tables.map((row: any) => `\n \n \n \n `).join(\"\")}\n \n

Table Name
${row[0] \|\| row.name}

\n ` : `\n

\n No tables found in the database.\n

\n `}\n

\n ` : \"\"}\n `;\n\n return c.html(renderPageLayout('SQLite Query Interface', body));\n } catch (error) {\n const message = error instanceof Error ? error.message : \"Unknown error\";\n return c.html(`

Error: ${message}

`, 500);\n }\n}",[],[325],{"_103":334,"_95":335,"_152":336,"_154":-5,"_155":137,"_156":337,"_158":159,"_105":338,"_100":32,"_161":186,"_163":339,"_165":22,"_166":-5,"_167":340,"_98":341},"c84a721e-ba5f-11f0-ba63-0224a6c84d84","syncPinsToBookmarksCron.ts","c84a72c8-ba5f-11f0-ba63-0224a6c84d84",256,["D",1762358099334],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n/**\n * Cron job to sync the 'added' timestamps from pins table to bookmarks table\n * for any URLs that appear in both tables.\n *\n * This ensures that if a bookmark exists in pins with an earlier timestamp,\n * the bookmarks table reflects the original pin date.\n */\nexport default async function syncPinsToBookmarks() {\n try {\n console.log(\"Starting pins to bookmarks sync...\");\n\n // Find the intersection of URLs between pins and bookmarks tables\n // and update bookmarks.added with pins.added for matching URLs\n // Convert pins.added from Unix timestamp (milliseconds) to datetime format\n const updateResult = await sqlite.execute(`\n UPDATE bookmarks\n SET added = (\n SELECT datetime(pins.added / 1000, 'unixepoch')\n FROM pins\n WHERE pins.url = bookmarks.url\n )\n WHERE EXISTS (\n SELECT 1\n FROM pins\n WHERE pins.url = bookmarks.url\n )\n `);\n\n console.log(\"Sync completed successfully\");\n console.log(`Update result:`, updateResult);\n\n // Log the count of synced bookmarks for monitoring\n const countResult = await sqlite.execute(`\n SELECT COUNT(*) as synced_count\n FROM bookmarks b\n INNER JOIN pins p ON b.url = p.url\n `);\n\n const syncedCount = countResult.rows[0]?.synced_count || 0;\n console.log(`Total URLs present in both pins and bookmarks: ${syncedCount}`);\n\n return {\n success: true,\n syncedCount: syncedCount,\n timestamp: new Date().toISOString(),\n };\n } catch (error) {\n console.error(\"Error syncing pins to bookmarks:\", error);\n const message = error instanceof Error ? error.message : \"Unknown error\";\n\n return {\n success: false,\n error: message,\n timestamp: new Date().toISOString(),\n };\n }\n}\n",[],[335],{"_103":343,"_95":344,"_152":345,"_154":-5,"_155":137,"_156":346,"_158":159,"_105":347,"_100":348,"_161":186,"_163":349,"_165":22,"_166":-5,"_167":350,"_98":351},"02035850-b997-11f0-bb3a-0224a6c84d84","todos.ts","16ee367e-b8be-11f0-8ba5-0224a6c84d84",200,["D",1762271867327],14,"import { Context } from \"https://esm.sh/hono\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Initialize tables\nexport async function initializeTodosDatabase() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS todos (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n text TEXT NOT NULL,\n done INTEGER DEFAULT 0,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS todos_tags (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n todo_id INTEGER NOT NULL,\n tag TEXT NOT NULL,\n FOREIGN KEY (todo_id) REFERENCES todos(id) ON DELETE CASCADE\n )\n `);\n}\n\n// Helper function to extract tags from last line\nfunction extractTags(content: string): { lines: string[]; tags: string[] } {\n const allLines = content.trim().split('\\n').filter(line => line.trim());\n\n if (allLines.length === 0) {\n return { lines: [], tags: [] };\n }\n\n const lastLine = allLines[allLines.length - 1];\n\n if (lastLine.startsWith('#')) {\n const tags = lastLine.match(/#\\w+/g)?.map(tag => tag.substring(1)) || [];\n const lines = allLines.slice(0, -1);\n return { lines, tags };\n }\n\n return { lines: allLines, tags: [] };\n}\n\n// Render HTML page layout\nfunction renderPageLayout(title: string, styles: string, body: string): string {\n return `\n \n \n \n \n \n ${title}\n \n \n \n \n \n ${body}\n \n \n `;\n}\n\n// Render todos table\nfunction renderTodosTable(todosTableRows: string): string {\n return `\n \n \n \n \n \n \n \n \n \n ${todosTableRows}\n \n

	Todo

\n `;\n}\n\n// Render the todos list page\nfunction renderTodosListPage(todosTableRows: string): string {\n const styles = `\n table { width: 100%; }\n td:first-child { width: 1%; text-align: center; white-space: nowrap; }\n td:nth-child(2) { width: auto; }\n td:last-child { width: 1%; text-align: right; white-space: nowrap; }\n .done { text-decoration: line-through; color: #888; }\n `;\n\n const body = `\n

Todos

Back to Home

\n\n \n\n

All Todos

\n ${renderTodosTable(todosTableRows)}\n `;\n\n return renderPageLayout('Todos', styles, body);\n}\n\n// Render the edit todo page\nfunction renderEditTodoPage(id: string, text: string): string {\n const styles = `\n input[type=\"text\"] { width: 100%; }\n `;\n\n const body = `\n

Edit Todo

\n \n `;\n\n return renderPageLayout('Edit Todo', styles, body);\n}\n\n// Render the tag filter page\nfunction renderTodosTagFilterPage(tag: string, todosTableRows: string): string {\n const styles = `\n table { width: 100%; }\n td:first-child { width: 1%; text-align: center; white-space: nowrap; }\n td:nth-child(2) { width: auto; }\n td:last-child { width: 1%; text-align: right; white-space: nowrap; }\n .done { text-decoration: line-through; color: #888; }\n `;\n\n const body = `\n

Todos tagged #${tag}

Back to All Todos

\n\n ${renderTodosTable(todosTableRows)}\n `;\n\n return renderPageLayout(`Todos tagged #${tag}`, styles, body);\n}\n\n// Database operations - exported for use in API\n\nexport async function getAllTodos() {\n const todos = await sqlite.execute(\"SELECT * FROM todos ORDER BY done ASC, created_at DESC\");\n return todos.rows;\n}\n\nexport async function getTodoById(id: string | number) {\n const result = await sqlite.execute(\"SELECT * FROM todos WHERE id = ?\", [id]);\n return result.rows.length > 0 ? result.rows[0] : null;\n}\n\nexport async function createTodo(text: string, tags: string[]) {\n const result = await sqlite.execute(\n \"INSERT INTO todos (text, done) VALUES (?, 0)\",\n [text]\n );\n\n const todoId = result.lastInsertRowid;\n\n if (todoId !== undefined) {\n for (const tag of tags) {\n await sqlite.execute(\n \"INSERT INTO todos_tags (todo_id, tag) VALUES (?, ?)\",\n [Number(todoId), tag]\n );\n }\n }\n\n return todoId;\n}\n\nexport async function updateTodo(id: string | number, text?: string, done?: boolean, tags?: string[]) {\n if (text !== undefined) {\n await sqlite.execute(\n \"UPDATE todos SET text = ? WHERE id = ?\",\n [text, id]\n );\n }\n\n if (done !== undefined) {\n await sqlite.execute(\n \"UPDATE todos SET done = ? WHERE id = ?\",\n [done ? 1 : 0, id]\n );\n }\n\n if (tags !== undefined) {\n await sqlite.execute(\"DELETE FROM todos_tags WHERE todo_id = ?\", [id]);\n for (const tag of tags) {\n await sqlite.execute(\n \"INSERT INTO todos_tags (todo_id, tag) VALUES (?, ?)\",\n [id, tag]\n );\n }\n }\n}\n\nexport async function toggleTodo(id: string | number) {\n await sqlite.execute(\n \"UPDATE todos SET done = CASE WHEN done = 0 THEN 1 ELSE 0 END WHERE id = ?\",\n [id]\n );\n}\n\nexport async function deleteTodo(id: string | number) {\n await sqlite.execute(\"DELETE FROM todos_tags WHERE todo_id = ?\", [id]);\n await sqlite.execute(\"DELETE FROM todos WHERE id = ?\", [id]);\n}\n\nexport async function getTodosByTag(tag: string) {\n const result = await sqlite.execute(`\n SELECT t.* FROM todos t\n INNER JOIN todos_tags tt ON t.id = tt.todo_id\n WHERE tt.tag = ?\n ORDER BY t.done ASC, t.created_at DESC\n `, [tag]);\n return result.rows;\n}\n\nexport async function getTodoTags(todoId: string | number) {\n const tagsResult = await sqlite.execute(\n \"SELECT tag FROM todos_tags WHERE todo_id = ?\",\n [Number(todoId)]\n );\n return tagsResult.rows.map(row => String(row.tag));\n}\n\n// Helper to build todo table rows with tags\nasync function buildTodoTableRows(todos: any[]): Promise {\n let todosTableRows = '';\n\n for (const todo of todos) {\n const isDone = todo.done === 1;\n const todoClass = isDone ? 'done' : '';\n const tags = await getTodoTags(todo.id);\n\n // Render tags as links (inline)\n const tagsHtml = tags.length > 0\n ? ` ${tags.map(tag => `#${tag}`).join('')}`\n : '';\n\n todosTableRows += `\n \n \n \n \n \n ${String(todo.text || '')}${tagsHtml}\n \n \n \n \n \n \n `;\n }\n\n return todosTableRows;\n}\n\n// Export extractTags for use in API\nexport { extractTags };\n\n// GET /todos - Display all todos\nexport async function handleGetTodos(c: Context) {\n const todos = await getAllTodos();\n const todosTableRows = await buildTodoTableRows(todos);\n return c.html(renderTodosListPage(todosTableRows));\n}\n\n// POST /todos - Create new todos\nexport async function handleCreateTodos(c: Context) {\n const body = await c.req.parseBody();\n const content = body.content as string;\n\n const { lines, tags } = extractTags(content);\n\n // Insert each line as a separate todo\n for (const line of lines) {\n if (line.trim()) {\n await createTodo(line.trim(), tags);\n }\n }\n\n return c.redirect(\"/todos\");\n}\n\n// GET /todos/:id/toggle - Toggle todo done status\nexport async function handleToggleTodo(c: Context) {\n const id = c.req.param(\"id\");\n await toggleTodo(id);\n return c.redirect(\"/todos\");\n}\n\n// GET /todos/:id/delete - Delete a todo\nexport async function handleDeleteTodo(c: Context) {\n const id = c.req.param(\"id\");\n await deleteTodo(id);\n return c.redirect(\"/todos\");\n}\n\n// GET /todos/:id/edit - Show edit form\nexport async function handleEditTodoForm(c: Context) {\n const id = c.req.param(\"id\");\n const todo = await getTodoById(id);\n\n if (!todo) {\n return c.redirect(\"/todos\");\n }\n\n return c.html(renderEditTodoPage(id, String(todo.text || '')));\n}\n\n// POST /todos/:id/update - Update a todo\nexport async function handleUpdateTodo(c: Context) {\n const id = c.req.param(\"id\");\n const body = await c.req.parseBody();\n const text = body.text as string;\n\n await updateTodo(id, text);\n return c.redirect(\"/todos\");\n}\n\n// GET /todos/tags/:tag - Display all todos with a specific tag\nexport async function handleGetTodosByTag(c: Context) {\n const tag = c.req.param(\"tag\");\n const todos = await getTodosByTag(tag);\n const todosTableRows = await buildTodoTableRows(todos);\n return c.html(renderTodosTagFilterPage(tag, todosTableRows));\n}\n",[],[344],{"_103":353,"_95":354,"_152":355,"_154":-5,"_155":137,"_156":356,"_158":159,"_105":357,"_100":358,"_161":359,"_163":360,"_165":22,"_166":-5,"_167":361,"_98":362},"29a0cda4-ba6c-11f0-83f8-0224a6c84d84","val.ts","23aabe42-b8b8-11f0-b639-0224a6c84d84",264,["D",1762363416598],68,"http","import { Hono } from \"https://esm.sh/hono\";\nimport { basicAuth } from \"https://esm.sh/hono/basic-auth\";\nimport { HTTPException } from \"https://esm.sh/hono/http-exception\";\nimport { readFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { blob } from \"https://esm.town/v/std/blob\";\nimport {\n initializeNotesDatabase,\n handleGetNotes,\n handleCreateNote,\n handleDeleteNote,\n handleEditNoteForm,\n handleUpdateNote,\n handleSearchNotes,\n handleGetNotesByTag,\n} from \"./notes.ts\";\nimport {\n initializeTodosDatabase,\n handleGetTodos,\n handleCreateTodos,\n handleToggleTodo,\n handleDeleteTodo,\n handleEditTodoForm,\n handleUpdateTodo,\n handleGetTodosByTag,\n} from \"./todos.ts\";\nimport {\n initializeBookmarksDatabase,\n handleGetBookmarks,\n handleAddBookmarkForm,\n handleAddBookmark,\n handleDeleteConfirmation,\n handleDeleteConfirm,\n handleFindRss,\n handleSubscribe,\n handleGetEditBookmarkForm,\n handleUpdateBookmark,\n handleGetSearchBookmarks,\n handleSearchBookmarksPost,\n} from \"./bookmarks.ts\";\nimport {\n initializeDinocomicsDatabase,\n handleGetDinocomics,\n handleReadComic,\n handleRefreshComics,\n} from \"./dinocomics.ts\";\nimport {\n handleGetLounge,\n handleGetThreadPosts,\n handleGetPostForm,\n handleSubmitPost,\n handleGetSinglePost,\n} from \"./lounge.ts\";\nimport {\n initializeBudgetDatabase,\n handleGetBudget,\n handleGetSpendForm,\n handleUpdateBudget,\n} from \"./budget.ts\";\nimport {\n handleGetSql,\n} from \"./sql.ts\";\nimport {\n initializeBugsDatabase,\n handleGetBugsList,\n handleGetAllBugs,\n handleGetBug,\n handleGetProjects,\n handleGetProject,\n handleGetNewBugForm,\n handleCreateBug,\n handleCloseBug,\n handleWontfixBug,\n} from \"./bugs.ts\";\nimport {\n initializeFeedsDatabase,\n handleGetFeeds,\n handleGetPosts,\n handleGetFindForm,\n handleFindFeed,\n handleGetFeedSubscribeForm,\n handleFeedSubscribe,\n} from \"./feeds.ts\";\nimport {\n handleGetWikipedia,\n} from \"./wp.ts\";\nimport {\n apiGetNotes,\n apiCreateNote,\n apiGetNote,\n apiUpdateNote,\n apiDeleteNote,\n apiSearchNotes,\n apiGetNotesByTag,\n apiGetTodos,\n apiCreateTodos,\n apiGetTodo,\n apiToggleTodo,\n apiUpdateTodo,\n apiDeleteTodo,\n apiGetTodosByTag,\n apiGetBookmarks,\n apiCreateBookmark,\n apiGetBookmark,\n apiDeleteBookmark,\n apiGetDinocomics,\n apiGetDinocomic,\n apiMarkComicRead,\n apiRefreshDinocomics,\n} from \"./api.ts\";\n\nconst app = new Hono();\n\n// Initialize databases\nawait initializeNotesDatabase();\nawait initializeTodosDatabase();\nawait initializeBookmarksDatabase();\nawait initializeDinocomicsDatabase();\nawait initializeBudgetDatabase();\nawait initializeBugsDatabase();\nawait initializeFeedsDatabase();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n if (err instanceof HTTPException) {\n return err.getResponse();\n }\n return c.notFound();\n});\n\n// Add basic authentication middleware\napp.use(\n \"*\",\n basicAuth({\n username: Deno.env.get(\"USER\"),\n password: Deno.env.get(\"PASS\"),\n }),\n);\n\napp.get(\"/\", async (c) => {\n const html = await readFile(\"./index.html\", import.meta.url);\n return c.html(html);\n});\n\napp.get(\"/weather\", async (c) => {\n const html = await readFile(\"./weather.html\", import.meta.url);\n return c.html(html);\n});\n\napp.get(\"/weather.json\", async (c) => {\n let weather = await blob.get(Deno.env.get(\"WEATHER_BLOB\"));\n return c.html(weather.text());\n});\n\n// Notes routes\napp.get(\"/notes/search\", handleSearchNotes);\napp.get(\"/notes/tags/:tag\", handleGetNotesByTag);\napp.get(\"/notes/:id/delete\", handleDeleteNote);\napp.get(\"/notes/:id/edit\", handleEditNoteForm);\napp.post(\"/notes/:id/update\", handleUpdateNote);\napp.get(\"/notes\", handleGetNotes);\napp.post(\"/notes\", handleCreateNote);\n\n// Todos routes\napp.get(\"/todos\", handleGetTodos);\napp.post(\"/todos\", handleCreateTodos);\napp.get(\"/todos/:id/toggle\", handleToggleTodo);\napp.get(\"/todos/:id/delete\", handleDeleteTodo);\napp.get(\"/todos/:id/edit\", handleEditTodoForm);\napp.post(\"/todos/:id/update\", handleUpdateTodo);\napp.get(\"/todos/tags/:tag\", handleGetTodosByTag);\n\n// Bookmarks routes\napp.get(\"/bookmarks\", handleGetBookmarks);\napp.get(\"/bookmarks/form\", handleAddBookmarkForm);\napp.get(\"/bookmarks/add\", handleAddBookmark);\napp.get(\"/bookmarks/edit\", handleGetEditBookmarkForm);\napp.post(\"/bookmarks/edit\", handleUpdateBookmark);\napp.get(\"/bookmarks/search\", handleGetSearchBookmarks);\napp.post(\"/bookmarks/search\", handleSearchBookmarksPost);\napp.get(\"/bookmarks/delete\", handleDeleteConfirmation);\napp.get(\"/bookmarks/delete/confirm\", handleDeleteConfirm);\napp.get(\"/bookmarks/find-rss\", handleFindRss);\napp.get(\"/bookmarks/subscribe\", handleSubscribe);\n\n// Dinocomics routes\napp.get(\"/dinocomics\", handleGetDinocomics);\napp.get(\"/dinocomics/refresh\", handleRefreshComics);\napp.get(\"/dinocomics/:comic\", handleReadComic);\n\n// Lounge routes\napp.get(\"/lounge\", handleGetLounge);\napp.get(\"/lounge/post/:postId\", handleGetSinglePost);\napp.get(\"/lounge/:thread/post\", handleGetPostForm);\napp.post(\"/lounge/:thread/post\", handleSubmitPost);\napp.get(\"/lounge/:thread/:first\", handleGetThreadPosts);\n\n// Budget routes\napp.get(\"/budget\", handleGetBudget);\napp.get(\"/budget/spend\", handleGetSpendForm);\napp.post(\"/budget/update-budget\", handleUpdateBudget);\n\n// SQL routes\napp.get(\"/sql\", handleGetSql);\n\n// Bugs routes\napp.get(\"/bugs\", handleGetBugsList);\napp.get(\"/bugs/all\", handleGetAllBugs);\napp.get(\"/bugs/new\", handleGetNewBugForm);\napp.post(\"/bugs/new\", handleCreateBug);\napp.get(\"/bugs/projects\", handleGetProjects);\napp.get(\"/bugs/projects/:name\", handleGetProject);\napp.get(\"/bugs/bug/:id\", handleGetBug);\napp.get(\"/bugs/close/:id\", handleCloseBug);\napp.get(\"/bugs/wontfix/:id\", handleWontfixBug);\n\n// Feeds routes\napp.get(\"/feeds\", handleGetPosts);\napp.get(\"/feeds/subscriptions\", handleGetFeeds);\napp.get(\"/feeds/find\", handleGetFindForm);\napp.post(\"/feeds/find\", handleFindFeed);\napp.get(\"/feeds/subscribe\", handleGetFeedSubscribeForm);\napp.post(\"/feeds/subscribe\", handleFeedSubscribe);\n\n// Wikipedia route\napp.get(\"/wp\", handleGetWikipedia);\n\n// API Routes - Notes\napp.get(\"/api/notes\", apiGetNotes);\napp.post(\"/api/notes\", apiCreateNote);\napp.get(\"/api/notes/search\", apiSearchNotes);\napp.get(\"/api/notes/tags/:tag\", apiGetNotesByTag);\napp.get(\"/api/notes/:id\", apiGetNote);\napp.put(\"/api/notes/:id\", apiUpdateNote);\napp.patch(\"/api/notes/:id\", apiUpdateNote);\napp.delete(\"/api/notes/:id\", apiDeleteNote);\n\n// API Routes - Todos\napp.get(\"/api/todos\", apiGetTodos);\napp.post(\"/api/todos\", apiCreateTodos);\napp.get(\"/api/todos/tags/:tag\", apiGetTodosByTag);\napp.get(\"/api/todos/:id\", apiGetTodo);\napp.post(\"/api/todos/:id/toggle\", apiToggleTodo);\napp.put(\"/api/todos/:id\", apiUpdateTodo);\napp.patch(\"/api/todos/:id\", apiUpdateTodo);\napp.delete(\"/api/todos/:id\", apiDeleteTodo);\n\n// API Routes - Bookmarks\napp.get(\"/api/bookmarks\", apiGetBookmarks);\napp.post(\"/api/bookmarks\", apiCreateBookmark);\napp.get(\"/api/bookmarks/get\", apiGetBookmark);\napp.delete(\"/api/bookmarks\", apiDeleteBookmark);\n\n// API Routes - Dinocomics\napp.get(\"/api/dinocomics\", apiGetDinocomics);\napp.get(\"/api/dinocomics/:number\", apiGetDinocomic);\napp.post(\"/api/dinocomics/:number/read\", apiMarkComicRead);\napp.post(\"/api/dinocomics/refresh\", apiRefreshDinocomics);\n\nexport default app.fetch;\n",[],[354],{"_103":364,"_95":365,"_152":366,"_154":-5,"_155":137,"_156":367,"_158":159,"_105":368,"_100":32,"_161":162,"_163":369,"_165":22,"_166":-5,"_167":370,"_98":371},"0a9127a4-b8f2-11f0-a107-0224a6c84d84","weather.html","0a91284e-b8f2-11f0-a107-0224a6c84d84",178,["D",1762201014727],"\n \n Salem Weather\n \n \n \n \n \n

Salem Weather

Temp & Dew Pt.

Wind Speed

Precip Chance

\n \n",[],[365],{"_103":373,"_95":374,"_152":375,"_154":-5,"_155":137,"_156":376,"_158":159,"_105":377,"_100":185,"_161":195,"_163":378,"_165":22,"_166":-5,"_167":379,"_98":380},"d28a51e2-b8f0-11f0-9ece-0224a6c84d84","weatherCron.ts","c71c1192-b8f0-11f0-a907-0224a6c84d84",165,["D",1762200491222],"const marked = await import(\"npm:marked\");\nimport { blob } from \"https://esm.town/v/std/blob\";\n\nfunction celsiusToFahrenheit(celsius: number): number {\n return (celsius * 9 / 5) + 32;\n}\n\nfunction parseWindSpeed(windSpeed: string): number {\n const match = windSpeed.match(/(\\d+)/);\n return match ? parseInt(match[1], 10) : 0;\n}\n\nexport default async function server(interval: Interval) {\n const lat = 42.5184;\n const lon = -70.8976;\n const url = `https://api.weather.gov/points/${lat},${lon}`;\n\n try {\n const response = await fetch(url);\n const data = await response.json();\n const forecastUrl = data.properties.forecastHourly;\n const textUrl = data.properties.forecast;\n const forecastResponse = await fetch(forecastUrl);\n const textResponse = await fetch(textUrl);\n const validatedData = await forecastResponse.json();\n const textData = await textResponse.json();\n console.log(validatedData);\n console.log(textData);\n\n const processedData = {\n t: [],\n temp: [],\n dew: [],\n wind: [],\n rain: [],\n forecast: \"\",\n };\n\n validatedData.properties.periods.forEach(period => {\n processedData.t.push(period.startTime);\n processedData.temp.push(period.temperature);\n processedData.dew.push(celsiusToFahrenheit(period.dewpoint.value));\n processedData.wind.push(parseWindSpeed(period.windSpeed));\n processedData.rain.push(period.probabilityOfPrecipitation.value ?? 0);\n });\n\n textData.properties.periods.forEach(period => {\n const day = period.name;\n const w = period.detailedForecast;\n const s = `\\n* **${day}** - ${w}`;\n processedData.forecast = processedData.forecast + s;\n });\n processedData.forecast = await marked.parse(processedData.forecast);\n console.log(processedData);\n blob.setJSON(Deno.env.get(\"WEATHER_BLOB\"), processedData);\n } catch (error) {\n console.error(\"Error fetching weather data:\", error);\n }\n}",[],[374],{"_103":382,"_95":383,"_152":384,"_154":-5,"_155":137,"_156":136,"_158":159,"_105":385,"_100":185,"_161":195,"_163":386,"_165":22,"_166":-5,"_167":387,"_98":388},"4dfe6f24-ba73-11f0-a756-0224a6c84d84","weatherNtfyCron.ts","2e5a307c-ba73-11f0-ba4c-0224a6c84d84",["D",1762366484082],"// This val will fetch the weather forecast for Salem, MA from the US National Weather Service,\n// extract the earliest prediction, and send it to a ntfy.sh channel.\n// We'll use the NWS API for weather data and the ntfy.sh API for notifications.\n\nexport default async function server(interval: Interval) {\n // Fetch weather data from NWS API\n const response = await fetch(\"https://api.weather.gov/gridpoints/BOX/70,76/forecast\");\n const data = await response.json();\n\n // Extract the earliest prediction\n const earliestPrediction = data.properties.periods[0];\n const forecastText = `${earliestPrediction.detailedForecast}`;\n\n // Send notification to ntfy.sh\n await fetch(\"https://ntfy.sh/\" + Deno.env.get(\"MORNING_WEATHER_TOPIC\"), {\n method: \"POST\",\n body: forecastText,\n headers: {\n \"Content-Type\": \"text/plain\",\n \"Click\": \"https://emvee.rocks/weather\",\n \"Title\": \"Today's Weather Forecast\",\n \"Tags\": \"weather\",\n },\n });\n}",[],[383],{"_103":390,"_95":391,"_152":392,"_154":-5,"_155":137,"_156":393,"_158":159,"_105":394,"_100":157,"_161":186,"_163":395,"_165":22,"_166":-5,"_167":396,"_98":397},"1ad9ef1c-ba6c-11f0-80ce-0224a6c84d84","wp.ts","764207aa-ba6b-11f0-8685-0224a6c84d84",262,["D",1762363391804],"import { Context } from \"https://esm.sh/hono\";\n\ninterface WikipediaPage {\n pageid: number;\n title: string;\n extract?: string;\n}\n\ninterface WikipediaResponse {\n query?: {\n pages?: WikipediaPage[];\n };\n}\n\nasync function fetchRandomWikipediaArticle(): Promise<{ title: string; extract: string; pageId: number } | null> {\n try {\n const response = await fetch('https://en.wikipedia.org/w/api.php?action=query&format=json&prop=extracts&meta=&generator=random&formatversion=2&exsentences=1&explaintext=1&grnnamespace=0');\n\n if (!response.ok) {\n throw new Error('Network response was not ok');\n }\n\n const data: WikipediaResponse = await response.json();\n\n if (data.query && data.query.pages && data.query.pages.length > 0) {\n const page = data.query.pages[0];\n return {\n title: page.title,\n extract: page.extract || 'No extract available for this article.',\n pageId: page.pageid\n };\n }\n\n return null;\n } catch (error) {\n console.error('Error fetching Wikipedia article:', error);\n return null;\n }\n}\n\nexport async function handleGetWikipedia(c: Context) {\n const article = await fetchRandomWikipediaArticle();\n \n if (!article) {\n // Error state HTML\n const errorHtml = `\n\n\n \n \n Random Wikipedia Article - Error\n \n \n \n \n\n\n

Oops! Something went wrong

Unable to fetch a Wikipedia article. Please try again.

\n Try Again\n

\n\n`;\n \n return c.html(errorHtml, 500);\n }\n\n // Success state HTML with article data\n const html = `\n\n\n \n \n ${article.title} - Random Wikipedia Article\n \n \n \n \n\n\n

${article.title}

${article.extract}

\n \n \n \n \n \n
\n Get Another Article\n

\n\n`;\n\n return c.html(html);\n}",[],[391],"files",[149,170,179,190,199,209,218,227,237,246,256,265,274,284,294,304,314,323,333,342,352,363,372,381,389],"counts",{"_402":32,"_403":185,"_404":32,"_405":406},"pulls","branches","forks","envVars",{"_407":233,"_408":32},"count","emptyCount","contents",[],{"_103":191,"_155":137,"_152":192,"_95":99,"_163":196,"_161":195,"_100":157,"_154":-5,"_105":412,"_156":193,"_166":-5,"_98":413},["D",1762356606318],[99],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_93":94,"_95":96,"_97":43,"_98":99,"_101":422,"_162":427,"_430":431,"_448":449,"_455":-7,"_456":32,"_457":22},{"_103":104,"_95":96,"_105":423,"_107":-5,"_108":22,"_109":110,"_111":72,"_112":-5,"_14":113,"_114":-5,"_115":22,"_116":-5,"_117":32,"_16":118,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_23":424,"_131":425,"_134":426,"_146":22},["D",1762175885300],{"_93":94,"_129":130},{"_93":94,"_133":130,"_14":113},{"_100":136,"_95":43,"_103":137,"_138":104,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":96,"_145":94},{"_103":191,"_95":99,"_152":192,"_154":-5,"_155":137,"_156":193,"_158":159,"_105":428,"_100":157,"_161":195,"_163":196,"_165":22,"_166":-5,"_98":429},["D",1762356606318],[99],"history",[432,434,439,444],{"_103":191,"_155":137,"_152":192,"_95":99,"_163":196,"_161":195,"_100":157,"_154":-5,"_105":433,"_156":193,"_166":-5},["D",1762356606318],{"_103":435,"_155":137,"_152":192,"_95":99,"_163":436,"_161":195,"_100":174,"_154":-5,"_105":437,"_156":438,"_166":-5},"4959a46e-ba5c-11f0-9fd9-0224a6c84d84","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport * as cheerio from \"https://esm.sh/cheerio@1.0.0-rc.12\";\n\nconst TABLE_NAME = \"bookmarks\";\n\n// Extract server component (hostname) from a URL\nfunction getServerComponent(url: string): string {\n try {\n const urlObj = new URL(url);\n return urlObj.hostname;\n } catch (error) {\n return '';\n }\n}\n\n// Search function using DuckDuckGo HTML\nasync function searchDuckDuckGo(query: string, targetServer: string) {\n const url = `https://html.duckduckgo.com/html/?q=${encodeURIComponent(query)}`;\n\n const response = await fetch(url, {\n headers: {\n 'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36'\n }\n });\n\n const html = await response.text();\n const $ = cheerio.load(html);\n\n // Parse all results\n const results = $('.result');\n\n if (results.length === 0) {\n return null;\n }\n\n // Look for a result that matches the target server\n for (let i = 0; i < results.length; i++) {\n const result = results.eq(i);\n const link = result.find('.result__a').attr('href');\n const snippet = result.find('.result__snippet').text().trim();\n\n if (link && snippet) {\n const resultServer = getServerComponent(link);\n if (resultServer === targetServer) {\n return snippet;\n }\n }\n }\n\n // No matching server found\n return null;\n}\n\n// Get bookmarks with blank summaries\nasync function getBookmarksWithoutSummary(limit: number = 3) {\n const result = await sqlite.execute(\n `SELECT url, title FROM ${TABLE_NAME} WHERE summary IS NULL OR summary = '' ORDER BY added DESC LIMIT ?`,\n [limit]\n );\n return result.rows;\n}\n\n// Update bookmark summary (without touching timestamp)\nasync function updateBookmarkSummary(url: string, summary: string) {\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} SET summary = ? WHERE url = ?`,\n [summary, url]\n );\n}\n\n// Main cron function\nexport default async function() {\n console.log(\"Starting bookmark summary update cron...\");\n\n try {\n // Get 3 most recent bookmarks with blank summaries\n const bookmarks = await getBookmarksWithoutSummary(3);\n\n console.log(`Found ${bookmarks.length} bookmarks without summaries`);\n\n for (const bookmark of bookmarks) {\n const url = String(bookmark[0]);\n const title = String(bookmark[1]);\n\n console.log(`Processing bookmark: ${title} - ${url}`);\n\n try {\n // Search for \"{TITLE} {URL}\"\n const query = `${title} ${url}`;\n const snippet = await searchDuckDuckGo(query);\n\n if (snippet) {\n // Update the summary field\n await updateBookmarkSummary(url, snippet);\n console.log(`Updated summary for ${url}: ${snippet.substring(0, 50)}...`);\n } else {\n console.log(`No search results found for ${url}`);\n }\n\n // Add a small delay to avoid rate limiting\n await new Promise(resolve => setTimeout(resolve, 2000));\n } catch (error) {\n console.error(`Error processing bookmark ${url}:`, error);\n }\n }\n\n console.log(\"Bookmark summary update cron completed\");\n } catch (error) {\n console.error(\"Error in bookmark summary cron:\", error);\n }\n}\n",["D",1762356597871],241,{"_103":440,"_155":137,"_152":192,"_95":99,"_163":441,"_161":195,"_100":185,"_154":-5,"_105":442,"_156":443,"_166":-5},"fd5c8cda-ba5a-11f0-bc42-0224a6c84d84","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport * as cheerio from \"https://esm.sh/cheerio@1.0.0-rc.12\";\n\nconst TABLE_NAME = \"bookmarks\";\n\n// Search function using DuckDuckGo HTML\nasync function searchDuckDuckGo(query: string) {\n const url = `https://html.duckduckgo.com/html/?q=${encodeURIComponent(query)}`;\n\n const response = await fetch(url, {\n headers: {\n 'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36'\n }\n });\n\n const html = await response.text();\n const $ = cheerio.load(html);\n\n // Parse the first result\n const firstResult = $('.result').first();\n\n if (firstResult.length === 0) {\n return null;\n }\n\n const snippet = firstResult.find('.result__snippet').text().trim();\n return snippet;\n}\n\n// Get bookmarks with blank summaries\nasync function getBookmarksWithoutSummary(limit: number = 3) {\n const result = await sqlite.execute(\n `SELECT url, title FROM ${TABLE_NAME} WHERE summary IS NULL OR summary = '' ORDER BY added DESC LIMIT ?`,\n [limit]\n );\n return result.rows;\n}\n\n// Update bookmark summary (without touching timestamp)\nasync function updateBookmarkSummary(url: string, summary: string) {\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} SET summary = ? WHERE url = ?`,\n [summary, url]\n );\n}\n\n// Main cron function\nexport default async function() {\n console.log(\"Starting bookmark summary update cron...\");\n\n try {\n // Get 3 most recent bookmarks with blank summaries\n const bookmarks = await getBookmarksWithoutSummary(3);\n\n console.log(`Found ${bookmarks.length} bookmarks without summaries`);\n\n for (const bookmark of bookmarks) {\n const url = String(bookmark[0]);\n const title = String(bookmark[1]);\n\n console.log(`Processing bookmark: ${title} - ${url}`);\n\n try {\n // Search for \"{TITLE} {URL}\"\n const query = `${title} ${url}`;\n const snippet = await searchDuckDuckGo(query);\n\n if (snippet) {\n // Update the summary field\n await updateBookmarkSummary(url, snippet);\n console.log(`Updated summary for ${url}: ${snippet.substring(0, 50)}...`);\n } else {\n console.log(`No search results found for ${url}`);\n }\n\n // Add a small delay to avoid rate limiting\n await new Promise(resolve => setTimeout(resolve, 2000));\n } catch (error) {\n console.error(`Error processing bookmark ${url}:`, error);\n }\n }\n\n console.log(\"Bookmark summary update cron completed\");\n } catch (error) {\n console.error(\"Error in bookmark summary cron:\", error);\n }\n}\n",["D",1762356040871],234,{"_103":445,"_155":137,"_152":192,"_95":99,"_163":441,"_161":186,"_100":32,"_154":-5,"_105":446,"_156":447,"_166":-5},"bff9a49a-ba5a-11f0-9ca8-0224a6c84d84",["D",1762355937901],233,"versions",[450,452,453,454],{"_162":432,"_451":434},"previous",{"_162":434,"_451":439},{"_162":439,"_451":444},{"_162":444,"_451":-5},"versionNumber","page","hasNext","actionData","errors"]

Hi

My Bookmarks

Add Bookmark

Delete Bookmark

Confirm Deletion

${bookmark.title || \"Untitled\"}

Bookmark Added!

Bookmark Deleted

RSS Feed Discovery

Source URL

Error

RSS Feed Found

Recent Articles

${article.title}

No RSS Feed Found

Subscription Added!

Edit Bookmark

Search Bookmarks

Search Results

Error

Error

Bookmark Not Found

Error

Error

Bookmark Not Found

Error

Error

Error

Spend Budget

Bug Tracker

Bug Tracker

Bug #${id}

Description

Projects

Project: ${name}

Create New Bug

Dino Comics

Comics Refreshed

Error

RSS Subscriptions

RSS Posts

Find a Feed for a URL

Subscribe to a Feed

Welcome

Lounge Discussions

Thread Discussion

Page Navigation:

${replyToPostId ? 'Reply to Post' : 'Create New Post'}

Post #${postId}

${line.substring(2)}

${line.substring(3)}

${line.substring(4)}

Notes

All Notes

Search Notes

Search results for \"${searchQuery}\"

Edit Note

Notes tagged #${tag}

SQLite Query Interface

SQL Query

Query Results

Available Tables

Todos

All Todos

Edit Todo

Todos tagged #${tag}

Salem Weather

Temp & Dew Pt.

Wind Speed

Precip Chance

Oops! Something went wrong

${article.title}

flymaster

lifehub

History for bookmarkSummaryCron.ts