Create/Edit Event

\n \n

Event Created!

Event ID:

Secret:

\n Answer Link |\n Edit Link (save this!)\n

\n \n Email me the edit link:\n \n \n \n

\n \n

Event Statistics

\n \n

✓ Event updated!

\n Answer Link |\n Edit Link (save this!) |\n Create new doodle →\n

\n \n\n \n\n`;\n\n return new Response(html, {\n headers: { 'Content-Type': 'text/html' }\n });\n}",[],[183],{"_103":191,"_95":192,"_156":193,"_158":-5,"_159":137,"_160":136,"_161":162,"_105":194,"_100":32,"_164":186,"_166":195,"_168":22,"_169":-5,"_170":196,"_98":197},"997cbb96-53b6-11f0-bb79-f69ea79377d9","answer.http.ts","6fe7298c-07b6-42bc-a596-a312203b661f",["D",1751070417185],"export default async function(req: Request) {\n const url = new URL(req.url);\n const eventId = url.searchParams.get('event');\n const personId = url.searchParams.get('person_id');\n const answerSecret = url.searchParams.get('secret');\n \n if (!eventId) {\n return new Response('Missing event parameter', { status: 400 });\n }\n \n const html = `\n\n\n \n \n Answer Event\n \n\n\n

Loading...

\n \n

✓ Answer submitted!

Save this link to change your answer later:

\n \n

\n \n Email me this link:\n \n \n \n

\n \n

Current Results

\n \n

