\n \n \n \n\n",[],[256,258],"eb8433b8-3635-11f0-bd45-9e149126039e","TaskList.tsx","eb843494-3635-11f0-bd45-9e149126039e","cb32ae7f-d51c-4f6d-bff0-348555ad61ea",14,["D",1747826566092],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { Task } from \"../../shared/types.ts\";\nimport TaskForm from \"./TaskForm.tsx\";\n\ninterface TaskListProps {\n token: string;\n}\n\nconst TaskList: React.FC = ({ token }) => {\n const [tasks, setTasks] = useState([]);\n const [isLoading, setIsLoading] = useState(true);\n const [error, setError] = useState(null);\n const [editingTask, setEditingTask] = useState(null);\n \n // Fetch tasks from the API\n const fetchTasks = async () => {\n setIsLoading(true);\n setError(null);\n \n try {\n const response = await fetch(\"/api/tasks\", {\n headers: {\n \"Authorization\": `Bearer ${token}`\n }\n });\n \n const data = await response.json();\n \n if (!data.success) {\n setError(data.error || \"Failed to fetch tasks\");\n return;\n }\n \n setTasks(data.data);\n } catch (err) {\n console.error(\"Error fetching tasks:\", err);\n setError(\"An error occurred while fetching tasks\");\n } finally {\n setIsLoading(false);\n }\n };\n \n // Load tasks on component mount\n useEffect(() => {\n fetchTasks();\n }, [token]);\n \n // Toggle task completion status\n const toggleTaskCompletion = async (task: Task) => {\n try {\n const response = await fetch(`/api/tasks/${task.id}`, {\n method: \"PUT\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"Authorization\": `Bearer ${token}`\n },\n body: JSON.stringify({\n completed: !task.completed\n }),\n });\n \n const data = await response.json();\n \n if (!data.success) {\n setError(data.error || \"Failed to update task\");\n return;\n }\n \n // Update the task in the local state\n setTasks(tasks.map(t => t.id === task.id ? data.data : t));\n } catch (err) {\n console.error(\"Error updating task:\", err);\n setError(\"An error occurred while updating the task\");\n }\n };\n \n // Delete a task\n const deleteTask = async (taskId: number) => {\n if (!confirm(\"Are you sure you want to delete this task?\")) {\n return;\n }\n \n try {\n const response = await fetch(`/api/tasks/${taskId}`, {\n method: \"DELETE\",\n headers: {\n \"Authorization\": `Bearer ${token}`\n }\n });\n \n const data = await response.json();\n \n if (!data.success) {\n setError(data.error || \"Failed to delete task\");\n return;\n }\n \n // Remove the task from the local state\n setTasks(tasks.filter(t => t.id !== taskId));\n } catch (err) {\n console.error(\"Error deleting task:\", err);\n setError(\"An error occurred while deleting the task\");\n }\n };\n \n // Start editing a task\n const startEditingTask = (task: Task) => {\n setEditingTask(task);\n };\n \n // Cancel editing\n const cancelEditing = () => {\n setEditingTask(null);\n };\n \n // Render loading state\n if (isLoading && tasks.length === 0) {\n return (\n

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

\n {/* Error message */}\n {error && (\n

\n {error}\n \n

\n )}\n \n {/* Task editing form */}\n {editingTask && (\n \n )}\n \n {/* Task list */}\n

\n Your Tasks {tasks.length > 0 && `(${tasks.length})`}\n

\n \n {tasks.length === 0 ? (\n

You don't have any tasks yet. Create one above!

\n ) : (\n tasks.map(task => (\n

\n toggleTaskCompletion(task)}\n className=\"mt-1 h-5 w-5 text-blue-600 focus:ring-blue-500 border-gray-300 rounded\"\n />\n

\n {task.title}\n

\n {task.description && (\n

\n {task.description}\n

\n )}\n

\n Created: {new Date(task.createdAt).toLocaleString()}\n

\n \n

\n startEditingTask(task)}\n className=\"text-blue-500 hover:text-blue-700\"\n title=\"Edit task\"\n >\n \n \n deleteTask(task.id)}\n className=\"text-red-500 hover:text-red-700\"\n title=\"Delete task\"\n >\n \n \n

\n ))\n )}\n

