Hi

\"\n});\n```\n\n## Val Town Utility Functions\n\nVal Town provides several utility functions to help with common project tasks.\n\n### Importing Utilities\n\nAlways import utilities with version pins to avoid breaking changes:\n\n```ts\nimport { parseProject, readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n```\n\n### Available Utilities\n\n\n#### **serveFile** - Serve project files with proper content types\n\nFor example, in Hono:\n\n```ts\n// serve all files in frontend/ and shared/\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n```\n\n#### **readFile** - Read files from within the project:\n\n```ts\n// Read a file from the project\nconst fileContent = await readFile(\"/frontend/index.html\", import.meta.url);\n```\n\n#### **listFiles** - List all files in the project\n\n```ts\nconst files = await listFiles(import.meta.url);\n```\n\n#### **parseProject** - Extract information about the current project from import.meta.url\n\nThis is useful for including info for linking back to a val, ie in \"view source\" urls:\n\n```ts\nconst projectVal = parseProject(import.meta.url);\nconsole.log(projectVal.username); // Owner of the project\nconsole.log(projectVal.name); // Project name\nconsole.log(projectVal.version); // Version number\nconsole.log(projectVal.branch); // Branch name\nconsole.log(projectVal.links.self.project); // URL to the project page\n```\n\nHowever, it's *extremely importing* to note that `parseProject` and other Standard Library utilities ONLY RUN ON THE SERVER.\nIf you need access to this data on the client, run it in the server and pass it to the client by splicing it into the HTML page\nor by making an API request for it.\n\n## Val Town Platform Specifics\n\n- **Redirects:** Use `return new Response(null, { status: 302, headers: { Location: \"/place/to/redirect\" }})` instead of `Response.redirect` which is broken\n- **Images:** Avoid external images or base64 images. Use emojis, unicode symbols, or icon fonts/libraries instead\n- **AI Image:** To inline generate an AI image use: `

