[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_387":388,"_389":390},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_285":-5,"_20":286,"_22":287,"_288":289,"_290":291,"_26":292,"_24":293,"_294":295,"_296":297,"_298":54,"_299":300,"_301":70,"_302":-5,"_303":-5,"_304":305},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":29,"_30":-5,"_31":32,"_33":34,"_35":-5},"handle","plusjade","name","source-wnba","branchName","lifecycle-window","version","path","rpc.ts","project",{"_36":44,"_13":14,"_38":238,"_52":-5,"_239":54,"_55":56,"_240":56,"_241":242,"_243":-5,"_244":245,"_246":247,"_248":70,"_249":-5,"_250":-5,"_251":32,"_58":59,"_252":253,"_254":255,"_256":257,"_258":-5,"_259":260,"_261":260,"_262":263,"_264":263,"_265":263,"_266":260,"_267":260,"_268":269,"_270":271,"_272":273,"_53":54},"tree",[79,80,81,82,83,84,85,86],"file",{"_36":61,"_13":19,"_62":63,"_64":-5,"_65":66,"_67":68,"_69":70,"_38":71,"_17":34,"_72":73,"_74":75,"_76":54,"_77":-5,"_18":78},"contents",[],"upstream",{"_36":37,"_38":39,"_40":41,"_13":42,"_43":44,"_17":45,"_46":47,"_48":49,"_50":51,"_52":-5,"_53":54,"_55":56,"_57":12,"_58":59,"_60":14},"pull","ahead",0,"behind",1,"envVars","id","e48487c1-8c7d-4a71-8497-20fa5e49852d","createdAt",["D",1788818616931],"updatedAt",["D",1789502865626],"main","projectId","c0bf06b0-4d38-49ff-aa56-54d81db775bb",16,"forkedBranchId","72e0d709-5cf3-4bb8-91f0-b616d4c49f98","forkedBranchVersion",2,"lockfileKey","1789502865793-esm.town_v_plusjade_source-wnba@16-main","deletedAt","isOwned",false,"privacy","public","userHandle","orgId","5a10edca-919b-4a78-babb-71908f69af93","projectName","ae1b539a-5169-4a6d-b7a5-67c2de637744","fileId","01a08d56-91fd-7254-9bfc-ed169df24003","parentId","branchId","4222f4f6-17f7-4aa0-8a00-08e8f59a3226","branchVersion",5,"latest",true,["D",1789077695893],"fileType","http","content","// Authenticated WNBA source protocol and cache coverage diagnostics.\nimport { diagnostics } from \"./diagnostics.ts\";\nimport { serveSource } from \"https://esm.town/v/plusjade/source-sdk@12-main/mod.ts\";\nimport wnbaSource from \"./wnbaSource.ts\";\nimport { readCatalog } from \"./lib/catalogStore.ts\";\nimport { cachedGamesCoverage } from \"./lib/cachedGames.ts\";\nexport default async function handler(req:Request):Promise {\n const expected=Deno.env.get(\"SOURCE_WNBA_V1_TOKEN\");\n if(!expected) return Response.json({error:\"RPC token not configured\"},{status:503});\n if(req.headers.get(\"authorization\") !== `Bearer ${expected}`) return Response.json({error:\"unauthorized\"},{status:401});\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(wnbaSource,req);\n if(req.method===\"GET\"&&url.pathname===\"/health\") return Response.json({ok:true});\n if(req.method===\"GET\"&&url.pathname===\"/catalog\") return Response.json(await readCatalog());\n if(req.method===\"GET\"&&url.pathname===\"/cached-games/coverage\") return Response.json(await cachedGamesCoverage());\n return new Response(\"Not found\",{status:404});\n}\n","deleted","label",[19],{"_36":152,"_13":153,"_62":154,"_64":-5,"_65":66,"_67":34,"_69":70,"_38":155,"_17":32,"_72":126,"_74":-5,"_76":54,"_77":-5,"_94":156,"_18":157},{"_36":146,"_13":147,"_62":148,"_64":-5,"_65":66,"_67":34,"_69":70,"_38":149,"_17":32,"_72":126,"_74":-5,"_76":54,"_77":-5,"_94":150,"_18":151},{"_36":122,"_13":123,"_62":124,"_64":-5,"_65":66,"_67":34,"_69":70,"_38":125,"_17":32,"_72":126,"_74":-5,"_76":54,"_77":-5,"_94":127,"_18":128},{"_36":115,"_13":116,"_62":117,"_64":-5,"_65":66,"_67":34,"_69":70,"_38":118,"_17":32,"_72":92,"_74":119,"_76":54,"_77":-5,"_94":120,"_18":121},{"_36":108,"_13":109,"_62":110,"_64":-5,"_65":66,"_67":34,"_69":70,"_38":111,"_17":32,"_72":92,"_74":112,"_76":54,"_77":-5,"_94":113,"_18":114},{"_36":100,"_13":101,"_62":102,"_64":-5,"_65":66,"_67":34,"_69":70,"_38":103,"_17":32,"_72":104,"_74":105,"_76":54,"_77":-5,"_94":106,"_18":107},{"_36":61,"_13":19,"_62":63,"_64":-5,"_65":66,"_67":68,"_69":70,"_38":97,"_17":34,"_72":73,"_74":75,"_76":54,"_77":-5,"_94":98,"_18":99},{"_36":87,"_13":88,"_62":89,"_64":-5,"_65":66,"_67":90,"_69":70,"_38":91,"_17":34,"_72":92,"_74":93,"_76":54,"_77":-5,"_94":95,"_18":96},"60a13385-3644-44b1-8ac6-1e9c8d403ca6","wnbaSource.ts","01a08d56-91fd-7254-9bfc-f352432d4389",6,["D",1789077698888],"script","// WNBA settings and operations exported through the shared source SDK.\nimport { readCatalog } from \"./lib/catalogStore.ts\";\nimport { wnbaItems } from \"./lib/wnbaFeed.ts\";\nimport { ingestSleeperWindow } from \"./lib/sleeperIngest.ts\";\nimport type { Catalog } from \"./lib/catalog.ts\";\nimport { accept, defineSource, reject } from \"https://esm.town/v/plusjade/source-sdk@12-main/mod.ts\";\n\n// parseSettings' output, not the wire shape. It carries the catalog snapshot\n// it validated against so the read doesn't go back to SQLite for a second\n// copy — and so selection is resolved against exactly the catalog the request\n// was checked against, even if someone edits a team mid-request.\ntype WNBARead = {\n teams: string[];\n intradayFilter: boolean;\n catalog: Catalog;\n};\n\nasync function settingsSchema() {\n const catalog = await readCatalog();\n return {\n type: \"object\",\n properties: {\n teams: {\n type: \"array\", title: \"Teams\", default: [], uniqueItems: true,\n description: \"Choose teams to follow. No selection produces an empty feed.\",\n items: { type: \"string\", oneOf: catalog.competitions.flatMap((competition) =>\n catalog.teams.filter((team) => team.competitionCode === competition.code).map((team) => ({\n const: team.slug, title: team.displayName, \"x-group\": competition.displayName,\n }))) },\n },\n intradayFilter: {\n type: \"boolean\", title: \"Hide a game as soon as it ends\", 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: \"wnba\",\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 references a team we\n // dropped from the catalog\" 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 catalog = await readCatalog();\n const teams = raw.teams as string[];\n if (teams.some((slug) => !catalog.teams.some((team) => team.slug === slug))) {\n return reject(\"unknown_team\");\n }\n\n return accept({ teams, intradayFilter: raw.intradayFilter === true, catalog });\n },\n\n read: ({ teams, intradayFilter, catalog }, { utcOffsetSeconds }) =>\n wnbaItems({ teams, intradayFilter }, utcOffsetSeconds, catalog),\n\n writes: {\n // Pull the next N days of Sleeper's slate into cached_games. Bounded at 31\n // because each day is a separate upstream request.\n \"sleeper.refresh\": async (payload) => {\n const days = payload.days;\n if (typeof days !== \"number\" || !Number.isInteger(days) || days < 1 || days > 31) {\n return reject(\"invalid_days\");\n }\n return accept(await ingestSleeperWindow(days));\n },\n },\n});\n","children",[],[88],["D",1789077695893],[],[19],"8da41bf6-dd01-474e-92b0-54ab51ad8162","refresh.ts","01a08d56-91fd-7254-9bfc-eb050bfb0cae",["D",1789077656071],"interval","// Scheduled cached_games ingest — the val's third entrypoint, alongside rpc.ts\n// (remote callers) and tools/ (operator runs).\n//\n// Calls ingestSleeperWindow directly rather than going through rpc.ts: the\n// bearer check there exists to gate remote callers, and a job running inside\n// this val is not one. Transport belongs at the edge, and this job IS an edge.\n//\n// Hourly rather than daily because the window is not the only thing that goes\n// stale: cached status is what widgetItems turns into the LIVE/END caption and\n// what intradayFilter hides a finished game on, so a daily run would leave a\n// game reading as scheduled for hours after it ended.\nimport { ingestSleeperWindow } from \"./lib/sleeperIngest.ts\";\n\n// Horizon in days past today_ET. Wide enough that coverage survives a stretch\n// of failed runs, and cheap enough to re-fetch hourly: one upstream request\n// per date in the window, issued in parallel.\nconst DAYS = 14;\n\nexport default async function (_interval: Interval) {\n const report = await ingestSleeperWindow(DAYS);\n console.log(\n `wnba ingest ${report.dates[0]}..${report.dates.at(-1)}: `\n + `fetched ${report.fetched}, stored ${report.stored}, skipped ${report.skipped}`,\n );\n}\n",[],[101],"2d5988b5-9574-4b44-b443-f72cb71fea8d","diagnostics.ts","01a08d56-91fd-7254-9bfc-e67fa27b5110",["D",1789077656071],"// 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 cached_games WHERE sport = 'wnba'`);\n const row = result.rows[0];\n return {\n diagnosticsVersion: 1, sourceKey: \"wnba\", 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",[],[109],"d702e432-c082-4e84-a75d-2fd9aa683ee5","diagnostics-check.ts","01a08d56-91fd-7254-9bfc-e33d9499de1d",["D",1789077656071],"// Read-only verification of the diagnostics mount and existing descriptor.\nimport handler from \"./rpc.ts\";\nconst headers = { authorization: `Bearer ${Deno.env.get(\"SOURCE_WNBA_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 === \"wnba\" && 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=wnba\", { 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",[],[116],"a0ae4aa6-fb28-4b86-b293-7fcacd733c88","tools","01a08d56-91fd-7254-9bfc-df16b071e4ee",["D",1789077656071],"directory",[129,130],[123],{"_36":139,"_13":140,"_62":141,"_64":124,"_65":66,"_67":34,"_69":70,"_38":142,"_17":32,"_72":92,"_74":143,"_76":54,"_77":-5,"_94":144,"_18":145},{"_36":131,"_13":132,"_62":133,"_64":124,"_65":66,"_67":134,"_69":70,"_38":135,"_17":49,"_72":92,"_74":136,"_76":54,"_77":-5,"_94":137,"_18":138},"f56420a3-6d25-4502-998b-07ec0d71351a","source-contract-check.ts","01a08d56-91fd-7254-9bfc-db3368a1143b",4,["D",1789077692452],"// WNBA contract and deterministic selection checks. No production writes.\nimport handler from \"../rpc.ts\";\nimport { items, phase } from \"https://esm.town/v/plusjade/source-sdk@12-main/mod.ts\";\nimport { readCatalog } from \"../lib/catalogStore.ts\";\nimport { pickNextPerTeam } from \"../lib/games.ts\";\nimport { widgetItems } from \"../lib/widgetItems.ts\";\nimport { normalizeGame } from \"../lib/sleeperIngest.ts\";\nimport { dayStartMsAtOffset } from \"../lib/dates.ts\";\nlet checks=0;\nfunction check(ok:unknown,msg:string){if(!ok)throw new Error(msg);checks++;}\nconst token=Deno.env.get(\"SOURCE_WNBA_V1_TOKEN\");\nasync function call(path:string,body?:unknown,auth=true){\n const r=await handler(new Request(\"https://fixture.invalid\"+path,{method:body?\"POST\":\"GET\",headers:auth?{authorization:`Bearer ${token}`}:{},body:body?JSON.stringify(body):undefined}));\n return {status:r.status,body:await r.json().catch(()=>null)};\n}\nconst base={protocolVersion:1,sourceKey:\"wnba\",settings:{teams:[\"fever\"],intradayFilter:false},context:{utcOffsetSeconds:0}};\ncheck((await call(\"/v1/descriptor\",undefined,false)).status===401,\"auth\");\nconst d=(await call(\"/v1/descriptor?sourceKey=wnba\")).body;\ncheck(d.sourceKey===\"wnba\"&&d.protocolVersion===1&&d.temporal,\"identity\");\ncheck(d.capabilities.validateSettings&&JSON.stringify(d.capabilities.write)==='[\"sleeper.refresh\"]'&&!d.capabilities.publish,\"capabilities\");\nconst s=d.settingsSchema;\ncheck(s.additionalProperties===false&&s.required.includes(\"teams\"),\"closed settings\");\ncheck(s.properties.teams.uniqueItems&&s.properties.teams.items.type===\"string\"&&s.properties.teams.items.oneOf.length===15,\"15 choices\");\ncheck(s.properties.teams.items.oneOf.every((x:any)=>typeof x.const===\"string\"&&typeof x.title===\"string\"&&x[\"x-group\"]===\"WNBA\"),\"choice labels\");\ncheck(s.properties.intradayFilter.type===\"boolean\"&&s.properties.intradayFilter.default===false,\"boolean settings\");\nfor(const offset of [-43200,-25200,0,50400,null]){\n const r=await call(\"/v1/read\",{...base,context:{utcOffsetSeconds:offset}});\n check(r.status===200&&items(r.body.items),\"read \"+offset);\n}\nconst valid=await call(\"/v1/validate-settings\",base);\ncheck(valid.status===200&&Object.keys(valid.body).length===3&&valid.body.ok,\"validation isolation\");\nfor(const settings of [{teams:[\"fever\",\"fever\"]},{teams:[],unexpected:true},{teams:[],intradayFilter:\"true\"},{teams:\"fever\"}]){\n check((await call(\"/v1/validate-settings\",{...base,settings})).body.error===\"invalid_settings\",\"invalid settings\");\n}\nfor(const slug of [\"trojans\",\"united-states\",\"rams\",\"missing\"]){\n check((await call(\"/v1/read\",{...base,settings:{teams:[slug]}})).body.error===\"unknown_team\",\"non WNBA \"+slug);\n}\ncheck((await call(\"/v1/read\",{...base,settings:{teams:[]}})).body.items.length===0,\"empty\");\ncheck((await call(\"/v1/read\",{...base,sourceKey:\"sports\"})).status===404,\"old key\");\ncheck((await call(\"/v1/read\",{...base,protocolVersion:2})).status===400,\"protocol\");\ncheck((await call(\"/v1/publish\",base)).status===501,\"publish\");\nfor(const operation of [\"cache.put\",\"toString\",\"sql\"]){\n check((await call(\"/v1/write\",{...base,operation,payload:{}})).status===422,\"write guard\");\n}\nfor(const days of [0,32,1.5,\"1\"]){\n check((await call(\"/v1/write\",{...base,operation:\"sleeper.refresh\",payload:{days}})).body.error===\"invalid_days\",\"days\");\n}\nconst catalog=await readCatalog();\nconst game={sport:\"wnba\",game_id:\"fixture\",start_time:1788739200000,status:\"final\",metadata:{away_team:\"IND\",home_team:\"LAS\",channel:\"NBC\"}};\nconst picked=pickNextPerTeam([game],[{sport:\"wnba\",code:\"IND\"},{sport:\"wnba\",code:\"LAS\"}],[\"wnba\"])!;\nconst built=widgetItems(picked.bySport,catalog);\ncheck(built.length===1&&built[0].startsAt===1788739200&&built[0].mainText===\"🏀 Fever @ Sparks\",\"union and seconds\");\ncheck(built[0].timestamp===1788739200,\"the transitional timestamp still mirrors startsAt\");\ncheck(built[0].expiresAt===1788739200+7200,\"the window is this source's own typical duration\");\ncheck(built[0].caption===\"END\"&&!built[0].emphasized&&widgetItems(picked.bySport,catalog,true).length===0,\"final filter\");\n// Lifecycle from the clock, with no ingest between these calls: a stale\n// `scheduled` on a tipped-off game still reads LIVE.\nconst stale=pickNextPerTeam([{...game,status:\"scheduled\"}],[{sport:\"wnba\",code:\"IND\"}],[\"wnba\"])!;\nconst tipoff=1788739200;\ncheck(widgetItems(stale.bySport,catalog,false,tipoff-1)[0].caption===null,\"before tipoff the client formats the time\");\ncheck(widgetItems(stale.bySport,catalog,false,tipoff+60)[0].caption===\"LIVE\",\"a stale scheduled status still reads live\");\ncheck(widgetItems(stale.bySport,catalog,false,tipoff+7200)[0].caption===\"END\",\"expired by the clock alone\");\ncheck(widgetItems(picked.bySport,catalog,false,tipoff+60)[0].caption===\"END\",\"an ingested final is never live\");\ncheck(phase(widgetItems(stale.bySport,catalog,false,tipoff)[0],tipoff)===\"current\",\"phase agrees with the caption\");\ncheck(normalizeGame({...game,sport:\"nfl\"})===null,\"ingest league guard\");\ncheck(normalizeGame(game)?.away_code===\"IND\",\"flat WNBA shape\");\ncheck(dayStartMsAtOffset(50400,new Date(\"2026-09-07T20:00:00Z\"))===Date.parse(\"2026-09-07T10:00:00Z\"),\"UTC+14 boundary\");\ncheck(normalizeGame({...game,metadata:{away_team:{team:\"IND\",record:\"0-0\"},home_team:{team:\"LAS\"}}})?.away_code===\"IND\",\"nested WNBA shape\");\ncheck(normalizeGame({...game,metadata:{away_team:{team:42}}})?.away_code===null,\"malformed team\");\nconsole.log(\"PASS: \"+checks+\" WNBA assertions\");\n",[],[123,132],"51cfeba5-6ad9-4b25-8dd1-540641f3b8a0","sleeper-ingest.ts","01a08d56-91fd-7254-9bfc-d7a58d3901c0",["D",1789077656071],"// Operator entry point for populating cached_games: drives the real\n// sleeper.refresh write through rpc.ts, so the run exercises the same auth,\n// protocol envelope and day guard a parent-issued ingest would.\n//\n// DAYS is edited in place before a run rather than read from an argument —\n// run_file passes none, and the value is a deliberate operator choice each\n// time. The window ingestSleeperWindow builds is [today_ET - 1, today_ET + DAYS],\n// so pick DAYS to reach the last slate date you want covered.\nimport handler from \"../rpc.ts\";\nimport { cachedGamesCoverage } from \"../lib/cachedGames.ts\";\n\nconst DAYS = 14;\n\nconst token = Deno.env.get(\"SOURCE_WNBA_V1_TOKEN\");\nif (!token) throw new Error(\"SOURCE_WNBA_V1_TOKEN is not configured\");\n\nconst response = await handler(\n new Request(\"https://fixture.invalid/v1/write\", {\n method: \"POST\",\n headers: { authorization: `Bearer ${token}`, \"content-type\": \"application/json\" },\n body: JSON.stringify({\n protocolVersion: 1,\n sourceKey: \"wnba\",\n operation: \"sleeper.refresh\",\n payload: { days: DAYS },\n }),\n }),\n);\n\nconst body = await response.json();\nif (!response.ok) throw new Error(`ingest failed (${response.status}): ${JSON.stringify(body)}`);\n\nconsole.log(JSON.stringify({ report: body.result, coverage: await cachedGamesCoverage() }, null, 2));\n",[],[123,140],"d699c085-06b7-4da1-aaaf-322c5f2f7d28","sdk","01a08d56-91fd-7254-9bfc-d22a77a9913a",["D",1789077656071],[],[147],"d7795c02-f7cd-46b4-9ca9-0e9ad53f48d9","lib","01a08d56-91fd-7254-9bfc-ce3305a254ff",["D",1789077656071],[158,159,160,161,162,163,164,165,166,167],[153],{"_36":231,"_13":232,"_62":233,"_64":154,"_65":66,"_67":34,"_69":70,"_38":234,"_17":32,"_72":92,"_74":235,"_76":54,"_77":-5,"_94":236,"_18":237},{"_36":224,"_13":225,"_62":226,"_64":154,"_65":66,"_67":34,"_69":70,"_38":227,"_17":32,"_72":92,"_74":228,"_76":54,"_77":-5,"_94":229,"_18":230},{"_36":217,"_13":218,"_62":219,"_64":154,"_65":66,"_67":34,"_69":70,"_38":220,"_17":32,"_72":92,"_74":221,"_76":54,"_77":-5,"_94":222,"_18":223},{"_36":210,"_13":211,"_62":212,"_64":154,"_65":66,"_67":34,"_69":70,"_38":213,"_17":32,"_72":92,"_74":214,"_76":54,"_77":-5,"_94":215,"_18":216},{"_36":203,"_13":204,"_62":205,"_64":154,"_65":66,"_67":34,"_69":70,"_38":206,"_17":32,"_72":92,"_74":207,"_76":54,"_77":-5,"_94":208,"_18":209},{"_36":196,"_13":197,"_62":198,"_64":154,"_65":66,"_67":34,"_69":70,"_38":199,"_17":32,"_72":92,"_74":200,"_76":54,"_77":-5,"_94":201,"_18":202},{"_36":189,"_13":190,"_62":191,"_64":154,"_65":66,"_67":34,"_69":70,"_38":192,"_17":32,"_72":92,"_74":193,"_76":54,"_77":-5,"_94":194,"_18":195},{"_36":182,"_13":183,"_62":184,"_64":154,"_65":66,"_67":34,"_69":70,"_38":185,"_17":32,"_72":92,"_74":186,"_76":54,"_77":-5,"_94":187,"_18":188},{"_36":175,"_13":176,"_62":177,"_64":154,"_65":66,"_67":49,"_69":70,"_38":178,"_17":34,"_72":92,"_74":179,"_76":54,"_77":-5,"_94":180,"_18":181},{"_36":168,"_13":169,"_62":170,"_64":154,"_65":66,"_67":34,"_69":70,"_38":171,"_17":32,"_72":92,"_74":172,"_76":54,"_77":-5,"_94":173,"_18":174},"96794622-c624-4c22-bc72-efe304c41fe4","wnbaFeed.ts","01a08d56-91fd-7254-9bfc-c910624cabe6",["D",1789077656071],"// Each selected WNBA team's next cached game, unioned into temporal items.\nimport type { Catalog } from \"./catalog.ts\";\nimport { nextGamesForTeams } from \"./cachedGames.ts\";\nimport { clientOffsetSeconds, dayStartMsAtOffset } from \"./dates.ts\";\nimport { pickNextPerTeam } from \"./games.ts\";\nimport { widgetItems } from \"./widgetItems.ts\";\n\nexport async function wnbaItems(\n settings: { teams: string[]; intradayFilter: boolean },\n utcOffsetSeconds: number | null,\n catalog: Catalog,\n) {\n const teams = settings.teams.map((slug) => ({\n sport: \"wnba\", code: catalog.teams.find((team) => team.slug === slug)!.providerCode,\n }));\n const fromMs = dayStartMsAtOffset(clientOffsetSeconds(utcOffsetSeconds));\n const candidates = await nextGamesForTeams(teams, fromMs);\n const picked = pickNextPerTeam(candidates, teams, [\"wnba\"]);\n return widgetItems(picked?.bySport ?? [], catalog, settings.intradayFilter);\n}\n",[],[153,169],"a9f377fb-d0a5-4172-b81d-567d0ecc6c21","widgetItems.ts","01a08d56-91fd-7254-9bfc-c4ea5970ec13",["D",1789077675909],"// Stored rows → the widget's item shape. Every field here is a VIEW decision;\n// the client renders it blind. Pure: the clock arrives as an argument.\n\nimport type { Catalog } from \"./catalog.ts\";\nimport { teamLabel } from \"./catalog.ts\";\nimport { type ChannelInfo } from \"./channels.ts\";\nimport { flattenByStartTime, type EnrichedGame, type GamesBySport } from \"./games.ts\";\nimport { phase, type Item, type Phase, windowFrom } from \"https://esm.town/v/plusjade/source-sdk@12-main/mod.ts\";\n\n// WNBA is 4×10-minute quarters; with breaks, reviews and broadcast padding,\n// two hours is the wall-clock estimate. It is an ESTIMATE: this val has no\n// live ingest, so lifecycle is derived from the clock rather than from a\n// stored status that only moves when someone ingests. Narrow it if live\n// ingest lands.\nconst WNBA_TYPICAL_GAME_SECONDS = 2 * 60 * 60;\n\ntype Status = \"scheduled\" | \"live\" | \"final\";\n\nconst STATUS_MAP: Record = {\n scheduled: \"scheduled\",\n pre_game: \"scheduled\",\n postponed: \"scheduled\",\n delayed: \"scheduled\",\n in_game: \"live\",\n in_progress: \"live\",\n live: \"live\",\n halftime: \"live\",\n complete: \"final\",\n final: \"final\",\n closed: \"final\",\n};\n\nfunction normalizeStatus(raw: string | null): Status {\n return (raw && STATUS_MAP[raw]) || \"scheduled\";\n}\n\n// The protocol says `current`; this is where that becomes \"LIVE\". Phase is\n// state and belongs to the protocol, the wording belongs to this source.\n// `caption: null` is a protocol value telling the client to format `startsAt`\n// itself as a local start time.\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\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\nfunction widgetItem(game: EnrichedGame, catalog: Catalog, now: number): { item: Item; current: Phase } {\n const status = normalizeStatus(game.statusRaw);\n const away = teamLabel(game.sport, game.away, catalog) ?? game.away ?? \"\";\n const home = teamLabel(game.sport, game.home, catalog) ?? game.home ?? \"\";\n const emoji = catalog.competitions.find((competition) => competition.code === game.sport)?.emoji;\n // Unix epoch SECONDS on the wire; the stored start is milliseconds.\n const window = windowFrom(Math.floor(game.start_time / 1000), WNBA_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. The reverse does not hold — a stored `scheduled` on a\n // game whose start has passed is a stale ingest, which is exactly what the\n // window exists to route around.\n const current = status === \"final\" ? \"expired\" : phase(window, now);\n return {\n item: {\n id: game.id ?? `${game.sport}:${game.away}-${game.home}:${game.start_time}`,\n mainText: `${emoji ? `${emoji} ` : \"\"}${away} @ ${home}`,\n subText: channelText(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 above, not on caption text, so the filter agrees with what the\n// item says rather than with whenever the last ingest ran.\nexport function widgetItems(\n bySport: GamesBySport,\n catalog: Catalog,\n hideCompleted = false,\n now = Math.floor(Date.now() / 1000),\n): Item[] {\n const built = flattenByStartTime(bySport).map((game) => widgetItem(game, catalog, now));\n return (hideCompleted ? built.filter((b) => b.current !== \"expired\") : built).map((b) => b.item);\n}\n",[],[153,176],"6672c8d2-d519-42a6-80c9-16b70085adda","sleeperIngest.ts","01a08d56-91fd-7254-9bfc-c087b1702faf",["D",1789077656071],"\nimport { readCatalog } from \"./catalogStore.ts\";\nimport { saveCachedGames, type CachedGameRow } from \"./cachedGames.ts\";\nimport { addDays, todaySlateDate } from \"./dates.ts\";\nimport { teamCode, type Game } from \"./games.ts\";\nimport { fetchScores } from \"./sleeper.ts\";\n\nexport type IngestReport = {\n dates: string[];\n fetched: number;\n stored: number;\n skipped: number;\n bySport: Record;\n};\n\nexport function normalizeGame(game: Game): CachedGameRow | null {\n const gameId = game.game_id;\n const id = typeof gameId === \"string\" || typeof gameId === \"number\" ? String(gameId) : null;\n const startTimeMs = typeof game.start_time === \"number\" ? game.start_time : NaN;\n if (!id || game.sport !== \"wnba\" || !Number.isFinite(startTimeMs) || startTimeMs <= 0) return null;\n\n return {\n sport: game.sport,\n game_id: id,\n away_code: teamCode(game.metadata?.away_team),\n home_code: teamCode(game.metadata?.home_team),\n start_time_ms: startTimeMs,\n status: typeof game.status === \"string\" ? game.status : null,\n channel: game.metadata?.channel ?? null,\n };\n}\n\nexport async function ingestSleeperWindow(\n days = 7,\n now = new Date(),\n backfillDays = 1,\n): Promise {\n const start = addDays(todaySlateDate(now), -backfillDays);\n const dates = Array.from(\n { length: days + backfillDays + 1 },\n (_, i) => addDays(start, i),\n );\n\n const catalog = await readCatalog();\n const competitions = catalog.competitions.filter((competition) => competition.adapter === \"sleeper\");\n const codes = new Map(competitions.map((competition) => [competition.providerKey, competition.code]));\n const perDate = await Promise.all(\n codes.size > 0 ? dates.map((date) => fetchScores(date, [...codes.keys()])) : [],\n );\n\n const fetched = perDate.flat();\n const rows: CachedGameRow[] = [];\n let skipped = 0;\n for (const game of fetched) {\n const sport = codes.get(game.sport);\n const row = sport ? normalizeGame({ ...game, sport }) : null;\n if (row) rows.push(row);\n else skipped++;\n }\n\n const byKey = new Map();\n for (const row of rows) byKey.set(`${row.sport}:${row.game_id}`, row);\n const deduped = [...byKey.values()];\n\n const stored = await saveCachedGames(deduped);\n\n const bySport: Record = {};\n for (const row of deduped) bySport[row.sport] = (bySport[row.sport] ?? 0) + 1;\n\n return { dates, fetched: fetched.length, stored, skipped, bySport };\n}\n",[],[153,183],"8330992c-a394-4c66-b6a1-6dfc4055068a","sleeper.ts","01a08d56-91fd-7254-9bfc-bdf5c0460025",["D",1789077656071],"// Sleeper's outbound I/O. Everything else under lib/ is pure or SQLite,\n// which is what lets tests/ run the whole slate pipeline against captured\n// fixtures with no network — this file is the seam they stop at, and the\n// deployed endpoint is what covers it (see docs/HANDOFF.md).\n//\n// No longer on the request path. Until cached_games arrived this was called\n// live, once per date in the scan window, on every widget request; it is now\n// reached only from lib/sleeperIngest.ts. That is the whole point of the\n// move — a request answers from an index instead of from N third-party\n// round trips whose cost is what forced the window to be narrow.\n\nimport { type Game } from \"./games.ts\";\n\nexport async function fetchScores(date: string, sports: string[]): Promise {\n const url = new URL(\"https://api.sleeper.app/scores\");\n for (const sport of sports) url.searchParams.append(\"sports[]\", sport);\n url.searchParams.set(\"date\", date);\n\n const res = await fetch(url);\n if (!res.ok) throw new Error(`Sleeper /scores returned ${res.status}`);\n return (await res.json()) ?? [];\n}\n",[],[153,190],"843d43a7-e23c-45ba-8719-3c867eaca51f","games.ts","01a08d56-91fd-7254-9bfc-b8378260009f",["D",1789077656071],"\nimport { type TeamRef } from \"./catalog.ts\";\nimport { channelInfo, type ChannelInfo } from \"./channels.ts\";\n\nexport function teamCode(value: unknown): string | null {\n // Sleeper sends nested WNBA teams; cached rows already contain flat codes.\n const code = value && typeof value === \"object\" ? (value as { team?: unknown }).team : value;\n return typeof code === \"string\" ? code : null;\n}\n\nexport type Game = {\n sport: string;\n start_time: number;\n status?: unknown;\n game_id?: unknown;\n metadata: {\n away_team?: unknown;\n home_team?: unknown;\n channel?: string | null;\n };\n};\n\nexport type EnrichedGame = Game & {\n away: string | null;\n home: string | null;\n channel: ChannelInfo;\n id: string | null;\n statusRaw: string | null;\n};\n\nexport type GamesBySport = { sport: string; games: EnrichedGame[] }[];\n\nfunction enrichGames(games: Game[]): EnrichedGame[] {\n return (games ?? []).map((game) => ({\n ...game,\n away: teamCode(game.metadata?.away_team),\n home: teamCode(game.metadata?.home_team),\n channel: channelInfo(game.metadata?.channel),\n id: typeof game.game_id === \"string\" || typeof game.game_id === \"number\" ? String(game.game_id) : null,\n statusRaw: typeof game.status === \"string\" ? game.status : null,\n }));\n}\n\nfunction filterByTeams(enriched: EnrichedGame[], teams: TeamRef[]): EnrichedGame[] {\n if (!teams.length) return enriched;\n return enriched.filter((game) =>\n teams.some((t) => t.sport === game.sport && (game.away === t.code || game.home === t.code)),\n );\n}\n\nfunction groupBySport(enriched: EnrichedGame[], sports: string[]): GamesBySport {\n const bySport = Object.groupBy(enriched, (g) => g.sport) as Record;\n return sports\n .filter((sport) => bySport[sport]?.length)\n .map((sport) => ({ sport, games: bySport[sport].toSorted((a, b) => a.start_time - b.start_time) }));\n}\n\nexport function flattenByStartTime(bySport: GamesBySport): EnrichedGame[] {\n return bySport.flatMap((group) => group.games).toSorted((a, b) => a.start_time - b.start_time);\n}\n\nexport function pickNextPerTeam(\n candidates: Game[],\n teams: TeamRef[],\n sports: string[],\n): { earliestStartMs: number; bySport: GamesBySport } | null {\n if (!teams.length) return null;\n\n const enriched = enrichGames(candidates).toSorted((a, b) => a.start_time - b.start_time);\n\n const matched: EnrichedGame[] = [];\n for (const team of teams) {\n const next = enriched.find((game) => filterByTeams([game], [team]).length > 0);\n if (next) matched.push(next);\n }\n if (!matched.length) return null;\n\n const seen = new Set();\n const deduped = matched.filter((g) => {\n const key = g.id ?? `${g.sport}:${g.away}-${g.home}:${g.start_time}`;\n if (seen.has(key)) return false;\n seen.add(key);\n return true;\n });\n\n return {\n earliestStartMs: Math.min(...deduped.map((g) => g.start_time)),\n bySport: groupBySport(deduped, sports),\n };\n}\n",[],[153,197],"33b961ab-ea9f-4290-a3bf-3885409ee4fe","dates.ts","01a08d56-91fd-7254-9bfc-b710dd7f428a",["D",1789077656071],"// Pure date math for the sports slate. No formatting of games, no I/O —\n// every function here takes an explicit `now`, which is what lets tests pin\n// behaviour without freezing the clock.\n//\n// Two halves that must not be confused, which is why they never share a\n// function: Sleeper's ingest half speaks IANA zone names (DST needs a real\n// zone), and the client-facing half speaks offset seconds that already have\n// DST folded in by iOS.\n\n// Sleeper buckets /scores by Eastern day, not UTC. This is a server-side\n// fact about Sleeper, never client-supplied.\nconst SLEEPER_TIME_ZONE = \"America/New_York\";\n\n// The client's timezone when the parent has no offset to pass on. Resolved\n// to a live, DST-correct offset via offsetSecondsForZone rather than being\n// stored as a constant number of seconds, so it does not go stale twice a\n// year.\nconst DEFAULT_CLIENT_TIME_ZONE = \"America/Los_Angeles\";\n\n// Eastern's calendar date for `now` — the bucket Sleeper's /scores keys on.\n// Anchored off real UTC \"now\", not any app-local notion of \"today\". en-CA\n// gives YYYY-MM-DD directly, sorted the way ISO date math wants it.\n//\n// This is Sleeper's half of the pipeline, and it takes an IANA zone name;\n// the client's half is dateAtOffset below, which takes offset seconds. Kept\n// as separate functions on purpose so the two kinds of timezone value can't\n// be swapped for each other by mistake.\nexport function todaySlateDate(now = new Date()): string {\n return now.toLocaleDateString(\"en-CA\", { timeZone: SLEEPER_TIME_ZONE });\n}\n\nexport function addDays(isoDate: string, days: number): string {\n const [y, m, d] = isoDate.split(\"-\").map(Number);\n const date = new Date(Date.UTC(y, m - 1, d));\n date.setUTCDate(date.getUTCDate() + days);\n return date.toISOString().slice(0, 10);\n}\n\n// The calendar date `now` falls on at a fixed UTC offset — the client-offset\n// counterpart to todaySlateDate's IANA version. No DST table lookup, because\n// the offset it's given has already had DST folded into it (by the iOS\n// client, or by offsetSecondsForZone's live Intl lookup for the fallback\n// case), so adding seconds is all that's left to do.\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: UTC midnight\n// of the client's current calendar day.\n//\n// The bound is the day's START, not `now`, and that is deliberate — it is\n// what implements the \"keep showing a game for the rest of the day once it\n// ends\" assignment setting. A game that finished at noon stays a candidate\n// until the client's day rolls over, and `intradayFilter` is the opt-out.\n//\n// There is no `day=today|tomorrow|next` term any more. The source protocol\n// has no such parameter: every read means \"from the start of the client's\n// today\", which is what all three terms resolved to on this path anyway\n// (`tomorrow` was the only distinct offset, and nothing ever sent it).\nexport function dayStartMsAtOffset(offsetSeconds: number, now = new Date()): number {\n const localDate = dateAtOffset(offsetSeconds, now);\n return Date.parse(`${localDate}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\n// the fallback path stays DST-correct without this file carrying a DST table\n// of its own. \"longOffset\" is the Intl.DateTimeFormat mode that always\n// renders as \"GMT±HH:MM\", never a zone abbreviation, which is what makes it\n// parseable here.\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 const sign = match[1] === \"-\" ? -1 : 1;\n return sign * (Number(match[2]) * 3600 + Number(match[3]) * 60);\n}\n\n// The protocol's `context.utcOffsetSeconds`, resolved to a usable offset.\n// iOS sends TimeZone.current.secondsFromGMT(), an integer seconds-east-of-GMT\n// that already has DST folded in, so there is no DST table to consult on this\n// side — just range-check it.\n//\n// `null` means the parent had no client offset to forward, not \"UTC\": it\n// falls back to DEFAULT_CLIENT_TIME_ZONE's live offset. An out-of-range value\n// takes the same fallback rather than throwing — a failed source fails the\n// whole composition, which is worse than a slightly-off day boundary. The\n// range [-12:00, +14:00] is every real-world UTC offset (Baker Island to\n// Kiribati); the protocol's own guard is wider, so this is the narrower of\n// the two checks and the one that decides.\n//\n// One trade this accepts, deliberately not engineered around: a WidgetKit\n// timeline entry built before a DST transition and rendered after it still\n// carries the pre-transition offset until iOS refreshes the timeline. The\n// client owns DST now; this file no longer has the information to catch it.\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",[],[153,204],"89383dca-52d8-4484-9458-baaf0fe9757b","channels.ts","01a08d56-91fd-7254-9bfc-b05ec6971415",["D",1789077656071],"// 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",[],[153,211],"bd323f60-5544-4219-8249-1210dbbf5c87","catalogStore.ts","01a08d56-91fd-7254-9bfc-afc4c00b3ce9",["D",1789077656071],"// Canonical selection catalog in this val's SQLite. Read once at the I/O edge\n// and pass the snapshot through the pure pipeline; edits are visible next request.\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport type { Catalog, CatalogCompetition, CatalogTeam } from \"./catalog.ts\";\n\nexport async function readCatalog(): Promise {\n const [competitions, teams] = await sqlite.batch([\n { sql: `SELECT code, display_name AS displayName, adapter,\n provider_competition_key AS providerKey, emoji, coverage_note AS coverageNote\n FROM catalog_competitions WHERE code = 'wnba' ORDER BY display_order, code`, args: [] },\n { sql: `SELECT t.slug, t.competition_code AS competitionCode,\n t.display_name AS displayName, t.provider_team_code AS providerCode\n FROM catalog_teams t JOIN catalog_competitions c ON c.code = t.competition_code\n WHERE t.competition_code = 'wnba'\n ORDER BY c.display_order, c.code, t.display_order, t.slug`, args: [] },\n ], \"read\");\n return {\n competitions: competitions.rows as CatalogCompetition[],\n teams: teams.rows as CatalogTeam[],\n };\n}\n",[],[153,218],"9eb26e74-c233-4f7a-9348-bdd0967fb0f3","catalog.ts","01a08d56-91fd-7254-9bfc-a92193a437f2",["D",1789077656071],"\nexport type TeamRef = { sport: string; code: string };\n\nexport type CatalogCompetition = {\n code: string;\n displayName: string;\n adapter: \"sleeper\";\n providerKey: string;\n emoji: string;\n coverageNote: string;\n};\n\nexport type CatalogTeam = {\n slug: string;\n competitionCode: string;\n displayName: string;\n providerCode: string;\n};\n\nexport type Catalog = {\n competitions: CatalogCompetition[];\n teams: CatalogTeam[];\n};\n\nexport function teamLabel(sport: string, code: string | null, catalog: Catalog): string | null {\n if (!code) return code;\n return catalog.teams.find((team) =>\n team.competitionCode === sport && team.providerCode === code\n )?.displayName ?? code;\n}\n",[],[153,225],"0fdf8581-9de6-4c70-9ae3-b15d00e944ff","cachedGames.ts","01a08d56-91fd-7254-9bfc-a407cbca22dc",["D",1789077656071],"\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { type TeamRef } from \"./catalog.ts\";\nimport { type Game } from \"./games.ts\";\n\nexport type CachedGameRow = {\n sport: string;\n game_id: string;\n away_code: string | null;\n home_code: string | null;\n start_time_ms: number;\n status: string | null;\n channel: string | null;\n};\n\nfunction rowToGame(row: CachedGameRow): Game {\n return {\n sport: row.sport,\n start_time: Number(row.start_time_ms),\n status: row.status,\n game_id: row.game_id,\n metadata: {\n away_team: row.away_code,\n home_team: row.home_code,\n channel: row.channel,\n },\n };\n}\n\nconst SELECT_COLUMNS =\n \"sport, game_id, away_code, home_code, start_time_ms, status, channel\";\n\nexport async function nextGamesForTeams(teams: TeamRef[], fromMs: number): Promise {\n if (!teams.length) return [];\n\n const results = await sqlite.batch(\n teams.map((team) => ({\n sql: `SELECT ${SELECT_COLUMNS} FROM cached_games\n WHERE sport = ? AND (away_code = ? OR home_code = ?) AND start_time_ms >= ?\n ORDER BY start_time_ms ASC\n LIMIT 1`,\n args: [\"wnba\", team.code, team.code, fromMs],\n })),\n );\n\n return results.flatMap((result) => (result.rows as CachedGameRow[]).map(rowToGame));\n}\n\nexport async function saveCachedGames(rows: CachedGameRow[]): Promise {\n if (rows.some((row) => row.sport !== \"wnba\")) throw new Error(\"WNBA rows required\");\n if (!rows.length) return 0;\n\n const ingestedAt = new Date().toISOString();\n const CHUNK = 50;\n let written = 0;\n\n for (let i = 0; i < rows.length; i += CHUNK) {\n const chunk = rows.slice(i, i + CHUNK);\n await sqlite.batch(\n chunk.map((row) => ({\n sql: `INSERT INTO cached_games\n (sport, game_id, away_code, home_code, start_time_ms,\n status, channel, ingested_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)\n ON CONFLICT(sport, game_id) DO UPDATE SET\n away_code = excluded.away_code,\n home_code = excluded.home_code,\n start_time_ms = excluded.start_time_ms,\n status = excluded.status,\n channel = excluded.channel,\n ingested_at = excluded.ingested_at`,\n args: [\n row.sport, row.game_id, row.away_code, row.home_code, row.start_time_ms,\n row.status, row.channel, ingestedAt,\n ],\n })),\n );\n written += chunk.length;\n }\n\n return written;\n}\n\nexport async function cachedGamesCoverage(): Promise<\n { sport: string; games: number; firstStartMs: number; lastStartMs: number; ingestedAt: string }[]\n> {\n const result = await sqlite.execute(`\n SELECT sport,\n COUNT(*) AS games,\n MIN(start_time_ms) AS first_start_ms,\n MAX(start_time_ms) AS last_start_ms,\n MAX(ingested_at) AS ingested_at\n FROM cached_games\n WHERE sport = 'wnba'\n GROUP BY sport\n ORDER BY sport\n `);\n return (result.rows as {\n sport: string; games: number; first_start_ms: number;\n last_start_ms: number; ingested_at: string;\n }[]).map((row) => ({\n sport: row.sport,\n games: Number(row.games),\n firstStartMs: Number(row.first_start_ms),\n lastStartMs: Number(row.last_start_ms),\n ingestedAt: row.ingested_at,\n }));\n}\n",[],[153,232],["D",1788818616931],"legacyEnvVars","httpPrivacy","description","WNBA schedules and upcoming games","imageUrl","userId","b0a8da26-58e7-4d19-8b5c-eedf487df9a9","pinnedFileId","01a07de5-f2ca-7358-a270-26c8bacce23f","pinPreview","pinMigrated","screenshotVersion","likeCount","tursoName","c0bf06b04d3849ffaa5654d81db775bb","tursoHostname","c0bf06b04d3849ffaa5654d81db775bb-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789516253896],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_284":280},"org",{"_11":12,"_278":-5,"_279":280,"_244":245,"_281":282,"_283":54},"branch",{"_17":90,"_13":16,"_36":66,"_43":44,"_46":37,"_48":274,"_275":56,"_276":44,"_277":59,"_60":14,"_57":12},15,"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yVHpab25kTlBTM3M3WmpCa3NMSTd5akVwWksuanBlZyJ9","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":44,"_13":14,"_38":382,"_52":-5,"_239":54,"_55":56,"_240":56,"_241":242,"_243":-5,"_244":245,"_246":247,"_248":70,"_249":-5,"_250":-5,"_251":32,"_58":59,"_252":253,"_254":255,"_256":383,"_258":-5,"_259":260,"_261":260,"_262":263,"_264":263,"_265":263,"_266":260,"_267":260,"_268":384,"_270":385,"_272":386,"_53":54},[322,333,334,337,338,339,340,341],"files",[322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341],"counts",{"_313":32,"_314":68,"_315":32,"_35":316,"_317":318},[],{"_36":61,"_13":19,"_62":63,"_64":-5,"_65":66,"_67":68,"_69":70,"_38":71,"_17":34,"_72":73,"_74":75,"_76":54,"_77":-5,"_18":312},"upstreamProject",{"_36":308,"_13":309,"_241":310,"_243":-5,"_55":56,"_268":311},"upstreamBranch",{"_36":37,"_38":306,"_40":307,"_13":42,"_43":44,"_17":45,"_46":47,"_48":49,"_50":51,"_52":-5,"_53":54,"_55":56,"_57":12,"_58":59,"_60":14},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1788818616931],["D",1789502865626],"c6b65c42-8367-4edb-bb37-e9eb4a828295","source-cfb","College football schedules and upcoming games",{"_11":12,"_284":280},[19],"pulls","branches","forks",{"_319":90,"_321":32},"connections",{"_319":32,"_320":32},"count","unfilledCount","emptyCount",{"_36":152,"_13":153,"_62":154,"_64":-5,"_65":66,"_67":34,"_69":70,"_38":155,"_17":32,"_72":126,"_74":-5,"_76":54,"_77":-5,"_94":380,"_18":381},{"_36":231,"_13":232,"_62":233,"_64":154,"_65":66,"_67":34,"_69":70,"_38":234,"_17":32,"_72":92,"_74":235,"_76":54,"_77":-5,"_94":378,"_18":379},{"_36":224,"_13":225,"_62":226,"_64":154,"_65":66,"_67":34,"_69":70,"_38":227,"_17":32,"_72":92,"_74":228,"_76":54,"_77":-5,"_94":376,"_18":377},{"_36":217,"_13":218,"_62":219,"_64":154,"_65":66,"_67":34,"_69":70,"_38":220,"_17":32,"_72":92,"_74":221,"_76":54,"_77":-5,"_94":374,"_18":375},{"_36":210,"_13":211,"_62":212,"_64":154,"_65":66,"_67":34,"_69":70,"_38":213,"_17":32,"_72":92,"_74":214,"_76":54,"_77":-5,"_94":372,"_18":373},{"_36":203,"_13":204,"_62":205,"_64":154,"_65":66,"_67":34,"_69":70,"_38":206,"_17":32,"_72":92,"_74":207,"_76":54,"_77":-5,"_94":370,"_18":371},{"_36":196,"_13":197,"_62":198,"_64":154,"_65":66,"_67":34,"_69":70,"_38":199,"_17":32,"_72":92,"_74":200,"_76":54,"_77":-5,"_94":368,"_18":369},{"_36":189,"_13":190,"_62":191,"_64":154,"_65":66,"_67":34,"_69":70,"_38":192,"_17":32,"_72":92,"_74":193,"_76":54,"_77":-5,"_94":366,"_18":367},{"_36":182,"_13":183,"_62":184,"_64":154,"_65":66,"_67":34,"_69":70,"_38":185,"_17":32,"_72":92,"_74":186,"_76":54,"_77":-5,"_94":364,"_18":365},{"_36":175,"_13":176,"_62":177,"_64":154,"_65":66,"_67":49,"_69":70,"_38":178,"_17":34,"_72":92,"_74":179,"_76":54,"_77":-5,"_94":362,"_18":363},{"_36":168,"_13":169,"_62":170,"_64":154,"_65":66,"_67":34,"_69":70,"_38":171,"_17":32,"_72":92,"_74":172,"_76":54,"_77":-5,"_94":360,"_18":361},{"_36":146,"_13":147,"_62":148,"_64":-5,"_65":66,"_67":34,"_69":70,"_38":149,"_17":32,"_72":126,"_74":-5,"_76":54,"_77":-5,"_94":358,"_18":359},{"_36":122,"_13":123,"_62":124,"_64":-5,"_65":66,"_67":34,"_69":70,"_38":125,"_17":32,"_72":126,"_74":-5,"_76":54,"_77":-5,"_94":356,"_18":357},{"_36":139,"_13":140,"_62":141,"_64":124,"_65":66,"_67":34,"_69":70,"_38":142,"_17":32,"_72":92,"_74":143,"_76":54,"_77":-5,"_94":354,"_18":355},{"_36":131,"_13":132,"_62":133,"_64":124,"_65":66,"_67":134,"_69":70,"_38":135,"_17":49,"_72":92,"_74":136,"_76":54,"_77":-5,"_94":352,"_18":353},{"_36":115,"_13":116,"_62":117,"_64":-5,"_65":66,"_67":34,"_69":70,"_38":118,"_17":32,"_72":92,"_74":119,"_76":54,"_77":-5,"_94":350,"_18":351},{"_36":108,"_13":109,"_62":110,"_64":-5,"_65":66,"_67":34,"_69":70,"_38":111,"_17":32,"_72":92,"_74":112,"_76":54,"_77":-5,"_94":348,"_18":349},{"_36":100,"_13":101,"_62":102,"_64":-5,"_65":66,"_67":34,"_69":70,"_38":103,"_17":32,"_72":104,"_74":105,"_76":54,"_77":-5,"_94":346,"_18":347},{"_36":61,"_13":19,"_62":63,"_64":-5,"_65":66,"_67":68,"_69":70,"_38":97,"_17":34,"_72":73,"_74":75,"_76":54,"_77":-5,"_94":344,"_18":345},{"_36":87,"_13":88,"_62":89,"_64":-5,"_65":66,"_67":90,"_69":70,"_38":91,"_17":34,"_72":92,"_74":93,"_76":54,"_77":-5,"_94":342,"_18":343},[],[88],[],[19],[],[101],[],[109],[],[116],[],[123,132],[],[123,140],[335,336],[123],[],[147],[],[153,169],[],[153,176],[],[153,183],[],[153,190],[],[153,197],[],[153,204],[],[153,211],[],[153,218],[],[153,225],[],[153,232],[323,324,325,326,327,328,329,330,331,332],[153],["D",1788818616931],["D",1789516253896],{"_11":12,"_284":280},{"_11":12,"_278":-5,"_279":280,"_244":245,"_281":282,"_283":54},{"_17":90,"_13":16,"_36":66,"_43":44,"_46":37,"_48":274,"_275":56,"_276":44,"_277":59,"_60":14,"_57":12},"ctx",{"_268":-5,"_303":420,"_421":422,"_423":424,"_425":54,"_426":54,"_427":54,"_428":70,"_429":-5,"_430":-7,"_431":-7,"_432":32,"_433":54,"_434":54,"_435":-5,"_436":54,"_437":54,"_438":54,"_439":-5},"ENV",{"_391":392,"_393":394,"_395":42,"_396":397,"_398":399,"_400":401,"_402":403,"_404":405,"_406":407,"_408":409,"_410":411,"_412":413,"_414":415,"_416":417,"_418":419},"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"]