\n \n \n\n \n\n`;\n\n return new Response(html, {\n headers: { 'Content-Type': 'text/html' }\n });\n}",[],[192],{"_103":199,"_95":200,"_156":201,"_158":-5,"_159":137,"_160":136,"_161":162,"_105":202,"_100":32,"_164":165,"_166":203,"_168":22,"_169":-5,"_170":204,"_98":205},"997ccb4a-53b6-11f0-bb79-f69ea79377d9","deno.json","e7bf3643-ff40-4b5a-be6f-d13d79f001d6",["D",1751070417185],"{\n \"$schema\": \"https://raw.githubusercontent.com/denoland/deno/348900b8b79f4a434cab4c74b3bc8d4d2fa8ee74/cli/schemas/config-file.v1.json\",\n \"lock\": false,\n \"compilerOptions\": {\n \"noImplicitAny\": false,\n \"strict\": false,\n \"types\": [\n \"https://www.val.town/types/valtown.d.ts\"\n ],\n \"lib\": [\n \"dom\",\n \"dom.iterable\",\n \"dom.asynciterable\",\n \"deno.ns\",\n \"deno.unstable\"\n ]\n },\n \"lint\": {\n \"files\": {\n \"include\": [\n \"deno:/https/esm.town/**/*\"\n ]\n },\n \"rules\": {\n \"exclude\": [\n \"no-explicit-any\"\n ]\n }\n },\n \"node_modules_dir\": false,\n \"experimental\": {\n \"unstable-node-globals\": true,\n \"unstable-temporal\": true,\n \"unstable-worker-options\": true,\n \"unstable-sloppy-imports\": true\n }\n}",[],[200],{"_103":207,"_95":99,"_156":208,"_158":-5,"_159":137,"_160":136,"_161":162,"_105":209,"_100":32,"_164":210,"_166":211,"_168":22,"_169":-5,"_170":212,"_98":213},"997cccc6-53b6-11f0-bb79-f69ea79377d9","5e0060c5-367f-42ba-85dc-fed1cbbb85e8",["D",1751070417185],"http","import { Hono } from \"https://esm.sh/hono@latest\";\n\n// Import the API app (SQLite version)\nimport { app as apiApp } from \"./doodle_sqlite.http.ts\";\n\n// Import the page handlers\nimport adminHandler from \"./admin.http.ts\";\nimport answerHandler from \"./answer.http.ts\";\n\nconst app = new Hono();\n\n// Mount the API routes under /api\napp.route(\"/api\", apiApp);\n\n// Admin page (root)\napp.get(\"/\", async (c) => {\n // Update the admin handler to use relative API URLs\n const req = new Request(c.req.url);\n const response = await adminHandler(req);\n let html = await response.text();\n \n // Replace API URLs to use relative paths\n html = html.replace(/https:\\/\\/doodle-api\\.val\\.run/g, '/api');\n html = html.replace(/https:\\/\\/doodle-view\\.val\\.run/g, '');\n \n return c.html(html);\n});\n\n// Answer page\napp.get(\"/answer\", async (c) => {\n // Update the answer handler to use relative API URLs\n const req = new Request(c.req.url);\n const response = await answerHandler(req);\n let html = await response.text();\n \n // Replace API URLs to use relative paths\n html = html.replace(/https:\\/\\/doodle-api\\.val\\.run/g, '/api');\n html = html.replace(/https:\\/\\/doodle-admin\\.val\\.run/g, '');\n \n return c.html(html);\n});\n\nexport default app.fetch;",[],[99],{"_103":215,"_95":216,"_156":217,"_158":-5,"_159":137,"_160":136,"_161":162,"_105":218,"_100":32,"_164":186,"_166":219,"_168":22,"_169":-5,"_170":220,"_98":221},"997ccf78-53b6-11f0-bb79-f69ea79377d9","doodle_sqlite.http.ts","f1db7803-3b22-4d77-b01c-90a25f5537b4",["D",1751070417185],"import { Hono } from \"https://esm.sh/hono@latest\";\nimport { nanoid } from \"https://esm.sh/nanoid@latest\";\nimport { z } from \"https://esm.sh/zod@latest\";\nimport { email } from \"https://esm.town/v/std/email\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Initialize database tables\nasync function initDB() {\n // Events table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS events_v1 (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n options TEXT NOT NULL,\n secret TEXT NOT NULL,\n creator_email TEXT,\n created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Answers table with person_id\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS answers_v2 (\n event_id TEXT NOT NULL,\n person_id TEXT NOT NULL,\n person_name TEXT NOT NULL,\n option TEXT NOT NULL,\n secret TEXT NOT NULL,\n email TEXT,\n answered_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n PRIMARY KEY (event_id, person_id),\n FOREIGN KEY (event_id) REFERENCES events_v1(id)\n )\n `);\n\n // Create indexes for performance\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_answers_event_id ON answers_v2(event_id)\n `);\n}\n\n// Initialize DB on startup\nawait initDB();\n\n// Types and validation schemas\nconst CreateEventSchema = z.object({\n name: z.string().min(1),\n options: z.array(z.string()).optional(),\n creator_email: z.string().email().optional(),\n});\n\nconst UpdateEventSchema = z.object({\n name: z.string().min(1).optional(),\n options: z.array(z.string()).optional(),\n secret: z.string(),\n creator_email: z.string().email().optional().nullable(),\n});\n\nconst AnswerEventSchema = z.object({\n person_name: z.string().min(1),\n option: z.string(),\n email: z.string().email().optional(),\n});\n\nconst UpdateAnswerSchema = z.object({\n option: z.string().optional(),\n person_name: z.string().optional(),\n secret: z.string(),\n email: z.string().email().optional().nullable(),\n});\n\n// Create event endpoint\napp.post(\"/events\", async (c) => {\n const body = await c.req.json();\n const validation = CreateEventSchema.safeParse(body);\n \n if (!validation.success) {\n return c.json({ error: validation.error.flatten() }, 400);\n }\n\n const { name, options = [], creator_email } = validation.data;\n const id = nanoid(10);\n const secret = nanoid(20);\n \n await sqlite.execute(\n `INSERT INTO events_v1 (id, name, options, secret, creator_email) \n VALUES (?, ?, ?, ?, ?)`,\n [id, name, JSON.stringify(options), secret, creator_email || null]\n );\n \n return c.json({ id, secret });\n});\n\n// Update event endpoint\napp.patch(\"/events/:id\", async (c) => {\n const id = c.req.param(\"id\");\n const body = await c.req.json();\n const validation = UpdateEventSchema.safeParse(body);\n \n if (!validation.success) {\n return c.json({ error: validation.error.flatten() }, 400);\n }\n\n const { secret, name, options, creator_email } = validation.data;\n\n // Get existing event to verify secret\n const result = await sqlite.execute(\n `SELECT * FROM events_v1 WHERE id = ?`,\n [id]\n );\n \n if (result.rows.length === 0) {\n return c.json({ error: \"Event not found\" }, 404);\n }\n\n const event = result.rows[0];\n if (event.secret !== secret) {\n return c.json({ error: \"Invalid secret\" }, 403);\n }\n\n // Build dynamic update query\n const updates = [];\n const values = [];\n \n if (name !== undefined) {\n updates.push(\"name = ?\");\n values.push(name);\n }\n if (options !== undefined) {\n updates.push(\"options = ?\");\n values.push(JSON.stringify(options));\n }\n if (creator_email !== undefined) {\n updates.push(\"creator_email = ?\");\n values.push(creator_email);\n }\n \n if (updates.length > 0) {\n values.push(id);\n await sqlite.execute(\n `UPDATE events_v1 SET ${updates.join(\", \")} WHERE id = ?`,\n values\n );\n }\n \n return c.json({ success: true });\n});\n\n// Get event endpoint with stats\napp.get(\"/events/:id\", async (c) => {\n const id = c.req.param(\"id\");\n\n // Get event first\n const eventResult = await sqlite.execute(\n `SELECT * FROM events_v1 WHERE id = ?`,\n [id]\n );\n \n if (eventResult.rows.length === 0) {\n return c.json({ error: \"Event not found\" }, 404);\n }\n \n const event = eventResult.rows[0];\n const options = JSON.parse(event.options as string);\n \n // Get answers and stats\n const answerResult = await sqlite.execute(`\n SELECT \n option,\n person_name,\n person_id,\n COUNT(*) OVER (PARTITION BY option) as option_count\n FROM answers_v2\n WHERE event_id = ?\n ORDER BY option, person_name\n `, [id]);\n\n // Process the results\n const stats: Record = {};\n const answersByOption: Record = {};\n const participants = new Set();\n \n // Initialize all options\n for (const option of options) {\n stats[option] = 0;\n answersByOption[option] = [];\n }\n\n // Process answers\n const seenOptions = new Set();\n for (const row of answerResult.rows) {\n const option = row.option as string;\n const personName = row.person_name as string;\n \n participants.add(personName);\n \n // Set count once per option\n if (!seenOptions.has(option)) {\n stats[option] = row.option_count as number;\n seenOptions.add(option);\n }\n \n // Add person to option\n if (!answersByOption[option].includes(personName)) {\n answersByOption[option].push(personName);\n }\n }\n\n return c.json({\n name: event.name,\n options,\n stats,\n answers_by_option: answersByOption,\n total_participants: participants.size,\n ...(event.creator_email && { creator_email: event.creator_email }),\n });\n});\n\n// Submit answer endpoint\napp.post(\"/events/:id/answers\", async (c) => {\n const id = c.req.param(\"id\");\n const body = await c.req.json();\n const validation = AnswerEventSchema.safeParse(body);\n \n if (!validation.success) {\n return c.json({ error: validation.error.flatten() }, 400);\n }\n\n const { person_name, option, email } = validation.data;\n\n // Check if event exists and validate option\n const eventResult = await sqlite.execute(\n `SELECT options FROM events_v1 WHERE id = ?`,\n [id]\n );\n \n if (eventResult.rows.length === 0) {\n return c.json({ error: \"Event not found\" }, 404);\n }\n\n const options = JSON.parse(eventResult.rows[0].options as string);\n if (!options.includes(option)) {\n return c.json({ error: \"Invalid option\" }, 400);\n }\n\n // Generate new person_id for new submissions\n const personId = nanoid(10);\n const answerSecret = nanoid(20);\n\n // Insert new answer\n await sqlite.execute(`\n INSERT INTO answers_v2 (event_id, person_id, person_name, option, secret, email, answered_at)\n VALUES (?, ?, ?, ?, ?, ?, CURRENT_TIMESTAMP)\n `, [id, personId, person_name, option, answerSecret, email || null]);\n \n return c.json({ \n success: true, \n secret: answerSecret,\n person_id: personId \n });\n});\n\n// Get answer endpoint\napp.get(\"/events/:id/answers/:person_id\", async (c) => {\n const id = c.req.param(\"id\");\n const person_id = c.req.param(\"person_id\");\n\n const result = await sqlite.execute(\n `SELECT person_name, option, email, person_id \n FROM answers_v2 \n WHERE event_id = ? AND person_id = ?`,\n [id, person_id]\n );\n \n if (result.rows.length === 0) {\n return c.json({ error: \"Answer not found\" }, 404);\n }\n\n const answer = result.rows[0];\n return c.json({\n person_id: answer.person_id,\n person_name: answer.person_name,\n option: answer.option,\n ...(answer.email && { email: answer.email }),\n });\n});\n\n// Update answer endpoint\napp.patch(\"/events/:id/answers/:person_id\", async (c) => {\n const id = c.req.param(\"id\");\n const person_id = c.req.param(\"person_id\");\n const body = await c.req.json();\n const validation = UpdateAnswerSchema.safeParse(body);\n \n if (!validation.success) {\n return c.json({ error: validation.error.flatten() }, 400);\n }\n\n const { option, secret, email, person_name } = validation.data;\n\n // Get existing answer and verify secret\n const answerResult = await sqlite.execute(\n `SELECT secret, option as current_option FROM answers_v2 WHERE event_id = ? AND person_id = ?`,\n [id, person_id]\n );\n \n if (answerResult.rows.length === 0) {\n return c.json({ error: \"Answer not found\" }, 404);\n }\n\n if (answerResult.rows[0].secret !== secret) {\n return c.json({ error: \"Invalid secret\" }, 403);\n }\n\n // Verify option is valid if changing it\n if (option) {\n const eventResult = await sqlite.execute(\n `SELECT options FROM events_v1 WHERE id = ?`,\n [id]\n );\n \n if (eventResult.rows.length === 0) {\n return c.json({ error: \"Event not found\" }, 404);\n }\n\n const options = JSON.parse(eventResult.rows[0].options as string);\n if (!options.includes(option)) {\n return c.json({ error: \"Invalid option\" }, 400);\n }\n }\n\n // Build update query\n const updates = [\"answered_at = CURRENT_TIMESTAMP\"];\n const values = [];\n \n if (option) {\n updates.push(\"option = ?\");\n values.push(option);\n }\n \n if (person_name) {\n updates.push(\"person_name = ?\");\n values.push(person_name);\n }\n \n if (email !== undefined) {\n updates.push(\"email = ?\");\n values.push(email);\n }\n \n values.push(id, person_id);\n await sqlite.execute(\n `UPDATE answers_v2 SET ${updates.join(\", \")} \n WHERE event_id = ? AND person_id = ?`,\n values\n );\n \n return c.json({ success: true });\n});\n\n// Email endpoint\napp.post(\"/email\", async (c) => {\n const body = await c.req.json();\n const { to, subject, body: emailBody, html: htmlBody } = body;\n \n if (!to || !subject || (!emailBody && !htmlBody)) {\n return c.json({ error: \"Missing required fields: to, subject, body or html\" }, 400);\n }\n \n try {\n await email({\n to,\n subject,\n text: emailBody,\n html: htmlBody,\n });\n \n return c.json({ success: true, message: \"Email sent successfully\" });\n } catch (error) {\n console.error(\"Email send error:\", error);\n return c.json({ error: \"Failed to send email\" }, 500);\n }\n});\n\n// Health check\napp.get(\"/\", (c) => {\n const html = `\n\n\n \n \n Doodle API (SQLite)\n \n\n\n

