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",[139],"19097772-ce33-11f0-9668-42dde27851f2",".vtignore","19097844-ce33-11f0-9668-42dde27851f2",27,["D",1764537930636],".git\n.vscode\n.cursorrules\n.DS_Store\nnode_modules\nvendor",[146],"184204d0-ce33-11f0-aea2-42dde27851f2","shared","184205a2-ce33-11f0-aea2-42dde27851f2",4,["D",1764537929399],"directory",[153],"1818c746-ce33-11f0-aa28-42dde27851f2","frontend","1818c82c-ce33-11f0-aa28-42dde27851f2",["D",1764537929135],[160],"182beace-ce33-11f0-9440-42dde27851f2","backend","182bebc8-ce33-11f0-9440-42dde27851f2",3,["D",1764537929262],[165],"pulls","branches",1,"forks","envVars",{"_178":180,"_181":41},"connections",{"_178":41,"_179":41},"count","unfilledCount",6,"emptyCount",{"_18":164,"_20":165,"_116":166,"_118":-5,"_119":67,"_120":167,"_122":37,"_22":419,"_64":41,"_124":157,"_125":-5,"_127":26,"_128":-5,"_214":420,"_84":421},{"_18":415,"_20":406,"_116":400,"_118":166,"_119":67,"_120":180,"_122":37,"_22":416,"_64":41,"_124":157,"_125":-5,"_127":26,"_128":-5,"_214":417,"_84":418},{"_18":407,"_20":408,"_116":409,"_118":400,"_119":67,"_120":410,"_122":37,"_22":411,"_64":167,"_124":231,"_125":412,"_127":26,"_128":-5,"_214":413,"_84":414},{"_18":397,"_20":398,"_116":399,"_118":400,"_119":67,"_120":401,"_122":37,"_22":402,"_64":135,"_124":231,"_125":403,"_127":26,"_128":-5,"_214":404,"_84":405},{"_18":392,"_20":391,"_116":385,"_118":166,"_119":67,"_120":393,"_122":37,"_22":394,"_64":41,"_124":157,"_125":-5,"_127":26,"_128":-5,"_214":395,"_84":396},{"_18":382,"_20":383,"_116":384,"_118":385,"_119":67,"_120":386,"_122":37,"_22":387,"_64":172,"_124":231,"_125":388,"_127":26,"_128":-5,"_214":389,"_84":390},{"_18":377,"_20":360,"_116":355,"_118":166,"_119":67,"_120":378,"_122":37,"_22":379,"_64":41,"_124":157,"_125":-5,"_127":26,"_128":-5,"_214":380,"_84":381},{"_18":369,"_20":370,"_116":371,"_118":355,"_119":67,"_120":372,"_122":37,"_22":373,"_64":172,"_124":231,"_125":374,"_127":26,"_128":-5,"_214":375,"_84":376},{"_18":361,"_20":362,"_116":363,"_118":355,"_119":67,"_120":364,"_122":37,"_22":365,"_64":135,"_124":231,"_125":366,"_127":26,"_128":-5,"_214":367,"_84":368},{"_18":352,"_20":353,"_116":354,"_118":355,"_119":67,"_120":65,"_122":37,"_22":356,"_64":180,"_124":231,"_125":357,"_127":26,"_128":-5,"_214":358,"_84":359},{"_18":344,"_20":345,"_116":35,"_118":166,"_119":67,"_120":346,"_122":37,"_22":347,"_64":167,"_124":348,"_125":349,"_127":26,"_128":-5,"_214":350,"_84":351},{"_18":159,"_20":160,"_116":161,"_118":-5,"_119":67,"_120":135,"_122":37,"_22":341,"_64":41,"_124":157,"_125":-5,"_127":26,"_128":-5,"_214":342,"_84":343},{"_18":336,"_20":279,"_116":273,"_118":161,"_119":67,"_120":337,"_122":37,"_22":338,"_64":41,"_124":157,"_125":-5,"_127":26,"_128":-5,"_214":339,"_84":340},{"_18":328,"_20":329,"_116":330,"_118":273,"_119":67,"_120":331,"_122":37,"_22":332,"_64":135,"_124":231,"_125":333,"_127":26,"_128":-5,"_214":334,"_84":335},{"_18":320,"_20":321,"_116":322,"_118":273,"_119":67,"_120":323,"_122":37,"_22":324,"_64":135,"_124":231,"_125":325,"_127":26,"_128":-5,"_214":326,"_84":327},{"_18":312,"_20":313,"_116":314,"_118":273,"_119":67,"_120":315,"_122":37,"_22":316,"_64":135,"_124":231,"_125":317,"_127":26,"_128":-5,"_214":318,"_84":319},{"_18":304,"_20":305,"_116":306,"_118":273,"_119":67,"_120":307,"_122":37,"_22":308,"_64":41,"_124":231,"_125":309,"_127":26,"_128":-5,"_214":310,"_84":311},{"_18":296,"_20":297,"_116":298,"_118":273,"_119":67,"_120":299,"_122":37,"_22":300,"_64":41,"_124":231,"_125":301,"_127":26,"_128":-5,"_214":302,"_84":303},{"_18":288,"_20":289,"_116":290,"_118":273,"_119":67,"_120":291,"_122":37,"_22":292,"_64":172,"_124":231,"_125":293,"_127":26,"_128":-5,"_214":294,"_84":295},{"_18":280,"_20":281,"_116":282,"_118":273,"_119":67,"_120":283,"_122":37,"_22":284,"_64":155,"_124":231,"_125":285,"_127":26,"_128":-5,"_214":286,"_84":287},{"_18":270,"_20":271,"_116":272,"_118":273,"_119":67,"_120":274,"_122":37,"_22":275,"_64":180,"_124":231,"_125":276,"_127":26,"_128":-5,"_214":277,"_84":278},{"_18":262,"_20":263,"_116":264,"_118":161,"_119":67,"_120":265,"_122":37,"_22":266,"_64":172,"_124":231,"_125":267,"_127":26,"_128":-5,"_214":268,"_84":269},{"_18":254,"_20":255,"_116":256,"_118":161,"_119":67,"_120":257,"_122":37,"_22":258,"_64":172,"_124":95,"_125":259,"_127":26,"_128":-5,"_214":260,"_84":261},{"_18":246,"_20":247,"_116":248,"_118":161,"_119":67,"_120":249,"_122":37,"_22":250,"_64":135,"_124":95,"_125":251,"_127":26,"_128":-5,"_214":252,"_84":253},{"_18":238,"_20":239,"_116":240,"_118":161,"_119":67,"_120":241,"_122":37,"_22":242,"_64":172,"_124":231,"_125":243,"_127":26,"_128":-5,"_214":244,"_84":245},{"_18":152,"_20":153,"_116":154,"_118":-5,"_119":67,"_120":155,"_122":37,"_22":235,"_64":41,"_124":157,"_125":-5,"_127":26,"_128":-5,"_214":236,"_84":237},{"_18":226,"_20":227,"_116":228,"_118":154,"_119":67,"_120":229,"_122":37,"_22":230,"_64":155,"_124":231,"_125":232,"_127":26,"_128":-5,"_214":233,"_84":234},{"_18":145,"_20":146,"_116":147,"_118":-5,"_119":67,"_120":148,"_122":37,"_22":223,"_64":41,"_124":95,"_125":150,"_127":26,"_128":-5,"_214":224,"_84":225},{"_18":138,"_20":139,"_116":140,"_118":-5,"_119":67,"_120":141,"_122":37,"_22":220,"_64":41,"_124":95,"_125":143,"_127":26,"_128":-5,"_214":221,"_84":222},{"_18":130,"_20":131,"_116":132,"_118":-5,"_119":67,"_120":133,"_122":37,"_22":217,"_64":135,"_124":95,"_125":136,"_127":26,"_128":-5,"_214":218,"_84":219},{"_18":114,"_20":115,"_116":117,"_118":-5,"_119":67,"_120":121,"_122":37,"_22":213,"_64":41,"_124":95,"_125":126,"_127":26,"_128":-5,"_214":215,"_84":216},["D",1764537930379],"children",[],[115],["D",1765138439696],[],[131],["D",1764537930621],[],[139],["D",1764537930636],[],[146],"4448c458-d3a9-11f0-8de1-42dde27851f2","types.ts","18f25ea2-ce33-11f0-a53c-42dde27851f2",77,["D",1765138439529],"script","// Shared types for General Asks integration\n// NOTE: This file runs in both frontend and backend - do not use Deno APIs here\n\nexport interface User {\n id: string;\n email: string;\n name: string | null;\n googleConnected: boolean;\n}\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 sortOrder: number;\n estimate: number | null;\n url: string;\n createdAt: string;\n updatedAt: string;\n dueDate: string | null;\n parentId: string | null;\n children: LinearTask[];\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 isGoogleEvent?: boolean; // True for events fetched directly from Google Calendar (not created via this app)\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",[],[153,227],["D",1764537929399],[208],[153],"e8fc46cc-ce41-11f0-96ae-42dde27851f2","index.tsx","18b3073e-ce33-11f0-8193-42dde27851f2",39,["D",1764544292469],"/** @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\n",[],[160,239],"4439ebfe-d3a9-11f0-91ca-42dde27851f2","index.html","18a78eae-ce33-11f0-b19b-42dde27851f2",76,["D",1765138439522],"\n\n\n \n \n General Asks\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\n\n

