Tasks

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_198":199,"_200":201},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_149":-5,"_20":150,"_22":151,"_152":153,"_154":155,"_26":156,"_24":157,"_158":-5,"_159":-5,"_160":55,"_161":162,"_163":46,"_164":-5,"_165":-5,"_166":167},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","ChrisP","name","To-Do","branchName","main","version","path","frontend","project",{"_34":92,"_13":14,"_47":93,"_94":-5,"_95":55,"_96":97,"_98":97,"_99":100,"_101":102,"_103":104,"_105":-5,"_106":55,"_107":-5,"_108":-5,"_109":49,"_110":111,"_112":113,"_114":115,"_116":117,"_118":-5,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_128":129,"_130":131,"_132":133,"_134":55},"tree",[63,64,65],"file",{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":59,"_45":46,"_47":60,"_17":49,"_50":61,"_52":-5,"_54":55,"_56":-5,"_18":62},"contents",[33],"upstream","pull","ahead","behind","envVars",{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":57},"id","70d35f4e-3f27-11f1-976e-42b51c65c3df","app.tsx","fileId","70d3600c-3f27-11f1-976e-42b51c65c3df","parentId","2fe2f062-3f27-11f1-8fb4-42b51c65c3df","branchId","e102660a-3f1a-11f1-9eb0-42b51c65c3df","branchVersion",9,"latest",true,"createdAt",["D",1776957405394],0,"fileType","script","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useEffect, useRef, useState } from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\n\nconst PRIORITIES = [\"high\", \"low\"];\nconst PRIORITY_CONFIG = {\n high: { label: \"HIGH\", color: \"#ef4444\", dot: \"#ef4444\" },\n low: { label: \"LOW\", color: \"#4b5563\", dot: \"#374151\" },\n};\n\n// ---------- API helpers ----------\nasync function apiGet() {\n const res = await fetch(\"/api/data\");\n return res.json();\n}\nasync function apiPost(path: string, body: any) {\n await fetch(path, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(body),\n });\n}\nasync function apiPut(path: string, body: any) {\n await fetch(path, {\n method: \"PUT\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(body),\n });\n}\nasync function apiDelete(path: string, body: any) {\n await fetch(path, {\n method: \"DELETE\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(body),\n });\n}\n\nlet _id = Date.now();\nfunction genId() {\n return String(++_id);\n}\n\nfunction TaskManager() {\n const [data, setData] = useState({ tasks: [], projects: [], tags: [] });\n const [loading, setLoading] = useState(true);\n const [filter, setFilter] = useState({\n project: \"all\",\n tag: null as string | null,\n priority: \"high\" as string | null,\n done: false,\n });\n const [newTask, setNewTask] = useState({\n title: \"\",\n project: \"General\",\n priority: \"high\",\n tags: [] as string[],\n notes: \"\",\n });\n const [showForm, setShowForm] = useState(false);\n const [expandedId, setExpandedId] = useState(null);\n const [editingId, setEditingId] = useState(null);\n const [editTask, setEditTask] = useState(null);\n const [newProject, setNewProject] = useState(\"\");\n const [newTag, setNewTag] = useState(\"\");\n const [showProjectInput, setShowProjectInput] = useState(false);\n const [showTagInput, setShowTagInput] = useState(false);\n const [search, setSearch] = useState(\"\");\n const [dragging, setDragging] = useState(null);\n const [dragOver, setDragOver] = useState(null);\n const dragId = useRef(null);\n const touchOverId = useRef(null);\n const titleRef = useRef(null);\n\n // Load data from server on mount\n useEffect(() => {\n apiGet().then((d) => {\n setData(d);\n setLoading(false);\n });\n }, []);\n\n const { tasks, projects, tags: allTags } = data;\n\n // --- Task actions (optimistic update + server sync) ---\n async function addTask() {\n if (!newTask.title.trim()) return;\n const task = {\n ...newTask,\n id: genId(),\n done: false,\n createdAt: Date.now(),\n title: newTask.title.trim(),\n };\n setData((prev: any) => ({ ...prev, tasks: [task, ...prev.tasks] }));\n setNewTask({\n title: \"\",\n project: newTask.project,\n priority: \"high\",\n tags: [],\n notes: \"\",\n });\n setShowForm(false);\n await apiPost(\"/api/tasks\", task);\n }\n\n async function toggleDone(id: string) {\n const task = tasks.find((t: any) => t.id === id);\n if (!task) return;\n const updated = { ...task, done: !task.done };\n setData((prev: any) => ({\n ...prev,\n tasks: prev.tasks.map((t: any) => (t.id === id ? updated : t)),\n }));\n await apiPut(\"/api/tasks\", updated);\n }\n\n async function deleteTaskAction(id: string) {\n setData((prev: any) => ({\n ...prev,\n tasks: prev.tasks.filter((t: any) => t.id !== id),\n }));\n if (expandedId === id) setExpandedId(null);\n await apiDelete(\"/api/tasks\", { id });\n }\n\n function startEdit(task: any) {\n setEditingId(task.id);\n setEditTask({ ...task });\n setExpandedId(task.id);\n }\n\n async function saveEdit() {\n if (!editTask.title.trim()) return;\n const updated = { ...editTask, title: editTask.title.trim() };\n setData((prev: any) => ({\n ...prev,\n tasks: prev.tasks.map((t: any) => (t.id === editingId ? updated : t)),\n }));\n setEditingId(null);\n setEditTask(null);\n await apiPut(\"/api/tasks\", updated);\n }\n\n function toggleTagOnTask(tag: string, taskObj: any, setTaskObj: any) {\n const has = taskObj.tags.includes(tag);\n setTaskObj({\n ...taskObj,\n tags: has ? taskObj.tags.filter((x: string) => x !== tag) : [...taskObj.tags, tag],\n });\n }\n\n async function addProjectAction() {\n const p = newProject.trim();\n if (!p || projects.includes(p)) return;\n setData((prev: any) => ({ ...prev, projects: [...prev.projects, p] }));\n setNewProject(\"\");\n setShowProjectInput(false);\n await apiPost(\"/api/projects\", { name: p });\n }\n\n async function addTagAction() {\n const t = newTag.trim().toLowerCase().replace(/\\s+/g, \"-\");\n if (!t || allTags.includes(t)) return;\n setData((prev: any) => ({ ...prev, tags: [...prev.tags, t] }));\n setNewTag(\"\");\n setShowTagInput(false);\n await apiPost(\"/api/tags\", { name: t });\n }\n\n // --- Drag & drop (same logic, with server sync) ---\n function onDragStart(e: any, id: string) {\n dragId.current = id;\n setDragging(id);\n e.dataTransfer.effectAllowed = \"move\";\n }\n function onDragEnter(e: any, id: string) {\n e.preventDefault();\n setDragOver(id);\n }\n function onDragOver(e: any) {\n e.preventDefault();\n e.dataTransfer.dropEffect = \"move\";\n }\n function onDrop(e: any, targetId: string) {\n e.preventDefault();\n const fromId = dragId.current;\n if (!fromId || fromId === targetId) {\n resetDrag();\n return;\n }\n reorderTasks(fromId, targetId);\n resetDrag();\n }\n function onDragEnd() {\n resetDrag();\n }\n function onTouchStart(e: any, id: string) {\n dragId.current = id;\n setDragging(id);\n touchOverId.current = null;\n }\n function onTouchMove(e: any) {\n e.preventDefault();\n const touch = e.touches[0];\n const el = document.elementFromPoint(touch.clientX, touch.clientY);\n if (!el) return;\n const row = (el as HTMLElement).closest(\"[data-taskid]\");\n if (row) {\n const overId = row.getAttribute(\"data-taskid\");\n if (overId !== dragId.current) {\n touchOverId.current = overId;\n setDragOver(overId);\n }\n }\n }\n function onTouchEnd() {\n const fromId = dragId.current;\n const toId = touchOverId.current;\n if (fromId && toId && fromId !== toId) reorderTasks(fromId, toId);\n resetDrag();\n }\n\n async function reorderTasks(fromId: string, toId: string) {\n setData((prev: any) => {\n const arr = [...prev.tasks];\n const fi = arr.findIndex((t: any) => t.id === fromId);\n const ti = arr.findIndex((t: any) => t.id === toId);\n if (fi === -1 || ti === -1) return prev;\n const [moved] = arr.splice(fi, 1);\n arr.splice(ti, 0, moved);\n // Fire and forget server sync\n apiPost(\"/api/tasks/reorder\", { orderedIds: arr.map((t: any) => t.id) });\n return { ...prev, tasks: arr };\n });\n }\n\n function resetDrag() {\n dragId.current = null;\n touchOverId.current = null;\n setDragging(null);\n setDragOver(null);\n }\n\n // --- Filtering ---\n const filtered = tasks.filter((t: any) => {\n if (t.done !== filter.done) return false;\n if (filter.project !== \"all\" && t.project !== filter.project) return false;\n if (filter.tag && !t.tags.includes(filter.tag)) return false;\n if (filter.priority && t.priority !== filter.priority) return false;\n if (search && !t.title.toLowerCase().includes(search.toLowerCase())) return false;\n return true;\n });\n\n const isAllProjects = filter.project === \"all\";\n const grouped: Record = {};\n if (!isAllProjects) {\n filtered.forEach((t: any) => {\n if (!grouped[t.project]) grouped[t.project] = [];\n grouped[t.project].push(t);\n });\n }\n\n const visibleProjects = isAllProjects ? [] : projects.filter((p: string) => grouped[p]?.length > 0);\n const doneCt = tasks.filter((t: any) => t.done).length;\n const pendingCt = tasks.filter((t: any) => !t.done).length;\n const myDayCt = tasks.filter((t: any) => !t.done && t.priority === \"high\").length;\n const projectCounts: Record = {};\n projects.forEach((p: string) => {\n projectCounts[p] = tasks.filter((t: any) => !t.done && t.project === p).length;\n });\n\n function renderTask(task: any) {\n const isExpanded = expandedId === task.id;\n const isEditing = editingId === task.id;\n const pc = (PRIORITY_CONFIG as any)[task.priority] || PRIORITY_CONFIG.low;\n const isDraggingThis = dragging === task.id;\n const isDragOverThis = dragOver === task.id && dragging !== task.id;\n\n return (\n onDragStart(e, task.id)}\n onDragEnter={(e) => onDragEnter(e, task.id)}\n onDragOver={onDragOver}\n onDrop={(e) => onDrop(e, task.id)}\n onDragEnd={onDragEnd}\n style={{\n borderBottom: \"1px solid #141414\",\n background: task.priority === \"high\" && !task.done ? \"#130d0d\" : \"transparent\",\n }}\n >\n

