✨📝 Emojified Todo List 📝✨

\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 = \"emojiTodoListApp\";\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_todos_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n content TEXT NOT NULL,\n completed BOOLEAN NOT NULL DEFAULT 0\n )\n `);\n\n const url = new URL(request.url);\n const path = url.pathname;\n\n if (path === \"/todos\" && request.method === \"GET\") {\n const todos = await sqlite.execute(`SELECT * FROM ${KEY}_todos_${SCHEMA_VERSION} ORDER BY id DESC`);\n return new Response(JSON.stringify(todos.rows), { headers: { \"Content-Type\": \"application/json\" } });\n }\n\n if (path === \"/todos\" && request.method === \"POST\") {\n const { content } = await request.json();\n await sqlite.execute(`INSERT INTO ${KEY}_todos_${SCHEMA_VERSION} (content) VALUES (?)`, [content]);\n return new Response(null, { status: 201 });\n }\n\n if (path.startsWith(\"/todos/\") && request.method === \"PATCH\") {\n const id = path.split(\"/\")[2];\n await sqlite.execute(`UPDATE ${KEY}_todos_${SCHEMA_VERSION} SET completed = NOT completed WHERE id = ?`, [id]);\n return new Response(null, { status: 200 });\n }\n\n if (path.startsWith(\"/todos/\") && request.method === \"DELETE\") {\n const id = path.split(\"/\")[2];\n await sqlite.execute(`DELETE FROM ${KEY}_todos_${SCHEMA_VERSION} WHERE id = ?`, [id]);\n return new Response(null, { status: 200 });\n }\n\n return new Response(\n `\n \n \n ✨📝 Emojified Todo List 📝✨\n \n \n \n \n \n

\n \n \n 👀 View Source\n \n \n `,\n {\n headers: {\n \"content-type\": \"text/html\",\n },\n },\n );\n}\n\nconst css = `\nbody {\n font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;\n background-color: #f0f8ff;\n margin: 0;\n padding: 20px;\n display: flex;\n justify-content: center;\n}\n\n.container {\n background-color: white;\n border-radius: 10px;\n padding: 20px;\n box-shadow: 0 4px 6px rgba(0, 0, 0, 0.1);\n max-width: 500px;\n width: 100%;\n}\n\nh1 {\n text-align: center;\n color: #4a4a4a;\n margin-bottom: 20px;\n}\n\n.add-todo-form {\n display: flex;\n margin-bottom: 20px;\n}\n\n.new-todo-input {\n flex-grow: 1;\n padding: 10px;\n font-size: 16px;\n border: 2px solid #ddd;\n border-radius: 5px 0 0 5px;\n}\n\n.add-button {\n padding: 10px 15px;\n font-size: 16px;\n background-color: #4CAF50;\n color: white;\n border: none;\n border-radius: 0 5px 5px 0;\n cursor: pointer;\n}\n\n.todo-list {\n list-style-type: none;\n padding: 0;\n}\n\n.todo-item {\n background-color: #f9f9f9;\n border-radius: 5px;\n margin-bottom: 10px;\n padding: 10px;\n display: flex;\n justify-content: space-between;\n align-items: center;\n}\n\n.todo-item.completed .todo-content {\n text-decoration: line-through;\n color: #888;\n}\n\n.todo-content {\n cursor: pointer;\n flex-grow: 1;\n}\n\n.delete-button {\n background-color: transparent;\n border: none;\n cursor: pointer;\n font-size: 20px;\n}\n\n.emoji-footer {\n text-align: center;\n margin-top: 20px;\n font-size: 18px;\n}\n\n.view-source {\n position: fixed;\n bottom: 10px;\n right: 10px;\n background-color: #f0f0f0;\n padding: 5px 10px;\n border-radius: 5px;\n text-decoration: none;\n color: #333;\n font-size: 14px;\n}\n\n@media (max-width: 600px) {\n .container {\n width: 90%;\n }\n}\n`;","deleted","label",[98],"permalink","https://www.val.town/x/maxm/emojiTodoListApp/code/main.tsx","extension","actionData","errors"]