[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_333":334,"_335":336},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_249":-5,"_20":250,"_22":251,"_252":253,"_254":255,"_26":256,"_24":257,"_258":-5,"_259":-5,"_260":56,"_261":262,"_263":47,"_264":-5,"_265":-5,"_266":267},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","CAS98","name","release-radar","branchName","main","version","path","frontend","project",{"_35":191,"_13":14,"_48":192,"_193":-5,"_194":56,"_195":196,"_197":196,"_198":199,"_200":-5,"_201":202,"_203":176,"_204":47,"_205":-5,"_206":-5,"_207":50,"_208":209,"_210":211,"_212":213,"_214":215,"_216":-5,"_217":218,"_219":218,"_220":221,"_222":221,"_223":221,"_224":218,"_225":218,"_226":227,"_228":229,"_230":231,"_232":56},"tree",[70,71,72,73,74],"file",{"_35":66,"_13":19,"_38":41,"_40":-5,"_42":43,"_44":45,"_46":47,"_48":67,"_17":50,"_51":68,"_53":-5,"_55":56,"_57":-5,"_18":69},"contents",[33,34],"upstream","pull","ahead","behind","envVars",{"_35":59,"_13":60,"_38":61,"_40":41,"_42":43,"_44":62,"_46":47,"_48":63,"_17":50,"_51":52,"_53":64,"_55":56,"_57":-5,"_18":65},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_17":50,"_51":52,"_53":54,"_55":56,"_57":-5,"_18":58},"id","ff96554d-5050-4e19-b6b1-1cd30d47e426","root.tsx","fileId","918d5082-9c6f-11f1-adbc-1607ee4eb77e","parentId","16ccc6b7-e18f-4295-a9b7-48af38323d57","branchId","d9a26512-0605-40bd-b660-bf83629b1afb","branchVersion",11,"latest",true,"createdAt",["D",1787213842216],0,"fileType","script","content","/** @jsxImportSource npm:hono/jsx */\n\nexport function Root({ entry }: { entry: string }) {\n return (\n \n \n \n \n Release Radar\n 📡\" />\n \n \n \n \n

