[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_173":174,"_175":176},"routes/_app.x.$handle.$name",{"_104":103,"_37":49,"_113":94,"_32":114,"_13":14,"_115":-5,"_11":116,"_117":118,"_119":120,"_121":122,"_123":124,"_26":-5,"_125":-5,"_126":-5,"_127":30,"_128":129,"_130":63,"_131":-5,"_132":-5,"_133":134},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_47":48,"_37":49,"_42":50,"_51":-5,"_52":30,"_53":54,"_55":54,"_56":57,"_58":-5,"_19":59,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":75,"_76":-5,"_77":78,"_79":78,"_80":81,"_82":81,"_83":81,"_84":78,"_85":78,"_86":87,"_88":89,"_90":91,"_92":30},"version",2,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","65ce54ff-44e7-4a9b-84ce-037f1decb329","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":33,"_38":39,"_40":41,"_42":43,"_44":14,"_45":46,"_29":30},"previous","deleted",false,"deletedHere","path","lab.ts","latestPath","fileId","30c7c606-aa20-11f1-9651-1607ee4eb77e","name","fileType","http","content","/**\n * Black Hat Hydrology Lab — automated San Juan River seasonal prediction tracker.\n *\n * Automatic lifecycle, year after year:\n * 1. A new season opens on October 1 (\"2025-26\", \"2026-27\", ...).\n * 2. Each prediction is locked on a fixed issue date — once locked it is\n * immutable (inputs + model version preserved, cannot be overwritten).\n * 3. When the season provides the answer, the result is scored and stored\n * alongside the original forecast.\n * 4. The previous (now-finished) season remains available as the \"film room.\"\n * 5. The public page serves all records read-only.\n */\nimport { Database } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// Project-scoped persistent SQLite store.\nexport const db = new Database(\"/blackhat.sqlite\");\ninit();\n\nfunction init() {\n db.exec(`\n CREATE TABLE IF NOT EXISTS predictions (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n season TEXT NOT NULL,\n issue_date TEXT NOT NULL,\n locked INTEGER NOT NULL DEFAULT 0,\n forecast TEXT NOT NULL, -- JSON: { headline, inputs, model_version }\n result TEXT, -- JSON: actual observation\n score REAL,\n created_at TEXT NOT NULL,\n scored_at TEXT\n );\n CREATE INDEX IF NOT EXISTS idx_season ON predictions (season);\n `);\n}\n\n// ---- Helpers ---------------------------------------------------------------\n\n/** Season slug from a date: Oct 2025 -> \"2025-26\" (seasons start Oct 1, UTC). */\nfunction seasonSlug(date = new Date()): string {\n const y = date.getUTCFullYear();\n return date.getUTCMonth() >= 9 ? `${y}-${(y + 1) % 100}` : `${y - 1}-${y % 100}`;\n}\n\n/** Season currently in effect today. Oct 1 rolls this over automatically. */\nfunction currentSeason(): string {\n return seasonSlug(new Date());\n}\n\n/** Lock a prediction on its fixed issue date. Refuses to overwrite once locked. */\nexport function lockPrediction(p: {\n issueDate: string; // ISO date (UTC) the prediction is issued on\n headline: string;\n inputs: object;\n modelVersion: string;\n}): { ok: boolean; id?: number; error?: string } {\n const season = seasonSlug(new Date(p.issueDate));\n const existing = db\n .query(\"SELECT id, locked FROM predictions WHERE season = ? AND issue_date = ?\", [\n season,\n p.issueDate,\n ])\n .next();\n if (existing && existing[1] === 1) {\n return { ok: false, id: Number(existing[0]), error: \"Prediction already locked — immutable.\" };\n }\n const forecast = JSON.stringify({\n headline: p.headline,\n inputs: p.inputs,\n model_version: p.modelVersion,\n });\n if (existing) {\n db.exec(\"UPDATE predictions SET forecast = ?, locked = 1 WHERE id = ?\", [\n forecast,\n Number(existing[0]),\n ]);\n return { ok: true, id: Number(existing[0]) };\n }\n const id = db.exec(\n \"INSERT INTO predictions (season, issue_date, locked, forecast, created_at) VALUES (?, ?, 1, ?, ?)\",\n [season, p.issueDate, forecast, new Date(p.issueDate).toISOString()],\n );\n return { ok: true, id: Number(id) };\n}\n\n/** Score a locked prediction once the season provides the answer. */\nexport function scorePrediction(\n issueDate: string,\n actual: object,\n score: number,\n): { ok: boolean; id?: number; error?: string } {\n const existing = db\n .query(\"SELECT id, locked FROM predictions WHERE season = ? AND issue_date = ?\", [\n seasonSlug(new Date(issueDate)),\n issueDate,\n ])\n .next();\n if (!existing) return { ok: false, error: \"Prediction not found.\" };\n if (existing[1] !== 1) return { ok: false, error: \"Prediction is not locked.\" };\n const id = Number(existing[0]);\n db.exec(\"UPDATE predictions SET result = ?, score = ?, scored_at = ? WHERE id = ?\", [\n JSON.stringify(actual),\n score,\n new Date().toISOString(),\n id,\n ]);\n return { ok: true, id };\n}\n\n/** All records (newest last) with JSON fields parsed. */\nfunction allPredictions() {\n return [...db.query(\"SELECT * FROM predictions ORDER BY issue_date\")].map((r) => ({\n id: r[0],\n season: r[1],\n issue_date: r[2],\n locked: r[3],\n forecast: JSON.parse(r[4] as string),\n result: r[5] ? JSON.parse(r[5] as string) : null,\n score: r[6],\n created_at: r[7],\n scored_at: r[8],\n }));\n}\n\n// ---- HTTP ------------------------------------------------------------------\n\nfunction layout(body: string): string {\n return `\n\nBlack Hat Hydrology Lab\n${body}`;\n}\n\nexport default async function handler(req: Request): Promise {\n const url = new URL(req.url);\n\n // ---- Admin POST endpoints (write-only; guarded by secret when set) -------\n if (req.method === \"POST\" && url.pathname === \"/api/predict\") {\n if (!authorized(req)) return new Response(\"Unauthorized\", { status: 401 });\n const out = lockPrediction(await req.json());\n return jsonResponse(out, out.ok ? 201 : 400);\n }\n if (req.method === \"POST\" && url.pathname === \"/api/score\") {\n if (!authorized(req)) return new Response(\"Unauthorized\", { status: 401 });\n const { issue_date, actual, score } = await req.json();\n const out = scorePrediction(issue_date, actual, score);\n return jsonResponse(out, out.ok ? 200 : 400);\n }\n\n // ---- Public read-only JSON feed ----\n if (url.pathname === \"/data\") {\n return jsonResponse({ current_season: currentSeason(), records: allPredictions() });\n }\n\n // ---- Public read-only page ----\n const current = currentSeason();\n const bySeason = new Map>>();\n for (const r of allPredictions()) {\n const list = bySeason.get(r.season as string) ?? [];\n list.push(r);\n bySeason.set(r.season as string, list);\n }\n\n let body = `

