🖤 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",[139],"897ff7c2-3743-4e65-9376-bbd7003740f8","lab.ts","30c7c606-aa20-11f1-9651-1607ee4eb77e",2,["D",1788719065897],"/**\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",[146],"pulls","branches","forks","envVars",{"_159":62,"_161":62},"connections",{"_159":62,"_160":62},"count","unfilledCount","emptyCount",{"_42":145,"_32":146,"_30":147,"_133":-5,"_40":41,"_39":148,"_134":58,"_37":172,"_13":62,"_33":142,"_35":150,"_23":24,"_136":-5,"_166":173,"_26":174},{"_42":138,"_32":139,"_30":56,"_133":-5,"_40":41,"_39":140,"_134":24,"_37":169,"_13":62,"_33":142,"_35":143,"_23":24,"_136":-5,"_166":170,"_26":171},{"_42":132,"_32":27,"_30":31,"_133":-5,"_40":41,"_39":14,"_134":24,"_37":165,"_13":62,"_33":34,"_35":36,"_23":24,"_136":-5,"_166":167,"_26":168},["D",1788881426921],"children",[],[27],["D",1788718987538],[],[139],["D",1788719065897],[],[146],["D",1788718960405],["D",1789575110896],{"_99":98,"_107":103},{"_99":98,"_100":101,"_102":103,"_18":54,"_104":105,"_106":24},{"_13":88,"_32":89,"_42":41,"_90":43,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":44,"_97":98},"ctx",{"_81":-5,"_126":213,"_214":215,"_216":217,"_218":24,"_219":24,"_220":24,"_221":58,"_222":-5,"_223":-7,"_224":-7,"_225":62,"_226":24,"_227":24,"_228":-5,"_229":24,"_230":24,"_231":24,"_232":-5},"ENV",{"_184":185,"_186":187,"_188":89,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210,"_211":212},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","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 · v3