[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_328":329,"_330":331},"routes/_app.x.$handle.$name",{"_95":94,"_31":44,"_103":85,"_26":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":24,"_118":119,"_120":24,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":24},"version",20,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","backend/routes/calendar.ts","latestPath","fileId","18e69f2c-ce33-11f0-8193-42dde27851f2","name","calendar.ts","fileType","script","content","import { Hono } from \"https://esm.sh/hono@4.4.2\";\nimport type { CalendarEvent, CreateEventRequest, UpdateEventRequest, ApiResponse } from \"../../shared/types.ts\";\nimport * as db from \"../database/queries.ts\";\n\nconst calendarRoutes = new Hono();\n\n// Get Google OAuth credentials from environment\nfunction getGoogleCredentials() {\n const clientId = Deno.env.get('GOOGLE_CLIENT_ID');\n const clientSecret = Deno.env.get('GOOGLE_CLIENT_SECRET');\n const refreshToken = Deno.env.get('GOOGLE_REFRESH_TOKEN');\n\n if (!clientId || !clientSecret || !refreshToken) {\n throw new Error('Google Calendar credentials not configured');\n }\n\n return { clientId, clientSecret, refreshToken };\n}\n\n// Get a fresh access token using refresh token\nasync function getAccessToken(): Promise {\n const { clientId, clientSecret, refreshToken } = getGoogleCredentials();\n\n const response = await fetch('https://oauth2.googleapis.com/token', {\n method: 'POST',\n headers: { 'Content-Type': 'application/x-www-form-urlencoded' },\n body: new URLSearchParams({\n client_id: clientId,\n client_secret: clientSecret,\n refresh_token: refreshToken,\n grant_type: 'refresh_token',\n }),\n });\n\n if (!response.ok) {\n const error = await response.text();\n throw new Error(`Failed to refresh Google token: ${error}`);\n }\n\n const data = await response.json();\n return data.access_token;\n}\n\n// Create Google Calendar event\nasync function createGoogleEvent(\n title: string,\n description: string | null,\n start: string,\n end: string,\n color: string\n): Promise {\n const accessToken = await getAccessToken();\n\n // Map hex color to Google Calendar colorId (1-11)\n const colorId = getGoogleColorId(color);\n\n const event = {\n summary: title,\n description: description || undefined,\n start: {\n dateTime: start,\n timeZone: 'America/Los_Angeles',\n },\n end: {\n dateTime: end,\n timeZone: 'America/Los_Angeles',\n },\n colorId,\n };\n\n const response = await fetch(\n 'https://www.googleapis.com/calendar/v3/calendars/primary/events',\n {\n method: 'POST',\n headers: {\n 'Authorization': `Bearer ${accessToken}`,\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify(event),\n }\n );\n\n if (!response.ok) {\n const error = await response.text();\n throw new Error(`Failed to create Google Calendar event: ${error}`);\n }\n\n const data = await response.json();\n return data.id;\n}\n\n// Update Google Calendar event\nasync function updateGoogleEvent(\n googleEventId: string,\n updates: { start?: string; end?: string; title?: string }\n): Promise {\n const accessToken = await getAccessToken();\n\n const patch: Record = {};\n\n if (updates.title) {\n patch.summary = updates.title;\n }\n if (updates.start) {\n patch.start = {\n dateTime: updates.start,\n timeZone: 'America/Los_Angeles',\n };\n }\n if (updates.end) {\n patch.end = {\n dateTime: updates.end,\n timeZone: 'America/Los_Angeles',\n };\n }\n\n const response = await fetch(\n `https://www.googleapis.com/calendar/v3/calendars/primary/events/${googleEventId}`,\n {\n method: 'PATCH',\n headers: {\n 'Authorization': `Bearer ${accessToken}`,\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify(patch),\n }\n );\n\n if (!response.ok) {\n const error = await response.text();\n throw new Error(`Failed to update Google Calendar event: ${error}`);\n }\n}\n\n// Delete Google Calendar event\nasync function deleteGoogleEvent(googleEventId: string): Promise {\n const accessToken = await getAccessToken();\n\n const response = await fetch(\n `https://www.googleapis.com/calendar/v3/calendars/primary/events/${googleEventId}`,\n {\n method: 'DELETE',\n headers: {\n 'Authorization': `Bearer ${accessToken}`,\n },\n }\n );\n\n // 404 is okay - event might already be deleted\n if (!response.ok && response.status !== 404) {\n const error = await response.text();\n throw new Error(`Failed to delete Google Calendar event: ${error}`);\n }\n}\n\n// Map hex color to Google Calendar colorId\nfunction getGoogleColorId(hexColor: string): string {\n const hex = hexColor.toLowerCase();\n\n if (hex.includes('ef') || hex.includes('f44') || hex.includes('d50')) return '11'; // Red\n if (hex.includes('f97') || hex.includes('f45')) return '6'; // Orange\n if (hex.includes('eab') || hex.includes('f6b')) return '5'; // Yellow\n if (hex.includes('10b') || hex.includes('0b8') || hex.includes('33b')) return '2'; // Green\n if (hex.includes('3b8') || hex.includes('039')) return '7'; // Blue\n if (hex.includes('8e2') || hex.includes('7c3')) return '3'; // Purple\n if (hex.includes('6b7') || hex.includes('616')) return '8'; // Gray\n\n return '9'; // Default to blueberry\n}\n\n// GET /events - Get all events (optionally filtered by date range)\ncalendarRoutes.get('/events', async (c) => {\n try {\n const start = c.req.query('start');\n const end = c.req.query('end');\n\n let events: CalendarEvent[];\n\n if (start && end) {\n events = await db.getEventsInRange(start, end);\n } else {\n events = await db.getAllEvents();\n }\n\n return c.json>({\n success: true,\n data: events,\n });\n } catch (error) {\n console.error('Error fetching events:', error);\n return c.json>({\n success: false,\n error: error instanceof Error ? error.message : 'Unknown error',\n }, 500);\n }\n});\n\n// POST /events - Create a new event\ncalendarRoutes.post('/events', async (c) => {\n try {\n const body = await c.req.json();\n\n // Calculate end time\n const startDate = new Date(body.start);\n const endDate = new Date(startDate.getTime() + body.durationMinutes * 60 * 1000);\n\n // Create in Google Calendar first\n let googleEventId: string | null = null;\n try {\n googleEventId = await createGoogleEvent(\n body.taskTitle,\n body.taskDescription,\n body.start,\n endDate.toISOString(),\n body.color\n );\n } catch (error) {\n console.error('Failed to create Google Calendar event:', error);\n // Continue without Google sync - we'll try again later\n }\n\n // Create in local database\n const event = await db.createEvent(\n body.taskId,\n body.taskTitle,\n body.taskDescription,\n body.start,\n endDate.toISOString(),\n googleEventId,\n body.color\n );\n\n return c.json>({\n success: true,\n data: event,\n });\n } catch (error) {\n console.error('Error creating event:', error);\n return c.json>({\n success: false,\n error: error instanceof Error ? error.message : 'Unknown error',\n }, 500);\n }\n});\n\n// PATCH /events/:id - Update an event\ncalendarRoutes.patch('/events/:id', async (c) => {\n try {\n const eventId = c.req.param('id');\n const body = await c.req.json();\n\n // Get current event to check for Google sync\n const currentEvent = await db.getEventById(eventId);\n if (!currentEvent) {\n return c.json>({\n success: false,\n error: 'Event not found',\n }, 404);\n }\n\n // Update in Google Calendar if synced\n if (currentEvent.googleEventId) {\n try {\n await updateGoogleEvent(currentEvent.googleEventId, {\n start: body.start,\n end: body.end,\n title: body.title,\n });\n } catch (error) {\n console.error('Failed to update Google Calendar event:', error);\n // Continue with local update\n }\n }\n\n // Update in local database\n const updatedEvent = await db.updateEvent(eventId, {\n start: body.start,\n end: body.end,\n title: body.title,\n });\n\n return c.json>({\n success: true,\n data: updatedEvent,\n });\n } catch (error) {\n console.error('Error updating event:', error);\n return c.json>({\n success: false,\n error: error instanceof Error ? error.message : 'Unknown error',\n }, 500);\n }\n});\n\n// DELETE /events/:id - Delete an event\ncalendarRoutes.delete('/events/:id', async (c) => {\n try {\n const eventId = c.req.param('id');\n\n // Get current event to check for Google sync\n const currentEvent = await db.getEventById(eventId);\n if (!currentEvent) {\n return c.json>({\n success: false,\n error: 'Event not found',\n }, 404);\n }\n\n // Delete from Google Calendar if synced\n if (currentEvent.googleEventId) {\n try {\n await deleteGoogleEvent(currentEvent.googleEventId);\n } catch (error) {\n console.error('Failed to delete Google Calendar event:', error);\n // Continue with local delete\n }\n }\n\n // Delete from local database\n await db.deleteEvent(eventId);\n\n return c.json>({\n success: true,\n data: { deleted: true },\n });\n } catch (error) {\n console.error('Error deleting event:', error);\n return c.json>({\n success: false,\n error: error instanceof Error ? error.message : 'Unknown error',\n }, 500);\n }\n});\n\nexport { calendarRoutes };\n\n","createdAt",["D",1764537930486],"branchVersion","branchId","966a5c38-ce27-11f0-9f57-42dde27851f2","id","966a184a-ce27-11f0-9f57-42dde27851f2","general-asks",["D",1764532987103],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","7ed186b0-c78a-4757-a5b0-12c00ac89afa","pinnedFileId","18edb10e-ce33-11f0-b19b-42dde27851f2","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","e9195859-3c6b-4b40-bb3e-c11844477fdf","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":24},"branch",{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"isOwned",79,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","shapedlines","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yYlc2Q1A2eUFyNEdDeXBud0E0bFJyWlJVUzQifQ","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":324,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":325,"_79":326,"_81":327,"_83":24},"tree",[176,182,193,194,195],"files",[176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195],"counts",{"_165":61,"_166":134,"_167":61,"_168":169,"_170":171},"contents",[125,126,127,128,129],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":159,"_31":160,"_29":161,"_133":-5,"_40":41,"_39":162,"_135":57,"_37":163,"_13":61,"_33":151,"_35":-5,"_23":24,"_137":-5,"_26":164},{"_42":153,"_31":154,"_29":155,"_133":-5,"_40":41,"_39":156,"_135":57,"_37":157,"_13":61,"_33":151,"_35":-5,"_23":24,"_137":-5,"_26":158},{"_42":146,"_31":147,"_29":148,"_133":-5,"_40":41,"_39":149,"_135":57,"_37":150,"_13":61,"_33":151,"_35":-5,"_23":24,"_137":-5,"_26":152},{"_42":139,"_31":140,"_29":141,"_133":-5,"_40":41,"_39":142,"_135":57,"_37":143,"_13":61,"_33":20,"_35":144,"_23":24,"_137":-5,"_26":145},{"_42":130,"_31":131,"_29":132,"_133":-5,"_40":41,"_39":134,"_135":24,"_37":136,"_13":61,"_33":34,"_35":104,"_23":24,"_137":-5,"_26":138},"966c1226-ce27-11f0-9f57-42dde27851f2","main.ts","966c12da-ce27-11f0-9f57-42dde27851f2","parentId",1,"latest",["D",1764532987114],"label",[131],"18d85606-ce33-11f0-9668-42dde27851f2","deno.json","18d8578c-ce33-11f0-9668-42dde27851f2",18,["D",1764537930379],"{\n \"$schema\": \"https://raw.githubusercontent.com/denoland/deno/98f62cee78e85bfc47c62ed703777c6bc8794f1c/cli/schemas/config-file.v1.json\",\n \"lock\": false,\n \"compilerOptions\": {\n \"noImplicitAny\": false,\n \"strict\": true,\n \"types\": [\"https://www.val.town/types/valtown.d.ts\"],\n \"lib\": [\n \"dom\",\n \"dom.iterable\",\n \"dom.asynciterable\",\n \"deno.ns\",\n \"deno.unstable\"\n ]\n },\n \"lint\": {\n \"include\": [\"deno:/https/esm.town/**/*\"],\n \"rules\": {\n \"exclude\": [\"no-explicit-any\"]\n }\n },\n \"node_modules_dir\": false,\n \"experimental\": {\n \"unstable-node-globals\": true,\n \"unstable-temporal\": true,\n \"unstable-worker-options\": true,\n \"unstable-sloppy-imports\": true\n }\n}",[140],"184204d0-ce33-11f0-aea2-42dde27851f2","shared","184205a2-ce33-11f0-aea2-42dde27851f2",4,["D",1764537929399],"directory",[147],"1818c746-ce33-11f0-aa28-42dde27851f2","frontend","1818c82c-ce33-11f0-aa28-42dde27851f2",2,["D",1764537929135],[154],"182beace-ce33-11f0-9440-42dde27851f2","backend","182bebc8-ce33-11f0-9440-42dde27851f2",3,["D",1764537929262],[160],"pulls","branches","forks","envVars",{"_172":174,"_175":61},"connections",{"_172":61,"_173":61},"count","unfilledCount",6,"emptyCount",{"_42":159,"_31":160,"_29":161,"_133":-5,"_40":41,"_39":162,"_135":57,"_37":321,"_13":61,"_33":151,"_35":-5,"_23":24,"_137":-5,"_197":322,"_26":323},{"_42":317,"_31":308,"_29":302,"_133":161,"_40":41,"_39":174,"_135":57,"_37":318,"_13":61,"_33":151,"_35":-5,"_23":24,"_137":-5,"_197":319,"_26":320},{"_42":309,"_31":310,"_29":311,"_133":302,"_40":41,"_39":312,"_135":24,"_37":313,"_13":61,"_33":34,"_35":314,"_23":24,"_137":-5,"_197":315,"_26":316},{"_42":299,"_31":300,"_29":301,"_133":302,"_40":41,"_39":303,"_135":24,"_37":304,"_13":61,"_33":34,"_35":305,"_23":24,"_137":-5,"_197":306,"_26":307},{"_42":294,"_31":293,"_29":289,"_133":161,"_40":41,"_39":295,"_135":57,"_37":296,"_13":61,"_33":151,"_35":-5,"_23":24,"_137":-5,"_197":297,"_26":298},{"_42":288,"_31":32,"_29":30,"_133":289,"_40":41,"_39":14,"_135":24,"_37":290,"_13":61,"_33":34,"_35":36,"_23":24,"_137":-5,"_197":291,"_26":292},{"_42":153,"_31":154,"_29":155,"_133":-5,"_40":41,"_39":156,"_135":57,"_37":285,"_13":61,"_33":151,"_35":-5,"_23":24,"_137":-5,"_197":286,"_26":287},{"_42":280,"_31":239,"_29":233,"_133":155,"_40":41,"_39":281,"_135":57,"_37":282,"_13":61,"_33":151,"_35":-5,"_23":24,"_137":-5,"_197":283,"_26":284},{"_42":272,"_31":273,"_29":274,"_133":233,"_40":41,"_39":275,"_135":24,"_37":276,"_13":61,"_33":34,"_35":277,"_23":24,"_137":-5,"_197":278,"_26":279},{"_42":264,"_31":265,"_29":266,"_133":233,"_40":41,"_39":267,"_135":24,"_37":268,"_13":61,"_33":34,"_35":269,"_23":24,"_137":-5,"_197":270,"_26":271},{"_42":256,"_31":257,"_29":258,"_133":233,"_40":41,"_39":259,"_135":24,"_37":260,"_13":61,"_33":34,"_35":261,"_23":24,"_137":-5,"_197":262,"_26":263},{"_42":248,"_31":249,"_29":250,"_133":233,"_40":41,"_39":251,"_135":24,"_37":252,"_13":61,"_33":34,"_35":253,"_23":24,"_137":-5,"_197":254,"_26":255},{"_42":240,"_31":241,"_29":242,"_133":233,"_40":41,"_39":243,"_135":24,"_37":244,"_13":61,"_33":34,"_35":245,"_23":24,"_137":-5,"_197":246,"_26":247},{"_42":230,"_31":231,"_29":232,"_133":233,"_40":41,"_39":234,"_135":24,"_37":235,"_13":61,"_33":34,"_35":236,"_23":24,"_137":-5,"_197":237,"_26":238},{"_42":222,"_31":223,"_29":224,"_133":155,"_40":41,"_39":225,"_135":24,"_37":226,"_13":61,"_33":20,"_35":227,"_23":24,"_137":-5,"_197":228,"_26":229},{"_42":214,"_31":215,"_29":216,"_133":155,"_40":41,"_39":217,"_135":24,"_37":218,"_13":61,"_33":20,"_35":219,"_23":24,"_137":-5,"_197":220,"_26":221},{"_42":206,"_31":207,"_29":208,"_133":155,"_40":41,"_39":209,"_135":24,"_37":210,"_13":61,"_33":34,"_35":211,"_23":24,"_137":-5,"_197":212,"_26":213},{"_42":146,"_31":147,"_29":148,"_133":-5,"_40":41,"_39":149,"_135":57,"_37":203,"_13":61,"_33":151,"_35":-5,"_23":24,"_137":-5,"_197":204,"_26":205},{"_42":139,"_31":140,"_29":141,"_133":-5,"_40":41,"_39":142,"_135":57,"_37":200,"_13":61,"_33":20,"_35":144,"_23":24,"_137":-5,"_197":201,"_26":202},{"_42":130,"_31":131,"_29":132,"_133":-5,"_40":41,"_39":134,"_135":24,"_37":196,"_13":61,"_33":34,"_35":104,"_23":24,"_137":-5,"_197":198,"_26":199},["D",1764532987114],"children",[],[131],["D",1764537930379],[],[140],["D",1764537929399],[],[147],"18b30694-ce33-11f0-8193-42dde27851f2","index.tsx","18b3073e-ce33-11f0-8193-42dde27851f2",10,["D",1764537930058],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\nconst root = createRoot(document.getElementById(\"root\")!);\nroot.render();\n\n",[],[154,207],"18a78dc8-ce33-11f0-b19b-42dde27851f2","index.html","18a78eae-ce33-11f0-b19b-42dde27851f2",8,["D",1764537930066],"\n\n\n \n \n Linear Calendar\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\n\n

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

\n \n

Current Cycle

\n {cycle && (\n

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

\n )}\n

\n \n

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

\n \n

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

\n \n

No tasks in this cycle

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

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

\n \n

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

\n ))\n )}\n