🖤 Black Hat Hydrology Lab

San Juan River forecast experiment · Current season ${current} ·\nraw JSON

`;\n\n // Film room first: all completed seasons, most recent first.\n const completed = [...bySeason.keys()].filter((s) => s !== current).sort().reverse();\n for (const season of completed) {\n body +=\n `

Film room — ${season}

${seasonTable(bySeason.get(season)!, season)}

`;\n }\n // Current / active season last.\n body +=\n `

Current season — ${current}

${seasonTable(bySeason.get(current) ?? [], current)}

`;\n\n return new Response(layout(body), {\n headers: { \"content-type\": \"text/html; charset=utf-8\" },\n });\n}\n\nfunction seasonTable(recs: Array>, season: string): string {\n if (!recs.length) return `

No predictions locked yet for ${season}.

`;\n const rows = recs\n .map((r) => {\n const f = r.forecast as { headline: string; model_version: string };\n const s = r.score == null\n ? \"—\"\n : `= 0 ? \"win\" : \"loss\"}\">${r.score}`;\n return `${r.issue_date}${f.headline}${f.model_version}${s}`;\n })\n .join(\"\");\n return `${rows}

Issue	Forecast	Model	Score

`;\n}\n\nfunction authorized(req: Request): boolean {\n const secret = Deno.env.get(\"BH_LAB_SECRET\");\n if (!secret) return true; // no secret set → allow while building\n return req.headers.get(\"x-lab-secret\") === secret;\n}\n\nfunction jsonResponse(data: unknown, status = 200): Response {\n return new Response(JSON.stringify(data, null, 2), {\n status,\n headers: { \"content-type\": \"application/json\" },\n });\n}\n","createdAt",["D",1788719065897],"branchVersion","branchId","70817041-1dfa-4778-885e-ac83be02b1d0","id","f84d0eeb-ceea-4772-8eb3-fa7a8cedbc13","black-hat-hydrology",["D",1788718960405],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","San Juan River seasonal prediction tracker","imageUrl","66be13f3-dd08-4f8a-aca1-8697006c9a46","pinnedFileId","0210c8ee-aa20-11f1-a516-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a077f2-9ad7-764c-8f6b-583a36c43414","tursoName","f84d0eebceea47728eb3fa7a8cedbc13","tursoHostname","f84d0eebceea47728eb3fa7a8cedbc13-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789488693443],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_104":103,"_112":108},"org",{"_104":103,"_105":106,"_107":108,"_19":59,"_109":110,"_111":30},"branch",{"_13":93,"_37":94,"_47":46,"_95":48,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":49,"_102":103},"isOwned",268,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","pagosaoutside","handle","displayName","Pagosa Outside","avatar","https://lh3.googleusercontent.com/a/ACg8ocLkPUw3N28PFDWb5so2_Azzb6wOyGiti-gB56AMhHTn6R7IXJA6Ug=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_47":48,"_37":49,"_42":168,"_51":-5,"_52":30,"_53":54,"_55":54,"_56":57,"_58":-5,"_19":59,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":169,"_76":-5,"_77":78,"_79":78,"_80":81,"_82":81,"_83":81,"_84":78,"_85":78,"_86":170,"_88":171,"_90":172,"_92":30},"tree",[159,160],"files",[159,160],"counts",{"_149":67,"_150":140,"_151":67,"_152":153,"_154":155},"contents",[135,136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_47":146,"_37":33,"_35":36,"_139":-5,"_45":46,"_44":14,"_141":63,"_42":147,"_13":67,"_38":39,"_40":41,"_29":30,"_144":-5,"_32":148},{"_47":137,"_37":138,"_35":61,"_139":-5,"_45":46,"_44":140,"_141":30,"_42":142,"_13":67,"_38":39,"_40":143,"_29":30,"_144":-5,"_32":145},"a22d96e8-0685-4b83-beee-f2d72e16d9bc","main.ts","parentId",1,"latest",["D",1788718987538],"/**\n * Black Hat Hydrology Lab — automated San Juan River seasonal prediction tracker.\n *\n * What this does, automatically, year after year:\n * 1. On October 1 it starts a new season (\"2025-26\", \"2026-27\", ...).\n * 2. Each seasonal prediction is locked on its fixed issue date — once locked\n * it is immutable (inputs + model version preserved forever).\n * 3. When the season provides the answer, a prediction can be scored; the\n * record keeps both the forecast and the actual result.\n * 4. The previous (now-finished) season stays available as the \"film room.\"\n * 5. The public page serves all records read-only.\n */\nimport { Database } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport const db = new Database(\"/blackhat.sqlite\");\ninit(db);\n\n// ---- Storage ---------------------------------------------------------------\n\nfunction init(db: Database) {\n db.exec(`\n CREATE TABLE IF NOT EXISTS predictions (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n season TEXT NOT NULL,\n issue_date TEXT NOT NULL,\n locked INTEGER NOT NULL DEFAULT 0,\n forecast TEXT NOT NULL, -- JSON: { inputs, model_version, headline }\n result TEXT, -- JSON: { actual, observation }\n score REAL,\n created_at TEXT NOT NULL,\n scored_at TEXT\n );\n CREATE INDEX IF NOT EXISTS idx_season ON predictions (season);\n `);\n}\n\n/** Season slug from a date: Oct 2025 -> \"2025-26\" (seasons start Oct 1, UTC). */\nfunction seasonSlug(date = new Date()): string {\n const y = date.getUTCFullYear();\n return date.getUTCMonth() >= 9 ? `${y}-${(y + 1) % 100}` : `${y - 1}-${y % 100}`;\n}\n\n/** If today is Oct 1 or later in a new season, log a fresh season marker. */\nfunction openCurrentSeason(now = new Date()): string {\n const season = seasonSlug(now);\n // Ensure a season row exists so the public page always shows the current one.\n const row = db\n .query(\"SELECT season FROM seasons WHERE season = ?\", [season])\n .next();\n if (!row) db.exec(\"INSERT OR IGNORE INTO seasons (season, opened_at) VALUES (?, ?)\", [season, now.toISOString()]);\n return season;\n}\n\n/** Lock a prediction on its fixed issue date. Refuses to overwrite once locked. */\nexport function lockPrediction(p: {\n issueDate: string; // ISO date (UTC)\n headline: string;\n inputs: object;\n modelVersion: string;\n}): { ok: boolean; id?: number; error?: string } {\n // Immutability: look up by season + issue date, never overwrite a locked one.\n const existing = db\n .query(\"SELECT id, locked FROM predictions WHERE season = ? AND issue_date = ?\", [\n seasonSlug(new Date(p.issueDate)),\n p.issueDate,\n ])\n .next();\n if (existing && existing[1] === 1) {\n return { ok: false, id: Number(existing[0]), error: \"Prediction already locked — immutable.\" };\n }\n const forecast = JSON.stringify({\n headline: p.headline,\n inputs: p.inputs,\n model_version: p.modelVersion,\n });\n if (existing) {\n db.exec(\"UPDATE predictions SET forecast = ?, locked = 1 WHERE id = ?\", [forecast, Number(existing[0])]);\n return { ok: true, id: Number(existing[0]) };\n }\n const id = db.exec(\n \"INSERT INTO predictions (season, issue_date, locked, forecast, created_at) VALUES (?, ?, 1, ?, ?)\",\n [seasonSlug(new Date(p.issueDate)), p.issueDate, forecast, new Date(p.issueDate).toISOString()],\n );\n return { ok: true, id: Number(id) };\n}\n\n/** Score a locked prediction once the season provides the answer. */\nexport function scorePrediction(\n issueDate: string,\n actual: object,\n score: number,\n): { ok: boolean; id?: number; error?: string } {\n const existing = db\n .query(\"SELECT id, locked FROM predictions WHERE season = ? AND issue_date = ?\", [\n seasonSlug(new Date(issueDate)),\n issueDate,\n ])\n .next();\n if (!existing) return { ok: false, error: \"Prediction not found.\" };\n if (existing[1] !== 1) return { ok: false, error: \"Prediction is not locked.\" };\n const id = Number(existing[0]);\n db.exec(\"UPDATE predictions SET result = ?, score = ?, scored_at = ? WHERE id = ?\", [\n JSON.stringify(actual),\n score,\n new Date().toISOString(),\n id,\n ]);\n return { ok: true, id };\n}\n\nfunction predictions(): Array> {\n return [...db.query(\"SELECT * FROM predictions ORDER BY issue_date\")].map((r) => ({\n id: r[0], season: r[1], issue_date: r[2], locked: r[3],\n forecast: JSON.parse(r[4]), result: r[5] ? JSON.parse(r[5]) : null,\n score: r[6], created_at: r[7], scored_at: r[8],\n }));\n}\n\n// ---- HTTP ------------------------------------------------------------------\n\nfunction html(records, current, body: string) {\n return `\n\nBlack Hat Hydrology Lab\n\n

