[{"_1":2,"_170":-5,"_171":-5},"loaderData",{"_3":4,"_91":92},"root",{"_5":6,"_34":35,"_64":65},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","ENV",{"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61,"_62":63},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","40d33e9c7bacd1f32863183408ee0e4ae3e5f5a3","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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","API_URL","https://api.val.town","clerkState",{"_66":67},"__internal_clerk_state",{"_68":69,"_70":45,"_71":72,"_73":72,"_74":20,"_75":72,"_76":72,"_77":72,"_78":72,"_79":80,"_89":20,"_90":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_81":20,"_19":20,"_82":72,"_83":84,"_85":72,"_86":45,"_87":20,"_88":72},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_93":94,"_95":96,"_97":98,"_99":100,"_146":147,"_167":168,"_169":-5},"handle","stevekrouse","name","complex-test-app","path","backend/index.ts","project",{"_101":102,"_95":96,"_103":104,"_105":-5,"_106":20,"_107":108,"_109":-5,"_110":-5,"_12":111,"_112":-5,"_113":20,"_114":-5,"_115":32,"_14":116,"_117":118,"_119":118,"_120":121,"_122":121,"_123":121,"_124":118,"_125":118,"_23":126,"_129":130,"_132":133,"_145":20},"id","df5ec440-998b-11f0-ad22-0224a6c84d84","createdAt",["D",1758748647548],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","pinnedFileId","pinPreview","screenshotVersion","likeCount","e81e7335-6d4c-4764-a902-d0962bbfa9f7","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_127":128},"profileImageUrl","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg","org",{"_93":94,"_131":128},"avatar","branch",{"_134":135,"_95":43,"_101":136,"_137":102,"_138":-5,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":96,"_144":94},"version",6,"df5f17e2-998b-11f0-ad22-0224a6c84d84","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_101":148,"_95":149,"_150":151,"_152":153,"_154":136,"_155":135,"_156":157,"_103":158,"_134":32,"_159":160,"_161":162,"_163":20,"_164":-5,"_97":165},"99a4a9fa-998c-11f0-afb6-0224a6c84d84","index.ts","fileId","99a4aa9a-998c-11f0-afb6-0224a6c84d84","parentId","d9a22809-ea0d-4b87-b382-8cb2afb29eea","branchId","branchVersion","latest",true,["D",1758748960057],"fileType","script","content","// Main backend entry point for the Advanced Todo App\n\nimport { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { cors } from \"https://esm.sh/hono@3.11.7/middleware\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { runMigrations, seedSampleData } from \"./database/migrations.ts\";\nimport * as queries from \"./database/queries.ts\";\nimport { \n Todo, Category, Tag, Goal, Statistics, UserPreferences, \n Achievement, TodoFilters, CreateTodoRequest, UpdateTodoRequest,\n CreateCategoryRequest, CreateTagRequest, CreateGoalRequest,\n BulkOperation, ExportOptions, ApiResponse, PaginatedResponse\n} from \"../shared/types.ts\";\nimport { exportToJson, exportToCsv, exportToMarkdown } from \"../shared/utils.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err) => Promise.reject(err));\n\n// Initialize database on startup\nlet dbInitialized = false;\nasync function initializeDatabase() {\n if (!dbInitialized) {\n console.log('🚀 Initializing database...');\n await runMigrations();\n await seedSampleData();\n dbInitialized = true;\n console.log('✅ Database initialized successfully');\n }\n}\n\n// Middleware\napp.use('*', cors());\n\n// Initialize database before handling requests\napp.use('*', async (c, next) => {\n await initializeDatabase();\n await next();\n});\n\n// Serve static files\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Serve main HTML with initial data injection\napp.get(\"/\", async c => {\n try {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject initial data to avoid extra round-trips\n const [todos, categories, tags, preferences, stats] = await Promise.all([\n queries.getAllTodos(),\n queries.getAllCategories(),\n queries.getAllTags(),\n queries.getUserPreferences(),\n queries.getStatistics()\n ]);\n \n const initialData = {\n todos,\n categories,\n tags,\n preferences,\n stats,\n timestamp: new Date().toISOString()\n };\n \n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n } catch (error) {\n console.error('Error serving main page:', error);\n return c.text('Error loading application', 500);\n }\n});\n\n// API Routes\n\n// Todos API\napp.get(\"/api/todos\", async c => {\n try {\n const query = c.req.query();\n const filters: TodoFilters = {\n search: query.search || '',\n category_id: query.category_id ? parseInt(query.category_id) : null,\n priority: query.priority || null,\n completed: query.completed ? query.completed === 'true' : null,\n due_date_range: {\n start: query.due_date_start || null,\n end: query.due_date_end || null\n },\n tags: query.tags ? query.tags.split(',').map(id => parseInt(id)) : [],\n has_attachments: query.has_attachments ? query.has_attachments === 'true' : null,\n overdue_only: query.overdue_only === 'true'\n };\n \n const todos = await queries.getAllTodos(filters);\n \n // Add tags for each todo\n for (const todo of todos) {\n const tags = await queries.getTagsForTodo(todo.id);\n (todo as any).tags = tags;\n }\n \n return c.json({ success: true, data: todos } as ApiResponse);\n } catch (error) {\n console.error('Error fetching todos:', error);\n return c.json({ success: false, error: 'Failed to fetch todos' }, 500);\n }\n});\n\napp.get(\"/api/todos/:id\", async c => {\n try {\n const id = parseInt(c.req.param('id'));\n const todo = await queries.getTodoById(id);\n \n if (!todo) {\n return c.json({ success: false, error: 'Todo not found' }, 404);\n }\n \n // Add tags\n const tags = await queries.getTagsForTodo(todo.id);\n (todo as any).tags = tags;\n \n return c.json({ success: true, data: todo } as ApiResponse);\n } catch (error) {\n console.error('Error fetching todo:', error);\n return c.json({ success: false, error: 'Failed to fetch todo' }, 500);\n }\n});\n\napp.post(\"/api/todos\", async c => {\n try {\n const body = await c.req.json() as CreateTodoRequest & { tags?: number[] };\n const { tags, ...todoData } = body;\n \n const todo = await queries.createTodo(todoData);\n \n // Add tags if provided\n if (tags && tags.length > 0) {\n await queries.setTodoTags(todo.id, tags);\n }\n \n // Get the complete todo with tags\n const completeTodo = await queries.getTodoById(todo.id);\n if (completeTodo) {\n const todoTags = await queries.getTagsForTodo(todo.id);\n (completeTodo as any).tags = todoTags;\n }\n \n return c.json({ success: true, data: completeTodo, message: 'Todo created successfully' } as ApiResponse);\n } catch (error) {\n console.error('Error creating todo:', error);\n return c.json({ success: false, error: 'Failed to create todo' }, 500);\n }\n});\n\napp.put(\"/api/todos/:id\", async c => {\n try {\n const id = parseInt(c.req.param('id'));\n const body = await c.req.json() as UpdateTodoRequest & { tags?: number[] };\n const { tags, ...updates } = body;\n \n const todo = await queries.updateTodo(id, updates);\n \n if (!todo) {\n return c.json({ success: false, error: 'Todo not found' }, 404);\n }\n \n // Update tags if provided\n if (tags !== undefined) {\n await queries.setTodoTags(id, tags);\n }\n \n // Get the complete todo with tags\n const completeTodo = await queries.getTodoById(id);\n if (completeTodo) {\n const todoTags = await queries.getTagsForTodo(id);\n (completeTodo as any).tags = todoTags;\n }\n \n return c.json({ success: true, data: completeTodo, message: 'Todo updated successfully' } as ApiResponse);\n } catch (error) {\n console.error('Error updating todo:', error);\n return c.json({ success: false, error: 'Failed to update todo' }, 500);\n }\n});\n\napp.delete(\"/api/todos/:id\", async c => {\n try {\n const id = parseInt(c.req.param('id'));\n const success = await queries.deleteTodo(id);\n \n if (!success) {\n return c.json({ success: false, error: 'Todo not found' }, 404);\n }\n \n return c.json({ success: true, message: 'Todo deleted successfully' } as ApiResponse);\n } catch (error) {\n console.error('Error deleting todo:', error);\n return c.json({ success: false, error: 'Failed to delete todo' }, 500);\n }\n});\n\napp.post(\"/api/todos/:id/toggle\", async c => {\n try {\n const id = parseInt(c.req.param('id'));\n const todo = await queries.toggleTodoCompletion(id);\n \n if (!todo) {\n return c.json({ success: false, error: 'Todo not found' }, 404);\n }\n \n // Add tags\n const tags = await queries.getTagsForTodo(todo.id);\n (todo as any).tags = tags;\n \n return c.json({ success: true, data: todo, message: 'Todo toggled successfully' } as ApiResponse);\n } catch (error) {\n console.error('Error toggling todo:', error);\n return c.json({ success: false, error: 'Failed to toggle todo' }, 500);\n }\n});\n\napp.post(\"/api/todos/reorder\", async c => {\n try {\n const { todoIds } = await c.req.json() as { todoIds: number[] };\n await queries.updateTodoPositions(todoIds);\n \n return c.json({ success: true, message: 'Todos reordered successfully' } as ApiResponse);\n } catch (error) {\n console.error('Error reordering todos:', error);\n return c.json({ success: false, error: 'Failed to reorder todos' }, 500);\n }\n});\n\napp.post(\"/api/todos/bulk\", async c => {\n try {\n const operation = await c.req.json() as BulkOperation;\n await queries.executeBulkOperation(operation);\n \n return c.json({ success: true, message: 'Bulk operation completed successfully' } as ApiResponse);\n } catch (error) {\n console.error('Error executing bulk operation:', error);\n return c.json({ success: false, error: 'Failed to execute bulk operation' }, 500);\n }\n});\n\n// Categories API\napp.get(\"/api/categories\", async c => {\n try {\n const categories = await queries.getAllCategories();\n return c.json({ success: true, data: categories } as ApiResponse);\n } catch (error) {\n console.error('Error fetching categories:', error);\n return c.json({ success: false, error: 'Failed to fetch categories' }, 500);\n }\n});\n\napp.post(\"/api/categories\", async c => {\n try {\n const body = await c.req.json() as CreateCategoryRequest;\n const category = await queries.createCategory(body);\n \n return c.json({ success: true, data: category, message: 'Category created successfully' } as ApiResponse);\n } catch (error) {\n console.error('Error creating category:', error);\n return c.json({ success: false, error: 'Failed to create category' }, 500);\n }\n});\n\napp.put(\"/api/categories/:id\", async c => {\n try {\n const id = parseInt(c.req.param('id'));\n const updates = await c.req.json() as Partial;\n const category = await queries.updateCategory(id, updates);\n \n if (!category) {\n return c.json({ success: false, error: 'Category not found' }, 404);\n }\n \n return c.json({ success: true, data: category, message: 'Category updated successfully' } as ApiResponse);\n } catch (error) {\n console.error('Error updating category:', error);\n return c.json({ success: false, error: 'Failed to update category' }, 500);\n }\n});\n\napp.delete(\"/api/categories/:id\", async c => {\n try {\n const id = parseInt(c.req.param('id'));\n const success = await queries.deleteCategory(id);\n \n if (!success) {\n return c.json({ success: false, error: 'Category not found' }, 404);\n }\n \n return c.json({ success: true, message: 'Category deleted successfully' } as ApiResponse);\n } catch (error) {\n console.error('Error deleting category:', error);\n return c.json({ success: false, error: 'Failed to delete category' }, 500);\n }\n});\n\n// Tags API\napp.get(\"/api/tags\", async c => {\n try {\n const tags = await queries.getAllTags();\n return c.json({ success: true, data: tags } as ApiResponse);\n } catch (error) {\n console.error('Error fetching tags:', error);\n return c.json({ success: false, error: 'Failed to fetch tags' }, 500);\n }\n});\n\napp.post(\"/api/tags\", async c => {\n try {\n const body = await c.req.json() as CreateTagRequest;\n const tag = await queries.createTag(body);\n \n return c.json({ success: true, data: tag, message: 'Tag created successfully' } as ApiResponse);\n } catch (error) {\n console.error('Error creating tag:', error);\n return c.json({ success: false, error: 'Failed to create tag' }, 500);\n }\n});\n\n// Goals API\napp.get(\"/api/goals\", async c => {\n try {\n const goals = await queries.getAllGoals();\n return c.json({ success: true, data: goals } as ApiResponse);\n } catch (error) {\n console.error('Error fetching goals:', error);\n return c.json({ success: false, error: 'Failed to fetch goals' }, 500);\n }\n});\n\napp.post(\"/api/goals\", async c => {\n try {\n const body = await c.req.json() as CreateGoalRequest;\n const goal = await queries.createGoal(body);\n \n return c.json({ success: true, data: goal, message: 'Goal created successfully' } as ApiResponse);\n } catch (error) {\n console.error('Error creating goal:', error);\n return c.json({ success: false, error: 'Failed to create goal' }, 500);\n }\n});\n\n// Statistics API\napp.get(\"/api/statistics\", async c => {\n try {\n const stats = await queries.getStatistics();\n return c.json({ success: true, data: stats } as ApiResponse);\n } catch (error) {\n console.error('Error fetching statistics:', error);\n return c.json({ success: false, error: 'Failed to fetch statistics' }, 500);\n }\n});\n\n// User Preferences API\napp.get(\"/api/preferences\", async c => {\n try {\n const preferences = await queries.getUserPreferences();\n return c.json({ success: true, data: preferences } as ApiResponse);\n } catch (error) {\n console.error('Error fetching preferences:', error);\n return c.json({ success: false, error: 'Failed to fetch preferences' }, 500);\n }\n});\n\napp.put(\"/api/preferences\", async c => {\n try {\n const updates = await c.req.json() as Partial;\n const preferences = await queries.updateUserPreferences(updates);\n \n return c.json({ success: true, data: preferences, message: 'Preferences updated successfully' } as ApiResponse);\n } catch (error) {\n console.error('Error updating preferences:', error);\n return c.json({ success: false, error: 'Failed to update preferences' }, 500);\n }\n});\n\n// Achievements API\napp.get(\"/api/achievements\", async c => {\n try {\n const achievements = await queries.getAchievements();\n return c.json({ success: true, data: achievements } as ApiResponse);\n } catch (error) {\n console.error('Error fetching achievements:', error);\n return c.json({ success: false, error: 'Failed to fetch achievements' }, 500);\n }\n});\n\n// Export API\napp.post(\"/api/export\", async c => {\n try {\n const options = await c.req.json() as ExportOptions;\n \n // Get data based on options\n const filters: TodoFilters = {\n search: '',\n category_id: null,\n priority: null,\n completed: options.include_completed ? null : false,\n due_date_range: options.date_range,\n tags: [],\n has_attachments: null,\n overdue_only: false\n };\n \n const [todos, categories] = await Promise.all([\n queries.getAllTodos(filters),\n options.include_categories ? queries.getAllCategories() : []\n ]);\n \n let exportData: string;\n let contentType: string;\n let filename: string;\n \n switch (options.format) {\n case 'json':\n exportData = exportToJson({\n todos,\n categories: options.include_categories ? categories : [],\n exported_at: new Date().toISOString(),\n options\n });\n contentType = 'application/json';\n filename = `todos-${new Date().toISOString().split('T')[0]}.json`;\n break;\n \n case 'csv':\n exportData = exportToCsv(todos, categories);\n contentType = 'text/csv';\n filename = `todos-${new Date().toISOString().split('T')[0]}.csv`;\n break;\n \n case 'markdown':\n exportData = exportToMarkdown(todos, categories);\n contentType = 'text/markdown';\n filename = `todos-${new Date().toISOString().split('T')[0]}.md`;\n break;\n \n default:\n return c.json({ success: false, error: 'Invalid export format' }, 400);\n }\n \n return new Response(exportData, {\n headers: {\n 'Content-Type': contentType,\n 'Content-Disposition': `attachment; filename=\"${filename}\"`,\n 'Access-Control-Expose-Headers': 'Content-Disposition'\n }\n });\n } catch (error) {\n console.error('Error exporting data:', error);\n return c.json({ success: false, error: 'Failed to export data' }, 500);\n }\n});\n\n// Time tracking API\napp.post(\"/api/todos/:id/time/start\", async c => {\n try {\n const todoId = parseInt(c.req.param('id'));\n const { description } = await c.req.json() as { description?: string };\n \n const timeLog = await queries.startTimeTracking(todoId, description);\n \n return c.json({ success: true, data: timeLog, message: 'Time tracking started' });\n } catch (error) {\n console.error('Error starting time tracking:', error);\n return c.json({ success: false, error: 'Failed to start time tracking' }, 500);\n }\n});\n\napp.post(\"/api/time-logs/:id/stop\", async c => {\n try {\n const timeLogId = parseInt(c.req.param('id'));\n const timeLog = await queries.stopTimeTracking(timeLogId);\n \n if (!timeLog) {\n return c.json({ success: false, error: 'Time log not found' }, 404);\n }\n \n return c.json({ success: true, data: timeLog, message: 'Time tracking stopped' });\n } catch (error) {\n console.error('Error stopping time tracking:', error);\n return c.json({ success: false, error: 'Failed to stop time tracking' }, 500);\n }\n});\n\napp.get(\"/api/todos/:id/time-logs\", async c => {\n try {\n const todoId = parseInt(c.req.param('id'));\n const timeLogs = await queries.getTimeLogsForTodo(todoId);\n \n return c.json({ success: true, data: timeLogs });\n } catch (error) {\n console.error('Error fetching time logs:', error);\n return c.json({ success: false, error: 'Failed to fetch time logs' }, 500);\n }\n});\n\n// Health check\napp.get(\"/api/health\", c => {\n return c.json({ \n success: true, \n data: { \n status: 'healthy', \n timestamp: new Date().toISOString(),\n database: dbInitialized ? 'connected' : 'initializing'\n } \n });\n});\n\n// 404 handler for API routes\napp.all(\"/api/*\", c => {\n return c.json({ success: false, error: 'API endpoint not found' }, 404);\n});\n\n// Catch-all for SPA routing\napp.get(\"*\", async c => {\n try {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject initial data for SPA routes too\n const [todos, categories, tags, preferences] = await Promise.all([\n queries.getAllTodos(),\n queries.getAllCategories(),\n queries.getAllTags(),\n queries.getUserPreferences()\n ]);\n \n const initialData = {\n todos,\n categories,\n tags,\n preferences,\n timestamp: new Date().toISOString()\n };\n \n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n } catch (error) {\n console.error('Error serving SPA route:', error);\n return c.text('Error loading application', 500);\n }\n});\n\nexport default app;","deleted","label",[166,149],"backend","permalink","https://www.val.town/x/stevekrouse/complex-test-app/code/backend/index.ts","extension","actionData","errors"]