Personal Task Manager

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_270":271,"_272":273},"routes/_app.x.$handle.$name",{"_100":99,"_32":49,"_108":90,"_27":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_21":-5,"_120":-5,"_121":-5,"_122":25,"_123":124,"_125":25,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_47":48,"_32":49,"_37":50,"_51":-5,"_52":25,"_53":54,"_55":54,"_56":-5,"_57":-5,"_18":58,"_59":60,"_61":62,"_63":62,"_64":-5,"_65":66,"_67":68,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",9,"changes",[19,20],"aiChatInfo","userId",{"_21":42,"_23":-7,"_24":25,"_26":25,"_27":43,"_29":43},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":21,"_35":36,"_37":38,"_39":14,"_40":41,"_24":25},"previous","deleted",false,"deletedHere","path","frontend/index.html","latestPath","fileId","aafe1066-3635-11f0-8384-9e149126039e","name","index.html","fileType","content","\n\n\n \n \n Personal Task Manager\n \n \n \n \n \n \n \n \n\n\n

\n \n \n \n\n","createdAt",["D",1747826457838],"branchVersion","branchId","5357797e-3635-11f0-a945-9e149126039e",{"_30":44,"_32":43,"_34":45,"_35":-5,"_37":46,"_39":14,"_40":41,"_24":25},"frontend","9c8ea74c-f2ef-4021-a3ae-313f9aa889d4","directory",["D",1747826457838],"id","53573c34-3635-11f0-a945-9e149126039e","lucie",["D",1747826310786],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","f4675420-1ee2-11f0-82e6-37b0a309c55b","pinnedFileId","a6c6e536-3635-11f0-b9f4-9e149126039e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","a5e2ec27-9915-4b8a-beed-e3bf61329958","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_107":103},"org",{"_100":99,"_101":-5,"_102":103,"_18":58,"_104":105,"_106":25},"branch",{"_13":89,"_32":90,"_47":41,"_91":48,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":49,"_98":99},"isOwned",16,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","lucie_123","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ3M0VmNlpLdXZSNGJ6SGR0TWxSYUFjeEdFcyJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_47":48,"_32":49,"_37":266,"_51":-5,"_52":25,"_53":54,"_55":54,"_56":-5,"_57":-5,"_18":58,"_59":60,"_61":62,"_63":62,"_64":-5,"_65":66,"_67":68,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":267,"_84":268,"_86":269,"_88":25},"tree",[169,178,180,182],"files",[169,170,171,172,173,174,175,176,177,178,179,180,181,182],"counts",{"_159":66,"_160":138,"_161":66,"_162":163,"_164":165},"contents",[130,131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_47":153,"_32":154,"_30":155,"_137":-5,"_40":41,"_39":156,"_139":62,"_37":157,"_13":66,"_34":45,"_35":-5,"_24":25,"_142":-5,"_27":158},{"_47":150,"_32":43,"_30":44,"_137":-5,"_40":41,"_39":14,"_139":62,"_37":151,"_13":66,"_34":45,"_35":-5,"_24":25,"_142":-5,"_27":152},{"_47":144,"_32":145,"_30":146,"_137":-5,"_40":41,"_39":147,"_139":62,"_37":148,"_13":66,"_34":45,"_35":-5,"_24":25,"_142":-5,"_27":149},{"_47":134,"_32":135,"_30":136,"_137":-5,"_40":41,"_39":138,"_139":62,"_37":140,"_13":66,"_34":21,"_35":141,"_24":25,"_142":-5,"_27":143},"766db2f2-3635-11f0-ae53-9e149126039e","README.md","766db3b0-3635-11f0-ae53-9e149126039e","parentId",1,"latest",["D",1747826369650],"# Personal Task Manager\n\nA full-stack task manager application built on Val Town.\n\n## Features\n\n- User registration and login with JWT authentication\n- Create, read, update, and delete tasks\n- Responsive UI for desktop and mobile\n- Secure API endpoints\n- Data persistence with SQLite\n\n## Project Structure\n\n```\n/\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Database schema\n│ │ └── queries.ts # Database queries\n│ ├── routes/\n│ │ ├── auth.ts # Authentication routes\n│ │ ├── tasks.ts # Task management routes\n│ │ └── static.ts # Static file serving\n│ └── index.ts # Main entry point\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx # Main application component\n│ │ ├── Login.tsx # Login component\n│ │ ├── Register.tsx # Registration component\n│ │ ├── TaskList.tsx # Task list component\n│ │ └── TaskForm.tsx # Task creation/editing form\n│ ├── index.html # Main HTML template\n│ └── index.tsx # Frontend entry point\n└── shared/\n └── types.ts # Shared type definitions\n```\n\n## Technologies Used\n\n- **Backend**: Hono.js, SQLite, JWT\n- **Frontend**: React, TailwindCSS\n- **Storage**: Val Town SQLite","label",[135],"79fff9d4-3635-11f0-9b08-9e149126039e","shared","385fa7f5-5cdd-4abb-8968-67d6d5915b5e",2,["D",1747826375642],[145],"aafe4c0c-3635-11f0-8384-9e149126039e",["D",1747826457838],[43],"7e5a3cf6-3635-11f0-8ce9-9e149126039e","backend","65e036bb-53f0-458c-b156-27ce7c7db8f0",3,["D",1747826382944],[154],"pulls","branches","forks","envVars",{"_166":66,"_168":66},"connections",{"_166":66,"_167":66},"count","unfilledCount","emptyCount",{"_47":153,"_32":154,"_30":155,"_137":-5,"_40":41,"_39":156,"_139":62,"_37":263,"_13":66,"_34":45,"_35":-5,"_24":25,"_142":-5,"_184":264,"_27":265},{"_47":259,"_32":251,"_30":245,"_137":155,"_40":41,"_39":156,"_139":62,"_37":260,"_13":66,"_34":45,"_35":-5,"_24":25,"_142":-5,"_184":261,"_27":262},{"_47":252,"_32":253,"_30":254,"_137":245,"_40":41,"_39":156,"_139":62,"_37":255,"_13":66,"_34":191,"_35":256,"_24":25,"_142":-5,"_184":257,"_27":258},{"_47":242,"_32":243,"_30":244,"_137":245,"_40":41,"_39":246,"_139":62,"_37":247,"_13":66,"_34":191,"_35":248,"_24":25,"_142":-5,"_184":249,"_27":250},{"_47":238,"_32":221,"_30":215,"_137":155,"_40":41,"_39":233,"_139":62,"_37":239,"_13":66,"_34":45,"_35":-5,"_24":25,"_142":-5,"_184":240,"_27":241},{"_47":230,"_32":231,"_30":232,"_137":215,"_40":41,"_39":233,"_139":62,"_37":234,"_13":66,"_34":191,"_35":235,"_24":25,"_142":-5,"_184":236,"_27":237},{"_47":222,"_32":223,"_30":224,"_137":215,"_40":41,"_39":225,"_139":62,"_37":226,"_13":66,"_34":191,"_35":227,"_24":25,"_142":-5,"_184":228,"_27":229},{"_47":212,"_32":213,"_30":214,"_137":215,"_40":41,"_39":216,"_139":62,"_37":217,"_13":66,"_34":191,"_35":218,"_24":25,"_142":-5,"_184":219,"_27":220},{"_47":205,"_32":206,"_30":60,"_137":155,"_40":41,"_39":207,"_139":25,"_37":208,"_13":66,"_34":191,"_35":209,"_24":25,"_142":-5,"_184":210,"_27":211},{"_47":150,"_32":43,"_30":44,"_137":-5,"_40":41,"_39":14,"_139":62,"_37":202,"_13":66,"_34":45,"_35":-5,"_24":25,"_142":-5,"_184":203,"_27":204},{"_47":198,"_32":33,"_30":31,"_137":44,"_40":41,"_39":14,"_139":62,"_37":199,"_13":66,"_34":21,"_35":36,"_24":25,"_142":-5,"_184":200,"_27":201},{"_47":144,"_32":145,"_30":146,"_137":-5,"_40":41,"_39":147,"_139":62,"_37":195,"_13":66,"_34":45,"_35":-5,"_24":25,"_142":-5,"_184":196,"_27":197},{"_47":187,"_32":188,"_30":189,"_137":146,"_40":41,"_39":147,"_139":62,"_37":190,"_13":66,"_34":191,"_35":192,"_24":25,"_142":-5,"_184":193,"_27":194},{"_47":134,"_32":135,"_30":136,"_137":-5,"_40":41,"_39":138,"_139":62,"_37":183,"_13":66,"_34":21,"_35":141,"_24":25,"_142":-5,"_184":185,"_27":186},["D",1747826369650],"children",[],[135],"79ffd68e-3635-11f0-9b08-9e149126039e","types.ts","79ffd71a-3635-11f0-9b08-9e149126039e",["D",1747826375642],"script","// User-related types\nexport interface User {\n id: number;\n username: string;\n password?: string; // Only used internally, never sent to client\n}\n\nexport interface UserLoginRequest {\n username: string;\n password: string;\n}\n\nexport interface UserRegisterRequest {\n username: string;\n password: string;\n}\n\nexport interface AuthResponse {\n token: string;\n user: Omit;\n}\n\n// Task-related types\nexport interface Task {\n id: number;\n userId: number;\n title: string;\n description: string;\n completed: boolean;\n createdAt: string;\n}\n\nexport interface CreateTaskRequest {\n title: string;\n description: string;\n}\n\nexport interface UpdateTaskRequest {\n title?: string;\n description?: string;\n completed?: boolean;\n}\n\n// API response types\nexport interface ApiResponse {\n success: boolean;\n data?: T;\n error?: string;\n}",[],[145,188],["D",1747826375642],[181],[145],"aafe0fb2-3635-11f0-8384-9e149126039e",["D",1747826457838],[],[43,33],["D",1747826457838],[179],[43],"a6c6e446-3635-11f0-b9f4-9e149126039e","index.ts",8,["D",1747826450766],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { cors } from \"https://esm.sh/hono@3.11.7/cors\";\nimport { logger } from \"https://esm.sh/hono@3.11.7/logger\";\nimport { initializeDatabase } from \"./database/migrations.ts\";\nimport authRoutes from \"./routes/auth.ts\";\nimport taskRoutes from \"./routes/tasks.ts\";\nimport staticRoutes from \"./routes/static.ts\";\n\n// Initialize the database\nawait initializeDatabase();\n\n// Create the main Hono app\nconst app = new Hono();\n\n// Middleware\napp.use(\"*\", logger());\napp.use(\"*\", cors());\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n console.error(\"Application error:\", err);\n throw err;\n});\n\n// Mount routes\napp.route(\"/api/auth\", authRoutes);\napp.route(\"/api/tasks\", taskRoutes);\napp.route(\"/\", staticRoutes);\n\n// Export the fetch handler for HTTP val\nexport default app.fetch;",[],[154,206],"9cafd8fa-3635-11f0-ae53-9e149126039e","tasks.ts","9cafd9b8-3635-11f0-ae53-9e149126039e","c1a48440-3cc6-4d07-a724-8cd7c8105694",6,["D",1747826433839],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { jwt } from \"https://esm.sh/hono@3.11.7/jwt\";\nimport { \n getTasks, \n getTaskById, \n createTask, \n updateTask, \n deleteTask \n} from \"../database/queries.ts\";\nimport { \n ApiResponse, \n Task, \n CreateTaskRequest, \n UpdateTaskRequest \n} from \"../../shared/types.ts\";\n\n// JWT secret key - in production, use environment variable\nconst JWT_SECRET = Deno.env.get(\"JWT_SECRET\") || \"your-secret-key\";\n\n// Create a new Hono app for task routes\nconst app = new Hono();\n\n// Middleware to verify JWT token\napp.use(\"*\", jwt({ secret: JWT_SECRET }));\n\n// Get all tasks for the authenticated user\napp.get(\"/\", async (c) => {\n try {\n const userId = c.get(\"jwtPayload\").id;\n const tasks = await getTasks(userId);\n \n return c.json>({\n success: true,\n data: tasks\n });\n } catch (error) {\n console.error(\"Error fetching tasks:\", error);\n return c.json>({\n success: false,\n error: \"An error occurred while fetching tasks\"\n }, 500);\n }\n});\n\n// Get a specific task by ID\napp.get(\"/:id\", async (c) => {\n try {\n const userId = c.get(\"jwtPayload\").id;\n const taskId = parseInt(c.req.param(\"id\"));\n \n if (isNaN(taskId)) {\n return c.json>({\n success: false,\n error: \"Invalid task ID\"\n }, 400);\n }\n \n const task = await getTaskById(taskId, userId);\n \n if (!task) {\n return c.json>({\n success: false,\n error: \"Task not found\"\n }, 404);\n }\n \n return c.json>({\n success: true,\n data: task\n });\n } catch (error) {\n console.error(\"Error fetching task:\", error);\n return c.json>({\n success: false,\n error: \"An error occurred while fetching the task\"\n }, 500);\n }\n});\n\n// Create a new task\napp.post(\"/\", async (c) => {\n try {\n const userId = c.get(\"jwtPayload\").id;\n const body = await c.req.json();\n \n // Validate input\n if (!body.title) {\n return c.json>({\n success: false,\n error: \"Title is required\"\n }, 400);\n }\n \n const task = await createTask(userId, body);\n \n return c.json>({\n success: true,\n data: task\n }, 201);\n } catch (error) {\n console.error(\"Error creating task:\", error);\n return c.json>({\n success: false,\n error: \"An error occurred while creating the task\"\n }, 500);\n }\n});\n\n// Update a task\napp.put(\"/:id\", async (c) => {\n try {\n const userId = c.get(\"jwtPayload\").id;\n const taskId = parseInt(c.req.param(\"id\"));\n \n if (isNaN(taskId)) {\n return c.json>({\n success: false,\n error: \"Invalid task ID\"\n }, 400);\n }\n \n const body = await c.req.json();\n \n // Check if task exists\n const existingTask = await getTaskById(taskId, userId);\n if (!existingTask) {\n return c.json>({\n success: false,\n error: \"Task not found\"\n }, 404);\n }\n \n const updatedTask = await updateTask(taskId, userId, body);\n \n return c.json>({\n success: true,\n data: updatedTask!\n });\n } catch (error) {\n console.error(\"Error updating task:\", error);\n return c.json>({\n success: false,\n error: \"An error occurred while updating the task\"\n }, 500);\n }\n});\n\n// Delete a task\napp.delete(\"/:id\", async (c) => {\n try {\n const userId = c.get(\"jwtPayload\").id;\n const taskId = parseInt(c.req.param(\"id\"));\n \n if (isNaN(taskId)) {\n return c.json>({\n success: false,\n error: \"Invalid task ID\"\n }, 400);\n }\n \n // Check if task exists\n const existingTask = await getTaskById(taskId, userId);\n if (!existingTask) {\n return c.json>({\n success: false,\n error: \"Task not found\"\n }, 404);\n }\n \n await deleteTask(taskId, userId);\n \n return c.json>({\n success: true\n });\n } catch (error) {\n console.error(\"Error deleting task:\", error);\n return c.json>({\n success: false,\n error: \"An error occurred while deleting the task\"\n }, 500);\n }\n});\n\nexport default app;",[],[154,221,213],"routes","a1e2d96c-3635-11f0-92af-9e149126039e","static.ts","a1e2da02-3635-11f0-92af-9e149126039e",7,["D",1747826442560],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\n\nconst app = new Hono();\n\n// Serve frontend files\napp.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\n\n// Serve shared files\napp.get(\"/shared/*\", (c) => serveFile(c.req.path, import.meta.url));\n\n// Serve the main HTML file for all other routes (for SPA routing)\napp.get(\"*\", async (c) => {\n try {\n // Read the HTML file\n const html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Return the HTML with the correct content type\n return c.html(html);\n } catch (error) {\n console.error(\"Error serving index.html:\", error);\n return c.text(\"Error loading application\", 500);\n }\n});\n\nexport default app;",[],[154,221,223],"91f26d9c-3635-11f0-991f-9e149126039e","auth.ts","91f26e5a-3635-11f0-991f-9e149126039e",5,["D",1747826415819],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { jwt } from \"https://esm.sh/hono@3.11.7/jwt\";\nimport { createUser, findUserByUsername, validatePassword } from \"../database/queries.ts\";\nimport { UserLoginRequest, UserRegisterRequest, ApiResponse, AuthResponse } from \"../../shared/types.ts\";\n\n// JWT secret key - in production, use environment variable\nconst JWT_SECRET = Deno.env.get(\"JWT_SECRET\") || \"your-secret-key\";\n\n// Create a new Hono app for auth routes\nconst app = new Hono();\n\n// Register a new user\napp.post(\"/register\", async (c) => {\n try {\n const body = await c.req.json();\n \n // Validate input\n if (!body.username || !body.password) {\n return c.json>({\n success: false,\n error: \"Username and password are required\"\n }, 400);\n }\n \n // Check if username already exists\n const existingUser = await findUserByUsername(body.username);\n if (existingUser) {\n return c.json>({\n success: false,\n error: \"Username already exists\"\n }, 400);\n }\n \n // Create the user\n const user = await createUser(body.username, body.password);\n \n // Generate JWT token\n const token = await jwt.sign({ id: user.id }, JWT_SECRET);\n \n return c.json>({\n success: true,\n data: {\n token,\n user\n }\n }, 201);\n } catch (error) {\n console.error(\"Registration error:\", error);\n return c.json>({\n success: false,\n error: \"An error occurred during registration\"\n }, 500);\n }\n});\n\n// Login a user\napp.post(\"/login\", async (c) => {\n try {\n const body = await c.req.json();\n \n // Validate input\n if (!body.username || !body.password) {\n return c.json>({\n success: false,\n error: \"Username and password are required\"\n }, 400);\n }\n \n // Find the user\n const user = await findUserByUsername(body.username);\n if (!user) {\n return c.json>({\n success: false,\n error: \"Invalid username or password\"\n }, 401);\n }\n \n // Validate password\n const isValidPassword = await validatePassword(user, body.password);\n if (!isValidPassword) {\n return c.json>({\n success: false,\n error: \"Invalid username or password\"\n }, 401);\n }\n \n // Generate JWT token\n const token = await jwt.sign({ id: user.id }, JWT_SECRET);\n \n // Remove password from user object\n const { password, ...userWithoutPassword } = user;\n \n return c.json>({\n success: true,\n data: {\n token,\n user: userWithoutPassword\n }\n });\n } catch (error) {\n console.error(\"Login error:\", error);\n return c.json>({\n success: false,\n error: \"An error occurred during login\"\n }, 500);\n }\n});\n\nexport default app;",[],[154,221,231],"91f28ac0-3635-11f0-991f-9e149126039e",["D",1747826415819],[174,175,176],[154,221],"89e36e1c-3635-11f0-8ce9-9e149126039e","queries.ts","89e36eee-3635-11f0-8ce9-9e149126039e","49ef072b-0345-4d68-9782-fc13ecfcc6c6",4,["D",1747826402299],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { USERS_TABLE, TASKS_TABLE } from \"./migrations.ts\";\nimport { User, Task, CreateTaskRequest, UpdateTaskRequest } from \"../../shared/types.ts\";\nimport bcrypt from \"https://esm.sh/bcryptjs@2.4.3\";\n\n// User-related queries\nexport async function findUserByUsername(username: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${USERS_TABLE} WHERE username = ?`,\n [username]\n );\n \n if (result.length === 0) {\n return null;\n }\n \n return {\n id: result[0].id,\n username: result[0].username,\n password: result[0].password\n };\n}\n\nexport async function findUserById(id: number): Promise | null> {\n const result = await sqlite.execute(\n `SELECT id, username FROM ${USERS_TABLE} WHERE id = ?`,\n [id]\n );\n \n if (result.length === 0) {\n return null;\n }\n \n return {\n id: result[0].id,\n username: result[0].username\n };\n}\n\nexport async function createUser(username: string, password: string): Promise> {\n // Hash the password\n const hashedPassword = await bcrypt.hash(password, 10);\n \n // Insert the user\n const result = await sqlite.execute(\n `INSERT INTO ${USERS_TABLE} (username, password) VALUES (?, ?) RETURNING id, username`,\n [username, hashedPassword]\n );\n \n return {\n id: result[0].id,\n username: result[0].username\n };\n}\n\nexport async function validatePassword(user: User, password: string): Promise {\n return bcrypt.compare(password, user.password!);\n}\n\n// Task-related queries\nexport async function getTasks(userId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TASKS_TABLE} WHERE user_id = ? ORDER BY created_at DESC`,\n [userId]\n );\n \n return result.map(row => ({\n id: row.id,\n userId: row.user_id,\n title: row.title,\n description: row.description || \"\",\n completed: Boolean(row.completed),\n createdAt: row.created_at\n }));\n}\n\nexport async function getTaskById(id: number, userId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TASKS_TABLE} WHERE id = ? AND user_id = ?`,\n [id, userId]\n );\n \n if (result.length === 0) {\n return null;\n }\n \n return {\n id: result[0].id,\n userId: result[0].user_id,\n title: result[0].title,\n description: result[0].description || \"\",\n completed: Boolean(result[0].completed),\n createdAt: result[0].created_at\n };\n}\n\nexport async function createTask(userId: number, task: CreateTaskRequest): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${TASKS_TABLE} (user_id, title, description) \n VALUES (?, ?, ?) \n RETURNING id, user_id, title, description, completed, created_at`,\n [userId, task.title, task.description || \"\"]\n );\n \n return {\n id: result[0].id,\n userId: result[0].user_id,\n title: result[0].title,\n description: result[0].description || \"\",\n completed: Boolean(result[0].completed),\n createdAt: result[0].created_at\n };\n}\n\nexport async function updateTask(id: number, userId: number, updates: UpdateTaskRequest): Promise {\n // Build the SET clause dynamically based on provided updates\n const setClauses = [];\n const params = [];\n \n if (updates.title !== undefined) {\n setClauses.push(\"title = ?\");\n params.push(updates.title);\n }\n \n if (updates.description !== undefined) {\n setClauses.push(\"description = ?\");\n params.push(updates.description);\n }\n \n if (updates.completed !== undefined) {\n setClauses.push(\"completed = ?\");\n params.push(updates.completed ? 1 : 0);\n }\n \n if (setClauses.length === 0) {\n return await getTaskById(id, userId);\n }\n \n // Add id and userId to params\n params.push(id);\n params.push(userId);\n \n const result = await sqlite.execute(\n `UPDATE ${TASKS_TABLE} \n SET ${setClauses.join(\", \")} \n WHERE id = ? AND user_id = ? \n RETURNING id, user_id, title, description, completed, created_at`,\n params\n );\n \n if (result.length === 0) {\n return null;\n }\n \n return {\n id: result[0].id,\n userId: result[0].user_id,\n title: result[0].title,\n description: result[0].description || \"\",\n completed: Boolean(result[0].completed),\n createdAt: result[0].created_at\n };\n}\n\nexport async function deleteTask(id: number, userId: number): Promise {\n const result = await sqlite.execute(\n `DELETE FROM ${TASKS_TABLE} WHERE id = ? AND user_id = ?`,\n [id, userId]\n );\n \n return result.rowsAffected > 0;\n}",[],[154,251,243],"database","7e5a2086-3635-11f0-8ce9-9e149126039e","migrations.ts","7e5a2162-3635-11f0-8ce9-9e149126039e",["D",1747826382944],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table names - change these when modifying schema\nexport const USERS_TABLE = \"task_manager_users\";\nexport const TASKS_TABLE = \"task_manager_tasks\";\n\n/**\n * Initialize the database schema\n */\nexport async function initializeDatabase() {\n // Create users table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${USERS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT UNIQUE NOT NULL,\n password TEXT NOT NULL,\n created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Create tasks table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TASKS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER NOT NULL,\n title TEXT NOT NULL,\n description TEXT,\n completed BOOLEAN DEFAULT 0,\n created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE} (id)\n )\n `);\n\n console.log(\"Database initialized successfully\");\n}",[],[154,251,253],"7e5a4016-3635-11f0-8ce9-9e149126039e",["D",1747826382944],[171,172],[154,251],["D",1747826382944],[170,173,177],[154],["D",1747826310786],{"_100":99,"_107":103},{"_100":99,"_101":-5,"_102":103,"_18":58,"_104":105,"_106":25},{"_13":89,"_32":90,"_47":41,"_91":48,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":49,"_98":99},"ctx",{"_82":-5,"_127":303,"_304":305,"_306":307,"_308":25,"_309":25,"_310":25,"_311":62,"_312":-5,"_313":-7,"_314":-7,"_315":66,"_316":25,"_317":25,"_318":-5,"_319":25,"_320":25,"_321":25,"_322":-5},"ENV",{"_274":275,"_276":277,"_278":90,"_279":280,"_281":282,"_283":284,"_285":286,"_287":288,"_289":290,"_291":292,"_293":294,"_295":296,"_297":298,"_299":300,"_301":302},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","c73f21da490985bff19c279eb0e09db24d688e4f","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"]

Diff · v9