Doodle API (SQLite Version)

A simple API for creating and managing doodle polls, now powered by SQLite.

\n \n

Available Endpoints

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

Method	Endpoint	Description
`POST`	`/events`	Create a new event
`PATCH`	`/events/:id`	Update event (requires secret)
`GET`	`/events/:id`	Get event details and stats
`GET`	`/events/:id/answers/:person_id`	Get individual answer details
`POST`	`/events/:id/answers`	Submit answer to event
`PATCH`	`/events/:id/answers/:person_id`	Update answer (requires secret)
`POST`	`/email`	Send email

\n \n \n

\n\n`;\n \n return c.html(html);\n});\n\nexport default app.fetch;\nexport { app };",[],[216],"files",[153,173,181,190,198,206,214],"counts",{"_226":32,"_227":136,"_228":32,"_229":230},"pulls","branches","forks","envVars",2,"contents",[],{"_103":207,"_95":99,"_156":208,"_158":-5,"_159":137,"_160":136,"_161":162,"_105":234,"_100":32,"_164":210,"_166":211,"_168":22,"_169":-5,"_98":235},["D",1751070417185],[99],"upstreamProject",{"_103":145,"_95":96,"_111":-5,"_112":-5,"_109":110,"_23":238},{"_93":239,"_129":240},"helge","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ5bVQ2S2dxbzA4dUltakRmbmtWcDBHY1NociJ9","upstreamBranch",{"_103":140,"_105":243,"_244":245,"_95":43,"_138":145,"_100":142,"_139":-5,"_141":-5,"_246":247,"_107":-5,"_150":22,"_109":110,"_149":239,"_16":147,"_148":96},["D",1750797052053],"updatedAt",["D",1750803527989],"lockfileKey","1755624155998-esm.town_v_helge_doodle@63-main","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.code.$",{"_93":94,"_95":96,"_97":43,"_100":-7,"_98":99,"_101":254,"_151":259,"_222":281,"_165":282,"_231":285,"_286":287,"_290":22,"_291":-5,"_292":32,"_293":32,"_294":295},{"_103":104,"_95":96,"_105":255,"_107":-5,"_108":22,"_109":110,"_111":-5,"_112":-5,"_14":113,"_114":-5,"_115":22,"_116":-5,"_117":32,"_16":118,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_23":256,"_131":257,"_134":258,"_150":22},["D",1751070417185],{"_93":94,"_129":130},{"_93":94,"_133":130},{"_100":136,"_95":43,"_103":137,"_138":104,"_139":140,"_141":142,"_143":110,"_144":145,"_146":147,"_148":96,"_149":94},[260,263,266,269,272,275,278],{"_103":154,"_95":155,"_156":157,"_158":-5,"_159":137,"_160":136,"_161":162,"_105":163,"_100":32,"_164":165,"_166":167,"_168":22,"_169":-5,"_170":261,"_98":262},[],[155],{"_103":174,"_95":175,"_156":176,"_158":-5,"_159":137,"_160":136,"_161":162,"_105":177,"_100":32,"_164":165,"_166":178,"_168":22,"_169":-5,"_170":264,"_98":265},[],[175],{"_103":182,"_95":183,"_156":184,"_158":-5,"_159":137,"_160":136,"_161":162,"_105":185,"_100":32,"_164":186,"_166":187,"_168":22,"_169":-5,"_170":267,"_98":268},[],[183],{"_103":191,"_95":192,"_156":193,"_158":-5,"_159":137,"_160":136,"_161":162,"_105":194,"_100":32,"_164":186,"_166":195,"_168":22,"_169":-5,"_170":270,"_98":271},[],[192],{"_103":199,"_95":200,"_156":201,"_158":-5,"_159":137,"_160":136,"_161":162,"_105":202,"_100":32,"_164":165,"_166":203,"_168":22,"_169":-5,"_170":273,"_98":274},[],[200],{"_103":207,"_95":99,"_156":208,"_158":-5,"_159":137,"_160":136,"_161":162,"_105":209,"_100":32,"_164":210,"_166":211,"_168":22,"_169":-5,"_170":276,"_98":277},[],[99],{"_103":215,"_95":216,"_156":217,"_158":-5,"_159":137,"_160":136,"_161":162,"_105":218,"_100":32,"_164":186,"_166":219,"_168":22,"_169":-5,"_170":279,"_98":280},[],[216],[260,263,266,269,272,275,278],{"_103":207,"_159":137,"_156":208,"_95":99,"_166":211,"_164":210,"_100":32,"_158":-5,"_105":283,"_160":136,"_169":-5,"_98":284},["D",1751070417185],[99],[],"upstream",{"_103":140,"_105":288,"_244":289,"_95":43,"_138":145,"_100":142,"_139":-5,"_141":-5,"_246":247,"_107":-5,"_150":22,"_109":110,"_149":239,"_16":147,"_148":96},["D",1750797052053],["D",1750803527989],"showCompareCallout","pull","ahead","behind","templates",[296,313],{"_103":297,"_95":298,"_105":299,"_107":-5,"_108":22,"_109":110,"_111":300,"_112":301,"_14":302,"_114":303,"_115":162,"_116":304,"_117":305,"_16":306,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_23":307,"_131":310,"_134":311,"_150":22},"8e7382ae-d835-11ef-bbbf-e6cdfca9ef9f","markdownBlogStarter",["D",1737491000655],"Starter template for a markdown blog","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/44a31e5c-3e8a-48a8-d067-5785c0b08200/square512","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","a4a9ad14-d835-11ef-8351-e6cdfca9ef9f",167,11,"e81e7335-6d4c-4764-a902-d0962bbfa9f7",{"_93":308,"_129":309},"stevekrouse","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg",{"_93":308,"_133":309},{"_103":312,"_95":43,"_100":304,"_138":297,"_139":-5,"_141":-5},"8e73c264-d835-11ef-bbbf-e6cdfca9ef9f",{"_103":314,"_95":315,"_105":316,"_107":-5,"_108":22,"_109":110,"_111":317,"_112":-5,"_14":318,"_114":319,"_115":162,"_116":320,"_117":321,"_16":322,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_23":323,"_131":326,"_134":327,"_150":22},"96102714-f528-11ef-aa68-569c3dd06744","reactHonoStarter",["D",1740674013689],"Starter template with client-side React & Hono server","c9143560-63b6-444f-8f9f-e2647fabe09f","a9b2b20a-f528-11ef-9e98-569c3dd06744",39,14,"c606f87f-4d7e-48c8-9c39-ef5ab94aec49",{"_93":324,"_129":325},"std","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJVaVhpQ1BId3dscVpBbkdZVWlMNjJtcjkxWS5wbmcifQ",{"_93":324,"_133":325},{"_103":328,"_95":43,"_100":329,"_138":314,"_139":-5,"_141":-5},"961078ea-f528-11ef-aa68-569c3dd06744",72,"actionData","errors"]