`\n- **Storage:** DO NOT use the Deno KV module for storage\n- **Browser APIs:** DO NOT use the `alert()`, `prompt()`, or `confirm()` methods\n- **Weather Data:** Use open-meteo for weather data (doesn't require API keys) unless otherwise specified\n- **View Source:** Add a view source link by importing & using `import.meta.url.replace(\"ems.sh\", \"val.town)\"` (or passing this data to the client) and include `target=\"_top\"` attribute\n- **Error Debugging:** Add `` to HTML to capture client-side errors\n- **Error Handling:** Only use try...catch when there's a clear local resolution; Avoid catches that merely log or return 500s. Let errors bubble up with full context\n- **Environment Variables:** Use `Deno.env.get('keyname')` when you need to, but generally prefer APIs that don't require keys\n- **Imports:** Use `https://esm.sh` for npm and Deno dependencies to ensure compatibility on server and browser\n- **Storage Strategy:** Only use backend storage if explicitly required; prefer simple static client-side sites\n- **React Configuration:** When using React libraries, pin versions with `?deps=react@18.2.0,react-dom@18.2.0` and start the file with `/** @jsxImportSource https://esm.sh/react@18.2.0 */`\n- Ensure all React dependencies and sub-dependencies are pinned to the same version\n- **Styling:** Default to using TailwindCSS via `` unless otherwise specified\n\n## Project Structure and Design Patterns\n\n### Recommended Directory Structure\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Schema definitions\n│ │ ├── queries.ts # DB query functions\n│ │ └── README.md\n│ └── routes/ # Route modules\n│ ├── [route].ts\n│ └── static.ts # Static file serving\n│ ├── index.ts # Main entry point\n│ └── README.md\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx\n│ │ └── [Component].tsx\n│ ├── favicon.svg\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # Frontend JS entry point\n│ ├── README.md\n│ └── style.css\n├── README.md\n└── shared/\n ├── README.md\n └── utils.ts # Shared types and functions\n```\n\n### Backend (Hono) Best Practices\n\n- Hono is the recommended API framework\n- Main entry point should be `backend/index.ts`\n- **Static asset serving:** Use the utility functions to read and serve project files:\n ```ts\n import { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n \n // serve all files in frontend/ and shared/\n app.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\n app.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n \n // For index.html, often you'll want to bootstrap with initial data\n app.get(\"/\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject data to avoid extra round-trips\n const initialData = await fetchInitialData();\n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n });\n ```\n- Create RESTful API routes for CRUD operations\n- Always include this snippet at the top-level Hono app to re-throwing errors to see full stack traces:\n ```ts\n // Unwrap Hono errors to see original error details\n app.onError((err, c) => {\n throw err;\n });\n ```\n\n### Database Patterns\n- Run migrations on startup or comment out for performance\n- Change table names when modifying schemas rather than altering\n- Export clear query functions with proper TypeScript typing\n\n## Common Gotchas and Solutions\n\n1. **Environment Limitations:** \n - Val Town runs on Deno in a serverless context, not Node.js\n - Code in `shared/` must work in both frontend and backend environments\n - Cannot use `Deno` keyword in shared code\n - Use `https://esm.sh` for imports that work in both environments\n\n2. **SQLite Peculiarities:**\n - Limited support for ALTER TABLE operations\n - Create new tables with updated schemas and copy data when needed\n - Always run table creation before querying\n\n3. **React Configuration:**\n - All React dependencies must be pinned to 18.2.0\n - Always include `@jsxImportSource https://esm.sh/react@18.2.0` at the top of React files\n - Rendering issues often come from mismatched React versions\n\n4. **File Handling:**\n - Val Town only supports text files, not binary\n - Use the provided utilities to read files across branches and forks\n - For files in the project, use `readFile` helpers\n\n5. **API Design:**\n - `fetch` handler is the entry point for HTTP vals\n - Run the Hono app with `export default app.fetch // This is the entry point for HTTP vals`\n\n",[148],"19097772-ce33-11f0-9668-42dde27851f2",["D",1764537930636],[27],"184204d0-ce33-11f0-aea2-42dde27851f2","shared","184205a2-ce33-11f0-aea2-42dde27851f2",4,["D",1764537929399],"directory",[158],"1818c746-ce33-11f0-aa28-42dde27851f2","frontend","1818c82c-ce33-11f0-aa28-42dde27851f2",2,["D",1764537929135],[165],"182beace-ce33-11f0-9440-42dde27851f2","backend","182bebc8-ce33-11f0-9440-42dde27851f2",3,["D",1764537929262],[171],"pulls","branches",1,"forks","envVars",{"_184":186,"_187":59},"connections",{"_184":59,"_185":59},"count","unfilledCount",6,"emptyCount",{"_40":170,"_31":171,"_29":172,"_133":-5,"_38":39,"_37":173,"_135":55,"_35":372,"_13":59,"_32":162,"_33":-5,"_23":24,"_138":-5,"_214":373,"_26":374},{"_40":368,"_31":359,"_29":353,"_133":172,"_38":39,"_37":186,"_135":55,"_35":369,"_13":59,"_32":162,"_33":-5,"_23":24,"_138":-5,"_214":370,"_26":371},{"_40":360,"_31":361,"_29":362,"_133":353,"_38":39,"_37":363,"_135":24,"_35":364,"_13":59,"_32":231,"_33":365,"_23":24,"_138":-5,"_214":366,"_26":367},{"_40":350,"_31":351,"_29":352,"_133":353,"_38":39,"_37":354,"_135":24,"_35":355,"_13":59,"_32":231,"_33":356,"_23":24,"_138":-5,"_214":357,"_26":358},{"_40":345,"_31":336,"_29":330,"_133":172,"_38":39,"_37":346,"_135":55,"_35":347,"_13":59,"_32":162,"_33":-5,"_23":24,"_138":-5,"_214":348,"_26":349},{"_40":337,"_31":338,"_29":339,"_133":330,"_38":39,"_37":340,"_135":24,"_35":341,"_13":59,"_32":231,"_33":342,"_23":24,"_138":-5,"_214":343,"_26":344},{"_40":327,"_31":328,"_29":329,"_133":330,"_38":39,"_37":331,"_135":24,"_35":332,"_13":59,"_32":231,"_33":333,"_23":24,"_138":-5,"_214":334,"_26":335},{"_40":320,"_31":321,"_29":53,"_133":172,"_38":39,"_37":322,"_135":24,"_35":323,"_13":59,"_32":231,"_33":324,"_23":24,"_138":-5,"_214":325,"_26":326},{"_40":164,"_31":165,"_29":166,"_133":-5,"_38":39,"_37":167,"_135":55,"_35":317,"_13":59,"_32":162,"_33":-5,"_23":24,"_138":-5,"_214":318,"_26":319},{"_40":312,"_31":271,"_29":265,"_133":166,"_38":39,"_37":313,"_135":55,"_35":314,"_13":59,"_32":162,"_33":-5,"_23":24,"_138":-5,"_214":315,"_26":316},{"_40":304,"_31":305,"_29":306,"_133":265,"_38":39,"_37":307,"_135":24,"_35":308,"_13":59,"_32":231,"_33":309,"_23":24,"_138":-5,"_214":310,"_26":311},{"_40":296,"_31":297,"_29":298,"_133":265,"_38":39,"_37":299,"_135":24,"_35":300,"_13":59,"_32":231,"_33":301,"_23":24,"_138":-5,"_214":302,"_26":303},{"_40":288,"_31":289,"_29":290,"_133":265,"_38":39,"_37":291,"_135":24,"_35":292,"_13":59,"_32":231,"_33":293,"_23":24,"_138":-5,"_214":294,"_26":295},{"_40":280,"_31":281,"_29":282,"_133":265,"_38":39,"_37":283,"_135":24,"_35":284,"_13":59,"_32":231,"_33":285,"_23":24,"_138":-5,"_214":286,"_26":287},{"_40":272,"_31":273,"_29":274,"_133":265,"_38":39,"_37":275,"_135":24,"_35":276,"_13":59,"_32":231,"_33":277,"_23":24,"_138":-5,"_214":278,"_26":279},{"_40":262,"_31":263,"_29":264,"_133":265,"_38":39,"_37":266,"_135":24,"_35":267,"_13":59,"_32":231,"_33":268,"_23":24,"_138":-5,"_214":269,"_26":270},{"_40":254,"_31":255,"_29":256,"_133":166,"_38":39,"_37":257,"_135":24,"_35":258,"_13":59,"_32":20,"_33":259,"_23":24,"_138":-5,"_214":260,"_26":261},{"_40":246,"_31":247,"_29":248,"_133":166,"_38":39,"_37":249,"_135":24,"_35":250,"_13":59,"_32":20,"_33":251,"_23":24,"_138":-5,"_214":252,"_26":253},{"_40":238,"_31":239,"_29":240,"_133":166,"_38":39,"_37":241,"_135":24,"_35":242,"_13":59,"_32":231,"_33":243,"_23":24,"_138":-5,"_214":244,"_26":245},{"_40":157,"_31":158,"_29":159,"_133":-5,"_38":39,"_37":160,"_135":55,"_35":235,"_13":59,"_32":162,"_33":-5,"_23":24,"_138":-5,"_214":236,"_26":237},{"_40":226,"_31":227,"_29":228,"_133":159,"_38":39,"_37":229,"_135":24,"_35":230,"_13":59,"_32":231,"_33":232,"_23":24,"_138":-5,"_214":233,"_26":234},{"_40":154,"_31":27,"_29":30,"_133":-5,"_38":39,"_37":14,"_135":55,"_35":223,"_13":59,"_32":20,"_33":34,"_23":24,"_138":-5,"_214":224,"_26":225},{"_40":147,"_31":148,"_29":149,"_133":-5,"_38":39,"_37":150,"_135":55,"_35":220,"_13":59,"_32":20,"_33":152,"_23":24,"_138":-5,"_214":221,"_26":222},{"_40":140,"_31":141,"_29":142,"_133":-5,"_38":39,"_37":143,"_135":24,"_35":217,"_13":59,"_32":20,"_33":145,"_23":24,"_138":-5,"_214":218,"_26":219},{"_40":130,"_31":131,"_29":132,"_133":-5,"_38":39,"_37":134,"_135":55,"_35":213,"_13":59,"_32":20,"_33":137,"_23":24,"_138":-5,"_214":215,"_26":216},["D",1764537930379],"children",[],[131],["D",1764537930611],[],[141],["D",1764537930621],[],[148],["D",1764537930636],[],[27],"18f25de4-ce33-11f0-a53c-42dde27851f2","types.ts","18f25ea2-ce33-11f0-a53c-42dde27851f2",23,["D",1764537930563],"script","// Shared types for Linear Calendar integration\n// NOTE: This file runs in both frontend and backend - do not use Deno APIs here\n\nexport interface LinearTask {\n id: string;\n title: string;\n description: string | null;\n status: {\n id: string;\n name: string;\n color: string;\n type: string;\n };\n project: {\n id: string;\n name: string;\n color: string;\n icon: string | null;\n } | null;\n priority: number;\n priorityLabel: string;\n estimate: number | null;\n url: string;\n createdAt: string;\n updatedAt: string;\n dueDate: string | null;\n}\n\nexport interface CalendarEvent {\n id: string;\n taskId: string | null;\n title: string;\n description: string | null;\n start: string;\n end: string;\n googleEventId: string | null;\n color: string;\n}\n\nexport interface CreateEventRequest {\n taskId: string;\n taskTitle: string;\n taskDescription: string | null;\n start: string;\n durationMinutes: number;\n color: string;\n}\n\nexport interface UpdateEventRequest {\n id: string;\n start?: string;\n end?: string;\n title?: string;\n}\n\nexport interface DeleteEventRequest {\n id: string;\n googleEventId: string | null;\n}\n\nexport interface ApiResponse {\n success: boolean;\n data?: T;\n error?: string;\n}\n\nexport interface LinearCycleInfo {\n id: string;\n name: string;\n startsAt: string;\n endsAt: string;\n}\n\nexport const STATUS_COLORS: Record = {\n 'backlog': '#6B7280',\n 'unstarted': '#6B7280', \n 'started': '#3B82F6',\n 'completed': '#10B981',\n 'canceled': '#EF4444',\n 'triage': '#F59E0B',\n};\n\nexport const PRIORITY_LABELS: Record = {\n 0: 'No priority',\n 1: 'Urgent',\n 2: 'High',\n 3: 'Medium',\n 4: 'Low',\n};\n\nexport const PRIORITY_COLORS: Record = {\n 0: '#6B7280',\n 1: '#EF4444',\n 2: '#F97316',\n 3: '#EAB308',\n 4: '#3B82F6',\n};\n\n",[],[158,227],["D",1764537929399],[208],[158],"18b30694-ce33-11f0-8193-42dde27851f2","index.tsx","18b3073e-ce33-11f0-8193-42dde27851f2",10,["D",1764537930058],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\nconst root = createRoot(document.getElementById(\"root\")!);\nroot.render();\n\n",[],[165,239],"18a78dc8-ce33-11f0-b19b-42dde27851f2","index.html","18a78eae-ce33-11f0-b19b-42dde27851f2",8,["D",1764537930066],"\n\n\n \n \n Linear Calendar\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\n\n

\n \n\n\n\n",[],[165,247],"18ce5a8e-ce33-11f0-aea2-42dde27851f2","favicon.svg","18ce5b24-ce33-11f0-aea2-42dde27851f2",15,["D",1764537930327],"\n\n",[],[165,255],"18c8fb70-ce33-11f0-aea2-42dde27851f2","TaskList.tsx","18c8fc1a-ce33-11f0-aea2-42dde27851f2","1856e33c-ce33-11f0-8193-42dde27851f2",14,["D",1764537930214],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useMemo } from \"https://esm.sh/react@18.2.0\";\nimport type { LinearTask, LinearCycleInfo } from \"../../shared/types.ts\";\nimport { TaskItem } from \"./TaskItem.tsx\";\n\ninterface TaskListProps {\n tasks: LinearTask[];\n cycle: LinearCycleInfo | null;\n onSelectTask: (task: LinearTask) => void;\n selectedTaskId?: string;\n}\n\nexport function TaskList({ tasks, cycle, onSelectTask, selectedTaskId }: TaskListProps) {\n const groupedTasks = useMemo(() => {\n const groups: Record = {};\n \n tasks.forEach(task => {\n const statusType = task.status.type;\n if (!groups[statusType]) {\n groups[statusType] = [];\n }\n groups[statusType].push(task);\n });\n \n Object.values(groups).forEach(group => {\n group.sort((a, b) => a.priority - b.priority);\n });\n \n return groups;\n }, [tasks]);\n\n const statusOrder = ['unstarted', 'started', 'completed', 'canceled', 'backlog', 'triage'];\n const orderedGroups = statusOrder\n .filter(status => groupedTasks[status]?.length > 0)\n .map(status => ({ type: status, tasks: groupedTasks[status] }));\n\n const formatCycleDate = (dateStr: string) => {\n const date = new Date(dateStr);\n return date.toLocaleDateString('en-US', { month: 'short', day: 'numeric' });\n };\n\n return (\n

\n \n

Current Cycle

\n {cycle && (\n

\n {formatCycleDate(cycle.startsAt)} — {formatCycleDate(cycle.endsAt)}\n

\n )}\n

\n \n

\n \n {tasks.length} task{tasks.length !== 1 ? 's' : ''}\n \n

\n \n

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

\n \n

No tasks in this cycle

\n ) : (\n orderedGroups.map(group => (\n

\n \n \n {group.type === 'unstarted' ? 'Todo' : group.type}\n \n \n {group.tasks.length}\n \n

\n \n

\n {group.tasks.map((task, index) => (\n onSelectTask(task)}\n isSelected={task.id === selectedTaskId}\n animationDelay={index * 30}\n />\n ))}\n

\n ))\n )}\n

