[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_377":378,"_379":380},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_17":18,"_39":-7,"_179":-5,"_19":180,"_181":182,"_183":184,"_185":186,"_187":188,"_21":189,"_190":-5,"_191":192,"_193":30,"_194":195,"_196":24,"_197":-5,"_198":-5,"_199":200},"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","source-diagnostics-tabs","path","lib","project",{"_33":127,"_13":14,"_37":128,"_79":-5,"_129":30,"_130":131,"_132":131,"_133":134,"_135":-5,"_31":86,"_136":137,"_138":24,"_139":-5,"_140":-5,"_141":26,"_41":42,"_142":143,"_144":145,"_146":147,"_148":-5,"_149":150,"_151":150,"_152":153,"_154":153,"_155":153,"_156":150,"_157":150,"_54":158,"_159":160,"_161":162,"_163":30},"file",{"_80":124,"_13":18,"_83":125,"_85":30,"_126":-5},"isDirectory",true,"page",0,"history",[32],"hasNext",false,"userId",{"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_44":45,"_46":-5,"_47":-5,"_48":-5,"_49":-5,"_50":51,"_52":53,"_54":55,"_21":56,"_57":-5,"_58":59,"_60":-5,"_61":62,"_63":64},"id","61f03534-c449-4e62-bb80-933d747c4cc2","branchId","1ab5bb17-de7a-413b-a807-f56d2e25578e","createdAt",["D",1788927880064],"version",1,"orgId","5a10edca-919b-4a78-babb-71908f69af93","parentId","incomingCommitId","1ad6facf-1c32-4423-8018-4efff09f1616","aiChatMessageId","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle","source","mcp","clientLabel","ChatGPT","user",{"_33":86,"_41":42,"_11":12,"_87":88},{"_80":122,"_13":123,"_83":84,"_85":30},"pull","merge",{"_35":76,"_13":77,"_39":78,"_79":-5},"revert","multiple",{"_119":120,"_121":26},"commits",[65,66,67,68,69,70,71],{"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_44":45,"_46":-5,"_47":-5,"_48":-5,"_49":-5,"_50":51,"_52":53,"_54":55,"_21":56,"_57":-5,"_58":59,"_60":-5},{"_33":34,"_35":36,"_37":113,"_39":40,"_41":42,"_43":-5,"_44":45,"_46":-5,"_47":-5,"_48":-5,"_49":-5,"_50":51,"_52":53,"_54":114,"_21":115,"_57":-5,"_58":116,"_60":-5},{"_33":34,"_35":36,"_37":107,"_39":40,"_41":42,"_43":-5,"_44":45,"_46":-5,"_47":-5,"_48":-5,"_49":-5,"_50":51,"_52":53,"_54":108,"_21":109,"_57":-5,"_58":110,"_60":-5},{"_33":34,"_35":36,"_37":101,"_39":40,"_41":42,"_43":-5,"_44":45,"_46":-5,"_47":-5,"_48":-5,"_49":-5,"_50":51,"_52":53,"_54":102,"_21":103,"_57":-5,"_58":104,"_60":-5},{"_33":34,"_35":36,"_37":95,"_39":40,"_41":42,"_43":-5,"_44":45,"_46":-5,"_47":-5,"_48":-5,"_49":-5,"_50":51,"_52":53,"_54":96,"_21":97,"_57":-5,"_58":98,"_60":-5},{"_33":34,"_35":36,"_37":89,"_39":40,"_41":42,"_43":-5,"_44":45,"_46":-5,"_47":-5,"_48":-5,"_49":-5,"_50":51,"_52":53,"_54":90,"_21":91,"_57":-5,"_58":92,"_60":-5},{"_33":34,"_35":36,"_37":72,"_39":40,"_41":42,"_43":-5,"_44":45,"_46":-5,"_47":-5,"_48":-5,"_49":-5,"_50":51,"_52":53,"_54":73,"_21":74,"_57":-5,"_58":75,"_60":-5},["D",1788927880064],{"_33":86,"_41":42,"_11":12,"_87":88},{"_80":81,"_13":82,"_83":84,"_85":30},{"_35":76,"_13":77,"_39":78,"_79":-5},"20967dcf-9eb1-4cbf-a721-cf05b71b776a","main",53,"deletedAt","fileId","01a08469-2b7e-74a3-8d5a-cc117c4a3dbc","store.ts","fileType","script","deleted","b0a8da26-58e7-4d19-8b5c-eedf487df9a9","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yVHpab25kTlBTM3M3WmpCa3NMSTd5akVwWksuanBlZyJ9",["D",1788927880064],{"_33":86,"_41":42,"_11":12,"_87":88},{"_80":93,"_13":94,"_83":21,"_85":30},{"_35":76,"_13":77,"_39":78,"_79":-5},"01a08469-2b7e-74a3-8d5a-cbbf64cf2a7b","schema.sql",["D",1788927880064],{"_33":86,"_41":42,"_11":12,"_87":88},{"_80":99,"_13":100,"_83":84,"_85":30},{"_35":76,"_13":77,"_39":78,"_79":-5},"01a08469-2b7d-713b-bd22-ecfaeec4bd27","items.ts",["D",1788927880064],{"_33":86,"_41":42,"_11":12,"_87":88},{"_80":105,"_13":106,"_83":84,"_85":30},{"_35":76,"_13":77,"_39":78,"_79":-5},"01a08469-2b7d-713b-bd22-ebf492b17b4f","feed.ts",["D",1788927880064],{"_33":86,"_41":42,"_11":12,"_87":88},{"_80":111,"_13":112,"_83":84,"_85":30},{"_35":76,"_13":77,"_39":78,"_79":-5},"01a08469-2b7d-713b-bd22-e7cf7c39efe1","espn.ts",["D",1788927880064],{"_33":86,"_41":42,"_11":12,"_87":88},{"_80":117,"_13":118,"_83":84,"_85":30},{"_35":76,"_13":77,"_39":78,"_79":-5},"01a08469-2b7d-713b-bd22-e12747a57001","dates.ts","count",7,"deletedCount","01a08469-2b7d-713b-bd22-dfe3216131eb","channels.ts","01a08469-2b7e-74a3-8d5a-d2954557ff34","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,"_178":88},"org",{"_11":12,"_174":-5,"_87":88,"_31":86,"_175":176,"_177":30},"branch",{"_39":164,"_13":16,"_33":36,"_165":127,"_166":76,"_167":168,"_169":131,"_170":127,"_171":42,"_172":14,"_173":12},"isOwned",5,"projectId","forkedBranchId","forkedBranchVersion",44,"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":127,"_13":14,"_37":372,"_79":-5,"_129":30,"_130":131,"_132":131,"_133":134,"_135":-5,"_31":86,"_136":137,"_138":24,"_139":-5,"_140":-5,"_141":26,"_41":42,"_142":143,"_144":145,"_146":373,"_148":-5,"_149":150,"_151":150,"_152":153,"_154":153,"_155":153,"_156":150,"_157":150,"_54":374,"_159":375,"_161":376,"_163":30},"tree",[258,266,271,272,273,274,275],"files",[258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275],"counts",{"_248":26,"_249":164,"_250":26,"_251":252,"_253":254},"contents",[213,214,215,216,217,218,219],{"_33":206,"_13":18,"_80":124,"_43":-5,"_35":36,"_207":40,"_208":24,"_37":209,"_39":26,"_83":125,"_210":-5,"_85":30,"_211":-5,"_17":212},"upstreamProject","upstreamBranch",{"_33":76,"_37":201,"_202":203,"_13":77,"_165":127,"_39":78,"_166":-5,"_167":-5,"_204":205,"_79":-5,"_163":30,"_130":131,"_173":12,"_41":42,"_172":14},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1788811087002],"updatedAt",["D",1789502869681],"lockfileKey","1789502869788-esm.town_v_plusjade_source-wfiba@53-main","e91ddcf4-b921-4a99-90c9-e7fe14d7635d","branchVersion","latest",["D",1788927880064],"content","label",[18],{"_33":244,"_13":123,"_80":122,"_43":124,"_35":36,"_207":40,"_208":24,"_37":245,"_39":26,"_83":84,"_210":246,"_85":30,"_211":-5,"_17":247},{"_33":240,"_13":118,"_80":117,"_43":124,"_35":36,"_207":40,"_208":24,"_37":241,"_39":26,"_83":84,"_210":242,"_85":30,"_211":-5,"_17":243},{"_33":236,"_13":112,"_80":111,"_43":124,"_35":36,"_207":40,"_208":24,"_37":237,"_39":26,"_83":84,"_210":238,"_85":30,"_211":-5,"_17":239},{"_33":232,"_13":106,"_80":105,"_43":124,"_35":36,"_207":40,"_208":24,"_37":233,"_39":26,"_83":84,"_210":234,"_85":30,"_211":-5,"_17":235},{"_33":228,"_13":100,"_80":99,"_43":124,"_35":36,"_207":40,"_208":24,"_37":229,"_39":26,"_83":84,"_210":230,"_85":30,"_211":-5,"_17":231},{"_33":224,"_13":94,"_80":93,"_43":124,"_35":36,"_207":40,"_208":24,"_37":225,"_39":26,"_83":21,"_210":226,"_85":30,"_211":-5,"_17":227},{"_33":220,"_13":82,"_80":81,"_43":124,"_35":36,"_207":40,"_208":24,"_37":221,"_39":26,"_83":84,"_210":222,"_85":30,"_211":-5,"_17":223},"09ab253f-dd55-464f-a72a-ba2328c42a4c",["D",1788927880064],"// 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,82],"adbf7be0-447a-4434-8e99-1f70d0b346d6",["D",1788927880064],"-- 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,94],"75935d49-c719-4efb-9b23-e032588667b8",["D",1788927880064],"// 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",[18,100],"de4cfdfc-5249-49c4-bea4-1eb09b71012f",["D",1788927880064],"// 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",[18,106],"091a5b40-10ea-4cd8-b07c-fd846a521524",["D",1788927880064],"// 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,112],"c01888ed-e898-459c-9063-9570f486eca5",["D",1788927880064],"// 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,118],"7bdcbcae-530c-40c4-84ae-8b8ff4033bf8",["D",1788927880064],"// 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,123],"pulls","branches","forks","envVars",{"_119":256,"_257":26},"connections",{"_119":26,"_255":26},"unfilledCount",4,"emptyCount",{"_33":206,"_13":18,"_80":124,"_43":-5,"_35":36,"_207":40,"_208":24,"_37":369,"_39":26,"_83":125,"_210":-5,"_85":30,"_211":-5,"_281":370,"_17":371},{"_33":244,"_13":123,"_80":122,"_43":124,"_35":36,"_207":40,"_208":24,"_37":366,"_39":26,"_83":84,"_210":246,"_85":30,"_211":-5,"_281":367,"_17":368},{"_33":240,"_13":118,"_80":117,"_43":124,"_35":36,"_207":40,"_208":24,"_37":363,"_39":26,"_83":84,"_210":242,"_85":30,"_211":-5,"_281":364,"_17":365},{"_33":236,"_13":112,"_80":111,"_43":124,"_35":36,"_207":40,"_208":24,"_37":360,"_39":26,"_83":84,"_210":238,"_85":30,"_211":-5,"_281":361,"_17":362},{"_33":232,"_13":106,"_80":105,"_43":124,"_35":36,"_207":40,"_208":24,"_37":357,"_39":26,"_83":84,"_210":234,"_85":30,"_211":-5,"_281":358,"_17":359},{"_33":228,"_13":100,"_80":99,"_43":124,"_35":36,"_207":40,"_208":24,"_37":354,"_39":26,"_83":84,"_210":230,"_85":30,"_211":-5,"_281":355,"_17":356},{"_33":224,"_13":94,"_80":93,"_43":124,"_35":36,"_207":40,"_208":24,"_37":351,"_39":26,"_83":21,"_210":226,"_85":30,"_211":-5,"_281":352,"_17":353},{"_33":220,"_13":82,"_80":81,"_43":124,"_35":36,"_207":40,"_208":24,"_37":348,"_39":26,"_83":84,"_210":222,"_85":30,"_211":-5,"_281":349,"_17":350},{"_33":344,"_13":322,"_80":317,"_43":-5,"_35":36,"_207":40,"_208":24,"_37":345,"_39":26,"_83":125,"_210":-5,"_85":30,"_211":-5,"_281":346,"_17":347},{"_33":337,"_13":338,"_80":339,"_43":317,"_35":36,"_207":40,"_208":24,"_37":340,"_39":26,"_83":84,"_210":341,"_85":30,"_211":-5,"_281":342,"_17":343},{"_33":330,"_13":331,"_80":332,"_43":317,"_35":36,"_207":40,"_208":24,"_37":333,"_39":26,"_83":21,"_210":334,"_85":30,"_211":-5,"_281":335,"_17":336},{"_33":323,"_13":324,"_80":325,"_43":317,"_35":36,"_207":40,"_208":24,"_37":326,"_39":26,"_83":84,"_210":327,"_85":30,"_211":-5,"_281":328,"_17":329},{"_33":314,"_13":315,"_80":316,"_43":317,"_35":36,"_207":40,"_208":24,"_37":318,"_39":26,"_83":84,"_210":319,"_85":30,"_211":-5,"_281":320,"_17":321},{"_33":307,"_13":308,"_80":309,"_43":-5,"_35":36,"_207":40,"_208":24,"_37":310,"_39":26,"_83":21,"_210":311,"_85":30,"_211":-5,"_281":312,"_17":313},{"_33":300,"_13":301,"_80":302,"_43":-5,"_35":36,"_207":164,"_208":24,"_37":303,"_39":26,"_83":84,"_210":304,"_85":30,"_211":-5,"_281":305,"_17":306},{"_33":293,"_13":294,"_80":295,"_43":-5,"_35":36,"_207":288,"_208":24,"_37":296,"_39":26,"_83":84,"_210":297,"_85":30,"_211":-5,"_281":298,"_17":299},{"_33":284,"_13":285,"_80":286,"_43":-5,"_35":36,"_207":256,"_208":24,"_37":287,"_39":288,"_83":289,"_210":290,"_85":30,"_211":-5,"_281":291,"_17":292},{"_33":276,"_13":277,"_80":278,"_43":-5,"_35":36,"_207":40,"_208":24,"_37":279,"_39":26,"_83":84,"_210":280,"_85":30,"_211":-5,"_281":282,"_17":283},"09bd058d-338b-4e7b-b2c1-0ab975b3e628","wfibaSource.ts","01a08469-2b7e-74a3-8d5a-f12ba16a0a15",["D",1788927880064],"// 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",[],[277],"2d96297a-42d9-48ac-9ca5-5f2dbb87d34d","rpc.ts","01a08469-2b7e-74a3-8d5a-ec2fe7d55922",["D",1788927891046],2,"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@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 (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",[],[285],"b174ff80-1ab8-4909-acf8-9abbe9aabd78","diagnostics.ts","618bf2f2-ac06-11f1-ac0a-1607ee4eb77e",["D",1788927883136],"// 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",[],[294],"1acbf650-3aff-4be9-8529-1c7de3e7ea43","diagnostics-check.ts","b6ac86ca-ac06-11f1-b435-1607ee4eb77e",["D",1788928025962],"// 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",[],[301],"59d9f318-bd44-445f-a4ec-3ee9c870661b","README.md","01a08469-2b7e-74a3-8d5a-eb499e09e66e",["D",1788927880064],"# 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**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@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",[],[308],"6bd78bcb-da55-4c56-902a-1dd9e11ccb7b","source-contract-check.ts","01a08469-2b7e-74a3-8d5a-e1313f0d3e8b","01a08469-2b7e-74a3-8d5a-e49b5a6479bd",["D",1788927880064],"// 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",[],[322,315],"tools","b2eed29a-067a-4736-8cad-3e21780c5514","ingest.ts","01a08469-2b7e-74a3-8d5a-dc22e1311bb6",["D",1788927880064],"// 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",[],[322,324],"4351e00b-6f37-4d09-817d-ad7bcc3641e8","fiba-snapshot-20260909.json","01a08469-2b7e-74a3-8d5a-d939c4f9762e",["D",1788927880064],"{\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}",[],[322,331],"95978ecd-22ff-46f1-87d6-45c33d0a659c","deploy-schema.ts","01a08469-2b7e-74a3-8d5a-d7f348ad5a8b",["D",1788927880064],"// 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",[],[322,338],"46321f48-4923-480c-b7db-f8364a898f47",["D",1788927880064],[267,268,269,270],[322],["D",1788927880064],[],[18,82],["D",1788927880064],[],[18,94],["D",1788927880064],[],[18,100],["D",1788927880064],[],[18,106],["D",1788927880064],[],[18,112],["D",1788927880064],[],[18,118],["D",1788927880064],[],[18,123],["D",1788927880064],[259,260,261,262,263,264,265],[18],["D",1788811087002],["D",1789509043237],{"_11":12,"_178":88},{"_11":12,"_174":-5,"_87":88,"_31":86,"_175":176,"_177":30},{"_39":164,"_13":16,"_33":36,"_165":127,"_166":76,"_167":168,"_169":131,"_170":127,"_171":42,"_172":14,"_173":12},"ctx",{"_54":-5,"_198":410,"_411":412,"_413":414,"_415":30,"_416":30,"_417":30,"_418":24,"_419":-5,"_420":-7,"_421":-7,"_422":26,"_423":30,"_424":30,"_425":-5,"_426":30,"_427":30,"_428":30,"_429":-5},"ENV",{"_381":382,"_383":384,"_385":77,"_386":387,"_388":389,"_390":391,"_392":393,"_394":395,"_396":397,"_398":399,"_400":401,"_402":403,"_404":405,"_406":407,"_408":409},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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