\n \n \n \n );\n}\n",[18,67],"e1580b50-cb53-4fa4-94fe-f5ff9e3e45d4",["D",1787213870303],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\n\nconst KIND_LABEL: Record = { movie: \"🎬 Movie\", tv: \"📺 TV Show\", game: \"🎮 Game\" };\n\ninterface WatchItem {\n id: number;\n kind: \"movie\" | \"tv\" | \"game\";\n external_id: number;\n title: string;\n release_date: string | null;\n extra: Record;\n}\n\ninterface SearchResult {\n id: number;\n title: string;\n date: string | null;\n poster_path?: string | null;\n background_image?: string | null;\n platforms?: string[];\n}\n\nfunction formatDate(iso: string | null): string {\n if (!iso) return \"TBA\";\n return new Date(iso + \"T00:00:00Z\").toLocaleDateString(\"en-GB\", {\n day: \"numeric\",\n month: \"short\",\n year: \"numeric\",\n timeZone: \"UTC\",\n });\n}\n\nfunction SearchPanel({ onAdded }: { onAdded: () => void }) {\n const [kind, setKind] = useState<\"movie\" | \"tv\" | \"game\">(\"movie\");\n const [query, setQuery] = useState(\"\");\n const [results, setResults] = useState([]);\n const [loading, setLoading] = useState(false);\n const [addingId, setAddingId] = useState(null);\n\n async function doSearch(e: React.FormEvent) {\n e.preventDefault();\n if (!query.trim()) return;\n setLoading(true);\n try {\n const res = await fetch(`/api/search?kind=${kind}&q=${encodeURIComponent(query)}`);\n const data = await res.json();\n setResults(Array.isArray(data) ? data : []);\n } finally {\n setLoading(false);\n }\n }\n\n async function add(r: SearchResult) {\n setAddingId(r.id);\n try {\n await fetch(\"/api/watchlist\", {\n method: \"POST\",\n headers: { \"content-type\": \"application/json\" },\n body: JSON.stringify({ kind, external_id: r.id }),\n });\n onAdded();\n } finally {\n setAddingId(null);\n }\n }\n\n return (\n

Add something to track

\n setKind(e.target.value as any)}\n className=\"bg-slate-800 border border-slate-700 rounded-lg px-3 py-2 text-sm\"\n >\n \n \n \n \n setQuery(e.target.value)}\n placeholder=\"Search by title...\"\n className=\"flex-1 bg-slate-800 border border-slate-700 rounded-lg px-3 py-2 text-sm placeholder-slate-500\"\n />\n \n {loading ? \"Searching...\" : \"Search\"}\n \n \n\n {results.length > 0 && (\n

\n
\n
{r.title}
\n
{formatDate(r.date)}
\n
\n add(r)}\n disabled={addingId === r.id}\n className=\"shrink-0 bg-emerald-600 hover:bg-emerald-500 disabled:opacity-50 rounded-lg px-3 py-1.5 text-xs font-medium\"\n >\n {addingId === r.id ? \"Adding...\" : \"+ Add\"}\n \n

\n )}\n

