[{"_1":2,"_184":-5,"_185":-5},"loaderData",{"_3":4,"_96":97},"root",{"_5":6,"_37":38,"_69":70},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":-5,"_32":33,"_34":20,"_35":20,"_36":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesChatPanelState","notificationCount",0,"flagDenols","isBusinessOrgMember","isHigherTownieTier","ENV",{"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58,"_59":60,"_61":62,"_63":64,"_65":66,"_67":68},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","efeea19332d9bfe7de1049656877be9cb817c45f","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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","API_URL","https://api.val.town","clerkState",{"_71":72},"__internal_clerk_state",{"_73":74,"_75":48,"_76":77,"_78":77,"_79":20,"_80":77,"_81":77,"_82":77,"_83":77,"_84":85,"_94":20,"_95":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_86":20,"_19":20,"_87":77,"_88":89,"_90":77,"_91":48,"_92":20,"_93":77},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_98":99,"_100":101,"_102":103,"_104":105,"_162":163,"_181":182,"_183":-5},"handle","dcm31","name","burpees","path","predictions.ts","project",{"_106":107,"_100":101,"_108":109,"_110":-5,"_111":20,"_112":113,"_114":115,"_116":-5,"_12":117,"_118":-5,"_119":20,"_120":-5,"_121":-5,"_122":33,"_14":123,"_124":125,"_126":127,"_128":129,"_130":-5,"_131":132,"_133":132,"_134":135,"_136":135,"_137":135,"_138":132,"_139":132,"_23":140,"_143":144,"_148":149,"_161":20},"id","6015bbba-0878-11f1-b1e4-42dde27851f2","createdAt",["D",1770944852631],"deletedAt","legacyEnvVars","privacy","unlisted","description","Burpee goal optimizer with logistic regression","imageUrl","9319c175-2593-4f88-ba21-04f2ef7b1c28","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","d663a026-6449-42f6-9156-1d4a2d64d38c","tursoName","6015bbba087811f1b1e442dde27851f2","tursoHostname","6015bbba087811f1b1e442dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1776213631921],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_98":99,"_141":142},"profileImageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/3e904faa-3764-4629-c475-f561a49b0000/square512","org",{"_98":99,"_145":142,"_12":117,"_146":147},"avatar","tier","pro","branch",{"_150":151,"_100":46,"_106":152,"_153":107,"_154":-5,"_155":-5,"_156":-5,"_157":-5,"_158":-5,"_159":101,"_160":99},"version",88,"601602fa-0878-11f1-b1e4-42dde27851f2","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_106":164,"_100":103,"_165":166,"_167":-5,"_168":152,"_169":170,"_171":172,"_108":173,"_150":33,"_174":175,"_176":177,"_178":20,"_179":-5,"_102":180},"50521fbe-1b17-11f1-abfe-42dde27851f2","fileId","50522054-1b17-11f1-abfe-42dde27851f2","parentId","branchId","branchVersion",53,"latest",true,["D",1772992237087],"fileType","script","content","/**\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","deleted","label",[103],"permalink","https://www.val.town/x/dcm31/burpees/code/predictions.ts","extension","actionData","errors"]