that contains span.icon-dat; the text after the span is the date\n let pubDate = \"\";\n $post.find(\".utility-list li\").each((_j, li) => {\n const $li = $(li);\n if ($li.find(\".icon-dat\").length) {\n // Remove the icon span, grab the remaining text\n const $clone = $li.clone();\n $clone.find(\"span\").remove();\n const dateText = $clone.text().trim();\n if (dateText) pubDate = parseDate(dateText);\n }\n });\n if (!pubDate) return;\n\n // --- Category ---\n // Prefer the link text inside .utility-info (human-readable, properly cased)\n let category: string | null = $post.find('.utility-info a[href*=\"/category/\"]').first().text().trim() || null;\n\n // Fallback: extract from post div's class list: \"category-city-news\" → \"City News\"\n if (!category) {\n const classStr = $post.attr(\"class\") || \"\";\n const catMatch = classStr.match(/\\bcategory-([\\w-]+)/);\n if (catMatch && catMatch[1] !== \"uncategorized\") {\n category = titleCase(catMatch[1]);\n }\n }\n\n // --- Description / excerpt ---\n // After .utility-info, the remaining text in the content column is the excerpt.\n // Clone the content column, remove the h3 and utility-info, then grab text.\n const $contentCol = $post.find(\".col-12.col-md-6\").not(\".mx-auto\").last();\n const $clone = $contentCol.clone();\n $clone.find(\"h3, .utility-info, a.btn, a[href$='#']\").remove();\n const description = $clone.text().trim().replace(/\\s+/g, \" \") || null;\n\n entries.push({\n slug,\n title,\n category,\n pubDate,\n description: description || null,\n link,\n });\n });\n\n console.log(`Parsed ${entries.length} news entries`);\n return entries;\n}\n\n/**\n * Upsert news entries into SQLite.\n * Returns count of rows affected.\n */\nexport async function upsertEntries(entries: NewsEntry[]): Promise {\n if (entries.length === 0) return 0;\n\n const statements = entries.map((entry) => ({\n sql: `INSERT INTO blog_entries (slug, title, category, pub_date, description, link)\n VALUES (?, ?, ?, ?, ?, ?)\n ON CONFLICT(slug) DO UPDATE SET\n title = excluded.title,\n category = excluded.category,\n pub_date = excluded.pub_date,\n description = excluded.description,\n link = excluded.link,\n updated_at = datetime('now')`,\n args: [entry.slug, entry.title, entry.category, entry.pubDate, entry.description, entry.link] as (\n | string\n | null\n )[],\n }));\n\n const results = await sqlite.batch(statements);\n const totalAffected = results.reduce((sum, r) => sum + (r.rowsAffected ?? 0), 0);\n return totalAffected;\n}\n\n/**\n * Full scrape + store pipeline. Returns summary.\n */\nexport async function scrapeAndStore(): Promise {\n const entries = await fetchNewsEntries();\n const count = await upsertEntries(entries);\n const msg = `Scraped ${entries.length} entries, upserted ${count}`;\n console.log(msg);\n return msg;\n}\n","deleted","label",[133],"92e70296-586a-11f1-93db-ee650bb23af1","rss.ts","019e6077-6bdc-76de-82b1-db49734e5bd4",3,["D",1779735017946],1,"// RSS feed generator — reads news entries from SQLite and serves RSS 2.0 XML.\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst FEED_TITLE = \"Sanford Springvale News\";\nconst FEED_DESCRIPTION = \"Nonprofit local news for Sanford & Springvale, Maine\";\nconst FEED_LINK = \"https://sanfordspringvalenews.com/\";\n\n/**\n * Escape XML special characters.\n */\nfunction escapeXml(str: string): string {\n return str\n .replace(/&/g, \"&\")\n .replace(//g, \">\")\n .replace(/\"/g, \""\")\n .replace(/'/g, \"'\");\n}\n\n/**\n * Generate RSS 2.0 XML from stored news entries.\n */\nexport async function generateRss(feedUrl: string): Promise {\n const result = await sqlite.execute(\n \"SELECT slug, title, category, pub_date, description, link FROM blog_entries ORDER BY pub_date DESC LIMIT 50\",\n );\n\n const items = result.rows\n .map((row) => {\n const title = escapeXml(String(row.title ?? \"\"));\n const link = escapeXml(String(row.link ?? \"\"));\n const description = row.description ? escapeXml(String(row.description)) : \"\";\n const category = row.category ? `${escapeXml(String(row.category))}` : \"\";\n const pubDate = row.pub_date ? new Date(String(row.pub_date)).toUTCString() : \"\";\n const guid = escapeXml(String(row.link ?? row.slug ?? \"\"));\n\n return ` \n ${title}\n ${link}\n ${description}\n ${category}\n ${pubDate}\n ${guid}\n `;\n })\n .join(\"\\n\");\n\n const lastBuildDate = new Date().toUTCString();\n\n return `\n\n \n ${escapeXml(FEED_TITLE)}\n ${escapeXml(FEED_LINK)}\n ${escapeXml(FEED_DESCRIPTION)}\n en-us\n ${lastBuildDate}\n \n${items}\n \n`;\n}\n",[151],"4c69fef4-586a-11f1-a080-ee650bb23af1","main.ts","019e6077-6bdc-76de-82b1-d47868632f62",["D",1779734899620],"// Database initialization script — run once to set up the schema.\n// Can be re-run safely (uses IF NOT EXISTS).\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS blog_entries (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n slug TEXT UNIQUE NOT NULL,\n title TEXT NOT NULL,\n category TEXT,\n pub_date TEXT NOT NULL,\n description TEXT,\n link TEXT NOT NULL,\n created_at TEXT DEFAULT (datetime('now')),\n updated_at TEXT DEFAULT (datetime('now'))\n )\n`);\n\nawait sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_blog_entries_pub_date ON blog_entries(pub_date DESC)\n`);\n\nawait sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_blog_entries_slug ON blog_entries(slug)\n`);\n\nconsole.log(\"✅ Database schema initialized\");\n",[159],"9b3eae3a-586a-11f1-9d99-ee650bb23af1","feed.ts",4,["D",1779735031930],"http","// HTTP endpoint — serves the RSS feed and a simple landing page.\nimport { generateRss } from \"./rss.ts\";\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\n\nexport default async function(req: Request): Promise {\n const url = new URL(req.url);\n const feedUrl = `${url.origin}/feed`;\n\n // Serve RSS feed at /feed or /rss\n if (url.pathname === \"/feed\" || url.pathname === \"/rss\") {\n const xml = await generateRss(feedUrl);\n return new Response(xml, {\n headers: {\n \"Content-Type\": \"application/rss+xml; charset=utf-8\",\n \"Cache-Control\": \"public, max-age=3600\",\n },\n });\n }\n\n // Source redirect\n if (url.pathname === \"/source\") {\n const { links } = parseVal();\n return new Response(null, { status: 302, headers: { Location: links.self.val } });\n }\n\n // Landing page at root\n const { links } = parseVal();\n const html = `\n\n\n \n \n Sanford Springvale News — RSS Feed\n \n \n\n\n