\n );\n};\n\nexport default TaskList;",[],[256,274,266],"components","d98c73e6-3635-11f0-ad4d-9e149126039e","TaskForm.tsx","d98c74d6-3635-11f0-ad4d-9e149126039e",13,["D",1747826535948],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport { CreateTaskRequest } from \"../../shared/types.ts\";\n\ninterface TaskFormProps {\n token: string;\n taskToEdit?: {\n id: number;\n title: string;\n description: string;\n };\n onTaskCreated?: () => void;\n onTaskUpdated?: () => void;\n onCancel?: () => void;\n}\n\nconst TaskForm: React.FC = ({ \n token, \n taskToEdit, \n onTaskCreated, \n onTaskUpdated,\n onCancel \n}) => {\n const [title, setTitle] = useState(taskToEdit?.title || \"\");\n const [description, setDescription] = useState(taskToEdit?.description || \"\");\n const [error, setError] = useState(null);\n const [isLoading, setIsLoading] = useState(false);\n \n const isEditMode = !!taskToEdit;\n \n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n \n // Validate form\n if (!title.trim()) {\n setError(\"Title is required\");\n return;\n }\n \n setIsLoading(true);\n setError(null);\n \n try {\n const taskData: CreateTaskRequest = {\n title: title.trim(),\n description: description.trim()\n };\n \n let url = \"/api/tasks\";\n let method = \"POST\";\n \n if (isEditMode) {\n url = `/api/tasks/${taskToEdit.id}`;\n method = \"PUT\";\n }\n \n const response = await fetch(url, {\n method,\n headers: {\n \"Content-Type\": \"application/json\",\n \"Authorization\": `Bearer ${token}`\n },\n body: JSON.stringify(taskData),\n });\n \n const data = await response.json();\n \n if (!data.success) {\n setError(data.error || \"Failed to save task\");\n return;\n }\n \n // Reset form after successful creation\n if (!isEditMode) {\n setTitle(\"\");\n setDescription(\"\");\n if (onTaskCreated) onTaskCreated();\n } else {\n if (onTaskUpdated) onTaskUpdated();\n if (onCancel) onCancel();\n }\n } catch (err) {\n console.error(\"Task save error:\", err);\n setError(\"An error occurred while saving the task\");\n } finally {\n setIsLoading(false);\n }\n };\n \n return (\n

\n {isEditMode ? \"Edit Task\" : \"Create New Task\"}\n

\n \n {error && (\n

\n {error}\n

\n )}\n \n

\n \n Title\n \n setTitle(e.target.value)}\n className=\"shadow appearance-none border rounded w-full py-2 px-3 text-gray-700 leading-tight focus:outline-none focus:shadow-outline\"\n placeholder=\"Task title\"\n />\n

\n \n

\n \n Description\n \n setDescription(e.target.value)}\n className=\"shadow appearance-none border rounded w-full py-2 px-3 text-gray-700 leading-tight focus:outline-none focus:shadow-outline\"\n placeholder=\"Task description (optional)\"\n rows={3}\n />\n

\n \n

