[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_185":186,"_187":188},"routes/_app.x.$handle.$name",{"_100":99,"_33":46,"_109":90,"_28":110,"_13":14,"_111":-5,"_11":112,"_113":114,"_115":116,"_117":118,"_119":120,"_20":-5,"_121":-5,"_122":-5,"_123":27,"_124":125,"_126":25,"_127":-5,"_128":-5,"_129":130},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_33":46,"_39":47,"_48":-5,"_49":27,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":25,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":27},"version",83,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":27,"_28":29,"_30":29},"file",{"_31":32,"_33":29,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":27},"previous",{"_31":32,"_33":29,"_34":35,"_36":37},"deleted",true,"deletedHere",false,"path","savvycal-cleaner.ts","latestPath","fileId","3362045c-8113-11f1-9a89-1607ee4eb77e","name","fileType","interval","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst TARGET_TEXT = \"Component Test\";\n\nasync function refreshAccessToken(clientId: string, clientSecret: string, tenantId: string, refreshToken: string) {\n const res = await fetch(`https://login.microsoftonline.com/${tenantId}/oauth2/v2.0/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 grant_type: \"refresh_token\",\n refresh_token: refreshToken,\n }),\n });\n if (!res.ok) {\n throw new Error(`Token refresh failed: ${await res.text()}`);\n }\n return await res.json();\n}\n\nasync function getValidToken(clientId: string, clientSecret: string, tenantId: string) {\n const res = await sqlite.execute(\"SELECT access_token, refresh_token, expires_at, id FROM gatekeeper_auth ORDER BY expires_at DESC LIMIT 1\");\n if (!res.rows || res.rows.length === 0) return null;\n \n const row = res.rows[0];\n const accessToken = Array.isArray(row) ? row[0] : row.access_token;\n const refreshToken = Array.isArray(row) ? row[1] : row.refresh_token;\n const expiresAt = Array.isArray(row) ? row[2] : row.expires_at;\n const id = Array.isArray(row) ? row[3] : row.id;\n\n if (Date.now() < Number(expiresAt)) return accessToken;\n\n if (refreshToken) {\n const fresh = await refreshAccessToken(clientId, clientSecret, tenantId, String(refreshToken));\n const newExpiresAt = Date.now() + fresh.expires_in * 1000;\n await sqlite.execute({\n sql: \"UPDATE gatekeeper_auth SET access_token = ?, expires_at = ? WHERE id = ?\",\n args: [fresh.access_token, newExpiresAt, id],\n });\n return fresh.access_token;\n }\n return null;\n}\n\nasync function graphRequest(token: string, endpoint: string, method = \"GET\", body?: any) {\n const options: any = {\n method,\n headers: {\n Authorization: `Bearer ${token}`,\n \"Content-Type\": \"application/json\",\n },\n };\n if (body) options.body = JSON.stringify(body);\n const res = await fetch(`https://graph.microsoft.com/v1.0${endpoint}`, options);\n if (!res.ok && res.status !== 204) {\n console.error(`Graph request to ${endpoint} failed (${res.status}): ${await res.text()}`);\n return null;\n }\n return res.status === 204 ? true : await res.json();\n}\n\nfunction matchesTarget(text: string | null | undefined): boolean {\n if (!text) return false;\n return text.toLowerCase().includes(TARGET_TEXT.toLowerCase());\n}\n\nexport default async function(interval: Interval) {\n const clientId = Deno.env.get(\"MICROSOFT_CLIENT_ID\");\n const clientSecret = Deno.env.get(\"MICROSOFT_CLIENT_SECRET\");\n const tenantId = Deno.env.get(\"MICROSOFT_TENANT_ID\") || \"common\";\n\n if (!clientId || !clientSecret) {\n return \"ERROR: Missing environment variables inside project.\";\n }\n\n const token = await getValidToken(clientId, clientSecret, tenantId).catch(e => {\n console.error(\"Token retrieval failed:\", e);\n return null;\n });\n \n if (!token) {\n return \"ERROR: No valid token found in project SQLite.\";\n }\n\n console.log(\"Searching for 'Component Test' calendar events (case-insensitive, including body)...\");\n // Select both subject and body content\n const events = await graphRequest(token, `/me/events?$select=id,subject,body&$top=100`);\n let eventsProcessed = 0;\n if (events?.value) {\n for (const event of events.value) {\n if (matchesTarget(event.subject) || matchesTarget(event.body?.content)) {\n console.log(`Canceling event: ${event.subject} (ID: ${event.id})`);\n const success = await graphRequest(token, `/me/events/${event.id}`, \"DELETE\");\n if (success) eventsProcessed++;\n }\n }\n }\n\n console.log(\"Searching for 'Component Test' emails (case-insensitive, including body)...\");\n // Search covers subject and body. We fetch subject and bodyPreview for the local check.\n const emails = await graphRequest(token, `/me/messages?$search=\"${TARGET_TEXT}\"&$select=id,subject,bodyPreview`);\n let emailsProcessed = 0;\n if (emails?.value) {\n for (const email of emails.value) {\n if (matchesTarget(email.subject) || matchesTarget(email.bodyPreview)) {\n console.log(`Deleting email: ${email.subject} (ID: ${email.id})`);\n const success = await graphRequest(token, `/me/messages/${email.id}`, \"DELETE\");\n if (success) emailsProcessed++;\n }\n }\n }\n \n return `Cleaned up ${eventsProcessed} events and ${emailsProcessed} emails.`;\n}\n","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst TARGET_TEXT = \"Component Test\";\n\nasync function refreshAccessToken(clientId: string, clientSecret: string, tenantId: string, refreshToken: string) {\n const res = await fetch(`https://login.microsoftonline.com/${tenantId}/oauth2/v2.0/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 grant_type: \"refresh_token\",\n refresh_token: refreshToken,\n }),\n });\n if (!res.ok) {\n throw new Error(`Token refresh failed: ${await res.text()}`);\n }\n return await res.json();\n}\n\nasync function getValidToken(clientId: string, clientSecret: string, tenantId: string) {\n const res = await sqlite.execute(\"SELECT access_token, refresh_token, expires_at, id, user_email FROM gatekeeper_auth ORDER BY expires_at DESC LIMIT 1\");\n if (!res.rows || res.rows.length === 0) return null;\n \n const row = res.rows[0];\n const accessToken = Array.isArray(row) ? row[0] : row.access_token;\n const refreshToken = Array.isArray(row) ? row[1] : row.refresh_token;\n const expiresAt = Array.isArray(row) ? row[2] : row.expires_at;\n const id = Array.isArray(row) ? row[3] : row.id;\n const userEmail = Array.isArray(row) ? row[4] : row.user_email;\n\n if (Date.now() < Number(expiresAt)) return { token: accessToken, userEmail };\n\n if (refreshToken) {\n const fresh = await refreshAccessToken(clientId, clientSecret, tenantId, String(refreshToken));\n const newExpiresAt = Date.now() + fresh.expires_in * 1000;\n await sqlite.execute({\n sql: \"UPDATE gatekeeper_auth SET access_token = ?, expires_at = ? WHERE id = ?\",\n args: [fresh.access_token, newExpiresAt, id],\n });\n return { token: fresh.access_token, userEmail };\n }\n return null;\n}\n\nasync function graphRequest(token: string, endpoint: string, method = \"GET\", body?: any) {\n const options: any = {\n method,\n headers: {\n Authorization: `Bearer ${token}`,\n \"Content-Type\": \"application/json\",\n },\n };\n if (body) options.body = JSON.stringify(body);\n const res = await fetch(`https://graph.microsoft.com/v1.0${endpoint}`, options);\n if (!res.ok && res.status !== 204) {\n console.error(`Graph request to ${endpoint} failed (${res.status}): ${await res.text()}`);\n return null;\n }\n return res.status === 204 ? true : await res.json();\n}\n\nfunction matchesTarget(text: string | null | undefined): boolean {\n if (!text) return false;\n return text.toLowerCase().includes(TARGET_TEXT.toLowerCase());\n}\n\nexport default async function(interval: Interval) {\n const clientId = Deno.env.get(\"MICROSOFT_CLIENT_ID\");\n const clientSecret = Deno.env.get(\"MICROSOFT_CLIENT_SECRET\");\n const tenantId = Deno.env.get(\"MICROSOFT_TENANT_ID\") || \"common\";\n\n if (!clientId || !clientSecret) {\n return \"ERROR: Missing environment variables inside project.\";\n }\n\n const auth = await getValidToken(clientId, clientSecret, tenantId).catch(e => {\n console.error(\"Token retrieval failed:\", e);\n return null;\n });\n \n if (!auth) {\n return \"ERROR: No valid token found in project SQLite.\";\n }\n\n const { token, userEmail } = auth;\n\n console.log(\"Searching for 'Component Test' calendar events (case-insensitive, including body)...\");\n const events = await graphRequest(token, `/me/events?$select=id,subject,body&$top=100`);\n let eventsProcessed = 0;\n if (events?.value) {\n for (const event of events.value) {\n if (matchesTarget(event.subject) || matchesTarget(event.body?.content)) {\n console.log(`Canceling event: ${event.subject} (ID: ${event.id})`);\n const success = await graphRequest(token, `/me/events/${event.id}`, \"DELETE\");\n if (success) eventsProcessed++;\n }\n }\n }\n\n console.log(\"Searching for 'Component Test' emails (case-insensitive, including body)...\");\n const emails = await graphRequest(token, `/me/messages?$search=\"${TARGET_TEXT}\"&$select=id,subject,bodyPreview`);\n let emailsProcessed = 0;\n if (emails?.value) {\n for (const email of emails.value) {\n if (matchesTarget(email.subject) || matchesTarget(email.bodyPreview)) {\n console.log(`Deleting email: ${email.subject} (ID: ${email.id})`);\n const success = await graphRequest(token, `/me/messages/${email.id}`, \"DELETE\");\n if (success) emailsProcessed++;\n }\n }\n }\n \n const summary = `Cleaned up ${eventsProcessed} events and ${emailsProcessed} emails.`;\n const now = new Date().toISOString();\n \n await sqlite.execute({\n sql: `\n INSERT INTO gatekeeper_settings (user_email, key, value) VALUES (?, ?, ?)\n ON CONFLICT(user_email, key) DO UPDATE SET value = excluded.value`,\n args: [userEmail, \"last_savvycal_cleanup_at\", now],\n });\n await sqlite.execute({\n sql: `\n INSERT INTO gatekeeper_settings (user_email, key, value) VALUES (?, ?, ?)\n ON CONFLICT(user_email, key) DO UPDATE SET value = excluded.value`,\n args: [userEmail, \"last_savvycal_cleanup_summary\", summary],\n });\n\n return summary;\n}\n","createdAt",["D",1784213638131],"branchVersion","branchId","2c2cae38-1b17-4cec-8428-dc29fefdecf9","id","99532b3b-b077-420b-9e87-b34e8ac5ac8d","outlook_gatekeeper",["D",1783440688481],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Outlook Gatekeeper Fresh: Direct Graph Auth + SQLite + Hono UI","imageUrl","4415b31e-7137-48dd-a702-ba6ff1d9bd0b","pinnedFileId","82aef5c0-7a1e-11f1-af67-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019ef236-fc96-74eb-95f7-9a47681ead32","tursoName","99532b3bb077420b9e87b34e8ac5ac8d","tursoHostname","99532b3bb077420b9e87b34e8ac5ac8d-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789521640046],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_108":104},"org",{"_100":99,"_101":102,"_103":104,"_18":56,"_105":106,"_107":27},"branch",{"_13":89,"_33":90,"_44":43,"_91":45,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":46,"_98":99},"isOwned",111,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","raskin","handle","displayName","Perry Raskin","avatar","https://avatars.githubusercontent.com/u/17967465?v=4","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_33":46,"_39":180,"_48":-5,"_49":27,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":25,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":181,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":182,"_84":183,"_86":184,"_88":27},"tree",[167,168,169],"files",[167,168,169],"counts",{"_156":63,"_157":158,"_159":63,"_160":161,"_162":163},"contents",[131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":148,"_33":149,"_31":58,"_137":-5,"_42":43,"_41":150,"_139":27,"_39":151,"_13":152,"_34":153,"_36":154,"_24":27,"_142":-5,"_28":155},{"_44":144,"_33":29,"_31":32,"_137":-5,"_42":43,"_41":14,"_139":27,"_39":145,"_13":146,"_34":35,"_36":38,"_24":27,"_142":-5,"_28":147},{"_44":134,"_33":135,"_31":136,"_137":-5,"_42":43,"_41":138,"_139":25,"_39":140,"_13":63,"_34":35,"_36":141,"_24":27,"_142":-5,"_28":143},"3a5753b1-5259-4b3a-8978-a6fce27d03dd","scheduled-sync.ts","8182b71c-7a2e-11f1-a324-1607ee4eb77e","parentId",69,"latest",["D",1783447558411],"import { scheduledSyncTick } from \"./main.ts\";\n\nexport default async function(interval: Interval) {\n const result = await scheduledSyncTick(interval);\n console.log(JSON.stringify(result));\n}\n","label",[135],"e6889243-078d-4472-9a3b-98aa3b41e067",["D",1784213638131],7,[29],"f43afd60-2b28-43b1-8dbf-f64a608e3d12","main.ts",82,["D",1784213614899],73,"http","import { Hono } from \"npm:hono\";\nimport { getCookie, setCookie, deleteCookie } from \"npm:hono/cookie\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst app = new Hono();\n\n// --- CONFIGURATION ---\nconst getEnv = (name) => Deno.env.get(name);\nconst TENANT_ID = getEnv(\"MICROSOFT_TENANT_ID\") || \"common\";\nconst CLIENT_ID = getEnv(\"MICROSOFT_CLIENT_ID\");\nconst CLIENT_SECRET = getEnv(\"MICROSOFT_CLIENT_SECRET\");\nconst OPENAI_API_KEY = getEnv(\"OPENAI_API_KEY\");\nconst OPENAI_MODEL = getEnv(\"OPENAI_MODEL\") || \"gpt-4o\";\nconst NYC_TIME_ZONE = \"America/New_York\";\nconst SYNC_DAYS_BACK = 7;\nconst SYNC_DAYS_FORWARD = 7;\n\nconst SESSION_COOKIE = \"gatekeeper_session\";\nconst OAUTH_STATE_COOKIE = \"gatekeeper_oauth_state\";\nconst SESSION_MAX_AGE_SECONDS = 60 * 60 * 24 * 30;\n\nconst ALLOWED_EMAILS = (getEnv(\"ALLOWED_EMAILS\") || \"perry.raskin@coverdash.com\")\n .split(\",\")\n .map((email) => email.trim().toLowerCase())\n .filter(Boolean);\n\nfunction normalizeUserEmail(email) {\n return String(email || \"\").trim().toLowerCase();\n}\n\nfunction defaultUserEmail() {\n return ALLOWED_EMAILS[0] || \"unknown\";\n}\n\nasync function tableColumns(tableName) {\n const res = await sqlite.execute(`PRAGMA table_info(${tableName})`);\n return (res.rows || []).map((row) => String(Array.isArray(row) ? row[1] : row.name));\n}\n\nasync function scopedStorageUserEmail() {\n const res = await sqlite.execute(\"SELECT user_email FROM gatekeeper_auth WHERE user_email IS NOT NULL AND user_email != '' ORDER BY expires_at DESC LIMIT 1\");\n if (res.rows && res.rows.length > 0) {\n const row = res.rows[0];\n const email = normalizeUserEmail(Array.isArray(row) ? row[0] : row.user_email);\n if (email)\n return email;\n }\n return defaultUserEmail();\n}\n\n// --- DATABASE SETUP ---\nasync function ensureTables() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS gatekeeper_auth (\n id TEXT PRIMARY KEY,\n access_token TEXT,\n refresh_token TEXT,\n expires_at INTEGER,\n user_email TEXT\n )\n `);\n\n const migrationEmail = await scopedStorageUserEmail();\n \n const auditColumns = await tableColumns(\"gatekeeper_audit\");\n if (auditColumns.length === 0) {\n await sqlite.execute(`\n CREATE TABLE gatekeeper_audit (\n id TEXT PRIMARY KEY,\n user_email TEXT NOT NULL,\n event_id TEXT NOT NULL,\n subject TEXT,\n decision TEXT,\n reasoning TEXT,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n }\n\n const rulesColumns = await tableColumns(\"gatekeeper_rules\");\n if (rulesColumns.length === 0) {\n await sqlite.execute(`\n CREATE TABLE gatekeeper_rules (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_email TEXT NOT NULL,\n pattern TEXT NOT NULL,\n type TEXT DEFAULT 'mute',\n UNIQUE(user_email, pattern)\n )\n `);\n }\n\n const settingsColumns = await tableColumns(\"gatekeeper_settings\");\n if (settingsColumns.length === 0) {\n await sqlite.execute(`\n CREATE TABLE gatekeeper_settings (\n user_email TEXT NOT NULL,\n key TEXT NOT NULL,\n value TEXT,\n PRIMARY KEY(user_email, key)\n )\n `);\n }\n \n await ensureUserSettings(migrationEmail);\n}\n\n// --- DISPLAY HELPERS ---\nfunction escapeHtml(value) {\n return String(value ?? \"\")\n .replaceAll(\"&\", \"&\")\n .replaceAll(\"<\", \"<\")\n .replaceAll(\">\", \">\")\n .replaceAll('\"', \""\")\n .replaceAll(\"'\", \"'\");\n}\n\nfunction formatNycEventTime(value) {\n const raw = String(value ?? \"\");\n if (!raw)\n return \"Unknown\";\n const date = new Date(raw);\n if (Number.isNaN(date.getTime()))\n return escapeHtml(raw);\n return new Intl.DateTimeFormat(\"en-US\", {\n timeZone: NYC_TIME_ZONE,\n year: \"numeric\",\n month: \"numeric\",\n day: \"numeric\",\n hour: \"numeric\",\n minute: \"2-digit\",\n timeZoneName: \"short\",\n }).format(date);\n}\n\nfunction displayDecision(value) {\n const decision = String(value ?? \"\").toLowerCase();\n if (decision === \"noise\" || decision === \"muted\") {\n return { className: \"decision-muted\", label: \"Alerts off\" };\n }\n return { className: \"decision-kept\", label: \"Kept\" };\n}\n\nfunction displayReason(value) {\n const reason = String(value ?? \"\");\n if (reason === \"Actionable by default\")\n return \"No alert rule matched; left unchanged\";\n if (reason === \"User manual rule match\")\n return \"Matched a rule; turned alerts off\";\n return reason\n .replaceAll(\"should be muted\", \"should have alerts turned off\")\n || \"No reason recorded\";\n}\n\n// --- OAUTH HELPERS ---\nfunction newToken() {\n return crypto.randomUUID();\n}\n\nfunction isAllowedEmail(email) {\n return ALLOWED_EMAILS.length === 0 || ALLOWED_EMAILS.includes(String(email || \"\").toLowerCase());\n}\n\nasync function refreshAccessToken(refreshToken) {\n const res = await fetch(`https://login.microsoftonline.com/${TENANT_ID}/oauth2/v2.0/token`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/x-www-form-urlencoded\" },\n body: new URLSearchParams({\n client_id: CLIENT_ID,\n client_secret: CLIENT_SECRET,\n grant_type: \"refresh_token\",\n refresh_token: refreshToken,\n }),\n });\n if (!res.ok) {\n throw new Error(`Failed to refresh token: ${await res.text()}`);\n }\n return await res.json();\n}\n\nasync function getStoredAuth(c) {\n const sessionId = getCookie(c, SESSION_COOKIE);\n if (!sessionId)\n return null;\n const res = await sqlite.execute({\n sql: \"SELECT * FROM gatekeeper_auth WHERE id = ? LIMIT 1\",\n args: [sessionId],\n });\n if (!res.rows || res.rows.length === 0)\n return null;\n const row = res.rows[0];\n const auth = {\n id: (Array.isArray(row) ? row[0] : row.id),\n access_token: (Array.isArray(row) ? row[1] : row.access_token),\n refresh_token: (Array.isArray(row) ? row[2] : row.refresh_token),\n expires_at: (Array.isArray(row) ? row[3] : row.expires_at),\n user_email: normalizeUserEmail(Array.isArray(row) ? row[4] : row.user_email),\n };\n if (!isAllowedEmail(auth.user_email))\n return null;\n return auth;\n}\n\nasync function getValidToken(c) {\n const auth = await getStoredAuth(c);\n if (!auth)\n return null;\n if (Date.now() < auth.expires_at) {\n return auth.access_token;\n }\n if (auth.refresh_token) {\n const fresh = await refreshAccessToken(auth.refresh_token);\n const expiresAt = Date.now() + fresh.expires_in * 1000;\n await sqlite.execute({\n sql: \"UPDATE gatekeeper_auth SET access_token = ?, expires_at = ? WHERE id = ?\",\n args: [fresh.access_token, expiresAt, auth.id],\n });\n return fresh.access_token;\n }\n return null;\n}\n\nconst SCHEDULE_OPTIONS = [\n { minutes: 1, label: \"Every minute\" },\n { minutes: 5, label: \"Every 5 minutes\" },\n { minutes: 15, label: \"Every 15 minutes\" },\n { minutes: 30, label: \"Every 30 minutes\" },\n { minutes: 60, label: \"Hourly\" },\n];\n\nfunction normalizeScheduleMinutes(value) {\n const numeric = Number(value);\n return SCHEDULE_OPTIONS.some((option) => option.minutes === numeric) ? numeric : 60;\n}\n\nfunction rowToAuth(row) {\n return {\n id: (Array.isArray(row) ? row[0] : row.id),\n access_token: (Array.isArray(row) ? row[1] : row.access_token),\n refresh_token: (Array.isArray(row) ? row[2] : row.refresh_token),\n expires_at: Number(Array.isArray(row) ? row[3] : row.expires_at),\n user_email: normalizeUserEmail(Array.isArray(row) ? row[4] : row.user_email),\n };\n}\n\nasync function ensureUserSettings(userEmail) {\n const scopedUser = normalizeUserEmail(userEmail) || defaultUserEmail();\n for (const [key, value] of [\n [\"schedule_enabled\", \"false\"],\n [\"schedule_interval_minutes\", \"60\"],\n [\"last_scheduled_sync_at\", \"\"],\n [\"last_scheduled_sync_summary\", \"Not run yet\"],\n [\"last_savvycal_cleanup_at\", \"\"],\n [\"last_savvycal_cleanup_summary\", \"Not run yet\"],\n ]) {\n await sqlite.execute({\n sql: \"INSERT OR IGNORE INTO gatekeeper_settings (user_email, key, value) VALUES (?, ?, ?)\",\n args: [scopedUser, key, value],\n });\n }\n}\n\nasync function getSetting(userEmail, key, fallback = \"\") {\n const scopedUser = normalizeUserEmail(userEmail) || defaultUserEmail();\n const res = await sqlite.execute({\n sql: \"SELECT value FROM gatekeeper_settings WHERE user_email = ? AND key = ? LIMIT 1\",\n args: [scopedUser, key],\n });\n if (!res.rows || res.rows.length === 0)\n return fallback;\n const row = res.rows[0];\n return String(Array.isArray(row) ? row[0] : row.value ?? fallback);\n}\n\nasync function setSetting(userEmail, key, value) {\n const scopedUser = normalizeUserEmail(userEmail) || defaultUserEmail();\n await sqlite.execute({\n sql: `\n INSERT INTO gatekeeper_settings (user_email, key, value) VALUES (?, ?, ?)\n ON CONFLICT(user_email, key) DO UPDATE SET value = excluded.value`,\n args: [scopedUser, key, String(value)],\n });\n}\n\nfunction formatNycDateTime(value) {\n if (!value)\n return \"Not run yet\";\n const date = new Date(value);\n if (Number.isNaN(date.getTime()))\n return String(value);\n return new Intl.DateTimeFormat(\"en-US\", {\n month: \"numeric\",\n day: \"numeric\",\n year: \"numeric\",\n hour: \"numeric\",\n minute: \"2-digit\",\n timeZone: NYC_TIME_ZONE,\n timeZoneName: \"short\",\n }).format(date);\n}\n\n// --- APP ROUTES ---\n\napp.get(\"/\", async (c) => {\n await ensureTables();\n const auth = await getStoredAuth(c);\n if (!auth) {\n return c.html(`\n \n \n \n Outlook Gatekeeper\n \n \n \n \n