🖤 Black Hat Hydrology Lab

San Juan River forecast experiment · Current season ${current} · ser

\n${body}\n

Raw JSON

\n`;\n}\n\nexport default async function handler(req: Request): Promise {\n const url = new URL(req.url);\n const current = openCurrentSeason();\n\n if (url.pathname === \"/data\") {\n return new Response(JSON.stringify(predictions(), null, 2), {\n headers: { \"content-type\": \"application/json\" },\n });\n }\n\n // Admin actions — protected by a shared secret when BH_LAB_SECRET is set.\n if (req.method === \"POST\" && url.pathname === \"/api/predict\") {\n if (!auth(req)) return new Response(\"Unauthorized\", { status: 401 });\n const body = await req.json();\n const out = lockPrediction(body);\n return new Response(JSON.stringify(out), { status: out.ok ? 201 : 400,\n headers: { \"content-type\": \"application/json\" } });\n }\n if (req.method === \"POST\" && url.pathname === \"/api/score\") {\n if (!auth(req)) return new Response(\"Unauthorized\", { status: 401 });\n const body = await req.json();\n const out = scorePrediction(body.issue_date, body.actual, body.score);\n return new Response(JSON.stringify(out), { status: out.ok ? 200 : 400,\n headers: { \"content-type\": \"application/json\" } });\n }\n\n const records = predictions();\n const bySeason = new Map();\n for (const r of records) {\n if (!bySeason.has(r.season as string)) bySeason.set(r.season as string, []);\n bySeason.get(r.season as string)!.push(r);\n }\n\n let body = `

