[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_204":205,"_206":207},"routes/_app.x.$handle.$name",{"_96":95,"_31":43,"_104":86,"_26":105,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":24,"_119":120,"_121":122,"_123":-5,"_124":-5,"_125":126},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_31":43,"_36":44,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":-5,"_55":24,"_56":-5,"_57":-5,"_58":59,"_60":61,"_62":63,"_64":65,"_66":67,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":24},"version",6,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":27,"_32":33,"_34":35,"_36":37,"_38":14,"_39":40,"_23":24},"previous","deleted",false,"deletedHere","path","test.ts","latestPath","fileId","9c084634-61aa-11f1-8c4e-1607ee4eb77e","name","fileType","script","content","// Test script – runs PROPFIND, PUT (create task), REPORT, DELETE against the live endpoint\nconst BASE = \"https://mluccone--051ac5f861aa11f1b3c31607ee4eb77e.web.val.run\";\nconst USER = \"admin\";\nconst PASS = \"T@sk5-2026!\";\nconst AUTH = \"Basic \" + btoa(`${USER}:${PASS}`);\nconst CAL_URL = `${BASE}/dav/calendars/${USER}/default/`;\nconst TASK_UID = \"test-task-001\";\nconst TASK_URL = `${CAL_URL}${TASK_UID}.ics`;\n\nconst results: string[] = [];\n\nfunction log(label: string, status: number, body: string) {\n const ok = status >= 200 && status < 300 || status === 207 || status === 201 || status === 204;\n results.push(`${ok ? \"✅\" : \"❌\"} ${label}: HTTP ${status}${body ? \"\\n \" + body.slice(0, 200) : \"\"}`);\n}\n\n// 1. OPTIONS\n{\n const r = await fetch(`${BASE}/dav/`, { method: \"OPTIONS\", headers: { Authorization: AUTH } });\n log(\"OPTIONS /dav/\", r.status, r.headers.get(\"DAV\") ?? \"\");\n}\n\n// 2. PROPFIND principal\n{\n const body = `

