[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_106":107,"_108":109},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","pagosaoutside","name","black-hat-hydrology","path","lab.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":53,"_54":-5,"_55":56,"_57":58,"_59":32,"_60":-5,"_61":-5,"_62":36,"_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":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_13":44},"permalink","https://www.val.town/x/pagosaoutside/black-hat-hydrology/code/lab.ts","extension","id","897ff7c2-3743-4e65-9376-bbd7003740f8","fileId","30c7c606-aa20-11f1-9651-1607ee4eb77e","parentId","branchId","70817041-1dfa-4778-885e-ac83be02b1d0","branchVersion",2,"latest",true,"createdAt",["D",1788719065897],"version",0,"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","deleted",false,"label",[14],"f84d0eeb-ceea-4772-8eb3-fa7a8cedbc13",["D",1788718960405],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","San Juan River seasonal prediction tracker","imageUrl","userId","66be13f3-dd08-4f8a-aca1-8697006c9a46","pinnedFileId","0210c8ee-aa20-11f1-a516-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount","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",{"_9":10,"_105":101},"org",{"_9":10,"_98":99,"_100":101,"_55":56,"_102":103,"_104":42},"branch",{"_35":88,"_11":89,"_22":28,"_90":45,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":12,"_97":10},"isOwned",268,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Pagosa Outside","avatar","https://lh3.googleusercontent.com/a/ACg8ocLkPUw3N28PFDWb5so2_Azzb6wOyGiti-gB56AMhHTn6R7IXJA6Ug=s96-c","tier","free","canRestrictVals","profileImageUrl","ctx",{"_81":-5,"_139":140,"_141":142,"_143":144,"_145":42,"_146":42,"_147":42,"_148":32,"_149":-5,"_150":-7,"_151":-7,"_152":36,"_153":42,"_154":42,"_155":-5,"_156":42,"_157":42,"_158":42,"_159":-5},"ENV",{"_110":111,"_112":113,"_114":89,"_115":116,"_117":118,"_119":120,"_121":122,"_123":124,"_125":126,"_127":128,"_129":130,"_131":132,"_133":134,"_135":136,"_137":138},"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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]