Outlook Gatekeeper

Mute alerts for personal calendar events automatically.

\n
\n Login with Microsoft\n

\n \n \n `);\n }\n\n const rules = await sqlite.execute({\n sql: \"SELECT * FROM gatekeeper_rules WHERE user_email = ? ORDER BY pattern ASC\",\n args: [auth.user_email],\n });\n const audits = await sqlite.execute({\n sql: \"SELECT * FROM gatekeeper_audit WHERE user_email = ? ORDER BY timestamp DESC LIMIT 50\",\n args: [auth.user_email],\n });\n\n const syncEnabled = (await getSetting(auth.user_email, \"schedule_enabled\", \"false\")) === \"true\";\n const lastSyncAt = await getSetting(auth.user_email, \"last_scheduled_sync_at\", \"\");\n const lastSyncSummary = await getSetting(auth.user_email, \"last_scheduled_sync_summary\", \"Not run yet\");\n \n const lastSavvycalAt = await getSetting(auth.user_email, \"last_savvycal_cleanup_at\", \"\");\n const lastSavvycalSummary = await getSetting(auth.user_email, \"last_savvycal_cleanup_summary\", \"Not run yet\");\n\n return c.html(`\n \n \n \n Outlook Gatekeeper\n \n \n \n \n

Outlook Gatekeeper