\n \n {isLoading ? (\n \n \n Saving...\n \n ) : (\n isEditMode ? \"Update Task\" : \"Create Task\"\n )}\n \n \n {isEditMode && onCancel && (\n \n Cancel\n \n )}\n

\n );\n};\n\nexport default TaskForm;",[],[256,274,276],"cd20cf76-3635-11f0-804c-9e149126039e","Register.tsx","cd20d034-3635-11f0-804c-9e149126039e",12,["D",1747826515105],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport { AuthResponse } from \"../../shared/types.ts\";\n\ninterface RegisterProps {\n onRegisterSuccess: (authResponse: AuthResponse) => void;\n onSwitchToLogin: () => void;\n}\n\nconst Register: React.FC = ({ onRegisterSuccess, onSwitchToLogin }) => {\n const [username, setUsername] = useState(\"\");\n const [password, setPassword] = useState(\"\");\n const [confirmPassword, setConfirmPassword] = useState(\"\");\n const [error, setError] = useState(null);\n const [isLoading, setIsLoading] = useState(false);\n \n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n \n // Validate form\n if (!username || !password || !confirmPassword) {\n setError(\"All fields are required\");\n return;\n }\n \n if (password !== confirmPassword) {\n setError(\"Passwords do not match\");\n return;\n }\n \n if (password.length < 6) {\n setError(\"Password must be at least 6 characters long\");\n return;\n }\n \n setIsLoading(true);\n setError(null);\n \n try {\n const response = await fetch(\"/api/auth/register\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ username, password }),\n });\n \n const data = await response.json();\n \n if (!data.success) {\n setError(data.error || \"Registration failed\");\n return;\n }\n \n onRegisterSuccess(data.data);\n } catch (err) {\n console.error(\"Registration error:\", err);\n setError(\"An error occurred during registration\");\n } finally {\n setIsLoading(false);\n }\n };\n \n return (\n

Register

\n \n {error && (\n

\n {error}\n

\n )}\n \n

\n \n Username\n \n setUsername(e.target.value)}\n className=\"shadow appearance-none border rounded w-full py-2 px-3 text-gray-700 leading-tight focus:outline-none focus:shadow-outline\"\n placeholder=\"Choose a username\"\n />\n

\n \n

\n \n Password\n \n setPassword(e.target.value)}\n className=\"shadow appearance-none border rounded w-full py-2 px-3 text-gray-700 leading-tight focus:outline-none focus:shadow-outline\"\n placeholder=\"Choose a password\"\n />\n

\n \n

\n \n Confirm Password\n \n setConfirmPassword(e.target.value)}\n className=\"shadow appearance-none border rounded w-full py-2 px-3 text-gray-700 leading-tight focus:outline-none focus:shadow-outline\"\n placeholder=\"Confirm your password\"\n />\n

\n \n

