[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_110":111,"_112":113},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","michaelfreedman","name","nfl-betting-app","path","lib/db.ts","project",{"_22":48,"_11":12,"_35":49,"_50":-5,"_51":44,"_52":53,"_54":53,"_55":56,"_57":-5,"_58":59,"_60":61,"_62":34,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":70,"_71":72,"_73":74,"_75":-5,"_76":77,"_78":77,"_79":80,"_81":80,"_82":80,"_83":77,"_84":77,"_85":86,"_87":88,"_89":90,"_91":44},"file",{"_22":23,"_11":24,"_25":26,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":-5,"_13":46},"permalink","https://www.val.town/x/michaelfreedman/nfl-betting-app/code/lib/db.ts","extension","id","97f9d688-f638-4aa0-a555-6dae1bcb7cf5","db.ts","fileId","3ed5b0c8-abf1-11f1-8d16-1607ee4eb77e","parentId","be65e5ee-01bf-4c7a-8bd9-ffb605a4016e","branchId","8ec703c1-dca2-4457-930c-483e75a3ce83","branchVersion",11,"latest",true,"createdAt",["D",1788918881347],"version",2,"fileType","script","content","// SQLite persistence: bankroll + bet history via std/sqlite (val-scoped DB).\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport const STARTING_BANKROLL = 1000;\n\nexport interface Bet {\n id: number;\n gameId: string;\n gameLabel: string;\n betType: \"moneyline\" | \"spread\" | \"total\";\n side: \"home\" | \"away\" | \"over\" | \"under\";\n pickLabel: string;\n /** The line locked in at placement; used to settle. spread line (home-relative) or o/u total. */\n linePoint: number | null;\n stake: number;\n decimalOdds: number;\n status: \"open\" | \"win\" | \"loss\" | \"push\";\n profit: number | null;\n createdAt: string;\n settledAt: string | null;\n}\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS meta (\n key TEXT PRIMARY KEY,\n value TEXT NOT NULL\n)`);\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS bets (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n game_id TEXT NOT NULL,\n game_label TEXT NOT NULL,\n bet_type TEXT NOT NULL,\n side TEXT NOT NULL,\n pick_label TEXT NOT NULL,\n line_point REAL,\n stake REAL NOT NULL,\n decimal_odds REAL NOT NULL,\n status TEXT NOT NULL DEFAULT 'open',\n profit REAL,\n created_at TEXT NOT NULL,\n settled_at TEXT\n)`);\n\nasync function getMeta(key: string): Promise {\n const r = await sqlite.execute(`SELECT value FROM meta WHERE key = ?`, [key]);\n return (r.rows[0] as { value?: string } | undefined)?.value ?? null;\n}\n\nasync function setMeta(key: string, value: string): Promise {\n await sqlite.execute({\n sql: `INSERT INTO meta (key, value) VALUES (?, ?)\n ON CONFLICT(key) DO UPDATE SET value = excluded.value`,\n args: [key, value],\n });\n}\n\nexport async function getBankroll(): Promise {\n const raw = await getMeta(\"bankroll\");\n if (raw == null) {\n await setMeta(\"bankroll\", String(STARTING_BANKROLL));\n await setMeta(\"starting_bankroll\", String(STARTING_BANKROLL));\n return STARTING_BANKROLL;\n }\n return Number(raw);\n}\n\nexport async function getStartingBankroll(): Promise {\n const raw = await getMeta(\"starting_bankroll\");\n return raw == null ? STARTING_BANKROLL : Number(raw);\n}\n\nexport async function getOpenBets(): Promise {\n const rows: any[] = (await sqlite.execute(`SELECT * FROM bets WHERE status = 'open' ORDER BY created_at DESC`)).rows;\n return rows.map(rowToBet);\n}\n\nexport async function getAllBets(): Promise {\n const rows: any[] = (await sqlite.execute(`SELECT * FROM bets ORDER BY created_at DESC`)).rows;\n return rows.map(rowToBet);\n}\n\nexport async function getBetsForGame(gameId: string): Promise {\n const rows: any[] = (await sqlite.execute(`SELECT * FROM bets WHERE game_id = ? ORDER BY created_at DESC`, [gameId])).rows;\n return rows.map(rowToBet);\n}\n\nfunction rowToBet(r: any): Bet {\n return {\n id: r.id,\n gameId: r.game_id,\n gameLabel: r.game_label,\n betType: r.bet_type,\n side: r.side,\n pickLabel: r.pick_label,\n linePoint: r.line_point != null ? Number(r.line_point) : null,\n stake: r.stake,\n decimalOdds: r.decimal_odds,\n status: r.status,\n profit: r.profit != null ? Number(r.profit) : null,\n createdAt: r.created_at,\n settledAt: r.settled_at,\n };\n}\n\nexport interface PlaceBetInput {\n gameId: string;\n gameLabel: string;\n betType: Bet[\"betType\"];\n side: Bet[\"side\"];\n pickLabel: string;\n linePoint: number | null;\n stake: number;\n decimalOdds: number;\n}\n\n/** Place a bet: deducts the stake and inserts the bet atomically. Throws on invalid input. */\nexport async function placeBet(input: PlaceBetInput): Promise<{ bankroll: number; bet: Bet }> {\n const bankroll = await getBankroll();\n if (!Number.isFinite(input.stake) || input.stake <= 0) {\n throw new Error(\"Stake must be a positive number.\");\n }\n if (input.stake > bankroll) {\n throw new Error(`You only have $${bankroll.toLocaleString()} in your bankroll.`);\n }\n\n const createdAt = new Date().toISOString();\n await sqlite.batch([\n { sql: `INSERT INTO bets (game_id, game_label, bet_type, side, pick_label, line_point, stake, decimal_odds, status, profit, created_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, 'open', NULL, ?)`,\n args: [input.gameId, input.gameLabel, input.betType, input.side, input.pickLabel, input.linePoint, input.stake, input.decimalOdds, createdAt] },\n { sql: `UPDATE meta SET value = ? WHERE key = 'bankroll'`, args: [String(bankroll - input.stake)] },\n ]);\n\n const inserted: any[] = (await sqlite.execute(`SELECT * FROM bets WHERE created_at = ? ORDER BY id DESC LIMIT 1`, [createdAt])).rows;\n return { bankroll: bankroll - input.stake, bet: rowToBet(inserted[0]) };\n}\n\nexport interface BetResult {\n status: Bet[\"status\"];\n profit: number;\n}\n\n/**\n * Compute the outcome of a bet given the final scores. Uses the line locked in\n * at placement (bet.linePoint). linePoint semantics:\n * - spread: the HOME team's line (negative = home favored), e.g. -3\n * - total: the over/under total, e.g. 44.5\n * Moneyline ignores linePoint (whoever outscores wins; a tie pushes).\n */\nexport function resolveBet(bet: Bet, homeScore: number, awayScore: number): BetResult {\n const margin = homeScore - awayScore;\n const total = homeScore + awayScore;\n const winProfit = bet.stake * (bet.decimalOdds - 1);\n\n if (bet.betType === \"moneyline\") {\n if (margin === 0) return { status: \"push\", profit: 0 };\n const homeWon = margin > 0;\n if ((bet.side === \"home\") === homeWon) return { status: \"win\", profit: winProfit };\n return { status: \"loss\", profit: -bet.stake };\n }\n\n if (bet.betType === \"spread\") {\n if (bet.linePoint == null) return { status: \"open\", profit: 0 };\n const adj = margin + bet.linePoint; // >0 home covers, <0 away covers, ===0 push\n if (adj === 0) return { status: \"push\", profit: 0 };\n const homeCovers = adj > 0;\n if ((bet.side === \"home\") === homeCovers) return { status: \"win\", profit: winProfit };\n return { status: \"loss\", profit: -bet.stake };\n }\n\n // total (over/under)\n if (bet.linePoint == null) return { status: \"open\", profit: 0 };\n if (total === bet.linePoint) return { status: \"push\", profit: 0 };\n const overWon = total > bet.linePoint;\n if ((bet.side === \"over\") === overWon) return { status: \"win\", profit: winProfit };\n return { status: \"loss\", profit: -bet.stake };\n}\n\n/** Settle any open bets among the given completed results. Returns newly-settled bets + bankroll. */\nexport async function settleResults(results: { gameId: string; homeScore: number; awayScore: number }[]): Promise<{ settled: Bet[]; bankroll: number }> {\n const open = await getOpenBets();\n const byId = new Map(results.map((r) => [r.gameId, r]));\n const settled: Bet[] = [];\n\n for (const bet of open) {\n const res = byId.get(bet.gameId);\n if (!res) continue;\n const result = resolveBet(bet, res.homeScore, res.awayScore);\n const settledAt = new Date().toISOString();\n await sqlite.batch([\n { sql: `UPDATE bets SET status = ?, profit = ?, settled_at = ? WHERE id = ?`,\n args: [result.status, result.profit, settledAt, bet.id] },\n { sql: `UPDATE meta SET value = CAST(CAST(value AS REAL) + ? AS TEXT) WHERE key = 'bankroll'`,\n args: [result.profit] },\n ]);\n settled.push({ ...bet, status: result.status, profit: result.profit, settledAt });\n }\n\n return { settled, bankroll: await getBankroll() };\n}\n\n/** Reset the entire game: bankroll back to start, all bets cleared. */\nexport async function resetBankroll(): Promise<{ bankroll: number }> {\n await sqlite.batch([\n { sql: `DELETE FROM bets` },\n { sql: `UPDATE meta SET value = ? WHERE key = 'bankroll'`, args: [String(STARTING_BANKROLL)] },\n ]);\n return { bankroll: STARTING_BANKROLL };\n}\n\n/** Overall record from settled bets. */\nexport async function getRecord(): Promise<{ wins: number; losses: number; pushes: number }> {\n const r: any[] = (await sqlite.execute(`SELECT status, COUNT(*) as n FROM bets WHERE status IN ('win','loss','push') GROUP BY status`)).rows;\n const rec = { wins: 0, losses: 0, pushes: 0 };\n for (const row of r) {\n if (row.status === \"win\") rec.wins = Number(row.n);\n else if (row.status === \"loss\") rec.losses = Number(row.n);\n else if (row.status === \"push\") rec.pushes = Number(row.n);\n }\n return rec;\n}\n","deleted",false,"label",[47,24],"lib","bd982b4e-7d01-4dd7-b746-c1f70fbfa9e8",["D",1788918736700],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","NFL pick'em & simulated bankroll betting app with real ESPN data","imageUrl","userId","f9e3ca71-3efe-459f-8238-02505cd1e34e","pinnedFileId","01a083dd-a784-740f-ad04-36397e47d99f","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a083da-e415-7538-8e5b-1c2e98dba80b","tursoName","bd982b4e7d014dd7b746c1f70fbfa9e8","tursoHostname","bd982b4e7d014dd7b746c1f70fbfa9e8-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789530642963],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_109":105},"org",{"_9":10,"_102":103,"_104":105,"_58":59,"_106":107,"_108":44},"branch",{"_37":92,"_11":93,"_22":30,"_94":48,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":12,"_101":10},"isOwned",30,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Michael Freedman","avatar","https://lh3.googleusercontent.com/a/ACg8ocLNlBCcJsODlTN6IwagSlTpF8cuTaIF5s9T-KOXm8gKP1cMrQ=s96-c","tier","free","canRestrictVals","profileImageUrl","ctx",{"_85":-5,"_143":144,"_145":146,"_147":148,"_149":44,"_150":44,"_151":44,"_152":34,"_153":-5,"_154":-7,"_155":-7,"_156":66,"_157":44,"_158":44,"_159":-5,"_160":44,"_161":44,"_162":44,"_163":-5},"ENV",{"_114":115,"_116":117,"_118":93,"_119":120,"_121":122,"_123":124,"_125":126,"_127":128,"_129":130,"_131":132,"_133":134,"_135":136,"_137":138,"_139":140,"_141":142},"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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]