\n \n

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

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

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

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

\n \n

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

\n \n

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

;\n default:\n return

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

\n \n

\n {task.title}\n

\n \n

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

\n \n

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

e.stopPropagation()}\n >\n

\n {task.title}\n

\n \n

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

\n \n \n \n \n

\n \n

\n Description\n

\n {task.description ? (\n

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

\n ) : (\n

No description provided

\n )}\n

\n \n

\n {task.estimate && (\n

\n Estimate\n

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

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

\n Due Date\n

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

\n )}\n \n

\n Created\n

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

\n \n

\n Last Updated\n

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

\n \n

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

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

;\n case 'started':\n return

;\n case 'canceled':\n return

;\n default:\n return

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

{line.slice(4)}

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

{line.slice(3)}

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

{line.slice(2)}

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

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

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

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

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

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

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

;\n }\n \n return

{line}

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

\n {event.title}\n

\n {!isCompact && (\n

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

\n )}\n

\n \n

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

\n \n

\n )}\n

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

setShowMenu(false)}\n />\n

\n \n \n Delete\n \n

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

\n {formatWeekRange()}\n

\n \n

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

\n \n \n Today\n \n

\n \n

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

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

\n {date.getDate()}\n

\n ))}\n

\n \n

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

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

\n ))}\n

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

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

