U.S. Election Debate Poll App

Create a New Poll

\n setNewPollQuestion(e.target.value)}\n placeholder=\"Enter poll question\"\n required\n />\n {newPollOptions.map((option, index) => (\n {\n const updatedOptions = [...newPollOptions];\n updatedOptions[index] = e.target.value;\n setNewPollOptions(updatedOptions);\n }}\n placeholder={`Option ${index + 1}`}\n required\n />\n ))}\n \n \n \n

Active Polls

\n {polls.map((poll) => (\n

{poll.question}

\n {option.text} ({option.votes} votes)\n \n

\n ))}\n

\n View Source\n

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const SCHEMA_VERSION = 1\n const KEY = \"debatePollApp\";\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_polls_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n question TEXT NOT NULL,\n options TEXT NOT NULL,\n votes TEXT NOT NULL\n )\n `);\n\n const url = new URL(request.url);\n const path = url.pathname;\n\n if (path === \"/polls\" && request.method === \"GET\") {\n const result = await sqlite.execute(`SELECT * FROM ${KEY}_polls_${SCHEMA_VERSION}`);\n const polls = result.rows.map(row => ({\n id: row.id,\n question: row.question,\n options: JSON.parse(row.options).map((option, index) => ({\n text: option,\n votes: JSON.parse(row.votes)[index]\n }))\n }));\n return new Response(JSON.stringify(polls), { headers: { \"Content-Type\": \"application/json\" } });\n }\n\n if (path === \"/polls\" && request.method === \"POST\") {\n const { question, options } = await request.json();\n const votes = new Array(options.length).fill(0);\n await sqlite.execute(`\n INSERT INTO ${KEY}_polls_${SCHEMA_VERSION} (question, options, votes)\n VALUES (?, ?, ?)\n `, [question, JSON.stringify(options), JSON.stringify(votes)]);\n return new Response(null, { status: 201 });\n }\n\n if (path.startsWith(\"/polls/\") && path.endsWith(\"/vote\") && request.method === \"POST\") {\n const pollId = parseInt(path.split(\"/\")[2]);\n const { optionIndex } = await request.json();\n const result = await sqlite.execute(`SELECT votes FROM ${KEY}_polls_${SCHEMA_VERSION} WHERE id = ?`, [pollId]);\n if (result.rows.length === 0) {\n return new Response(\"Poll not found\", { status: 404 });\n }\n const votes = JSON.parse(result.rows[0].votes);\n votes[optionIndex]++;\n await sqlite.execute(`UPDATE ${KEY}_polls_${SCHEMA_VERSION} SET votes = ? WHERE id = ?`, [JSON.stringify(votes), pollId]);\n return new Response(null, { status: 200 });\n }\n\n return new Response(`\n \n \n U.S. Election Debate Poll App\n \n \n \n

\n \n \n \n \n \n `,\n {\n headers: {\n \"content-type\": \"text/html\",\n },\n });\n}\n\nconst css = `\nbody {\n font-family: 'Arial', sans-serif;\n line-height: 1.6;\n margin: 0;\n padding: 0;\n background-color: #f0f0f0;\n color: #333;\n}\n\n.container {\n width: 80%;\n margin: auto;\n overflow: hidden;\n padding: 20px;\n}\n\nh1, h2, h3 {\n color: #002868;\n}\n\n.create-poll {\n background: #fff;\n padding: 20px;\n margin-bottom: 20px;\n border-radius: 5px;\n box-shadow: 0 0 10px rgba(0,0,0,0.1);\n border: 2px solid #002868;\n}\n\n.create-poll input[type=\"text\"] {\n width: 100%;\n padding: 10px;\n margin-bottom: 10px;\n border: 1px solid #002868;\n}\n\n.create-poll button {\n display: inline-block;\n background: #002868;\n color: #fff;\n padding: 10px 20px;\n border: none;\n cursor: pointer;\n margin-right: 10px;\n}\n\n.create-poll button:hover {\n background: #001f4d;\n}\n\n.polls {\n background: #fff;\n padding: 20px;\n border-radius: 5px;\n box-shadow: 0 0 10px rgba(0,0,0,0.1);\n border: 2px solid #002868;\n}\n\n.poll {\n border-bottom: 1px solid #ccc;\n padding-bottom: 20px;\n margin-bottom: 20px;\n}\n\n.poll:last-child {\n border-bottom: none;\n padding-bottom: 0;\n margin-bottom: 0;\n}\n\n.poll ul {\n list-style-type: none;\n padding: 0;\n}\n\n.poll li {\n margin-bottom: 10px;\n}\n\n.poll button {\n background: #bf0a30;\n color: white;\n border: none;\n padding: 5px 10px;\n cursor: pointer;\n margin-left: 10px;\n}\n\n.poll button:hover {\n background: #8c0000;\n}\n\n.view-source {\n display: inline-block;\n margin-top: 20px;\n color: #002868;\n text-decoration: none;\n}\n\n.view-source:hover {\n text-decoration: underline;\n}\n\n.chart-container {\n width: 100%;\n max-width: 600px;\n margin: 20px auto;\n}\n`;","deleted","label",[98],"permalink","https://www.val.town/x/laur3n/debatePollApp/code/main.tsx","extension","actionData","errors"]