\n \n

\n \n Drag tasks to calendar to schedule\n

\n );\n}\n\nfunction StatusIcon({ type }: { type: string }) {\n switch (type) {\n case 'unstarted':\n return

;\n case 'started':\n return (\n

\n );\n case 'completed':\n return (\n

\n \n

\n );\n case 'canceled':\n return (\n

\n \n

\n );\n case 'backlog':\n return

;\n default:\n return

;\n }\n}\n\n",[],[165,271,263],"components","18c1b18a-ce33-11f0-a854-42dde27851f2","TaskItem.tsx","18c1b22a-ce33-11f0-a854-42dde27851f2",13,["D",1764537930243],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useRef } from \"https://esm.sh/react@18.2.0\";\nimport type { LinearTask } from \"../../shared/types.ts\";\nimport { PRIORITY_COLORS } from \"../../shared/types.ts\";\n\ninterface TaskItemProps {\n task: LinearTask;\n onClick: () => void;\n isSelected: boolean;\n animationDelay: number;\n}\n\nexport function TaskItem({ task, onClick, isSelected, animationDelay }: TaskItemProps) {\n const dragRef = useRef(null);\n\n const handleDragStart = (e: React.DragEvent) => {\n const dragData = {\n taskId: task.id,\n taskTitle: task.title,\n taskDescription: task.description,\n color: task.project?.color || task.status.color || '#7c3aed',\n };\n e.dataTransfer.setData('application/json', JSON.stringify(dragData));\n e.dataTransfer.effectAllowed = 'copy';\n \n if (dragRef.current) {\n dragRef.current.classList.add('task-dragging');\n }\n };\n\n const handleDragEnd = () => {\n if (dragRef.current) {\n dragRef.current.classList.remove('task-dragging');\n }\n };\n\n const priorityColor = PRIORITY_COLORS[task.priority] || PRIORITY_COLORS[0];\n\n return (\n \n

\n \n

\n {task.title}\n

\n \n

\n {task.project && (\n \n {task.project.icon && {task.project.icon}}\n {task.project.name}\n \n )}\n \n {task.estimate && (\n \n \n {task.estimate}\n \n )}\n \n {task.dueDate && (\n \n \n {formatDueDate(task.dueDate)}\n \n )}\n

\n \n

\n );\n}\n\nfunction isOverdue(dateStr: string): boolean {\n const dueDate = new Date(dateStr);\n const today = new Date();\n today.setHours(0, 0, 0, 0);\n dueDate.setHours(0, 0, 0, 0);\n return dueDate < today;\n}\n\nfunction formatDueDate(dateStr: string): string {\n const dueDate = new Date(dateStr);\n const today = new Date();\n today.setHours(0, 0, 0, 0);\n dueDate.setHours(0, 0, 0, 0);\n \n const diffDays = Math.ceil((dueDate.getTime() - today.getTime()) / (1000 * 60 * 60 * 24));\n \n if (diffDays === 0) return 'Today';\n if (diffDays === 1) return 'Tomorrow';\n if (diffDays === -1) return 'Yesterday';\n if (diffDays < -1) return `${Math.abs(diffDays)}d ago`;\n if (diffDays < 7) return `In ${diffDays}d`;\n \n return dueDate.toLocaleDateString('en-US', { month: 'short', day: 'numeric' });\n}\n\n",[],[165,271,273],"18bee144-ce33-11f0-a32a-42dde27851f2","TaskDetail.tsx","18bee1e4-ce33-11f0-a32a-42dde27851f2",12,["D",1764537930225],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useEffect, useRef } from \"https://esm.sh/react@18.2.0\";\nimport type { LinearTask } from \"../../shared/types.ts\";\nimport { PRIORITY_COLORS } from \"../../shared/types.ts\";\n\ninterface TaskDetailProps {\n task: LinearTask;\n onClose: () => void;\n}\n\nexport function TaskDetail({ task, onClose }: TaskDetailProps) {\n const modalRef = useRef(null);\n\n useEffect(() => {\n const handleKeyDown = (e: KeyboardEvent) => {\n if (e.key === 'Escape') {\n onClose();\n }\n };\n \n document.addEventListener('keydown', handleKeyDown);\n return () => document.removeEventListener('keydown', handleKeyDown);\n }, [onClose]);\n\n const handleBackdropClick = (e: React.MouseEvent) => {\n if (e.target === e.currentTarget) {\n onClose();\n }\n };\n\n const priorityColor = PRIORITY_COLORS[task.priority] || PRIORITY_COLORS[0];\n\n return (\n

e.stopPropagation()}\n >\n

\n {task.title}\n

\n \n

\n \n \n {task.status.name}\n \n \n \n \n {task.priorityLabel}\n \n \n {task.project && (\n \n {task.project.icon && {task.project.icon}}\n {task.project.name}\n \n )}\n

\n \n \n \n \n

\n \n

\n Description\n

\n {task.description ? (\n

\n {renderDescription(task.description)}\n

\n ) : (\n

No description provided

\n )}\n

\n \n

\n {task.estimate && (\n

\n Estimate\n

\n {task.estimate} point{task.estimate !== 1 ? 's' : ''}\n

\n )}\n \n {task.dueDate && (\n

\n Due Date\n

\n {formatDate(task.dueDate)}\n

\n )}\n \n

\n Created\n

\n {formatDate(task.createdAt)}\n

\n \n

\n Last Updated\n

\n {formatDate(task.updatedAt)}\n

\n \n

\n \n \n Open in Linear\n \n \n \n Close\n \n

