[{"_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","RT_Brandt","name","throne-ledger","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/RT_Brandt/throne-ledger/code/lib/db.ts","extension","id","eae8ca36-99f5-4ff1-9c84-ee39190c89bd","db.ts","fileId","9a6a2df6-b010-11f1-af0e-1607ee4eb77e","parentId","36d116d1-be79-439b-af80-39fd2bb6eeb1","branchId","649b81a3-ef64-48e6-b6db-ab0a767348e2","branchVersion",142,"latest",true,"createdAt",["D",1789378199721],"version",8,"fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { hashPassword, newId } from \"./crypto.ts\";\n\nexport { sqlite };\n\nexport const STARTING_BALANCE = 1000;\nexport const SESSION_TTL_MS = 1000 * 60 * 60 * 24 * 14; // 14 days\n\n/** Selling a position back to the house returns this fraction of the stake. */\nexport const SELLBACK_RATE = 0.9;\n\n/**\n * The Overseer's levy on every wager. Taken out of the stake, not the\n * wallet: bid 100 and 100 leaves your purse, 1 is levied, and 99 is what\n * actually sits in the pot and earns you a share of it. The levy leaves\n * circulation entirely; it does not join the pot.\n *\n * The levy always rounds UP to a whole Gelt, so the Overseer is never\n * shorted by a fractional remainder.\n */\nexport const TAX_RATE = 0.01;\n\n/** gross -> { tax, net }. The levy rounds up; the pot gets the rest. */\nexport function applyLevy(gross: number): { tax: number; net: number } {\n const tax = Math.ceil(gross * TAX_RATE);\n return { tax, net: gross - tax };\n}\n\n/**\n * Rounding up means a small enough bid would be entirely consumed by the\n * levy, leaving a position with nothing in the pot. That is not merely\n * useless: a zero stake pays nothing, and if it were the only backing on\n * the winning outcome the pool would read as empty and the whole pot\n * would go to the house instead. So bids below this are refused outright.\n * Derived from the rate rather than hardcoded, so changing TAX_RATE\n * cannot silently reopen the hole.\n */\nexport const MIN_BID = (() => {\n for (let g = 1; g <= 10000; g++) {\n if (g - Math.ceil(g * TAX_RATE) >= 1) return g;\n }\n return 2;\n})();\n\n/**\n * Schema notes\n *\n * This is a parimutuel (pool) market, not a fixed-odds book. Nobody sets\n * payout rates: every stake on a bet goes into one pot, and when the bet\n * resolves the whole pot is split among backers of the winning outcome in\n * proportion to what each of them put in. So odds are an emergent property\n * of where the money sits, and they move as people bet.\n *\n * bets.forfeited holds the 10% skimmed from positions sold back early.\n * It stays in the pot and is paid out to whoever eventually wins, which\n * gives holders a small edge over churners.\n *\n * wagers.status: pending | won | lost | sold | void\n */\n\nconst DDL = [\n `CREATE TABLE IF NOT EXISTS meta (\n key TEXT PRIMARY KEY,\n value TEXT NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS users (\n id TEXT PRIMARY KEY,\n username TEXT NOT NULL,\n username_lower TEXT NOT NULL UNIQUE,\n password_hash TEXT NOT NULL,\n balance INTEGER NOT NULL DEFAULT ${STARTING_BALANCE},\n is_admin INTEGER NOT NULL DEFAULT 0,\n wins INTEGER NOT NULL DEFAULT 0,\n losses INTEGER NOT NULL DEFAULT 0,\n failed_attempts INTEGER NOT NULL DEFAULT 0,\n locked_until INTEGER NOT NULL DEFAULT 0,\n created_at INTEGER NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS sessions (\n token_hash TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n created_at INTEGER NOT NULL,\n expires_at INTEGER NOT NULL\n )`,\n `CREATE INDEX IF NOT EXISTS idx_sessions_user ON sessions(user_id)`,\n `CREATE TABLE IF NOT EXISTS bets (\n id TEXT PRIMARY KEY,\n title TEXT NOT NULL,\n description TEXT NOT NULL DEFAULT '',\n status TEXT NOT NULL DEFAULT 'open',\n closes_at INTEGER NOT NULL,\n winning_option_id TEXT,\n forfeited INTEGER NOT NULL DEFAULT 0,\n created_at INTEGER NOT NULL,\n resolved_at INTEGER\n )`,\n `CREATE TABLE IF NOT EXISTS bet_options (\n id TEXT PRIMARY KEY,\n bet_id TEXT NOT NULL,\n label TEXT NOT NULL,\n sort_order INTEGER NOT NULL DEFAULT 0\n )`,\n `CREATE INDEX IF NOT EXISTS idx_options_bet ON bet_options(bet_id)`,\n `CREATE TABLE IF NOT EXISTS wagers (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n bet_id TEXT NOT NULL,\n option_id TEXT NOT NULL,\n stake INTEGER NOT NULL,\n tax INTEGER NOT NULL DEFAULT 0,\n status TEXT NOT NULL DEFAULT 'pending',\n payout INTEGER NOT NULL DEFAULT 0,\n created_at INTEGER NOT NULL,\n settled_at INTEGER\n )`,\n `CREATE INDEX IF NOT EXISTS idx_wagers_bet ON wagers(bet_id)`,\n `CREATE INDEX IF NOT EXISTS idx_wagers_user ON wagers(user_id)`,\n // One snapshot per round of the war engine. Keeping every round means\n // the Overseer can roll back a bad advance instead of rebuilding.\n // `log` holds that round's blow-by-blow, for writeups.\n `CREATE TABLE IF NOT EXISTS campaign_rounds (\n round INTEGER PRIMARY KEY,\n save_code TEXT NOT NULL,\n log TEXT NOT NULL DEFAULT '',\n note TEXT NOT NULL DEFAULT '',\n created_at INTEGER NOT NULL\n )`,\n];\n\nlet readyPromise: Promise | null = null;\n\n/** Idempotent. Safe to await on every request; the work happens once per isolate. */\nexport function ready(): Promise {\n if (!readyPromise) readyPromise = boot();\n return readyPromise;\n}\n\nasync function boot(): Promise {\n for (const stmt of DDL) await sqlite.execute(stmt);\n await migrate();\n await seedAdmin();\n await pruneSessions();\n}\n\nasync function columnsOf(table: string): Promise {\n const res = await sqlite.execute(`PRAGMA table_info(${table})`);\n return res.rows.map((r: any) => String(r.name ?? r[1]));\n}\n\n/**\n * Moves a fixed-odds database (multipliers baked into each option and\n * wager) onto the pool model. Existing rows are preserved.\n */\nasync function migrate(): Promise {\n // bets.forfeited\n const betCols = await columnsOf(\"bets\");\n if (!betCols.includes(\"forfeited\")) {\n await sqlite.execute(\n \"ALTER TABLE bets ADD COLUMN forfeited INTEGER NOT NULL DEFAULT 0\",\n );\n console.log(\"migration: added bets.forfeited\");\n }\n\n // bet_options loses multiplier\n const optCols = await columnsOf(\"bet_options\");\n if (optCols.includes(\"multiplier\")) {\n await sqlite.batch([\n { sql: `CREATE TABLE bet_options_new (\n id TEXT PRIMARY KEY, bet_id TEXT NOT NULL,\n label TEXT NOT NULL, sort_order INTEGER NOT NULL DEFAULT 0)` },\n { sql: `INSERT INTO bet_options_new (id, bet_id, label, sort_order)\n SELECT id, bet_id, label, sort_order FROM bet_options` },\n { sql: `DROP TABLE bet_options` },\n { sql: `ALTER TABLE bet_options_new RENAME TO bet_options` },\n { sql: `CREATE INDEX IF NOT EXISTS idx_options_bet ON bet_options(bet_id)` },\n ], \"write\");\n console.log(\"migration: dropped bet_options.multiplier\");\n }\n\n // wagers lose multiplier + potential_return (payouts are now computed at resolve)\n const wagerCols = await columnsOf(\"wagers\");\n if (wagerCols.includes(\"multiplier\") || wagerCols.includes(\"potential_return\")) {\n await sqlite.batch([\n { sql: `CREATE TABLE wagers_new (\n id TEXT PRIMARY KEY, user_id TEXT NOT NULL, bet_id TEXT NOT NULL,\n option_id TEXT NOT NULL, stake INTEGER NOT NULL,\n status TEXT NOT NULL DEFAULT 'pending',\n payout INTEGER NOT NULL DEFAULT 0,\n created_at INTEGER NOT NULL, settled_at INTEGER)` },\n { sql: `INSERT INTO wagers_new (id, user_id, bet_id, option_id, stake, status, payout, created_at, settled_at)\n SELECT id, user_id, bet_id, option_id, stake, status, payout, created_at, settled_at FROM wagers` },\n { sql: `DROP TABLE wagers` },\n { sql: `ALTER TABLE wagers_new RENAME TO wagers` },\n { sql: `CREATE INDEX IF NOT EXISTS idx_wagers_bet ON wagers(bet_id)` },\n { sql: `CREATE INDEX IF NOT EXISTS idx_wagers_user ON wagers(user_id)` },\n ], \"write\");\n console.log(\"migration: dropped wagers.multiplier and potential_return\");\n }\n\n // wagers.tax: pre-levy wagers simply recorded nothing, which is correct\n // for them since no levy was taken.\n const wagerCols2 = await columnsOf(\"wagers\");\n if (!wagerCols2.includes(\"tax\")) {\n await sqlite.execute(\n \"ALTER TABLE wagers ADD COLUMN tax INTEGER NOT NULL DEFAULT 0\",\n );\n console.log(\"migration: added wagers.tax\");\n }\n\n // campaign_rounds.log: rounds recorded before the log was kept simply\n // have none, which is accurate.\n const roundCols = await columnsOf(\"campaign_rounds\");\n if (!roundCols.includes(\"log\")) {\n await sqlite.execute(\n \"ALTER TABLE campaign_rounds ADD COLUMN log TEXT NOT NULL DEFAULT ''\",\n );\n console.log(\"migration: added campaign_rounds.log\");\n }\n\n await sqlite.execute({\n sql: \"INSERT OR REPLACE INTO meta (key, value) VALUES ('schema_version', '4')\",\n args: [],\n });\n}\n\n/**\n * The admin account is created from environment variables, never from\n * source code. If ADMIN_PASSWORD is absent the account is simply not\n * created and the admin panel stays unreachable.\n */\nasync function seedAdmin(): Promise {\n const username = (Deno.env.get(\"ADMIN_USERNAME\") || \"admin\").trim();\n const password = Deno.env.get(\"ADMIN_PASSWORD\");\n if (!password) {\n console.warn(\"ADMIN_PASSWORD not set - no admin account will exist.\");\n return;\n }\n\n const existing = await sqlite.execute({\n sql: \"SELECT id FROM users WHERE username_lower = ?\",\n args: [username.toLowerCase()],\n });\n if (existing.rows.length > 0) {\n await sqlite.execute({\n sql: \"UPDATE users SET is_admin = 1 WHERE username_lower = ?\",\n args: [username.toLowerCase()],\n });\n return;\n }\n\n await sqlite.execute({\n sql: `INSERT INTO users\n (id, username, username_lower, password_hash, balance, is_admin, created_at)\n VALUES (?, ?, ?, ?, 0, 1, ?)`,\n args: [\n newId(\"usr\"),\n username,\n username.toLowerCase(),\n await hashPassword(password),\n Date.now(),\n ],\n });\n console.log(`Seeded admin account \"${username}\".`);\n}\n\nasync function pruneSessions(): Promise {\n await sqlite.execute({\n sql: \"DELETE FROM sessions WHERE expires_at < ?\",\n args: [Date.now()],\n });\n}\n\nexport type Row = Record;\n\nexport async function queryOne(sql: string, args: any[] = []): Promise {\n const res = await sqlite.execute({ sql, args });\n return res.rows.length ? (res.rows[0] as Row) : null;\n}\n\nexport async function queryAll(sql: string, args: any[] = []): Promise {\n const res = await sqlite.execute({ sql, args });\n return res.rows as Row[];\n}\n\nexport async function run(sql: string, args: any[] = []) {\n return await sqlite.execute({ sql, args });\n}\n","deleted",false,"label",[47,24],"lib","3acf27cf-bc0f-4f45-b440-a47608349aee",["D",1789371999223],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Imperial wager ledger for the Battle for the Hive campaign","imageUrl","userId","28c534b6-beee-40a1-be9c-43985b36185d","pinnedFileId","6b608f96-b010-11f1-9552-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a09ecc-b888-773d-b822-8340b04163b7","tursoName","3acf27cfbc0f4f45b440a47608349aee","tursoHostname","3acf27cfbc0f4f45b440a47608349aee-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789546246980],"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",173,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Garrick W","avatar","https://lh3.googleusercontent.com/a/ACg8ocIFL4o68YPM3Sv8WlUCusFPkUPZWiKW0FtIuul8fl9ATqyk3Xw=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","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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]