[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_313":314,"_315":316},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_17":18,"_38":-7,"_130":-5,"_19":131,"_132":133,"_134":135,"_136":137,"_138":139,"_21":140,"_141":-5,"_142":143,"_144":24,"_145":146,"_147":89,"_148":-5,"_149":-5,"_150":151},"routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":22,"_23":24,"_25":26,"_27":28,"_29":24,"_30":-5},"handle","plusjade","name","source-wfiba","branchName","shared-sdk","path","lib/schema.sql","project",{"_32":77,"_13":14,"_36":78,"_67":-5,"_79":24,"_80":81,"_82":81,"_83":84,"_85":-5,"_30":73,"_86":87,"_88":89,"_90":-5,"_91":-5,"_92":26,"_40":41,"_93":94,"_95":96,"_97":98,"_99":-5,"_100":101,"_102":101,"_103":104,"_105":104,"_106":104,"_107":101,"_108":101,"_53":109,"_110":111,"_112":113,"_114":24},"file",{"_68":69,"_13":70,"_71":21,"_72":24,"_76":-5},"isDirectory",false,"page",0,"history",[31],"hasNext","userId",{"_32":33,"_34":35,"_36":37,"_38":39,"_40":41,"_42":-5,"_43":44,"_45":-5,"_46":-5,"_47":-5,"_48":-5,"_49":50,"_51":52,"_53":54,"_21":55,"_56":-5,"_57":58,"_59":-5,"_60":-5,"_61":62},"id","29db15ed-b496-4721-9973-a609d755acaa","branchId","86f4ffec-06a8-4362-9772-3ff5d887e51b","createdAt",["D",1788851621680],"version",1,"orgId","5a10edca-919b-4a78-babb-71908f69af93","parentId","incomingCommitId","9eb758d0-f750-4804-914e-298544efef53","aiChatMessageId","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle","source","mcp","clientLabel","ChatGPT","user",{"_32":73,"_40":41,"_11":12,"_74":75},{"_68":69,"_13":70,"_71":21,"_72":24},"pull","merge",{"_34":64,"_13":65,"_38":66,"_67":-5},"revert","multiple","commits",[63],{"_32":33,"_34":35,"_36":37,"_38":39,"_40":41,"_42":-5,"_43":44,"_45":-5,"_46":-5,"_47":-5,"_48":-5,"_49":50,"_51":52,"_53":54,"_21":55,"_56":-5,"_57":58,"_59":-5},"20967dcf-9eb1-4cbf-a721-cf05b71b776a","main",53,"deletedAt","fileId","01a07fdd-8f2d-7249-a0e8-149b349464f0","schema.sql","fileType","deleted","b0a8da26-58e7-4d19-8b5c-eedf487df9a9","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yVHpab25kTlBTM3M3WmpCa3NMSTd5akVwWksuanBlZyJ9","deletedAtVersion","8cd67c66-1c13-4d59-a550-efcd693c834b",["D",1788811087002],"legacyEnvVars","privacy","public","httpPrivacy","description","Women's FIBA World Cup source val","imageUrl","pinnedFileId","01a07d73-0d02-703f-be73-09449008031e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount","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",{"_11":12,"_129":75},"org",{"_11":12,"_125":-5,"_74":75,"_30":73,"_126":127,"_128":24},"branch",{"_38":115,"_13":16,"_32":35,"_116":77,"_117":64,"_118":119,"_120":81,"_121":77,"_122":41,"_123":14,"_124":12},"isOwned",21,"projectId","forkedBranchId","forkedBranchVersion",38,"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_32":77,"_13":14,"_36":308,"_67":-5,"_79":24,"_80":81,"_82":81,"_83":84,"_85":-5,"_30":73,"_86":87,"_88":89,"_90":-5,"_91":-5,"_92":26,"_40":41,"_93":94,"_95":96,"_97":309,"_99":-5,"_100":101,"_102":101,"_103":104,"_105":104,"_106":104,"_107":101,"_108":101,"_53":310,"_110":311,"_112":312,"_114":24},"tree",[178,186,187,191,192,193],"files",[178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193],"counts",{"_166":26,"_167":168,"_169":26,"_170":171,"_172":173},"contents",[],{"_32":157,"_34":35,"_68":69,"_13":70,"_158":159,"_71":21,"_38":26,"_42":160,"_36":161,"_162":39,"_163":-5,"_17":164},"upstreamProject","upstreamBranch",{"_32":64,"_36":152,"_153":154,"_13":65,"_116":77,"_38":66,"_117":-5,"_118":-5,"_155":156,"_67":-5,"_114":24,"_80":81,"_124":12,"_40":41,"_123":14},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1788811087002],"updatedAt",["D",1789502869681],"lockfileKey","1789502869788-esm.town_v_plusjade_source-wfiba@53-main","885805d5-573b-4db4-b329-57a491d04b90","content","-- 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","01a07fdd-8f2d-7249-a0e8-1f1c7036ac64",["D",1788851621680],"branchVersion","label",[165,70],"lib","pulls","branches",5,"forks","envVars",{"_174":176,"_177":26},"connections",{"_174":26,"_175":26},"count","unfilledCount",4,"emptyCount",{"_32":304,"_13":165,"_68":160,"_42":-5,"_34":35,"_162":39,"_198":89,"_36":305,"_38":26,"_71":250,"_158":-5,"_72":24,"_163":-5,"_203":306,"_17":307},{"_32":297,"_13":298,"_68":299,"_42":160,"_34":35,"_162":39,"_198":89,"_36":300,"_38":26,"_71":201,"_158":301,"_72":24,"_163":-5,"_203":302,"_17":303},{"_32":290,"_13":291,"_68":292,"_42":160,"_34":35,"_162":39,"_198":89,"_36":293,"_38":26,"_71":201,"_158":294,"_72":24,"_163":-5,"_203":295,"_17":296},{"_32":283,"_13":284,"_68":285,"_42":160,"_34":35,"_162":39,"_198":89,"_36":286,"_38":26,"_71":201,"_158":287,"_72":24,"_163":-5,"_203":288,"_17":289},{"_32":276,"_13":277,"_68":278,"_42":160,"_34":35,"_162":168,"_198":89,"_36":279,"_38":39,"_71":201,"_158":280,"_72":24,"_163":-5,"_203":281,"_17":282},{"_32":269,"_13":270,"_68":271,"_42":160,"_34":35,"_162":176,"_198":89,"_36":272,"_38":39,"_71":201,"_158":273,"_72":24,"_163":-5,"_203":274,"_17":275},{"_32":157,"_13":70,"_68":69,"_42":160,"_34":35,"_162":39,"_198":89,"_36":266,"_38":26,"_71":21,"_158":159,"_72":24,"_163":-5,"_203":267,"_17":268},{"_32":259,"_13":260,"_68":261,"_42":160,"_34":35,"_162":39,"_198":89,"_36":262,"_38":26,"_71":201,"_158":263,"_72":24,"_163":-5,"_203":264,"_17":265},{"_32":253,"_13":254,"_68":255,"_42":-5,"_34":35,"_162":39,"_198":89,"_36":256,"_38":26,"_71":250,"_158":-5,"_72":24,"_163":-5,"_203":257,"_17":258},{"_32":248,"_13":233,"_68":227,"_42":-5,"_34":35,"_162":39,"_198":89,"_36":249,"_38":26,"_71":250,"_158":-5,"_72":24,"_163":-5,"_203":251,"_17":252},{"_32":241,"_13":242,"_68":243,"_42":227,"_34":35,"_162":39,"_198":89,"_36":244,"_38":26,"_71":201,"_158":245,"_72":24,"_163":-5,"_203":246,"_17":247},{"_32":234,"_13":235,"_68":236,"_42":227,"_34":35,"_162":39,"_198":89,"_36":237,"_38":26,"_71":201,"_158":238,"_72":24,"_163":-5,"_203":239,"_17":240},{"_32":224,"_13":225,"_68":226,"_42":227,"_34":35,"_162":228,"_198":89,"_36":229,"_38":39,"_71":201,"_158":230,"_72":24,"_163":-5,"_203":231,"_17":232},{"_32":215,"_13":216,"_68":217,"_42":-5,"_34":35,"_162":218,"_198":89,"_36":219,"_38":220,"_71":21,"_158":221,"_72":24,"_163":-5,"_203":222,"_17":223},{"_32":206,"_13":207,"_68":208,"_42":-5,"_34":35,"_162":209,"_198":89,"_36":210,"_38":200,"_71":211,"_158":212,"_72":24,"_163":-5,"_203":213,"_17":214},{"_32":194,"_13":195,"_68":196,"_42":-5,"_34":35,"_162":197,"_198":89,"_36":199,"_38":200,"_71":201,"_158":202,"_72":24,"_163":-5,"_203":204,"_17":205},"1d9f3c06-3b92-4dd9-a890-43269e90ffe1","wfibaSource.ts","01a07fdd-8f2d-7249-a0e8-56dcb845a645",17,"latest",["D",1788851840059],2,"script","// 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@3-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 intradayFilter: boolean;\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 intradayFilter: {\n type: \"boolean\",\n title: \"Hide a game as soon as it ends\",\n default: false,\n description: \"When unchecked, keep showing ended games for the rest of the day.\",\n },\n },\n required: [\"teams\"],\n additionalProperties: false,\n };\n}\n\nconst SETTING_KEYS = [\"teams\", \"intradayFilter\"];\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 || (raw.intradayFilter !== undefined && typeof raw.intradayFilter !== \"boolean\")\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, intradayFilter: raw.intradayFilter === true, roster });\n },\n\n read: ({ teams, intradayFilter, roster }, { utcOffsetSeconds }) =>\n feedItems({ teams, intradayFilter }, 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","children",[],[195],"b44a3d3d-d4a7-447c-bcdd-3acdb6abea2a","rpc.ts","01a07fdd-8f2d-7249-a0e8-529e6b51393b",16,["D",1788851836086],"http","// Authenticated HTTP mount for the shared SDK and Women's FIBA definition.\n// /health and /coverage are this deployment's operational routes.\nimport { serveSource } from \"https://esm.town/v/plusjade/source-sdk@3-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 (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",[],[207],"f4f52ce7-cb3b-42fa-962e-d20aae685512","README.md","01a07fdd-8f2d-7249-a0e8-4c7daf82d235",15,["D",1788851831729],3,"# 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@3-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 six-field item shape. 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-07. So `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**The tournament is not fully ingested.** ESPN publishes the knockout bracket\nlate: as of 2026-09-07 only the four group-stage dates exist (24 games), and\n09-08 onward return zero events. Re-run the ingest as the bracket fills.\n`GET /coverage` reports what is actually held.\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@3-main/mod.ts`; keep them on one snapshot and rerun this check on a branch when upgrading.\n\n- `tools/source-contract-check.ts` — 39 assertions over the whole HTTP surface,\n plus pinned pure-function behaviour (Unix seconds, per-team selection, the\n ingest date filter) and a disposable row on `1900-01-01`.\nShared protocol conformance and boundary checks now live in `plusjade/source-sdk/tools/sdk-check.ts`.\n",[],[216],"43f3009e-4668-4073-a117-9ad11020a094","source-contract-check.ts","01a07fdd-8f2d-7249-a0e8-458f329a8ab1","01a07fdd-8f2d-7249-a0e8-4805b7149807",6,["D",1788851650656],"// 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 } from \"https://esm.town/v/plusjade/source-sdk@3-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].timestamp === 1788806700, \"timestamp is Unix seconds\");\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// 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",[],[233,225],"tools","6ac380cf-e770-4b23-9505-371161043600","ingest.ts","01a07fdd-8f2d-7249-a0e8-3c91d83d6140",["D",1788851621680],"// 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",[],[233,235],"b10864c6-b7b4-4589-924c-3fce97fdfc0d","deploy-schema.ts","01a07fdd-8f2d-7249-a0e8-38a3f7551e75",["D",1788851621680],"// 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",[],[233,242],"6dfec5f9-c7f9-4158-9fb2-5c2fd0db8507",["D",1788851621680],"directory",[188,189,190],[233],"b4ef8196-9d42-46d6-90a8-020d00b0a0ac","sdk","01a07fdd-8f2d-7249-a0e8-36551b7171f5",["D",1788851621680],[],[254],"06b66d4c-895e-48f0-b3af-8b834f96f772","store.ts","01a07fdd-8f2d-7249-a0e8-18cbadbbb5f7",["D",1788851621680],"// 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",[],[165,260],["D",1788851621680],[],[165,70],"2b6ae6d5-6d43-44c9-a1d0-1f08da982066","items.ts","01a07fdd-8f2d-7249-a0e8-117f802f9fa9",["D",1788851643151],"// 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`,\n// Unix-second `timestamp`) are mirrored by the Codable types at\n// Shared/WidgetPayload.swift in the iOS repo. Only add fields, never remove or\n// 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\nimport { channelInfo, type ChannelInfo } from \"./channels.ts\";\nimport type { Game, Team } from \"./store.ts\";\nimport type { Item } from \"https://esm.town/v/plusjade/source-sdk@3-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\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// `caption: null` is a protocol value, not just \"no status\" — it tells the\n// client to format `timestamp` itself as a local start time, which is right\n// for a game that hasn't started. Only live is emphasized; final gets the dim\n// treatment.\nfunction captionFor(status: Status): { caption: string | null; emphasized: boolean } {\n if (status === \"live\") return { caption: \"LIVE\", emphasized: true };\n if (status === \"final\") 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[]): { item: Item; status: Status } {\n const status = (game.status && STATUS_MAP[game.status]) || \"scheduled\";\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(status),\n // Unix epoch SECONDS, UTC. Getting this wrong (sending ms) decodes on\n // the client as a timestamp ~57,000 years out; nothing in a passing\n // TypeScript-side test would catch that, only a pinned integer does.\n timestamp: Math.floor(game.startTimeMs / 1000),\n },\n status,\n };\n}\n\n// `hideCompleted` is the assignment's `intradayFilter` setting. It filters on\n// the status computed above, not on caption text: \"END\" is a display string\n// while `status` is the actual classification.\nexport function buildItems(games: Game[], teams: Team[], hideCompleted = false): Item[] {\n const built = games\n .toSorted((a, b) => a.startTimeMs - b.startTimeMs)\n .map((game) => toItem(game, teams));\n return (hideCompleted ? built.filter((b) => b.status !== \"final\") : built).map((b) => b.item);\n}\n",[],[165,270],"2433cb0b-ff6b-41ef-90da-93520aed8168","feed.ts","01a07fdd-8f2d-7249-a0e8-0c7ee7c2bd0a",["D",1788851646886],"// 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@3-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[]; intradayFilter: boolean },\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, settings.intradayFilter);\n}\n",[],[165,277],"5710d29d-971c-4f72-b0f1-d593689b4d8e","espn.ts","01a07fdd-8f2d-7249-a0e8-0bdef1c1ec54",["D",1788851621680],"// 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",[],[165,284],"60797fa6-d587-4a4e-a955-3ba2a0e01d4b","dates.ts","01a07fdd-8f2d-7249-a0e8-0714b1732cb8",["D",1788851621680],"// 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",[],[165,291],"db5b672e-6e6b-4b1e-b804-36bc225564bc","channels.ts","01a07fdd-8f2d-7249-a0e8-013f72e644e8",["D",1788851621680],"// 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",[],[165,298],"8cf363fd-4c74-455b-85fb-4cdf0e417398",["D",1788851621680],[179,180,181,182,183,184,185],[165],["D",1788811087002],["D",1789509043237],{"_11":12,"_129":75},{"_11":12,"_125":-5,"_74":75,"_30":73,"_126":127,"_128":24},{"_38":115,"_13":16,"_32":35,"_116":77,"_117":64,"_118":119,"_120":81,"_121":77,"_122":41,"_123":14,"_124":12},"ctx",{"_53":-5,"_149":346,"_347":348,"_349":350,"_351":24,"_352":24,"_353":24,"_354":89,"_355":-5,"_356":-7,"_357":-7,"_358":26,"_359":24,"_360":24,"_361":-5,"_362":24,"_363":24,"_364":24,"_365":-5},"ENV",{"_317":318,"_319":320,"_321":65,"_322":323,"_324":325,"_326":327,"_328":329,"_330":331,"_332":333,"_334":335,"_336":337,"_338":339,"_340":341,"_342":343,"_344":345},"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"]

History · schema.sql