\n \n\n\n\n\n",[],[160,247],"e91f76a6-ce41-11f0-a7d1-42dde27851f2","favicon.svg","18ce5b24-ce33-11f0-aea2-42dde27851f2",44,["D",1764544292776],"\n\n\n",[],[160,255],"e90888a6-ce41-11f0-ad50-42dde27851f2","dragState.ts","f3023ff0-ce3c-11f0-81d0-42dde27851f2",41,["D",1764544292471],"// Simple shared state for drag data between TaskItem and Calendar\n// This is needed because browsers don't allow reading dataTransfer during dragover\n\nexport interface DragData {\n taskId: string;\n taskTitle: string;\n taskDescription: string | null;\n color: string;\n}\n\nlet currentDragData: DragData | null = null;\n\nexport function setDragData(data: DragData | null) {\n currentDragData = data;\n}\n\nexport function getDragData(): DragData | null {\n return currentDragData;\n}\n\n\n",[],[160,263],"442e9894-d3a9-11f0-8621-42dde27851f2","TaskList.tsx","18c8fc1a-ce33-11f0-aea2-42dde27851f2","1856e33c-ce33-11f0-8193-42dde27851f2",74,["D",1765138439520],"/** @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 // Build parent-child tree using parentId (Linear's primitive)\n const { groupedTasks, topLevelTaskCount, childrenByParentId } = useMemo(() => {\n const groups: Record = {};\n const taskIdsInCycle = new Set(tasks.map(t => t.id));\n \n // Build children map using parentId relationships\n const childrenMap = new Map();\n tasks.forEach(task => {\n if (task.parentId) {\n const siblings = childrenMap.get(task.parentId) || [];\n siblings.push(task);\n childrenMap.set(task.parentId, siblings);\n }\n });\n \n // Sort children by sortOrder (Linear's manual ordering)\n childrenMap.forEach(children => {\n children.sort((a, b) => a.sortOrder - b.sortOrder);\n });\n \n // Top-level tasks: no parent, or parent not in cycle\n const topLevelTasks = tasks.filter(task => \n !task.parentId || !taskIdsInCycle.has(task.parentId)\n );\n \n topLevelTasks.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.sortOrder - b.sortOrder);\n });\n \n return { \n groupedTasks: groups, \n topLevelTaskCount: topLevelTasks.length,\n childrenByParentId: childrenMap\n };\n }, [tasks]);\n\n const statusOrder = ['started', 'unstarted', '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 {topLevelTaskCount} task{topLevelTaskCount !== 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 === 'started' ? 'In Progress' : 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 selectedTaskId={selectedTaskId}\n animationDelay={index * 30}\n onSubtaskClick={(subtask) => onSelectTask(subtask)}\n childrenByParentId={childrenByParentId}\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\n",[],[160,279,271],"components","4433ab68-d3a9-11f0-bace-42dde27851f2","TaskItem.tsx","18c1b22a-ce33-11f0-a854-42dde27851f2",75,["D",1765138439544],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useRef, useState } from \"https://esm.sh/react@18.2.0\";\nimport type { LinearTask } from \"../../shared/types.ts\";\nimport { PRIORITY_COLORS } from \"../../shared/types.ts\";\nimport { setDragData } from \"../dragState.ts\";\n\ninterface TaskItemProps {\n task: LinearTask;\n onClick: () => void;\n isSelected: boolean;\n selectedTaskId?: string;\n animationDelay: number;\n depth?: number;\n onSubtaskClick?: (subtask: LinearTask) => void;\n childrenByParentId: Map;\n}\n\n// Recursive function to count all descendants and their completion status\nfunction countDescendants(\n taskId: string, \n childrenByParentId: Map\n): { completed: number; total: number } {\n const children = childrenByParentId.get(taskId) || [];\n let completed = 0;\n let total = children.length;\n \n children.forEach(child => {\n if (child.status.type === 'completed' || child.status.type === 'canceled') {\n completed++;\n }\n // Recursively count grandchildren\n const grandchildCounts = countDescendants(child.id, childrenByParentId);\n completed += grandchildCounts.completed;\n total += grandchildCounts.total;\n });\n \n return { completed, total };\n}\n\nexport function TaskItem({ \n task, \n onClick, \n isSelected, \n selectedTaskId,\n animationDelay, \n depth = 0,\n onSubtaskClick,\n childrenByParentId\n}: TaskItemProps) {\n const dragRef = useRef(null);\n const [isExpanded, setIsExpanded] = useState(true);\n\n const handleDragStart = (e: React.DragEvent) => {\n e.stopPropagation();\n const dragData = {\n taskId: task.id,\n taskTitle: task.title,\n taskDescription: task.description,\n color: '#7c3aed', // Purple for all Linear tasks\n };\n e.dataTransfer.setData('application/json', JSON.stringify(dragData));\n e.dataTransfer.effectAllowed = 'copy';\n \n setDragData(dragData);\n \n if (dragRef.current) {\n dragRef.current.classList.add('task-dragging');\n }\n };\n\n const handleDragEnd = () => {\n setDragData(null);\n \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 // Get children from the parentId-based map\n const children = childrenByParentId.get(task.id) || [];\n const hasChildren = children.length > 0;\n \n // Count all descendants (including nested) for the badge\n const { completed: completedCount, total: totalCount } = hasChildren \n ? countDescendants(task.id, childrenByParentId)\n : { completed: 0, total: 0 };\n\n const handleExpandToggle = (e: React.MouseEvent) => {\n e.stopPropagation();\n setIsExpanded(!isExpanded);\n };\n\n const isSubtask = depth > 0;\n const isCompleted = task.status.type === 'completed';\n const isCanceled = task.status.type === 'canceled';\n\n return (\n