`;\n const r = await fetch(`${BASE}/dav/principals/${USER}/`, {\n method: \"PROPFIND\",\n headers: { Authorization: AUTH, \"Content-Type\": \"application/xml\", Depth: \"0\" },\n body,\n });\n const text = await r.text();\n log(\"PROPFIND principals\", r.status, text);\n}\n\n// 3. PROPFIND calendar home (Depth:1)\n{\n const body = ``;\n const r = await fetch(`${BASE}/dav/calendars/${USER}/`, {\n method: \"PROPFIND\",\n headers: { Authorization: AUTH, \"Content-Type\": \"application/xml\", Depth: \"1\" },\n body,\n });\n const text = await r.text();\n log(\"PROPFIND calendar home (Depth:1)\", r.status, text);\n}\n\n// 4. PUT – create a VTODO\n{\n const ics = [\n \"BEGIN:VCALENDAR\",\n \"VERSION:2.0\",\n \"PRODID:-//Test//Test//EN\",\n \"BEGIN:VTODO\",\n `UID:${TASK_UID}`,\n `DTSTAMP:${new Date().toISOString().replace(/[-:.]/g, \"\").slice(0,15)}Z`,\n \"SUMMARY:Testaufgabe vom CalDAV Server\",\n \"DESCRIPTION:Automatisch erstellt beim Integrationstest\",\n \"STATUS:NEEDS-ACTION\",\n \"PRIORITY:1\",\n \"DUE:20260610T120000Z\",\n \"END:VTODO\",\n \"END:VCALENDAR\",\n ].join(\"\\r\\n\");\n\n const r = await fetch(TASK_URL, {\n method: \"PUT\",\n headers: { Authorization: AUTH, \"Content-Type\": \"text/calendar; charset=utf-8\" },\n body: ics,\n });\n log(\"PUT task (create)\", r.status, r.headers.get(\"ETag\") ?? \"\");\n}\n\n// 5. GET – retrieve task\n{\n const r = await fetch(TASK_URL, { headers: { Authorization: AUTH } });\n const text = await r.text();\n log(\"GET task\", r.status, text);\n}\n\n// 6. REPORT – list all tasks\n{\n const body = `

`;\n const r = await fetch(CAL_URL, {\n method: \"REPORT\",\n headers: { Authorization: AUTH, \"Content-Type\": \"application/xml\", Depth: \"1\" },\n body,\n });\n const text = await r.text();\n log(\"REPORT calendar-query\", r.status, text);\n}\n\n// 7. PUT – update task (mark completed)\n{\n const ics = [\n \"BEGIN:VCALENDAR\",\n \"VERSION:2.0\",\n \"PRODID:-//Test//Test//EN\",\n \"BEGIN:VTODO\",\n `UID:${TASK_UID}`,\n `DTSTAMP:${new Date().toISOString().replace(/[-:.]/g, \"\").slice(0,15)}Z`,\n \"SUMMARY:Testaufgabe vom CalDAV Server\",\n \"STATUS:COMPLETED\",\n `COMPLETED:${new Date().toISOString().replace(/[-:.]/g, \"\").slice(0,15)}Z`,\n \"END:VTODO\",\n \"END:VCALENDAR\",\n ].join(\"\\r\\n\");\n\n const r = await fetch(TASK_URL, {\n method: \"PUT\",\n headers: { Authorization: AUTH, \"Content-Type\": \"text/calendar; charset=utf-8\" },\n body: ics,\n });\n log(\"PUT task (update to COMPLETED)\", r.status, r.headers.get(\"ETag\") ?? \"\");\n}\n\n// 8. DELETE task\n{\n const r = await fetch(TASK_URL, {\n method: \"DELETE\",\n headers: { Authorization: AUTH },\n });\n log(\"DELETE task\", r.status, \"\");\n}\n\n// 9. Confirm deletion\n{\n const r = await fetch(TASK_URL, { headers: { Authorization: AUTH } });\n log(\"GET after DELETE (expect 404)\", r.status, \"\");\n}\n\n// Output\nconsole.log(\"\\n=== CalDAV Integration Test ===\");\nfor (const line of results) console.log(line);\n","createdAt",["D",1780752081520],"branchVersion","branchId","afde4a9a-8e22-4cf1-96ef-17b2921f6432","id","3332e6cc-1ade-4e07-aff0-b7cc5f0a257b","caldavTasks",["D",1780751828275],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","CalDAV server for task sync (VTODO) with SQLite","imageUrl","df36cd27-0b5e-4bc7-bef3-c6d671275d45","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","aed17e9f-e407-46bc-8000-7daa4acae08a","tursoName","3332e6cc1ade4e07aff0b7cc5f0a257b","tursoHostname","3332e6cc1ade4e07aff0b7cc5f0a257b-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789471840176],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_96":95,"_103":99},"org",{"_96":95,"_97":-5,"_98":99,"_18":53,"_100":101,"_102":24},"branch",{"_13":85,"_31":86,"_41":40,"_87":42,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":43,"_94":95},"isOwned",14,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","mluccone","handle","displayName","avatar","https://images.clerk.dev/oauth_github/img_2RT8dJpHa2Xt6cZX4kE2cv19Ldh.png","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_41":42,"_31":43,"_36":199,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":-5,"_55":24,"_56":-5,"_57":-5,"_58":59,"_60":61,"_62":63,"_64":65,"_66":200,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":201,"_80":202,"_82":203,"_84":24},"tree",[178,179,180,181,182],"files",[178,179,180,181,182],"counts",{"_168":59,"_169":150,"_170":59,"_171":172,"_173":174},"contents",[127,128,129,130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_41":161,"_31":162,"_29":163,"_135":-5,"_39":40,"_38":164,"_137":122,"_36":165,"_13":59,"_32":33,"_34":166,"_23":24,"_140":-5,"_26":167},{"_41":154,"_31":155,"_29":156,"_135":-5,"_39":40,"_38":157,"_137":122,"_36":158,"_13":59,"_32":33,"_34":159,"_23":24,"_140":-5,"_26":160},{"_41":145,"_31":146,"_29":147,"_135":-5,"_39":40,"_38":148,"_137":24,"_36":149,"_13":150,"_32":151,"_34":152,"_23":24,"_140":-5,"_26":153},{"_41":142,"_31":27,"_29":30,"_135":-5,"_39":40,"_38":14,"_137":24,"_36":143,"_13":59,"_32":33,"_34":35,"_23":24,"_140":-5,"_26":144},{"_41":132,"_31":133,"_29":134,"_135":-5,"_39":40,"_38":136,"_137":122,"_36":138,"_13":59,"_32":33,"_34":139,"_23":24,"_140":-5,"_26":141},"12e88a0b-fbbe-4ec5-ba6d-68cef430e58d","xmlHelpers.ts","265d849e-61aa-11f1-94f0-1607ee4eb77e","parentId",4,"latest",["D",1780751884103],"// CalDAV XML helpers – builds well-formed WebDAV/CalDAV XML responses\n\nexport const DAV_NS = 'DAV:';\nexport const CALDAV_NS = 'urn:ietf:params:xml:ns:caldav';\nexport const CS_NS = 'http://calendarserver.org/ns/';\n\nexport function xml(...parts: string[]): string {\n return `\\r\\n` + parts.join('');\n}\n\nexport function tag(ns: string, name: string, content = '', attrs = ''): string {\n const prefix = ns === DAV_NS ? 'd' : ns === CALDAV_NS ? 'c' : 'cs';\n return `<${prefix}:${name}${attrs ? ' ' + attrs : ''}>${content}`;\n}\n\n/** Multistatus wrapper */\nexport function multistatus(responses: string[]): string {\n return xml(\n ``,\n responses.join(''),\n ``\n );\n}\n\nexport function response(href: string, propstats: string[]): string {\n return `${href}${propstats.join('')}`;\n}\n\nexport function propstat(props: string, status: string): string {\n return `${props}HTTP/1.1 ${status}`;\n}\n\n/** Parse requested prop names from PROPFIND body */\nexport function parseRequestedProps(body: string): Set {\n const props = new Set();\n // Match local names in prop elements, e.g. , \n const re = /<[^/][^>]*:([a-z\\-]+)\\s*\\/>/gi;\n let m: RegExpExecArray | null;\n while ((m = re.exec(body)) !== null) {\n props.add(m[1].toLowerCase());\n }\n // Also handle allprop\n if (body.includes('allprop')) props.add('allprop');\n return props;\n}\n","label",[133],"d9ff609e-5801-488b-91eb-50f5a2b88fb1",["D",1780752081520],[27],"4c7b13b6-379a-4bb5-83e9-0ea65a25814e","main.ts","051ac5f8-61aa-11f1-b3c3-1607ee4eb77e",5,["D",1780751951995],1,"http","import { Hono } from \"npm:hono\";\nimport { initSchema, getCalendars, getCalendar, listTasks, getTask, upsertTask, deleteTask } from \"./db.ts\";\nimport { parseVTODO, buildVTODO, computeEtag } from \"./ics.ts\";\nimport { multistatus, response, propstat, parseRequestedProps, DAV_NS, CALDAV_NS, CS_NS } from \"./xmlHelpers.ts\";\n\n// ── Init ──────────────────────────────────────────────────────────────────────\nawait initSchema();\n\nconst CALDAV_USER = Deno.env.get(\"CALDAV_USER\") ?? \"admin\";\nconst CALDAV_PASS = Deno.env.get(\"CALDAV_PASS\") ?? \"changeme\";\nconst BASE_PATH = \"/dav\";\n\n// ── Auth helper ───────────────────────────────────────────────────────────────\nfunction checkAuth(req: Request): boolean {\n const auth = req.headers.get(\"Authorization\") ?? \"\";\n if (!auth.startsWith(\"Basic \")) return false;\n const [u, p] = atob(auth.slice(6)).split(\":\");\n return u === CALDAV_USER && p === CALDAV_PASS;\n}\n\nfunction unauthorized(): Response {\n return new Response(\"Unauthorized\", {\n status: 401,\n headers: {\n \"WWW-Authenticate\": `Basic realm=\"CalDAV Tasks\"`,\n \"Content-Type\": \"text/plain\",\n },\n });\n}\n\n// ── XML content type ──────────────────────────────────────────────────────────\nconst XML_CT = \"application/xml; charset=utf-8\";\nconst ICS_CT = \"text/calendar; charset=utf-8\";\n\n// ── Hono app ──────────────────────────────────────────────────────────────────\nconst app = new Hono();\napp.onError((err) => Promise.reject(err));\n\n// Auth middleware for all /dav/* routes\napp.use(`${BASE_PATH}/*`, async (c, next) => {\n if (!checkAuth(c.req.raw)) return unauthorized();\n await next();\n});\n\n// ─────────────────────────────────────────────────────────────────────────────\n// OPTIONS – announce CalDAV capabilities\n// ─────────────────────────────────────────────────────────────────────────────\napp.options(`${BASE_PATH}/*`, (c) => {\n return new Response(null, {\n status: 200,\n headers: {\n Allow: \"OPTIONS, GET, HEAD, PUT, DELETE, PROPFIND, REPORT, MKCALENDAR\",\n DAV: \"1, 2, calendar-access\",\n \"Content-Length\": \"0\",\n },\n });\n});\n\n// ─────────────────────────────────────────────────────────────────────────────\n// GET /.well-known/caldav → redirect to principal\n// ─────────────────────────────────────────────────────────────────────────────\napp.get(\"/.well-known/caldav\", (c) => {\n return new Response(null, {\n status: 301,\n headers: { Location: `${BASE_PATH}/principals/${CALDAV_USER}/` },\n });\n});\n\n// ─────────────────────────────────────────────────────────────────────────────\n// Helper: build calendar props XML for a given calendar row\n// ─────────────────────────────────────────────────────────────────────────────\nfunction calendarProps(cal: Record, href: string): string {\n const found = [\n ``,\n `${cal.displayname}`,\n `${cal.ctag}`,\n ``,\n `${BASE_PATH}/principals/${CALDAV_USER}/`,\n ].join('');\n return response(href, [propstat(found, \"200 OK\")]);\n}\n\n// ─────────────────────────────────────────────────────────────────────────────\n// PROPFIND – principal / calendar home / calendar / task\n// ─────────────────────────────────────────────────────────────────────────────\napp.all(`${BASE_PATH}/principals/:user/`, async (c) => {\n if (c.req.method !== \"PROPFIND\") return c.text(\"Method Not Allowed\", 405);\n const user = c.req.param(\"user\");\n const calHome = `${BASE_PATH}/calendars/${user}/`;\n const props = [\n ``,\n `${user}`,\n `${calHome}`,\n `${BASE_PATH}/principals/${user}/`,\n ].join('');\n return new Response(\n `${response(`${BASE_PATH}/principals/${user}/`, [propstat(props, \"200 OK\")])}`,\n { status: 207, headers: { \"Content-Type\": XML_CT } },\n );\n});\n\n// Calendar home-set PROPFIND\napp.all(`${BASE_PATH}/calendars/:user/`, async (c) => {\n if (c.req.method !== \"PROPFIND\") return c.text(\"Method Not Allowed\", 405);\n const user = c.req.param(\"user\");\n const depth = c.req.header(\"Depth\") ?? \"0\";\n const cals = await getCalendars();\n\n const selfProps = [\n ``,\n `Calendar Home`,\n `${BASE_PATH}/calendars/${user}/`,\n ].join('');\n const responses: string[] = [\n response(`${BASE_PATH}/calendars/${user}/`, [propstat(selfProps, \"200 OK\")]),\n ];\n\n if (depth === \"1\") {\n for (const cal of cals) {\n const href = `${BASE_PATH}/calendars/${user}/${cal.id}/`;\n responses.push(calendarProps(cal as Record, href));\n }\n }\n\n return new Response(\n `${responses.join('')}`,\n { status: 207, headers: { \"Content-Type\": XML_CT } },\n );\n});\n\n// Individual calendar PROPFIND\napp.all(`${BASE_PATH}/calendars/:user/:calId/`, async (c) => {\n const method = c.req.method;\n const user = c.req.param(\"user\");\n const calId = c.req.param(\"calId\");\n\n if (method === \"MKCALENDAR\") return c.text(\"Calendar already exists\", 405);\n\n if (method === \"PROPFIND\") {\n const cal = await getCalendar(calId);\n if (!cal) return c.text(\"Not Found\", 404);\n const href = `${BASE_PATH}/calendars/${user}/${calId}/`;\n return new Response(\n `${calendarProps(cal as Record, href)}`,\n { status: 207, headers: { \"Content-Type\": XML_CT } },\n );\n }\n\n if (method === \"REPORT\") {\n const body = await c.req.text();\n const tasks = await listTasks(calId);\n const responses: string[] = [];\n\n for (const t of tasks) {\n const taskHref = `${BASE_PATH}/calendars/${user}/${calId}/${t.uid}.ics`;\n // If calendar-data is requested, return full ICS; otherwise just etag\n const wantsData = body.includes(\"calendar-data\") || body.includes(\"allprop\");\n let icsContent = t.raw_ics as string;\n // Rebuild from DB for freshness if raw_ics seems stale\n if (!icsContent || icsContent.trim() === \"\") {\n icsContent = buildVTODO(t as any);\n }\n\n const props = wantsData\n ? [\n `\"${t.etag}\"`,\n `text/calendar; charset=utf-8; component=VTODO`,\n `${escapeXml(icsContent)}`,\n ].join('')\n : `\"${t.etag}\"`;\n\n responses.push(response(taskHref, [propstat(props, \"200 OK\")]));\n }\n\n return new Response(\n `${responses.join('')}`,\n { status: 207, headers: { \"Content-Type\": XML_CT } },\n );\n }\n\n return c.text(\"Method Not Allowed\", 405);\n});\n\n// ─────────────────────────────────────────────────────────────────────────────\n// GET individual task .ics\n// ─────────────────────────────────────────────────────────────────────────────\napp.get(`${BASE_PATH}/calendars/:user/:calId/:uid{.+\\\\.ics}`, async (c) => {\n const uid = c.req.param(\"uid\").replace(/\\.ics$/, \"\");\n const task = await getTask(uid);\n if (!task) return c.text(\"Not Found\", 404);\n\n const ics = task.raw_ics as string || buildVTODO(task as any);\n return new Response(ics, {\n status: 200,\n headers: {\n \"Content-Type\": ICS_CT,\n ETag: `\"${task.etag}\"`,\n },\n });\n});\n\n// ─────────────────────────────────────────────────────────────────────────────\n// PUT – create or update task\n// ─────────────────────────────────────────────────────────────────────────────\napp.put(`${BASE_PATH}/calendars/:user/:calId/:uid{.+\\\\.ics}`, async (c) => {\n const calId = c.req.param(\"calId\");\n const uid = c.req.param(\"uid\").replace(/\\.ics$/, \"\");\n const rawIcs = await c.req.text();\n\n if (!rawIcs.includes(\"BEGIN:VTODO\")) {\n return c.text(\"Only VTODO components are supported\", 415);\n }\n\n const cal = await getCalendar(calId);\n if (!cal) return c.text(\"Calendar Not Found\", 404);\n\n const parsed = parseVTODO(rawIcs);\n const etag = await computeEtag(rawIcs);\n\n // Check If-Match for safe updates (concurrency)\n const ifMatch = c.req.header(\"If-Match\");\n if (ifMatch) {\n const existing = await getTask(uid);\n if (existing && `\"${existing.etag}\"` !== ifMatch) {\n return c.text(\"Precondition Failed\", 412);\n }\n }\n\n await upsertTask({\n uid,\n calendar_id: calId,\n etag,\n summary: parsed.summary,\n status: parsed.status,\n priority: parsed.priority,\n due: parsed.due,\n completed: parsed.completed,\n description: parsed.description,\n raw_ics: rawIcs,\n });\n\n return new Response(null, {\n status: 201,\n headers: { ETag: `\"${etag}\"` },\n });\n});\n\n// ─────────────────────────────────────────────────────────────────────────────\n// DELETE – remove task\n// ─────────────────────────────────────────────────────────────────────────────\napp.delete(`${BASE_PATH}/calendars/:user/:calId/:uid{.+\\\\.ics}`, async (c) => {\n const uid = c.req.param(\"uid\").replace(/\\.ics$/, \"\");\n\n // Optional If-Match check\n const ifMatch = c.req.header(\"If-Match\");\n if (ifMatch) {\n const existing = await getTask(uid);\n if (!existing) return c.text(\"Not Found\", 404);\n if (`\"${existing.etag}\"` !== ifMatch) return c.text(\"Precondition Failed\", 412);\n }\n\n const deleted = await deleteTask(uid);\n if (!deleted) return c.text(\"Not Found\", 404);\n return new Response(null, { status: 204 });\n});\n\n// ─────────────────────────────────────────────────────────────────────────────\n// Root PROPFIND – redirect clients that probe /\n// ─────────────────────────────────────────────────────────────────────────────\napp.all(`${BASE_PATH}/`, (c) => {\n const props = [\n `${BASE_PATH}/principals/${CALDAV_USER}/`,\n `${BASE_PATH}/calendars/${CALDAV_USER}/`,\n ].join('');\n return new Response(\n `${response(`${BASE_PATH}/`, [propstat(props, \"200 OK\")])}`,\n { status: 207, headers: { \"Content-Type\": XML_CT } },\n );\n});\n\n// ─────────────────────────────────────────────────────────────────────────────\n// Utility\n// ─────────────────────────────────────────────────────────────────────────────\nfunction escapeXml(s: string): string {\n return s\n .replace(/&/g, \"&\")\n .replace(//g, \">\");\n}\n\nexport default app.fetch;\n",[146],"fc450c52-810a-4749-b307-ab76a828b857","ics.ts","1deedb32-61aa-11f1-8f48-1607ee4eb77e",3,["D",1780751869964],"// iCalendar (RFC 5545) VTODO parser and serializer\n// No external dependency – hand-rolled for Deno compatibility\n\nexport interface TaskData {\n uid: string;\n summary: string | null;\n description: string | null;\n status: string;\n priority: number;\n due: string | null;\n completed: string | null;\n raw_ics: string;\n}\n\nfunction foldLine(line: string): string {\n // RFC 5545: fold lines at 75 chars\n const result: string[] = [];\n while (line.length > 75) {\n result.push(line.slice(0, 75));\n line = \" \" + line.slice(75);\n }\n result.push(line);\n return result.join(\"\\r\\n\");\n}\n\nfunction formatDate(d: Date): string {\n return d.toISOString().replace(/[-:]/g, \"\").replace(\".000\", \"\");\n}\n\n/** Parse a raw ICS string and extract VTODO fields */\nexport function parseVTODO(raw: string): TaskData {\n const lines: string[] = [];\n // Unfold lines (continuation lines start with SPACE or TAB)\n for (const line of raw.split(/\\r?\\n/)) {\n if ((line.startsWith(\" \") || line.startsWith(\"\\t\")) && lines.length > 0) {\n lines[lines.length - 1] += line.slice(1);\n } else {\n lines.push(line);\n }\n }\n\n const get = (name: string): string | null => {\n for (const line of lines) {\n // Match NAME or NAME;PARAM=...\n if (line.toUpperCase().startsWith(name.toUpperCase() + \":\") ||\n line.toUpperCase().startsWith(name.toUpperCase() + \";\")) {\n return line.slice(line.indexOf(\":\") + 1).trim();\n }\n }\n return null;\n };\n\n const uid = get(\"UID\") ?? crypto.randomUUID();\n const summary = get(\"SUMMARY\");\n const description = get(\"DESCRIPTION\");\n const status = get(\"STATUS\") ?? \"NEEDS-ACTION\";\n const priority = parseInt(get(\"PRIORITY\") ?? \"0\", 10) || 0;\n const due = get(\"DUE\");\n const completed = get(\"COMPLETED\");\n\n return { uid, summary, description, status, priority, due, completed, raw_ics: raw };\n}\n\n/** Build a minimal VTODO ICS block from DB fields */\nexport function buildVTODO(task: {\n uid: string;\n summary: string | null;\n description: string | null;\n status: string;\n priority: number;\n due: string | null;\n completed: string | null;\n created_at: string;\n updated_at: string;\n}): string {\n const now = formatDate(new Date());\n const lines: string[] = [\n \"BEGIN:VCALENDAR\",\n \"VERSION:2.0\",\n \"PRODID:-//caldavTasks//Val.Town//EN\",\n \"BEGIN:VTODO\",\n `UID:${task.uid}`,\n `DTSTAMP:${now}`,\n `CREATED:${task.created_at.replace(/[-: ]/g, \"\").slice(0, 15)}Z`,\n `LAST-MODIFIED:${task.updated_at.replace(/[-: ]/g, \"\").slice(0, 15)}Z`,\n `STATUS:${task.status}`,\n `PRIORITY:${task.priority}`,\n ];\n if (task.summary) lines.push(foldLine(`SUMMARY:${task.summary}`));\n if (task.description) lines.push(foldLine(`DESCRIPTION:${task.description}`));\n if (task.due) lines.push(`DUE:${task.due}`);\n if (task.completed) lines.push(`COMPLETED:${task.completed}`);\n lines.push(\"END:VTODO\", \"END:VCALENDAR\");\n return lines.join(\"\\r\\n\");\n}\n\n/** Compute a simple ETag from the raw ICS content */\nexport async function computeEtag(raw: string): Promise {\n const buf = await crypto.subtle.digest(\n \"SHA-1\",\n new TextEncoder().encode(raw),\n );\n return Array.from(new Uint8Array(buf))\n .map((b) => b.toString(16).padStart(2, \"0\"))\n .join(\"\");\n}\n",[155],"fb91d580-a65f-447f-8f1b-1d881a48a711","db.ts","11e9db3e-61aa-11f1-9ae4-1607ee4eb77e",2,["D",1780751849789],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function initSchema() {\n await sqlite.batch([\n {\n sql: `CREATE TABLE IF NOT EXISTS calendars (\n id TEXT PRIMARY KEY,\n displayname TEXT NOT NULL,\n color TEXT DEFAULT '#0082C9',\n ctag TEXT NOT NULL,\n components TEXT DEFAULT 'VTODO'\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS tasks (\n uid TEXT PRIMARY KEY,\n calendar_id TEXT NOT NULL,\n etag TEXT NOT NULL,\n summary TEXT,\n status TEXT DEFAULT 'NEEDS-ACTION',\n priority INTEGER DEFAULT 0,\n due TEXT,\n completed TEXT,\n description TEXT,\n raw_ics TEXT NOT NULL,\n created_at TEXT DEFAULT (datetime('now')),\n updated_at TEXT DEFAULT (datetime('now')),\n FOREIGN KEY (calendar_id) REFERENCES calendars(id)\n )`,\n },\n {\n sql: `INSERT OR IGNORE INTO calendars (id, displayname, ctag) VALUES (?, ?, ?)`,\n args: [\"default\", \"Tasks\", crypto.randomUUID()],\n },\n ]);\n}\n\nexport async function getCalendars() {\n const res = await sqlite.execute(\"SELECT * FROM calendars\");\n return res.rows;\n}\n\nexport async function getCalendar(id: string) {\n const res = await sqlite.execute({\n sql: \"SELECT * FROM calendars WHERE id = ?\",\n args: [id],\n });\n return res.rows[0] ?? null;\n}\n\nexport async function bumpCtag(calendarId: string) {\n await sqlite.execute({\n sql: \"UPDATE calendars SET ctag = ? WHERE id = ?\",\n args: [crypto.randomUUID(), calendarId],\n });\n}\n\nexport async function listTasks(calendarId: string) {\n const res = await sqlite.execute({\n sql: \"SELECT * FROM tasks WHERE calendar_id = ?\",\n args: [calendarId],\n });\n return res.rows;\n}\n\nexport async function getTask(uid: string) {\n const res = await sqlite.execute({\n sql: \"SELECT * FROM tasks WHERE uid = ?\",\n args: [uid],\n });\n return res.rows[0] ?? null;\n}\n\nexport async function upsertTask(task: {\n uid: string;\n calendar_id: string;\n etag: string;\n summary: string | null;\n status: string;\n priority: number;\n due: string | null;\n completed: string | null;\n description: string | null;\n raw_ics: string;\n}) {\n await sqlite.execute({\n sql: `INSERT INTO tasks (uid, calendar_id, etag, summary, status, priority, due, completed, description, raw_ics, updated_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, datetime('now'))\n ON CONFLICT(uid) DO UPDATE SET\n calendar_id = excluded.calendar_id,\n etag = excluded.etag,\n summary = excluded.summary,\n status = excluded.status,\n priority = excluded.priority,\n due = excluded.due,\n completed = excluded.completed,\n description = excluded.description,\n raw_ics = excluded.raw_ics,\n updated_at = datetime('now')`,\n args: [\n task.uid,\n task.calendar_id,\n task.etag,\n task.summary,\n task.status,\n task.priority,\n task.due,\n task.completed,\n task.description,\n task.raw_ics,\n ],\n });\n await bumpCtag(task.calendar_id);\n}\n\nexport async function deleteTask(uid: string) {\n const task = await getTask(uid);\n if (!task) return false;\n await sqlite.execute({\n sql: \"DELETE FROM tasks WHERE uid = ?\",\n args: [uid],\n });\n await bumpCtag(task.calendar_id as string);\n return true;\n}\n",[162],"pulls","branches","forks","envVars",{"_175":164,"_177":59},"connections",{"_175":59,"_176":59},"count","unfilledCount","emptyCount",{"_41":161,"_31":162,"_29":163,"_135":-5,"_39":40,"_38":164,"_137":122,"_36":196,"_13":59,"_32":33,"_34":166,"_23":24,"_140":-5,"_184":197,"_26":198},{"_41":154,"_31":155,"_29":156,"_135":-5,"_39":40,"_38":157,"_137":122,"_36":193,"_13":59,"_32":33,"_34":159,"_23":24,"_140":-5,"_184":194,"_26":195},{"_41":145,"_31":146,"_29":147,"_135":-5,"_39":40,"_38":148,"_137":24,"_36":190,"_13":150,"_32":151,"_34":152,"_23":24,"_140":-5,"_184":191,"_26":192},{"_41":142,"_31":27,"_29":30,"_135":-5,"_39":40,"_38":14,"_137":24,"_36":187,"_13":59,"_32":33,"_34":35,"_23":24,"_140":-5,"_184":188,"_26":189},{"_41":132,"_31":133,"_29":134,"_135":-5,"_39":40,"_38":136,"_137":122,"_36":183,"_13":59,"_32":33,"_34":139,"_23":24,"_140":-5,"_184":185,"_26":186},["D",1780751884103],"children",[],[133],["D",1780752081520],[],[27],["D",1780751951995],[],[146],["D",1780751869964],[],[155],["D",1780751849789],[],[162],["D",1780751828275],["D",1789471840176],{"_96":95,"_103":99},{"_96":95,"_97":-5,"_98":99,"_18":53,"_100":101,"_102":24},{"_13":85,"_31":86,"_41":40,"_87":42,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":43,"_94":95},"ctx",{"_78":-5,"_124":237,"_238":239,"_240":241,"_242":24,"_243":24,"_244":24,"_245":122,"_246":-5,"_247":-7,"_248":-7,"_249":59,"_250":24,"_251":24,"_252":-5,"_253":24,"_254":24,"_255":24,"_256":-5},"ENV",{"_208":209,"_210":211,"_212":86,"_213":214,"_215":216,"_217":218,"_219":220,"_221":222,"_223":224,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234,"_235":236},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v6