Feed not found

'), 404);\n }\n\n const feed = feedResult.rows[0];\n const feedUrl = feed[0];\n const feedTitle = feed[1];\n const feedIcon = feed[2];\n const feedOdds = feed[3];\n\n const styles = `\n form { margin: 20px 0; }\n input[type=\"text\"] { width: 100%; max-width: 500px; }\n `;\n\n const body = `\n

Edit Feed

\n ← Back to Subscriptions |\n Show Posts\n

\n\n

Update Feed Title

\n \n\n

Update Icon

\n \n\n

Feed Details

URL: ${feedUrl}

Current Icon: ${Icon[feedIcon] ? Icon[feedIcon]() : feedIcon} ${feedIcon}

Odds: ${feedOdds}

\n\n

Danger Zone

\n \n ${Icon.trash()} Delete Feed\n \n

\n `;\n\n return c.html(renderPageLayout(\"Edit Feed\", styles, body));\n }\n\n // Otherwise show all feeds\n const feeds = await getAllFeedsWithLatestPost();\n\n const styles = `\n table { width: 100%; }\n `;\n\n let tableHtml =\n \"\";\n for (const row of feeds) {\n // We need to get the rowid and icon for the edit link\n const feedUrlForLookup = row[1];\n const feedRowidResult = await sqlite.execute(\n \"SELECT rowid, icon FROM rssSubscriptions WHERE url = ?\",\n [feedUrlForLookup],\n );\n const feedRowid = feedRowidResult.rows[0]?.[0] || '';\n const feedIcon = feedRowidResult.rows[0]?.[1] || 'rss';\n\n tableHtml += ``;\n }\n tableHtml += \"

Icon	Feed	URL	Updated	Odds	Last Post	Actions
${Icon[feedIcon] ? Icon[feedIcon]() : feedIcon}	${row[0]}	${\n row[1]\n }	${row[2]}	${row[3]}	${\n row[4]\n }	${Icon.edit()} ${Icon.trash()}

\";\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 const adminMode = c.req.query(\"admin\") !== undefined;\n const showTitles = c.req.query(\"titles\") !== undefined;\n\n const styles = `\n .posttitle { font-weight: bold; }\n .feedtitle { color: #666; font-size: 0.9em; }\n .admin-link { margin-left: 10px; 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 = \"

${Icon[f[3]] ? Icon[f[3]]() : f[3]}

${iconHtml} ${\n f[1] || f[0]\n } | ${f[2]}${\n adminMode ? `[manage]` : ''\n }
${iconHtml} ${\n f[1] || f[0]\n }${\n adminMode ? `[manage]` : ''\n }

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

RSS Posts

\n ← Back to Home |\n Manage Subscriptions |\n Find Feed |\n Subscribe |\n ${showTitles ? 'Hide' : 'Show'} Feed Titles\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(`/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(\"/\");\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}\n\nexport async function handleBulkSubscribe(c: Context) {\n try {\n const body = await c.req.json();\n const urls = body.urls;\n\n if (!Array.isArray(urls)) {\n return c.json({ error: \"urls must be an array\" }, 400);\n }\n\n const results: Array<{ url: string; success: boolean; error?: string }> =\n [];\n for (const url of urls) {\n try {\n await addSubscription(url);\n results.push({ url, success: true });\n } catch (error) {\n const message = error instanceof Error\n ? error.message\n : \"Unknown error\";\n results.push({ url, success: false, error: message });\n }\n }\n\n return c.json({ results });\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 handleGetSubscriptionsJson(c: Context) {\n try {\n const subs = await sqlite.execute(\n \"SELECT url, title, icon, odds FROM rssSubscriptions\",\n );\n const subscriptions = subs.rows.map((row) => ({\n url: row[0],\n title: row[1],\n icon: row[2],\n odds: row[3],\n }));\n return c.json({ subscriptions });\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 handleDeleteFeed(c: Context) {\n const url = c.req.query(\"url\");\n\n if (!url) {\n return c.html(\"

Error: Feed URL is required

\", 400);\n }\n\n try {\n await deleteFeed(url);\n return c.redirect(\"/subscriptions\");\n } catch (error) {\n const message = error instanceof Error ? error.message : \"Unknown error\";\n return c.html(`

Error deleting feed: ${message}

`, 500);\n }\n}\n\nexport async function handleUpdateFeedTitle(c: Context) {\n const formData = await c.req.formData();\n const rowid = formData.get(\"rowid\") as string;\n const title = formData.get(\"title\") as string;\n\n if (!rowid || !title) {\n return c.html(\"

Error: Feed rowid and title are required

\", 400);\n }\n\n try {\n await sqlite.execute(\n \"UPDATE rssSubscriptions SET title = ? WHERE rowid = ?\",\n [title, rowid],\n );\n return c.redirect(`/subscriptions?rowid=${rowid}`);\n } catch (error) {\n const message = error instanceof Error ? error.message : \"Unknown error\";\n return c.html(`

Error updating feed title: ${message}

`, 500);\n }\n}\n\nexport async function handleUpdateFeedIcon(c: Context) {\n const formData = await c.req.formData();\n const rowid = formData.get(\"rowid\") as string;\n const icon = formData.get(\"icon\") as string;\n\n if (!rowid || !icon) {\n return c.html(\"

Error: Feed rowid and icon are required

\", 400);\n }\n\n try {\n await sqlite.execute(\n \"UPDATE rssSubscriptions SET icon = ? WHERE rowid = ?\",\n [icon, rowid],\n );\n return c.redirect(`/subscriptions?rowid=${rowid}`);\n } catch (error) {\n const message = error instanceof Error ? error.message : \"Unknown error\";\n return c.html(`

Error updating feed icon: ${message}

`, 500);\n }\n}\n\nexport async function handleFindFeedsFromBookmarks(c: Context) {\n const styles = `\n table { width: 100%; }\n .status { font-size: 0.9em; color: #666; }\n .success { color: green; }\n .error { color: red; }\n .feed-url { font-size: 0.9em; word-break: break-all; }\n `;\n\n try {\n // Get bookmarks from the last 6 hours\n const sixHoursAgo = new Date();\n sixHoursAgo.setHours(sixHoursAgo.getHours() - 6);\n const sixHoursAgoStr = sixHoursAgo.toISOString();\n\n const bookmarksResult = await sqlite.execute(\n \"SELECT url, title FROM bookmarks WHERE added >= ? ORDER BY added DESC\",\n [sixHoursAgoStr],\n );\n\n const bookmarks = bookmarksResult.rows;\n\n if (bookmarks.length === 0) {\n const body = `\n

Find Feeds from Recent Bookmarks

← Back to Feeds

No bookmarks found in the last 6 hours.

\n `;\n return c.html(renderPageLayout(\"Find Feeds from Bookmarks\", styles, body));\n }\n\n // Create all feed finding promises in parallel\n const feedPromises = bookmarks.map(async (bookmark) => {\n const bookmarkUrl = String(bookmark[0] || '');\n const bookmarkTitle = String(bookmark[1] || bookmarkUrl);\n\n try {\n const feedUrl = await findFeed(bookmarkUrl);\n return {\n bookmarkUrl,\n bookmarkTitle,\n feedUrl,\n error: null,\n };\n } catch (error) {\n return {\n bookmarkUrl,\n bookmarkTitle,\n feedUrl: null,\n error: error instanceof Error ? error.message : 'Unknown error',\n };\n }\n });\n\n // Wait for all promises to settle (don't fail if some fail)\n const results = await Promise.allSettled(feedPromises);\n\n // Now subscribe to all found feeds\n const subscribedFeeds: Array<{ title: string; url: string }> = [];\n const failedSubscriptions: Array<{ url: string; error: string }> = [];\n let feedsFound = 0;\n let noFeedFound = 0;\n\n for (const result of results) {\n if (result.status === 'fulfilled') {\n const { bookmarkUrl, bookmarkTitle, feedUrl, error } = result.value;\n\n if (feedUrl) {\n feedsFound++;\n // Try to subscribe to this feed\n try {\n await addSubscription(feedUrl);\n\n // Get the feed title from the database (addSubscription stores it)\n const feedResult = await sqlite.execute(\n \"SELECT title FROM rssSubscriptions WHERE url = ?\",\n [feedUrl],\n );\n const feedTitle = feedResult.rows[0]?.[0] || feedUrl;\n\n subscribedFeeds.push({\n title: String(feedTitle),\n url: feedUrl\n });\n } catch (error) {\n const errorMsg = error instanceof Error ? error.message : 'Unknown error';\n failedSubscriptions.push({ url: feedUrl, error: errorMsg });\n }\n } else {\n noFeedFound++;\n }\n }\n }\n\n // Build summary\n let summaryHtml = `\n

Summary

${Icon['circle-check']()} Scanned ${bookmarks.length} bookmark${bookmarks.length === 1 ? '' : 's'} from the last 6 hours

${Icon['circle-check']()} Found ${feedsFound} feed${feedsFound === 1 ? '' : 's'}

${Icon['circle-check']()} Successfully subscribed to ${subscribedFeeds.length} feed${subscribedFeeds.length === 1 ? '' : 's'}

\n `;\n\n if (failedSubscriptions.length > 0) {\n summaryHtml += `

${Icon['circle-minus']()} Failed to subscribe to ${failedSubscriptions.length} feed${failedSubscriptions.length === 1 ? '' : 's'}

`;\n }\n\n if (noFeedFound > 0) {\n summaryHtml += `

${Icon['circle-minus']()} ${noFeedFound} bookmark${noFeedFound === 1 ? '' : 's'} had no feed

`;\n }\n\n summaryHtml += `

`;\n\n // List subscribed feeds\n if (subscribedFeeds.length > 0) {\n summaryHtml += `\n

Subscribed Feeds

${Icon['circle-check']()} ${feed.title}
${feed.url}

`;\n }\n\n // List failed subscriptions if any\n if (failedSubscriptions.length > 0) {\n summaryHtml += `\n

Failed Subscriptions

${Icon['circle-minus']()} ${failed.url}
Error: ${failed.error}

`;\n }\n\n const body = `\n

Find Feeds from Recent Bookmarks

← Back to Feeds | View Subscriptions

\n ${summaryHtml}\n `;\n\n return c.html(renderPageLayout(\"Find Feeds from Bookmarks\", styles, body));\n } catch (error) {\n const message = error instanceof Error ? error.message : \"Unknown error\";\n const body = `\n

Find Feeds from Recent Bookmarks

← Back to Feeds

Error: ${message}

\n `;\n return c.html(renderPageLayout(\"Find Feeds from Bookmarks\", styles, body), 500);\n }\n}\n\n// Configure routes\napp.get(\"/\", handleGetPosts);\napp.get(\"/subscriptions\", handleGetFeeds);\napp.get(\"/subs/json\", handleGetSubscriptionsJson);\napp.get(\"/find\", handleGetFindForm);\napp.post(\"/find\", handleFindFeed);\napp.get(\"/subscribe\", handleGetFeedSubscribeForm);\napp.post(\"/subscribe\", handleFeedSubscribe);\napp.post(\"/suball\", handleBulkSubscribe);\napp.get(\"/delete\", handleDeleteFeed);\napp.post(\"/update-title\", handleUpdateFeedTitle);\napp.post(\"/update-icon\", handleUpdateFeedIcon);\napp.get(\"/from-bookmarks\", handleFindFeedsFromBookmarks);\n\nexport default app.fetch;","deleted","label","rssfeeds",[100],"permalink","https://www.val.town/x/flymaster/rss/code/feeds.ts","extension","actionData","errors"]