\n \n \n \n );\n}\n","deleted",false,"label",[19,37],"e1580b50-cb53-4fa4-94fe-f5ff9e3e45d4","index.tsx","a24934ea-9c6f-11f1-89ad-1607ee4eb77e",12,["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",[19,60],"5a8e677e-577b-4901-be56-7df8ac20dc09",["D",1787213842216],"directory",[19],{"_35":155,"_13":156,"_38":157,"_40":-5,"_42":43,"_44":158,"_46":47,"_48":159,"_17":50,"_51":68,"_53":-5,"_55":56,"_57":-5,"_82":160,"_18":161},{"_35":66,"_13":19,"_38":41,"_40":-5,"_42":43,"_44":45,"_46":47,"_48":144,"_17":50,"_51":68,"_53":-5,"_55":56,"_57":-5,"_82":145,"_18":146},{"_35":137,"_13":138,"_38":139,"_40":-5,"_42":43,"_44":140,"_46":47,"_48":141,"_17":50,"_51":68,"_53":-5,"_55":56,"_57":-5,"_82":142,"_18":143},{"_35":85,"_13":86,"_38":87,"_40":-5,"_42":43,"_44":80,"_46":47,"_48":88,"_17":50,"_51":68,"_53":-5,"_55":56,"_57":-5,"_82":89,"_18":90},{"_35":75,"_13":76,"_38":77,"_40":-5,"_42":43,"_44":78,"_46":47,"_48":79,"_17":80,"_51":24,"_53":81,"_55":56,"_57":-5,"_82":83,"_18":84},"a080b199-cc03-446f-9861-4510c3c4fb11","README.md","2acc597e-9c6f-11f1-8352-1607ee4eb77e",20,["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",[],[76],"7f590045-97e3-41fb-888c-aca21d0fb7eb","shared","0bb1b29f-d2b5-4079-ab94-6db55eeb27cb",["D",1787213698524],[91,92,93,94,95],[86],{"_35":129,"_13":130,"_38":131,"_40":87,"_42":43,"_44":132,"_46":47,"_48":133,"_17":125,"_51":52,"_53":134,"_55":56,"_57":-5,"_82":135,"_18":136},{"_35":120,"_13":121,"_38":122,"_40":87,"_42":43,"_44":123,"_46":47,"_48":124,"_17":125,"_51":52,"_53":126,"_55":56,"_57":-5,"_82":127,"_18":128},{"_35":112,"_13":113,"_38":114,"_40":87,"_42":43,"_44":115,"_46":47,"_48":116,"_17":50,"_51":52,"_53":117,"_55":56,"_57":-5,"_82":118,"_18":119},{"_35":104,"_13":105,"_38":106,"_40":87,"_42":43,"_44":107,"_46":47,"_48":108,"_17":50,"_51":52,"_53":109,"_55":56,"_57":-5,"_82":110,"_18":111},{"_35":96,"_13":97,"_38":98,"_40":87,"_42":43,"_44":99,"_46":47,"_48":100,"_17":50,"_51":52,"_53":101,"_55":56,"_57":-5,"_82":102,"_18":103},"623fb206-ebe1-4596-9f44-af2b4b89eeba","tmdb.ts","47a6f360-9c6f-11f1-aafe-1607ee4eb77e",3,["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",[],[86,97],"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",[],[86,105],"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",[],[86,113],"109980b7-3852-4875-8367-cf523c4d891e","discord.ts","6c5c3602-9c6f-11f1-b326-1607ee4eb77e",18,["D",1787215340750],1,"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",[],[86,121],"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",[],[86,130],"ad1ba789-e2c9-4e82-9c76-767329a03280","scripts","780d0959-51ea-42e1-8918-5405201a9a7f",5,["D",1787213738461],[],[138],["D",1787213842216],[147,148],[19],{"_35":59,"_13":60,"_38":61,"_40":41,"_42":43,"_44":62,"_46":47,"_48":152,"_17":50,"_51":52,"_53":64,"_55":56,"_57":-5,"_82":153,"_18":154},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":149,"_17":50,"_51":52,"_53":54,"_55":56,"_57":-5,"_82":150,"_18":151},["D",1787213842216],[],[19,37],["D",1787213870303],[],[19,60],"1c670b48-4b1a-4034-aaaf-1d6a35df47de","backend","2b486220-77a5-42fd-8542-2573c787c63e",8,["D",1787213796851],[162,163,164],[156],{"_35":183,"_13":184,"_38":185,"_40":157,"_42":43,"_44":186,"_46":47,"_48":187,"_17":50,"_51":170,"_53":188,"_55":56,"_57":-5,"_82":189,"_18":190},{"_35":174,"_13":175,"_38":176,"_40":157,"_42":43,"_44":177,"_46":47,"_48":178,"_17":50,"_51":179,"_53":180,"_55":56,"_57":-5,"_82":181,"_18":182},{"_35":165,"_13":166,"_38":167,"_40":157,"_42":43,"_44":168,"_46":47,"_48":169,"_17":125,"_51":170,"_53":171,"_55":56,"_57":-5,"_82":172,"_18":173},"4252174a-fdbb-46f1-8612-11dff8a7590f","sync.ts","76812e1c-9c6f-11f1-878f-1607ee4eb77e",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",[],[156,166],"ffe72c7c-7a1b-4855-8c3b-154157265f28","index.ts","8b683cc6-9c6f-11f1-bd8a-1607ee4eb77e",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",[],[156,175],"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",[],[156,184],"914903c6-e97d-4c16-93fd-3038cdfece7a",["D",1787213669731],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Upcoming movie/TV/game watchlist - Discord digest + ICS feed","imageUrl","userId","61ffb0fe-d459-4ad3-8d91-9f9cef83669a","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","019f59d1-fca3-73fa-92f7-78e081d29438","tursoName","914903c6e97d4c1693fd3038cdfece7a","tursoHostname","914903c6e97d4c1693fd3038cdfece7a-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789476648181],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_248":244},"org",{"_11":12,"_241":242,"_243":244,"_201":202,"_245":246,"_247":56},"branch",{"_17":78,"_13":16,"_35":43,"_233":191,"_234":-5,"_235":-5,"_236":-5,"_237":-5,"_238":-5,"_239":14,"_240":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Connor Spring","avatar","https://lh3.googleusercontent.com/a/ACg8ocIXiybVVENL2jKHwJuSnLA-b3XaCWjbMQB9VY7KWtrTm1M0_w=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_35":191,"_13":14,"_48":328,"_193":-5,"_194":56,"_195":196,"_197":196,"_198":199,"_200":-5,"_201":202,"_203":176,"_204":47,"_205":-5,"_206":-5,"_207":50,"_208":209,"_210":211,"_212":213,"_214":329,"_216":-5,"_217":218,"_219":218,"_220":221,"_222":221,"_223":221,"_224":218,"_225":218,"_226":330,"_228":331,"_230":332,"_232":56},[283,287,290,291,297],"files",[283,284,285,286,287,288,289,290,291,292,293,294,295,296,297],"counts",{"_274":50,"_275":125,"_276":50,"_32":277,"_278":279},[270,271],{"_35":66,"_42":43,"_38":41,"_13":19,"_53":-5,"_51":68,"_17":50,"_40":-5,"_48":268,"_44":45,"_57":-5,"_18":269},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1787213842216],[19],{"_35":59,"_13":60,"_38":61,"_40":41,"_42":43,"_44":62,"_46":47,"_48":63,"_17":50,"_51":52,"_53":64,"_55":56,"_57":-5,"_18":273},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_17":50,"_51":52,"_53":54,"_55":56,"_57":-5,"_18":272},[19,37],[19,60],"pulls","branches","forks",{"_280":99,"_282":50},"connections",{"_280":50,"_281":50},"count","unfilledCount","emptyCount",{"_35":155,"_13":156,"_38":157,"_40":-5,"_42":43,"_44":158,"_46":47,"_48":159,"_17":50,"_51":68,"_53":-5,"_55":56,"_57":-5,"_82":326,"_18":327},{"_35":183,"_13":184,"_38":185,"_40":157,"_42":43,"_44":186,"_46":47,"_48":187,"_17":50,"_51":170,"_53":188,"_55":56,"_57":-5,"_82":324,"_18":325},{"_35":174,"_13":175,"_38":176,"_40":157,"_42":43,"_44":177,"_46":47,"_48":178,"_17":50,"_51":179,"_53":180,"_55":56,"_57":-5,"_82":322,"_18":323},{"_35":165,"_13":166,"_38":167,"_40":157,"_42":43,"_44":168,"_46":47,"_48":169,"_17":125,"_51":170,"_53":171,"_55":56,"_57":-5,"_82":320,"_18":321},{"_35":66,"_13":19,"_38":41,"_40":-5,"_42":43,"_44":45,"_46":47,"_48":144,"_17":50,"_51":68,"_53":-5,"_55":56,"_57":-5,"_82":318,"_18":319},{"_35":59,"_13":60,"_38":61,"_40":41,"_42":43,"_44":62,"_46":47,"_48":152,"_17":50,"_51":52,"_53":64,"_55":56,"_57":-5,"_82":316,"_18":317},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":149,"_17":50,"_51":52,"_53":54,"_55":56,"_57":-5,"_82":314,"_18":315},{"_35":137,"_13":138,"_38":139,"_40":-5,"_42":43,"_44":140,"_46":47,"_48":141,"_17":50,"_51":68,"_53":-5,"_55":56,"_57":-5,"_82":312,"_18":313},{"_35":85,"_13":86,"_38":87,"_40":-5,"_42":43,"_44":80,"_46":47,"_48":88,"_17":50,"_51":68,"_53":-5,"_55":56,"_57":-5,"_82":310,"_18":311},{"_35":129,"_13":130,"_38":131,"_40":87,"_42":43,"_44":132,"_46":47,"_48":133,"_17":125,"_51":52,"_53":134,"_55":56,"_57":-5,"_82":308,"_18":309},{"_35":120,"_13":121,"_38":122,"_40":87,"_42":43,"_44":123,"_46":47,"_48":124,"_17":125,"_51":52,"_53":126,"_55":56,"_57":-5,"_82":306,"_18":307},{"_35":112,"_13":113,"_38":114,"_40":87,"_42":43,"_44":115,"_46":47,"_48":116,"_17":50,"_51":52,"_53":117,"_55":56,"_57":-5,"_82":304,"_18":305},{"_35":104,"_13":105,"_38":106,"_40":87,"_42":43,"_44":107,"_46":47,"_48":108,"_17":50,"_51":52,"_53":109,"_55":56,"_57":-5,"_82":302,"_18":303},{"_35":96,"_13":97,"_38":98,"_40":87,"_42":43,"_44":99,"_46":47,"_48":100,"_17":50,"_51":52,"_53":101,"_55":56,"_57":-5,"_82":300,"_18":301},{"_35":75,"_13":76,"_38":77,"_40":-5,"_42":43,"_44":78,"_46":47,"_48":79,"_17":80,"_51":24,"_53":81,"_55":56,"_57":-5,"_82":298,"_18":299},[],[76],[],[86,97],[],[86,105],[],[86,113],[],[86,121],[],[86,130],[292,293,294,295,296],[86],[],[138],[],[19,37],[],[19,60],[288,289],[19],[],[156,166],[],[156,175],[],[156,184],[284,285,286],[156],["D",1787213669731],["D",1789476648181],{"_11":12,"_248":244},{"_11":12,"_241":242,"_243":244,"_201":202,"_245":246,"_247":56},{"_17":78,"_13":16,"_35":43,"_233":191,"_234":-5,"_235":-5,"_236":-5,"_237":-5,"_238":-5,"_239":14,"_240":12},"ctx",{"_226":-5,"_265":366,"_367":368,"_369":370,"_371":56,"_372":56,"_373":56,"_374":47,"_375":-5,"_376":-7,"_377":-7,"_378":50,"_379":56,"_380":56,"_381":-5,"_382":56,"_383":56,"_384":56,"_385":-5},"ENV",{"_337":338,"_339":340,"_341":16,"_342":343,"_344":345,"_346":347,"_348":349,"_350":351,"_352":353,"_354":355,"_356":357,"_358":359,"_360":361,"_362":363,"_364":365},"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"]