Burpees

\n\n\n`;\n\n return new Response(html, { headers: { \"Content-Type\": \"text/html; charset=utf-8\" } });\n}\n\n// ─── Router ─────────────────────────────────────────────────────────────────\n\nexport default async function(req: Request): Promise {\n await ensureTables();\n await backfillIfNeeded();\n\n const url = new URL(req.url);\n const path = url.pathname;\n\n const corsHeaders = {\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"GET, POST, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type\",\n };\n\n if (req.method === \"OPTIONS\") {\n return new Response(null, { headers: corsHeaders });\n }\n\n try {\n let response: Response;\n\n if (path === \"/api/goal\" && req.method === \"GET\") {\n response = await handleGetGoal();\n } else if (path === \"/api/done\" && req.method === \"GET\") {\n response = await handleDone(url);\n } else if (path === \"/api/log\" && req.method === \"POST\") {\n response = await handleLogBurpees(req);\n } else if (path === \"/api/lookahead\" && req.method === \"GET\") {\n response = await handleLookahead();\n } else if (path === \"/api/lock-next\" && (req.method === \"GET\" || req.method === \"POST\")) {\n response = await handleLockNext();\n } else if (path.startsWith(\"/api/predict/\") && req.method === \"GET\") {\n response = await handlePredict(url);\n } else if (path === \"/api/predictions\" && req.method === \"GET\") {\n response = await handlePredictions(url);\n } else if (path === \"/api/sweep\" && req.method === \"GET\") {\n response = await handleSweep();\n } else if (path === \"/api/explain\" && req.method === \"GET\") {\n response = await handleExplain(url);\n } else if (path === \"/api/history\" && req.method === \"GET\") {\n response = await handleHistory();\n } else if (path === \"/api/stats\" && req.method === \"GET\") {\n response = await handleStats();\n } else if (path === \"/api/insights\" && req.method === \"GET\") {\n response = await handleInsights();\n } else {\n response = renderUI();\n }\n\n for (const [k, v] of Object.entries(corsHeaders)) {\n response.headers.set(k, v);\n }\n return response;\n } catch (e: any) {\n return Response.json({ error: e.message, stack: e.stack }, { status: 500 });\n }\n}\n","deleted","label","children",[],[166],{"_107":187,"_100":188,"_167":189,"_169":-5,"_170":152,"_171":151,"_173":174,"_109":190,"_104":191,"_177":192,"_179":193,"_181":22,"_182":-5,"_183":194,"_103":195},"4e1b66c6-27ea-11f1-b90d-42dde27851f2","predict-tomorrow.ts","4f8eb2bc-1b18-11f1-be3e-42dde27851f2",["D",1774402271124],17,"script","import sqlite from \"https://esm.town/v/std/db/main.ts\";\n\nconst recent = await sqlite.execute(`SELECT date, goal, probability, fatebook_qid, charlie_qid FROM locks WHERE date >= '2026-03-24' ORDER BY date`);\nconsole.log(\"Locks:\");\nfor (const r of recent.rows as any[]) console.log(` ${r.date} | goal=${r.goal} | prob=${(r.probability*100).toFixed(1)}% | model=${r.fatebook_qid||'null'} | charlie=${r.charlie_qid||'null'}`);\n\nconst preds = await sqlite.execute(`SELECT * FROM predictions WHERE date >= '2026-03-24' ORDER BY date, round`);\nconsole.log(\"\\nPredictions:\");\nfor (const r of preds.rows as any[]) console.log(` ${r.date} r${r.round} | goal=${r.goal_shown} | model=${(r.model_prob*100).toFixed(1)}% | charlie=${r.charlie_prob ? (r.charlie_prob*100).toFixed(1)+'%' : 'null'}`);\n\nconst hist = await sqlite.execute(`SELECT date, goal, burpees, achieved FROM history WHERE date >= '2026-03-24' ORDER BY date`);\nconsole.log(\"\\nHistory:\");\nfor (const r of hist.rows as any[]) console.log(` ${r.date} | goal=${r.goal} | burpees=${r.burpees} | achieved=${r.achieved}`);\n",[],[188],{"_107":197,"_100":198,"_167":199,"_169":-5,"_170":152,"_171":200,"_173":174,"_109":201,"_104":33,"_177":192,"_179":202,"_181":22,"_182":-5,"_183":203,"_103":204},"50521fbe-1b17-11f1-abfe-42dde27851f2","predictions.ts","50522054-1b17-11f1-abfe-42dde27851f2",53,["D",1772992237087],"/**\n * Predictions table + feature helpers.\n *\n * Stores every round of negotiation between Charlie and the model.\n * Dynamic feature columns: for each round r, three features:\n * charlie_pred_r, model_pred_r, goal_at_r\n * \n * Days with fewer rounds get 0s for missing columns.\n */\n\nimport sqlite from \"https://esm.town/v/std/db/main.ts\";\n\nexport interface PredictionRow {\n date: string;\n round: number;\n goal_shown: number;\n model_prob: number;\n charlie_prob: number | null;\n}\n\nexport async function ensurePredictionsTable(): Promise {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS predictions (\n date TEXT NOT NULL,\n round INTEGER NOT NULL,\n goal_shown INTEGER NOT NULL,\n model_prob REAL NOT NULL,\n charlie_prob REAL,\n PRIMARY KEY (date, round)\n )`);\n}\n\nexport async function storePrediction(\n date: string,\n round: number,\n goalShown: number,\n modelProb: number,\n charlieProb: number | null,\n): Promise {\n await sqlite.execute(\n `INSERT OR REPLACE INTO predictions (date, round, goal_shown, model_prob, charlie_prob)\n VALUES (?, ?, ?, ?, ?)`,\n [date, round, goalShown, modelProb, charlieProb],\n );\n}\n\nexport async function getPredictionsForDate(date: string): Promise {\n const r = await sqlite.execute(\n `SELECT date, round, goal_shown, model_prob, charlie_prob\n FROM predictions WHERE date = ? ORDER BY round`,\n [date],\n );\n return r.rows.map((row: any) => ({\n date: row.date,\n round: row.round,\n goal_shown: row.goal_shown,\n model_prob: row.model_prob,\n charlie_prob: row.charlie_prob,\n }));\n}\n\nexport async function getAllPredictionsByDate(): Promise> {\n const r = await sqlite.execute(\n `SELECT date, round, goal_shown, model_prob, charlie_prob\n FROM predictions ORDER BY date, round`,\n );\n const map = new Map();\n for (const row of r.rows as any[]) {\n const p: PredictionRow = {\n date: row.date,\n round: row.round,\n goal_shown: row.goal_shown,\n model_prob: row.model_prob,\n charlie_prob: row.charlie_prob,\n };\n if (!map.has(p.date)) map.set(p.date, []);\n map.get(p.date)!.push(p);\n }\n return map;\n}\n\nexport async function getMaxPredictionRounds(): Promise {\n try {\n const r = await sqlite.execute(`SELECT MAX(round) as max_round FROM predictions`);\n return (r.rows[0] as any)?.max_round ?? 0;\n } catch {\n return 0;\n }\n}\n\n/** Generate feature key names for prediction rounds 1..maxRounds */\nexport function predictionFeatureKeys(maxRounds: number): string[] {\n const keys: string[] = [];\n for (let r = 1; r <= maxRounds; r++) {\n keys.push(`charlie_pred_${r}`, `model_pred_${r}`, `goal_at_${r}`);\n }\n return keys;\n}\n\n/** Build the prediction portion of the feature vector for a given date */\nexport function buildPredictionFeatures(\n preds: PredictionRow[] | undefined,\n maxRounds: number,\n): Record {\n const feat: Record = {};\n for (let r = 1; r <= maxRounds; r++) {\n const p = preds?.find((p) => p.round === r);\n feat[`charlie_pred_${r}`] = p?.charlie_prob ?? 0;\n feat[`model_pred_${r}`] = p?.model_prob ?? 0;\n feat[`goal_at_${r}`] = p?.goal_shown ?? 0;\n }\n return feat;\n}\n",[],[198],{"_107":206,"_100":207,"_167":208,"_169":-5,"_170":152,"_171":209,"_173":174,"_109":210,"_104":211,"_177":192,"_179":212,"_181":22,"_182":-5,"_183":213,"_103":214},"9b0a3b22-087a-11f1-8656-42dde27851f2","seed.ts","4672af40-087a-11f1-aa73-42dde27851f2",13,["D",1770945810518],4,"import sqlite from \"https://esm.town/v/std/db/main.ts\";\n\n// Seed data: [date, burpees|null, goal, achieved]\nconst DATA: [string, number | null, number, number][] = [\n[\"2025-01-18\",12,12,1],[\"2025-01-19\",13,13,1],[\"2025-01-20\",15,15,1],[\"2025-01-21\",18,18,1],[\"2025-01-22\",23,23,1],[\"2025-01-23\",0,31,0],[\"2025-01-24\",30,30,1],[\"2025-01-25\",31,31,1],[\"2025-01-26\",0,33,0],[\"2025-01-27\",0,32,0],[\"2025-01-28\",0,30,0],[\"2025-01-29\",27,27,1],[\"2025-01-30\",28,28,1],[\"2025-01-31\",30,30,1],\n[\"2025-02-01\",33,33,1],[\"2025-02-02\",38,38,1],[\"2025-02-03\",46,46,1],[\"2025-02-04\",50,50,1],[\"2025-02-05\",50,50,1],[\"2025-02-06\",50,50,1],[\"2025-02-07\",50,50,1],[\"2025-02-08\",50,50,1],[\"2025-02-09\",50,50,1],[\"2025-02-10\",0,50,0],[\"2025-02-11\",49,49,1],[\"2025-02-12\",50,50,1],[\"2025-02-13\",50,50,1],[\"2025-02-14\",0,50,0],[\"2025-02-15\",49,49,1],[\"2025-02-16\",50,50,1],[\"2025-02-17\",50,50,1],[\"2025-02-18\",50,50,1],[\"2025-02-19\",50,50,1],[\"2025-02-20\",50,50,1],[\"2025-02-21\",50,50,1],[\"2025-02-22\",50,50,1],[\"2025-02-23\",0,50,0],[\"2025-02-24\",49,49,1],[\"2025-02-25\",50,50,1],[\"2025-02-26\",50,50,1],[\"2025-02-27\",50,50,1],[\"2025-02-28\",50,50,1],\n[\"2025-03-01\",0,50,0],[\"2025-03-02\",0,49,0],[\"2025-03-03\",47,47,1],[\"2025-03-04\",48,48,1],[\"2025-03-05\",50,50,1],[\"2025-03-06\",50,50,1],[\"2025-03-07\",50,50,1],[\"2025-03-08\",null,50,0],[\"2025-03-09\",49,49,1],[\"2025-03-10\",50,50,1],[\"2025-03-11\",50,50,1],[\"2025-03-12\",50,50,1],[\"2025-03-13\",50,50,1],[\"2025-03-14\",null,50,0],[\"2025-03-15\",49,49,1],[\"2025-03-16\",null,50,0],[\"2025-03-17\",49,49,1],[\"2025-03-18\",50,50,1],[\"2025-03-19\",50,50,1],[\"2025-03-20\",50,50,1],[\"2025-03-21\",50,50,1],[\"2025-03-22\",50,50,1],[\"2025-03-23\",null,50,0],[\"2025-03-24\",49,49,1],[\"2025-03-25\",50,50,1],[\"2025-03-26\",50,50,1],[\"2025-03-27\",50,50,1],[\"2025-03-28\",null,50,0],[\"2025-03-29\",null,49,0],[\"2025-03-30\",47,47,1],[\"2025-03-31\",48,48,1],\n[\"2025-04-01\",null,50,0],[\"2025-04-02\",49,49,1],[\"2025-04-03\",null,50,0],[\"2025-04-04\",null,49,0],[\"2025-04-05\",null,47,0],[\"2025-04-06\",null,44,0],[\"2025-04-07\",null,39,0],[\"2025-04-08\",null,31,0],[\"2025-04-09\",1,18,0],[\"2025-04-10\",2,1,1],[\"2025-04-11\",2,2,1],[\"2025-04-12\",4,4,1],[\"2025-04-13\",7,7,1],[\"2025-04-14\",12,12,1],[\"2025-04-15\",20,20,1],[\"2025-04-16\",null,33,0],[\"2025-04-17\",null,32,0],[\"2025-04-18\",30,30,1],[\"2025-04-19\",null,31,0],[\"2025-04-20\",null,30,0],[\"2025-04-21\",null,28,0],[\"2025-04-22\",null,25,0],[\"2025-04-23\",20,20,1],[\"2025-04-24\",21,21,1],[\"2025-04-25\",23,23,1],[\"2025-04-26\",null,26,0],[\"2025-04-27\",25,25,1],[\"2025-04-28\",null,26,0],[\"2025-04-29\",25,25,1],[\"2025-04-30\",null,26,0],\n[\"2025-05-01\",25,25,1],[\"2025-05-02\",26,26,1],[\"2025-05-03\",null,28,0],[\"2025-05-04\",null,27,0],[\"2025-05-05\",null,25,0],[\"2025-05-06\",null,22,0],[\"2025-05-07\",null,17,0],[\"2025-05-08\",9,9,1],[\"2025-05-09\",null,10,0],[\"2025-05-10\",null,9,0],[\"2025-05-11\",null,7,0],[\"2025-05-12\",4,4,1],[\"2025-05-13\",5,5,1],[\"2025-05-14\",7,7,1],[\"2025-05-15\",10,10,1],[\"2025-05-16\",15,15,1],[\"2025-05-17\",null,23,0],[\"2025-05-18\",22,22,1],[\"2025-05-19\",null,23,0],[\"2025-05-20\",null,22,0],[\"2025-05-21\",null,20,0],[\"2025-05-22\",17,17,1],[\"2025-05-23\",18,18,1],[\"2025-05-24\",20,20,1],[\"2025-05-25\",23,23,1],[\"2025-05-26\",28,28,1],[\"2025-05-27\",36,36,1],[\"2025-05-28\",49,49,1],[\"2025-05-29\",null,50,0],[\"2025-05-30\",null,49,0],[\"2025-05-31\",47,47,1],\n[\"2025-06-01\",48,48,1],[\"2025-06-02\",50,50,1],[\"2025-06-03\",50,50,1],[\"2025-06-04\",50,50,1],[\"2025-06-05\",50,50,1],[\"2025-06-06\",50,50,1],[\"2025-06-07\",50,50,1],[\"2025-06-08\",50,50,1],[\"2025-06-09\",null,50,0],[\"2025-06-10\",null,49,0],[\"2025-06-11\",null,47,0],[\"2025-06-12\",null,44,0],[\"2025-06-13\",39,39,1],[\"2025-06-14\",null,40,0],[\"2025-06-15\",null,39,0],[\"2025-06-16\",null,37,0],[\"2025-06-17\",null,34,0],[\"2025-06-18\",null,29,0],[\"2025-06-19\",null,21,0],[\"2025-06-20\",8,8,1],[\"2025-06-21\",null,9,0],[\"2025-06-22\",null,8,0],[\"2025-06-23\",6,6,1],[\"2025-06-24\",7,7,1],[\"2025-06-25\",null,9,0],[\"2025-06-26\",null,8,0],[\"2025-06-27\",6,6,1],[\"2025-06-28\",null,7,0],[\"2025-06-29\",null,6,0],[\"2025-06-30\",null,4,0],\n[\"2025-07-01\",1,1,1],[\"2025-07-02\",2,2,1],[\"2025-07-03\",4,4,1],[\"2025-07-04\",null,7,0],[\"2025-07-05\",null,6,0],[\"2025-07-06\",null,4,0],[\"2025-07-07\",1,1,1],[\"2025-07-08\",2,2,1],[\"2025-07-09\",null,4,0],[\"2025-07-10\",null,3,0],[\"2025-07-11\",null,1,0],[\"2025-07-12\",null,1,0],[\"2025-07-13\",1,1,1],[\"2025-07-14\",2,2,1],[\"2025-07-15\",4,4,1],[\"2025-07-16\",7,7,1],[\"2025-07-17\",null,12,0],[\"2025-07-18\",11,11,1],[\"2025-07-19\",null,12,0],[\"2025-07-20\",null,11,0],[\"2025-07-21\",null,9,0],[\"2025-07-22\",null,6,0],[\"2025-07-23\",null,1,0],[\"2025-07-24\",1,1,1],[\"2025-07-25\",null,2,0],[\"2025-07-26\",1,1,1],[\"2025-07-27\",null,2,0],[\"2025-07-28\",1,1,1],[\"2025-07-29\",2,2,1],[\"2025-07-30\",4,4,1],[\"2025-07-31\",7,7,1],\n[\"2025-08-01\",12,12,1],[\"2025-08-02\",null,20,0],[\"2025-08-03\",null,19,0],[\"2025-08-04\",6,17,0],[\"2025-08-05\",null,14,0],[\"2025-08-06\",9,9,1],[\"2025-08-07\",10,10,1],[\"2025-08-08\",12,12,1],[\"2025-08-09\",15,15,1],[\"2025-08-10\",null,20,0],[\"2025-08-11\",19,19,1],[\"2025-08-12\",20,20,1],[\"2025-08-13\",22,22,1],[\"2025-08-14\",25,25,1],[\"2025-08-15\",30,30,1],[\"2025-08-16\",38,38,1],[\"2025-08-17\",null,50,0],[\"2025-08-18\",49,49,1],[\"2025-08-19\",null,50,0],[\"2025-08-20\",null,49,0],[\"2025-08-21\",47,47,1],[\"2025-08-22\",48,48,1],[\"2025-08-23\",null,50,0],[\"2025-08-24\",null,49,0],[\"2025-08-25\",47,47,1],[\"2025-08-26\",48,48,1],[\"2025-08-27\",50,50,1],[\"2025-08-28\",50,50,1],[\"2025-08-29\",50,50,1],[\"2025-08-30\",null,50,0],[\"2025-08-31\",null,49,0],\n[\"2025-09-01\",47,47,1],[\"2025-09-02\",null,48,0],[\"2025-09-03\",null,47,0],[\"2025-09-04\",null,45,0],[\"2025-09-05\",null,42,0],[\"2025-09-06\",null,37,0],[\"2025-09-07\",null,29,0],[\"2025-09-08\",null,16,0],[\"2025-09-09\",null,1,0],[\"2025-09-10\",null,1,0],[\"2025-09-11\",null,1,0],[\"2025-09-12\",null,1,0],[\"2025-09-13\",null,1,0],[\"2025-09-14\",null,1,0],[\"2025-09-15\",null,1,0],[\"2025-09-16\",1,1,1],[\"2025-09-17\",2,2,1],[\"2025-09-18\",4,4,1],[\"2025-09-19\",7,7,1],[\"2025-09-20\",12,12,1],[\"2025-09-21\",null,20,0],[\"2025-09-22\",19,19,1],[\"2025-09-23\",null,20,0],[\"2025-09-24\",null,19,0],[\"2025-09-25\",null,17,0],[\"2025-09-26\",null,14,0],[\"2025-09-27\",9,9,1],[\"2025-09-28\",null,10,0],[\"2025-09-29\",null,9,0],[\"2025-09-30\",null,7,0],\n[\"2025-10-01\",4,4,1],[\"2025-10-02\",7,7,1],[\"2025-10-03\",null,36,0],[\"2025-10-04\",28,28,1],[\"2025-10-05\",30,30,1],[\"2025-10-06\",34,34,1],[\"2025-10-07\",41,41,1],[\"2025-10-08\",null,50,0],[\"2025-10-09\",40,40,1],[\"2025-10-10\",null,43,0],[\"2025-10-11\",null,31,0],[\"2025-10-12\",null,25,0],[\"2025-10-13\",null,24,0],[\"2025-10-14\",null,25,0],[\"2025-10-15\",26,26,1],[\"2025-10-16\",35,35,1],[\"2025-10-17\",null,40,0],[\"2025-10-18\",null,28,0],[\"2025-10-19\",28,23,1],[\"2025-10-20\",33,33,1],[\"2025-10-21\",34,34,1],[\"2025-10-22\",34,34,1],[\"2025-10-23\",48,48,1],[\"2025-10-24\",50,50,1],[\"2025-10-25\",null,50,0],[\"2025-10-26\",null,39,0],[\"2025-10-27\",null,46,0],[\"2025-10-28\",null,48,0],[\"2025-10-29\",46,46,1],[\"2025-10-30\",null,50,0],[\"2025-10-31\",39,39,1],\n[\"2025-11-01\",null,41,0],[\"2025-11-02\",null,32,0],[\"2025-11-03\",null,31,0],[\"2025-11-04\",33,33,1],[\"2025-11-05\",null,50,0],[\"2025-11-06\",37,37,1],[\"2025-11-07\",null,37,0],[\"2025-11-08\",null,26,0],[\"2025-11-09\",null,24,0],[\"2025-11-10\",null,25,0],[\"2025-11-11\",null,27,0],[\"2025-11-12\",null,28,0],[\"2025-11-13\",null,26,0],[\"2025-11-14\",22,22,1],[\"2025-11-15\",null,27,0],[\"2025-11-16\",null,22,0],[\"2025-11-17\",null,22,0],[\"2025-11-18\",null,23,0],[\"2025-11-19\",24,24,1],[\"2025-11-20\",null,34,0],[\"2025-11-21\",null,24,0],[\"2025-11-22\",null,21,0],[\"2025-11-23\",null,20,0],[\"2025-11-24\",null,21,0],[\"2025-11-25\",null,22,0],[\"2025-11-26\",23,23,1],[\"2025-11-27\",null,22,0],[\"2025-11-28\",23,23,1],[\"2025-11-29\",null,28,0],[\"2025-11-30\",null,24,0],\n[\"2025-12-01\",null,24,0],[\"2025-12-02\",null,24,0],[\"2025-12-03\",null,25,0],[\"2025-12-04\",null,23,0],[\"2025-12-05\",null,20,0],[\"2025-12-06\",null,18,0],[\"2025-12-07\",null,18,0],[\"2025-12-08\",null,19,0],[\"2025-12-09\",null,20,0],[\"2025-12-10\",null,21,0],[\"2025-12-11\",20,20,1],[\"2025-12-12\",null,25,0],[\"2025-12-13\",null,18,0],[\"2025-12-14\",null,17,0],[\"2025-12-15\",null,18,0],[\"2025-12-16\",null,19,0],[\"2025-12-17\",21,21,1],[\"2025-12-18\",null,29,0],[\"2025-12-19\",21,21,1],[\"2025-12-20\",null,23,0],[\"2025-12-21\",null,18,0],[\"2025-12-22\",null,18,0],[\"2025-12-23\",null,20,0],[\"2025-12-24\",null,22,0],[\"2025-12-25\",null,22,0],[\"2025-12-26\",null,19,0],[\"2025-12-27\",null,17,0],[\"2025-12-28\",null,16,0],[\"2025-12-29\",null,17,0],[\"2025-12-30\",null,18,0],[\"2025-12-31\",null,19,0],\n[\"2026-01-01\",null,18,0],[\"2026-01-02\",null,17,0],[\"2026-01-03\",null,15,0],[\"2026-01-04\",15,15,1],[\"2026-01-05\",null,20,0],[\"2026-01-06\",null,18,0],[\"2026-01-07\",null,19,0],[\"2026-01-08\",null,18,0],[\"2026-01-09\",null,17,0],[\"2026-01-10\",null,16,0],[\"2026-01-11\",null,15,0],[\"2026-01-12\",null,16,0],[\"2026-01-13\",null,17,0],[\"2026-01-14\",null,18,0],[\"2026-01-15\",null,18,0],[\"2026-01-16\",null,16,0],[\"2026-01-17\",null,15,0],[\"2026-01-18\",null,15,0],[\"2026-01-19\",null,15,0],[\"2026-01-20\",null,16,0],[\"2026-01-21\",null,17,0],[\"2026-01-22\",null,16,0],[\"2026-01-23\",15,15,1],[\"2026-01-24\",null,18,0],[\"2026-01-25\",15,15,1],[\"2026-01-26\",null,19,0],[\"2026-01-27\",null,18,0],[\"2026-01-28\",null,19,0],[\"2026-01-29\",null,18,0],[\"2026-01-30\",null,17,0],[\"2026-01-31\",null,15,0],\n[\"2026-02-01\",null,15,0],[\"2026-02-02\",null,15,0],[\"2026-02-03\",null,16,0],[\"2026-02-04\",null,17,0],[\"2026-02-05\",null,17,0],[\"2026-02-06\",16,16,1],[\"2026-02-07\",null,18,0],[\"2026-02-08\",15,15,1],[\"2026-02-09\",null,19,0],[\"2026-02-10\",null,17,0],[\"2026-02-11\",18,18,1],\n];\n\nasync function seed() {\n // Create tables first\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS history (\n date TEXT PRIMARY KEY, goal INTEGER NOT NULL, burpees INTEGER, achieved INTEGER NOT NULL DEFAULT 0\n )`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS locks (\n date TEXT PRIMARY KEY, goal INTEGER NOT NULL, probability REAL, ev REAL\n )`);\n \n console.log(`Seeding ${DATA.length} rows...`);\n \n // Do in individual inserts\n for (let i = 0; i < DATA.length; i++) {\n const [date, burpees, goal, achieved] = DATA[i];\n await sqlite.execute(\n `INSERT OR IGNORE INTO history (date, goal, burpees, achieved) VALUES (?, ?, ?, ?)`,\n [date, goal, burpees, achieved],\n );\n }\n \n const count = await sqlite.execute(`SELECT COUNT(*) as c FROM history`);\n console.log(`Done. Total rows: ${(count.rows[0] as any).c}`);\n}\n\nseed();\n",[],[207],"files",[164,186,196,205],"counts",{"_219":33,"_220":221,"_222":33,"_223":224,"_228":229},"pulls","branches",1,"forks","envVars",{"_225":226,"_227":33},"count",3,"emptyCount","connections",{"_225":33,"_230":33},"unfilledCount","contents",[233,236,239,242],{"_107":165,"_100":166,"_167":168,"_169":-5,"_170":152,"_171":172,"_173":174,"_109":234,"_104":176,"_177":178,"_179":180,"_181":22,"_182":-5,"_103":235},["D",1773287585175],[166],{"_107":187,"_100":188,"_167":189,"_169":-5,"_170":152,"_171":151,"_173":174,"_109":237,"_104":191,"_177":192,"_179":193,"_181":22,"_182":-5,"_103":238},["D",1774402271124],[188],{"_107":197,"_100":198,"_167":199,"_169":-5,"_170":152,"_171":200,"_173":174,"_109":240,"_104":33,"_177":192,"_179":202,"_181":22,"_182":-5,"_103":241},["D",1772992237087],[198],{"_107":206,"_100":207,"_167":208,"_169":-5,"_170":152,"_171":209,"_173":174,"_109":243,"_104":211,"_177":192,"_179":212,"_181":22,"_182":-5,"_103":244},["D",1770945810518],[207],"file","upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.environment-variables",{"_98":99,"_100":101,"_105":254,"_223":260,"_276":22},{"_107":108,"_100":101,"_109":255,"_111":-5,"_112":22,"_113":114,"_115":116,"_117":-5,"_14":118,"_119":-5,"_120":22,"_121":-5,"_122":-5,"_123":33,"_16":124,"_125":126,"_127":128,"_129":256,"_131":-5,"_132":133,"_134":133,"_135":136,"_137":136,"_138":136,"_139":133,"_140":133,"_23":257,"_144":258,"_149":259,"_161":22},["D",1770944852631],["D",1776213631921],{"_98":99,"_142":143},{"_98":99,"_146":143,"_14":118,"_147":148},{"_104":151,"_100":46,"_107":152,"_153":108,"_154":-5,"_155":-5,"_156":-5,"_157":-5,"_158":-5,"_159":101,"_160":99},[261,268,272],{"_262":263,"_109":264,"_265":-5,"_115":266,"_267":22},"key","FATEBOOK_API_KEY",["D",1772574376224],"updatedAt","Fatebook prediction API key for model predictions","isEmpty",{"_262":269,"_109":270,"_265":-5,"_115":271,"_267":22},"BEEMINDER_TOKEN",["D",1771783755615],"Beeminder API auth token (corrected) for charliem/burpees goal",{"_262":273,"_109":274,"_265":-5,"_115":275,"_267":22},"BEEMINDER_AUTH_TOKEN",["D",1771783194966],"Beeminder API auth token for charliem/burpees goal","isTeamOrg","actionData","errors"]

dcm31

burpees

Environment variables