[{"_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",{"_103":102,"_32":46,"_111":91,"_27":112,"_13":14,"_113":-5,"_11":114,"_115":116,"_117":118,"_119":120,"_121":122,"_20":-5,"_123":-5,"_124":125,"_126":25,"_127":128,"_129":60,"_130":-5,"_131":-5,"_132":133},"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",4,"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","lib/items.ts","latestPath","fileId","01a0a6a6-dc15-7190-a78e-08c3dc75143e","name","items.ts","fileType","script","content","// The game -> temporal-item boundary: a stored row in, the widget's view shape\n// out. Every field here is a VIEW decision — the server decides exactly what\n// text to show and the client is a dumb template with no knowledge of \"teams\"\n// or \"games\". There is deliberately no away/home object and no score field.\n//\n// The wire keys (`id`, `mainText`, `subText`, `caption`, `emphasized`, and the\n// Unix-second `startsAt`/`expiresAt` window) are mirrored by the Codable types\n// at Shared/WidgetPayload.swift in the iOS repo. Only add fields, never remove\n// or repurpose one, without a coordinated schemaVersion bump.\n//\n// Pure: no I/O. The team labels arrive as a snapshot the caller already read,\n// and the clock arrives as an argument.\n\nimport { channelInfo, type ChannelInfo } from \"./channels.ts\";\nimport type { Game, Team } from \"./store.ts\";\nimport { phase, type Item, type Phase, windowFrom } from \"https://esm.town/v/plusjade/source-sdk@12-main/mod.ts\";\n\n// The one competition this val serves, so a constant rather than a lookup —\n// the sports val reads this per game off its catalog because it has five.\nconst EMOJI = \"🏀\";\n\n// FIBA is 4×10-minute quarters; with breaks, review stoppages and a lopsided\n// game's clock, two hours is the wall-clock estimate. It is an ESTIMATE — this\n// val has no live ingest, and a long game reading as ended slightly early is\n// the accepted cost of deriving lifecycle from the clock instead of a stored\n// status that only moves when someone ingests. Narrow it if live ingest lands.\nconst WFIBA_TYPICAL_GAME_SECONDS = 2 * 60 * 60;\n\ntype Status = \"scheduled\" | \"live\" | \"final\";\n\n// ESPN's status.type.state is already exactly this 3-value vocabulary, so this\n// is a rename rather than the guesswork Sleeper's inconsistent vocabulary\n// needs. Anything unrecognized falls back to \"scheduled\", which is never\n// fatal — an item the client can't parse is worse than one guessed wrong.\nconst STATUS_MAP: Record = {\n pre: \"scheduled\",\n in: \"live\",\n post: \"final\",\n};\n\n// The words. `caption: null` is a protocol value, not just \"no status\" — it\n// tells the client to format `startsAt` itself as a local start time, which is\n// right for a game that hasn't started. Only live is emphasized; final gets\n// the dim treatment.\n//\n// The protocol says `current`; this function is where that becomes \"LIVE\".\n// Phase is state and belongs to the protocol, the wording belongs here.\nfunction captionFor(current: Phase): { caption: string | null; emphasized: boolean } {\n if (current === \"current\") return { caption: \"LIVE\", emphasized: true };\n if (current === \"expired\") return { caption: \"END\", emphasized: false };\n return { caption: null, emphasized: false };\n}\n\n// subText's channel metadata, built from exactly what channelInfo gives —\n// nothing invented for this format. \"TBD\" is the fallback for the one case\n// channelInfo can't fill in at all: no channel string stored.\nfunction channelText(channel: ChannelInfo): string {\n if (!channel.label) return \"TBD\";\n if (channel.directv_channel) return `${channel.label} · ${channel.directv_channel}`;\n if (channel.note) return `${channel.label} · ${channel.note}`;\n return channel.label;\n}\n\n// An opponent outside the roster keeps its ESPN code rather than having a name\n// invented for it. There is one competition here, so unlike the sports val's\n// teamLabel this needs no (sport, code) pair to disambiguate — no two entries\n// can share a code.\nfunction label(code: string | null, teams: Team[]): string {\n if (!code) return \"\";\n return teams.find((team) => team.espnCode === code)?.displayName ?? code;\n}\n\nfunction toItem(game: Game, teams: Team[], now: number): { item: Item; current: Phase } {\n const status = (game.status && STATUS_MAP[game.status]) || \"scheduled\";\n // Unix epoch SECONDS, UTC. Getting this wrong (sending ms) decodes on the\n // client as a time ~57,000 years out; nothing in a passing TypeScript-side\n // test would catch that, only a pinned integer does.\n const window = windowFrom(Math.floor(game.startTimeMs / 1000), WFIBA_TYPICAL_GAME_SECONDS);\n // The clock decides, with one exception: a stored `final` is knowledge that\n // the game ended, while the window is only an estimate that it did. Known\n // beats estimated, so a game ingested as final never reads as live. The\n // reverse does not hold — a stored `pre` on a game whose start has passed is\n // just a stale ingest, which is exactly what the window exists to route\n // around.\n const current = status === \"final\" ? \"expired\" : phase(window, now);\n return {\n item: {\n // ESPN's event id, stable across re-ingests of the same game. The parent\n // namespaces it with its own source id before it reaches the widget.\n id: game.gameId,\n mainText: `${EMOJI} ${label(game.awayCode, teams)} @ ${label(game.homeCode, teams)}`,\n subText: channelText(channelInfo(game.channel)),\n ...captionFor(current),\n ...window,\n // Transitional: consumers that predate the window still read `timestamp`.\n timestamp: window.startsAt,\n },\n current,\n };\n}\n\n// `hideCompleted` is the assignment's `intradayFilter` setting. It filters on\n// the phase computed above, not on caption text: \"END\" is a display string\n// while the phase is the actual classification. Deriving it from the clock is\n// what makes the filter agree with what the item says, rather than with\n// whenever the last ingest ran.\nexport function buildItems(\n games: Game[],\n teams: Team[],\n hideCompleted = false,\n now = Math.floor(Date.now() / 1000),\n): Item[] {\n const built = games\n .toSorted((a, b) => a.startTimeMs - b.startTimeMs)\n .map((game) => toItem(game, teams, now));\n return (hideCompleted ? built.filter((b) => b.current !== \"expired\") : built).map((b) => b.item);\n}\n","// The game -> temporal-item boundary: a stored row in, the widget's view shape\n// out. Every field here is a VIEW decision — the server decides exactly what\n// text to show and the client is a dumb template with no knowledge of \"teams\"\n// or \"games\". There is deliberately no away/home object and no score field.\n//\n// The wire keys (`id`, `mainText`, `subText`, `caption`, `emphasized`, and the\n// Unix-second `startsAt`/`expiresAt` window) are mirrored by the Codable types\n// at Shared/WidgetPayload.swift in the iOS repo. Only add fields, never remove\n// or repurpose one, without a coordinated schemaVersion bump.\n//\n// Pure: no I/O. The team labels arrive as a snapshot the caller already read,\n// and the clock arrives as an argument.\n\nimport { channelInfo, type ChannelInfo } from \"./channels.ts\";\nimport type { Game, Team } from \"./store.ts\";\nimport { phase, type Item, type Phase, windowFrom } from \"https://esm.town/v/plusjade/source-sdk@12-main/mod.ts\";\n\n// The one competition this val serves, so a constant rather than a lookup —\n// the sports val reads this per game off its catalog because it has five.\nconst EMOJI = \"🏀\";\n\n// FIBA is 4×10-minute quarters; with breaks, review stoppages and a lopsided\n// game's clock, two hours is the wall-clock estimate. It is an ESTIMATE — this\n// val has no live ingest, and a long game reading as ended slightly early is\n// the accepted cost of deriving lifecycle from the clock instead of a stored\n// status that only moves when someone ingests. Narrow it if live ingest lands.\nconst WFIBA_TYPICAL_GAME_SECONDS = 2 * 60 * 60;\n\n// The words. `caption: null` is a protocol value, not just \"no status\" — it\n// tells the client to format `startsAt` itself as a local start time, which is\n// right for a game that hasn't started. Only live is emphasized; final gets\n// the dim treatment.\n//\n// The protocol says `current`; this function is where that becomes \"LIVE\".\n// Phase is state and belongs to the protocol, the wording belongs here.\nfunction captionFor(current: Phase): { caption: string | null; emphasized: boolean } {\n if (current === \"current\") return { caption: \"LIVE\", emphasized: true };\n if (current === \"expired\") return { caption: \"END\", emphasized: false };\n return { caption: null, emphasized: false };\n}\n\n// subText's channel metadata, built from exactly what channelInfo gives —\n// nothing invented for this format. \"TBD\" is the fallback for the one case\n// channelInfo can't fill in at all: no channel string stored.\nfunction channelText(channel: ChannelInfo): string {\n if (!channel.label) return \"TBD\";\n if (channel.directv_channel) return `${channel.label} · ${channel.directv_channel}`;\n if (channel.note) return `${channel.label} · ${channel.note}`;\n return channel.label;\n}\n\n// An opponent outside the roster keeps its ESPN code rather than having a name\n// invented for it. There is one competition here, so unlike the sports val's\n// teamLabel this needs no (sport, code) pair to disambiguate — no two entries\n// can share a code.\nfunction label(code: string | null, teams: Team[]): string {\n if (!code) return \"\";\n return teams.find((team) => team.espnCode === code)?.displayName ?? code;\n}\n\nfunction toItem(game: Game, teams: Team[], now: number): Item {\n // Unix epoch SECONDS, UTC. Getting this wrong (sending ms) decodes on the\n // client as a time ~57,000 years out; nothing in a passing TypeScript-side\n // test would catch that, only a pinned integer does.\n const window = windowFrom(Math.floor(game.startTimeMs / 1000), WFIBA_TYPICAL_GAME_SECONDS);\n const current = phase(window, now);\n return {\n // ESPN's event id, stable across re-ingests of the same game. The parent\n // namespaces it with its own source id before it reaches the widget.\n id: game.gameId,\n mainText: `${EMOJI} ${label(game.awayCode, teams)} @ ${label(game.homeCode, teams)}`,\n subText: channelText(channelInfo(game.channel)),\n ...captionFor(current),\n ...window,\n // Transitional: consumers that predate the window still read `timestamp`.\n timestamp: window.startsAt,\n };\n}\n\nexport function buildItems(\n games: Game[],\n teams: Team[],\n now = Math.floor(Date.now() / 1000),\n): Item[] {\n return games\n .toSorted((a, b) => a.startTimeMs - b.startTimeMs)\n .map((game) => toItem(game, teams, now));\n}\n","createdAt",["D",1789502462212],"branchVersion","branchId","c034218d-b546-458e-8af9-7841dbdacf15","id","8cd67c66-1c13-4d59-a550-efcd693c834b","source-wfiba",["D",1788811087002],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Women's FIBA World Cup source val","imageUrl","b0a8da26-58e7-4d19-8b5c-eedf487df9a9","pinnedFileId","01a07d73-0d02-703f-be73-09449008031e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","5a10edca-919b-4a78-babb-71908f69af93","tursoName","8cd67c661c134d59a550efcd693c834b","tursoHostname","8cd67c661c134d59a550efcd693c834b-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789509043237],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_103":102,"_110":106},"org",{"_103":102,"_104":-5,"_105":106,"_18":56,"_107":108,"_109":25},"branch",{"_13":90,"_32":91,"_44":43,"_92":45,"_93":94,"_95":96,"_97":51,"_98":45,"_99":66,"_100":46,"_101":102},"isOwned",8,"remove-source-intraday","projectId","forkedBranchId","20967dcf-9eb1-4cbf-a721-cf05b71b776a","forkedBranchVersion",53,"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","plusjade","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yVHpab25kTlBTM3M3WmpCa3NMSTd5akVwWksuanBlZyJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_32":46,"_39":328,"_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":329,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":330,"_85":331,"_87":332,"_89":25},"tree",[205,213,219,220,221,222,223],"files",[205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223],"counts",{"_194":64,"_195":196,"_197":64,"_198":199,"_200":201},"contents",[140,141,142,143,144,145,146],"upstreamProject","upstreamBranch",{"_44":94,"_39":134,"_135":136,"_32":137,"_92":45,"_13":96,"_93":-5,"_95":-5,"_138":139,"_48":-5,"_89":25,"_50":51,"_101":102,"_65":66,"_100":46},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1788811087002],"updatedAt",["D",1789502869681],"main","lockfileKey","1789502869788-esm.town_v_plusjade_source-wfiba@53-main",{"_44":189,"_32":190,"_30":191,"_150":-5,"_42":43,"_41":154,"_152":60,"_39":192,"_13":64,"_34":187,"_36":-5,"_24":25,"_156":-5,"_27":193},{"_44":183,"_32":184,"_30":185,"_150":-5,"_42":43,"_41":154,"_152":60,"_39":186,"_13":64,"_34":187,"_36":-5,"_24":25,"_156":-5,"_27":188},{"_44":177,"_32":178,"_30":179,"_150":-5,"_42":43,"_41":154,"_152":25,"_39":180,"_13":64,"_34":20,"_36":181,"_24":25,"_156":-5,"_27":182},{"_44":171,"_32":172,"_30":173,"_150":-5,"_42":43,"_41":154,"_152":60,"_39":174,"_13":64,"_34":35,"_36":175,"_24":25,"_156":-5,"_27":176},{"_44":165,"_32":166,"_30":167,"_150":-5,"_42":43,"_41":154,"_152":60,"_39":168,"_13":64,"_34":35,"_36":169,"_24":25,"_156":-5,"_27":170},{"_44":158,"_32":159,"_30":160,"_150":-5,"_42":43,"_41":154,"_152":60,"_39":161,"_13":64,"_34":162,"_36":163,"_24":25,"_156":-5,"_27":164},{"_44":147,"_32":148,"_30":149,"_150":-5,"_42":43,"_41":151,"_152":60,"_39":153,"_13":154,"_34":35,"_36":155,"_24":25,"_156":-5,"_27":157},"664b5399-3123-475f-8f04-89d5f1ec8dc4","wfibaSource.ts","01a0a6a6-dc15-7190-a78e-41f4fd10f445","parentId",2,"latest",["D",1789502455110],1,"// Women's FIBA settings and ingestion policy, implemented through lib/.\n// The imported source-sdk owns request envelopes and output validation.\n\nimport { gamesFromScoreboard, scoreboard } from \"./lib/espn.ts\";\nimport { feedItems } from \"./lib/feed.ts\";\nimport { readTeams, replaceDate, type Team } from \"./lib/store.ts\";\nimport { accept, reject, defineSource } from \"https://esm.town/v/plusjade/source-sdk@12-main/mod.ts\";\n\n// parseSettings' output, not the wire shape. It carries the roster snapshot it\n// validated against so the read doesn't go back to SQLite for a second copy —\n// and so selection resolves against exactly the roster the request was checked\n// against, even if someone relabels a team mid-request.\ntype WfibaRead = {\n teams: string[];\n roster: Team[];\n};\n\n// The settings contract the parent's generic form renders, in the supported\n// subset documented at docs/source-settings-contract.md in the iOS repo: a\n// closed object whose properties are booleans and arrays of string choices,\n// with `x-group` as the only UI extension. Nothing outside that subset — no\n// nested objects, free text, numbers or conditional fields — because the\n// parent fails closed on anything it does not recognize, showing no save form\n// at all.\n//\n// Built from the roster table on every descriptor request rather than\n// hard-coded, so relabelling a team in SQLite changes the form without a\n// deploy.\nasync function settingsSchema() {\n const roster = await readTeams();\n return {\n type: \"object\",\n properties: {\n teams: {\n type: \"array\",\n title: \"Teams\",\n default: [],\n uniqueItems: true,\n description: \"Choose national teams to follow. No selection produces an empty feed.\",\n items: {\n type: \"string\",\n oneOf: roster.map((team) => ({\n const: team.slug,\n title: team.displayName,\n \"x-group\": \"FIBA Women's World Cup\",\n })),\n },\n },\n },\n required: [\"teams\"],\n additionalProperties: false,\n };\n}\n\nconst SETTING_KEYS = [\"teams\"];\n\nexport default defineSource({\n key: \"wfiba\",\n temporal: true,\n settingsSchema,\n\n // Hand-written rather than driven off settingsSchema above: the schema is\n // published for the parent's UI, and running a JSON Schema validator here to\n // re-derive checks this function states in four lines would add a dependency\n // to save nothing. They are two audiences, not one mechanism — if they ever\n // drift, this one is the one that decides.\n //\n // `unknown_team` is a distinct code from `invalid_settings` on purpose: the\n // parent can tell \"this caller's saved selection names a team we dropped\n // from the roster\" from \"this request is malformed\".\n parseSettings: async (raw) => {\n if (\n !Array.isArray(raw.teams) || !raw.teams.every((t) => typeof t === \"string\")\n || new Set(raw.teams).size !== raw.teams.length\n || Object.keys(raw).some((k) => !SETTING_KEYS.includes(k))\n ) return reject(\"invalid_settings\");\n\n const roster = await readTeams();\n const teams = raw.teams as string[];\n if (teams.some((slug) => !roster.some((team) => team.slug === slug))) {\n return reject(\"unknown_team\");\n }\n\n return accept({ teams, roster });\n },\n\n read: ({ teams, roster }, { utcOffsetSeconds }) =>\n feedItems({ teams }, utcOffsetSeconds, roster),\n\n writes: {\n // The whole ingest surface. ESPN answers Val Town's egress with 403, so an\n // external process on an unblocked network fetches one date's scoreboard\n // and posts it here; this val does the ESPN-shape-to-rows translation, so\n // that process stays a dumb pipe with no schema knowledge.\n //\n // Authoritative per date: the payload replaces that date's rows rather\n // than merging into them, so a cancelled or rescheduled game disappears\n // instead of lingering on someone's widget forever.\n \"games.ingest\": async (payload) => {\n if (\n typeof payload.dateKey !== \"string\" || !/^\\d{4}-\\d{2}-\\d{2}$/.test(payload.dateKey)\n || !scoreboard(payload.payload)\n ) return reject(\"invalid_ingest_payload\");\n\n const games = gamesFromScoreboard(payload.payload, payload.dateKey);\n await replaceDate(payload.dateKey, games);\n return accept({ dateKey: payload.dateKey, games: games.length });\n },\n },\n});\n","label",[148],"b9d1a549-92c7-4b1e-a34e-e112c9979eb4","rpc.ts","01a0a6a6-dc15-7190-a78e-3e30f9727257",["D",1789502348312],"http","// Authenticated HTTP mount for the shared SDK and Women's FIBA definition.\n// /health and /coverage are this deployment's operational routes.\nimport { diagnostics } from \"./diagnostics.ts\";\nimport { serveSource } from \"https://esm.town/v/plusjade/source-sdk@12-main/mod.ts\";\nimport wfibaSource from \"./wfibaSource.ts\";\nimport { coverage } from \"./lib/store.ts\";\n\nexport default async function handler(req: Request): Promise {\n const expected = Deno.env.get(\"SOURCE_WFIBA_V1_TOKEN\");\n if (!expected) return Response.json({ error: \"RPC token not configured\" }, { status: 503 });\n if (req.headers.get(\"authorization\") !== `Bearer ${expected}`) {\n return Response.json({ error: \"unauthorized\" }, { status: 401 });\n }\n\n const url = new URL(req.url);\n if (req.method === \"GET\" && url.pathname === \"/diagnostics\") return Response.json(await diagnostics(), { headers: { \"cache-control\": \"no-store\" } });\n if (url.pathname.startsWith(\"/v1/\")) return serveSource(wfibaSource, req);\n if (req.method === \"GET\" && url.pathname === \"/health\") return Response.json({ ok: true });\n if (req.method === \"GET\" && url.pathname === \"/coverage\") return Response.json(await coverage());\n return new Response(\"Not found\", { status: 404 });\n}\n",[159],"61105ab1-8463-4651-92d1-f95e2b308587","diagnostics.ts","01a0a6a6-dc15-7190-a78e-3a150fd83fcb",["D",1789502348312],"// Source-owned storage projection; the parent never interprets these tables.\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function diagnostics() {\n const result = await sqlite.execute(`SELECT COUNT(*) AS total,\n MIN(start_time_ms / 1000.0) AS earliest, MAX(start_time_ms / 1000.0) AS latest,\n MAX(ingested_at) AS updated FROM wfiba_games`);\n const row = result.rows[0];\n return {\n diagnosticsVersion: 1, sourceKey: \"wfiba\", scope: \"stored\",\n totalItems: Number(row.total),\n earliestTimestamp: row.earliest === null ? null : Number(row.earliest),\n latestTimestamp: row.latest === null ? null : Number(row.latest),\n lastIngestedAt: row.updated === null ? null : String(row.updated),\n };\n}\n",[166],"f356ba39-5800-4efe-a2d0-f0c740a05861","diagnostics-check.ts","01a0a6a6-dc15-7190-a78e-341c608161a0",["D",1789502348312],"// Read-only verification of the diagnostics mount and existing descriptor.\nimport handler from \"./rpc.ts\";\nconst headers = { authorization: `Bearer ${Deno.env.get(\"SOURCE_WFIBA_V1_TOKEN\")}` };\nfunction check(ok: unknown, label: string) { if (!ok) throw new Error(label); }\nconst denied = await handler(new Request(\"https://check.invalid/diagnostics\"));\ncheck(denied.status === 401, \"diagnostics requires authentication\");\nconst response = await handler(new Request(\"https://check.invalid/diagnostics\", { headers }));\ncheck(response.status === 200, \"diagnostics status\");\ncheck(response.headers.get(\"cache-control\") === \"no-store\", \"uncached diagnostics\");\nconst value = await response.json();\ncheck(value.diagnosticsVersion === 1 && value.sourceKey === \"wfiba\" && value.scope === \"stored\", \"identity\");\ncheck(Number.isSafeInteger(value.totalItems) && value.totalItems >= 0, \"total\");\ncheck(value.totalItems === 0\n ? value.earliestTimestamp === null && value.latestTimestamp === null\n : Number.isFinite(value.earliestTimestamp) && Number.isFinite(value.latestTimestamp)\n && value.earliestTimestamp <= value.latestTimestamp, \"bounds\");\nconst descriptor = await handler(new Request(\"https://check.invalid/v1/descriptor?sourceKey=wfiba\", { headers }));\ncheck(descriptor.status === 200, \"descriptor preserved\");\nconsole.log({ source: value.sourceKey, totalItems: value.totalItems,\n earliest: value.earliestTimestamp, latest: value.latestTimestamp, checks: \"passed\" });\n",[172],"b5889443-e814-4231-b179-12d19bd3dde7","README.md","01a0a6a6-dc15-7190-a78e-3252d25ad89a",["D",1789502348312],"# source-wfiba\n\nA Clark View source val serving the **2026 FIBA Women's Basketball World Cup**\n(2026-09-04 to 2026-09-14). It implements source protocol v1 and nothing else:\none source, one competition, one upstream.\n\nSplit out of `plusjade/source-sports`, which still carries its own `fiba`\ncompetition. **This val did not remove FIBA from that one** — de-duplicating the\ntwo is a separate decision with its own migration.\n\n## Layout\n\n| Path | Role |\n| --- | --- |\n| `rpc.ts` | Mount point. Bearer check, then `serveSource`. Also `/health` and `/coverage`. |\n| `wfibaSource.ts` | The source definition: settings schema, `parseSettings`, `read`, one write. |\n| Shared SDK | [source-sdk](https://www.val.town/x/plusjade/source-sdk/code/README.md), imported through `source-sdk@12-main/mod.ts`. No vendored SDK. |\n| `lib/store.ts` | The only module that touches SQLite. |\n| `lib/espn.ts` | ESPN scoreboard payload → rows. Pure. |\n| `lib/feed.ts` | Selection: each favorite's own next game. |\n| `lib/items.ts` | Rows → the widget's item shape, including the `startsAt`/`expiresAt` window and the caption derived from it. Pure. |\n| `lib/dates.ts` | Client-offset date math. Pure. |\n| `lib/channels.ts` | Broadcaster labels. Pure. |\n| `lib/schema.sql` | Complete schema and roster seed. |\n\n## Storage\n\nTwo tables, both provisioned by `tools/deploy-schema.ts` at deployment — never\nby a request.\n\n`wfiba_games` holds **one row per game**, with `away_code` and `home_code` as\nreal columns. This is the deliberate departure from `source-sports`, which\nstores a whole day's ESPN scoreboard as one JSON blob in `source_cache` and can\ntherefore only filter by team in TypeScript after loading and parsing every\nday. Here \"which games involve Spain\" is a `WHERE` clause against an index.\n\n`wfiba_teams` is the 16-nation selectable roster: slug, display name, ESPN code,\norder. It is a table rather than a `SELECT DISTINCT` over the games so the\nsettings form's choices do not depend on ingest state. Slugs match the sports\nval's catalog (`spain`, `united-states`, …), so a selection means the same thing\nin both.\n\n## Ingest\n\n**ESPN blocks Val Town's egress** — 403 Access Denied regardless of headers,\nre-verified 2026-09-12 with a default fetch (earlier header variants tested Sep 7).\nSo `read` never fetches; an external process does.\n\n`POST /v1/write` with `operation: \"games.ingest\"` and\n`{dateKey, payload}`, where `payload` is ESPN's raw scoreboard JSON. The val\ndoes the shape translation, so the ingest process stays a dumb pipe. Each date's\npayload is **authoritative**: it replaces that date's rows rather than merging,\nso a rescheduled or cancelled game disappears instead of lingering on a widget.\nIdempotent — re-running is the intended way to refresh statuses.\n\n`tools/ingest.ts` is that process. Run it off-platform:\n\n```\ndeno run --allow-net --allow-env tools/ingest.ts\n```\n\n### Operational status — 2026-09-12\n\nStorage has 36 games across nine dates, ending Sep 13. The Sep 12 semifinals are\nnow ingested: France–Germany at 14:30 UTC and Spain–USA at 18:00 UTC; the authenticated\nfeed returned both, with TBS. Sep 9–10 participants/statuses were also refreshed.\nInputs and ESPN-to-FIBA ID mapping: `tools/espn-snapshot-20260912.json`.\nThe earlier manual FIBA capture remains in `tools/fiba-snapshot-20260909.json`.\nPreserve `fiba-2026-game-{official game number}` IDs when changing providers;\nthe unchanged ESPN runner does not perform this mapping. Refreshed home/away\nfields follow ESPN's supplied roles, not the earlier first-listed-side convention.\n\nThe unchanged `tools/ingest.ts` was run in Val Town and failed before writes:\n`ESPN 403 for 2026-09-04` (evaluation `01a09666-9e55-7069-92bc-7307b4d4d729`).\nA separate Sep 12 request also returned 403. Local requests returned HTTP 200,\nincluding both semifinals: ESPN coverage is no longer limited to Sep 9.\nThe successful refresh fetched ESPN off-platform and replayed reviewed payloads\nthrough the existing `games.ingest` endpoint; no browser interaction was needed.\nTemporary probe/replay scripts were removed.\n\n**Open:** Sep 13 ESPN still returned two TBD-vs-TBD games at capture time, so the\nexisting medal-game bracket placeholders were retained. Recheck after semifinals\nand replace the complete Sep 13 date when participants are published; verify the\nteam-filtered read as well as stored coverage. Close this status when resolved.\n\n### Refresh procedure and automation assessment\n\nPreflight the required dates before writing. Reject malformed/off-bucket data and\nreview missing games or regressions from resolved teams to TBD before an authoritative\ndate replacement. Do not blindly rerun `tools/ingest.ts` over hand-verified dates:\nit has no completeness guards or FIBA ID mapping. The script was left unchanged for\nthe as-is evaluation.\n\nPrefer accessible structured ESPN data when it covers the requested games.\nUse the official FIBA tournament page and its date controls when ESPN is incomplete,\ncross-checking client-local browser times against explicit GMT times.\nA manual browser fallback has been proven; an automated FIBA parser has not.\n\nA scheduler on a tested external runtime could fetch ESPN and call `/v1/write`\nwithout computer use; the local fetch succeeded, but no unattended host was tested\nor scheduled. Direct Val Town cron execution currently encounters the same 403.\nIf a browser fallback becomes necessary, a cron can orchestrate a remote browser\n([Val Town's Kernel guide](https://docs.val.town/guides/browser-automation/kernel));\nthat needs a configured service and validated extraction, not this interactive session.\nBefore scheduling, add stable-ID mapping, completeness checks, and visible failures.\nRecheck network access from the intended scheduler before selecting it.\n\n## Settings contract\n\n`GET /v1/descriptor` publishes a closed object in the supported subset the\nparent's generic form renders: an array of 16 string choices carrying\n`const`/`title`/`x-group`, plus the `intradayFilter` boolean.\n`capabilities.validateSettings` is true and `POST /v1/validate-settings` runs\nthe same `parseSettings` a read does, without reading or leaking parsed\ninternal context.\n\n## Checks\n\nThe source check reads production data and removes its disposable fixture. All SDK imports use `https://esm.town/v/plusjade/source-sdk@12-main/mod.ts`; keep them on one snapshot and rerun this check on a branch when upgrading.\n\n- `tools/source-contract-check.ts` — 46 assertions over the whole HTTP surface,\n plus pinned pure-function behaviour (Unix seconds, the two-hour window and\n the captions derived from it, per-team selection, the ingest date filter) and\n a disposable row on `1900-01-01`.\nShared protocol conformance and boundary checks now live in `plusjade/source-sdk/tools/sdk-check.ts`.\n",[178],"4c0bc91c-66dd-4a65-91d0-443527a3dee8","tools","01a0a6a6-dc15-7190-a78e-2c2cac7dbcfe",["D",1789502348312],"directory",[184],"92bb6bf0-91a3-48aa-8956-f9987fa7b95d","lib","01a0a6a6-dc15-7190-a78e-1586da6b9ca2",["D",1789502348312],[190],"pulls","branches",5,"forks","envVars",{"_202":14,"_204":64},"connections",{"_202":64,"_203":64},"count","unfilledCount","emptyCount",{"_44":189,"_32":190,"_30":191,"_150":-5,"_42":43,"_41":154,"_152":60,"_39":325,"_13":64,"_34":187,"_36":-5,"_24":25,"_156":-5,"_225":326,"_27":327},{"_44":318,"_32":319,"_30":320,"_150":191,"_42":43,"_41":154,"_152":60,"_39":321,"_13":64,"_34":35,"_36":322,"_24":25,"_156":-5,"_225":323,"_27":324},{"_44":311,"_32":312,"_30":313,"_150":191,"_42":43,"_41":154,"_152":25,"_39":314,"_13":64,"_34":35,"_36":315,"_24":25,"_156":-5,"_225":316,"_27":317},{"_44":304,"_32":305,"_30":306,"_150":191,"_42":43,"_41":154,"_152":60,"_39":307,"_13":64,"_34":35,"_36":308,"_24":25,"_156":-5,"_225":309,"_27":310},{"_44":296,"_32":297,"_30":298,"_150":191,"_42":43,"_41":299,"_152":60,"_39":300,"_13":154,"_34":35,"_36":301,"_24":25,"_156":-5,"_225":302,"_27":303},{"_44":292,"_32":33,"_30":31,"_150":191,"_42":43,"_41":14,"_152":60,"_39":293,"_13":154,"_34":35,"_36":38,"_24":25,"_156":-5,"_225":294,"_27":295},{"_44":285,"_32":286,"_30":287,"_150":191,"_42":43,"_41":154,"_152":60,"_39":288,"_13":64,"_34":20,"_36":289,"_24":25,"_156":-5,"_225":290,"_27":291},{"_44":278,"_32":279,"_30":280,"_150":191,"_42":43,"_41":154,"_152":60,"_39":281,"_13":64,"_34":35,"_36":282,"_24":25,"_156":-5,"_225":283,"_27":284},{"_44":183,"_32":184,"_30":185,"_150":-5,"_42":43,"_41":154,"_152":60,"_39":275,"_13":64,"_34":187,"_36":-5,"_24":25,"_156":-5,"_225":276,"_27":277},{"_44":268,"_32":269,"_30":270,"_150":185,"_42":43,"_41":154,"_152":60,"_39":271,"_13":64,"_34":35,"_36":272,"_24":25,"_156":-5,"_225":273,"_27":274},{"_44":261,"_32":262,"_30":263,"_150":185,"_42":43,"_41":154,"_152":60,"_39":264,"_13":64,"_34":20,"_36":265,"_24":25,"_156":-5,"_225":266,"_27":267},{"_44":254,"_32":255,"_30":256,"_150":185,"_42":43,"_41":154,"_152":60,"_39":257,"_13":64,"_34":20,"_36":258,"_24":25,"_156":-5,"_225":259,"_27":260},{"_44":247,"_32":248,"_30":249,"_150":185,"_42":43,"_41":154,"_152":60,"_39":250,"_13":64,"_34":35,"_36":251,"_24":25,"_156":-5,"_225":252,"_27":253},{"_44":240,"_32":241,"_30":242,"_150":185,"_42":43,"_41":154,"_152":25,"_39":243,"_13":64,"_34":35,"_36":244,"_24":25,"_156":-5,"_225":245,"_27":246},{"_44":177,"_32":178,"_30":179,"_150":-5,"_42":43,"_41":154,"_152":25,"_39":237,"_13":64,"_34":20,"_36":181,"_24":25,"_156":-5,"_225":238,"_27":239},{"_44":171,"_32":172,"_30":173,"_150":-5,"_42":43,"_41":154,"_152":60,"_39":234,"_13":64,"_34":35,"_36":175,"_24":25,"_156":-5,"_225":235,"_27":236},{"_44":165,"_32":166,"_30":167,"_150":-5,"_42":43,"_41":154,"_152":60,"_39":231,"_13":64,"_34":35,"_36":169,"_24":25,"_156":-5,"_225":232,"_27":233},{"_44":158,"_32":159,"_30":160,"_150":-5,"_42":43,"_41":154,"_152":60,"_39":228,"_13":64,"_34":162,"_36":163,"_24":25,"_156":-5,"_225":229,"_27":230},{"_44":147,"_32":148,"_30":149,"_150":-5,"_42":43,"_41":151,"_152":60,"_39":224,"_13":154,"_34":35,"_36":155,"_24":25,"_156":-5,"_225":226,"_27":227},["D",1789502455110],"children",[],[148],["D",1789502348312],[],[159],["D",1789502348312],[],[166],["D",1789502348312],[],[172],["D",1789502348312],[],[178],"864a95bb-bcbe-4716-810f-6579e92a7667","source-contract-check.ts","01a0a6a6-dc15-7190-a78e-2b1f1e510fa7",["D",1789502348312],"// Contract check for this val's whole HTTP surface. Reads production data and\n// exercises one disposable game row on a date the tournament cannot occupy,\n// which it always removes.\n\nimport handler from \"../rpc.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { items, phase } from \"https://esm.town/v/plusjade/source-sdk@12-main/mod.ts\";\nimport { gamesFromScoreboard } from \"../lib/espn.ts\";\nimport { nextPerTeam } from \"../lib/feed.ts\";\nimport { buildItems } from \"../lib/items.ts\";\nimport { clientOffsetSeconds, dayStartMsAtOffset } from \"../lib/dates.ts\";\n\nfunction assert(ok: unknown, msg: string) {\n if (!ok) throw new Error(msg);\n}\n\nconst token = Deno.env.get(\"SOURCE_WFIBA_V1_TOKEN\");\nfunction call(path: string, body?: unknown, auth = true) {\n return handler(new Request(\"https://source.invalid\" + path, {\n method: body ? \"POST\" : \"GET\",\n headers: auth ? { authorization: `Bearer ${token}` } : {},\n body: body ? JSON.stringify(body) : undefined,\n }));\n}\n\nlet checks = 0;\nconst ok = async (condition: unknown, msg: string) => {\n assert(await condition, msg);\n checks++;\n};\n\n// ------------------------------------------------------------------- auth --\nawait ok((await call(\"/v1/descriptor\", undefined, false)).status === 401, \"unauthenticated descriptor\");\n\n// ------------------------------------------------------------- descriptor --\nconst descriptor = await (await call(\"/v1/descriptor\")).json();\nawait ok(descriptor.sourceKey === \"wfiba\" && descriptor.protocolVersion === 1, \"descriptor identity\");\nawait ok(descriptor.temporal === true, \"temporal\");\nawait ok(descriptor.capabilities.publish === false && descriptor.capabilities.validateSettings === true,\n \"advertised capabilities\");\nawait ok(JSON.stringify(descriptor.capabilities.write) === JSON.stringify([\"games.ingest\"]),\n \"advertised writes\");\n\n// The settings contract the parent's generic form consumes. These assertions\n// are the supported subset itself, not incidental shape: a closed object,\n// declared choices carrying const/title, and the boolean.\nconst schema = descriptor.settingsSchema;\nawait ok(schema.type === \"object\" && schema.additionalProperties === false, \"closed settings object\");\nawait ok(schema.required[0] === \"teams\", \"teams required\");\nawait ok(schema.properties.teams.items.oneOf.length === 16, \"sixteen national teams\");\nawait ok(schema.properties.teams.items.oneOf.every((c: Record) =>\n typeof c.const === \"string\" && typeof c.title === \"string\" && typeof c[\"x-group\"] === \"string\"),\n \"choice shape\");\nawait ok(schema.properties.intradayFilter.type === \"boolean\", \"intradayFilter is a checkbox\");\n\n// --------------------------------------------------------- validate-settings --\nconst validated = await call(\"/v1/validate-settings\", {\n protocolVersion: 1, sourceKey: \"wfiba\", settings: { teams: [\"spain\"], intradayFilter: true },\n});\nconst validatedBody = await validated.json();\nawait ok(validated.ok && validatedBody.ok === true, \"validate-settings accepts a good selection\");\n// parseSettings' output carries a roster snapshot; it must never be exported.\nawait ok(!(\"roster\" in validatedBody) && Object.keys(validatedBody).length === 3,\n \"validate-settings leaks no internal context\");\nawait ok((await call(\"/v1/validate-settings\", {\n protocolVersion: 1, sourceKey: \"wfiba\", settings: { teams: [\"not-a-team\"] },\n})).status === 400, \"validate-settings rejects an unknown team\");\n\n// -------------------------------------------------------------------- read --\nconst base = {\n protocolVersion: 1,\n sourceKey: \"wfiba\",\n settings: { teams: [\"united-states\"], intradayFilter: false },\n context: { utcOffsetSeconds: -25200 },\n};\nconst read = await call(\"/v1/read\", base);\nconst body = await read.json();\nawait ok(read.ok && items(body.items), \"read satisfies the item contract\");\n\n// A null offset is the documented \"parent had nothing to forward\" case: it\n// must resolve to this source's own default zone, not fail and not shift to UTC.\nawait ok((await call(\"/v1/read\", { ...base, context: { utcOffsetSeconds: null } })).ok, \"null offset\");\n\n// An empty selection is a valid request producing an empty feed, never the\n// whole tournament.\nconst empty = await call(\"/v1/read\", { ...base, settings: { teams: [], intradayFilter: false } });\nawait ok(empty.ok && (await empty.json()).items.length === 0, \"empty selection yields empty feed\");\n\nawait ok((await call(\"/v1/read\", { ...base, settings: { teams: [\"not-a-team\"] } })).status === 400, \"unknown team\");\nawait ok((await call(\"/v1/read\", { ...base, settings: { teams: [\"spain\", \"spain\"] } })).status === 400, \"duplicate team\");\nawait ok((await call(\"/v1/read\", { ...base, settings: { teams: [], unexpected: 1 } })).status === 400, \"unknown setting\");\nawait ok((await call(\"/v1/read\", { ...base, sourceKey: \"sports\" })).status === 404, \"foreign source key\");\nawait ok((await call(\"/v1/read\", { ...base, protocolVersion: 2 })).status === 400, \"protocol version\");\n\n// ------------------------------------------------------------------ writes --\nawait ok((await call(\"/v1/publish\", base)).status === 501, \"publish stub\");\nawait ok((await call(\"/v1/write\", { ...base, operation: \"sql\", payload: {} })).status === 422, \"unsupported write\");\nawait ok((await call(\"/v1/write\", { ...base, operation: \"cache.put\", payload: {} })).status === 422,\n \"the sports val's write name is not implemented here\");\nawait ok((await call(\"/v1/write\", {\n ...base, operation: \"games.ingest\", payload: { dateKey: \"not-a-date\", payload: {} },\n})).status === 400, \"malformed ingest date\");\nawait ok((await call(\"/v1/write\", {\n ...base, operation: \"games.ingest\", payload: { dateKey: \"2026-09-05\", payload: [] },\n})).status === 400, \"non-object scoreboard\");\n\n// ------------------------------------------------------------------- pure --\n// The rules most worth pinning, checked directly rather than through HTTP.\n//\n// Unix SECONDS. A pinned integer is the only thing that catches a milliseconds\n// regression — both are numbers, so no type check and no live-data test would.\nconst fixture = [{\n gameId: \"g1\", startTimeMs: 1788806700000, awayCode: \"USA\", homeCode: \"CZE\",\n status: \"post\", channel: \"TNT\",\n}];\nconst built = buildItems(fixture, [{ slug: \"united-states\", displayName: \"USA\", espnCode: \"USA\" }]);\nawait ok(built[0].startsAt === 1788806700, \"startsAt is Unix seconds\");\nawait ok(built[0].timestamp === 1788806700, \"the transitional timestamp still mirrors startsAt\");\nawait ok(built[0].expiresAt === 1788806700 + 7200, \"the window is the source's own typical duration\");\nawait ok(built[0].mainText === \"🏀 USA @ CZE\", \"unrostered opponent keeps its ESPN code\");\nawait ok(built[0].caption === \"END\" && built[0].emphasized === false, \"final caption\");\nawait ok(buildItems(fixture, [], true).length === 0, \"intradayFilter drops a final game\");\n\n// Lifecycle now comes from the clock, so a stale `pre` status on a game that\n// has already started still reads LIVE — the freshness this window buys, with\n// no ingest between the two calls below.\nconst scheduled = [{ ...fixture[0], gameId: \"g2\", status: \"pre\" }];\nconst start = 1788806700;\nawait ok(buildItems(scheduled, [], false, start - 1)[0].caption === null, \"before start: client formats the time\");\nawait ok(buildItems(scheduled, [], false, start + 60)[0].caption === \"LIVE\", \"a stale `pre` still reads live once started\");\nawait ok(buildItems(scheduled, [], false, start + 7200)[0].caption === \"END\", \"expired by the clock alone\");\n// A stored `final` is knowledge and outranks the estimate.\nawait ok(buildItems(fixture, [], false, start + 60)[0].caption === \"END\", \"an ingested final is never live\");\nawait ok(\n phase(buildItems(scheduled, [], false, start)[0], start) === \"current\",\n \"phase agrees with the caption the source chose\",\n);\n\n// Each favorite's own next game, unioned — not one shared earliest, which\n// would silently drop every other favorite playing later.\nconst a = { gameId: \"a\", startTimeMs: 1000, awayCode: \"ESP\", homeCode: \"FRA\", status: null, channel: null };\nconst b = { gameId: \"b\", startTimeMs: 2000, awayCode: \"USA\", homeCode: \"CHN\", status: null, channel: null };\nawait ok(nextPerTeam([a, b], [\"ESP\", \"USA\"]).length === 2, \"each favorite resolves independently\");\nawait ok(nextPerTeam([a], [\"ESP\", \"FRA\"]).length === 1, \"two favorites in one game dedupe\");\n\n// The ingest's date filter drops an event ESPN files under the wrong bucket.\nconst scoreboardFixture = {\n events: [\n { id: \"in\", date: \"2026-09-05T09:30Z\", competitions: [{ competitors: [] }] },\n { id: \"out\", date: \"2026-09-06T09:30Z\", competitions: [{ competitors: [] }] },\n ],\n};\nconst mapped = gamesFromScoreboard(scoreboardFixture, \"2026-09-05\");\nawait ok(mapped.length === 1 && mapped[0].gameId === \"in\", \"ingest keeps only the requested date\");\n\n// A far-east client must still see a game that falls inside their local today\n// but carries the previous UTC date. This is the case source-sports gets wrong:\n// it derives a cache-scan floor from the local date while its payloads are\n// bucketed by UTC date, so it drops the game entirely. Filtering on the\n// absolute instant, as here, is what makes that unrepresentable.\nconst fromMs = dayStartMsAtOffset(clientOffsetSeconds(50400), new Date(\"2026-09-07T20:15:00Z\"));\nawait ok(fromMs <= Date.parse(\"2026-09-07T18:45:00Z\"), \"UTC+14 lower bound still admits today's UTC games\");\n\n// ---------------------------------------------------------------- storage --\n// A date the tournament cannot occupy, so a leaked fixture is obvious.\nconst dateKey = \"1900-01-01\";\nconst before = await sqlite.execute({\n sql: \"SELECT count(*) AS n FROM wfiba_games WHERE date_key = ?\", args: [dateKey],\n});\nassert(Number(before.rows[0].n) === 0, \"fixture date already occupied\");\n\ntry {\n const write = await call(\"/v1/write\", {\n protocolVersion: 1, sourceKey: \"wfiba\", operation: \"games.ingest\",\n payload: {\n dateKey,\n payload: {\n events: [{\n id: \"contract-fixture\",\n date: \"1900-01-01T00:00Z\",\n competitions: [{\n competitors: [\n { homeAway: \"home\", team: { abbreviation: \"ESP\" } },\n { homeAway: \"away\", team: { abbreviation: \"USA\" } },\n ],\n status: { type: { state: \"pre\" } },\n broadcasts: [{ names: [\"TNT\"] }],\n }],\n }],\n },\n },\n });\n await ok(write.ok, \"ingest write accepted\");\n\n const stored = await sqlite.execute({\n sql: \"SELECT away_code, home_code, status, channel FROM wfiba_games WHERE date_key = ?\", args: [dateKey],\n });\n await ok(stored.rows.length === 1, \"one row written\");\n // The redesign's whole point: the teams landed in queryable columns.\n await ok(stored.rows[0].away_code === \"USA\" && stored.rows[0].home_code === \"ESP\",\n \"team codes stored as columns\");\n await ok(stored.rows[0].status === \"pre\" && stored.rows[0].channel === \"TNT\", \"status and channel stored\");\n\n // Re-ingesting the same date with an empty slate must remove it, not merge.\n await call(\"/v1/write\", {\n protocolVersion: 1, sourceKey: \"wfiba\", operation: \"games.ingest\",\n payload: { dateKey, payload: { events: [] } },\n });\n const after = await sqlite.execute({\n sql: \"SELECT count(*) AS n FROM wfiba_games WHERE date_key = ?\", args: [dateKey],\n });\n await ok(Number(after.rows[0].n) === 0, \"re-ingest replaces a date rather than merging into it\");\n\n console.log(JSON.stringify({ ok: true, checks, items: body.items.length, fixtureDate: dateKey }));\n} finally {\n await sqlite.execute({ sql: \"DELETE FROM wfiba_games WHERE date_key = ?\", args: [dateKey] });\n}\n",[],[184,241],"a414d835-3059-4e22-99c5-7f353709993e","ingest.ts","01a0a6a6-dc15-7190-a78e-24f157493326",["D",1789502348312],"// The external ingest process, in one file.\n//\n// DO NOT RUN THIS IN VAL TOWN. It is the one tool here that cannot work on\n// platform: ESPN answers Val Town's shared egress with 403 Access Denied\n// regardless of headers. Run it from a normal network:\n//\n// deno run --allow-net --allow-env tools/ingest.ts\n//\n// with SOURCE_WFIBA_V1_TOKEN set. It fetches each tournament date's scoreboard\n// and posts it to /v1/write, where the val turns it into rows. This side stays\n// a dumb pipe: it knows the ESPN URL and nothing about the schema.\n//\n// Re-run it to pick up knockout fixtures. ESPN publishes the bracket late — as\n// of 2026-09-07 only the four group-stage dates (09-04..09-07, 24 games) exist\n// and 09-08 onward return zero events — so the tournament is NOT fully\n// ingested until this has been run again nearer the end. Each date's ingest is\n// authoritative and idempotent, so running it repeatedly is safe and is the\n// intended way to refresh live statuses.\n\nconst ENDPOINT = \"https://plusjade--01a07d730d02703fbe7309449008031e.web.val.run\";\nconst TOKEN = Deno.env.get(\"SOURCE_WFIBA_V1_TOKEN\");\nif (!TOKEN) throw new Error(\"SOURCE_WFIBA_V1_TOKEN is required\");\n\n// The 2026 Women's World Cup runs 2026-09-04 to 2026-09-14 (ESPN's own season\n// bounds for league 53). Dates outside it have nothing to ingest.\nconst START = \"2026-09-04\";\nconst END = \"2026-09-14\";\n\nfunction* dateRange(from: string, to: string): Generator {\n for (\n let day = new Date(`${from}T00:00:00Z`);\n day <= new Date(`${to}T00:00:00Z`);\n day.setUTCDate(day.getUTCDate() + 1)\n ) yield day.toISOString().slice(0, 10);\n}\n\nlet seen = 0;\nlet written = 0;\nfor (const dateKey of dateRange(START, END)) {\n const espn = await fetch(\n `https://site.api.espn.com/apis/site/v2/sports/basketball/fiba/scoreboard?dates=${dateKey.replaceAll(\"-\", \"\")}`,\n );\n if (!espn.ok) throw new Error(`ESPN ${espn.status} for ${dateKey}`);\n const payload = await espn.json();\n const events: { id: string; date: string }[] = payload.events ?? [];\n\n // Cross-check the val's own date filter. It keeps only events whose UTC date\n // equals the requested key; if ESPN ever files a game under a bucket that\n // does not match its own date, and no other bucket carries it, that game\n // would be silently dropped by every ingest. Reported rather than assumed\n // away — it has not happened for this tournament, but it is the failure that\n // would be invisible.\n const offBucket = events.filter((event) => event.date.slice(0, 10) !== dateKey).map((event) => event.id);\n\n const res = await fetch(`${ENDPOINT}/v1/write`, {\n method: \"POST\",\n headers: { authorization: `Bearer ${TOKEN}`, \"content-type\": \"application/json\" },\n body: JSON.stringify({\n protocolVersion: 1,\n sourceKey: \"wfiba\",\n operation: \"games.ingest\",\n payload: { dateKey, payload },\n }),\n });\n const body = await res.json();\n if (!res.ok) throw new Error(`write failed for ${dateKey}: ${JSON.stringify(body)}`);\n\n seen += events.length;\n written += body.result.games;\n console.log(\n `${dateKey} espn=${String(events.length).padStart(2)} written=${String(body.result.games).padStart(2)}` +\n (offBucket.length ? ` OFF-BUCKET ${offBucket.join(\",\")}` : \"\"),\n );\n}\n\nconsole.log(`\\ntotal: ${seen} ESPN events seen, ${written} games written`);\n",[],[184,248],"70b3a823-364a-4cca-b719-36c255eb905e","fiba-snapshot-20260909.json","01a0a6a6-dc15-7190-a78e-209110c1b3f2",["D",1789502348312],"{\n \"capturedAt\": \"2026-09-09T02:53:11Z\",\n \"sourceUrl\": \"https://www.fiba.basketball/en/events/fiba-womens-basketball-world-cup-2026/games\",\n \"scheduleUrl\": \"https://assets.fiba.basketball/image/upload/fiba-womens-basketball-world-cup-208875-game-schedule.pdf\",\n \"notes\": [\n \"Manually transcribed FIBA schedule, ingested through games.ingest in ESPN-compatible envelopes; not ESPN data.\",\n \"IDs use fiba-2026-game-{official game number}; first listed side is home.\",\n \"Broadcasts not verified, left null.\",\n \"Games 33 and 34 on September 12 have unassigned start times (14:30 or 18:00 UTC) and were not ingested.\",\n \"Bracket labels do not match favorite-team codes until participants are resolved. Refresh these rows as results become available.\",\n \"Do not run the ESPN ingest over these dates with empty or incomplete payloads: writes replace dates authoritatively.\"\n ],\n \"columns\": [\n \"gameNumber\",\n \"dateKey\",\n \"utcTime\",\n \"homeCodeOrBracket\",\n \"awayCodeOrBracket\",\n \"status\"\n ],\n \"fixtures\": [\n [\n 26,\n \"2026-09-08\",\n \"15:45\",\n \"HUN\",\n \"JPN\",\n \"post\"\n ],\n [\n 25,\n \"2026-09-08\",\n \"18:45\",\n \"GER\",\n \"KOR\",\n \"post\"\n ],\n [\n 28,\n \"2026-09-09\",\n \"15:45\",\n \"PUR\",\n \"CHN\",\n \"pre\"\n ],\n [\n 27,\n \"2026-09-09\",\n \"18:45\",\n \"ITA\",\n \"AUS\",\n \"pre\"\n ],\n [\n 32,\n \"2026-09-10\",\n \"09:30\",\n \"USA\",\n \"HUN\",\n \"pre\"\n ],\n [\n 30,\n \"2026-09-10\",\n \"12:30\",\n \"Winner of Game 28\",\n \"FRA\",\n \"pre\"\n ],\n [\n 31,\n \"2026-09-10\",\n \"15:45\",\n \"BEL\",\n \"GER\",\n \"pre\"\n ],\n [\n 29,\n \"2026-09-10\",\n \"18:45\",\n \"Winner of Game 27\",\n \"ESP\",\n \"pre\"\n ],\n [\n 35,\n \"2026-09-13\",\n \"14:30\",\n \"Loser of Game 33\",\n \"Loser of Game 34\",\n \"pre\"\n ],\n [\n 36,\n \"2026-09-13\",\n \"18:00\",\n \"Winner of Game 33\",\n \"Winner of Game 34\",\n \"pre\"\n ]\n ]\n}",[],[184,255],"1acec332-93c2-4e1c-9644-4d484b82f8d3","espn-snapshot-20260912.json","01a0a6a6-dc15-7190-a78e-1ebdf078479f",["D",1789502348312],"{\n \"observedOn\": \"2026-09-12\",\n \"upstream\": \"https://site.api.espn.com/apis/site/v2/sports/basketball/fiba/scoreboard?dates=YYYYMMDD\",\n \"confirmation\": \"https://www.fiba.basketball/en/news/semi-finals-set-at-the-fiba-womens-basketball-world-cup-2026\",\n \"notes\": [\n \"ESPN fetched off-platform: local HTTP 200; Val Town HTTP 403.\",\n \"Projection preserves fields consumed by current ingest; ESPN event IDs mapped to existing FIBA game IDs.\",\n \"Home/away uses ESPN's supplied homeAway, not the previous manual first-listed-side convention.\",\n \"September 13 still has TBD vs TBD in ESPN; existing bracket placeholders retained.\",\n \"No cron configured; refresh again after semifinals to resolve medal participants.\"\n ],\n \"espnToFibaGameNumber\": {\n \"401917251\": 28,\n \"401917252\": 27,\n \"401917253\": 29,\n \"401917254\": 30,\n \"401917255\": 31,\n \"401917256\": 32,\n \"401917257\": 33,\n \"401917258\": 34\n },\n \"payloads\": [\n {\n \"dateKey\": \"2026-09-09\",\n \"payload\": {\n \"events\": [\n {\n \"id\": \"fiba-2026-game-28\",\n \"date\": \"2026-09-09T15:45Z\",\n \"name\": \"PUR VS CHN\",\n \"competitions\": [\n {\n \"competitors\": [\n {\n \"homeAway\": \"home\",\n \"team\": {\n \"abbreviation\": \"CHN\"\n }\n },\n {\n \"homeAway\": \"away\",\n \"team\": {\n \"abbreviation\": \"PUR\"\n }\n }\n ],\n \"status\": {\n \"clock\": 0,\n \"displayClock\": \"0:00\",\n \"period\": 4,\n \"type\": {\n \"id\": \"3\",\n \"name\": \"STATUS_FINAL\",\n \"state\": \"post\",\n \"completed\": true,\n \"description\": \"Final\",\n \"detail\": \"Final\",\n \"shortDetail\": \"Final\"\n }\n },\n \"broadcasts\": [\n {\n \"market\": \"national\",\n \"names\": [\n \"HBO Max\"\n ]\n }\n ],\n \"notes\": [\n {\n \"type\": \"event\",\n \"headline\": \"FIBA Women’s World Cup - Qualification to Quarterfinals\"\n }\n ]\n }\n ]\n },\n {\n \"id\": \"fiba-2026-game-27\",\n \"date\": \"2026-09-09T18:45Z\",\n \"name\": \"ITA VS AUS\",\n \"competitions\": [\n {\n \"competitors\": [\n {\n \"homeAway\": \"home\",\n \"team\": {\n \"abbreviation\": \"AUS\"\n }\n },\n {\n \"homeAway\": \"away\",\n \"team\": {\n \"abbreviation\": \"ITA\"\n }\n }\n ],\n \"status\": {\n \"clock\": 0,\n \"displayClock\": \"0:00\",\n \"period\": 4,\n \"type\": {\n \"id\": \"3\",\n \"name\": \"STATUS_FINAL\",\n \"state\": \"post\",\n \"completed\": true,\n \"description\": \"Final\",\n \"detail\": \"Final\",\n \"shortDetail\": \"Final\"\n }\n },\n \"broadcasts\": [\n {\n \"market\": \"national\",\n \"names\": [\n \"truTV\",\n \"HBO Max\"\n ]\n }\n ],\n \"notes\": [\n {\n \"type\": \"event\",\n \"headline\": \"FIBA Women’s World Cup - Qualification to Quarterfinals\"\n }\n ]\n }\n ]\n }\n ]\n }\n },\n {\n \"dateKey\": \"2026-09-10\",\n \"payload\": {\n \"events\": [\n {\n \"id\": \"fiba-2026-game-32\",\n \"date\": \"2026-09-10T09:30Z\",\n \"name\": \"USA VS HUN\",\n \"competitions\": [\n {\n \"competitors\": [\n {\n \"homeAway\": \"home\",\n \"team\": {\n \"abbreviation\": \"HUN\"\n }\n },\n {\n \"homeAway\": \"away\",\n \"team\": {\n \"abbreviation\": \"USA\"\n }\n }\n ],\n \"status\": {\n \"clock\": 0,\n \"displayClock\": \"0:00\",\n \"period\": 4,\n \"type\": {\n \"id\": \"3\",\n \"name\": \"STATUS_FINAL\",\n \"state\": \"post\",\n \"completed\": true,\n \"description\": \"Final\",\n \"detail\": \"Final\",\n \"shortDetail\": \"Final\"\n }\n },\n \"broadcasts\": [\n {\n \"market\": \"national\",\n \"names\": [\n \"TNT\",\n \"truTV\"\n ]\n }\n ],\n \"notes\": [\n {\n \"type\": \"event\",\n \"headline\": \"FIBA Women’s World Cup – Quarterfinals\"\n }\n ]\n }\n ]\n },\n {\n \"id\": \"fiba-2026-game-30\",\n \"date\": \"2026-09-10T12:30Z\",\n \"name\": \"CHN VS FRA\",\n \"competitions\": [\n {\n \"competitors\": [\n {\n \"homeAway\": \"home\",\n \"team\": {\n \"abbreviation\": \"FRA\"\n }\n },\n {\n \"homeAway\": \"away\",\n \"team\": {\n \"abbreviation\": \"CHN\"\n }\n }\n ],\n \"status\": {\n \"clock\": 0,\n \"displayClock\": \"0:00\",\n \"period\": 4,\n \"type\": {\n \"id\": \"3\",\n \"name\": \"STATUS_FINAL\",\n \"state\": \"post\",\n \"completed\": true,\n \"description\": \"Final\",\n \"detail\": \"Final\",\n \"shortDetail\": \"Final\"\n }\n },\n \"broadcasts\": [\n {\n \"market\": \"national\",\n \"names\": [\n \"truTV\"\n ]\n }\n ],\n \"notes\": [\n {\n \"type\": \"event\",\n \"headline\": \"FIBA Women’s World Cup – Quarterfinals\"\n }\n ]\n }\n ]\n },\n {\n \"id\": \"fiba-2026-game-31\",\n \"date\": \"2026-09-10T15:45Z\",\n \"name\": \"BEL VS GER\",\n \"competitions\": [\n {\n \"competitors\": [\n {\n \"homeAway\": \"home\",\n \"team\": {\n \"abbreviation\": \"GER\"\n }\n },\n {\n \"homeAway\": \"away\",\n \"team\": {\n \"abbreviation\": \"BEL\"\n }\n }\n ],\n \"status\": {\n \"clock\": 0,\n \"displayClock\": \"0:00\",\n \"period\": 4,\n \"type\": {\n \"id\": \"3\",\n \"name\": \"STATUS_FINAL\",\n \"state\": \"post\",\n \"completed\": true,\n \"description\": \"Final\",\n \"detail\": \"Final\",\n \"shortDetail\": \"Final\"\n }\n },\n \"broadcasts\": [\n {\n \"market\": \"national\",\n \"names\": [\n \"truTV\"\n ]\n }\n ],\n \"notes\": [\n {\n \"type\": \"event\",\n \"headline\": \"FIBA Women’s World Cup – Quarterfinals\"\n }\n ]\n }\n ]\n },\n {\n \"id\": \"fiba-2026-game-29\",\n \"date\": \"2026-09-10T18:45Z\",\n \"name\": \"AUS VS ESP\",\n \"competitions\": [\n {\n \"competitors\": [\n {\n \"homeAway\": \"home\",\n \"team\": {\n \"abbreviation\": \"ESP\"\n }\n },\n {\n \"homeAway\": \"away\",\n \"team\": {\n \"abbreviation\": \"AUS\"\n }\n }\n ],\n \"status\": {\n \"clock\": 0,\n \"displayClock\": \"0:00\",\n \"period\": 4,\n \"type\": {\n \"id\": \"3\",\n \"name\": \"STATUS_FINAL\",\n \"state\": \"post\",\n \"completed\": true,\n \"description\": \"Final\",\n \"detail\": \"Final\",\n \"shortDetail\": \"Final\"\n }\n },\n \"broadcasts\": [\n {\n \"market\": \"national\",\n \"names\": [\n \"truTV\"\n ]\n }\n ],\n \"notes\": [\n {\n \"type\": \"event\",\n \"headline\": \"FIBA Women’s World Cup – Quarterfinals\"\n }\n ]\n }\n ]\n }\n ]\n }\n },\n {\n \"dateKey\": \"2026-09-12\",\n \"payload\": {\n \"events\": [\n {\n \"id\": \"fiba-2026-game-34\",\n \"date\": \"2026-09-12T14:30Z\",\n \"name\": \"FRA VS GER\",\n \"competitions\": [\n {\n \"competitors\": [\n {\n \"homeAway\": \"home\",\n \"team\": {\n \"abbreviation\": \"GER\"\n }\n },\n {\n \"homeAway\": \"away\",\n \"team\": {\n \"abbreviation\": \"FRA\"\n }\n }\n ],\n \"status\": {\n \"clock\": 0,\n \"displayClock\": \"0:00\",\n \"period\": 4,\n \"type\": {\n \"id\": \"3\",\n \"name\": \"STATUS_FINAL\",\n \"state\": \"post\",\n \"completed\": true,\n \"description\": \"Final\",\n \"detail\": \"Final\",\n \"shortDetail\": \"Final\"\n }\n },\n \"broadcasts\": [\n {\n \"market\": \"national\",\n \"names\": [\n \"TBS\",\n \"truTV\"\n ]\n }\n ],\n \"notes\": [\n {\n \"type\": \"event\",\n \"headline\": \"FIBA Women’s World Cup – Semifinals\"\n }\n ]\n }\n ]\n },\n {\n \"id\": \"fiba-2026-game-33\",\n \"date\": \"2026-09-12T18:00Z\",\n \"name\": \"ESP VS USA\",\n \"competitions\": [\n {\n \"competitors\": [\n {\n \"homeAway\": \"home\",\n \"team\": {\n \"abbreviation\": \"USA\"\n }\n },\n {\n \"homeAway\": \"away\",\n \"team\": {\n \"abbreviation\": \"ESP\"\n }\n }\n ],\n \"status\": {\n \"clock\": 0,\n \"displayClock\": \"0:00\",\n \"period\": 0,\n \"type\": {\n \"id\": \"1\",\n \"name\": \"STATUS_SCHEDULED\",\n \"state\": \"pre\",\n \"completed\": false,\n \"description\": \"Scheduled\",\n \"detail\": \"Sat, September 12th at 2:00 PM EDT\",\n \"shortDetail\": \"9/12 - 2:00 PM EDT\"\n }\n },\n \"broadcasts\": [\n {\n \"market\": \"national\",\n \"names\": [\n \"TBS\",\n \"truTV\"\n ]\n }\n ],\n \"notes\": [\n {\n \"type\": \"event\",\n \"headline\": \"FIBA Women’s World Cup – Semifinals\"\n }\n ]\n }\n ]\n }\n ]\n }\n }\n ]\n}",[],[184,262],"60419bf7-42b3-47f4-940d-00c7ca37bdcc","deploy-schema.ts","01a0a6a6-dc15-7190-a78e-1b133e7a72ab",["D",1789502348312],"// Applies lib/schema.sql. Run this once at deployment, and again after any\n// schema change — request paths never provision, so this is the only thing\n// that creates a table here.\n//\n// Re-runnable: every statement is IF NOT EXISTS or INSERT OR IGNORE. Rerunning\n// restores a deleted seed row but never overwrites an operator's relabelling,\n// which makes it a bootstrap/migration tool rather than request-time setup.\n\nimport { readFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst sql = await readFile(\"/lib/schema.sql\", import.meta.url);\n\n// sqlite.execute takes one statement at a time, so the file is split on `;`.\n// Comments are stripped FIRST, and that is not cosmetic: a prose semicolon\n// inside a `--` comment would otherwise split a CREATE TABLE in half, which is\n// exactly how this failed the first time. Safe here because lib/schema.sql has\n// no `--` inside a string literal.\nconst statements = sql\n .replace(/--[^\\n]*/g, \"\")\n .split(\";\")\n .map((statement) => statement.trim())\n .filter(Boolean);\n\nfor (const statement of statements) await sqlite.execute(statement);\n\nconst counts = await sqlite.execute(\n \"SELECT (SELECT count(*) FROM wfiba_teams) AS teams, (SELECT count(*) FROM wfiba_games) AS games\",\n);\nconsole.log(JSON.stringify({ ok: true, statements: statements.length, ...counts.rows[0] }));\n",[],[184,269],["D",1789502348312],[214,215,216,217,218],[184],"c5706e12-b1b7-487a-8f2b-cc6938e126db","store.ts","01a0a6a6-dc15-7190-a78e-12ae71f4e1e3",["D",1789502348312],"// The only module that talks to SQLite. Schema lives in lib/schema.sql and is\n// applied at deployment by tools/deploy-schema.ts — nothing here creates a\n// table, so a read is exactly the query it looks like.\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport type Team = { slug: string; displayName: string; espnCode: string };\n\n// One game, already flat. There is no JSON to parse on the read path: the\n// ingest did that once, at write time.\nexport type Game = {\n gameId: string;\n startTimeMs: number;\n awayCode: string | null;\n homeCode: string | null;\n status: string | null;\n channel: string | null;\n};\n\nexport async function readTeams(): Promise {\n const result = await sqlite.execute(\n \"SELECT slug, display_name, espn_code FROM wfiba_teams ORDER BY display_order, slug\",\n );\n return (result.rows as { slug: string; display_name: string; espn_code: string }[])\n .map((row) => ({ slug: row.slug, displayName: row.display_name, espnCode: row.espn_code }));\n}\n\n// The point of the row-per-game redesign: the team filter is a WHERE clause.\n//\n// `codes` is expanded into placeholders rather than interpolated — these are\n// roster-resolved values, but building SQL by concatenation is how the one\n// case that isn't gets through later.\n//\n// The same `placeholders` string is deliberately reused for both the away and\n// home `IN` clauses, and `args` passes `codes` twice to match. Changing one\n// clause without the other fails at the argument boundary rather than\n// obviously, so keep them in step.\n//\n// Returns every candidate, not one per team: which game answers for which\n// favorite is a selection rule (lib/feed.ts), and doing it here would need\n// one query per team to express the same thing.\nexport async function gamesForCodes(codes: string[], fromMs: number): Promise {\n if (!codes.length) return [];\n const placeholders = codes.map(() => \"?\").join(\",\");\n const result = await sqlite.execute({\n sql: `SELECT game_id, start_time_ms, away_code, home_code, status, channel\n FROM wfiba_games\n WHERE start_time_ms >= ?\n AND (away_code IN (${placeholders}) OR home_code IN (${placeholders}))\n ORDER BY start_time_ms, game_id`,\n args: [fromMs, ...codes, ...codes],\n });\n return (result.rows as Record[]).map((row) => ({\n gameId: String(row.game_id),\n startTimeMs: Number(row.start_time_ms),\n awayCode: row.away_code === null ? null : String(row.away_code),\n homeCode: row.home_code === null ? null : String(row.home_code),\n status: row.status === null ? null : String(row.status),\n channel: row.channel === null ? null : String(row.channel),\n }));\n}\n\n// Replace-by-date, not upsert-by-game: one ESPN scoreboard request is the\n// authoritative answer for one date, so a game that has disappeared from it\n// (rescheduled to another day, or a knockout placeholder that got resolved)\n// must disappear here too. An upsert alone would leave that row behind\n// forever, and it would keep showing on someone's widget.\n//\n// Both statements go in one batch so a date is never briefly empty.\nexport async function replaceDate(dateKey: string, games: Game[]): Promise {\n const now = new Date().toISOString();\n await sqlite.batch([\n { sql: \"DELETE FROM wfiba_games WHERE date_key = ?\", args: [dateKey] },\n ...games.map((game) => ({\n sql: `INSERT INTO wfiba_games\n (game_id, date_key, start_time_ms, away_code, home_code, status, channel, ingested_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [game.gameId, dateKey, game.startTimeMs, game.awayCode, game.homeCode, game.status, game.channel, now],\n })),\n ], \"write\");\n return games.length;\n}\n\n// Operational visibility for /coverage: what this source actually holds.\n// `null` bounds mean an empty table, which is a real and reportable state —\n// it is what an un-ingested deployment looks like.\nexport async function coverage(): Promise<{\n games: number;\n dates: number;\n firstDate: string | null;\n lastDate: string | null;\n lastIngestedAt: string | null;\n}> {\n const result = await sqlite.execute(\n `SELECT count(*) AS games, count(DISTINCT date_key) AS dates,\n min(date_key) AS first_date, max(date_key) AS last_date,\n max(ingested_at) AS last_ingested_at\n FROM wfiba_games`,\n );\n const row = result.rows[0] as Record;\n return {\n games: Number(row.games),\n dates: Number(row.dates),\n firstDate: (row.first_date as string | null) ?? null,\n lastDate: (row.last_date as string | null) ?? null,\n lastIngestedAt: (row.last_ingested_at as string | null) ?? null,\n };\n}\n",[],[190,279],"b412c88c-20af-4128-a679-0e80f3a7074d","schema.sql","01a0a6a6-dc15-7190-a78e-0cf965940ed8",["D",1789502348312],"-- Complete schema for source-wfiba. Applied by tools/deploy-schema.ts, never\n-- by a request: a read is one indexed SELECT, not a CREATE TABLE followed by\n-- one. Re-runnable — every statement is IF NOT EXISTS and the roster seed\n-- preserves operator edits to display_name.\n\n-- One row per game. This replaces the date-keyed JSON blob the sports val\n-- stores in source_cache: there, \"which games involve Spain\" meant loading and\n-- parsing every day's whole ESPN scoreboard, so the team filter could only run\n-- in TypeScript after the fact. Here it is a WHERE clause.\nCREATE TABLE IF NOT EXISTS wfiba_games (\n -- ESPN's event id. It is also the Item.id the widget sees, so it must be\n -- stable across re-ingests of the same game — it is.\n game_id TEXT PRIMARY KEY NOT NULL,\n -- ESPN's own UTC calendar bucket for the game, kept as the ingest unit: one\n -- scoreboard request covers one date_key, and re-ingesting a date replaces\n -- exactly that date's rows. Not used for feed selection, which is an\n -- absolute-instant comparison against start_time_ms.\n date_key TEXT NOT NULL CHECK (date_key GLOB '[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]'),\n start_time_ms INTEGER NOT NULL CHECK (typeof(start_time_ms) = 'integer'),\n -- ESPN team abbreviations (\"ESP\", \"USA\"). Nullable because a knockout\n -- fixture appears on the schedule before its participants are decided;\n -- that game is real and belongs on the slate, it just matches no filter yet.\n away_code TEXT,\n home_code TEXT,\n -- ESPN's status.type.state: exactly \"pre\" | \"in\" | \"post\".\n status TEXT,\n -- Best-effort broadcaster string, verbatim from ESPN. Often absent.\n channel TEXT,\n ingested_at TEXT NOT NULL\n);\n\n-- The feed's access path: \"games at or after this instant involving any of\n-- these teams\", which is one index scan per team column.\nCREATE INDEX IF NOT EXISTS wfiba_games_start ON wfiba_games (start_time_ms);\nCREATE INDEX IF NOT EXISTS wfiba_games_away ON wfiba_games (away_code, start_time_ms);\nCREATE INDEX IF NOT EXISTS wfiba_games_home ON wfiba_games (home_code, start_time_ms);\nCREATE INDEX IF NOT EXISTS wfiba_games_date ON wfiba_games (date_key);\n\n-- The selectable roster, and the only reason it is a table rather than a\n-- SELECT DISTINCT over wfiba_games: the settings form's choices must not\n-- depend on ingest state. Deriving them from played games would hide a team\n-- whose fixtures are not ingested yet, and would offer ESPN's \"USA\" where the\n-- product says \"USA\" only because someone chose that label.\n--\n-- One competition, so no competition table and no adapter column: this val is\n-- the 2026 FIBA Women's World Cup and nothing else.\nCREATE TABLE IF NOT EXISTS wfiba_teams (\n -- The stable assignment identifier stored in the parent's device settings.\n -- Deliberately the same slugs the sports val's catalog uses, so an existing\n -- selection means the same thing here.\n slug TEXT PRIMARY KEY NOT NULL CHECK (\n length(slug) > 0 AND slug = lower(slug) AND slug NOT GLOB '*[^a-z0-9-]*'\n ),\n display_name TEXT NOT NULL CHECK (length(trim(display_name)) > 0),\n espn_code TEXT NOT NULL UNIQUE CHECK (length(trim(espn_code)) > 0),\n display_order INTEGER NOT NULL CHECK (typeof(display_order) = 'integer' AND display_order >= 0)\n);\n\n-- The 16-nation field, carried over verbatim from the sports val's catalog_teams\n-- (slug, label and ESPN code all preserved). INSERT OR IGNORE, so re-running\n-- this file restores a deleted row but never overwrites a relabelled one.\nINSERT OR IGNORE INTO wfiba_teams (slug, display_name, espn_code, display_order) VALUES\n ('australia', 'Australia', 'AUS', 0),\n ('belgium', 'Belgium', 'BEL', 1),\n ('china', 'China', 'CHN', 2),\n ('czechia', 'Czechia', 'CZE', 3),\n ('spain', 'Spain', 'ESP', 4),\n ('france', 'France', 'FRA', 5),\n ('germany', 'Germany', 'GER', 6),\n ('hungary', 'Hungary', 'HUN', 7),\n ('italy', 'Italy', 'ITA', 8),\n ('japan', 'Japan', 'JPN', 9),\n ('south-korea', 'South Korea', 'KOR', 10),\n ('mali', 'Mali', 'MLI', 11),\n ('nigeria', 'Nigeria', 'NGR', 12),\n ('puerto-rico', 'Puerto Rico', 'PUR', 13),\n ('turkey', 'Turkey', 'TUR', 14),\n ('united-states', 'USA', 'USA', 15);\n",[],[190,286],"8a0b6ebc-d28c-4b57-9709-53365baf0911",["D",1789502462212],[],[190,33],"0e6e96c6-2476-4911-a740-c5593d1a11a9","feed.ts","01a0a6a6-dc15-7190-a78e-057a6087fbe1",3,["D",1789502458030],"// The pipeline: selected team slugs and a client offset in, temporal widget\n// items out. The one place storage, date math and rendering meet.\n\nimport { clientOffsetSeconds, dayStartMsAtOffset } from \"./dates.ts\";\nimport { buildItems } from \"./items.ts\";\nimport { gamesForCodes, type Game, type Team } from \"./store.ts\";\nimport type { Item } from \"https://esm.town/v/plusjade/source-sdk@12-main/mod.ts\";\n\n// Each favorite's own next game, unioned and deduped.\n//\n// Resolving each team independently is the load-bearing part. One shared\n// \"earliest\" across the set silently drops every OTHER favorite whose next\n// game lands later: with Spain playing tonight and USA not until Sunday,\n// selecting both must return both, not just Spain. Two favorites meeting each\n// other produce one game, not two rows of it.\n//\n// `candidates` is expected to be pre-filtered to games at or after the\n// caller's lower bound and sorted by start time — gamesForCodes does both.\n// This function picks the earliest of what it is handed and has no notion of\n// \"now\".\nexport function nextPerTeam(candidates: Game[], codes: string[]): Game[] {\n const picked = new Map();\n for (const code of codes) {\n const next = candidates.find((game) => game.awayCode === code || game.homeCode === code);\n if (next) picked.set(next.gameId, next);\n }\n return [...picked.values()];\n}\n\n// `utcOffsetSeconds: null` means the parent had no client offset to pass on,\n// not \"UTC\" — clientOffsetSeconds falls back to this source's own default zone\n// rather than silently shifting the day boundary to Greenwich.\n//\n// An empty or fully-unresolved selection produces an empty feed rather than\n// widening to the whole tournament. An empty card is the honest answer to\n// \"show me nothing in particular\", and a whole-league slate is exactly the\n// laundry list the team filter exists to avoid.\nexport async function feedItems(\n settings: { teams: string[] },\n utcOffsetSeconds: number | null,\n teams: Team[],\n): Promise {\n // Deduped, and in the roster's display order rather than the order the\n // caller happened to save them in, so the feed is a function of the\n // selection set and not of its spelling.\n const selected = new Set(settings.teams);\n const codes = teams.filter((team) => selected.has(team.slug)).map((team) => team.espnCode);\n if (!codes.length) return [];\n\n const fromMs = dayStartMsAtOffset(clientOffsetSeconds(utcOffsetSeconds));\n const candidates = await gamesForCodes(codes, fromMs);\n return buildItems(nextPerTeam(candidates, codes), teams);\n}\n",[],[190,297],"9c62c2cd-f8d3-4aae-98f8-717c20b7c033","espn.ts","01a0a6a6-dc15-7190-a78e-0301b876a148",["D",1789502348312],"// ESPN's scoreboard payload -> this val's rows. Pure: the fetch that produces\n// the input does NOT happen here, and cannot — ESPN answers Val Town's shared\n// egress with 403 Access Denied regardless of headers (re-verified 2026-09-07).\n// An external process on an unblocked network fetches the scoreboard and POSTs\n// it to /v1/write; this module is what turns it into games.\n//\n// The relevant upstream is\n// site.api.espn.com/apis/site/v2/sports/basketball/fiba/scoreboard?dates=YYYYMMDD\n// which for the 2026 cycle is league 53, \"FIBA World Cup\" — the Women's World\n// Cup, 2026-09-04 to 2026-09-14. That bucket is reused across cycles and can\n// change tournament and gender between them, so revalidate it before trusting\n// this val with a later event rather than assuming the slug still means this.\n//\n// Every field is a progressive enhancement: a missing team code or broadcast\n// yields null and renders as the same \"TBD\"/blank a partial game already\n// shows, rather than failing the whole ingest.\n\nimport type { Game } from \"./store.ts\";\n\ntype EspnTeam = { abbreviation?: string };\ntype EspnCompetitor = { homeAway?: string; team?: EspnTeam };\ntype EspnBroadcast = { names?: string[] };\ntype EspnCompetition = {\n competitors?: EspnCompetitor[];\n status?: { type?: { state?: string } };\n broadcasts?: EspnBroadcast[];\n};\ntype EspnEvent = { id?: string; date?: string; competitions?: EspnCompetition[] };\n\nexport type EspnScoreboard = { events?: EspnEvent[] };\n\nexport function scoreboard(value: unknown): value is EspnScoreboard {\n if (typeof value !== \"object\" || value === null || Array.isArray(value)) return false;\n const events = (value as EspnScoreboard).events;\n // An absent `events` is how ESPN reports a date with no games — a valid\n // payload meaning \"this date is empty\", not a malformed one. An `events`\n // that is present but not an array is malformed.\n return events === undefined || Array.isArray(events);\n}\n\n// A game with no id can't have a stable Item.id, which is the one field the\n// item contract cannot fake — so it is dropped rather than given a synthetic\n// one that changes between polls. Real captures always carry it.\nfunction toGame(event: EspnEvent): Game | null {\n if (typeof event.id !== \"string\" || !event.id) return null;\n const startTimeMs = event.date ? Date.parse(event.date) : NaN;\n if (!Number.isFinite(startTimeMs)) return null;\n\n const competition = event.competitions?.[0];\n const competitors = competition?.competitors ?? [];\n const side = (which: string) =>\n competitors.find((competitor) => competitor.homeAway === which)?.team?.abbreviation ?? null;\n\n return {\n gameId: event.id,\n startTimeMs,\n awayCode: side(\"away\"),\n homeCode: side(\"home\"),\n // ESPN's status.type.state is already the 3-value vocabulary\n // (\"pre\"/\"in\"/\"post\") that lib/items.ts maps directly, unlike its noisier\n // status.type.name (\"STATUS_SCHEDULED\").\n status: competition?.status?.type?.state ?? null,\n channel: competition?.broadcasts?.[0]?.names?.[0] ?? null,\n };\n}\n\n// Only games whose own UTC date matches the requested key. ESPN's scoreboard\n// for a date occasionally carries an adjacent day's game; without this, two\n// date ingests would each claim it and the second replaceDate would delete\n// what the first wrote.\nexport function gamesFromScoreboard(payload: EspnScoreboard, dateKey: string): Game[] {\n return (payload.events ?? [])\n .map(toGame)\n .filter((game): game is Game =>\n game !== null && new Date(game.startTimeMs).toISOString().slice(0, 10) === dateKey\n );\n}\n",[],[190,305],"898a3beb-8c3d-4ae0-bbad-061cf81cdfe1","dates.ts","01a0a6a6-dc15-7190-a78d-ff29d61e97a2",["D",1789502348312],"// Pure date math for the feed. No I/O, and `now` is always explicit, which is\n// what lets a check pin behaviour without freezing the clock.\n//\n// Only the client-facing half of the sports val's dates.ts survives here.\n// Its Sleeper half (todaySlateDate/addDays, keyed on an IANA zone because\n// Sleeper buckets by Eastern day) went with the Sleeper adapter: this source\n// has one upstream and it speaks UTC.\n\n// The client's timezone when the parent has no offset to pass on. Resolved to\n// a live, DST-correct offset rather than stored as a constant number of\n// seconds, so it does not go stale twice a year.\nconst DEFAULT_CLIENT_TIME_ZONE = \"America/Los_Angeles\";\n\n// The calendar date `now` falls on at a fixed UTC offset. No DST table lookup,\n// because the offset has already had DST folded into it — by the iOS client,\n// or by offsetSecondsForZone's live Intl lookup for the fallback case.\nexport function dateAtOffset(offsetSeconds: number, now = new Date()): string {\n return new Date(now.getTime() + offsetSeconds * 1000).toISOString().slice(0, 10);\n}\n\n// The lower bound on candidate games, as an absolute instant: the start of the\n// client's current calendar day.\n//\n// The day's START, not `now`, and that is deliberate — it is what keeps a\n// finished game on the card for the rest of the day. `intradayFilter` is the\n// opt-out.\nexport function dayStartMsAtOffset(offsetSeconds: number, now = new Date()): number {\n return Date.parse(`${dateAtOffset(offsetSeconds, now)}T00:00:00.000Z`) - offsetSeconds * 1000;\n}\n\n// The live GMT offset for an IANA zone at `now`, via Intl's own tables, so the\n// fallback path stays DST-correct without a DST table here. \"longOffset\" is\n// the Intl mode that always renders \"GMT±HH:MM\" rather than a zone\n// abbreviation, which is what makes it parseable.\nfunction offsetSecondsForZone(timeZone: string, now: Date): number {\n const part = new Intl.DateTimeFormat(\"en-US\", { timeZone, timeZoneName: \"longOffset\" })\n .formatToParts(now)\n .find((p) => p.type === \"timeZoneName\")?.value;\n const match = part && /^GMT([+-])(\\d{1,2}):(\\d{2})$/.exec(part);\n if (!match) return 0;\n return (match[1] === \"-\" ? -1 : 1) * (Number(match[2]) * 3600 + Number(match[3]) * 60);\n}\n\n// The protocol's `context.utcOffsetSeconds`, resolved to a usable offset. iOS\n// sends TimeZone.current.secondsFromGMT(), seconds east of GMT with DST\n// already folded in, so there is nothing to look up here — just range-check it.\n//\n// `null` means the parent had no client offset to forward, NOT \"UTC\": it falls\n// back to DEFAULT_CLIENT_TIME_ZONE's live offset. An out-of-range value takes\n// the same fallback rather than throwing — a failed source fails the whole\n// composition, which is worse than a slightly-off day boundary. The range\n// [-12:00, +14:00] is every real-world UTC offset (Baker Island to Kiribati);\n// the protocol's own guard is wider, so this is the narrower of the two checks\n// and the one that decides.\nexport function clientOffsetSeconds(raw: number | null, now = new Date()): number {\n return raw !== null && Number.isInteger(raw) && raw >= -43200 && raw <= 50400\n ? raw\n : offsetSecondsForZone(DEFAULT_CLIENT_TIME_ZONE, now);\n}\n",[],[190,312],"439d4fb7-c3eb-46b9-9f3e-26e865960fd5","channels.ts","01a0a6a6-dc15-7190-a78d-faeee5da92b7",["D",1789502348312],"// Turns Sleeper's raw channel string into the shape the item builder reads.\n// Pure; broadcaster display rules are independent of the team catalog.\n\n// Existing broadcaster presentation rules; these are outside the selection catalog.\n// A blunt chop rather than a width measurement: this is a fallback label for a\n// regional broadcaster nobody has mapped, not a layout decision.\nconst MAX_CHANNEL_LABEL = 10;\nfunction chop(text: string, max: number): string {\n return text.length <= max ? text : `${text.slice(0, max - 1)}…`;\n}\nconst NATIONAL_CHANNELS: Record = {\n \"abc\": {\n \"label\": \"ABC\",\n \"directv_channel\": 4,\n \"note\": null\n },\n \"cbs\": {\n \"label\": \"CBS\",\n \"directv_channel\": 2,\n \"note\": null\n },\n \"espn\": {\n \"label\": \"ESPN\",\n \"directv_channel\": 206,\n \"note\": null\n },\n \"ion\": {\n \"label\": \"ION\",\n \"directv_channel\": 305,\n \"note\": null\n },\n \"nbatv\": {\n \"label\": \"NBATV\",\n \"directv_channel\": 216,\n \"note\": null\n },\n \"nbc\": {\n \"label\": \"NBC\",\n \"directv_channel\": 4,\n \"note\": null\n },\n \"tbs\": {\n \"label\": \"TBS\",\n \"directv_channel\": 247,\n \"note\": null\n },\n \"usa\": {\n \"label\": \"USA\",\n \"directv_channel\": 242,\n \"note\": null\n },\n \"sportsnet\": {\n \"label\": \"SportsNet\",\n \"directv_channel\": 691,\n \"note\": null\n }\n};\nconst STREAMING_CHANNELS: Record = {\n \"amzn\": {\n \"label\": \"AMZN\",\n \"note\": \"computer only\"\n },\n \"amazon\": {\n \"label\": \"AMZN\",\n \"note\": \"computer only\"\n },\n \"peacock\": {\n \"label\": \"Peacock\",\n \"note\": \"computer only\"\n },\n \"hbo max\": {\n \"label\": \"HBO Max\",\n \"note\": \"computer only\"\n }\n};\n\n\n// `name` stays the raw string Sleeper sent — it is the drift-detection\n// value, and the json format has to keep reporting what actually arrived.\n// `label` is the display form: dictionary-mapped where there is a mapping,\n// chopped raw text where there isn't.\nexport type ChannelInfo = {\n category: string;\n name: string | null;\n label: string | null;\n directv_channel: number | null;\n note: string | null;\n};\n\nfunction channelMatches(rawChannel: string, key: string) {\n return new RegExp(`\\\\b${key.replace(/[.*+?^${}()|[\\]\\\\]/g, \"\\\\$&\")}\\\\b`, \"i\").test(rawChannel);\n}\n\nexport function channelInfo(rawChannel: string | null | undefined): ChannelInfo {\n if (!rawChannel) return { category: \"unknown\", name: null, label: null, directv_channel: null, note: null };\n\n const nationalKey = Object.keys(NATIONAL_CHANNELS).find((key) => channelMatches(rawChannel, key));\n if (nationalKey) return { category: \"national\", name: rawChannel, ...NATIONAL_CHANNELS[nationalKey] };\n\n const streamingKey = Object.keys(STREAMING_CHANNELS).find((key) => channelMatches(rawChannel, key));\n if (streamingKey) {\n return { category: \"streaming\", name: rawChannel, directv_channel: null, ...STREAMING_CHANNELS[streamingKey] };\n }\n\n return {\n category: \"regional\",\n name: rawChannel,\n label: chop(rawChannel, MAX_CHANNEL_LABEL),\n directv_channel: null,\n note: null,\n };\n}\n",[],[190,319],["D",1789502348312],[206,207,208,209,210,211,212],[190],["D",1788811087002],["D",1789509043237],{"_103":102,"_110":106},{"_103":102,"_104":-5,"_105":106,"_18":56,"_107":108,"_109":25},{"_13":90,"_32":91,"_44":43,"_92":45,"_93":94,"_95":96,"_97":51,"_98":45,"_99":66,"_100":46,"_101":102},"ctx",{"_83":-5,"_131":366,"_367":368,"_369":370,"_371":25,"_372":25,"_373":25,"_374":60,"_375":-5,"_376":-7,"_377":-7,"_378":64,"_379":25,"_380":25,"_381":-5,"_382":25,"_383":25,"_384":25,"_385":-5},"ENV",{"_337":338,"_339":340,"_341":137,"_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"]

Diff · v4