\n \n

\n {/* Status indicator */}\n

\n {isCompleted ? (\n

\n \n

\n ) : isCanceled ? (\n

\n \n

\n ) : task.status.type === 'started' ? (\n

\n ) : (\n

\n )}\n

\n \n

\n {task.title}\n

\n \n {/* Subtask count badge like Linear */}\n {hasChildren && (\n \n \n {completedCount}/{totalCount}\n \n )}\n

\n \n {/* Only show metadata on parent tasks or first-level subtasks */}\n {depth < 2 && (\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 \n {/* Render children recursively */}\n {hasChildren && isExpanded && (\n

\n {children.map((child, index) => (\n onSubtaskClick ? onSubtaskClick(child) : onClick()}\n isSelected={child.id === selectedTaskId}\n selectedTaskId={selectedTaskId}\n animationDelay={animationDelay + (index + 1) * 30}\n depth={depth + 1}\n onSubtaskClick={onSubtaskClick}\n childrenByParentId={childrenByParentId}\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",[],[160,279,281],"e924b51c-ce41-11f0-b178-42dde27851f2","TaskDetail.tsx","18bee1e4-ce33-11f0-a32a-42dde27851f2",45,["D",1764544292787],"/** @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\n",[],[160,279,289],"2b9ea5c6-cf08-11f0-8ffa-42dde27851f2","Login.tsx","2b9ea6a2-cf08-11f0-8ffa-42dde27851f2",60,["D",1764629444693],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\n\nexport function Login() {\n const handleLinearLogin = () => {\n window.location.href = '/api/auth/linear';\n };\n\n return (\n

\n {/* Logo/Brand */}\n

\n \n

General Asks

\n Plan your Linear sprint with your Google Calendar\n

\n\n {/* Login Card */}\n

Sign in to continue

\n Connect your Linear account to get started\n

\n \n \n {/* Linear Logo - simplified square icon */}\n \n Sign in with Linear\n \n

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

\n Your Linear tasks, synced to your calendar\n

\n );\n}\n",[],[160,279,297],"e9b4aa28-ce41-11f0-b531-42dde27851f2","EventDetailModal.tsx","e9b4ab40-ce41-11f0-b531-42dde27851f2",50,["D",1764544292469],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useEffect, useRef } from \"https://esm.sh/react@18.2.0\";\nimport type { CalendarEvent } from \"../../shared/types.ts\";\n\ninterface EventDetailModalProps {\n event: CalendarEvent;\n onClose: () => void;\n onDelete: (eventId: string) => Promise;\n}\n\nexport function EventDetailModal({ event, onClose, onDelete }: EventDetailModalProps) {\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 handleDelete = async () => {\n await onDelete(event.id);\n onClose();\n };\n\n const formatTime = (dateStr: string) => {\n return new Date(dateStr).toLocaleTimeString('en-US', { \n hour: 'numeric', \n minute: '2-digit',\n hour12: true \n });\n };\n\n const formatDate = (dateStr: string) => {\n return new Date(dateStr).toLocaleDateString('en-US', {\n weekday: 'long',\n month: 'long',\n day: 'numeric',\n year: 'numeric',\n });\n };\n\n const getDuration = () => {\n const start = new Date(event.start);\n const end = new Date(event.end);\n const minutes = Math.round((end.getTime() - start.getTime()) / 60000);\n \n if (minutes < 60) {\n return `${minutes} min`;\n }\n const hours = Math.floor(minutes / 60);\n const remainingMinutes = minutes % 60;\n if (remainingMinutes === 0) {\n return `${hours} hr`;\n }\n return `${hours} hr ${remainingMinutes} min`;\n };\n\n // Determine if this is a Linear task or a native Google Calendar event\n const isLinearTask = event.taskId !== null;\n const isGoogleOnly = event.isGoogleEvent === true;\n\n return (\n

e.stopPropagation()}\n >\n {/* Header */}\n

\n {isLinearTask ? (\n \n \n Linear Task\n \n ) : (\n \n \n Calendar Event\n \n )}\n

\n \n

\n {event.title}\n

\n \n \n \n \n

\n \n {/* Content */}\n

\n {/* Time Information */}\n

\n \n

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

\n {formatDate(event.start)} • {getDuration()}\n

\n \n {/* Description */}\n

\n Description\n

\n {event.description ? (\n

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

\n ) : (\n

No description

\n )}\n

\n \n {/* Sync Status */}\n {event.googleEventId && !isGoogleOnly && (\n

\n \n Synced to Google Calendar\n

\n )}\n \n {isGoogleOnly && (\n

\n \n From Google Calendar (read-only)\n

\n )}\n

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

\n {/* Delete button - only show for Linear tasks (not Google-only events) */}\n {isLinearTask && !isGoogleOnly && (\n \n \n Remove from Calendar\n \n )}\n

\n \n \n Close\n \n

\n );\n}\n\nfunction renderDescription(text: string): React.ReactNode {\n const lines = text.split('\\n');\n \n return lines.map((line, i) => {\n // Headers\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 // Bullet lists\n if (line.startsWith('- ') || line.startsWith('* ')) {\n return (\n

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

\n );\n }\n \n // Checkboxes\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 // Empty lines\n if (line.trim() === '') {\n return

;\n }\n \n // Regular text\n return

{line}

;\n });\n}\n\n",[],[160,279,305],"e91ab4b8-ce41-11f0-ad50-42dde27851f2","CalendarEvent.tsx","18d20b5c-ce33-11f0-b19b-42dde27851f2",43,["D",1764544292746],"/** @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 onClick: (event: CalendarEvent) => void;\n hourHeight: number;\n startHour: number;\n}\n\nexport function CalendarEventComponent({ \n event, \n style, \n onUpdate, \n onDelete,\n onClick,\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 // Use refs to track current values during drag/resize operations (fixes closure issue)\n const tempHeightRef = useRef(null);\n const tempTopRef = useRef(null);\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 // Google-only events are read-only (not in our database)\n const isReadOnly = event.isGoogleEvent === true;\n\n const handleResizeStart = (e: React.MouseEvent) => {\n if (isReadOnly) return; // Don't allow resizing Google-only events\n e.preventDefault();\n e.stopPropagation();\n \n setIsResizing(true);\n startYRef.current = e.clientY;\n startHeightRef.current = style.height;\n tempHeightRef.current = null;\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 tempHeightRef.current = snappedHeight;\n setTempHeight(snappedHeight);\n };\n\n const handleResizeEnd = async () => {\n document.removeEventListener('mousemove', handleResizeMove);\n document.removeEventListener('mouseup', handleResizeEnd);\n \n const finalHeight = tempHeightRef.current;\n if (finalHeight !== null && finalHeight !== style.height) {\n const start = new Date(event.start);\n const hoursFromTop = (style.top + finalHeight) / 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 tempHeightRef.current = 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 // For read-only events, just handle click\n if (isReadOnly) {\n onClick(event);\n return;\n }\n \n const startX = e.clientX;\n const startY = e.clientY;\n startYRef.current = e.clientY;\n startTopRef.current = style.top;\n tempTopRef.current = null;\n \n let hasMoved = false;\n const DRAG_THRESHOLD = 5; // pixels before we consider it a drag\n\n const handleDragMove = (moveEvent: MouseEvent) => {\n const deltaX = Math.abs(moveEvent.clientX - startX);\n const deltaY = Math.abs(moveEvent.clientY - startY);\n \n // Only start dragging if we've moved past the threshold\n if (!hasMoved && (deltaX > DRAG_THRESHOLD || deltaY > DRAG_THRESHOLD)) {\n hasMoved = true;\n setIsDragging(true);\n }\n \n if (hasMoved) {\n const newTop = Math.max(0, startTopRef.current + (moveEvent.clientY - startYRef.current));\n const snappedTop = Math.round(newTop / (hourHeight / 4)) * (hourHeight / 4);\n tempTopRef.current = snappedTop;\n setTempTop(snappedTop);\n }\n };\n\n const handleDragEnd = async () => {\n document.removeEventListener('mousemove', handleDragMove);\n document.removeEventListener('mouseup', handleDragEnd);\n \n // If we didn't move, treat as a click\n if (!hasMoved) {\n onClick(event);\n return;\n }\n \n const finalTop = tempTopRef.current;\n if (finalTop !== null && finalTop !== style.top) {\n const deltaHours = (finalTop - 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 tempTopRef.current = 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 if (!isReadOnly) setShowMenu(true); // Only show menu for editable events\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 {/* Only show resize handle for editable events */}\n {!isReadOnly && (\n

\n )}\n \n {/* Google icon for synced events */}\n {event.googleEventId && !isReadOnly && (\n

\n \n

\n )}\n \n {/* Google Calendar indicator for read-only events */}\n {isReadOnly && (\n

\n \n

\n )}\n

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