\n \n {isLoading ? (\n \n \n Registering...\n \n ) : (\n \"Register\"\n )}\n \n

\n \n

\n Already have an account?{\" \"}\n \n Login\n \n

\n );\n};\n\nexport default Register;",[],[256,274,284],"c13e2ac8-3635-11f0-ac02-9e149126039e","Login.tsx","c13e2b72-3635-11f0-ac02-9e149126039e",11,["D",1747826495169],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport { AuthResponse } from \"../../shared/types.ts\";\n\ninterface LoginProps {\n onLoginSuccess: (authResponse: AuthResponse) => void;\n onSwitchToRegister: () => void;\n}\n\nconst Login: React.FC = ({ onLoginSuccess, onSwitchToRegister }) => {\n const [username, setUsername] = useState(\"\");\n const [password, setPassword] = useState(\"\");\n const [error, setError] = useState(null);\n const [isLoading, setIsLoading] = useState(false);\n \n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n \n // Validate form\n if (!username || !password) {\n setError(\"Username and password are required\");\n return;\n }\n \n setIsLoading(true);\n setError(null);\n \n try {\n const response = await fetch(\"/api/auth/login\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ username, password }),\n });\n \n const data = await response.json();\n \n if (!data.success) {\n setError(data.error || \"Login failed\");\n return;\n }\n \n onLoginSuccess(data.data);\n } catch (err) {\n console.error(\"Login error:\", err);\n setError(\"An error occurred during login\");\n } finally {\n setIsLoading(false);\n }\n };\n \n return (\n

Login

\n \n {error && (\n

\n {error}\n

\n )}\n \n

\n \n

\n \n {isLoading ? (\n \n \n Logging in...\n \n ) : (\n \"Login\"\n )}\n \n

\n \n

\n Don't have an account?{\" \"}\n \n Register\n \n

\n );\n};\n\nexport default Login;",[],[256,274,292],"b55643c6-3635-11f0-9e0c-9e149126039e","App.tsx","b5564466-3635-11f0-9e0c-9e149126039e",10,["D",1747826475193],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { AuthResponse, User } from \"../../shared/types.ts\";\nimport Login from \"./Login.tsx\";\nimport Register from \"./Register.tsx\";\nimport TaskList from \"./TaskList.tsx\";\nimport TaskForm from \"./TaskForm.tsx\";\n\nconst App: React.FC = () => {\n const [user, setUser] = useState | null>(null);\n const [token, setToken] = useState(null);\n const [isLoading, setIsLoading] = useState(true);\n const [view, setView] = useState<\"login\" | \"register\" | \"tasks\">(\"login\");\n \n // Check for existing token on load\n useEffect(() => {\n const storedToken = localStorage.getItem(\"token\");\n const storedUser = localStorage.getItem(\"user\");\n \n if (storedToken && storedUser) {\n setToken(storedToken);\n setUser(JSON.parse(storedUser));\n setView(\"tasks\");\n }\n \n setIsLoading(false);\n }, []);\n \n // Handle successful authentication\n const handleAuthSuccess = (authResponse: AuthResponse) => {\n setToken(authResponse.token);\n setUser(authResponse.user);\n localStorage.setItem(\"token\", authResponse.token);\n localStorage.setItem(\"user\", JSON.stringify(authResponse.user));\n setView(\"tasks\");\n };\n \n // Handle logout\n const handleLogout = () => {\n setToken(null);\n setUser(null);\n localStorage.removeItem(\"token\");\n localStorage.removeItem(\"user\");\n setView(\"login\");\n };\n \n // Switch between login and register views\n const toggleAuthView = () => {\n setView(view === \"login\" ? \"register\" : \"login\");\n };\n \n if (isLoading) {\n return (\n

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

\n {/* Header */}\n

Personal Task Manager

\n {user && (\n

Welcome, {user.username}

\n \n

\n )}\n

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

\n {view === \"login\" && (\n \n )}\n \n {view === \"register\" && (\n \n )}\n \n {view === \"tasks\" && token && (\n

\n \n \n

\n )}\n

\n \n {/* Footer */}\n \n

\n );\n};\n\nexport default App;",[],[256,274,300],"b556826e-3635-11f0-9e0c-9e149126039e",["D",1747826475193],[215,216,217,218,219],[256,274],"aafe4c0c-3635-11f0-8384-9e149126039e",["D",1747826457838],[214,220,221],[256],["D",1747826576549],[],[18,93],"9cafd8fa-3635-11f0-ae53-9e149126039e","tasks.ts","9cafd9b8-3635-11f0-ae53-9e149126039e",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;",[],[18,83,319],"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;",[],[18,83,327],"91f26d9c-3635-11f0-991f-9e149126039e","auth.ts","91f26e5a-3635-11f0-991f-9e149126039e",["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;",[],[18,83,335],["D",1747826415819],[209,210,211],[18,83],"89e36e1c-3635-11f0-8ce9-9e149126039e","queries.ts","89e36eee-3635-11f0-8ce9-9e149126039e",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}",[],[18,67,345],"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}",[],[18,67,353],["D",1747826382944],[206,207],[18,67],["D",1747826382944],[205,208,212],[18],["D",1747826310786],{"_11":12,"_151":73},{"_11":12,"_147":-5,"_72":73,"_31":71,"_148":149,"_150":30},{"_42":97,"_13":16,"_36":39,"_139":106,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":14,"_146":12},"ctx",{"_55":-5,"_170":402,"_403":404,"_405":406,"_407":30,"_408":30,"_409":30,"_410":24,"_411":-5,"_412":-7,"_413":-7,"_414":26,"_415":30,"_416":30,"_417":-5,"_418":30,"_419":30,"_420":30,"_421":-5},"ENV",{"_373":374,"_375":376,"_377":16,"_378":379,"_380":381,"_382":383,"_384":385,"_386":387,"_388":389,"_390":391,"_392":393,"_394":395,"_396":397,"_398":399,"_400":401},"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"]

History · backend