\n );\n}\n\nfunction StatusDot({ type }: { type: string }) {\n switch (type) {\n case 'completed':\n return

;\n case 'started':\n return

;\n case 'canceled':\n return

;\n default:\n return

;\n }\n}\n\nfunction PriorityIcon({ priority }: { priority: number }) {\n if (priority === 1) {\n return (\n \n );\n }\n \n const bars = priority === 0 ? 1 : 5 - priority;\n return (\n \n );\n}\n\nfunction isOverdue(dateStr: string): boolean {\n const dueDate = new Date(dateStr);\n const today = new Date();\n today.setHours(0, 0, 0, 0);\n dueDate.setHours(0, 0, 0, 0);\n return dueDate < today;\n}\n\nfunction formatDate(dateStr: string): string {\n return new Date(dateStr).toLocaleDateString('en-US', {\n weekday: 'short',\n month: 'short',\n day: 'numeric',\n year: 'numeric',\n });\n}\n\nfunction renderDescription(text: string): React.ReactNode {\n const lines = text.split('\\n');\n \n return lines.map((line, i) => {\n if (line.startsWith('### ')) {\n return

{line.slice(4)}

;\n }\n if (line.startsWith('## ')) {\n return

{line.slice(3)}

;\n }\n if (line.startsWith('# ')) {\n return

{line.slice(2)}

;\n }\n \n if (line.startsWith('- ') || line.startsWith('* ')) {\n return (\n

\n •\n {line.slice(2)}\n

\n );\n }\n \n if (line.startsWith('- [ ] ')) {\n return (\n

\n ☐\n {line.slice(6)}\n

\n );\n }\n if (line.startsWith('- [x] ') || line.startsWith('- [X] ')) {\n return (\n

\n ☑\n {line.slice(6)}\n

\n );\n }\n \n if (line.trim() === '') {\n return

;\n }\n \n return

{line}

;\n });\n}\n\n",[],[165,271,281],"18d20aa8-ce33-11f0-b19b-42dde27851f2","CalendarEvent.tsx","18d20b5c-ce33-11f0-b19b-42dde27851f2",16,["D",1764537930339],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useRef } from \"https://esm.sh/react@18.2.0\";\nimport type { CalendarEvent } from \"../../shared/types.ts\";\n\ninterface CalendarEventProps {\n event: CalendarEvent;\n style: { top: number; height: number };\n onUpdate: (eventId: string, updates: { start?: string; end?: string }) => Promise;\n onDelete: (eventId: string) => Promise;\n hourHeight: number;\n startHour: number;\n}\n\nexport function CalendarEventComponent({ \n event, \n style, \n onUpdate, \n onDelete,\n hourHeight,\n startHour,\n}: CalendarEventProps) {\n const [isResizing, setIsResizing] = useState(false);\n const [isDragging, setIsDragging] = useState(false);\n const [tempHeight, setTempHeight] = useState(null);\n const [tempTop, setTempTop] = useState(null);\n const [showMenu, setShowMenu] = useState(false);\n const eventRef = useRef(null);\n const startYRef = useRef(0);\n const startHeightRef = useRef(0);\n const startTopRef = useRef(0);\n\n const formatTime = (dateStr: string) => {\n const date = new Date(dateStr);\n return date.toLocaleTimeString('en-US', { \n hour: 'numeric', \n minute: '2-digit',\n hour12: true \n });\n };\n\n const getDuration = () => {\n const start = new Date(event.start);\n const end = new Date(event.end);\n return Math.round((end.getTime() - start.getTime()) / 60000);\n };\n\n const handleResizeStart = (e: React.MouseEvent) => {\n e.preventDefault();\n e.stopPropagation();\n \n setIsResizing(true);\n startYRef.current = e.clientY;\n startHeightRef.current = style.height;\n\n const handleResizeMove = (moveEvent: MouseEvent) => {\n const deltaY = moveEvent.clientY - startYRef.current;\n const newHeight = Math.max(20, startHeightRef.current + deltaY);\n const snappedHeight = Math.round(newHeight / (hourHeight / 4)) * (hourHeight / 4);\n setTempHeight(snappedHeight);\n };\n\n const handleResizeEnd = async () => {\n document.removeEventListener('mousemove', handleResizeMove);\n document.removeEventListener('mouseup', handleResizeEnd);\n \n if (tempHeight !== null && tempHeight !== style.height) {\n const start = new Date(event.start);\n const hoursFromTop = (style.top + tempHeight) / hourHeight;\n const endHour = Math.floor(hoursFromTop + startHour);\n const endMinutes = Math.round((hoursFromTop + startHour - endHour) * 60);\n \n const newEnd = new Date(start);\n newEnd.setHours(endHour, endMinutes, 0, 0);\n \n try {\n await onUpdate(event.id, { end: newEnd.toISOString() });\n } catch (error) {\n console.error('Failed to update event:', error);\n }\n }\n \n setIsResizing(false);\n setTempHeight(null);\n };\n\n document.addEventListener('mousemove', handleResizeMove);\n document.addEventListener('mouseup', handleResizeEnd);\n };\n\n const handleDragStart = (e: React.MouseEvent) => {\n if (isResizing) return;\n e.preventDefault();\n \n setIsDragging(true);\n startYRef.current = e.clientY;\n startTopRef.current = style.top;\n\n const handleDragMove = (moveEvent: MouseEvent) => {\n const deltaY = moveEvent.clientY - startYRef.current;\n const newTop = Math.max(0, startTopRef.current + deltaY);\n const snappedTop = Math.round(newTop / (hourHeight / 4)) * (hourHeight / 4);\n setTempTop(snappedTop);\n };\n\n const handleDragEnd = async () => {\n document.removeEventListener('mousemove', handleDragMove);\n document.removeEventListener('mouseup', handleDragEnd);\n \n if (tempTop !== null && tempTop !== style.top) {\n const deltaHours = (tempTop - style.top) / hourHeight;\n \n const start = new Date(event.start);\n const end = new Date(event.end);\n \n start.setTime(start.getTime() + deltaHours * 60 * 60 * 1000);\n end.setTime(end.getTime() + deltaHours * 60 * 60 * 1000);\n \n try {\n await onUpdate(event.id, { \n start: start.toISOString(), \n end: end.toISOString() \n });\n } catch (error) {\n console.error('Failed to update event:', error);\n }\n }\n \n setIsDragging(false);\n setTempTop(null);\n };\n\n document.addEventListener('mousemove', handleDragMove);\n document.addEventListener('mouseup', handleDragEnd);\n };\n\n const handleDelete = async () => {\n try {\n await onDelete(event.id);\n } catch (error) {\n console.error('Failed to delete event:', error);\n }\n setShowMenu(false);\n };\n\n const displayHeight = tempHeight ?? style.height;\n const displayTop = tempTop ?? style.top;\n const duration = getDuration();\n const isCompact = displayHeight < 40;\n\n return (\n <>\n {\n e.preventDefault();\n setShowMenu(true);\n }}\n >\n

\n {event.title}\n

\n {!isCompact && (\n

\n {formatTime(event.start)} - {formatTime(event.end)}\n ({duration}m)\n

\n )}\n

\n \n

\n \n {event.googleEventId && (\n

\n \n

\n )}\n

