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","children",[],[150],"files",[148],"counts",{"_173":32,"_174":175,"_176":32,"_177":178},"pulls","branches",1,"forks","envVars",{"_179":32,"_180":32},"count","emptyCount","contents",[183],{"_102":149,"_95":150,"_151":152,"_153":-5,"_154":136,"_155":135,"_156":157,"_104":184,"_99":159,"_160":161,"_162":163,"_164":22,"_165":-5,"_98":185},["D",1757598260945],[150],"file","upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name._index",{"_93":94,"_95":96,"_97":-7,"_99":-7,"_100":195,"_181":200,"_203":-7,"_204":-5,"_205":-5,"_169":206,"_210":211,"_212":-5,"_213":-5},{"_102":103,"_95":96,"_104":196,"_106":-5,"_107":22,"_108":109,"_110":72,"_111":72,"_14":112,"_113":-5,"_114":22,"_115":-5,"_116":32,"_16":117,"_118":119,"_120":119,"_121":122,"_123":122,"_124":122,"_125":119,"_126":119,"_23":197,"_130":198,"_133":199,"_145":22},["D",1757175383704],{"_93":94,"_128":129},{"_93":94,"_132":129},{"_99":135,"_95":43,"_102":136,"_137":103,"_138":-5,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":96,"_144":94},[201],{"_102":149,"_95":150,"_151":152,"_153":-5,"_154":136,"_155":135,"_156":157,"_104":184,"_99":159,"_160":161,"_162":163,"_164":22,"_165":-5,"_98":202},[150],"readme","upstream","pull",[207],{"_102":149,"_95":150,"_151":152,"_153":-5,"_154":136,"_155":135,"_156":157,"_104":158,"_99":159,"_160":161,"_162":163,"_164":22,"_165":-5,"_166":208,"_98":209},[],[150],"previews",[207],"ahead","behind","actionData","errors"]

stevekrouse

test-test