setShowMenu(false)}\n />\n

\n \n \n Delete\n \n

\n \n )}\n \n );\n}\n\n",[],[160,279,313],"e9142300-ce41-11f0-9c41-42dde27851f2","Calendar.tsx","18bb41e2-ce33-11f0-bbbf-42dde27851f2",42,["D",1764544292701],"/** @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\";\nimport { getDragData } from \"../dragState.ts\";\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 onSelectEvent: (event: CalendarEvent) => void;\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\n// Drop preview info\ninterface DropPreview {\n dateStr: string;\n dayIndex: number;\n top: number;\n timeLabel: string;\n color: string;\n title: string;\n}\n\nexport function Calendar({ \n selectedDate, \n onDateChange, \n events, \n onCreateEvent, \n onUpdateEvent,\n onDeleteEvent,\n onSelectEvent,\n}: CalendarProps) {\n const [currentTime, setCurrentTime] = useState(new Date());\n const [isDraggingOver, setIsDraggingOver] = useState(null);\n const [dropPreview, setDropPreview] = 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, dayIndex: number) => {\n e.preventDefault();\n e.dataTransfer.dropEffect = 'copy';\n setIsDraggingOver(dateStr);\n\n // Calculate snapped position for preview\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 const snappedTop = ((hour - START_HOUR) + minutes / 60) * HOUR_HEIGHT;\n\n // Format time label\n const displayHour = hour > 12 ? hour - 12 : hour === 0 ? 12 : hour;\n const ampm = hour >= 12 ? 'PM' : 'AM';\n const timeLabel = `${displayHour}:${minutes.toString().padStart(2, '0')} ${ampm}`;\n\n // Get drag data from shared state\n const dragData = getDragData();\n const title = dragData?.taskTitle || 'New Event';\n const color = dragData?.color || '#7c3aed';\n\n setDropPreview({\n dateStr,\n dayIndex,\n top: snappedTop,\n timeLabel,\n color,\n title,\n });\n };\n\n const handleDragLeave = (e: React.DragEvent) => {\n // Only clear if we're actually leaving the calendar area\n const rect = e.currentTarget.getBoundingClientRect();\n const x = e.clientX;\n const y = e.clientY;\n \n if (x < rect.left || x > rect.right || y < rect.top || y > rect.bottom) {\n setIsDraggingOver(null);\n setDropPreview(null);\n }\n };\n\n const handleDrop = async (e: React.DragEvent, date: Date) => {\n e.preventDefault();\n setIsDraggingOver(null);\n setDropPreview(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 const showPreview = dropPreview && dropPreview.dayIndex === dayIndex;\n \n return (\n handleDragOver(e, dateStr, dayIndex)}\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 {/* Drop preview indicator */}\n {showPreview && (\n

\n \n {dropPreview.title}\n \n \n {dropPreview.timeLabel}\n \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",[],[160,279,321],"2baa6b90-cf08-11f0-a5be-42dde27851f2","App.tsx","18aab0ac-ce33-11f0-bbbf-42dde27851f2",63,["D",1764629444765],"/** @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, User } from \"../../shared/types.ts\";\nimport { TaskList } from \"./TaskList.tsx\";\nimport { TaskDetail } from \"./TaskDetail.tsx\";\nimport { Calendar } from \"./Calendar.tsx\";\nimport { EventDetailModal } from \"./EventDetailModal.tsx\";\nimport { Login } from \"./Login.tsx\";\n\nexport function App() {\n const [user, setUser] = useState(undefined); // undefined = loading\n const [tasks, setTasks] = useState([]);\n const [cycle, setCycle] = useState(null);\n const [events, setEvents] = useState([]);\n const [selectedTask, setSelectedTask] = useState(null);\n const [selectedEvent, setSelectedEvent] = 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 current user\n const fetchUser = useCallback(async () => {\n try {\n const response = await fetch('/api/auth/me');\n const data = await response.json();\n if (data.success) {\n setUser(data.data); // null if not logged in\n }\n } catch (err) {\n console.error('Failed to fetch user:', err);\n setUser(null);\n }\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 if (response.status === 401) {\n // Not authenticated\n setUser(null);\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 // Initial load: fetch user first, then data if authenticated\n useEffect(() => {\n fetchUser();\n }, [fetchUser]);\n\n // Fetch data when user is loaded and authenticated\n useEffect(() => {\n if (user) {\n setLoading(true);\n Promise.all([fetchTasks(), fetchEvents()]).finally(() => {\n setLoading(false);\n });\n } else if (user === null) {\n setLoading(false);\n }\n }, [user, fetchTasks, fetchEvents]);\n\n const handleLogout = async () => {\n try {\n await fetch('/api/auth/logout', { method: 'POST' });\n setUser(null);\n setTasks([]);\n setEvents([]);\n setCycle(null);\n } catch (err) {\n console.error('Failed to logout:', err);\n }\n };\n\n const handleConnectGoogle = () => {\n window.location.href = '/api/auth/google';\n };\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 // Show loading while checking auth\n if (user === undefined) {\n return (\n

\n );\n }\n\n // Show login if not authenticated\n if (user === null) {\n return ;\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 {/* Account Header */}\n

\n {user.name ? user.name.charAt(0).toUpperCase() : user.email.charAt(0).toUpperCase()}\n

\n {user.name || user.email}\n

\n \n Sign out\n \n

\n\n {/* Google Connect Banner */}\n {!user.googleConnected && (\n

\n \n

Connect Google Calendar

Sync your events and schedule tasks

\n \n Connect\n \n

\n )}\n\n {/* Main Content */}\n

\n \n

\n \n {selectedTask && (\n setSelectedTask(null)}\n />\n )}\n \n {selectedEvent && (\n setSelectedEvent(null)}\n onDelete={handleDeleteEvent}\n />\n )}\n

