\n {sortedTodos.map((todo, index) => (\n

{todo.title}

Priority Score: {calculatePriorityScore(todo)}

Hard Deadline: {todo.hardDeadline ? '✅' : '❌'}

Blocking Work: {todo.blockingWork ? '✅' : '❌'}

Stakeholder Importance: {todo.stakeholderImportance}/5

Blocked: {todo.isBlocked ? '✅' : '❌'}

\n {todo.id && }\n

\n ))}\n

\n );\n}\n\nfunction App() {\n const [todos, setTodos] = useState([]);\n\n useEffect(() => {\n fetchTodos();\n }, []);\n\n const fetchTodos = async () => {\n try {\n const response = await fetch('/todos');\n const data = await response.json();\n setTodos(data);\n } catch (error) {\n console.error('Failed to fetch todos', error);\n }\n };\n\n const addTodo = async (todo: Todo) => {\n try {\n const response = await fetch('/todos', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify(todo)\n });\n const newTodo = await response.json();\n setTodos([...todos, newTodo]);\n } catch (error) {\n console.error('Failed to add todo', error);\n }\n };\n\n const deleteTodo = async (id: number) => {\n try {\n await fetch(`/todos/${id}`, { method: 'DELETE' });\n setTodos(todos.filter(todo => todo.id !== id));\n } catch (error) {\n console.error('Failed to delete todo', error);\n }\n };\n\n return (\n

Smart Todo Prioritizer 📋

\n \n \n \n View Source\n \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 KEY = new URL(import.meta.url).pathname.split(\"/\").at(-1);\n const SCHEMA_VERSION = 1;\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_todos_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n hardDeadline BOOLEAN NOT NULL,\n blockingWork BOOLEAN NOT NULL,\n stakeholderImportance INTEGER NOT NULL,\n isBlocked BOOLEAN NOT NULL\n )\n `);\n\n if (request.method === 'GET' && new URL(request.url).pathname === '/todos') {\n const result = await sqlite.execute(`SELECT * FROM ${KEY}_todos_${SCHEMA_VERSION}`);\n return new Response(JSON.stringify(result.rows), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n\n if (request.method === 'POST' && new URL(request.url).pathname === '/todos') {\n const todo = await request.json();\n const result = await sqlite.execute(\n `INSERT INTO ${KEY}_todos_${SCHEMA_VERSION} \n (title, hardDeadline, blockingWork, stakeholderImportance, isBlocked) \n VALUES (?, ?, ?, ?, ?)`,\n [\n todo.title, \n todo.hardDeadline ? 1 : 0, \n todo.blockingWork ? 1 : 0, \n todo.stakeholderImportance, \n todo.isBlocked ? 1 : 0\n ]\n );\n \n return new Response(JSON.stringify({\n ...todo,\n id: result.lastInsertRowid\n }), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n\n if (request.method === 'DELETE' && /^\\/todos\\/\\d+$/.test(new URL(request.url).pathname)) {\n const id = new URL(request.url).pathname.split('/').pop();\n await sqlite.execute(`DELETE FROM ${KEY}_todos_${SCHEMA_VERSION} WHERE id = ?`, [id]);\n return new Response(null, { status: 204 });\n }\n\n return new Response(`\n \n \n Smart Todo Prioritizer\n \n \n \n

\n \n \n \n `, {\n headers: { 'Content-Type': 'text/html' }\n });\n}","createdAt",["D",1741409729720],"version","currentUserHasLiked","likeCount","forkCount","referenceCount","dependencyCount",1,"commentCount","prCount","mergedPr",{"_129":130,"_131":132},"handle","connnolly","profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ1S21DQ001blMycndJZm9kem5RdjJlem9lVCJ9","forkedVal","interval","slug","connnolly/todoAppAutoPrioritize","description","@jsxImportSource https://esm.sh/react@18.2.0","versions",[141],{"_118":32,"_142":-5,"_116":143,"_113":111},"prId",["D",1741409729720],"recentThread","breadcrumbs","comments",[],"isOwner","routes/_app.v.$handle.$name.versions.$(version)",{"_94":151,"_152":153,"_95":154},"single","redirect","/v/connnolly/todoAppAutoPrioritize/versions",{"_113":111,"_114":115,"_118":32,"_116":155,"_156":100,"_101":102,"_108":109,"_129":130,"_11":97,"_157":-5,"_158":-5,"_159":-5,"_148":26,"_135":136},["D",1741409729720],"valName","deletedAt","messageId","threadId","routes/_app","actionData","errors"]

todoAppAutoPrioritize

Version 0