Film room — previous season

${seasonTable(bySeason.get(current) ?? [], current)}

`;\n let closed = new Response(\"\", { status: 204 });\n for (const [season, recs] of bySeason) {\n if (season === current) continue;\n closed = null;\n body += `

${season} archived

${seasonTable(recs, season)}

`;\n }\n return new Response(html(records, current, body), {\n headers: { \"content-type\": \"text/html; charset=utf-8\" },\n });\n}\n\nfunction seasonTable(recs, season) {\n if (!recs.length) return `

No predictions locked yet for ${season}.

`;\n return `` +\n recs.map((r) => {\n const s = r.score == null ? \"—\" : `= 0 ? \"win\" : \"loss\"}\">${r.score}`;\n return ``;\n }).join(\"\") + `

Issue	Forecast	Model	Score
${r.issue_date}	${r.forecast.headline}	${r.forecast.model_version}	${s}

`;\n}\n\nfunction auth(req: Request): boolean {\n const secret = Deno.env.get(\"BH_LAB_SECRET\");\n if (!secret) return true; // no secret configured → allow while building\n return req.headers.get(\"x-lab-secret\") === secret;\n}\n","label",[138],"897ff7c2-3743-4e65-9376-bbd7003740f8",["D",1788719065897],[33],"pulls","branches","forks","envVars",{"_156":67,"_158":67},"connections",{"_156":67,"_157":67},"count","unfilledCount","emptyCount",{"_47":146,"_37":33,"_35":36,"_139":-5,"_45":46,"_44":14,"_141":63,"_42":165,"_13":67,"_38":39,"_40":41,"_29":30,"_144":-5,"_162":166,"_32":167},{"_47":137,"_37":138,"_35":61,"_139":-5,"_45":46,"_44":140,"_141":30,"_42":161,"_13":67,"_38":39,"_40":143,"_29":30,"_144":-5,"_162":163,"_32":164},["D",1788718987538],"children",[],[138],["D",1788719065897],[],[33],["D",1788718960405],["D",1789488693443],{"_104":103,"_112":108},{"_104":103,"_105":106,"_107":108,"_19":59,"_109":110,"_111":30},{"_13":93,"_37":94,"_47":46,"_95":48,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":49,"_102":103},"ctx",{"_86":-5,"_132":206,"_207":208,"_209":210,"_211":30,"_212":30,"_213":30,"_214":63,"_215":-5,"_216":-7,"_217":-7,"_218":67,"_219":30,"_220":30,"_221":-5,"_222":30,"_223":30,"_224":30,"_225":-5},"ENV",{"_177":178,"_179":180,"_181":94,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195,"_196":197,"_198":199,"_200":201,"_202":203,"_204":205},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v2