\n onTouchStart(e, task.id)}\n onTouchMove={onTouchMove}\n onTouchEnd={onTouchEnd}\n style={{ touchAction: \"none\" }}\n >\n ⣿\n \n

toggleDone(task.id)} style={{ marginTop: 1 }}>\n {task.done && (\n \n )}\n

\n {isEditing ? (\n setEditTask((t: any) => ({ ...t, title: e.target.value }))}\n onKeyDown={(e) => e.key === \"Enter\" && saveEdit()}\n style={{ width: \"100%\", marginBottom: 6 }}\n autoFocus\n />\n ) : (\n setExpandedId(isExpanded ? null : task.id)}\n style={{\n fontSize: 12,\n color: task.done ? \"#333\" : \"#d0ccc4\",\n textDecoration: task.done ? \"line-through\" : \"none\",\n cursor: \"pointer\",\n lineHeight: \"1.45\",\n }}\n >\n {task.title}\n

\n )}\n

\n {isAllProjects && (\n \n {task.project}\n \n )}\n \n {pc.label}\n \n {task.tags.map((tag: string) => (\n \n #{tag}\n \n ))}\n {task.notes && !isExpanded && (\n \n \n Notes\n \n )}\n

\n {isExpanded && !isEditing && (\n

\n {task.notes && (\n

\n {task.notes}\n

\n )}\n

\n \n \n \n

\n )}\n {isEditing && (\n

\n \n \n

\n {allTags.map((tag: string) => (\n toggleTagOnTask(tag, editTask, setEditTask)}\n >\n #{tag}\n \n ))}\n

\n setEditTask((t: any) => ({ ...t, notes: e.target.value }))}\n rows={2}\n style={{ width: \"100%\", resize: \"vertical\", marginBottom: 7 }}\n placeholder=\"Notes...\"\n />\n

\n \n \n

\n )}\n

\n \n \n \n );\n }\n\n if (loading) {\n return (\n

\n );\n }\n\n return (\n

\n \n\n

TASKS

\n {pendingCt} OPEN · {doneCt} DONE\n

\n setSearch(e.target.value)}\n style={{ flex: 1, maxWidth: 220, fontSize: 11 }}\n />\n {\n setShowForm(true);\n setTimeout(() => titleRef.current?.focus(), 40);\n }}\n >\n + New Task\n \n

\n\n

\n {/* Sidebar */}\n

View

\n setFilter({ project: \"all\", tag: null, priority: \"high\", done: false })}\n >\n My Day\n {myDayCt > 0 && ({myDayCt})}\n \n setFilter({ project: \"all\", tag: null, priority: null, done: false })}\n >\n All Open\n {pendingCt > 0 && ({pendingCt})}\n \n setFilter((f) => ({ ...f, done: true, priority: null }))}\n >\n Completed\n \n\n

Priority

\n {[\n { l: \"All\", v: null },\n { l: \"High\", v: \"high\" },\n { l: \"Low\", v: \"low\" },\n ].map(({ l, v }) => (\n setFilter((f) => ({ ...f, priority: v, done: false }))}\n >\n {v && (\n \n )}\n {l}\n \n ))}\n\n \n Projects\n setShowProjectInput((v) => !v)}\n style={{ background: \"none\", border: \"none\", color: \"#333\", cursor: \"pointer\", fontSize: 14, lineHeight: 1, padding: 0 }}\n >\n +\n \n

\n {showProjectInput && (\n

\n setNewProject(e.target.value)}\n onKeyDown={(e) => e.key === \"Enter\" && addProjectAction()}\n placeholder=\"name\"\n style={{ width: \"100%\", fontSize: 10, padding: \"4px 7px\" }}\n />\n

\n )}\n setFilter((f) => ({ ...f, project: \"all\" }))}\n >\n All\n \n {projects.map((p: string) => (\n setFilter((f) => ({ ...f, project: p, done: false }))}\n >\n {p}\n {projectCounts[p] > 0 && (\n ({projectCounts[p]})\n )}\n \n ))}\n\n \n Tags\n setShowTagInput((v) => !v)}\n style={{ background: \"none\", border: \"none\", color: \"#333\", cursor: \"pointer\", fontSize: 14, lineHeight: 1, padding: 0 }}\n >\n +\n \n

\n {showTagInput && (\n

\n setNewTag(e.target.value)}\n onKeyDown={(e) => e.key === \"Enter\" && addTagAction()}\n placeholder=\"name\"\n style={{ width: \"100%\", fontSize: 10, padding: \"4px 7px\" }}\n />\n

\n )}\n setFilter((f) => ({ ...f, tag: null }))}\n >\n All\n \n {allTags.map((t: string) => (\n setFilter((f) => ({ ...f, tag: f.tag === t ? null : t }))}\n >\n #{t}\n \n ))}\n

\n\n {/* Main content */}\n

\n {showForm && (\n

\n setNewTask((t) => ({ ...t, title: e.target.value }))}\n onKeyDown={(e) => e.key === \"Enter\" && addTask()}\n style={{ flex: 1, minWidth: 160 }}\n />\n \n \n

\n {allTags.map((tag: string) => (\n toggleTagOnTask(tag, newTask, setNewTask)}\n >\n #{tag}\n \n ))}\n

\n setNewTask((t) => ({ ...t, notes: e.target.value }))}\n rows={2}\n style={{ width: \"100%\", resize: \"vertical\", marginBottom: 7 }}\n />\n

\n \n \n

\n )}\n\n {filtered.length === 0 && (\n

\n {filter.done ? \"NO COMPLETED TASKS\" : \"NO OPEN TASKS\"}\n

\n )}\n\n {isAllProjects && filtered.map((task: any) => renderTask(task))}\n\n {!isAllProjects &&\n visibleProjects.map((project: string) => (\n

\n {project}\n {grouped[project].length}\n

\n {grouped[project].map((task: any) => renderTask(task))}\n

\n ))}\n

\n \n \n );\n}\n\nconst root = createRoot(document.getElementById(\"root\")!);\nroot.render();\n","deleted",false,"label",[19,36],"2fe2efae-3f27-11f1-8fb4-42b51c65c3df",8,["D",1776957296450],"directory",[19],{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":59,"_45":46,"_47":85,"_17":49,"_50":61,"_52":-5,"_54":55,"_56":-5,"_74":86,"_18":87},{"_34":77,"_13":78,"_37":79,"_39":-5,"_41":42,"_43":80,"_45":46,"_47":81,"_17":49,"_50":51,"_52":82,"_54":55,"_56":-5,"_74":83,"_18":84},{"_34":66,"_13":67,"_37":68,"_39":-5,"_41":42,"_43":69,"_45":46,"_47":70,"_17":71,"_50":72,"_52":73,"_54":55,"_56":-5,"_74":75,"_18":76},"2dd22950-3f27-11f1-8fb4-42b51c65c3df","main.ts","e1058e8e-3f1a-11f1-9eb0-42b51c65c3df",7,["D",1776957293005],5,"http","import {\n initDB,\n seedDefaults,\n getAllData,\n addTask as dbAddTask,\n updateTask as dbUpdateTask,\n deleteTask as dbDeleteTask,\n reorderTasks as dbReorderTasks,\n addProject as dbAddProject,\n addTagToDB,\n} from \"./api.ts\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\n\nexport default async function server(req: Request): Promise {\n const url = new URL(req.url);\n\n // Initialize DB on first request\n await initDB();\n await seedDefaults();\n\n // API routes\n if (url.pathname === \"/api/data\" && req.method === \"GET\") {\n const data = await getAllData();\n return Response.json(data);\n }\n\n if (url.pathname === \"/api/tasks\" && req.method === \"POST\") {\n const task = await req.json();\n await dbAddTask(task);\n return Response.json({ ok: true });\n }\n\n if (url.pathname === \"/api/tasks\" && req.method === \"PUT\") {\n const task = await req.json();\n await dbUpdateTask(task);\n return Response.json({ ok: true });\n }\n\n if (url.pathname === \"/api/tasks\" && req.method === \"DELETE\") {\n const { id } = await req.json();\n await dbDeleteTask(id);\n return Response.json({ ok: true });\n }\n\n if (url.pathname === \"/api/tasks/reorder\" && req.method === \"POST\") {\n const { orderedIds } = await req.json();\n await dbReorderTasks(orderedIds);\n return Response.json({ ok: true });\n }\n\n if (url.pathname === \"/api/projects\" && req.method === \"POST\") {\n const { name } = await req.json();\n await dbAddProject(name);\n return Response.json({ ok: true });\n }\n\n if (url.pathname === \"/api/tags\" && req.method === \"POST\") {\n const { name } = await req.json();\n await addTagToDB(name);\n return Response.json({ ok: true });\n }\n\n // Serve frontend files\n if (url.pathname === \"/frontend/app.tsx\") {\n return serveFile(\"/frontend/app.tsx\");\n }\n\n // Serve HTML shell\n return new Response(\n `\n\n\n \n \n Tasks\n \n\n\n

\n \n\n`,\n { headers: { \"content-type\": \"text/html\" } },\n );\n}\n","children",[],[67],"270311de-3f27-11f1-8fb4-42b51c65c3df","api.ts","27031292-3f27-11f1-8fb4-42b51c65c3df",6,["D",1776957281591],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// Initialize database tables\nexport async function initDB() {\n await sqlite.batch([\n {\n sql: `CREATE TABLE IF NOT EXISTS tasks (\n id TEXT PRIMARY KEY,\n title TEXT NOT NULL,\n project TEXT NOT NULL DEFAULT 'General',\n priority TEXT NOT NULL DEFAULT 'high',\n tags TEXT NOT NULL DEFAULT '[]',\n notes TEXT NOT NULL DEFAULT '',\n done INTEGER NOT NULL DEFAULT 0,\n sort_order INTEGER NOT NULL DEFAULT 0,\n created_at INTEGER NOT NULL\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS projects (\n name TEXT PRIMARY KEY,\n sort_order INTEGER NOT NULL DEFAULT 0\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS tags (\n name TEXT PRIMARY KEY,\n sort_order INTEGER NOT NULL DEFAULT 0\n )`,\n },\n ]);\n}\n\nconst DEFAULT_PROJECTS = [\n \"General\", \"Office/PR\", \"Hillcrest\", \"Nimes\",\n \"Chalette\", \"Kihei\", \"BVI\", \"Bal Bay\", \"Le Mer\",\n];\nconst DEFAULT_TAGS = [\"follow-up\"];\n\nexport async function seedDefaults() {\n // Insert default projects if table is empty\n const projectCount = await sqlite.execute(\"SELECT COUNT(*) as cnt FROM projects\");\n if (projectCount.rows[0].cnt === 0) {\n await sqlite.batch(\n DEFAULT_PROJECTS.map((name, i) => ({\n sql: \"INSERT OR IGNORE INTO projects (name, sort_order) VALUES (?, ?)\",\n args: [name, i],\n })),\n );\n }\n // Insert default tags if table is empty\n const tagCount = await sqlite.execute(\"SELECT COUNT(*) as cnt FROM tags\");\n if (tagCount.rows[0].cnt === 0) {\n await sqlite.batch(\n DEFAULT_TAGS.map((name, i) => ({\n sql: \"INSERT OR IGNORE INTO tags (name, sort_order) VALUES (?, ?)\",\n args: [name, i],\n })),\n );\n }\n}\n\n// --- Data access functions ---\n\nexport async function getAllData() {\n const [tasksResult, projectsResult, tagsResult] = await Promise.all([\n sqlite.execute(\"SELECT * FROM tasks ORDER BY sort_order ASC, created_at DESC\"),\n sqlite.execute(\"SELECT name FROM projects ORDER BY sort_order ASC\"),\n sqlite.execute(\"SELECT name FROM tags ORDER BY sort_order ASC\"),\n ]);\n\n const tasks = tasksResult.rows.map((r: any) => ({\n id: r.id,\n title: r.title,\n project: r.project,\n priority: r.priority,\n tags: JSON.parse(r.tags),\n notes: r.notes,\n done: r.done === 1,\n createdAt: r.created_at,\n }));\n\n return {\n tasks,\n projects: projectsResult.rows.map((r: any) => r.name),\n tags: tagsResult.rows.map((r: any) => r.name),\n };\n}\n\nexport async function addTask(task: {\n id: string;\n title: string;\n project: string;\n priority: string;\n tags: string[];\n notes: string;\n done: boolean;\n createdAt: number;\n}) {\n await sqlite.execute({\n sql: `INSERT INTO tasks (id, title, project, priority, tags, notes, done, sort_order, created_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, 0, ?)`,\n args: [task.id, task.title, task.project, task.priority, JSON.stringify(task.tags), task.notes, task.done ? 1 : 0, task.createdAt],\n });\n // Push all existing sort_orders up by 1 so the new task is on top\n await sqlite.execute({\n sql: \"UPDATE tasks SET sort_order = sort_order + 1 WHERE id != ?\",\n args: [task.id],\n });\n}\n\nexport async function updateTask(task: {\n id: string;\n title: string;\n project: string;\n priority: string;\n tags: string[];\n notes: string;\n done: boolean;\n}) {\n await sqlite.execute({\n sql: `UPDATE tasks SET title=?, project=?, priority=?, tags=?, notes=?, done=? WHERE id=?`,\n args: [task.title, task.project, task.priority, JSON.stringify(task.tags), task.notes, task.done ? 1 : 0, task.id],\n });\n}\n\nexport async function deleteTask(id: string) {\n await sqlite.execute({ sql: \"DELETE FROM tasks WHERE id=?\", args: [id] });\n}\n\nexport async function reorderTasks(orderedIds: string[]) {\n await sqlite.batch(\n orderedIds.map((id, i) => ({\n sql: \"UPDATE tasks SET sort_order=? WHERE id=?\",\n args: [i, id],\n })),\n );\n}\n\nexport async function addProject(name: string) {\n const max = await sqlite.execute(\"SELECT COALESCE(MAX(sort_order),0)+1 as n FROM projects\");\n await sqlite.execute({\n sql: \"INSERT OR IGNORE INTO projects (name, sort_order) VALUES (?, ?)\",\n args: [name, (max.rows[0] as any).n],\n });\n}\n\nexport async function addTagToDB(name: string) {\n const max = await sqlite.execute(\"SELECT COALESCE(MAX(sort_order),0)+1 as n FROM tags\");\n await sqlite.execute({\n sql: \"INSERT OR IGNORE INTO tags (name, sort_order) VALUES (?, ?)\",\n args: [name, (max.rows[0] as any).n],\n });\n}\n",[],[78],["D",1776957296450],[88],[19],{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":89,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_74":90,"_18":91},["D",1776957405394],[],[19,36],"e10162c8-3f1a-11f1-9eb0-42b51c65c3df",["D",1776952010184],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","To Do List","imageUrl","","userId","cbd11856-beb9-4cc3-9c68-485c1572a2a5","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","019dba95-a312-7128-a7b5-db789ac9b472","tursoName","e10162c83f1a11f19eb042b51c65c3df","tursoHostname","e10162c83f1a11f19eb042b51c65c3df-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789507240000],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_148":102},"org",{"_11":12,"_143":-5,"_144":102,"_103":104,"_145":146,"_147":55},"branch",{"_17":44,"_13":16,"_34":42,"_135":92,"_136":-5,"_137":-5,"_138":-5,"_139":-5,"_140":-5,"_141":14,"_142":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_34":92,"_13":14,"_47":193,"_94":-5,"_95":55,"_96":97,"_98":97,"_99":100,"_101":102,"_103":104,"_105":-5,"_106":55,"_107":-5,"_108":-5,"_109":49,"_110":111,"_112":113,"_114":115,"_116":194,"_118":-5,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_128":195,"_130":196,"_132":197,"_134":55},[181,183,184],"files",[181,182,183,184],"counts",{"_171":49,"_172":173,"_174":49,"_32":175,"_176":177},[169],{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":59,"_45":46,"_47":60,"_17":49,"_50":61,"_52":-5,"_54":55,"_56":-5,"_18":168},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":170},[19,36],"pulls","branches",1,"forks",{"_178":49,"_180":49},"connections",{"_178":49,"_179":49},"count","unfilledCount","emptyCount",{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":59,"_45":46,"_47":85,"_17":49,"_50":61,"_52":-5,"_54":55,"_56":-5,"_74":191,"_18":192},{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":89,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_74":189,"_18":190},{"_34":77,"_13":78,"_37":79,"_39":-5,"_41":42,"_43":80,"_45":46,"_47":81,"_17":49,"_50":51,"_52":82,"_54":55,"_56":-5,"_74":187,"_18":188},{"_34":66,"_13":67,"_37":68,"_39":-5,"_41":42,"_43":69,"_45":46,"_47":70,"_17":71,"_50":72,"_52":73,"_54":55,"_56":-5,"_74":185,"_18":186},[],[67],[],[78],[],[19,36],[182],[19],["D",1776952010184],["D",1789507240000],{"_11":12,"_148":102},{"_11":12,"_143":-5,"_144":102,"_103":104,"_145":146,"_147":55},{"_17":44,"_13":16,"_34":42,"_135":92,"_136":-5,"_137":-5,"_138":-5,"_139":-5,"_140":-5,"_141":14,"_142":12},"ctx",{"_128":-5,"_165":231,"_232":233,"_234":235,"_236":55,"_237":55,"_238":55,"_239":46,"_240":-5,"_241":-7,"_242":-7,"_243":49,"_244":55,"_245":55,"_246":-5,"_247":55,"_248":55,"_249":55,"_250":-5},"ENV",{"_202":203,"_204":205,"_206":16,"_207":208,"_209":210,"_211":212,"_213":214,"_215":216,"_217":218,"_219":220,"_221":222,"_223":224,"_225":226,"_227":228,"_229":230},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]