\n );\n}\n",[],[160,279,329],"1856e26a-ce33-11f0-8193-42dde27851f2",5,["D",1764537929542],[195,196,197,198,199,200,201,202],[160,279],["D",1764537929135],[194,203,204,205,206],[160],"2bbaed9e-cf08-11f0-b8dc-42dde27851f2","index.ts",65,["D",1764629444852],"http","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\";\nimport { authRoutes } from \"./routes/auth.ts\";\nimport { sessionMiddleware } from \"./middleware/session.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// Apply session middleware to all routes\napp.use('*', sessionMiddleware);\n\n// API routes\napp.route('/api/auth', authRoutes);\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\n",[],[165,345],"446721d2-d3a9-11f0-afcc-42dde27851f2","linear.ts","18e9cb8e-ce33-11f0-9668-42dde27851f2","188ab342-ce33-11f0-bbbf-42dde27851f2",["D",1765138439532],"import { Hono } from \"https://esm.sh/hono@4.4.2\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport type { LinearTask, LinearCycleInfo, ApiResponse } from \"../../shared/types.ts\";\nimport { requireAuth, type SessionUser } from \"../middleware/session.ts\";\nimport { USERS_TABLE } from \"../database/migrations.ts\";\n\nconst linearRoutes = new Hono();\n\n// Apply auth middleware to all linear routes\nlinearRoutes.use('*', requireAuth);\n\n// Get Linear OAuth credentials\nfunction getLinearCredentials() {\n const clientId = Deno.env.get('LINEAR_CLIENT_ID');\n const clientSecret = Deno.env.get('LINEAR_CLIENT_SECRET');\n \n if (!clientId || !clientSecret) {\n throw new Error('Linear OAuth credentials not configured');\n }\n \n return { clientId, clientSecret };\n}\n\n// Refresh Linear access token using refresh token\nasync function refreshLinearToken(userId: string, refreshToken: string): Promise {\n const { clientId, clientSecret } = getLinearCredentials();\n \n const response = await fetch('https://api.linear.app/oauth/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 errorText = await response.text();\n throw new Error(`Failed to refresh Linear token: ${errorText}`);\n }\n \n const data = await response.json();\n \n // Update stored tokens in database\n await sqlite.execute(`\n UPDATE ${USERS_TABLE}\n SET linear_access_token = ?, linear_refresh_token = ?, updated_at = CURRENT_TIMESTAMP\n WHERE id = ?\n `, [data.access_token, data.refresh_token, userId]);\n \n return data.access_token;\n}\n\n// Query 1: Get teams and their active cycles (lightweight)\nconst ACTIVE_CYCLES_QUERY = `\n query ActiveCycles {\n viewer {\n teams {\n nodes {\n id\n name\n activeCycle {\n id\n name\n startsAt\n endsAt\n }\n }\n }\n }\n }\n`;\n\n// Query 2: Get issues for a specific cycle (with pagination limit)\nconst CYCLE_ISSUES_QUERY = `\n query CycleIssues($cycleId: String!) {\n cycle(id: $cycleId) {\n issues(first: 100) {\n nodes {\n id\n title\n description\n priority\n priorityLabel\n sortOrder\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 parent {\n id\n }\n children {\n nodes {\n id\n title\n description\n priority\n priorityLabel\n sortOrder\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 parent {\n id\n }\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 sortOrder\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 parent {\n id\n }\n children {\n nodes {\n id\n title\n description\n priority\n priorityLabel\n sortOrder\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 parent {\n id\n }\n }\n }\n }\n }\n`;\n\n// Helper to make Linear API calls with automatic token refresh on 401\nasync function linearGraphQL(\n user: SessionUser,\n query: string,\n variables?: Record\n): Promise {\n let accessToken = user.linearAccessToken;\n \n // First attempt\n let response = await fetch('https://api.linear.app/graphql', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n 'Authorization': `Bearer ${accessToken}`,\n },\n body: JSON.stringify({ query, variables }),\n });\n\n // If 401 and we have a refresh token, try to refresh\n if (response.status === 401 && user.linearRefreshToken) {\n console.log('Linear token expired, refreshing...');\n accessToken = await refreshLinearToken(user.id, user.linearRefreshToken);\n \n // Retry with new token\n response = await fetch('https://api.linear.app/graphql', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n 'Authorization': `Bearer ${accessToken}`,\n },\n body: JSON.stringify({ query, variables }),\n });\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, includeChildren = true): LinearTask {\n const parent = issue.parent as { id: string } | null;\n const childrenData = issue.children as { nodes: Record[] } | null;\n \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 sortOrder: issue.sortOrder as number,\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 parentId: parent?.id || null,\n children: includeChildren && childrenData?.nodes \n ? childrenData.nodes.map(child => transformIssue(child, false))\n : [],\n };\n}\n\n// Get tasks for current active cycle\nlinearRoutes.get('/tasks', async (c) => {\n try {\n const user = c.get('user') as SessionUser;\n\n // Step 1: Get teams and their active cycles\n const cyclesData = await linearGraphQL<{\n viewer: {\n teams: {\n nodes: Array<{\n id: string;\n name: string;\n activeCycle: {\n id: string;\n name: string;\n startsAt: string;\n endsAt: string;\n } | null;\n }>;\n };\n };\n }>(user, ACTIVE_CYCLES_QUERY);\n\n // Find the first team with an active cycle\n const teamWithCycle = cyclesData.viewer.teams.nodes.find(team => team.activeCycle !== null);\n\n if (!teamWithCycle || !teamWithCycle.activeCycle) {\n return c.json>({\n success: true,\n data: { tasks: [], cycle: null },\n });\n }\n\n const cycle = teamWithCycle.activeCycle;\n\n // Step 2: Get issues for this cycle\n const issuesData = await linearGraphQL<{\n cycle: {\n issues: {\n nodes: Record[];\n };\n };\n }>(user, CYCLE_ISSUES_QUERY, { cycleId: cycle.id });\n\n const tasks = issuesData.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 user = c.get('user') as SessionUser;\n const taskId = c.req.param('id');\n\n const data = await linearGraphQL<{\n issue: Record | null;\n }>(user, 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",[],[165,360,353],"routes","2bbfad8e-cf08-11f0-8c1a-42dde27851f2","calendar.ts","18e69f2c-ce33-11f0-8193-42dde27851f2",66,["D",1764629444898],"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\";\nimport { requireAuth, type SessionUser } from \"../middleware/session.ts\";\n\nconst calendarRoutes = new Hono();\n\n// Apply auth middleware to all calendar routes\ncalendarRoutes.use('*', requireAuth);\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\n if (!clientId || !clientSecret) {\n throw new Error('Google OAuth credentials not configured');\n }\n\n return { clientId, clientSecret };\n}\n\n// Get a fresh access token using user's refresh token\nasync function getAccessToken(refreshToken: string): Promise {\n const { clientId, clientSecret } = 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 refreshToken: string,\n title: string,\n description: string | null,\n start: string,\n end: string,\n color: string\n): Promise {\n const accessToken = await getAccessToken(refreshToken);\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 refreshToken: string,\n googleEventId: string,\n updates: { start?: string; end?: string; title?: string }\n): Promise {\n const accessToken = await getAccessToken(refreshToken);\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(refreshToken: string, googleEventId: string): Promise {\n const accessToken = await getAccessToken(refreshToken);\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// Map Google Calendar colorId to hex color\nfunction getHexFromGoogleColorId(colorId: string | undefined): string {\n const colorMap: Record = {\n '1': '#7986CB', // Lavender\n '2': '#33B679', // Sage\n '3': '#8E24AA', // Grape\n '4': '#E67C73', // Flamingo\n '5': '#F6BF26', // Banana\n '6': '#F4511E', // Tangerine\n '7': '#039BE5', // Peacock\n '8': '#616161', // Graphite\n '9': '#3F51B5', // Blueberry\n '10': '#0B8043', // Basil\n '11': '#D50000', // Tomato\n };\n return colorMap[colorId || '9'] || '#3B82F6';\n}\n\n// Fetch events from Google Calendar (using user's refresh token)\nasync function fetchGoogleCalendarEvents(\n refreshToken: string,\n startDate: string,\n endDate: string\n): Promise {\n const accessToken = await getAccessToken(refreshToken);\n\n const params = new URLSearchParams({\n timeMin: startDate,\n timeMax: endDate,\n singleEvents: 'true',\n orderBy: 'startTime',\n maxResults: '100',\n });\n\n const response = await fetch(\n `https://www.googleapis.com/calendar/v3/calendars/primary/events?${params}`,\n {\n headers: {\n 'Authorization': `Bearer ${accessToken}`,\n },\n }\n );\n\n if (!response.ok) {\n const error = await response.text();\n throw new Error(`Failed to fetch Google Calendar events: ${error}`);\n }\n\n const data = await response.json();\n \n // Transform Google Calendar events to our format\n return (data.items || [])\n .filter((item: Record) => {\n // Only include events with dateTime (skip all-day events)\n const start = item.start as Record | undefined;\n return start?.dateTime;\n })\n .map((item: Record) => {\n const start = item.start as Record;\n const end = item.end as Record;\n \n return {\n id: `gcal_${item.id}`,\n taskId: null,\n title: (item.summary as string) || 'Untitled Event',\n description: (item.description as string) || null,\n start: start.dateTime,\n end: end.dateTime,\n googleEventId: item.id as string,\n color: getHexFromGoogleColorId(item.colorId as string | undefined),\n isGoogleEvent: true, // Flag to identify Google-only events\n } as CalendarEvent & { isGoogleEvent?: boolean };\n });\n}\n\n// GET /events - Get all events (optionally filtered by date range)\n// Merges local database events with Google Calendar events\ncalendarRoutes.get('/events', async (c) => {\n try {\n const user = c.get('user') as SessionUser;\n const start = c.req.query('start');\n const end = c.req.query('end');\n\n // Get local database events (filtered by user)\n let localEvents: CalendarEvent[];\n if (start && end) {\n localEvents = await db.getEventsInRange(user.id, start, end);\n } else {\n localEvents = await db.getAllEvents(user.id);\n }\n\n // Get Google Calendar events (if date range provided and user has Google connected)\n let googleEvents: CalendarEvent[] = [];\n if (start && end && user.googleRefreshToken) {\n try {\n googleEvents = await fetchGoogleCalendarEvents(user.googleRefreshToken, start, end);\n } catch (error) {\n console.error('Failed to fetch Google Calendar events:', error);\n // Continue with just local events\n }\n }\n\n // Merge events, avoiding duplicates\n // Local events that have a googleEventId are already synced, so we filter those out from googleEvents\n const localGoogleEventIds = new Set(\n localEvents\n .filter(e => e.googleEventId)\n .map(e => e.googleEventId)\n );\n\n const uniqueGoogleEvents = googleEvents.filter(\n e => !localGoogleEventIds.has(e.googleEventId)\n );\n\n const allEvents = [...localEvents, ...uniqueGoogleEvents];\n\n return c.json>({\n success: true,\n data: allEvents,\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 user = c.get('user') as SessionUser;\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 (if user has Google connected)\n let googleEventId: string | null = null;\n if (user.googleRefreshToken) {\n try {\n googleEventId = await createGoogleEvent(\n user.googleRefreshToken,\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\n }\n }\n\n // Create in local database\n const event = await db.createEvent(\n user.id,\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 user = c.get('user') as SessionUser;\n const eventId = c.req.param('id');\n const body = await c.req.json();\n\n // Get current event to check for Google sync (with ownership check)\n const currentEvent = await db.getEventById(user.id, 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 and user has Google connected\n if (currentEvent.googleEventId && user.googleRefreshToken) {\n try {\n await updateGoogleEvent(user.googleRefreshToken, 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(user.id, 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 user = c.get('user') as SessionUser;\n const eventId = c.req.param('id');\n\n // Get current event to check for Google sync (with ownership check)\n const currentEvent = await db.getEventById(user.id, 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 and user has Google connected\n if (currentEvent.googleEventId && user.googleRefreshToken) {\n try {\n await deleteGoogleEvent(user.googleRefreshToken, 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(user.id, 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",[],[165,360,362],"c809b776-d00b-11f0-af24-42dde27851f2","auth.ts","2ba464f2-cf08-11f0-b22a-42dde27851f2",72,["D",1764740946734],"import { Hono } from \"https://esm.sh/hono@4.4.2\";\nimport { getCookie, setCookie, deleteCookie } from \"https://esm.sh/hono@4.4.2/cookie\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { USERS_TABLE, SESSIONS_TABLE } from \"../database/migrations.ts\";\n\nconst authRoutes = new Hono();\n\n// Generate a random session ID\nfunction generateSessionId(): string {\n const array = new Uint8Array(32);\n crypto.getRandomValues(array);\n return Array.from(array, b => b.toString(16).padStart(2, '0')).join('');\n}\n\n// Get Linear OAuth credentials\nfunction getLinearCredentials() {\n const clientId = Deno.env.get('LINEAR_CLIENT_ID');\n const clientSecret = Deno.env.get('LINEAR_CLIENT_SECRET');\n \n if (!clientId || !clientSecret) {\n throw new Error('Linear OAuth credentials not configured');\n }\n \n return { clientId, clientSecret };\n}\n\n// Get Google OAuth credentials\nfunction getGoogleCredentials() {\n const clientId = Deno.env.get('GOOGLE_CLIENT_ID');\n const clientSecret = Deno.env.get('GOOGLE_CLIENT_SECRET');\n \n if (!clientId || !clientSecret) {\n throw new Error('Google OAuth credentials not configured');\n }\n \n return { clientId, clientSecret };\n}\n\n// Get the app's base URL for OAuth callbacks\nfunction getBaseUrl(c: { req: { url: string } }): string {\n const url = new URL(c.req.url);\n return `${url.protocol}//${url.host}`;\n}\n\n// Linear OAuth: Redirect to Linear authorization\nauthRoutes.get('/linear', (c) => {\n const { clientId } = getLinearCredentials();\n const baseUrl = getBaseUrl(c);\n const redirectUri = `${baseUrl}/api/auth/linear/callback`;\n \n const params = new URLSearchParams({\n client_id: clientId,\n redirect_uri: redirectUri,\n response_type: 'code',\n scope: 'read',\n prompt: 'consent',\n });\n \n const authUrl = `https://linear.app/oauth/authorize?${params}`;\n \n return new Response(null, {\n status: 302,\n headers: { Location: authUrl },\n });\n});\n\n// Linear OAuth: Handle callback\nauthRoutes.get('/linear/callback', async (c) => {\n const code = c.req.query('code');\n const error = c.req.query('error');\n \n if (error) {\n return new Response(null, {\n status: 302,\n headers: { Location: '/?error=linear_auth_denied' },\n });\n }\n \n if (!code) {\n return new Response(null, {\n status: 302,\n headers: { Location: '/?error=missing_code' },\n });\n }\n \n const { clientId, clientSecret } = getLinearCredentials();\n const baseUrl = getBaseUrl(c);\n const redirectUri = `${baseUrl}/api/auth/linear/callback`;\n \n // Exchange code for access token\n const tokenResponse = await fetch('https://api.linear.app/oauth/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 code,\n redirect_uri: redirectUri,\n grant_type: 'authorization_code',\n }),\n });\n \n if (!tokenResponse.ok) {\n const errorText = await tokenResponse.text();\n console.error('Linear token exchange failed:', errorText);\n return new Response(null, {\n status: 302,\n headers: { Location: '/?error=token_exchange_failed' },\n });\n }\n \n const tokenData = await tokenResponse.json();\n const accessToken = tokenData.access_token;\n const linearRefreshToken = tokenData.refresh_token;\n \n // Fetch user info from Linear\n const userResponse = await fetch('https://api.linear.app/graphql', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n 'Authorization': `Bearer ${accessToken}`,\n },\n body: JSON.stringify({\n query: `query { viewer { id email name } }`,\n }),\n });\n \n if (!userResponse.ok) {\n return new Response(null, {\n status: 302,\n headers: { Location: '/?error=user_fetch_failed' },\n });\n }\n \n const userData = await userResponse.json();\n const linearUser = userData.data.viewer;\n \n // Create or update user in database (including refresh token)\n await sqlite.execute(`\n INSERT INTO ${USERS_TABLE} (id, email, name, linear_access_token, linear_refresh_token, updated_at)\n VALUES (?, ?, ?, ?, ?, CURRENT_TIMESTAMP)\n ON CONFLICT(id) DO UPDATE SET\n email = excluded.email,\n name = excluded.name,\n linear_access_token = excluded.linear_access_token,\n linear_refresh_token = excluded.linear_refresh_token,\n updated_at = CURRENT_TIMESTAMP\n `, [linearUser.id, linearUser.email, linearUser.name, accessToken, linearRefreshToken]);\n \n // Create session\n const sessionId = generateSessionId();\n const expiresAt = new Date(Date.now() + 30 * 24 * 60 * 60 * 1000).toISOString(); // 30 days\n \n await sqlite.execute(`\n INSERT INTO ${SESSIONS_TABLE} (id, user_id, expires_at)\n VALUES (?, ?, ?)\n `, [sessionId, linearUser.id, expiresAt]);\n \n // Set session cookie and redirect\n setCookie(c, 'session', sessionId, {\n path: '/',\n httpOnly: true,\n secure: true,\n sameSite: 'Lax',\n maxAge: 30 * 24 * 60 * 60, // 30 days\n });\n \n return new Response(null, {\n status: 302,\n headers: { \n Location: '/',\n 'Set-Cookie': `session=${sessionId}; Path=/; HttpOnly; Secure; SameSite=Lax; Max-Age=${30 * 24 * 60 * 60}`,\n },\n });\n});\n\n// Google OAuth: Redirect to Google authorization (requires logged-in user)\nauthRoutes.get('/google', async (c) => {\n const sessionId = getCookie(c, 'session');\n \n if (!sessionId) {\n return new Response(null, {\n status: 302,\n headers: { Location: '/?error=not_logged_in' },\n });\n }\n \n // Verify session exists\n const sessionResult = await sqlite.execute(`\n SELECT user_id FROM ${SESSIONS_TABLE}\n WHERE id = ? AND expires_at > datetime('now')\n `, [sessionId]);\n \n if (sessionResult.rows.length === 0) {\n return new Response(null, {\n status: 302,\n headers: { Location: '/?error=invalid_session' },\n });\n }\n \n const { clientId } = getGoogleCredentials();\n const baseUrl = getBaseUrl(c);\n const redirectUri = `${baseUrl}/api/auth/google/callback`;\n \n const params = new URLSearchParams({\n client_id: clientId,\n redirect_uri: redirectUri,\n response_type: 'code',\n scope: 'https://www.googleapis.com/auth/calendar',\n access_type: 'offline',\n prompt: 'consent',\n });\n \n const authUrl = `https://accounts.google.com/o/oauth2/v2/auth?${params}`;\n \n return new Response(null, {\n status: 302,\n headers: { Location: authUrl },\n });\n});\n\n// Google OAuth: Handle callback\nauthRoutes.get('/google/callback', async (c) => {\n const code = c.req.query('code');\n const error = c.req.query('error');\n \n if (error) {\n return new Response(null, {\n status: 302,\n headers: { Location: '/?error=google_auth_denied' },\n });\n }\n \n if (!code) {\n return new Response(null, {\n status: 302,\n headers: { Location: '/?error=missing_code' },\n });\n }\n \n // Get current user from session\n const sessionId = getCookie(c, 'session');\n \n if (!sessionId) {\n return new Response(null, {\n status: 302,\n headers: { Location: '/?error=not_logged_in' },\n });\n }\n \n const sessionResult = await sqlite.execute(`\n SELECT user_id FROM ${SESSIONS_TABLE}\n WHERE id = ? AND expires_at > datetime('now')\n `, [sessionId]);\n \n if (sessionResult.rows.length === 0) {\n return new Response(null, {\n status: 302,\n headers: { Location: '/?error=invalid_session' },\n });\n }\n \n const userId = sessionResult.rows[0].user_id as string;\n \n const { clientId, clientSecret } = getGoogleCredentials();\n const baseUrl = getBaseUrl(c);\n const redirectUri = `${baseUrl}/api/auth/google/callback`;\n \n // Exchange code for tokens\n const tokenResponse = 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 code,\n redirect_uri: redirectUri,\n grant_type: 'authorization_code',\n }),\n });\n \n if (!tokenResponse.ok) {\n const errorText = await tokenResponse.text();\n console.error('Google token exchange failed:', errorText);\n return new Response(null, {\n status: 302,\n headers: { Location: '/?error=google_token_exchange_failed' },\n });\n }\n \n const tokenData = await tokenResponse.json();\n const refreshToken = tokenData.refresh_token;\n \n if (!refreshToken) {\n return new Response(null, {\n status: 302,\n headers: { Location: '/?error=no_refresh_token' },\n });\n }\n \n // Store refresh token for user\n await sqlite.execute(`\n UPDATE ${USERS_TABLE}\n SET google_refresh_token = ?, updated_at = CURRENT_TIMESTAMP\n WHERE id = ?\n `, [refreshToken, userId]);\n \n return new Response(null, {\n status: 302,\n headers: { Location: '/?google_connected=true' },\n });\n});\n\n// Get current user info\nauthRoutes.get('/me', async (c) => {\n const sessionId = getCookie(c, 'session');\n \n if (!sessionId) {\n return c.json({ success: true, data: null });\n }\n \n // Get session and user\n const result = await sqlite.execute(`\n SELECT u.id, u.email, u.name, u.google_refresh_token IS NOT NULL as google_connected\n FROM ${SESSIONS_TABLE} s\n JOIN ${USERS_TABLE} u ON s.user_id = u.id\n WHERE s.id = ? AND s.expires_at > datetime('now')\n `, [sessionId]);\n \n if (result.rows.length === 0) {\n return c.json({ success: true, data: null });\n }\n \n const user = result.rows[0];\n return c.json({\n success: true,\n data: {\n id: user.id,\n email: user.email,\n name: user.name,\n googleConnected: Boolean(user.google_connected),\n },\n });\n});\n\n// Logout\nauthRoutes.post('/logout', async (c) => {\n const sessionId = getCookie(c, 'session');\n \n if (sessionId) {\n // Delete session from database\n await sqlite.execute(`DELETE FROM ${SESSIONS_TABLE} WHERE id = ?`, [sessionId]);\n \n // Clear cookie\n deleteCookie(c, 'session', { path: '/' });\n }\n \n return c.json({ success: true });\n});\n\nexport { authRoutes };\n\n",[],[165,360,370],"188ab28e-ce33-11f0-bbbf-42dde27851f2",7,["D",1764537929883],[189,190,191],[165,360],"c7fe304a-d00b-11f0-a620-42dde27851f2","session.ts","2ba0e854-cf08-11f0-b41f-42dde27851f2","2b87bb04-cf08-11f0-b22a-42dde27851f2",70,["D",1764740946690],"import { Context, Next } from \"https://esm.sh/hono@4.4.2\";\nimport { getCookie } from \"https://esm.sh/hono@4.4.2/cookie\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { SESSIONS_TABLE, USERS_TABLE } from \"../database/migrations.ts\";\n\n// User info stored in context\nexport interface SessionUser {\n id: string;\n email: string;\n name: string | null;\n linearAccessToken: string;\n linearRefreshToken: string | null;\n googleRefreshToken: string | null;\n}\n\n// Extend Hono context to include user\ndeclare module \"https://esm.sh/hono@4.4.2\" {\n interface ContextVariableMap {\n user: SessionUser | null;\n }\n}\n\n// Middleware to load user from session (doesn't require auth)\nexport async function sessionMiddleware(c: Context, next: Next) {\n const sessionId = getCookie(c, 'session');\n \n if (!sessionId) {\n c.set('user', null);\n return next();\n }\n \n // Get user from session\n const result = await sqlite.execute(`\n SELECT u.id, u.email, u.name, u.linear_access_token, u.linear_refresh_token, u.google_refresh_token\n FROM ${SESSIONS_TABLE} s\n JOIN ${USERS_TABLE} u ON s.user_id = u.id\n WHERE s.id = ? AND s.expires_at > datetime('now')\n `, [sessionId]);\n \n if (result.rows.length === 0) {\n c.set('user', null);\n return next();\n }\n \n const row = result.rows[0];\n c.set('user', {\n id: row.id as string,\n email: row.email as string,\n name: row.name as string | null,\n linearAccessToken: row.linear_access_token as string,\n linearRefreshToken: row.linear_refresh_token as string | null,\n googleRefreshToken: row.google_refresh_token as string | null,\n });\n \n return next();\n}\n\n// Middleware that requires authentication\nexport async function requireAuth(c: Context, next: Next) {\n const user = c.get('user');\n \n if (!user) {\n return c.json({\n success: false,\n error: 'Authentication required',\n }, 401);\n }\n \n return next();\n}\n\n// Middleware that requires Google Calendar to be connected\nexport async function requireGoogleCalendar(c: Context, next: Next) {\n const user = c.get('user');\n \n if (!user) {\n return c.json({\n success: false,\n error: 'Authentication required',\n }, 401);\n }\n \n if (!user.googleRefreshToken) {\n return c.json({\n success: false,\n error: 'Google Calendar not connected',\n }, 403);\n }\n \n return next();\n}\n\n",[],[165,391,383],"middleware","2b87ba46-cf08-11f0-b22a-42dde27851f2",59,["D",1764629444543],[187],[165,391],"2bb0878c-cf08-11f0-9486-42dde27851f2","queries.ts","18d57ae4-ce33-11f0-a53c-42dde27851f2","186a95bc-ce33-11f0-b6b7-42dde27851f2",64,["D",1764629444774],"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 (filtered by user)\nexport async function getEventsInRange(userId: string, 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 user_id = ? AND start_time >= ? AND start_time <= ?\n ORDER BY start_time ASC\n `, [userId, 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 (filtered by user)\nexport async function getAllEvents(userId: 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 user_id = ?\n ORDER BY start_time ASC\n `, [userId]);\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 (with user association)\nexport async function createEvent(\n userId: 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): Promise {\n const id = generateId();\n\n await sqlite.execute(`\n INSERT INTO ${EVENTS_TABLE} (id, user_id, task_id, title, description, start_time, end_time, google_event_id, color)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [id, userId, 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 (with user ownership check)\nexport async function updateEvent(\n userId: string,\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 values.push(userId);\n\n await sqlite.execute(`\n UPDATE ${EVENTS_TABLE}\n SET ${setClauses.join(', ')}\n WHERE id = ? AND user_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 = ? AND user_id = ?\n `, [id, userId]);\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 (with user ownership check)\nexport async function deleteEvent(userId: string, id: string): Promise {\n const result = await sqlite.execute(`\n DELETE FROM ${EVENTS_TABLE}\n WHERE id = ? AND user_id = ?\n `, [id, userId]);\n\n return result.rowsAffected > 0;\n}\n\n// Get event by ID (with user ownership check)\nexport async function getEventById(userId: string, 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 = ? AND user_id = ?\n `, [id, userId]);\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",[],[165,406,398],"database","c8049598-d00b-11f0-a945-42dde27851f2","migrations.ts","18e2c230-ce33-11f0-a32a-42dde27851f2",71,["D",1764740946724],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst USERS_TABLE = 'general_asks_users_v2';\nconst SESSIONS_TABLE = 'general_asks_sessions_v2';\nconst EVENTS_TABLE = 'linear_calendar_events_v3';\n\nexport async function runMigrations() {\n // Create users table (identified by Linear user ID)\n // v2: Added linear_refresh_token column for token refresh\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${USERS_TABLE} (\n id TEXT PRIMARY KEY,\n email TEXT NOT NULL,\n name TEXT,\n linear_access_token TEXT NOT NULL,\n linear_refresh_token TEXT,\n google_refresh_token TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Create sessions table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${SESSIONS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n expires_at TEXT NOT NULL,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Create index on sessions for user lookups\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${SESSIONS_TABLE}_user_id \n ON ${SESSIONS_TABLE}(user_id)\n `);\n\n // Create calendar events table (with user_id)\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${EVENTS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\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 // Create index on user_id for user-specific queries\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${EVENTS_TABLE}_user_id \n ON ${EVENTS_TABLE}(user_id)\n `);\n\n console.log('Migrations complete');\n}\n\nexport { USERS_TABLE, SESSIONS_TABLE, EVENTS_TABLE };\n\n\n",[],[165,406,408],"186a94fe-ce33-11f0-b6b7-42dde27851f2",["D",1764537929672],[184,185],[165,406],["D",1764537929262],[183,186,188,192],[165],["D",1764532987103],{"_16":17,"_82":78},{"_16":17,"_76":-5,"_77":78,"_32":33,"_79":80,"_81":26},{"_64":65,"_20":66,"_18":67,"_68":19,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":-5,"_74":21,"_75":17},"ctx",{"_57":-5,"_103":459,"_460":461,"_462":463,"_464":26,"_465":26,"_466":26,"_467":37,"_468":-5,"_469":-7,"_470":-7,"_471":41,"_472":26,"_473":26,"_474":-5,"_475":26,"_476":26,"_477":26,"_478":-5},"ENV",{"_430":431,"_432":433,"_434":66,"_435":436,"_437":438,"_439":440,"_441":442,"_443":444,"_445":446,"_447":448,"_449":450,"_451":452,"_453":454,"_455":456,"_457":458},"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"]