\n );\n}\n\nfunction WatchlistPanel({ items, onRemove }: { items: WatchItem[]; onRemove: (id: number) => void }) {\n const groups: Record = { movie: [], tv: [], game: [] };\n for (const item of items) groups[item.kind]?.push(item);\n\n return (\n

Your watchlist ({items.length})

\n {items.length === 0 &&

Nothing tracked yet — search above to add something.

}\n {([\"movie\", \"tv\", \"game\"] as const).map((kind) =>\n groups[kind].length > 0 ? (\n

{KIND_LABEL[kind]}s

\n
\n
\n {item.title}\n {item.kind === \"tv\" && item.extra?.season_number ? ` — S${item.extra.season_number}` : \"\"}\n
\n
{formatDate(item.release_date)}
\n
\n onRemove(item.id)}\n className=\"shrink-0 text-slate-400 hover:text-red-400 text-xs px-2 py-1\"\n >\n Remove\n \n

\n ) : null,\n )}\n

\n );\n}\n\nfunction App() {\n const [items, setItems] = useState([]);\n\n async function refresh() {\n const res = await fetch(\"/api/watchlist\");\n setItems(await res.json());\n }\n\n useEffect(() => {\n refresh();\n }, []);\n\n async function remove(id: number) {\n await fetch(`/api/watchlist/${id}`, { method: \"DELETE\" });\n refresh();\n }\n\n const icsUrl = `${location.origin}/ics`;\n\n return (\n

📡 Release Radar

\n Track upcoming movies, TV seasons, and games. Discord digest fires monthly; the calendar feed below updates\n daily.\n

\n\n

📅 Subscribe in Google Calendar (Settings → Add calendar → From URL):

\n {icsUrl}\n

\n\n

\n \n \n

\n\n \n

\n );\n}\n\ncreateRoot(document.getElementById(\"root\")!).render();\n",[18,82],"pulls","branches",1,"forks","envVars",{"_185":187,"_188":26},"connections",{"_185":26,"_186":26},"count","unfilledCount",3,"emptyCount",{"_34":301,"_13":284,"_65":277,"_44":-5,"_36":37,"_161":302,"_162":24,"_38":303,"_40":26,"_68":84,"_164":-5,"_70":30,"_165":-5,"_210":304,"_17":305},{"_34":293,"_13":294,"_65":295,"_44":277,"_36":37,"_161":296,"_162":24,"_38":297,"_40":26,"_68":280,"_164":298,"_70":30,"_165":-5,"_210":299,"_17":300},{"_34":285,"_13":286,"_65":97,"_44":277,"_36":37,"_161":287,"_162":24,"_38":288,"_40":26,"_68":289,"_164":290,"_70":30,"_165":-5,"_210":291,"_17":292},{"_34":274,"_13":275,"_65":276,"_44":277,"_36":37,"_161":278,"_162":24,"_38":279,"_40":179,"_68":280,"_164":281,"_70":30,"_165":-5,"_210":282,"_17":283},{"_34":160,"_13":18,"_65":83,"_44":-5,"_36":37,"_161":41,"_162":24,"_38":271,"_40":26,"_68":84,"_164":-5,"_70":30,"_165":-5,"_210":272,"_17":273},{"_34":173,"_13":82,"_65":81,"_44":83,"_36":37,"_161":76,"_162":24,"_38":268,"_40":26,"_68":69,"_164":175,"_70":30,"_165":-5,"_210":269,"_17":270},{"_34":169,"_13":67,"_65":66,"_44":83,"_36":37,"_161":41,"_162":24,"_38":265,"_40":26,"_68":69,"_164":171,"_70":30,"_165":-5,"_210":266,"_17":267},{"_34":258,"_13":259,"_65":260,"_44":-5,"_36":37,"_161":261,"_162":24,"_38":262,"_40":26,"_68":84,"_164":-5,"_70":30,"_165":-5,"_210":263,"_17":264},{"_34":254,"_13":221,"_65":216,"_44":-5,"_36":37,"_161":208,"_162":24,"_38":255,"_40":26,"_68":84,"_164":-5,"_70":30,"_165":-5,"_210":256,"_17":257},{"_34":246,"_13":247,"_65":248,"_44":216,"_36":37,"_161":249,"_162":24,"_38":250,"_40":179,"_68":69,"_164":251,"_70":30,"_165":-5,"_210":252,"_17":253},{"_34":238,"_13":239,"_65":240,"_44":216,"_36":37,"_161":241,"_162":24,"_38":242,"_40":179,"_68":69,"_164":243,"_70":30,"_165":-5,"_210":244,"_17":245},{"_34":230,"_13":231,"_65":232,"_44":216,"_36":37,"_161":233,"_162":24,"_38":234,"_40":26,"_68":69,"_164":235,"_70":30,"_165":-5,"_210":236,"_17":237},{"_34":222,"_13":223,"_65":224,"_44":216,"_36":37,"_161":225,"_162":24,"_38":226,"_40":26,"_68":69,"_164":227,"_70":30,"_165":-5,"_210":228,"_17":229},{"_34":213,"_13":214,"_65":215,"_44":216,"_36":37,"_161":187,"_162":24,"_38":217,"_40":26,"_68":69,"_164":218,"_70":30,"_165":-5,"_210":219,"_17":220},{"_34":204,"_13":205,"_65":206,"_44":-5,"_36":37,"_161":124,"_162":24,"_38":207,"_40":208,"_68":21,"_164":209,"_70":30,"_165":-5,"_210":211,"_17":212},"a080b199-cc03-446f-9861-4510c3c4fb11","README.md","2acc597e-9c6f-11f1-8352-1607ee4eb77e",["D",1787215398931],2,"# Release Radar\n\nPersonal tracker for upcoming movies, TV seasons, and games. Search TMDB (movies/TV)\nand RAWG (games) to build a watchlist, then get notified two ways:\n\n- **Discord digest** — posted on the 1st of each month, listing everything on the\n watchlist releasing that month. A shorter **day-of ping** also fires on the daily\n sync whenever something actually releases that day — silent otherwise.\n- **ICS calendar feed** — `/ics` serves a live calendar feed. Subscribe to it in\n Google Calendar (Settings → Add calendar → From URL) or any calendar app, and\n each release shows up as an all-day event on its date.\n\nItems auto-remove from the watchlist (and therefore the calendar/digests) 3 days\nafter their release date, so it stays a list of what's still coming rather than\neverything that ever was.\n\n## Structure\n\n- `backend/index.ts` — HTTP val (Hono). Serves the web UI, the `/ics` feed, and the\n `/api/*` endpoints used by the frontend to search and manage the watchlist.\n- `backend/sync.ts` — daily cron (06:00 UTC). Re-fetches release/air dates for\n everything on the watchlist, sends the day-of Discord ping if anything releases\n today, then drops items more than 3 days past their release date.\n- `backend/digest.ts` — monthly cron (1st, 08:00 UTC, after that day's sync). Posts\n the Discord digest for the current month.\n- `shared/db.ts` — SQLite watchlist table (val-scoped).\n- `shared/tmdb.ts` / `shared/rawg.ts` — API clients.\n- `shared/ics.ts` / `shared/discord.ts` — output formatters.\n- `frontend/` — React UI for searching and managing the watchlist.\n\n## Required env vars\n\n- `TMDB_API_KEY`\n- `RAWG_API_KEY`\n- `DISCORD_WEBHOOK_URL`\n\n👉 Manage them here: https://www.val.town/x/CAS98/release-radar/environment-variables\n\n## Adding items\n\nOpen the web UI, search by title (pick Movie/TV Show/Game first), and hit **+ Add**.\nTV shows track the *next* known episode/season air date — renewals get picked up\nautomatically by the daily sync once TMDB has a date for them.\n","children",[],[205],"623fb206-ebe1-4596-9f44-af2b4b89eeba","tmdb.ts","47a6f360-9c6f-11f1-aafe-1607ee4eb77e","0bb1b29f-d2b5-4079-ab94-6db55eeb27cb",["D",1787213718247],"const BASE = \"https://api.themoviedb.org/3\";\n\nfunction key() {\n const k = Deno.env.get(\"TMDB_API_KEY\");\n if (!k) throw new Error(\"TMDB_API_KEY not set\");\n return k;\n}\n\nasync function tmdbGet(path: string, params: Record = {}) {\n const url = new URL(BASE + path);\n url.searchParams.set(\"api_key\", key());\n for (const [k, v] of Object.entries(params)) url.searchParams.set(k, v);\n const res = await fetch(url.toString());\n if (!res.ok) throw new Error(`TMDB ${path} failed: ${res.status} ${await res.text()}`);\n return res.json();\n}\n\nexport interface TmdbSearchResult {\n id: number;\n title: string;\n date: string | null; // release_date or first_air_date\n poster_path: string | null;\n}\n\nexport async function searchMovies(query: string): Promise {\n const data = await tmdbGet(\"/search/movie\", { query });\n return (data.results ?? []).map((r: any) => ({\n id: r.id,\n title: r.title,\n date: r.release_date || null,\n poster_path: r.poster_path,\n }));\n}\n\nexport async function searchTv(query: string): Promise {\n const data = await tmdbGet(\"/search/tv\", { query });\n return (data.results ?? []).map((r: any) => ({\n id: r.id,\n title: r.name,\n date: r.first_air_date || null,\n poster_path: r.poster_path,\n }));\n}\n\nexport async function getMovieDetails(id: number) {\n const d = await tmdbGet(`/movie/${id}`);\n return {\n id: d.id,\n title: d.title,\n release_date: d.release_date || null,\n poster_path: d.poster_path,\n status: d.status, // e.g. \"Released\", \"Post Production\", \"Planned\"\n };\n}\n\nexport async function getTvDetails(id: number) {\n const d = await tmdbGet(`/tv/${id}`);\n const nextAir = d.next_episode_to_air; // { air_date, season_number, episode_number } | null\n // Prefer the confirmed next episode/season air date. If the show hasn't\n // premiered yet at all, fall back to first_air_date (may itself be in the future).\n const release_date = nextAir?.air_date || (d.status === \"Planned\" ? d.first_air_date : null) || null;\n return {\n id: d.id,\n title: d.name,\n release_date,\n poster_path: d.poster_path,\n status: d.status, // \"Returning Series\", \"Ended\", \"Planned\", \"In Production\", etc.\n season_number: nextAir?.season_number ?? null,\n episode_number: nextAir?.episode_number ?? null,\n };\n}\n",[],[221,214],"shared","f9982ff7-298f-464c-a671-b5152c225a4b","rawg.ts","4e410d82-9c6f-11f1-96ad-1607ee4eb77e",4,["D",1787213729327],"const BASE = \"https://api.rawg.io/api\";\n\nfunction key() {\n const k = Deno.env.get(\"RAWG_API_KEY\");\n if (!k) throw new Error(\"RAWG_API_KEY not set\");\n return k;\n}\n\nasync function rawgGet(path: string, params: Record = {}) {\n const url = new URL(BASE + path);\n url.searchParams.set(\"key\", key());\n for (const [k, v] of Object.entries(params)) url.searchParams.set(k, v);\n const res = await fetch(url.toString());\n if (!res.ok) throw new Error(`RAWG ${path} failed: ${res.status} ${await res.text()}`);\n return res.json();\n}\n\nexport interface RawgSearchResult {\n id: number;\n title: string;\n date: string | null; // released date, or tba\n background_image: string | null;\n platforms: string[];\n}\n\nexport async function searchGames(query: string): Promise {\n const data = await rawgGet(\"/games\", { search: query, page_size: \"10\" });\n return (data.results ?? []).map((r: any) => ({\n id: r.id,\n title: r.name,\n date: r.tba ? null : r.released || null,\n background_image: r.background_image,\n platforms: (r.platforms ?? []).map((p: any) => p.platform?.name).filter(Boolean),\n }));\n}\n\nexport async function getGameDetails(id: number) {\n const d = await rawgGet(`/games/${id}`);\n return {\n id: d.id,\n title: d.name,\n release_date: d.tba ? null : d.released || null,\n background_image: d.background_image,\n platforms: (d.platforms ?? []).map((p: any) => p.platform?.name).filter(Boolean),\n tba: !!d.tba,\n };\n}\n",[],[221,223],"fdf791fc-d0f7-4a42-beed-b7883438f3e7","ics.ts","630ee31a-9c6f-11f1-8f40-1607ee4eb77e",6,["D",1787213764236],"import type { WatchItem } from \"./db.ts\";\n\nconst KIND_EMOJI: Record = { movie: \"🎬\", tv: \"📺\", game: \"🎮\" };\n\nfunction dateToIcsDate(iso: string): string {\n // \"2026-08-14\" -> \"20260814\"\n return iso.replaceAll(\"-\", \"\");\n}\n\nfunction addDay(iso: string): string {\n const d = new Date(iso + \"T00:00:00Z\");\n d.setUTCDate(d.getUTCDate() + 1);\n return d.toISOString().slice(0, 10);\n}\n\nfunction escapeIcsText(text: string): string {\n return text.replace(/[\\\\;,]/g, (c) => \"\\\\\" + c).replace(/\\n/g, \"\\\\n\");\n}\n\nexport function buildIcs(items: WatchItem[]): string {\n const now = new Date().toISOString().replace(/[-:]/g, \"\").split(\".\")[0] + \"Z\";\n const lines: string[] = [\n \"BEGIN:VCALENDAR\",\n \"VERSION:2.0\",\n \"PRODID:-//Release Radar//EN\",\n \"CALSCALE:GREGORIAN\",\n \"X-WR-CALNAME:Release Radar\",\n \"REFRESH-INTERVAL;VALUE=DURATION:P1D\",\n ];\n\n for (const item of items) {\n if (!item.release_date) continue;\n const extra = item.extra ? JSON.parse(item.extra) : {};\n let summary = `${KIND_EMOJI[item.kind] ?? \"\"} ${item.title}`.trim();\n if (item.kind === \"tv\" && extra.season_number) {\n summary += ` S${String(extra.season_number).padStart(2, \"0\")}${\n extra.episode_number ? `E${String(extra.episode_number).padStart(2, \"0\")}` : \"\"\n }`;\n }\n lines.push(\n \"BEGIN:VEVENT\",\n `UID:${item.kind}-${item.external_id}@release-radar.val.run`,\n `DTSTAMP:${now}`,\n `DTSTART;VALUE=DATE:${dateToIcsDate(item.release_date)}`,\n `DTEND;VALUE=DATE:${dateToIcsDate(addDay(item.release_date))}`,\n `SUMMARY:${escapeIcsText(summary)}`,\n \"END:VEVENT\",\n );\n }\n\n lines.push(\"END:VCALENDAR\");\n return lines.join(\"\\r\\n\");\n}\n",[],[221,231],"109980b7-3852-4875-8367-cf523c4d891e","discord.ts","6c5c3602-9c6f-11f1-b326-1607ee4eb77e",18,["D",1787215340750],"import type { WatchItem } from \"./db.ts\";\n\nconst KIND_LABEL: Record = { movie: \"🎬 Movies\", tv: \"📺 TV / Seasons\", game: \"🎮 Games\" };\nconst KIND_ORDER = [\"movie\", \"tv\", \"game\"];\n\nfunction formatDate(iso: string): string {\n const d = new Date(iso + \"T00:00:00Z\");\n return d.toLocaleDateString(\"en-GB\", { day: \"numeric\", month: \"short\", timeZone: \"UTC\" });\n}\n\nexport function buildDigestContent(items: WatchItem[], monthLabel: string): string {\n if (items.length === 0) {\n return `**📅 ${monthLabel} Release Radar**\\n\\nNothing on your watchlist releasing this month.`;\n }\n\n const byKind: Record = {};\n for (const item of items) {\n (byKind[item.kind] ??= []).push(item);\n }\n\n const sections: string[] = [`**📅 ${monthLabel} Release Radar**`, \"\"];\n for (const kind of KIND_ORDER) {\n const group = byKind[kind];\n if (!group?.length) continue;\n sections.push(`**${KIND_LABEL[kind]}**`);\n for (const item of group.sort((a, b) => (a.release_date! < b.release_date! ? -1 : 1))) {\n const extra = item.extra ? JSON.parse(item.extra) : {};\n let line = `• *${item.title}*`;\n if (kind === \"tv\" && extra.season_number) line += ` S${extra.season_number}`;\n if (kind === \"game\" && extra.platforms?.length) line += ` (${extra.platforms.slice(0, 3).join(\"/\")})`;\n line += ` — ${formatDate(item.release_date!)}`;\n sections.push(line);\n }\n sections.push(\"\");\n }\n\n return sections.join(\"\\n\").trim();\n}\n\n// Short \"it's out today\" ping, sent by the daily sync only when something on\n// the watchlist actually releases that day.\nexport function buildTodayPingContent(items: WatchItem[]): string {\n const KIND_VERB: Record = { movie: \"out in cinemas\", tv: \"airing\", game: \"out now\" };\n const lines = [`**🚀 Releasing today!**`, \"\"];\n for (const item of items) {\n const extra = item.extra ? JSON.parse(item.extra) : {};\n let line = `${KIND_LABEL[item.kind]?.split(\" \")[0] ?? \"\"} *${item.title}*`;\n if (item.kind === \"tv\" && extra.season_number) {\n line += ` S${String(extra.season_number).padStart(2, \"0\")}${\n extra.episode_number ? `E${String(extra.episode_number).padStart(2, \"0\")}` : \"\"\n }`;\n }\n line += ` is ${KIND_VERB[item.kind] ?? \"out\"} today.`;\n lines.push(line);\n }\n return lines.join(\"\\n\");\n}\n\nexport async function sendDiscordDigest(content: string) {\n const url = Deno.env.get(\"DISCORD_WEBHOOK_URL\");\n if (!url) throw new Error(\"DISCORD_WEBHOOK_URL not set\");\n // Discord content field caps at 2000 chars; chunk defensively if a very full month exceeds it.\n const chunks: string[] = [];\n let remaining = content;\n while (remaining.length > 0) {\n if (remaining.length <= 1900) {\n chunks.push(remaining);\n break;\n }\n let cut = remaining.lastIndexOf(\"\\n\", 1900);\n if (cut <= 0) cut = 1900;\n chunks.push(remaining.slice(0, cut));\n remaining = remaining.slice(cut);\n }\n for (const chunk of chunks) {\n const res = await fetch(url, {\n method: \"POST\",\n headers: { \"content-type\": \"application/json\" },\n body: JSON.stringify({ content: chunk }),\n });\n if (!res.ok) throw new Error(`Discord webhook failed: ${res.status} ${await res.text()}`);\n }\n}\n",[],[221,239],"71fe2723-13e8-47f3-aaba-ba5f0922b4c5","db.ts","3be834c6-9c6f-11f1-b05e-1607ee4eb77e",17,["D",1787215324024],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport interface WatchItem {\n id: number;\n kind: \"movie\" | \"tv\" | \"game\";\n external_id: number;\n title: string;\n release_date: string | null; // ISO date (YYYY-MM-DD), null if unknown/TBA\n extra: string | null; // JSON blob: { poster, season, episode, platforms, status }\n added_at: string;\n last_checked_at: string | null;\n}\n\nexport async function initDb() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS watchlist (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n kind TEXT NOT NULL,\n external_id INTEGER NOT NULL,\n title TEXT NOT NULL,\n release_date TEXT,\n extra TEXT,\n added_at TEXT NOT NULL,\n last_checked_at TEXT,\n UNIQUE(kind, external_id)\n )\n `);\n}\n\nexport async function addItem(item: {\n kind: \"movie\" | \"tv\" | \"game\";\n external_id: number;\n title: string;\n release_date: string | null;\n extra: Record;\n}) {\n await initDb();\n await sqlite.execute({\n sql: `INSERT INTO watchlist (kind, external_id, title, release_date, extra, added_at)\n VALUES (?, ?, ?, ?, ?, ?)\n ON CONFLICT(kind, external_id) DO UPDATE SET\n title = excluded.title,\n release_date = excluded.release_date,\n extra = excluded.extra`,\n args: [\n item.kind,\n item.external_id,\n item.title,\n item.release_date,\n JSON.stringify(item.extra ?? {}),\n new Date().toISOString(),\n ],\n });\n}\n\nexport async function removeItem(id: number) {\n await initDb();\n await sqlite.execute({ sql: `DELETE FROM watchlist WHERE id = ?`, args: [id] });\n}\n\nexport async function listItems(): Promise {\n await initDb();\n const result = await sqlite.execute(`SELECT * FROM watchlist ORDER BY release_date IS NULL, release_date ASC`);\n return result.rows as unknown as WatchItem[];\n}\n\nexport async function updateReleaseDate(id: number, release_date: string | null, extra: Record) {\n await sqlite.execute({\n sql: `UPDATE watchlist SET release_date = ?, extra = ?, last_checked_at = ? WHERE id = ?`,\n args: [release_date, JSON.stringify(extra ?? {}), new Date().toISOString(), id],\n });\n}\n\n// Items releasing on an exact date (YYYY-MM-DD) - used for the day-of Discord ping.\nexport async function itemsReleasingOn(dateIso: string): Promise {\n await initDb();\n const result = await sqlite.execute({\n sql: `SELECT * FROM watchlist WHERE release_date = ?`,\n args: [dateIso],\n });\n return result.rows as unknown as WatchItem[];\n}\n\n// Removes (and returns) items whose release_date is strictly before the cutoff\n// (YYYY-MM-DD) - used to drop items a few days after they've released.\nexport async function removeReleasedBefore(cutoffIso: string): Promise {\n await initDb();\n const toRemove = await sqlite.execute({\n sql: `SELECT * FROM watchlist WHERE release_date IS NOT NULL AND release_date < ?`,\n args: [cutoffIso],\n });\n const rows = toRemove.rows as unknown as WatchItem[];\n if (rows.length > 0) {\n await sqlite.execute({\n sql: `DELETE FROM watchlist WHERE release_date IS NOT NULL AND release_date < ?`,\n args: [cutoffIso],\n });\n }\n return rows;\n}\n",[],[221,247],"7f590045-97e3-41fb-888c-aca21d0fb7eb",["D",1787213698524],[198,199,200,201,202],[221],"ad1ba789-e2c9-4e82-9c76-767329a03280","scripts","780d0959-51ea-42e1-8918-5405201a9a7f",5,["D",1787213738461],[],[259],["D",1787213842216],[],[18,67],["D",1787213870303],[],[18,82],["D",1787213842216],[194,195],[18],"4252174a-fdbb-46f1-8612-11dff8a7590f","sync.ts","76812e1c-9c6f-11f1-878f-1607ee4eb77e","2b486220-77a5-42fd-8542-2573c787c63e",19,["D",1787215354391],"interval","import { itemsReleasingOn, listItems, removeReleasedBefore, updateReleaseDate } from \"../shared/db.ts\";\nimport { getMovieDetails, getTvDetails } from \"../shared/tmdb.ts\";\nimport { getGameDetails } from \"../shared/rawg.ts\";\nimport { buildTodayPingContent, sendDiscordDigest } from \"../shared/discord.ts\";\n\nconst CLEANUP_GRACE_DAYS = 3;\n\n// Runs daily. Refreshes release/air dates for everything on the watchlist so\n// the ICS feed and monthly digest always reflect the latest known dates\n// (TV shows in particular get renewed/rescheduled over time), pings Discord\n// for anything releasing today, then drops items a few days past release.\nexport default async function (interval: Interval) {\n const items = await listItems();\n console.log(`Syncing ${items.length} watchlist item(s)...`);\n\n for (const item of items) {\n try {\n if (item.kind === \"movie\") {\n const d = await getMovieDetails(item.external_id);\n await updateReleaseDate(item.id, d.release_date, { poster: d.poster_path, status: d.status });\n } else if (item.kind === \"tv\") {\n const d = await getTvDetails(item.external_id);\n await updateReleaseDate(item.id, d.release_date, {\n poster: d.poster_path,\n status: d.status,\n season_number: d.season_number,\n episode_number: d.episode_number,\n });\n } else if (item.kind === \"game\") {\n const d = await getGameDetails(item.external_id);\n await updateReleaseDate(item.id, d.release_date, {\n background_image: d.background_image,\n platforms: d.platforms,\n });\n }\n } catch (err) {\n console.error(`Failed to sync ${item.kind} \"${item.title}\" (id ${item.id}):`, err);\n }\n }\n console.log(\"Sync complete.\");\n\n // --- Day-of ping ---\n const today = new Date().toISOString().slice(0, 10);\n const releasingToday = await itemsReleasingOn(today);\n if (releasingToday.length > 0) {\n try {\n await sendDiscordDigest(buildTodayPingContent(releasingToday));\n console.log(`Sent day-of ping for ${releasingToday.length} item(s).`);\n } catch (err) {\n console.error(\"Failed to send day-of ping:\", err);\n }\n }\n\n // --- Cleanup: drop items a few days past their release date ---\n const cutoff = new Date();\n cutoff.setUTCDate(cutoff.getUTCDate() - CLEANUP_GRACE_DAYS);\n const cutoffIso = cutoff.toISOString().slice(0, 10);\n const removed = await removeReleasedBefore(cutoffIso);\n if (removed.length > 0) {\n console.log(`Auto-removed ${removed.length} released item(s): ${removed.map((r) => r.title).join(\", \")}`);\n }\n}\n",[],[284,275],"backend","ffe72c7c-7a1b-4855-8c3b-154157265f28","index.ts",10,["D",1787213831928],"http","import { Hono } from \"npm:hono\";\nimport { immutableFileUrl, parseVal, serveImmutableFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { addItem, initDb, listItems, removeItem } from \"../shared/db.ts\";\nimport { getMovieDetails, getTvDetails, searchMovies, searchTv } from \"../shared/tmdb.ts\";\nimport { getGameDetails, searchGames } from \"../shared/rawg.ts\";\nimport { buildIcs } from \"../shared/ics.ts\";\nimport { Root } from \"../frontend/root.tsx\";\n\nconst app = new Hono();\n\napp.get(\"/\", (c) => c.html(Root({ entry: immutableFileUrl(\"/frontend/index.tsx\") })));\napp.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path));\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// Public ICS feed for calendar subscription (Google Calendar -> Add by URL)\napp.get(\"/ics\", async (c) => {\n const items = await listItems();\n const ics = buildIcs(items);\n return new Response(ics, {\n headers: {\n \"content-type\": \"text/calendar; charset=utf-8\",\n \"content-disposition\": \"inline; filename=release-radar.ics\",\n },\n });\n});\n\napp.get(\"/api/watchlist\", async (c) => {\n const items = await listItems();\n return c.json(items.map((i) => ({ ...i, extra: i.extra ? JSON.parse(i.extra) : {} })));\n});\n\napp.get(\"/api/search\", async (c) => {\n const kind = c.req.query(\"kind\");\n const q = c.req.query(\"q\");\n if (!q || !kind) return c.json({ error: \"kind and q required\" }, 400);\n try {\n if (kind === \"movie\") return c.json(await searchMovies(q));\n if (kind === \"tv\") return c.json(await searchTv(q));\n if (kind === \"game\") return c.json(await searchGames(q));\n return c.json({ error: \"invalid kind\" }, 400);\n } catch (err) {\n console.error(err);\n return c.json({ error: String(err) }, 502);\n }\n});\n\napp.post(\"/api/watchlist\", async (c) => {\n const body = await c.req.json();\n const { kind, external_id } = body ?? {};\n if (!kind || !external_id) return c.json({ error: \"kind and external_id required\" }, 400);\n try {\n if (kind === \"movie\") {\n const d = await getMovieDetails(external_id);\n await addItem({ kind, external_id, title: d.title, release_date: d.release_date, extra: { poster: d.poster_path, status: d.status } });\n } else if (kind === \"tv\") {\n const d = await getTvDetails(external_id);\n await addItem({\n kind,\n external_id,\n title: d.title,\n release_date: d.release_date,\n extra: { poster: d.poster_path, status: d.status, season_number: d.season_number, episode_number: d.episode_number },\n });\n } else if (kind === \"game\") {\n const d = await getGameDetails(external_id);\n await addItem({\n kind,\n external_id,\n title: d.title,\n release_date: d.release_date,\n extra: { background_image: d.background_image, platforms: d.platforms },\n });\n } else {\n return c.json({ error: \"invalid kind\" }, 400);\n }\n return c.json({ ok: true });\n } catch (err) {\n console.error(err);\n return c.json({ error: String(err) }, 502);\n }\n});\n\napp.delete(\"/api/watchlist/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n await removeItem(id);\n return c.json({ ok: true });\n});\n\napp.onError((err) => Promise.reject(err));\n\nawait initDb();\n\nexport default app.fetch;\n",[],[284,286],"6df18248-0c29-4934-a14a-e850485574ae","digest.ts","7db10a4a-9c6f-11f1-b78c-1607ee4eb77e",9,["D",1787213808909],"import { listItems } from \"../shared/db.ts\";\nimport { buildDigestContent, sendDiscordDigest } from \"../shared/discord.ts\";\n\n// Runs monthly (1st of the month). Posts everything on the watchlist that\n// releases during the current calendar month.\nexport default async function (interval: Interval) {\n const now = new Date();\n const year = now.getUTCFullYear();\n const month = now.getUTCMonth(); // 0-indexed\n const monthPrefix = `${year}-${String(month + 1).padStart(2, \"0\")}`;\n const monthLabel = now.toLocaleDateString(\"en-GB\", { month: \"long\", year: \"numeric\", timeZone: \"UTC\" });\n\n const items = await listItems();\n const thisMonth = items.filter((i) => i.release_date?.startsWith(monthPrefix));\n\n const content = buildDigestContent(thisMonth, monthLabel);\n await sendDiscordDigest(content);\n console.log(`Sent digest for ${monthLabel}: ${thisMonth.length} item(s).`);\n}\n",[],[284,294],"1c670b48-4b1a-4034-aaaf-1d6a35df47de",8,["D",1787213796851],[190,191,192],[284],["D",1787213669731],["D",1789563628475],{"_11":12,"_138":73},{"_11":12,"_133":134,"_72":73,"_31":71,"_135":136,"_137":30},{"_40":124,"_13":16,"_34":37,"_125":86,"_126":-5,"_127":-5,"_128":-5,"_129":-5,"_130":-5,"_131":14,"_132":12},"ctx",{"_55":-5,"_157":344,"_345":346,"_347":348,"_349":30,"_350":30,"_351":30,"_352":24,"_353":-5,"_354":-7,"_355":-7,"_356":26,"_357":30,"_358":30,"_359":-5,"_360":30,"_361":30,"_362":30,"_363":-5},"ENV",{"_315":316,"_317":318,"_319":16,"_320":321,"_322":323,"_324":325,"_326":327,"_328":329,"_330":331,"_332":333,"_334":335,"_336":337,"_338":339,"_340":341,"_342":343},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","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"]

History · frontend