📰

Sanford Springvale News

\n An unofficial RSS feed for\n sanfordspringvalenews.com —\n nonprofit local news for Sanford & Springvale, Maine.\n Updated hourly.\n

\n\n

RSS Feed URL:

\n ${feedUrl}\n

\n\n

\n \n 📡 View RSS Feed\n \n \n 🔗 View Source\n \n

\n\n

\n Not affiliated with Sanford Springvale News. Scrapes the public homepage hourly.\n

\n \n\n`;\n\n return new Response(html, {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n}\n",[165],"4c69da5a-586a-11f1-a080-ee650bb23af1","cron.ts","019e6077-6bdc-76de-82b1-cd510e6bb76a",["D",1779734899620],"interval","// Daily scraper cron — runs once per day to fetch and store new AISI blog entries.\nimport { scrapeAndStore } from \"./scraper.ts\";\n\nexport default async function (_interval: Interval) {\n const result = await scrapeAndStore();\n console.log(`[cron] ${new Date().toISOString()} — ${result}`);\n}\n",[172],"4c697e66-586a-11f1-a080-ee650bb23af1","README.md","019e6077-6bdc-76de-82b1-cb0b8f02a36a",["D",1779734899620],"# 📡 AISI Blog RSS Feed\n\nAn unofficial RSS feed for the\n[UK AI Security Institute (AISI) blog](https://www.aisi.gov.uk/blog), which\ndoesn't provide one natively.\n\n## Usage\n\nSubscribe to the feed in your RSS reader:\n\n```\nhttps://hrbrmstr--a9fd1110460d11f1b63242b51c65c3df.web.val.run/feed\n```\n\n## How it works\n\n```mermaid\nflowchart LR\n A[AISI Blog] -->|scrape HTML| B[scraper.ts]\n B -->|upsert| C[(SQLite)]\n D[cron.ts] -->|daily trigger| B\n E[RSS Reader] -->|GET /feed| F[feed.ts]\n F -->|query| C\n F -->|render| G[RSS 2.0 XML]\n G --> E\n```\n\n### Components\n\n| File | Type | Purpose |\n| ------------ | -------- | ---------------------------------------------------------- |\n| `feed.ts` | HTTP | Serves the RSS feed at `/feed` and a landing page at `/` |\n| `cron.ts` | Interval | Runs daily to scrape and store new blog entries |\n| `scraper.ts` | Script | Fetches and parses blog entries from the AISI Webflow site |\n| `rss.ts` | Script | Generates RSS 2.0 XML from stored entries |\n| `main.ts` | Script | One-time database schema initialization |\n\n### Endpoints\n\n- **`/`** — Landing page with feed URL and links\n- **`/feed`** or **`/rss`** — RSS 2.0 XML feed\n- **`/source`** — Redirect to this val's source code\n\n### Scraper details\n\nThe AISI blog is a Webflow site. Each blog card is a\n`div.work-card-wrapper.w-dyn-item` with data fields conveniently marked via\n`fs-list-field` attributes (`title`, `category`, `date`, `description`). The\nscraper uses Cheerio to parse these into structured entries and upserts them\ninto SQLite keyed by slug.\n\n## Not affiliated with AISI",[179],"pulls","forks","envVars",{"_190":56,"_192":56},"connections",{"_190":56,"_191":56},"count","unfilledCount","emptyCount",{"_20":178,"_13":179,"_134":180,"_136":-5,"_137":21,"_138":155,"_140":52,"_22":215,"_29":56,"_143":108,"_145":182,"_147":40,"_148":-5,"_200":216,"_96":217},{"_20":171,"_13":172,"_134":173,"_136":-5,"_137":21,"_138":155,"_140":52,"_22":212,"_29":56,"_143":175,"_145":176,"_147":40,"_148":-5,"_200":213,"_96":214},{"_20":164,"_13":165,"_134":50,"_136":-5,"_137":21,"_138":166,"_140":52,"_22":209,"_29":155,"_143":168,"_145":169,"_147":40,"_148":-5,"_200":210,"_96":211},{"_20":158,"_13":159,"_134":160,"_136":-5,"_137":21,"_138":155,"_140":52,"_22":206,"_29":56,"_143":144,"_145":162,"_147":40,"_148":-5,"_200":207,"_96":208},{"_20":150,"_13":151,"_134":152,"_136":-5,"_137":21,"_138":153,"_140":52,"_22":203,"_29":155,"_143":144,"_145":156,"_147":40,"_148":-5,"_200":204,"_96":205},{"_20":132,"_13":133,"_134":135,"_136":-5,"_137":21,"_138":139,"_140":52,"_22":199,"_29":142,"_143":144,"_145":146,"_147":40,"_148":-5,"_200":201,"_96":202},["D",1779735119793],"children",[],[133],["D",1779735017946],[],[151],["D",1779734899620],[],[159],["D",1779735031930],[],[165],["D",1779734899620],[],[172],["D",1779734899620],[],[179],["D",1779734899620],["D",1789502486629],{"_11":12,"_94":90},{"_11":12,"_88":-5,"_89":90,"_47":48,"_91":92,"_93":40},{"_29":30,"_13":26,"_20":21,"_27":28,"_31":32,"_33":34,"_82":42,"_83":84,"_85":58,"_86":14,"_87":12},"ctx",{"_75":-5,"_118":256,"_257":258,"_259":260,"_261":40,"_262":40,"_263":40,"_264":52,"_265":-5,"_266":-7,"_267":-7,"_268":56,"_269":40,"_270":40,"_271":-5,"_272":40,"_273":40,"_274":40,"_275":-5},"ENV",{"_227":228,"_229":230,"_231":26,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Branches1

Branches
1