Todo List

\n \n ${rows.length === 0 \n ? '

No todos found

'\n : `\n

\n \n \n \n \n \n \n \n \n \n \n ${rows.map(todo => `\n \n \n \n \n \n \n `).join('')}\n \n

ID	Task	Status	Created
${todo.id}	${escapeHtml(todo.task \|\| todo.title \|\| 'No task')}	\n \n ${todo.completed \|\| todo.status === 'completed' ? 'Completed' : 'Pending'}\n \n	\n ${todo.created_at ? new Date(todo.created_at).toLocaleDateString() : 'N/A'}\n

\n Total todos: ${rows.length}\n

\n `\n }\n

\n \n \n\n`;\n\n return new Response(html, {\n headers: { \"Content-Type\": \"text/html\" }\n });\n \n } catch (error) {\n console.error(\"Error querying todos:\", error);\n \n // Return error page\n const errorHtml = `\n\n\n\n \n \n Error - Todos\n \n\n\n

Error Loading Todos

There was an error querying the todos table:

${error.message}

Make sure the 'todos' table exists in your SQLite database.

\n\n`;\n\n return new Response(errorHtml, {\n status: 500,\n headers: { \"Content-Type\": \"text/html\" }\n });\n }\n}\n\n// Helper function to escape HTML\nfunction escapeHtml(text: string): string {\n const map: { [key: string]: string } = {\n '&': '&',\n '<': '<',\n '>': '>',\n '\"': '"',\n \"'\": '''\n };\n return text.replace(/[&<>\"']/g, (m) => map[m]);\n}","deleted","label",[98],"permalink","https://www.val.town/x/stevekrouse/test-test/code/main.ts","extension","actionData","errors"]