\n \n {showMenu && (\n <>\n

setShowMenu(false)}\n />\n

\n \n \n Delete\n \n

\n \n )}\n \n );\n}\n\n",[],[165,271,289],"18bb4138-ce33-11f0-bbbf-42dde27851f2","Calendar.tsx","18bb41e2-ce33-11f0-bbbf-42dde27851f2",11,["D",1764537930202],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useRef, useCallback, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport type { CalendarEvent, CreateEventRequest } from \"../../shared/types.ts\";\nimport { CalendarEventComponent } from \"./CalendarEvent.tsx\";\n\ninterface CalendarProps {\n selectedDate: Date;\n onDateChange: (date: Date) => void;\n events: CalendarEvent[];\n onCreateEvent: (request: CreateEventRequest) => Promise;\n onUpdateEvent: (eventId: string, updates: { start?: string; end?: string }) => Promise;\n onDeleteEvent: (eventId: string) => Promise;\n}\n\nconst HOUR_HEIGHT = 60;\nconst START_HOUR = 6;\nconst END_HOUR = 22;\nconst HOURS = Array.from({ length: END_HOUR - START_HOUR }, (_, i) => i + START_HOUR);\nconst DAYS_OF_WEEK = ['Sun', 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat'];\n\nexport function Calendar({ \n selectedDate, \n onDateChange, \n events, \n onCreateEvent, \n onUpdateEvent,\n onDeleteEvent,\n}: CalendarProps) {\n const [currentTime, setCurrentTime] = useState(new Date());\n const [isDraggingOver, setIsDraggingOver] = useState(null);\n const calendarRef = useRef(null);\n\n useEffect(() => {\n const interval = setInterval(() => {\n setCurrentTime(new Date());\n }, 60000);\n return () => clearInterval(interval);\n }, []);\n\n const getWeekDates = useCallback(() => {\n const startOfWeek = new Date(selectedDate);\n startOfWeek.setDate(startOfWeek.getDate() - startOfWeek.getDay());\n startOfWeek.setHours(0, 0, 0, 0);\n \n return Array.from({ length: 7 }, (_, i) => {\n const date = new Date(startOfWeek);\n date.setDate(date.getDate() + i);\n return date;\n });\n }, [selectedDate]);\n\n const weekDates = getWeekDates();\n\n const goToPrevWeek = () => {\n const newDate = new Date(selectedDate);\n newDate.setDate(newDate.getDate() - 7);\n onDateChange(newDate);\n };\n\n const goToNextWeek = () => {\n const newDate = new Date(selectedDate);\n newDate.setDate(newDate.getDate() + 7);\n onDateChange(newDate);\n };\n\n const goToToday = () => {\n onDateChange(new Date());\n };\n\n const isToday = (date: Date) => {\n const today = new Date();\n return date.toDateString() === today.toDateString();\n };\n\n const getEventsForDate = (date: Date) => {\n return events.filter(event => {\n const eventDate = new Date(event.start);\n return eventDate.toDateString() === date.toDateString();\n });\n };\n\n const getEventStyle = (event: CalendarEvent) => {\n const start = new Date(event.start);\n const end = new Date(event.end);\n \n const startHour = start.getHours() + start.getMinutes() / 60;\n const endHour = end.getHours() + end.getMinutes() / 60;\n \n const top = (startHour - START_HOUR) * HOUR_HEIGHT;\n const height = (endHour - startHour) * HOUR_HEIGHT;\n \n return { top, height: Math.max(height, 20) };\n };\n\n const handleDragOver = (e: React.DragEvent, dateStr: string) => {\n e.preventDefault();\n e.dataTransfer.dropEffect = 'copy';\n setIsDraggingOver(dateStr);\n };\n\n const handleDragLeave = () => {\n setIsDraggingOver(null);\n };\n\n const handleDrop = async (e: React.DragEvent, date: Date) => {\n e.preventDefault();\n setIsDraggingOver(null);\n\n try {\n const data = JSON.parse(e.dataTransfer.getData('application/json'));\n \n const rect = e.currentTarget.getBoundingClientRect();\n const y = e.clientY - rect.top;\n const hour = Math.floor(y / HOUR_HEIGHT) + START_HOUR;\n const minutes = Math.round((y % HOUR_HEIGHT) / HOUR_HEIGHT * 60 / 15) * 15;\n \n const startTime = new Date(date);\n startTime.setHours(hour, minutes, 0, 0);\n \n const request: CreateEventRequest = {\n taskId: data.taskId,\n taskTitle: data.taskTitle,\n taskDescription: data.taskDescription,\n start: startTime.toISOString(),\n durationMinutes: 30,\n color: data.color,\n };\n \n await onCreateEvent(request);\n } catch (error) {\n console.error('Failed to create event:', error);\n }\n };\n\n const getCurrentTimePosition = () => {\n const now = new Date();\n const hour = now.getHours() + now.getMinutes() / 60;\n if (hour < START_HOUR || hour > END_HOUR) return null;\n return (hour - START_HOUR) * HOUR_HEIGHT;\n };\n\n const timePosition = getCurrentTimePosition();\n\n const formatWeekRange = () => {\n const start = weekDates[0];\n const end = weekDates[6];\n \n if (start.getMonth() === end.getMonth()) {\n return `${start.toLocaleDateString('en-US', { month: 'long' })} ${start.getDate()} - ${end.getDate()}, ${start.getFullYear()}`;\n }\n \n return `${start.toLocaleDateString('en-US', { month: 'short', day: 'numeric' })} - ${end.toLocaleDateString('en-US', { month: 'short', day: 'numeric', year: 'numeric' })}`;\n };\n\n return (\n

\n {formatWeekRange()}\n

\n \n

\n \n \n \n \n \n \n

\n \n \n Today\n \n

\n \n

\n \n {weekDates.map((date, i) => (\n

\n {DAYS_OF_WEEK[date.getDay()]}\n

\n {date.getDate()}\n

\n ))}\n

\n \n

\n {HOURS.map(hour => (\n

\n \n {hour === 0 ? '12 AM' : hour === 12 ? '12 PM' : hour > 12 ? `${hour - 12} PM` : `${hour} AM`}\n \n

\n ))}\n

\n \n {weekDates.map((date, dayIndex) => {\n const dateStr = date.toISOString().split('T')[0];\n const dayEvents = getEventsForDate(date);\n \n return (\n handleDragOver(e, dateStr)}\n onDragLeave={handleDragLeave}\n onDrop={(e) => handleDrop(e, date)}\n >\n {HOURS.map(hour => (\n \n ))}\n \n {isToday(date) && timePosition !== null && (\n

\n )}\n \n {dayEvents.map(event => {\n const style = getEventStyle(event);\n return (\n \n );\n })}\n

\n );\n })}\n

\n );\n}\n\n",[],[165,271,297],"18aab016-ce33-11f0-bbbf-42dde27851f2","App.tsx","18aab0ac-ce33-11f0-bbbf-42dde27851f2",9,["D",1764537930081],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect, useCallback } from \"https://esm.sh/react@18.2.0\";\nimport type { LinearTask, CalendarEvent, LinearCycleInfo, CreateEventRequest } from \"../../shared/types.ts\";\nimport { TaskList } from \"./TaskList.tsx\";\nimport { TaskDetail } from \"./TaskDetail.tsx\";\nimport { Calendar } from \"./Calendar.tsx\";\n\nexport function App() {\n const [tasks, setTasks] = useState([]);\n const [cycle, setCycle] = useState(null);\n const [events, setEvents] = useState([]);\n const [selectedTask, setSelectedTask] = useState(null);\n const [loading, setLoading] = useState(true);\n const [error, setError] = useState(null);\n const [selectedDate, setSelectedDate] = useState(() => {\n const today = new Date();\n today.setHours(0, 0, 0, 0);\n return today;\n });\n\n // Fetch tasks from Linear\n const fetchTasks = useCallback(async () => {\n try {\n const response = await fetch('/api/linear/tasks');\n const data = await response.json();\n \n if (data.success) {\n setTasks(data.data.tasks);\n setCycle(data.data.cycle);\n } else {\n setError(data.error || 'Failed to fetch tasks');\n }\n } catch (err) {\n setError(err instanceof Error ? err.message : 'Failed to fetch tasks');\n }\n }, []);\n\n // Fetch calendar events\n const fetchEvents = useCallback(async () => {\n try {\n const startOfWeek = new Date(selectedDate);\n startOfWeek.setDate(startOfWeek.getDate() - startOfWeek.getDay());\n startOfWeek.setHours(0, 0, 0, 0);\n \n const endOfWeek = new Date(startOfWeek);\n endOfWeek.setDate(endOfWeek.getDate() + 7);\n \n const response = await fetch(\n `/api/calendar/events?start=${startOfWeek.toISOString()}&end=${endOfWeek.toISOString()}`\n );\n const data = await response.json();\n \n if (data.success) {\n setEvents(data.data);\n }\n } catch (err) {\n console.error('Failed to fetch events:', err);\n }\n }, [selectedDate]);\n\n useEffect(() => {\n Promise.all([fetchTasks(), fetchEvents()]).finally(() => {\n setLoading(false);\n });\n }, [fetchTasks, fetchEvents]);\n\n const handleCreateEvent = async (request: CreateEventRequest) => {\n try {\n const response = await fetch('/api/calendar/events', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify(request),\n });\n \n const data = await response.json();\n \n if (data.success) {\n setEvents(prev => [...prev, data.data]);\n return data.data;\n } else {\n throw new Error(data.error);\n }\n } catch (err) {\n console.error('Failed to create event:', err);\n throw err;\n }\n };\n\n const handleUpdateEvent = async (eventId: string, updates: { start?: string; end?: string }) => {\n try {\n const response = await fetch(`/api/calendar/events/${eventId}`, {\n method: 'PATCH',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify(updates),\n });\n \n const data = await response.json();\n \n if (data.success) {\n setEvents(prev => prev.map(e => e.id === eventId ? data.data : e));\n return data.data;\n } else {\n throw new Error(data.error);\n }\n } catch (err) {\n console.error('Failed to update event:', err);\n throw err;\n }\n };\n\n const handleDeleteEvent = async (eventId: string) => {\n try {\n const response = await fetch(`/api/calendar/events/${eventId}`, {\n method: 'DELETE',\n });\n \n const data = await response.json();\n \n if (data.success) {\n setEvents(prev => prev.filter(e => e.id !== eventId));\n } else {\n throw new Error(data.error);\n }\n } catch (err) {\n console.error('Failed to delete event:', err);\n throw err;\n }\n };\n\n if (loading) {\n return (\n

