[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_163":164,"_165":166},"routes/_app.x.$handle.$name",{"_103":102,"_38":51,"_111":93,"_33":112,"_13":14,"_113":-5,"_11":114,"_115":116,"_117":118,"_119":120,"_121":122,"_26":-5,"_123":-5,"_124":-5,"_125":31,"_126":127,"_128":129,"_130":-5,"_131":-5,"_132":133},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_49":50,"_38":51,"_44":52,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":-5,"_59":-5,"_19":60,"_61":-5,"_62":31,"_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":31},"version",5,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","5344176d-2faa-45a3-ac48-24a4558ee570","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":34,"_39":40,"_41":43,"_44":45,"_46":14,"_47":48,"_30":31},"previous",{"_36":37,"_38":34,"_39":40,"_41":42},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","f34c8332-2b8c-11f1-ae27-42dde27851f2","name","fileType","http","content","/**\n * smoke-elo-backend — Val Town serverless backend for Elo-based smoke spot ranking.\n *\n * Endpoints:\n * POST /votes { winner, loser } → records vote, updates both Elos\n * GET /leaderboard → [{ fileName, elo, wins, losses }] sorted by elo desc\n * POST /backfill { votes: [{winner,loser}][] } → resets & recomputes all Elos from history\n */\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst CORS = {\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"GET, POST, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type\",\n};\n\nconst ELO_K = 32;\nconst ELO_START = 1500;\n\nfunction expectedScore(ratingA: number, ratingB: number): number {\n return 1 / (1 + Math.pow(10, (ratingB - ratingA) / 400));\n}\n\nfunction applyElo(winnerElo: number, loserElo: number): [number, number] {\n const expWinner = expectedScore(winnerElo, loserElo);\n const expLoser = expectedScore(loserElo, winnerElo);\n return [\n winnerElo + ELO_K * (1 - expWinner),\n loserElo + ELO_K * (0 - expLoser),\n ];\n}\n\nasync function initDb() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS smoke_elo_ratings (\n fileName TEXT PRIMARY KEY,\n elo REAL NOT NULL DEFAULT ${ELO_START},\n wins INTEGER NOT NULL DEFAULT 0,\n losses INTEGER NOT NULL DEFAULT 0\n )\n `);\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS smoke_elo_votes (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n winner TEXT NOT NULL,\n loser TEXT NOT NULL,\n voted_at INTEGER NOT NULL\n )\n `);\n}\n\nasync function getOrDefault(fileName: string): Promise<{ elo: number; wins: number; losses: number }> {\n const result = await sqlite.execute({\n sql: `SELECT elo, wins, losses FROM smoke_elo_ratings WHERE fileName = ?`,\n args: [fileName],\n });\n if (result.rows.length === 0) return { elo: ELO_START, wins: 0, losses: 0 };\n const row = result.rows[0];\n return { elo: row.elo as number, wins: row.wins as number, losses: row.losses as number };\n}\n\nasync function upsertElo(fileName: string, elo: number, wins: number, losses: number) {\n await sqlite.execute({\n sql: `INSERT INTO smoke_elo_ratings (fileName, elo, wins, losses) VALUES (?, ?, ?, ?)\n ON CONFLICT(fileName) DO UPDATE SET elo = excluded.elo, wins = excluded.wins, losses = excluded.losses`,\n args: [fileName, elo, wins, losses],\n });\n}\n\nexport default async function handler(req: Request): Promise {\n if (req.method === \"OPTIONS\") {\n return new Response(null, { headers: CORS });\n }\n\n await initDb();\n\n const url = new URL(req.url);\n\n // POST /votes — record one vote and update Elos\n if (req.method === \"POST\" && url.pathname === \"/votes\") {\n const { winner, loser } = await req.json() as { winner: string; loser: string };\n\n const winnerData = await getOrDefault(winner);\n const loserData = await getOrDefault(loser);\n\n const [newWinnerElo, newLoserElo] = applyElo(winnerData.elo, loserData.elo);\n\n await upsertElo(winner, newWinnerElo, winnerData.wins + 1, winnerData.losses);\n await upsertElo(loser, newLoserElo, loserData.wins, loserData.losses + 1);\n\n await sqlite.execute({\n sql: `INSERT INTO smoke_elo_votes (winner, loser, voted_at) VALUES (?, ?, ?)`,\n args: [winner, loser, Date.now()],\n });\n\n return new Response(JSON.stringify({ ok: true }), {\n status: 201,\n headers: { ...CORS, \"Content-Type\": \"application/json\" },\n });\n }\n\n // GET /leaderboard — return all locations sorted by Elo descending\n if (req.method === \"GET\" && url.pathname === \"/leaderboard\") {\n const result = await sqlite.execute(\n `SELECT fileName, elo, wins, losses FROM smoke_elo_ratings ORDER BY elo DESC`,\n );\n\n const leaderboard = result.rows.map((row) => ({\n fileName: row.fileName as string,\n elo: Math.round(row.elo as number),\n wins: row.wins as number,\n losses: row.losses as number,\n }));\n\n return new Response(JSON.stringify(leaderboard), {\n headers: { ...CORS, \"Content-Type\": \"application/json\" },\n });\n }\n\n // POST /backfill — reset all Elos and recompute from a provided chronological vote list.\n // Body: { votes: Array<{ winner: string; loser: string }> }\n if (req.method === \"POST\" && url.pathname === \"/backfill\") {\n const { votes } = await req.json() as { votes: Array<{ winner: string; loser: string }> };\n\n // Reset\n await sqlite.execute(`DELETE FROM smoke_elo_ratings`);\n await sqlite.execute(`DELETE FROM smoke_elo_votes`);\n\n // Replay votes in order\n const eloMap: Record = {};\n\n for (const { winner, loser } of votes) {\n const w = eloMap[winner] ?? { elo: ELO_START, wins: 0, losses: 0 };\n const l = eloMap[loser] ?? { elo: ELO_START, wins: 0, losses: 0 };\n const [newW, newL] = applyElo(w.elo, l.elo);\n eloMap[winner] = { elo: newW, wins: w.wins + 1, losses: w.losses };\n eloMap[loser] = { elo: newL, wins: l.wins, losses: l.losses + 1 };\n }\n\n for (const [fileName, { elo, wins, losses }] of Object.entries(eloMap)) {\n await upsertElo(fileName, elo, wins, losses);\n }\n\n return new Response(\n JSON.stringify({ ok: true, locations: Object.keys(eloMap).length, votes: votes.length }),\n { headers: { ...CORS, \"Content-Type\": \"application/json\" } },\n );\n }\n\n return new Response(\"Not Found\", { status: 404, headers: CORS });\n}\n","/**\n * smoke-elo-backend — Val Town serverless backend for Elo-based smoke spot ranking.\n *\n * Endpoints:\n * POST /votes { winner, loser } → records vote, updates both Elos\n * GET /leaderboard → [{ fileName, elo, wins, losses }] sorted by elo desc\n * POST /backfill { votes: [{winner,loser,voted_at?}][] } → resets & recomputes all Elos from history\n */\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst CORS = {\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"GET, POST, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type\",\n};\n\nconst ELO_K = 32;\nconst ELO_START = 1500;\n\nfunction expectedScore(ratingA: number, ratingB: number): number {\n return 1 / (1 + Math.pow(10, (ratingB - ratingA) / 400));\n}\n\nfunction applyElo(winnerElo: number, loserElo: number): [number, number] {\n const expWinner = expectedScore(winnerElo, loserElo);\n const expLoser = expectedScore(loserElo, winnerElo);\n return [\n winnerElo + ELO_K * (1 - expWinner),\n loserElo + ELO_K * (0 - expLoser),\n ];\n}\n\nasync function initDb() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS smoke_elo_ratings (\n fileName TEXT PRIMARY KEY,\n elo REAL NOT NULL DEFAULT ${ELO_START},\n wins INTEGER NOT NULL DEFAULT 0,\n losses INTEGER NOT NULL DEFAULT 0\n )\n `);\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS smoke_elo_votes (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n winner TEXT NOT NULL,\n loser TEXT NOT NULL,\n voted_at INTEGER NOT NULL\n )\n `);\n}\n\nasync function getOrDefault(fileName: string): Promise<{ elo: number; wins: number; losses: number }> {\n const result = await sqlite.execute({\n sql: `SELECT elo, wins, losses FROM smoke_elo_ratings WHERE fileName = ?`,\n args: [fileName],\n });\n if (result.rows.length === 0) return { elo: ELO_START, wins: 0, losses: 0 };\n const row = result.rows[0];\n return { elo: row.elo as number, wins: row.wins as number, losses: row.losses as number };\n}\n\nasync function upsertElo(fileName: string, elo: number, wins: number, losses: number) {\n await sqlite.execute({\n sql: `INSERT INTO smoke_elo_ratings (fileName, elo, wins, losses) VALUES (?, ?, ?, ?)\n ON CONFLICT(fileName) DO UPDATE SET elo = excluded.elo, wins = excluded.wins, losses = excluded.losses`,\n args: [fileName, elo, wins, losses],\n });\n}\n\nexport default async function handler(req: Request): Promise {\n if (req.method === \"OPTIONS\") {\n return new Response(null, { headers: CORS });\n }\n\n await initDb();\n\n const url = new URL(req.url);\n\n // POST /votes — record one vote and update Elos\n if (req.method === \"POST\" && url.pathname === \"/votes\") {\n const { winner, loser } = await req.json() as { winner: string; loser: string };\n\n const winnerData = await getOrDefault(winner);\n const loserData = await getOrDefault(loser);\n\n const [newWinnerElo, newLoserElo] = applyElo(winnerData.elo, loserData.elo);\n\n await upsertElo(winner, newWinnerElo, winnerData.wins + 1, winnerData.losses);\n await upsertElo(loser, newLoserElo, loserData.wins, loserData.losses + 1);\n\n await sqlite.execute({\n sql: `INSERT INTO smoke_elo_votes (winner, loser, voted_at) VALUES (?, ?, ?)`,\n args: [winner, loser, Date.now()],\n });\n\n return new Response(JSON.stringify({ ok: true }), {\n status: 201,\n headers: { ...CORS, \"Content-Type\": \"application/json\" },\n });\n }\n\n // GET /leaderboard — return all locations sorted by Elo descending\n if (req.method === \"GET\" && url.pathname === \"/leaderboard\") {\n const result = await sqlite.execute(\n `SELECT fileName, elo, wins, losses FROM smoke_elo_ratings ORDER BY elo DESC`,\n );\n\n const leaderboard = result.rows.map((row) => ({\n fileName: row.fileName as string,\n elo: Math.round(row.elo as number),\n wins: row.wins as number,\n losses: row.losses as number,\n }));\n\n return new Response(JSON.stringify(leaderboard), {\n headers: { ...CORS, \"Content-Type\": \"application/json\" },\n });\n }\n\n // POST /backfill — reset all Elos and recompute from a provided chronological vote list.\n // Body: { votes: Array<{ winner: string; loser: string }> }\n if (req.method === \"POST\" && url.pathname === \"/backfill\") {\n const { votes } = await req.json() as { votes: Array<{ winner: string; loser: string }> };\n\n // Reset\n await sqlite.execute(`DELETE FROM smoke_elo_ratings`);\n await sqlite.execute(`DELETE FROM smoke_elo_votes`);\n\n // Replay votes in order\n const eloMap: Record = {};\n\n for (const { winner, loser } of votes) {\n const w = eloMap[winner] ?? { elo: ELO_START, wins: 0, losses: 0 };\n const l = eloMap[loser] ?? { elo: ELO_START, wins: 0, losses: 0 };\n const [newW, newL] = applyElo(w.elo, l.elo);\n eloMap[winner] = { elo: newW, wins: w.wins + 1, losses: w.losses };\n eloMap[loser] = { elo: newL, wins: l.wins, losses: l.losses + 1 };\n }\n\n for (const [fileName, { elo, wins, losses }] of Object.entries(eloMap)) {\n await upsertElo(fileName, elo, wins, losses);\n }\n\n return new Response(\n JSON.stringify({ ok: true, locations: Object.keys(eloMap).length, votes: votes.length }),\n { headers: { ...CORS, \"Content-Type\": \"application/json\" } },\n );\n }\n\n return new Response(\"Not Found\", { status: 404, headers: CORS });\n}\n","createdAt",["D",1774819128211],"branchVersion","branchId","0d96a52a-2b8c-11f1-a08f-42dde27851f2","id","0d966e66-2b8c-11f1-a08f-42dde27851f2","smoke_elo_backend",["D",1774801594853],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","a1d0e4c8-d265-47e7-85e3-a6792491909e","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","7f65624b-9d7b-4602-8ad8-76f192e91e6d","tursoName","0d966e662b8c11f1a08f42dde27851f2","tursoHostname","0d966e662b8c11f1a08f42dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789516253896],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_103":102,"_110":106},"org",{"_103":102,"_104":-5,"_105":106,"_19":60,"_107":108,"_109":31},"branch",{"_13":92,"_38":93,"_49":48,"_94":50,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":51,"_101":102},"isOwned",6,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","malloc","handle","displayName","avatar","https://images.clerk.dev/oauth_github/img_2P7WUduqm1PfyC50trwmmnvym5L.jpeg","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_49":50,"_38":51,"_44":158,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":-5,"_59":-5,"_19":60,"_61":-5,"_62":31,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":70,"_71":72,"_73":159,"_75":-5,"_76":77,"_78":77,"_79":80,"_81":80,"_82":80,"_83":77,"_84":77,"_85":160,"_87":161,"_89":162,"_91":31},"tree",[153],"files",[153],"counts",{"_142":66,"_143":144,"_145":66,"_146":147,"_148":149},"contents",[134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_49":135,"_38":34,"_36":37,"_136":-5,"_47":48,"_46":14,"_137":31,"_44":138,"_13":139,"_39":40,"_41":43,"_30":31,"_140":-5,"_33":141},"e04a9e40-2bb4-11f1-9716-42dde27851f2","parentId","latest",["D",1774819128211],2,"label",[34],"pulls","branches",1,"forks","envVars",{"_150":66,"_152":66},"connections",{"_150":66,"_151":66},"count","unfilledCount","emptyCount",{"_49":135,"_38":34,"_36":37,"_136":-5,"_47":48,"_46":14,"_137":31,"_44":154,"_13":139,"_39":40,"_41":43,"_30":31,"_140":-5,"_155":156,"_33":157},["D",1774819128211],"children",[],[34],["D",1774801594853],["D",1789516253896],{"_103":102,"_110":106},{"_103":102,"_104":-5,"_105":106,"_19":60,"_107":108,"_109":31},{"_13":92,"_38":93,"_49":48,"_94":50,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":51,"_101":102},"ctx",{"_85":-5,"_131":196,"_197":198,"_199":200,"_201":31,"_202":31,"_203":31,"_204":129,"_205":-5,"_206":-7,"_207":-7,"_208":66,"_209":31,"_210":31,"_211":-5,"_212":31,"_213":31,"_214":31,"_215":-5},"ENV",{"_167":168,"_169":170,"_171":93,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195},"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",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v5