[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_331":332,"_333":334},"routes/_app.x.$handle.$name",{"_102":101,"_32":44,"_110":89,"_27":111,"_13":14,"_112":-5,"_11":113,"_114":115,"_116":117,"_118":119,"_120":121,"_20":-5,"_122":123,"_124":125,"_126":48,"_127":128,"_129":25,"_130":-5,"_131":-5,"_132":133},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_32":44,"_37":45,"_46":-5,"_47":48,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":48,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":48},"version",12,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":20,"_35":36,"_37":38,"_39":14,"_40":41,"_24":25},"previous",{"_30":31,"_32":33,"_34":20,"_35":36},"deleted",true,"deletedHere","path","sdk/settings-form.md","latestPath","fileId","01a07dd8-7b2c-778e-9b98-06a670f3c3af","name","settings-form.md","fileType","content","# Source settings form contract\n\nThe parent renders source settings from authenticated `GET /v1/descriptor?sourceKey=...`.\nIt checks protocol/source identity, `temporal:true`, and\n`capabilities.validateSettings:true`. The live schema is authoritative for the\nform; stored registry schema snapshots are not used for editing.\n\n## Supported JSON Schema subset\n\nThe root is `{type:\"object\",properties:{...},additionalProperties:false}`.\nAn optional `required` array names declared properties. Each property has a\n`title`, optional `description`, and one of these shapes:\n\n- Boolean: `{type:\"boolean\",title:\"Show alerts\",default:false}`.\n- Multiple choices: `{type:\"array\",title:\"Locations\",default:[],uniqueItems:true,\n items:{type:\"string\",oneOf:[{const:\"west\",title:\"West\",\"x-group\":\"Regions\"}]}}`.\n\n`x-group` is the only UI extension. Choice values are stable strings;\ntitles and optional groups are display text. Declaration order determines form\norder. Defaults apply when displaying a field with no saved value. Empty\n`properties` means no settings. Field names start with a letter and contain\nonly letters, digits, and underscores; prototype-related names are rejected.\n\nUnsupported property types or constraints fail closed, with no save form.\nThis is deliberately not a general JSON Schema renderer. No nested objects,\nfree text, numbers, conditional fields, pagination, or source-supplied HTML/JS.\nAll labels are escaped by React. Legacy descriptor `options` is not consumed:\nthe choice-to-property binding is inside `settingsSchema`.\n\nA source may provide a static schema or an async `settingsSchema()` function.\nSports builds choices from its catalog in one descriptor request. Moon publishes\nthe empty object schema. No source data tables need changing.\n\n## Saving\n\nThe form includes a fingerprint of the rendered fields. The parent reloads the\ndescriptor on POST and rejects a changed fingerprint with 409; it does not\nsilently interpret an old form against new controls or choices.\n\nThe parent decodes only declared fields. Unchecked booleans become false and\nunselected arrays become []; defaults do not override an intentional clearing.\nUnknown fields, duplicate values, and unavailable choices are rejected.\nPreviously saved choices that disappear remain visible as checked unavailable\nvalues, requiring explicit removal.\n\nBefore persisting, the parent sends\n`POST /v1/validate-settings` with\n`{protocolVersion:1,sourceKey,settings}`.\nThe SDK invokes the same `parseSettings` used by reads and returns only\n`{protocolVersion:1,sourceKey,ok:true}`. It does not call `read`, perform writes,\nor expose parsed internal context. Implementers must keep `parseSettings`\nfree of mutation. Validation remains source-authoritative on every feed read,\nsince data/choices may change after a settings save.\n\nSource validation errors retain their stable error code. Unavailability returns\n502, invalid settings 422, and stale forms 409. None changes the assignment.\nSuccessful saves persist the original wire settings, then use the existing\ndevice notification path.\n\n## Scope and remaining coupling\n\nDevice settings routes and rendering have no source-kind dispatch, field-name\nknowledge, or sports catalog import. Another source supporting this profile\nneeds only a registered pointer and its descriptor/validation/read implementation.\n\nPrototype starter-feed defaults and operator ingestion/catalog/coverage adapters\nstill refer to Sports/Moon instance IDs. Removing those is separate from settings\nforms. Immutable releases, descriptor caching, schema migrations, and agent ACLs\nremain deferred.\n","createdAt",["D",1789071548696],"branchVersion","branchId","72e0d709-5cf3-4bb8-91f0-b616d4c49f98","id","c6b65c42-8367-4edb-bb37-e9eb4a828295","source-cfb",["D",1788817734356],"deletedAt","legacyEnvVars",false,"privacy","public","httpPrivacy","description","College football schedules and upcoming games","imageUrl","b0a8da26-58e7-4d19-8b5c-eedf487df9a9","pinnedFileId","01a07dd8-7b2c-778e-9b98-1f67aa94b955","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","5a10edca-919b-4a78-babb-71908f69af93","tursoName","c6b65c4283674edbbb37e9eb4a828295","tursoHostname","c6b65c4283674edbbb37e9eb4a828295-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789516253896],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_102":101,"_109":105},"org",{"_102":101,"_103":-5,"_104":105,"_18":55,"_106":107,"_108":48},"branch",{"_13":88,"_32":89,"_42":41,"_90":43,"_91":92,"_93":94,"_95":50,"_96":97,"_98":64,"_99":44,"_100":101},"isOwned",15,"main","projectId","forkedBranchId","61c73600-56ab-40cd-815a-59f4fefa923a","forkedBranchVersion",2,"forkedProjectPrivacy","forkedProjectId","244bcafd-364b-4df7-8955-55f2c3f7da2c","forkedProjectOrgId","projectName","userHandle","plusjade","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yVHpab25kTlBTM3M3WmpCa3NMSTd5akVwWksuanBlZyJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_32":44,"_37":326,"_46":-5,"_47":48,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":48,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":327,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":328,"_83":329,"_85":330,"_87":48},"tree",[208,219,220,222,223,224,225],"files",[208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225],"counts",{"_198":62,"_199":153,"_200":179,"_201":202,"_203":204},"contents",[143,144,145,146,147,148,149],"upstreamProject",{"_42":97,"_32":140,"_52":141,"_54":-5,"_49":50,"_81":142},"upstreamBranch",{"_42":92,"_37":134,"_135":136,"_32":89,"_90":97,"_13":137,"_91":-5,"_93":-5,"_138":139,"_46":-5,"_87":48,"_49":50,"_100":101,"_63":64,"_99":140},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1788814020921],"updatedAt",["D",1789502858592],18,"lockfileKey","1789502858692-esm.town_v_plusjade_source-nfl@18-main","source-nfl","NFL schedules and widget items via the source SDK",{"_102":101,"_109":105},{"_42":193,"_32":194,"_30":195,"_152":-5,"_40":41,"_39":179,"_154":25,"_37":196,"_13":62,"_34":186,"_35":-5,"_24":48,"_159":-5,"_27":197},{"_42":188,"_32":189,"_30":190,"_152":-5,"_40":41,"_39":179,"_154":48,"_37":191,"_13":62,"_34":186,"_35":-5,"_24":48,"_159":-5,"_27":192},{"_42":182,"_32":183,"_30":184,"_152":-5,"_40":41,"_39":179,"_154":25,"_37":185,"_13":62,"_34":186,"_35":-5,"_24":48,"_159":-5,"_27":187},{"_42":174,"_32":175,"_30":176,"_152":-5,"_40":41,"_39":177,"_154":48,"_37":178,"_13":179,"_34":165,"_35":180,"_24":48,"_159":-5,"_27":181},{"_42":168,"_32":169,"_30":170,"_152":-5,"_40":41,"_39":156,"_154":25,"_37":171,"_13":62,"_34":165,"_35":172,"_24":48,"_159":-5,"_27":173},{"_42":161,"_32":162,"_30":163,"_152":-5,"_40":41,"_39":156,"_154":25,"_37":164,"_13":62,"_34":165,"_35":166,"_24":48,"_159":-5,"_27":167},{"_42":150,"_32":151,"_30":57,"_152":-5,"_40":41,"_39":153,"_154":48,"_37":155,"_13":156,"_34":157,"_35":158,"_24":48,"_159":-5,"_27":160},"f0e32e5e-52d8-44d7-9d0c-b7c6bf290427","rpc.ts","parentId",5,"latest",["D",1789071537081],3,"http","// Authenticated CFB source protocol and cache coverage diagnostics.\nimport { diagnostics } from \"./diagnostics.ts\";\nimport { serveSource } from \"https://esm.town/v/plusjade/source-sdk@3-main/mod.ts\";\nimport cfbSource from \"./cfbSource.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_CFB_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(cfbSource,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","label",[151],"077c018a-0d16-40b3-b0b3-78a3c7a0a30b","diagnostics.ts","5ebc9c9c-ac07-11f1-aab4-1607ee4eb77e",["D",1788928307921],"script","// 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 = 'cfb'`);\n const row = result.rows[0];\n return {\n diagnosticsVersion: 1, sourceKey: \"cfb\", 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",[162],"9ac0fd45-b975-4ea7-846a-10451564e295","diagnostics-check.ts","5ebc6cd6-ac07-11f1-aab4-1607ee4eb77e",["D",1788928307921],"// Read-only verification of the diagnostics mount and existing descriptor.\nimport handler from \"./rpc.ts\";\nconst headers = { authorization: `Bearer ${Deno.env.get(\"SOURCE_CFB_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 === \"cfb\" && 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=cfb\", { 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",[169],"f029432c-64cc-4cbc-a369-f1c73e445d62","cfbSource.ts","60a46672-ab06-11f1-99e0-1607ee4eb77e",4,["D",1789071535606],1,"// CFB settings and operations exported through the shared source SDK.\nimport { readCatalog } from \"./lib/catalogStore.ts\";\nimport { cfbItems } from \"./lib/cfbFeed.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@3-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 CFBRead = {\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: \"cfb\",\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 cfbItems({ 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",[175],"2dcad24f-52ca-4c05-b461-9ff3ebd5fb86","tools","01a07dd8-7b2c-778e-9b98-1723a51ff5df",["D",1788817734356],"directory",[183],"12c2d099-9721-41e3-8efc-44cc50a8f065","sdk","01a07dd8-7b2c-778e-9b98-080b115e70d3",["D",1788817734356],[189],"e392d311-9475-4c74-84a4-4001333e9c98","lib","01a07dd8-7b2c-778e-9b97-f1b74dc4a5c0",["D",1788817734356],[194],"pulls","branches","forks","envVars",{"_205":153,"_207":62},"connections",{"_205":62,"_206":62},"count","unfilledCount","emptyCount",{"_42":193,"_32":194,"_30":195,"_152":-5,"_40":41,"_39":179,"_154":25,"_37":323,"_13":62,"_34":186,"_35":-5,"_24":48,"_159":-5,"_227":324,"_27":325},{"_42":316,"_32":317,"_30":318,"_152":195,"_40":41,"_39":94,"_154":25,"_37":319,"_13":179,"_34":165,"_35":320,"_24":48,"_159":-5,"_227":321,"_27":322},{"_42":309,"_32":310,"_30":311,"_152":195,"_40":41,"_39":179,"_154":25,"_37":312,"_13":62,"_34":165,"_35":313,"_24":48,"_159":-5,"_227":314,"_27":315},{"_42":302,"_32":303,"_30":304,"_152":195,"_40":41,"_39":94,"_154":25,"_37":305,"_13":179,"_34":165,"_35":306,"_24":48,"_159":-5,"_227":307,"_27":308},{"_42":295,"_32":296,"_30":297,"_152":195,"_40":41,"_39":94,"_154":48,"_37":298,"_13":62,"_34":165,"_35":299,"_24":48,"_159":-5,"_227":300,"_27":301},{"_42":288,"_32":289,"_30":290,"_152":195,"_40":41,"_39":179,"_154":25,"_37":291,"_13":62,"_34":165,"_35":292,"_24":48,"_159":-5,"_227":293,"_27":294},{"_42":281,"_32":282,"_30":283,"_152":195,"_40":41,"_39":179,"_154":48,"_37":284,"_13":62,"_34":165,"_35":285,"_24":48,"_159":-5,"_227":286,"_27":287},{"_42":274,"_32":275,"_30":276,"_152":195,"_40":41,"_39":179,"_154":48,"_37":277,"_13":62,"_34":165,"_35":278,"_24":48,"_159":-5,"_227":279,"_27":280},{"_42":267,"_32":268,"_30":269,"_152":195,"_40":41,"_39":179,"_154":25,"_37":270,"_13":62,"_34":165,"_35":271,"_24":48,"_159":-5,"_227":272,"_27":273},{"_42":260,"_32":261,"_30":262,"_152":195,"_40":41,"_39":94,"_154":25,"_37":263,"_13":179,"_34":165,"_35":264,"_24":48,"_159":-5,"_227":265,"_27":266},{"_42":253,"_32":254,"_30":255,"_152":195,"_40":41,"_39":179,"_154":48,"_37":256,"_13":62,"_34":165,"_35":257,"_24":48,"_159":-5,"_227":258,"_27":259},{"_42":188,"_32":189,"_30":190,"_152":-5,"_40":41,"_39":179,"_154":48,"_37":250,"_13":62,"_34":186,"_35":-5,"_24":48,"_159":-5,"_227":251,"_27":252},{"_42":182,"_32":183,"_30":184,"_152":-5,"_40":41,"_39":179,"_154":25,"_37":247,"_13":62,"_34":186,"_35":-5,"_24":48,"_159":-5,"_227":248,"_27":249},{"_42":239,"_32":240,"_30":241,"_152":184,"_40":41,"_39":242,"_154":48,"_37":243,"_13":94,"_34":165,"_35":244,"_24":48,"_159":-5,"_227":245,"_27":246},{"_42":174,"_32":175,"_30":176,"_152":-5,"_40":41,"_39":177,"_154":48,"_37":236,"_13":179,"_34":165,"_35":180,"_24":48,"_159":-5,"_227":237,"_27":238},{"_42":168,"_32":169,"_30":170,"_152":-5,"_40":41,"_39":156,"_154":25,"_37":233,"_13":62,"_34":165,"_35":172,"_24":48,"_159":-5,"_227":234,"_27":235},{"_42":161,"_32":162,"_30":163,"_152":-5,"_40":41,"_39":156,"_154":25,"_37":230,"_13":62,"_34":165,"_35":166,"_24":48,"_159":-5,"_227":231,"_27":232},{"_42":150,"_32":151,"_30":57,"_152":-5,"_40":41,"_39":153,"_154":48,"_37":226,"_13":156,"_34":157,"_35":158,"_24":48,"_159":-5,"_227":228,"_27":229},["D",1789071537081],"children",[],[151],["D",1788928307921],[],[162],["D",1788928307921],[],[169],["D",1789071535606],[],[175],"36a8bf90-f67f-4da8-8111-dbfdcce91e33","source-contract-check.ts","01a07dd8-7b2c-778e-9b98-10f85aae0a99",6,["D",1789071538711],"// CFB contract and deterministic selection checks. No production writes.\nimport handler from \"../rpc.ts\";\nimport { items } from \"https://esm.town/v/plusjade/source-sdk@3-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_CFB_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:\"cfb\",settings:{teams:[\"trojans\"],intradayFilter:false},context:{utcOffsetSeconds:0}};\ncheck((await call(\"/v1/descriptor\",undefined,false)).status===401,\"auth\");\nconst d=(await call(\"/v1/descriptor?sourceKey=cfb\")).body;\ncheck(d.sourceKey===\"cfb\"&&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===2,\"2 choices\");\ncheck(s.properties.teams.items.oneOf.every((x:any)=>typeof x.const===\"string\"&&typeof x.title===\"string\"&&x[\"x-group\"]===\"CFB\"),\"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:[\"trojans\",\"trojans\"]},{teams:[],unexpected:true},{teams:[],intradayFilter:\"true\"},{teams:\"trojans\"}]){\n check((await call(\"/v1/validate-settings\",{...base,settings})).body.error===\"invalid_settings\",\"invalid settings\");\n}\nfor(const slug of [\"fever\",\"united-states\",\"rams\",\"missing\"]){\n check((await call(\"/v1/read\",{...base,settings:{teams:[slug]}})).body.error===\"unknown_team\",\"non CFB \"+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:\"cfb\",game_id:\"fixture\",start_time:1788739200000,status:\"final\",metadata:{away_team:\"USC\",home_team:\"UCLA\",channel:\"NBC\"}};\nconst picked=pickNextPerTeam([game],[{sport:\"cfb\",code:\"USC\"},{sport:\"cfb\",code:\"UCLA\"}],[\"cfb\"])!;\nconst built=widgetItems(picked.bySport,catalog);\ncheck(built.length===1&&built[0].timestamp===1788739200&&built[0].mainText===\"🏈 Trojans @ Bruins\",\"union and seconds\");\ncheck(built[0].caption===\"END\"&&!built[0].emphasized&&widgetItems(picked.bySport,catalog,true).length===0,\"final filter\");\ncheck(normalizeGame({...game,sport:\"nfl\"})===null,\"ingest league guard\");\ncheck(normalizeGame(game)?.away_code===\"USC\",\"flat CFB shape\");\ncheck(dayStartMsAtOffset(50400,new Date(\"2026-09-07T20:00:00Z\"))===Date.parse(\"2026-09-07T10:00:00Z\"),\"UTC+14 boundary\");\nconsole.log(\"PASS: \"+checks+\" CFB assertions\");\n",[],[183,240],["D",1788817734356],[221],[183],["D",1788817734356],[],[189],"225097aa-409f-49fa-9b9d-d778ac10e026","widgetItems.ts","01a07dd8-7b2c-778e-9b97-ed4ed1d39d39",["D",1788817734356],"\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 type { Item } from \"../sdk/contract.ts\";\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\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\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): { item: Item; status: Status } {\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 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(status),\n timestamp: Math.floor(game.start_time / 1000),\n },\n status,\n };\n}\n\nexport function widgetItems(\n bySport: GamesBySport,\n catalog: Catalog,\n hideCompleted = false,\n): Item[] {\n const built = flattenByStartTime(bySport).map((game) => widgetItem(game, catalog));\n return (hideCompleted ? built.filter((b) => b.status !== \"final\") : built).map((b) => b.item);\n}\n",[],[194,254],"8bba5b36-8b41-47cb-b45f-93635b93acf4","sleeperIngest.ts","01a07dd8-7b2c-778e-9b97-ea21cc5e211a",["D",1788817930423],"\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 !== \"cfb\" || !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",[],[194,261],"d9d4c147-9169-4802-b0a2-72c68964a5b7","sleeper.ts","01a07dd8-7b2c-778e-9b97-e65c4b75aecd",["D",1788817734356],"// 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",[],[194,268],"a7a11791-8910-4d84-b8c8-11e5a30efdf0","games.ts","01a07dd8-7b2c-778e-9b97-dfe52ccdeff5",["D",1788817734356],"\nimport { type TeamRef } from \"./catalog.ts\";\nimport { channelInfo, type ChannelInfo } from \"./channels.ts\";\n\nexport function teamCode(value: unknown): string | null {\n return typeof value === \"string\" ? value : 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",[],[194,275],"535a0f09-6154-41ad-99fe-594a70479a61","dates.ts","01a07dd8-7b2c-778e-9b97-d865386d85ee",["D",1788817734356],"// 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",[],[194,282],"9a1c43e2-a9fe-4d53-9b86-d57495ef6752","channels.ts","01a07dd8-7b2c-778e-9b97-d5e18ae4578a",["D",1788817734356],"// 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",[],[194,289],"5e603d28-a999-4070-9099-a2b62e313238","cfbFeed.ts","60a49fb6-ab06-11f1-99e0-1607ee4eb77e",["D",1788817930423],"// Each selected CFB 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 cfbItems(\n settings: { teams: string[]; intradayFilter: boolean },\n utcOffsetSeconds: number | null,\n catalog: Catalog,\n) {\n const teams = settings.teams.map((slug) => ({\n sport: \"cfb\", 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, [\"cfb\"]);\n return widgetItems(picked?.bySport ?? [], catalog, settings.intradayFilter);\n}\n",[],[194,296],"58402d79-ec1e-4fed-b290-e4f85aefcd66","catalogStore.ts","01a07dd8-7b2c-778e-9b97-d3794fcbbfeb",["D",1788817930423],"// 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 = 'cfb' 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 = 'cfb'\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",[],[194,303],"fd83157f-f9f2-4734-a613-f502db9ab784","catalog.ts","01a07dd8-7b2c-778e-9b97-cff37e934fae",["D",1788817734356],"\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",[],[194,310],"8d2edec3-5bb1-42f0-9159-bafe0bbd2b56","cachedGames.ts","01a07dd8-7b2c-778e-9b97-c942b85ed0c3",["D",1788817930423],"\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: [\"cfb\", 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 !== \"cfb\")) throw new Error(\"CFB 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 = 'cfb'\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",[],[194,317],["D",1788817734356],[209,210,211,212,213,214,215,216,217,218],[194],["D",1788817734356],["D",1789516253896],{"_102":101,"_109":105},{"_102":101,"_103":-5,"_104":105,"_18":55,"_106":107,"_108":48},{"_13":88,"_32":89,"_42":41,"_90":43,"_91":92,"_93":94,"_95":50,"_96":97,"_98":64,"_99":44,"_100":101},"ctx",{"_81":-5,"_131":364,"_365":366,"_367":368,"_369":48,"_370":48,"_371":48,"_372":25,"_373":-5,"_374":-7,"_375":-7,"_376":62,"_377":48,"_378":48,"_379":-5,"_380":48,"_381":48,"_382":48,"_383":-5},"ENV",{"_335":336,"_337":338,"_339":89,"_340":341,"_342":343,"_344":345,"_346":347,"_348":349,"_350":351,"_352":353,"_354":355,"_356":357,"_358":359,"_360":361,"_362":363},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v12