[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_394":395,"_396":397},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_17":18,"_41":-7,"_196":-5,"_19":197,"_198":199,"_200":201,"_202":203,"_204":205,"_21":206,"_207":-5,"_208":209,"_210":30,"_211":212,"_213":24,"_214":-5,"_215":-5,"_216":217},"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":30,"_31":-5},"handle","plusjade","name","source-wfiba","branchName","lifecycle-window","path","lib","project",{"_35":144,"_13":14,"_39":145,"_81":-5,"_146":30,"_147":148,"_149":148,"_150":151,"_152":-5,"_31":88,"_153":154,"_155":24,"_156":-5,"_157":-5,"_158":26,"_43":44,"_159":160,"_161":162,"_163":164,"_165":-5,"_166":167,"_168":167,"_169":170,"_171":170,"_172":170,"_173":167,"_174":167,"_56":175,"_176":177,"_178":179,"_180":30},"file",{"_82":141,"_13":18,"_85":142,"_87":30,"_143":-5},"isDirectory",true,"page",0,"history",[32,33,34],"hasNext",false,"userId",{"_35":133,"_37":38,"_39":134,"_41":135,"_43":44,"_45":136,"_46":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":53,"_54":55,"_56":137,"_21":138,"_59":-5,"_60":-5,"_62":-5,"_63":-5,"_65":139},{"_35":126,"_37":38,"_39":127,"_41":128,"_43":44,"_45":36,"_46":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":53,"_54":55,"_56":129,"_21":130,"_59":-5,"_60":-5,"_62":-5,"_63":-5,"_65":131},{"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":-5,"_46":47,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":53,"_54":55,"_56":57,"_21":58,"_59":-5,"_60":61,"_62":-5,"_63":64,"_65":66},"id","a67e8812-c9d1-4c1a-9872-25aa2eceee00","branchId","538d1b1f-d880-4124-86df-8699bfca9f25","createdAt",["D",1789077430457],"version",1,"orgId","5a10edca-919b-4a78-babb-71908f69af93","parentId","incomingCommitId","96cafa2e-d9cc-4676-b530-1840cadaf53b","aiChatMessageId","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle","source","mcp","clientLabel","Claude","user",{"_35":88,"_43":44,"_11":12,"_89":90},{"_82":124,"_13":125,"_85":86,"_87":30},"pull","merge",{"_37":78,"_13":79,"_41":80,"_81":-5},"revert","multiple",{"_121":122,"_123":26},"commits",[67,68,69,70,71,72,73],{"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":-5,"_46":47,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":53,"_54":55,"_56":57,"_21":58,"_59":-5,"_60":61,"_62":-5},{"_35":36,"_37":38,"_39":115,"_41":42,"_43":44,"_45":-5,"_46":47,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":53,"_54":55,"_56":116,"_21":117,"_59":-5,"_60":118,"_62":-5},{"_35":36,"_37":38,"_39":109,"_41":42,"_43":44,"_45":-5,"_46":47,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":53,"_54":55,"_56":110,"_21":111,"_59":-5,"_60":112,"_62":-5},{"_35":36,"_37":38,"_39":103,"_41":42,"_43":44,"_45":-5,"_46":47,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":53,"_54":55,"_56":104,"_21":105,"_59":-5,"_60":106,"_62":-5},{"_35":36,"_37":38,"_39":97,"_41":42,"_43":44,"_45":-5,"_46":47,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":53,"_54":55,"_56":98,"_21":99,"_59":-5,"_60":100,"_62":-5},{"_35":36,"_37":38,"_39":91,"_41":42,"_43":44,"_45":-5,"_46":47,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":53,"_54":55,"_56":92,"_21":93,"_59":-5,"_60":94,"_62":-5},{"_35":36,"_37":38,"_39":74,"_41":42,"_43":44,"_45":-5,"_46":47,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":53,"_54":55,"_56":75,"_21":76,"_59":-5,"_60":77,"_62":-5},["D",1789077430457],{"_35":88,"_43":44,"_11":12,"_89":90},{"_82":83,"_13":84,"_85":86,"_87":30},{"_37":78,"_13":79,"_41":80,"_81":-5},"20967dcf-9eb1-4cbf-a721-cf05b71b776a","main",53,"deletedAt","fileId","01a08d53-20b4-747e-b432-dc083db3a60c","dates.ts","fileType","script","deleted","b0a8da26-58e7-4d19-8b5c-eedf487df9a9","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yVHpab25kTlBTM3M3WmpCa3NMSTd5akVwWksuanBlZyJ9",["D",1789077430457],{"_35":88,"_43":44,"_11":12,"_89":90},{"_82":95,"_13":96,"_85":86,"_87":30},{"_37":78,"_13":79,"_41":80,"_81":-5},"01a08d53-20b4-747e-b432-f2259f1693da","store.ts",["D",1789077430457],{"_35":88,"_43":44,"_11":12,"_89":90},{"_82":101,"_13":102,"_85":86,"_87":30},{"_37":78,"_13":79,"_41":80,"_81":-5},"01a08d53-20b4-747e-b432-d9e012b61d4f","channels.ts",["D",1789077430457],{"_35":88,"_43":44,"_11":12,"_89":90},{"_82":107,"_13":108,"_85":21,"_87":30},{"_37":78,"_13":79,"_41":80,"_81":-5},"01a08d53-20b4-747e-b432-ec1edd276d71","schema.sql",["D",1789077430457],{"_35":88,"_43":44,"_11":12,"_89":90},{"_82":113,"_13":114,"_85":86,"_87":30},{"_37":78,"_13":79,"_41":80,"_81":-5},"01a08d53-20b4-747e-b432-ebac566d2adc","items.ts",["D",1789077430457],{"_35":88,"_43":44,"_11":12,"_89":90},{"_82":119,"_13":120,"_85":86,"_87":30},{"_37":78,"_13":79,"_41":80,"_81":-5},"01a08d53-20b4-747e-b432-e7e03c79cc72","feed.ts","count",7,"deletedCount","01a08d53-20b4-747e-b432-e010b58fa73d","espn.ts","9f039e67-1f24-46e9-9111-9b15fc31b837",["D",1789077457032],2,{"_35":88,"_43":44,"_11":12,"_89":90},{"_82":113,"_13":114,"_85":86,"_87":30},[132],{"_35":126,"_37":38,"_39":127,"_41":128,"_43":44,"_45":36,"_46":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":53,"_54":55,"_56":129,"_21":130,"_59":-5,"_60":-5,"_62":-5},"db908174-9abb-4490-ad1a-259c8c92943b",["D",1789077470077],4,"e548d52c-c190-4712-bac7-e57da717f813",{"_35":88,"_43":44,"_11":12,"_89":90},{"_82":119,"_13":120,"_85":86,"_87":30},[140],{"_35":133,"_37":38,"_39":134,"_41":135,"_43":44,"_45":136,"_46":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":53,"_54":55,"_56":137,"_21":138,"_59":-5,"_60":-5,"_62":-5},"01a08d53-20b4-747e-b432-f7875fe56bc4","directory","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","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,"_195":90},"org",{"_11":12,"_191":-5,"_89":90,"_31":88,"_192":193,"_194":30},"branch",{"_41":181,"_13":16,"_35":38,"_182":144,"_183":78,"_184":185,"_186":148,"_187":144,"_188":44,"_189":14,"_190":12},"isOwned",10,"projectId","forkedBranchId","forkedBranchVersion",45,"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_35":144,"_13":14,"_39":389,"_81":-5,"_146":30,"_147":148,"_149":148,"_150":151,"_152":-5,"_31":88,"_153":154,"_155":24,"_156":-5,"_157":-5,"_158":26,"_43":44,"_159":160,"_161":162,"_163":390,"_165":-5,"_166":167,"_168":167,"_169":170,"_171":170,"_172":170,"_173":167,"_174":167,"_56":391,"_176":392,"_178":393,"_180":30},"tree",[275,283,288,289,290,291,292],"files",[275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292],"counts",{"_265":26,"_266":267,"_268":26,"_269":270,"_271":272},"contents",[230,231,232,233,234,235,236],{"_35":223,"_13":18,"_82":141,"_45":-5,"_37":38,"_224":42,"_225":24,"_39":226,"_41":26,"_85":142,"_227":-5,"_87":30,"_228":-5,"_17":229},"upstreamProject","upstreamBranch",{"_35":78,"_39":218,"_219":220,"_13":79,"_182":144,"_41":80,"_183":-5,"_184":-5,"_221":222,"_81":-5,"_180":30,"_147":148,"_190":12,"_43":44,"_189":14},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1788811087002],"updatedAt",["D",1789502869681],"lockfileKey","1789502869788-esm.town_v_plusjade_source-wfiba@53-main","a00ff9a5-588d-48e5-b7fc-bb7b96a8c5e8","branchVersion","latest",["D",1789077430457],"content","label",[18],{"_35":261,"_13":102,"_82":101,"_45":141,"_37":38,"_224":42,"_225":24,"_39":262,"_41":26,"_85":86,"_227":263,"_87":30,"_228":-5,"_17":264},{"_35":257,"_13":84,"_82":83,"_45":141,"_37":38,"_224":42,"_225":24,"_39":258,"_41":26,"_85":86,"_227":259,"_87":30,"_228":-5,"_17":260},{"_35":253,"_13":125,"_82":124,"_45":141,"_37":38,"_224":42,"_225":24,"_39":254,"_41":26,"_85":86,"_227":255,"_87":30,"_228":-5,"_17":256},{"_35":249,"_13":120,"_82":119,"_45":141,"_37":38,"_224":135,"_225":24,"_39":250,"_41":42,"_85":86,"_227":251,"_87":30,"_228":-5,"_17":252},{"_35":245,"_13":114,"_82":113,"_45":141,"_37":38,"_224":128,"_225":24,"_39":246,"_41":42,"_85":86,"_227":247,"_87":30,"_228":-5,"_17":248},{"_35":241,"_13":108,"_82":107,"_45":141,"_37":38,"_224":42,"_225":24,"_39":242,"_41":26,"_85":21,"_227":243,"_87":30,"_228":-5,"_17":244},{"_35":237,"_13":96,"_82":95,"_45":141,"_37":38,"_224":42,"_225":24,"_39":238,"_41":26,"_85":86,"_227":239,"_87":30,"_228":-5,"_17":240},"a0aff42d-6b31-4712-b483-0ec8709f56fe",["D",1789077430457],"// 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",[18,96],"d018b4f2-a230-47cc-b999-35d649ad4be6",["D",1789077430457],"-- 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",[18,108],"4e646904-a39a-4a08-afc7-0d8ce0a892fc",["D",1789077457032],"// 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",[18,114],"95098562-8cdb-4793-9805-c58373dbe7ad",["D",1789077470077],"// 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[]; 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",[18,120],"b2a11e64-4d15-4a85-9bf0-c5151b2add3c",["D",1789077430457],"// 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",[18,125],"de7f54f0-23bc-470b-bc8e-d65844bdb884",["D",1789077430457],"// 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",[18,84],"f03a613c-8eae-41f7-a7b3-bf3200eaf03e",["D",1789077430457],"// 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",[18,102],"pulls","branches",5,"forks","envVars",{"_121":135,"_274":26},"connections",{"_121":26,"_273":26},"unfilledCount","emptyCount",{"_35":223,"_13":18,"_82":141,"_45":-5,"_37":38,"_224":42,"_225":24,"_39":386,"_41":26,"_85":142,"_227":-5,"_87":30,"_228":-5,"_299":387,"_17":388},{"_35":261,"_13":102,"_82":101,"_45":141,"_37":38,"_224":42,"_225":24,"_39":383,"_41":26,"_85":86,"_227":263,"_87":30,"_228":-5,"_299":384,"_17":385},{"_35":257,"_13":84,"_82":83,"_45":141,"_37":38,"_224":42,"_225":24,"_39":380,"_41":26,"_85":86,"_227":259,"_87":30,"_228":-5,"_299":381,"_17":382},{"_35":253,"_13":125,"_82":124,"_45":141,"_37":38,"_224":42,"_225":24,"_39":377,"_41":26,"_85":86,"_227":255,"_87":30,"_228":-5,"_299":378,"_17":379},{"_35":249,"_13":120,"_82":119,"_45":141,"_37":38,"_224":135,"_225":24,"_39":374,"_41":42,"_85":86,"_227":251,"_87":30,"_228":-5,"_299":375,"_17":376},{"_35":245,"_13":114,"_82":113,"_45":141,"_37":38,"_224":128,"_225":24,"_39":371,"_41":42,"_85":86,"_227":247,"_87":30,"_228":-5,"_299":372,"_17":373},{"_35":241,"_13":108,"_82":107,"_45":141,"_37":38,"_224":42,"_225":24,"_39":368,"_41":26,"_85":21,"_227":243,"_87":30,"_228":-5,"_299":369,"_17":370},{"_35":237,"_13":96,"_82":95,"_45":141,"_37":38,"_224":42,"_225":24,"_39":365,"_41":26,"_85":86,"_227":239,"_87":30,"_228":-5,"_299":366,"_17":367},{"_35":361,"_13":339,"_82":334,"_45":-5,"_37":38,"_224":42,"_225":24,"_39":362,"_41":26,"_85":142,"_227":-5,"_87":30,"_228":-5,"_299":363,"_17":364},{"_35":354,"_13":355,"_82":356,"_45":334,"_37":38,"_224":42,"_225":24,"_39":357,"_41":26,"_85":86,"_227":358,"_87":30,"_228":-5,"_299":359,"_17":360},{"_35":347,"_13":348,"_82":349,"_45":334,"_37":38,"_224":42,"_225":24,"_39":350,"_41":26,"_85":21,"_227":351,"_87":30,"_228":-5,"_299":352,"_17":353},{"_35":340,"_13":341,"_82":342,"_45":334,"_37":38,"_224":42,"_225":24,"_39":343,"_41":26,"_85":86,"_227":344,"_87":30,"_228":-5,"_299":345,"_17":346},{"_35":331,"_13":332,"_82":333,"_45":334,"_37":38,"_224":122,"_225":24,"_39":335,"_41":128,"_85":86,"_227":336,"_87":30,"_228":-5,"_299":337,"_17":338},{"_35":324,"_13":325,"_82":326,"_45":-5,"_37":38,"_224":181,"_225":24,"_39":327,"_41":296,"_85":21,"_227":328,"_87":30,"_228":-5,"_299":329,"_17":330},{"_35":317,"_13":318,"_82":319,"_45":-5,"_37":38,"_224":42,"_225":24,"_39":320,"_41":26,"_85":86,"_227":321,"_87":30,"_228":-5,"_299":322,"_17":323},{"_35":310,"_13":311,"_82":312,"_45":-5,"_37":38,"_224":42,"_225":24,"_39":313,"_41":26,"_85":86,"_227":314,"_87":30,"_228":-5,"_299":315,"_17":316},{"_35":302,"_13":303,"_82":304,"_45":-5,"_37":38,"_224":267,"_225":24,"_39":305,"_41":42,"_85":306,"_227":307,"_87":30,"_228":-5,"_299":308,"_17":309},{"_35":293,"_13":294,"_82":295,"_45":-5,"_37":38,"_224":296,"_225":24,"_39":297,"_41":42,"_85":86,"_227":298,"_87":30,"_228":-5,"_299":300,"_17":301},"de044f54-1755-4096-b90e-a38e951914bb","wfibaSource.ts","01a08d53-20b5-7662-bed6-5474dd4b7dac",3,["D",1789077466873],"// 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 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",[],[294],"7923ad4d-ee83-4776-9d56-9336ae943f02","rpc.ts","01a08d53-20b5-7662-bed6-515d510bbb53",["D",1789077477555],"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",[],[303],"86ede1df-7d6a-47c3-ac44-fb082e2522c7","diagnostics.ts","01a08d53-20b5-7662-bed6-4d6ca05ca548",["D",1789077430457],"// 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",[],[311],"0df9d064-bf78-4621-a35c-a3a410a01f62","diagnostics-check.ts","01a08d53-20b5-7662-bed6-49a5df903468",["D",1789077430457],"// 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",[],[318],"9ace790f-4f98-490a-a7a6-94cc38cdb800","README.md","01a08d53-20b5-7662-bed6-468208011dd8",["D",1789077516752],"# 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-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**Coverage as of 2026-09-09 UTC: 34 games across eight dates, ending Sep 13.**\nA manual capture from the official [FIBA tournament schedule](https://www.fiba.basketball/en/events/fiba-womens-basketball-world-cup-2026/games)\nadded Sep 8 (2 final), Sep 9 (2 scheduled), Sep 10 (4 quarterfinals), and Sep 13\n(2 medal-game placeholders) through `games.ingest` using ESPN-compatible envelopes.\nThese are FIBA data, not ESPN responses. Provenance and exact inputs are retained in\n`tools/fiba-snapshot-20260909.json`; the temporary write runner was removed.\nIDs use `fiba-2026-game-{official game number}`; preserve them on refresh.\n\n**Still incomplete:** Sep 12 semifinals (#33/#34) have TBD start-time assignments;\nthe published slots are 14:30 and 18:00 UTC, but neither is assigned to a pairing.\nThey were not ingested because the current source requires an exact timestamp.\nUndecided opponents retain FIBA bracket labels; they do not match favorite-team\ncodes until resolved. Broadcasts were unverified and left null. Medal placeholders\ntherefore remain stored but do not appear in team-filtered feeds yet.\n\nESPN is blocked from Val Town, and the operator reported no schedules after Sep 9.\nDo not blindly rerun `tools/ingest.ts`: an empty/incomplete ESPN response would\nreplace and erase these FIBA-backed dates. Recheck FIBA and refresh participants,\nstatuses, and semifinal times as rounds finish. `GET /coverage` reports stored\nbounds, not proof that every game or participant is resolved.\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",[],[325],"7f097280-53ee-4a44-9812-24079b4bbea3","source-contract-check.ts","01a08d53-20b5-7662-bed6-3d14fa692e0b","01a08d53-20b5-7662-bed6-412b6abc0b2b",["D",1789077493097],"// 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",[],[339,332],"tools","0f58a572-5691-43c1-a15c-9a0348db478f","ingest.ts","01a08d53-20b5-7662-bed6-389ce3f7caa1",["D",1789077430457],"// 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",[],[339,341],"ef5e02e1-4945-401e-8d1b-fce23cd64c5c","fiba-snapshot-20260909.json","01a08d53-20b5-7662-bed6-34692905ddac",["D",1789077430457],"{\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}",[],[339,348],"afb865b4-56a9-400f-83c3-55c58495e54c","deploy-schema.ts","01a08d53-20b4-747e-b432-fb80d470680b",["D",1789077430457],"// 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",[],[339,355],"0f4d7391-76ad-4546-a04e-13e88b031c75",["D",1789077430457],[284,285,286,287],[339],["D",1789077430457],[],[18,96],["D",1789077430457],[],[18,108],["D",1789077457032],[],[18,114],["D",1789077470077],[],[18,120],["D",1789077430457],[],[18,125],["D",1789077430457],[],[18,84],["D",1789077430457],[],[18,102],["D",1789077430457],[276,277,278,279,280,281,282],[18],["D",1788811087002],["D",1789509043237],{"_11":12,"_195":90},{"_11":12,"_191":-5,"_89":90,"_31":88,"_192":193,"_194":30},{"_41":181,"_13":16,"_35":38,"_182":144,"_183":78,"_184":185,"_186":148,"_187":144,"_188":44,"_189":14,"_190":12},"ctx",{"_56":-5,"_215":427,"_428":429,"_430":431,"_432":30,"_433":30,"_434":30,"_435":24,"_436":-5,"_437":-7,"_438":-7,"_439":26,"_440":30,"_441":30,"_442":-5,"_443":30,"_444":30,"_445":30,"_446":-5},"ENV",{"_398":399,"_400":401,"_402":79,"_403":404,"_405":406,"_407":408,"_409":410,"_411":412,"_413":414,"_415":416,"_417":418,"_419":420,"_421":422,"_423":424,"_425":426},"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 · lib