[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_206":207,"_208":209},"routes/_app.x.$handle.$name",{"_95":94,"_31":44,"_103":85,"_26":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":24,"_118":119,"_120":24,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":24},"version",4,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","backend/database/queries.ts","latestPath","fileId","89e36eee-3635-11f0-8ce9-9e149126039e","name","queries.ts","fileType","script","content","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}","createdAt",["D",1747826402299],"branchVersion","branchId","5357797e-3635-11f0-a945-9e149126039e","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",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":24},"branch",{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"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",{"_42":43,"_31":44,"_37":202,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":203,"_79":204,"_81":205,"_83":24},"tree",[161,165,167],"files",[161,162,163,164,165,166,167],"counts",{"_151":61,"_152":132,"_153":61,"_154":155,"_156":157},"contents",[125,126,127],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":145,"_31":146,"_29":147,"_131":-5,"_40":41,"_39":148,"_133":57,"_37":149,"_13":61,"_33":143,"_35":-5,"_23":24,"_136":-5,"_26":150},{"_42":138,"_31":139,"_29":140,"_131":-5,"_40":41,"_39":141,"_133":57,"_37":142,"_13":61,"_33":143,"_35":-5,"_23":24,"_136":-5,"_26":144},{"_42":128,"_31":129,"_29":130,"_131":-5,"_40":41,"_39":132,"_133":57,"_37":134,"_13":61,"_33":20,"_35":135,"_23":24,"_136":-5,"_26":137},"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",[129],"79fff9d4-3635-11f0-9b08-9e149126039e","shared","385fa7f5-5cdd-4abb-8968-67d6d5915b5e",2,["D",1747826375642],"directory",[139],"7e5a3cf6-3635-11f0-8ce9-9e149126039e","backend","65e036bb-53f0-458c-b156-27ce7c7db8f0",3,["D",1747826382944],[146],"pulls","branches","forks","envVars",{"_158":61,"_160":61},"connections",{"_158":61,"_159":61},"count","unfilledCount","emptyCount",{"_42":145,"_31":146,"_29":147,"_131":-5,"_40":41,"_39":148,"_133":57,"_37":199,"_13":61,"_33":143,"_35":-5,"_23":24,"_136":-5,"_169":200,"_26":201},{"_42":195,"_31":187,"_29":183,"_131":147,"_40":41,"_39":148,"_133":57,"_37":196,"_13":61,"_33":143,"_35":-5,"_23":24,"_136":-5,"_169":197,"_26":198},{"_42":188,"_31":189,"_29":190,"_131":183,"_40":41,"_39":148,"_133":57,"_37":191,"_13":61,"_33":34,"_35":192,"_23":24,"_136":-5,"_169":193,"_26":194},{"_42":182,"_31":32,"_29":30,"_131":183,"_40":41,"_39":14,"_133":57,"_37":184,"_13":61,"_33":34,"_35":36,"_23":24,"_136":-5,"_169":185,"_26":186},{"_42":138,"_31":139,"_29":140,"_131":-5,"_40":41,"_39":141,"_133":57,"_37":179,"_13":61,"_33":143,"_35":-5,"_23":24,"_136":-5,"_169":180,"_26":181},{"_42":172,"_31":173,"_29":174,"_131":140,"_40":41,"_39":141,"_133":57,"_37":175,"_13":61,"_33":34,"_35":176,"_23":24,"_136":-5,"_169":177,"_26":178},{"_42":128,"_31":129,"_29":130,"_131":-5,"_40":41,"_39":132,"_133":57,"_37":168,"_13":61,"_33":20,"_35":135,"_23":24,"_136":-5,"_169":170,"_26":171},["D",1747826369650],"children",[],[129],"79ffd68e-3635-11f0-9b08-9e149126039e","types.ts","79ffd71a-3635-11f0-9b08-9e149126039e",["D",1747826375642],"// 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}",[],[139,173],["D",1747826375642],[166],[139],"89e36e1c-3635-11f0-8ce9-9e149126039e","49ef072b-0345-4d68-9782-fc13ecfcc6c6",["D",1747826402299],[],[146,187,32],"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}",[],[146,187,189],"7e5a4016-3635-11f0-8ce9-9e149126039e",["D",1747826382944],[163,164],[146,187],["D",1747826382944],[162],[146],["D",1747826310786],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":24},{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"ctx",{"_77":-5,"_122":239,"_240":241,"_242":243,"_244":24,"_245":24,"_246":24,"_247":57,"_248":-5,"_249":-7,"_250":-7,"_251":61,"_252":24,"_253":24,"_254":-5,"_255":24,"_256":24,"_257":24,"_258":-5},"ENV",{"_210":211,"_212":213,"_214":85,"_215":216,"_217":218,"_219":220,"_221":222,"_223":224,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234,"_235":236,"_237":238},"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 · v4