[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_295":296,"_297":298},"routes/_app.x.$handle.$name",{"_101":100,"_32":46,"_110":91,"_27":111,"_13":14,"_112":-5,"_11":113,"_114":115,"_116":117,"_118":119,"_120":121,"_20":-5,"_122":-5,"_123":-5,"_124":25,"_125":126,"_127":60,"_128":-5,"_129":-5,"_130":131},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":60,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":84,"_85":86,"_87":88,"_89":25},"version",19,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","backend/sync.ts","latestPath","fileId","76812e1c-9c6f-11f1-878f-1607ee4eb77e","name","sync.ts","fileType","interval","content","import { listItems, updateReleaseDate } from \"../shared/db.ts\";\nimport { getMovieDetails, getTvDetails } from \"../shared/tmdb.ts\";\nimport { getGameDetails } from \"../shared/rawg.ts\";\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).\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\n console.log(\"Sync complete.\");\n}\n","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","createdAt",["D",1787215354391],"branchVersion","branchId","d9a26512-0605-40bd-b660-bf83629b1afb","id","914903c6-e97d-4c16-93fd-3038cdfece7a","release-radar",["D",1787213669731],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Upcoming movie/TV/game watchlist - Discord digest + ICS feed","imageUrl","61ffb0fe-d459-4ad3-8d91-9f9cef83669a","pinnedFileId","8b683cc6-9c6f-11f1-bd8a-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"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",{"_101":100,"_109":105},"org",{"_101":100,"_102":103,"_104":105,"_18":56,"_106":107,"_108":25},"branch",{"_13":90,"_32":91,"_44":43,"_92":45,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":46,"_99":100},"isOwned",20,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","CAS98","handle","displayName","Connor Spring","avatar","https://lh3.googleusercontent.com/a/ACg8ocIXiybVVENL2jKHwJuSnLA-b3XaCWjbMQB9VY7KWtrTm1M0_w=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_32":46,"_39":290,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":60,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":291,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":292,"_85":293,"_87":294,"_89":25},"tree",[184,188,191,192,198],"files",[184,185,186,187,188,189,190,191,192,193,194,195,196,197,198],"counts",{"_173":64,"_174":144,"_175":64,"_176":177,"_178":179},"contents",[132,133,134,135,136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":167,"_32":168,"_30":169,"_140":-5,"_42":43,"_41":170,"_142":60,"_39":171,"_13":64,"_34":153,"_36":-5,"_24":25,"_146":-5,"_27":172},{"_44":161,"_32":162,"_30":163,"_140":-5,"_42":43,"_41":164,"_142":60,"_39":165,"_13":64,"_34":153,"_36":-5,"_24":25,"_146":-5,"_27":166},{"_44":155,"_32":156,"_30":157,"_140":-5,"_42":43,"_41":158,"_142":60,"_39":159,"_13":64,"_34":153,"_36":-5,"_24":25,"_146":-5,"_27":160},{"_44":148,"_32":149,"_30":150,"_140":-5,"_42":43,"_41":151,"_142":60,"_39":152,"_13":64,"_34":153,"_36":-5,"_24":25,"_146":-5,"_27":154},{"_44":137,"_32":138,"_30":139,"_140":-5,"_42":43,"_41":141,"_142":25,"_39":143,"_13":144,"_34":20,"_36":145,"_24":25,"_146":-5,"_27":147},"08c82775-f8af-470c-a1f3-96a2e64f4061","README.md","2acc597e-9c6f-11f1-8352-1607ee4eb77e","parentId",16,"latest",["D",1787214021436],1,"# 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.\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\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 so renewed TV shows and delayed games stay accurate.\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","label",[138],"7f590045-97e3-41fb-888c-aca21d0fb7eb","shared","0bb1b29f-d2b5-4079-ab94-6db55eeb27cb",2,["D",1787213698524],"directory",[149],"ad1ba789-e2c9-4e82-9c76-767329a03280","scripts","780d0959-51ea-42e1-8918-5405201a9a7f",5,["D",1787213738461],[156],"5a8e677e-577b-4901-be56-7df8ac20dc09","frontend","16ccc6b7-e18f-4295-a9b7-48af38323d57",11,["D",1787213842216],[162],"1c670b48-4b1a-4034-aaaf-1d6a35df47de","backend","2b486220-77a5-42fd-8542-2573c787c63e",8,["D",1787213796851],[168],"pulls","branches","forks","envVars",{"_180":182,"_183":64},"connections",{"_180":64,"_181":64},"count","unfilledCount",3,"emptyCount",{"_44":167,"_32":168,"_30":169,"_140":-5,"_42":43,"_41":170,"_142":60,"_39":287,"_13":64,"_34":153,"_36":-5,"_24":25,"_146":-5,"_200":288,"_27":289},{"_44":279,"_32":280,"_30":281,"_140":169,"_42":43,"_41":282,"_142":60,"_39":283,"_13":64,"_34":35,"_36":284,"_24":25,"_146":-5,"_200":285,"_27":286},{"_44":271,"_32":272,"_30":58,"_140":169,"_42":43,"_41":273,"_142":60,"_39":274,"_13":64,"_34":275,"_36":276,"_24":25,"_146":-5,"_200":277,"_27":278},{"_44":267,"_32":33,"_30":31,"_140":169,"_42":43,"_41":14,"_142":60,"_39":268,"_13":144,"_34":35,"_36":38,"_24":25,"_146":-5,"_200":269,"_27":270},{"_44":161,"_32":162,"_30":163,"_140":-5,"_42":43,"_41":164,"_142":60,"_39":264,"_13":64,"_34":153,"_36":-5,"_24":25,"_146":-5,"_200":265,"_27":266},{"_44":256,"_32":257,"_30":258,"_140":163,"_42":43,"_41":259,"_142":60,"_39":260,"_13":64,"_34":207,"_36":261,"_24":25,"_146":-5,"_200":262,"_27":263},{"_44":249,"_32":250,"_30":251,"_140":163,"_42":43,"_41":164,"_142":60,"_39":252,"_13":64,"_34":207,"_36":253,"_24":25,"_146":-5,"_200":254,"_27":255},{"_44":155,"_32":156,"_30":157,"_140":-5,"_42":43,"_41":158,"_142":60,"_39":246,"_13":64,"_34":153,"_36":-5,"_24":25,"_146":-5,"_200":247,"_27":248},{"_44":148,"_32":149,"_30":150,"_140":-5,"_42":43,"_41":151,"_142":60,"_39":243,"_13":64,"_34":153,"_36":-5,"_24":25,"_146":-5,"_200":244,"_27":245},{"_44":235,"_32":236,"_30":237,"_140":150,"_42":43,"_41":238,"_142":60,"_39":239,"_13":144,"_34":207,"_36":240,"_24":25,"_146":-5,"_200":241,"_27":242},{"_44":227,"_32":228,"_30":229,"_140":150,"_42":43,"_41":230,"_142":60,"_39":231,"_13":144,"_34":207,"_36":232,"_24":25,"_146":-5,"_200":233,"_27":234},{"_44":219,"_32":220,"_30":221,"_140":150,"_42":43,"_41":222,"_142":60,"_39":223,"_13":64,"_34":207,"_36":224,"_24":25,"_146":-5,"_200":225,"_27":226},{"_44":211,"_32":212,"_30":213,"_140":150,"_42":43,"_41":214,"_142":60,"_39":215,"_13":64,"_34":207,"_36":216,"_24":25,"_146":-5,"_200":217,"_27":218},{"_44":203,"_32":204,"_30":205,"_140":150,"_42":43,"_41":182,"_142":60,"_39":206,"_13":64,"_34":207,"_36":208,"_24":25,"_146":-5,"_200":209,"_27":210},{"_44":137,"_32":138,"_30":139,"_140":-5,"_42":43,"_41":141,"_142":25,"_39":199,"_13":144,"_34":20,"_36":145,"_24":25,"_146":-5,"_200":201,"_27":202},["D",1787214021436],"children",[],[138],"623fb206-ebe1-4596-9f44-af2b4b89eeba","tmdb.ts","47a6f360-9c6f-11f1-aafe-1607ee4eb77e",["D",1787213718247],"script","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",[],[149,204],"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",[],[149,212],"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",[],[149,220],"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",[],[149,228],"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",[],[149,236],["D",1787213698524],[193,194,195,196,197],[149],["D",1787213738461],[],[156],"ff96554d-5050-4e19-b6b1-1cd30d47e426","root.tsx","918d5082-9c6f-11f1-adbc-1607ee4eb77e",["D",1787213842216],"/** @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",[],[162,250],"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",[],[162,257],["D",1787213842216],[189,190],[162],"4252174a-fdbb-46f1-8612-11dff8a7590f",["D",1787215354391],[],[168,33],"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",[],[168,272],"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",[],[168,280],["D",1787213796851],[185,186,187],[168],["D",1787213669731],["D",1789476648181],{"_101":100,"_109":105},{"_101":100,"_102":103,"_104":105,"_18":56,"_106":107,"_108":25},{"_13":90,"_32":91,"_44":43,"_92":45,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":46,"_99":100},"ctx",{"_83":-5,"_129":328,"_329":330,"_331":332,"_333":25,"_334":25,"_335":25,"_336":60,"_337":-5,"_338":-7,"_339":-7,"_340":64,"_341":25,"_342":25,"_343":-5,"_344":25,"_345":25,"_346":25,"_347":-5},"ENV",{"_299":300,"_301":302,"_303":91,"_304":305,"_306":307,"_308":309,"_310":311,"_312":313,"_314":315,"_316":317,"_318":319,"_320":321,"_322":323,"_324":325,"_326":327},"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"]

Diff · v19