\n Logged in as ${escapeHtml(auth.user_email)}\n Logout\n

\n\n

Automations

\n \n

\n Outlook Gatekeeper\n

\n Latest Run\n

${escapeHtml(lastSyncSummary)}

${formatNycDateTime(lastSyncAt)}

\n\n

\n SavvyCal Cleaner\n

\n Latest Run\n

${escapeHtml(lastSavvycalSummary)}

${formatNycDateTime(lastSavvycalAt)}

\n\n

Alert Rules

Mute alerts for events containing these strings:

\n ${rules.rows.map((rule) => `\n

\n ${escapeHtml(Array.isArray(rule) ? rule[2] : rule.pattern)}\n ×\n

\n `).join(\"\")}\n

\n \n

\n\n

Recent Activity

\n \n \n \n \n \n \n \n \n \n ${audits.rows.map((audit) => {\n const decision = displayDecision(Array.isArray(audit) ? audit[4] : audit.decision);\n return `\n \n \n \n \n \n `;\n }).join(\"\")}\n ${audits.rows.length === 0 ? '' : \"\"}\n \n

Time	Event	Action
${formatNycDateTime(Array.isArray(audit) ? audit[6] : audit.timestamp)}	\n ${escapeHtml(Array.isArray(audit) ? audit[3] : audit.subject)} \n ${displayReason(Array.isArray(audit) ? audit[5] : audit.reasoning)} \n	${decision.label}
No activity recorded yet.

\n \n \n `);\n});\n\napp.get(\"/login\", (c) => {\n const state = newToken();\n setOAuthStateCookie(c, state);\n const params = new URLSearchParams({\n client_id: CLIENT_ID,\n response_type: \"code\",\n redirect_uri: getRedirectUri(c),\n response_mode: \"query\",\n scope: \"openid profile email offline_access https://graph.microsoft.com/Calendars.ReadWrite https://graph.microsoft.com/Mail.ReadWrite\",\n state,\n });\n return c.redirect(`https://login.microsoftonline.com/${TENANT_ID}/oauth2/v2.0/authorize?${params.toString()}`);\n});\n\napp.get(\"/callback\", async (c) => {\n const code = c.req.query(\"code\");\n const state = c.req.query(\"state\");\n const savedState = getCookie(c, OAUTH_STATE_COOKIE);\n clearOAuthStateCookie(c);\n if (!code || state !== savedState) {\n return c.text(\"Invalid login state or missing code\", 400);\n }\n const tokenRes = await fetch(`https://login.microsoftonline.com/${TENANT_ID}/oauth2/v2.0/token`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/x-www-form-urlencoded\" },\n body: new URLSearchParams({\n client_id: CLIENT_ID,\n client_secret: CLIENT_SECRET,\n grant_type: \"authorization_code\",\n code,\n redirect_uri: getRedirectUri(c),\n }),\n });\n if (!tokenRes.ok) {\n return c.text(`Token exchange failed: ${await tokenRes.text()}`, 500);\n }\n const tokenData = await tokenRes.json();\n const userRes = await fetch(\"https://graph.microsoft.com/v1.0/me\", {\n headers: { Authorization: `Bearer ${tokenData.access_token}` },\n });\n const userData = await userRes.json();\n const userEmail = normalizeUserEmail(userData.mail || userData.userPrincipalName);\n if (!isAllowedEmail(userEmail)) {\n return c.text(`Access denied for ${userEmail}`, 403);\n }\n const sessionId = newToken();\n const expiresAt = Date.now() + tokenData.expires_in * 1000;\n await sqlite.execute({\n sql: \"INSERT INTO gatekeeper_auth (id, access_token, refresh_token, expires_at, user_email) VALUES (?, ?, ?, ?, ?)\",\n args: [sessionId, tokenData.access_token, tokenData.refresh_token, expiresAt, userEmail],\n });\n setSessionCookie(c, sessionId);\n return c.redirect(\"/\");\n});\n\napp.get(\"/logout\", async (c) => {\n const sessionId = getCookie(c, SESSION_COOKIE);\n if (sessionId) {\n await sqlite.execute({\n sql: \"DELETE FROM gatekeeper_auth WHERE id = ?\",\n args: [sessionId],\n });\n }\n clearSessionCookie(c);\n return c.redirect(\"/\");\n});\n\napp.post(\"/rules/add\", async (c) => {\n const auth = await getStoredAuth(c);\n if (!auth)\n return c.redirect(\"/\");\n const body = await c.req.parseBody();\n const pattern = String(body.pattern || \"\").trim();\n if (pattern) {\n await sqlite.execute({\n sql: \"INSERT OR IGNORE INTO gatekeeper_rules (user_email, pattern) VALUES (?, ?)\",\n args: [auth.user_email, pattern],\n });\n }\n return c.redirect(\"/\");\n});\n\napp.get(\"/rules/delete\", async (c) => {\n const auth = await getStoredAuth(c);\n if (!auth)\n return c.redirect(\"/\");\n const id = c.req.query(\"id\");\n if (id) {\n await sqlite.execute({\n sql: \"DELETE FROM gatekeeper_rules WHERE id = ? AND user_email = ?\",\n args: [id, auth.user_email],\n });\n }\n return c.redirect(\"/\");\n});\n\nexport default app.fetch;\n\n// --- TICK LOGIC ---\nexport async function scheduledSyncTick(interval) {\n await ensureTables();\n const auth = await getLatestAuth();\n if (!auth)\n return { success: false, reason: \"No authorized users found\" };\n \n // Stub for sync logic\n const summary = \"Manual sync logic skipped for now.\";\n const now = new Date().toISOString();\n await setSetting(auth.user_email, \"last_scheduled_sync_at\", now);\n await setSetting(auth.user_email, \"last_scheduled_sync_summary\", summary);\n return { success: true, summary, at: now };\n}\n\nasync function getLatestAuth() {\n const res = await sqlite.execute(\"SELECT * FROM gatekeeper_auth ORDER BY expires_at DESC LIMIT 1\");\n if (!res.rows || res.rows.length === 0)\n return null;\n return rowToAuth(res.rows[0]);\n}\n",[149],"pulls","branches",1,"forks","envVars",{"_164":146,"_166":63},"connections",{"_164":63,"_165":63},"count","unfilledCount","emptyCount",{"_44":148,"_33":149,"_31":58,"_137":-5,"_42":43,"_41":150,"_139":27,"_39":177,"_13":152,"_34":153,"_36":154,"_24":27,"_142":-5,"_171":178,"_28":179},{"_44":144,"_33":29,"_31":32,"_137":-5,"_42":43,"_41":14,"_139":27,"_39":174,"_13":146,"_34":35,"_36":38,"_24":27,"_142":-5,"_171":175,"_28":176},{"_44":134,"_33":135,"_31":136,"_137":-5,"_42":43,"_41":138,"_139":25,"_39":170,"_13":63,"_34":35,"_36":141,"_24":27,"_142":-5,"_171":172,"_28":173},["D",1783447558411],"children",[],[135],["D",1784213638131],[],[29],["D",1784213614899],[],[149],["D",1783440688481],["D",1789521640046],{"_100":99,"_108":104},{"_100":99,"_101":102,"_103":104,"_18":56,"_105":106,"_107":27},{"_13":89,"_33":90,"_44":43,"_91":45,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":46,"_98":99},"ctx",{"_82":-5,"_128":218,"_219":220,"_221":222,"_223":27,"_224":27,"_225":27,"_226":25,"_227":-5,"_228":-7,"_229":-7,"_230":63,"_231":27,"_232":27,"_233":-5,"_234":27,"_235":27,"_236":27,"_237":-5},"ENV",{"_189":190,"_191":192,"_193":90,"_194":195,"_196":197,"_198":199,"_200":201,"_202":203,"_204":205,"_206":207,"_208":209,"_210":211,"_212":213,"_214":215,"_216":217},"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 · v83