\n Loading your tasks...\n

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

\n \n

Something went wrong

{error}

\n window.location.reload()}\n className=\"px-4 py-2 bg-purple-600 hover:bg-purple-700 text-white text-sm font-medium rounded-lg transition-colors\"\n >\n Try Again\n \n

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

\n \n

\n \n {selectedTask && (\n setSelectedTask(null)}\n />\n )}\n

\n );\n}\n\n",[],[165,271,305],"1856e26a-ce33-11f0-8193-42dde27851f2",5,["D",1764537929542],[198,199,200,201,202,203],[165,271],["D",1764537929135],[197,204,205,206],[165],"18edb00a-ce33-11f0-b19b-42dde27851f2","index.ts",22,["D",1764537930458],"import { Hono } from \"https://esm.sh/hono@4.4.2\";\nimport { serveFile, readFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport { linearRoutes } from \"./routes/linear.ts\";\nimport { calendarRoutes } from \"./routes/calendar.ts\";\n\nconst app = new Hono();\n\n// Run migrations on startup\nawait runMigrations();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// API routes\napp.route('/api/linear', linearRoutes);\napp.route('/api/calendar', calendarRoutes);\n\n// Serve static files from frontend and shared\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 index.html for root route\napp.get(\"/\", async c => {\n const html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n});\n\n// Serve favicon\napp.get(\"/favicon.svg\", c => serveFile(\"/frontend/favicon.svg\", import.meta.url));\n\n// This is the entry point for HTTP vals\nexport default app.fetch;\n\n",[],[171,321],"18e9cae4-ce33-11f0-9668-42dde27851f2","linear.ts","18e9cb8e-ce33-11f0-9668-42dde27851f2","188ab342-ce33-11f0-bbbf-42dde27851f2",21,["D",1764537930507],"import { Hono } from \"https://esm.sh/hono@4.4.2\";\nimport type { LinearTask, LinearCycleInfo, ApiResponse } from \"../../shared/types.ts\";\n\nconst linearRoutes = new Hono();\n\n// Get Linear API key from environment\nfunction getLinearApiKey(): string {\n const key = Deno.env.get('LINEAR_API_KEY');\n if (!key) {\n throw new Error('LINEAR_API_KEY environment variable is not set');\n }\n return key;\n}\n\n// GraphQL query for fetching current cycle tasks\nconst CURRENT_CYCLE_TASKS_QUERY = `\n query CurrentCycleTasks {\n viewer {\n activeCycle {\n id\n name\n startsAt\n endsAt\n issues {\n nodes {\n id\n title\n description\n priority\n priorityLabel\n estimate\n url\n createdAt\n updatedAt\n dueDate\n state {\n id\n name\n color\n type\n }\n project {\n id\n name\n color\n icon\n }\n }\n }\n }\n }\n }\n`;\n\n// GraphQL query for fetching a single issue with full details\nconst ISSUE_DETAILS_QUERY = `\n query IssueDetails($id: String!) {\n issue(id: $id) {\n id\n title\n description\n priority\n priorityLabel\n estimate\n url\n createdAt\n updatedAt\n dueDate\n state {\n id\n name\n color\n type\n }\n project {\n id\n name\n color\n icon\n }\n }\n }\n`;\n\n// Helper to make Linear API calls\nasync function linearGraphQL(query: string, variables?: Record): Promise {\n const apiKey = getLinearApiKey();\n\n const response = await fetch('https://api.linear.app/graphql', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n 'Authorization': apiKey,\n },\n body: JSON.stringify({ query, variables }),\n });\n\n if (!response.ok) {\n const errorText = await response.text();\n throw new Error(`Linear API error: ${response.status} - ${errorText}`);\n }\n\n const json = await response.json();\n\n if (json.errors) {\n throw new Error(`Linear GraphQL error: ${JSON.stringify(json.errors)}`);\n }\n\n return json.data;\n}\n\n// Transform Linear issue to our task type\nfunction transformIssue(issue: Record): LinearTask {\n return {\n id: issue.id as string,\n title: issue.title as string,\n description: issue.description as string | null,\n status: issue.state as LinearTask['status'],\n project: issue.project as LinearTask['project'],\n priority: issue.priority as number,\n priorityLabel: issue.priorityLabel as string,\n estimate: issue.estimate as number | null,\n url: issue.url as string,\n createdAt: issue.createdAt as string,\n updatedAt: issue.updatedAt as string,\n dueDate: issue.dueDate as string | null,\n };\n}\n\n// Get tasks for current active cycle\nlinearRoutes.get('/tasks', async (c) => {\n try {\n const data = await linearGraphQL<{\n viewer: {\n activeCycle: {\n id: string;\n name: string;\n startsAt: string;\n endsAt: string;\n issues: {\n nodes: Record[];\n };\n } | null;\n };\n }>(CURRENT_CYCLE_TASKS_QUERY);\n\n if (!data.viewer.activeCycle) {\n return c.json>({\n success: true,\n data: { tasks: [], cycle: null },\n });\n }\n\n const cycle = data.viewer.activeCycle;\n const tasks = cycle.issues.nodes.map(transformIssue);\n\n const cycleInfo: LinearCycleInfo = {\n id: cycle.id,\n name: cycle.name,\n startsAt: cycle.startsAt,\n endsAt: cycle.endsAt,\n };\n\n return c.json>({\n success: true,\n data: { tasks, cycle: cycleInfo },\n });\n } catch (error) {\n console.error('Error fetching Linear tasks:', error);\n return c.json>({\n success: false,\n error: error instanceof Error ? error.message : 'Unknown error',\n }, 500);\n }\n});\n\n// Get single task details\nlinearRoutes.get('/tasks/:id', async (c) => {\n try {\n const taskId = c.req.param('id');\n\n const data = await linearGraphQL<{\n issue: Record | null;\n }>(ISSUE_DETAILS_QUERY, { id: taskId });\n\n if (!data.issue) {\n return c.json>({\n success: false,\n error: 'Task not found',\n }, 404);\n }\n\n const task = transformIssue(data.issue);\n\n return c.json>({\n success: true,\n data: task,\n });\n } catch (error) {\n console.error('Error fetching Linear task:', error);\n return c.json>({\n success: false,\n error: error instanceof Error ? error.message : 'Unknown error',\n }, 500);\n }\n});\n\nexport { linearRoutes };\n\n",[],[171,336,328],"routes","18e69e6e-ce33-11f0-8193-42dde27851f2","calendar.ts","18e69f2c-ce33-11f0-8193-42dde27851f2",20,["D",1764537930486],"import { Hono } from \"https://esm.sh/hono@4.4.2\";\nimport type { CalendarEvent, CreateEventRequest, UpdateEventRequest, ApiResponse } from \"../../shared/types.ts\";\nimport * as db from \"../database/queries.ts\";\n\nconst calendarRoutes = new Hono();\n\n// Get Google OAuth credentials from environment\nfunction getGoogleCredentials() {\n const clientId = Deno.env.get('GOOGLE_CLIENT_ID');\n const clientSecret = Deno.env.get('GOOGLE_CLIENT_SECRET');\n const refreshToken = Deno.env.get('GOOGLE_REFRESH_TOKEN');\n\n if (!clientId || !clientSecret || !refreshToken) {\n throw new Error('Google Calendar credentials not configured');\n }\n\n return { clientId, clientSecret, refreshToken };\n}\n\n// Get a fresh access token using refresh token\nasync function getAccessToken(): Promise {\n const { clientId, clientSecret, refreshToken } = getGoogleCredentials();\n\n const response = await fetch('https://oauth2.googleapis.com/token', {\n method: 'POST',\n headers: { 'Content-Type': 'application/x-www-form-urlencoded' },\n body: new URLSearchParams({\n client_id: clientId,\n client_secret: clientSecret,\n refresh_token: refreshToken,\n grant_type: 'refresh_token',\n }),\n });\n\n if (!response.ok) {\n const error = await response.text();\n throw new Error(`Failed to refresh Google token: ${error}`);\n }\n\n const data = await response.json();\n return data.access_token;\n}\n\n// Create Google Calendar event\nasync function createGoogleEvent(\n title: string,\n description: string | null,\n start: string,\n end: string,\n color: string\n): Promise {\n const accessToken = await getAccessToken();\n\n // Map hex color to Google Calendar colorId (1-11)\n const colorId = getGoogleColorId(color);\n\n const event = {\n summary: title,\n description: description || undefined,\n start: {\n dateTime: start,\n timeZone: 'America/Los_Angeles',\n },\n end: {\n dateTime: end,\n timeZone: 'America/Los_Angeles',\n },\n colorId,\n };\n\n const response = await fetch(\n 'https://www.googleapis.com/calendar/v3/calendars/primary/events',\n {\n method: 'POST',\n headers: {\n 'Authorization': `Bearer ${accessToken}`,\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify(event),\n }\n );\n\n if (!response.ok) {\n const error = await response.text();\n throw new Error(`Failed to create Google Calendar event: ${error}`);\n }\n\n const data = await response.json();\n return data.id;\n}\n\n// Update Google Calendar event\nasync function updateGoogleEvent(\n googleEventId: string,\n updates: { start?: string; end?: string; title?: string }\n): Promise {\n const accessToken = await getAccessToken();\n\n const patch: Record = {};\n\n if (updates.title) {\n patch.summary = updates.title;\n }\n if (updates.start) {\n patch.start = {\n dateTime: updates.start,\n timeZone: 'America/Los_Angeles',\n };\n }\n if (updates.end) {\n patch.end = {\n dateTime: updates.end,\n timeZone: 'America/Los_Angeles',\n };\n }\n\n const response = await fetch(\n `https://www.googleapis.com/calendar/v3/calendars/primary/events/${googleEventId}`,\n {\n method: 'PATCH',\n headers: {\n 'Authorization': `Bearer ${accessToken}`,\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify(patch),\n }\n );\n\n if (!response.ok) {\n const error = await response.text();\n throw new Error(`Failed to update Google Calendar event: ${error}`);\n }\n}\n\n// Delete Google Calendar event\nasync function deleteGoogleEvent(googleEventId: string): Promise {\n const accessToken = await getAccessToken();\n\n const response = await fetch(\n `https://www.googleapis.com/calendar/v3/calendars/primary/events/${googleEventId}`,\n {\n method: 'DELETE',\n headers: {\n 'Authorization': `Bearer ${accessToken}`,\n },\n }\n );\n\n // 404 is okay - event might already be deleted\n if (!response.ok && response.status !== 404) {\n const error = await response.text();\n throw new Error(`Failed to delete Google Calendar event: ${error}`);\n }\n}\n\n// Map hex color to Google Calendar colorId\nfunction getGoogleColorId(hexColor: string): string {\n const hex = hexColor.toLowerCase();\n\n if (hex.includes('ef') || hex.includes('f44') || hex.includes('d50')) return '11'; // Red\n if (hex.includes('f97') || hex.includes('f45')) return '6'; // Orange\n if (hex.includes('eab') || hex.includes('f6b')) return '5'; // Yellow\n if (hex.includes('10b') || hex.includes('0b8') || hex.includes('33b')) return '2'; // Green\n if (hex.includes('3b8') || hex.includes('039')) return '7'; // Blue\n if (hex.includes('8e2') || hex.includes('7c3')) return '3'; // Purple\n if (hex.includes('6b7') || hex.includes('616')) return '8'; // Gray\n\n return '9'; // Default to blueberry\n}\n\n// GET /events - Get all events (optionally filtered by date range)\ncalendarRoutes.get('/events', async (c) => {\n try {\n const start = c.req.query('start');\n const end = c.req.query('end');\n\n let events: CalendarEvent[];\n\n if (start && end) {\n events = await db.getEventsInRange(start, end);\n } else {\n events = await db.getAllEvents();\n }\n\n return c.json>({\n success: true,\n data: events,\n });\n } catch (error) {\n console.error('Error fetching events:', error);\n return c.json>({\n success: false,\n error: error instanceof Error ? error.message : 'Unknown error',\n }, 500);\n }\n});\n\n// POST /events - Create a new event\ncalendarRoutes.post('/events', async (c) => {\n try {\n const body = await c.req.json();\n\n // Calculate end time\n const startDate = new Date(body.start);\n const endDate = new Date(startDate.getTime() + body.durationMinutes * 60 * 1000);\n\n // Create in Google Calendar first\n let googleEventId: string | null = null;\n try {\n googleEventId = await createGoogleEvent(\n body.taskTitle,\n body.taskDescription,\n body.start,\n endDate.toISOString(),\n body.color\n );\n } catch (error) {\n console.error('Failed to create Google Calendar event:', error);\n // Continue without Google sync - we'll try again later\n }\n\n // Create in local database\n const event = await db.createEvent(\n body.taskId,\n body.taskTitle,\n body.taskDescription,\n body.start,\n endDate.toISOString(),\n googleEventId,\n body.color\n );\n\n return c.json>({\n success: true,\n data: event,\n });\n } catch (error) {\n console.error('Error creating event:', error);\n return c.json>({\n success: false,\n error: error instanceof Error ? error.message : 'Unknown error',\n }, 500);\n }\n});\n\n// PATCH /events/:id - Update an event\ncalendarRoutes.patch('/events/:id', async (c) => {\n try {\n const eventId = c.req.param('id');\n const body = await c.req.json();\n\n // Get current event to check for Google sync\n const currentEvent = await db.getEventById(eventId);\n if (!currentEvent) {\n return c.json>({\n success: false,\n error: 'Event not found',\n }, 404);\n }\n\n // Update in Google Calendar if synced\n if (currentEvent.googleEventId) {\n try {\n await updateGoogleEvent(currentEvent.googleEventId, {\n start: body.start,\n end: body.end,\n title: body.title,\n });\n } catch (error) {\n console.error('Failed to update Google Calendar event:', error);\n // Continue with local update\n }\n }\n\n // Update in local database\n const updatedEvent = await db.updateEvent(eventId, {\n start: body.start,\n end: body.end,\n title: body.title,\n });\n\n return c.json>({\n success: true,\n data: updatedEvent,\n });\n } catch (error) {\n console.error('Error updating event:', error);\n return c.json>({\n success: false,\n error: error instanceof Error ? error.message : 'Unknown error',\n }, 500);\n }\n});\n\n// DELETE /events/:id - Delete an event\ncalendarRoutes.delete('/events/:id', async (c) => {\n try {\n const eventId = c.req.param('id');\n\n // Get current event to check for Google sync\n const currentEvent = await db.getEventById(eventId);\n if (!currentEvent) {\n return c.json>({\n success: false,\n error: 'Event not found',\n }, 404);\n }\n\n // Delete from Google Calendar if synced\n if (currentEvent.googleEventId) {\n try {\n await deleteGoogleEvent(currentEvent.googleEventId);\n } catch (error) {\n console.error('Failed to delete Google Calendar event:', error);\n // Continue with local delete\n }\n }\n\n // Delete from local database\n await db.deleteEvent(eventId);\n\n return c.json>({\n success: true,\n data: { deleted: true },\n });\n } catch (error) {\n console.error('Error deleting event:', error);\n return c.json>({\n success: false,\n error: error instanceof Error ? error.message : 'Unknown error',\n }, 500);\n }\n});\n\nexport { calendarRoutes };\n\n",[],[171,336,338],"188ab28e-ce33-11f0-bbbf-42dde27851f2",7,["D",1764537929883],[193,194],[171,336],"18d57a3a-ce33-11f0-a53c-42dde27851f2","queries.ts","18d57ae4-ce33-11f0-a53c-42dde27851f2","186a95bc-ce33-11f0-b6b7-42dde27851f2",17,["D",1764537930372],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { EVENTS_TABLE } from \"./migrations.ts\";\nimport type { CalendarEvent } from \"../../shared/types.ts\";\n\n// Generate a unique ID\nfunction generateId(): string {\n return `evt_${Date.now()}_${Math.random().toString(36).substring(2, 9)}`;\n}\n\n// Get all events for a date range\nexport async function getEventsInRange(startDate: string, endDate: string): Promise {\n const result = await sqlite.execute(`\n SELECT id, task_id, title, description, start_time, end_time, google_event_id, color\n FROM ${EVENTS_TABLE}\n WHERE start_time >= ? AND start_time <= ?\n ORDER BY start_time ASC\n `, [startDate, endDate]);\n\n return result.rows.map(row => ({\n id: row.id as string,\n taskId: row.task_id as string | null,\n title: row.title as string,\n description: row.description as string | null,\n start: row.start_time as string,\n end: row.end_time as string,\n googleEventId: row.google_event_id as string | null,\n color: row.color as string,\n }));\n}\n\n// Get all events\nexport async function getAllEvents(): Promise {\n const result = await sqlite.execute(`\n SELECT id, task_id, title, description, start_time, end_time, google_event_id, color\n FROM ${EVENTS_TABLE}\n ORDER BY start_time ASC\n `);\n\n return result.rows.map(row => ({\n id: row.id as string,\n taskId: row.task_id as string | null,\n title: row.title as string,\n description: row.description as string | null,\n start: row.start_time as string,\n end: row.end_time as string,\n googleEventId: row.google_event_id as string | null,\n color: row.color as string,\n }));\n}\n\n// Create a new event\nexport async function createEvent(\n taskId: string | null,\n title: string,\n description: string | null,\n start: string,\n end: string,\n googleEventId: string | null,\n color: string\n): Promise {\n const id = generateId();\n\n await sqlite.execute(`\n INSERT INTO ${EVENTS_TABLE} (id, task_id, title, description, start_time, end_time, google_event_id, color)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)\n `, [id, taskId, title, description, start, end, googleEventId, color]);\n\n return {\n id,\n taskId,\n title,\n description,\n start,\n end,\n googleEventId,\n color,\n };\n}\n\n// Update an event\nexport async function updateEvent(\n id: string,\n updates: { start?: string; end?: string; title?: string; googleEventId?: string }\n): Promise {\n const setClauses: string[] = ['updated_at = CURRENT_TIMESTAMP'];\n const values: (string | null)[] = [];\n\n if (updates.start !== undefined) {\n setClauses.push('start_time = ?');\n values.push(updates.start);\n }\n if (updates.end !== undefined) {\n setClauses.push('end_time = ?');\n values.push(updates.end);\n }\n if (updates.title !== undefined) {\n setClauses.push('title = ?');\n values.push(updates.title);\n }\n if (updates.googleEventId !== undefined) {\n setClauses.push('google_event_id = ?');\n values.push(updates.googleEventId);\n }\n\n values.push(id);\n\n await sqlite.execute(`\n UPDATE ${EVENTS_TABLE}\n SET ${setClauses.join(', ')}\n WHERE id = ?\n `, values);\n\n // Fetch updated event\n const result = await sqlite.execute(`\n SELECT id, task_id, title, description, start_time, end_time, google_event_id, color\n FROM ${EVENTS_TABLE}\n WHERE id = ?\n `, [id]);\n\n if (result.rows.length === 0) return null;\n\n const row = result.rows[0];\n return {\n id: row.id as string,\n taskId: row.task_id as string | null,\n title: row.title as string,\n description: row.description as string | null,\n start: row.start_time as string,\n end: row.end_time as string,\n googleEventId: row.google_event_id as string | null,\n color: row.color as string,\n };\n}\n\n// Delete an event\nexport async function deleteEvent(id: string): Promise {\n const result = await sqlite.execute(`\n DELETE FROM ${EVENTS_TABLE}\n WHERE id = ?\n `, [id]);\n\n return result.rowsAffected > 0;\n}\n\n// Get event by ID\nexport async function getEventById(id: string): Promise {\n const result = await sqlite.execute(`\n SELECT id, task_id, title, description, start_time, end_time, google_event_id, color\n FROM ${EVENTS_TABLE}\n WHERE id = ?\n `, [id]);\n\n if (result.rows.length === 0) return null;\n\n const row = result.rows[0];\n return {\n id: row.id as string,\n taskId: row.task_id as string | null,\n title: row.title as string,\n description: row.description as string | null,\n start: row.start_time as string,\n end: row.end_time as string,\n googleEventId: row.google_event_id as string | null,\n color: row.color as string,\n };\n}\n\n",[],[171,359,351],"database","18e2c15e-ce33-11f0-a32a-42dde27851f2","migrations.ts","18e2c230-ce33-11f0-a32a-42dde27851f2",19,["D",1764537930454],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst EVENTS_TABLE = 'linear_calendar_events_v1';\n\nexport async function runMigrations() {\n // Create calendar events table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${EVENTS_TABLE} (\n id TEXT PRIMARY KEY,\n task_id TEXT,\n title TEXT NOT NULL,\n description TEXT,\n start_time TEXT NOT NULL,\n end_time TEXT NOT NULL,\n google_event_id TEXT,\n color TEXT NOT NULL DEFAULT '#3B82F6',\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Create index on task_id for faster lookups\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${EVENTS_TABLE}_task_id \n ON ${EVENTS_TABLE}(task_id)\n `);\n\n // Create index on start_time for date range queries\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${EVENTS_TABLE}_start_time \n ON ${EVENTS_TABLE}(start_time)\n `);\n\n console.log('Migrations complete');\n}\n\nexport { EVENTS_TABLE };\n\n",[],[171,359,361],"186a94fe-ce33-11f0-b6b7-42dde27851f2",["D",1764537929672],[190,191],[171,359],["D",1764537929262],[189,192,195],[171],["D",1764532987103],{"_93":92,"_100":96},{"_93":92,"_94":-5,"_95":96,"_18":51,"_97":98,"_99":24},{"_13":82,"_31":83,"_40":39,"_84":41,"_85":-5,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":42,"_91":92},"ctx",{"_75":-5,"_120":412,"_413":414,"_415":416,"_417":24,"_418":24,"_419":24,"_420":55,"_421":-5,"_422":-7,"_423":-7,"_424":59,"_425":24,"_426":24,"_427":-5,"_428":24,"_429":24,"_430":24,"_431":-5},"ENV",{"_383":384,"_385":386,"_387":83,"_388":389,"_390":391,"_392":393,"_394":395,"_396":397,"_398":399,"_400":401,"_402":403,"_404":405,"_406":407,"_408":409,"_410":411},"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"]

Diff · v27