\n );\n })}\n

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

\n Loading your tasks...\n

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

\n \n

Something went wrong

{error}

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

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

\n \n

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

\n );\n}\n\n",[],[154,239,273],"1856e26a-ce33-11f0-8193-42dde27851f2",5,["D",1764537929542],[184,185,186,187,188,189],[154,239],["D",1764537929135],[183,190,191,192],[154],"18e69e6e-ce33-11f0-8193-42dde27851f2","188ab342-ce33-11f0-bbbf-42dde27851f2",["D",1764537930486],[],[160,293,32],"routes","188ab28e-ce33-11f0-bbbf-42dde27851f2",7,["D",1764537929883],[181],[160,293],"18d57a3a-ce33-11f0-a53c-42dde27851f2","queries.ts","18d57ae4-ce33-11f0-a53c-42dde27851f2","186a95bc-ce33-11f0-b6b7-42dde27851f2",17,["D",1764537930372],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { EVENTS_TABLE } from \"./migrations.ts\";\nimport type { CalendarEvent } from \"../../shared/types.ts\";\n\n// Generate a unique ID\nfunction generateId(): string {\n return `evt_${Date.now()}_${Math.random().toString(36).substring(2, 9)}`;\n}\n\n// Get all events for a date range\nexport async function getEventsInRange(startDate: string, endDate: string): Promise {\n const result = await sqlite.execute(`\n SELECT id, task_id, title, description, start_time, end_time, google_event_id, color\n FROM ${EVENTS_TABLE}\n WHERE start_time >= ? AND start_time <= ?\n ORDER BY start_time ASC\n `, [startDate, endDate]);\n\n return result.rows.map(row => ({\n id: row.id as string,\n taskId: row.task_id as string | null,\n title: row.title as string,\n description: row.description as string | null,\n start: row.start_time as string,\n end: row.end_time as string,\n googleEventId: row.google_event_id as string | null,\n color: row.color as string,\n }));\n}\n\n// Get all events\nexport async function getAllEvents(): Promise {\n const result = await sqlite.execute(`\n SELECT id, task_id, title, description, start_time, end_time, google_event_id, color\n FROM ${EVENTS_TABLE}\n ORDER BY start_time ASC\n `);\n\n return result.rows.map(row => ({\n id: row.id as string,\n taskId: row.task_id as string | null,\n title: row.title as string,\n description: row.description as string | null,\n start: row.start_time as string,\n end: row.end_time as string,\n googleEventId: row.google_event_id as string | null,\n color: row.color as string,\n }));\n}\n\n// Create a new event\nexport async function createEvent(\n taskId: string | null,\n title: string,\n description: string | null,\n start: string,\n end: string,\n googleEventId: string | null,\n color: string\n): Promise {\n const id = generateId();\n\n await sqlite.execute(`\n INSERT INTO ${EVENTS_TABLE} (id, task_id, title, description, start_time, end_time, google_event_id, color)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)\n `, [id, taskId, title, description, start, end, googleEventId, color]);\n\n return {\n id,\n taskId,\n title,\n description,\n start,\n end,\n googleEventId,\n color,\n };\n}\n\n// Update an event\nexport async function updateEvent(\n id: string,\n updates: { start?: string; end?: string; title?: string; googleEventId?: string }\n): Promise {\n const setClauses: string[] = ['updated_at = CURRENT_TIMESTAMP'];\n const values: (string | null)[] = [];\n\n if (updates.start !== undefined) {\n setClauses.push('start_time = ?');\n values.push(updates.start);\n }\n if (updates.end !== undefined) {\n setClauses.push('end_time = ?');\n values.push(updates.end);\n }\n if (updates.title !== undefined) {\n setClauses.push('title = ?');\n values.push(updates.title);\n }\n if (updates.googleEventId !== undefined) {\n setClauses.push('google_event_id = ?');\n values.push(updates.googleEventId);\n }\n\n values.push(id);\n\n await sqlite.execute(`\n UPDATE ${EVENTS_TABLE}\n SET ${setClauses.join(', ')}\n WHERE id = ?\n `, values);\n\n // Fetch updated event\n const result = await sqlite.execute(`\n SELECT id, task_id, title, description, start_time, end_time, google_event_id, color\n FROM ${EVENTS_TABLE}\n WHERE id = ?\n `, [id]);\n\n if (result.rows.length === 0) return null;\n\n const row = result.rows[0];\n return {\n id: row.id as string,\n taskId: row.task_id as string | null,\n title: row.title as string,\n description: row.description as string | null,\n start: row.start_time as string,\n end: row.end_time as string,\n googleEventId: row.google_event_id as string | null,\n color: row.color as string,\n };\n}\n\n// Delete an event\nexport async function deleteEvent(id: string): Promise {\n const result = await sqlite.execute(`\n DELETE FROM ${EVENTS_TABLE}\n WHERE id = ?\n `, [id]);\n\n return result.rowsAffected > 0;\n}\n\n// Get event by ID\nexport async function getEventById(id: string): Promise {\n const result = await sqlite.execute(`\n SELECT id, task_id, title, description, start_time, end_time, google_event_id, color\n FROM ${EVENTS_TABLE}\n WHERE id = ?\n `, [id]);\n\n if (result.rows.length === 0) return null;\n\n const row = result.rows[0];\n return {\n id: row.id as string,\n taskId: row.task_id as string | null,\n title: row.title as string,\n description: row.description as string | null,\n start: row.start_time as string,\n end: row.end_time as string,\n googleEventId: row.google_event_id as string | null,\n color: row.color as string,\n };\n}\n\n",[],[160,308,300],"database","18e2c15e-ce33-11f0-a32a-42dde27851f2","migrations.ts","18e2c230-ce33-11f0-a32a-42dde27851f2",19,["D",1764537930454],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst EVENTS_TABLE = 'linear_calendar_events_v1';\n\nexport async function runMigrations() {\n // Create calendar events table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${EVENTS_TABLE} (\n id TEXT PRIMARY KEY,\n task_id TEXT,\n title TEXT NOT NULL,\n description TEXT,\n start_time TEXT NOT NULL,\n end_time TEXT NOT NULL,\n google_event_id TEXT,\n color TEXT NOT NULL DEFAULT '#3B82F6',\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Create index on task_id for faster lookups\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${EVENTS_TABLE}_task_id \n ON ${EVENTS_TABLE}(task_id)\n `);\n\n // Create index on start_time for date range queries\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${EVENTS_TABLE}_start_time \n ON ${EVENTS_TABLE}(start_time)\n `);\n\n console.log('Migrations complete');\n}\n\nexport { EVENTS_TABLE };\n\n",[],[160,308,310],"186a94fe-ce33-11f0-b6b7-42dde27851f2",["D",1764537929672],[178,179],[160,308],["D",1764537929262],[177,180],[160],["D",1764532987103],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":24},{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"ctx",{"_77":-5,"_122":361,"_362":363,"_364":365,"_366":24,"_367":24,"_368":24,"_369":57,"_370":-5,"_371":-7,"_372":-7,"_373":61,"_374":24,"_375":24,"_376":-5,"_377":24,"_378":24,"_379":24,"_380":-5},"ENV",{"_332":333,"_334":335,"_336":85,"_337":338,"_339":340,"_341":342,"_343":344,"_345":346,"_347":348,"_349":350,"_351":352,"_353":354,"_355":356,"_357":358,"_359":360},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5015b8df46402d8bba4f485ecc37aec202b0e06b","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v20