Comedy Night Vote

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_154":155,"_156":157},"routes/_app.x.$handle.$name",{"_94":93,"_32":45,"_103":84,"_27":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":25,"_118":119,"_120":121,"_122":-5,"_123":-5,"_124":125},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":77,"_78":79,"_80":81,"_82":25},"version",8,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","6d70a462-5217-11f1-bc95-ee650bb23af1","name","fileType","http","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst ADMIN_PASSWORD = \"comedy2026\";\n\n// ── DB SETUP ──────────────────────────────────────────────────────\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS comedians (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n bio TEXT DEFAULT '',\n country TEXT DEFAULT 'Ireland',\n photo TEXT DEFAULT ''\n)`);\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS votes (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n comedian_id INTEGER NOT NULL\n)`);\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS settings (\n key TEXT PRIMARY KEY,\n value TEXT NOT NULL\n)`);\nawait sqlite.execute(\n `INSERT OR IGNORE INTO settings (key, value) VALUES ('voting_open', 'false')`,\n);\n\n// ── HELPERS ───────────────────────────────────────────────────────\nasync function getComedians() {\n const r = await sqlite.execute(`SELECT * FROM comedians ORDER BY id ASC`);\n return r.rows.map(([id, name, bio, country, photo]) => ({\n id,\n name,\n bio,\n country,\n photo,\n }));\n}\nasync function getVotes() {\n const r = await sqlite.execute(\n `SELECT comedian_id, COUNT(*) as count FROM votes GROUP BY comedian_id`,\n );\n const out: Record = {};\n r.rows.forEach(([id, count]) => {\n out[Number(id)] = Number(count);\n });\n return out;\n}\nasync function getVotingOpen() {\n const r = await sqlite.execute(\n `SELECT value FROM settings WHERE key='voting_open'`,\n );\n return r.rows[0][0] === \"true\";\n}\n\n// ── ROUTER ────────────────────────────────────────────────────────\nexport default async function handler(req: Request): Promise {\n const url = new URL(req.url);\n const path = url.pathname;\n\n const cors = {\n \"Access-Control-Allow-Origin\": \"*\",\n \"Content-Type\": \"application/json\",\n };\n\n // GET /api/state — full state for polling\n if (req.method === \"GET\" && path === \"/api/state\") {\n const [comedians, votes, votingOpen] = await Promise.all([\n getComedians(),\n getVotes(),\n getVotingOpen(),\n ]);\n return new Response(JSON.stringify({ comedians, votes, votingOpen }), {\n headers: cors,\n });\n }\n\n // POST /api/vote\n if (req.method === \"POST\" && path === \"/api/vote\") {\n const { comedian_id } = await req.json();\n const open = await getVotingOpen();\n if (!open) {\n return new Response(JSON.stringify({ error: \"Voting is closed\" }), {\n status: 403,\n headers: cors,\n });\n }\n await sqlite.execute(`INSERT INTO votes (comedian_id) VALUES (?)`, [\n comedian_id,\n ]);\n return new Response(JSON.stringify({ ok: true }), { headers: cors });\n }\n\n // POST /api/admin — all admin actions require password\n if (req.method === \"POST\" && path === \"/api/admin\") {\n const body = await req.json();\n if (body.password !== ADMIN_PASSWORD) {\n return new Response(JSON.stringify({ error: \"Unauthorized\" }), {\n status: 401,\n headers: cors,\n });\n }\n const { action } = body;\n\n if (action === \"set_voting\") {\n await sqlite.execute(\n `UPDATE settings SET value=? WHERE key='voting_open'`,\n [body.open ? \"true\" : \"false\"],\n );\n return new Response(JSON.stringify({ ok: true }), { headers: cors });\n }\n if (action === \"add_comedian\") {\n await sqlite.execute(\n `INSERT INTO comedians (name,bio,country,photo) VALUES (?,?,?,?)`,\n [\n body.name,\n body.bio || \"\",\n body.country || \"Ireland\",\n body.photo || \"\",\n ],\n );\n return new Response(JSON.stringify({ ok: true }), { headers: cors });\n }\n if (action === \"edit_comedian\") {\n await sqlite.execute(\n `UPDATE comedians SET name=?,bio=?,country=?,photo=? WHERE id=?`,\n [\n body.name,\n body.bio || \"\",\n body.country || \"Ireland\",\n body.photo || \"\",\n body.id,\n ],\n );\n return new Response(JSON.stringify({ ok: true }), { headers: cors });\n }\n if (action === \"remove_comedian\") {\n await sqlite.execute(`DELETE FROM comedians WHERE id=?`, [body.id]);\n await sqlite.execute(`DELETE FROM votes WHERE comedian_id=?`, [body.id]);\n return new Response(JSON.stringify({ ok: true }), { headers: cors });\n }\n if (action === \"reset_votes\") {\n await sqlite.execute(`DELETE FROM votes`);\n return new Response(JSON.stringify({ ok: true }), { headers: cors });\n }\n return new Response(JSON.stringify({ error: \"Unknown action\" }), {\n status: 400,\n headers: cors,\n });\n }\n\n // Serve HTML for all other requests\n return new Response(getHTML(req.url), {\n headers: { \"Content-Type\": \"text/html;charset=utf-8\" },\n });\n}\n\n// ── FRONTEND HTML ─────────────────────────────────────────────────\nfunction getHTML(reqUrl: string): string {\n const base = new URL(reqUrl).origin;\n return 'Comedy Night Vote' +\n '

Diff · v8