[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_158":159,"_160":161},"routes/_app.x.$handle.$name",{"_98":97,"_32":45,"_107":88,"_27":53,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":25,"_121":122,"_123":25,"_124":-5,"_125":-5,"_126":127},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":25},"version",3,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":37,"_35":36,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","7c7a132a-996c-11f1-9378-1607ee4eb77e","name","fileType","script","content","/**\n * Notion <-> Todoist sync for Val Town\n * ------------------------------------\n * Deploy as a \"Cron\" val on Val Town (e.g. every 10 minutes), with a\n * `export default async function` entry point (Val Town calls this\n * automatically on the schedule).\n *\n * REQUIRED VAL TOWN ENVIRONMENT VARIABLES (Settings -> Environment Variables):\n * NOTION_TOKEN - Notion internal integration token\n * TODOIST_TOKEN - Todoist personal API token\n * NOTION_UNI_DB_ID - \"Uni Dashboard\" database ID\n * NOTION_MYTASKS_DB_ID - \"My Tasks\" database ID (see setup notes below)\n *\n * OPTIONAL:\n * DRY_RUN=true - logs actions instead of writing anything (use this first!)\n *\n * ---------------------------------------------------------------------------\n * REQUIRED NOTION SETUP (do this once, manually, in Notion):\n *\n * 1. Create an internal integration at https://www.notion.so/my-integrations,\n * copy its token into NOTION_TOKEN, then in each database below click\n * \"...\" -> \"Connections\" -> add your integration.\n *\n * 2. No new properties needed on \"Uni Dashboard\" — the link between a\n * Notion page and its Todoist task is tracked entirely in this script's\n * own SQLite table, not in a Notion property.\n *\n * 3. Create a brand-new database called \"My Tasks\" with these properties:\n * - Name (Title) <- already exists by default\n * - Project (Text) <- Todoist project name for non-uni tasks\n * - Due (Date)\n * - Done (Checkbox)\n *\n * 4. Grab both database IDs from their share URLs (the 32-char id right\n * after notion.so/ and before the ?v=) and set NOTION_UNI_DB_ID /\n * NOTION_MYTASKS_DB_ID.\n *\n * ---------------------------------------------------------------------------\n * FIRST RUN WARNING:\n * On the very first run, every existing matching Notion row and every\n * existing Todoist task outside your 4 unit projects will get synced across\n * at once (there's no history yet). Set DRY_RUN=true first and check the\n * logs so nothing gets duplicated unexpectedly, then flip it off.\n */\n\nimport sqlite from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// ---------- Config ----------\n\nconst NOTION_TOKEN = Deno.env.get(\"NOTION_TOKEN\")!;\nconst TODOIST_TOKEN = Deno.env.get(\"TODOIST_TOKEN\")!;\nconst NOTION_UNI_DB_ID = Deno.env.get(\"NOTION_UNI_DB_ID\")!;\nconst NOTION_MYTASKS_DB_ID = Deno.env.get(\"NOTION_MYTASKS_DB_ID\")!;\nconst DRY_RUN = (Deno.env.get(\"DRY_RUN\") ?? \"false\").toLowerCase() === \"true\";\n\nconst UNI_PROJECTS = [\"ICT374\", \"ICT302\", \"ICT303\", \"MAS354\"];\nconst UNI_TYPES = [\"Lab\", \"Assignment\"];\nconst UNI_ACTIVE_STATUSES = [\"Not Started\", \"In Progress\"];\n\nconst NOTION_API = \"https://api.notion.com/v1\";\nconst NOTION_VERSION = \"2022-06-28\";\nconst TODOIST_API = \"https://api.todoist.com/api/v1\";\n\nfunction log(...args: unknown[]) {\n console.log(DRY_RUN ? \"[DRY RUN]\" : \"[LIVE]\", ...args);\n}\n\n// ---------- SQLite link table ----------\n\nasync function ensureTable() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS task_links (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n kind TEXT NOT NULL, -- 'uni' | 'general'\n notion_page_id TEXT UNIQUE,\n todoist_task_id TEXT,\n done INTEGER DEFAULT 0\n )\n `);\n}\n\nasync function findLinkByNotionId(notionPageId: string) {\n const r = await sqlite.execute(\n `SELECT * FROM task_links WHERE notion_page_id = ?`,\n [notionPageId],\n );\n return r.rows[0] ?? null;\n}\n\nasync function findLinkByTodoistId(todoistTaskId: string) {\n const r = await sqlite.execute(\n `SELECT * FROM task_links WHERE todoist_task_id = ?`,\n [todoistTaskId],\n );\n return r.rows[0] ?? null;\n}\n\nasync function insertLink(\n kind: string,\n notionPageId: string,\n todoistTaskId: string,\n) {\n if (DRY_RUN) return;\n await sqlite.execute(\n `INSERT INTO task_links (kind, notion_page_id, todoist_task_id) VALUES (?, ?, ?)`,\n [kind, notionPageId, todoistTaskId],\n );\n}\n\nasync function markDone(notionPageId: string) {\n if (DRY_RUN) return;\n await sqlite.execute(\n `UPDATE task_links SET done = 1 WHERE notion_page_id = ?`,\n [notionPageId],\n );\n}\n\nasync function allLinks(kind: string, doneFlag: number) {\n const r = await sqlite.execute(\n `SELECT * FROM task_links WHERE kind = ? AND done = ?`,\n [kind, doneFlag],\n );\n return r.rows;\n}\n\n// ---------- Notion helpers ----------\n\nasync function notionRequest(path: string, method: string, body?: unknown) {\n const res = await fetch(`${NOTION_API}${path}`, {\n method,\n headers: {\n Authorization: `Bearer ${NOTION_TOKEN}`,\n \"Notion-Version\": NOTION_VERSION,\n \"Content-Type\": \"application/json\",\n },\n body: body ? JSON.stringify(body) : undefined,\n });\n if (!res.ok) {\n const text = await res.text();\n throw new Error(`Notion ${method} ${path} failed: ${res.status} ${text}`);\n }\n return res.json();\n}\n\nasync function notionQueryAll(dbId: string, filter?: unknown) {\n const results: any[] = [];\n let cursor: string | undefined;\n do {\n const body: any = { page_size: 100 };\n if (filter) body.filter = filter;\n if (cursor) body.start_cursor = cursor;\n const data = await notionRequest(`/databases/${dbId}/query`, \"POST\", body);\n results.push(...data.results);\n cursor = data.has_more ? data.next_cursor : undefined;\n } while (cursor);\n return results;\n}\n\nasync function notionGetSchema(dbId: string) {\n const data = await notionRequest(`/databases/${dbId}`, \"GET\");\n const types: Record = {};\n for (const [name, prop] of Object.entries(data.properties)) {\n types[name] = prop.type;\n }\n return types;\n}\n\nfunction statusPropValue(schemaTypes: Record, value: string) {\n return schemaTypes[\"Status\"] === \"status\"\n ? { status: { name: value } }\n : { select: { name: value } };\n}\n\nfunction readStatus(page: any): string | null {\n const p = page.properties?.Status;\n return p?.status?.name ?? p?.select?.name ?? null;\n}\n\nfunction readTitle(page: any, prop = \"Name\"): string {\n const t = page.properties?.[prop]?.title;\n return t?.map((x: any) => x.plain_text).join(\"\") ?? \"\";\n}\n\nfunction readSelect(page: any, prop: string): string | null {\n return page.properties?.[prop]?.select?.name ?? null;\n}\n\nfunction readRichText(page: any, prop: string): string {\n const t = page.properties?.[prop]?.rich_text;\n return t?.map((x: any) => x.plain_text).join(\"\") ?? \"\";\n}\n\nfunction readDate(page: any, prop: string): string | null {\n return page.properties?.[prop]?.date?.start ?? null;\n}\n\nfunction readCheckbox(page: any, prop: string): boolean {\n return page.properties?.[prop]?.checkbox ?? false;\n}\n\nasync function notionCreatePage(dbId: string, properties: unknown) {\n return notionRequest(`/pages`, \"POST\", {\n parent: { database_id: dbId },\n properties,\n });\n}\n\nasync function notionUpdatePage(pageId: string, properties: unknown) {\n return notionRequest(`/pages/${pageId}`, \"PATCH\", { properties });\n}\n\n// ---------- Todoist helpers ----------\n\nasync function todoistRequest(path: string, method: string, body?: unknown) {\n const res = await fetch(`${TODOIST_API}${path}`, {\n method,\n headers: {\n Authorization: `Bearer ${TODOIST_TOKEN}`,\n \"Content-Type\": \"application/json\",\n },\n body: body ? JSON.stringify(body) : undefined,\n });\n if (res.status === 404) return null;\n if (!res.ok) {\n const text = await res.text();\n throw new Error(`Todoist ${method} ${path} failed: ${res.status} ${text}`);\n }\n if (res.status === 204) return {};\n return res.json();\n}\n\n// Handles both flat-array and {results, next_cursor} response shapes\nasync function todoistGetAllTasks(projectId?: string) {\n const tasks: any[] = [];\n let cursor: string | null = null;\n do {\n const params = new URLSearchParams();\n if (projectId) params.set(\"project_id\", projectId);\n if (cursor) params.set(\"cursor\", cursor);\n const data = await todoistRequest(`/tasks?${params.toString()}`, \"GET\");\n if (Array.isArray(data)) {\n tasks.push(...data);\n cursor = null;\n } else {\n tasks.push(...(data?.results ?? []));\n cursor = data?.next_cursor ?? null;\n }\n } while (cursor);\n return tasks;\n}\n\nasync function todoistGetProjects() {\n const data = await todoistRequest(`/projects`, \"GET\");\n return Array.isArray(data) ? data : data?.results ?? [];\n}\n\nasync function todoistCreateProject(name: string) {\n if (DRY_RUN) {\n log(`Would create Todoist project \"${name}\"`);\n return { id: `dry-${name}`, name };\n }\n return todoistRequest(`/projects`, \"POST\", { name });\n}\n\nasync function todoistCreateTask(\n opts: { content: string; project_id?: string; due_date?: string },\n) {\n if (DRY_RUN) {\n log(\n `Would create Todoist task \"${opts.content}\" (project ${\n opts.project_id ?? \"Inbox\"\n }, due ${opts.due_date ?? \"none\"})`,\n );\n return { id: `dry-${Date.now()}-${Math.random()}` };\n }\n return todoistRequest(`/tasks`, \"POST\", opts);\n}\n\nasync function todoistGetTask(id: string) {\n return todoistRequest(`/tasks/${id}`, \"GET\");\n}\n\nasync function todoistCloseTask(id: string) {\n if (DRY_RUN) {\n log(`Would close Todoist task ${id}`);\n return;\n }\n return todoistRequest(`/tasks/${id}/close`, \"POST\");\n}\n\n// ---------- Sync steps ----------\n\nasync function step1_uniDashboardToTodoist(\n uniSchema: Record,\n projectMap: Map,\n) {\n const pages = await notionQueryAll(NOTION_UNI_DB_ID, {\n and: [\n {\n or: UNI_TYPES.map((t) => ({ property: \"Type\", select: { equals: t } })),\n },\n {\n or: UNI_ACTIVE_STATUSES.map((s) => ({\n property: \"Status\",\n [uniSchema[\"Status\"] === \"status\" ? \"status\" : \"select\"]: {\n equals: s,\n },\n })),\n },\n ],\n });\n\n for (const page of pages) {\n const existing = await findLinkByNotionId(page.id);\n if (existing) continue;\n\n const unit = readSelect(page, \"Unit\");\n const name = readTitle(page, \"Name\");\n const due = readDate(page, \"Due\");\n if (!unit || !UNI_PROJECTS.includes(unit)) continue;\n\n let projectId = projectMap.get(unit);\n if (!projectId) {\n const proj = await todoistCreateProject(unit);\n projectId = proj.id;\n projectMap.set(unit, projectId);\n }\n\n log(`Creating Todoist task \"${name}\" in project ${unit}`);\n const task = await todoistCreateTask({\n content: name,\n project_id: projectId,\n due_date: due ? due.slice(0, 10) : undefined,\n });\n await insertLink(\"uni\", page.id, String(task.id));\n }\n}\n\nasync function step2_todoistCompletionToUni(uniSchema: Record) {\n const links = await allLinks(\"uni\", 0);\n for (const link of links) {\n const task = await todoistGetTask(String(link.todoist_task_id));\n if (task === null) {\n // 404 => completed or deleted\n log(\n `Todoist task ${link.todoist_task_id} no longer active -> marking Notion Done`,\n );\n if (!DRY_RUN) {\n await notionUpdatePage(String(link.notion_page_id), {\n Status: statusPropValue(uniSchema, \"Done\"),\n });\n }\n await markDone(String(link.notion_page_id));\n }\n }\n}\n\nasync function step2b_notionDoneToTodoistClose() {\n const links = await allLinks(\"uni\", 0);\n for (const link of links) {\n const page = await notionRequest(`/pages/${link.notion_page_id}`, \"GET\");\n if (readStatus(page) === \"Done\") {\n log(\n `Notion page ${link.notion_page_id} marked Done -> closing Todoist task`,\n );\n await todoistCloseTask(String(link.todoist_task_id));\n await markDone(String(link.notion_page_id));\n }\n }\n}\n\nasync function step3_todoistGeneralToMyTasks(projectMap: Map) {\n const uniProjectIds = new Set(projectMap.values());\n const allTasks = await todoistGetAllTasks();\n const idToName = new Map();\n for (const [name, id] of projectMap.entries()) idToName.set(id, name);\n\n // also need names for non-uni projects\n const allProjects = await todoistGetProjects();\n for (const p of allProjects) idToName.set(p.id, p.name);\n\n for (const task of allTasks) {\n if (uniProjectIds.has(task.project_id)) continue; // handled by uni flow\n const existing = await findLinkByTodoistId(String(task.id));\n if (existing) continue;\n\n const projectName = idToName.get(task.project_id) ?? \"Inbox\";\n log(\n `Creating Notion \"My Tasks\" page for Todoist task \"${task.content}\" (${projectName})`,\n );\n let page: any = { id: `dry-${Date.now()}` };\n if (!DRY_RUN) {\n page = await notionCreatePage(NOTION_MYTASKS_DB_ID, {\n Name: { title: [{ text: { content: task.content } }] },\n Project: { rich_text: [{ text: { content: projectName } }] },\n Due: task.due?.date ? { date: { start: task.due.date } } : undefined,\n });\n }\n await insertLink(\"general\", page.id, String(task.id));\n }\n}\n\nasync function step4_myTasksToTodoist() {\n const pages = await notionQueryAll(NOTION_MYTASKS_DB_ID);\n for (const page of pages) {\n const existing = await findLinkByNotionId(page.id);\n if (existing) continue;\n\n const name = readTitle(page, \"Name\");\n const due = readDate(page, \"Due\");\n if (!name) continue;\n\n log(`Creating Todoist task \"${name}\" (from Notion My Tasks)`);\n const task = await todoistCreateTask({\n content: name,\n due_date: due ? due.slice(0, 10) : undefined,\n });\n await insertLink(\"general\", page.id, String(task.id));\n }\n}\n\nasync function step5_completionSyncGeneral() {\n // Todoist completed -> Notion Done\n const links = await allLinks(\"general\", 0);\n for (const link of links) {\n const task = await todoistGetTask(String(link.todoist_task_id));\n if (task === null) {\n log(\n `Todoist task ${link.todoist_task_id} completed -> marking My Tasks Done`,\n );\n if (!DRY_RUN) {\n await notionUpdatePage(String(link.notion_page_id), {\n Done: { checkbox: true },\n });\n }\n await markDone(String(link.notion_page_id));\n }\n }\n\n // Notion Done -> Todoist close\n const stillOpen = await allLinks(\"general\", 0);\n for (const link of stillOpen) {\n const page = await notionRequest(`/pages/${link.notion_page_id}`, \"GET\");\n if (readCheckbox(page, \"Done\")) {\n log(\n `My Tasks page ${link.notion_page_id} checked Done -> closing Todoist task`,\n );\n await todoistCloseTask(String(link.todoist_task_id));\n await markDone(String(link.notion_page_id));\n }\n }\n}\n\n// ---------- Main ----------\n\nexport default async function () {\n await ensureTable();\n\n const uniSchema = await notionGetSchema(NOTION_UNI_DB_ID);\n\n const todoistProjects = await todoistGetProjects();\n const projectMap = new Map();\n for (const p of todoistProjects) {\n if (UNI_PROJECTS.includes(p.name)) projectMap.set(p.name, p.id);\n }\n\n await step1_uniDashboardToTodoist(uniSchema, projectMap);\n await step2_todoistCompletionToUni(uniSchema);\n await step2b_notionDoneToTodoistClose();\n await step3_todoistGeneralToMyTasks(projectMap);\n await step4_myTasksToTodoist();\n await step5_completionSyncGeneral();\n\n log(\"Sync run complete.\");\n return new Response(\"ok\");\n}","interval","createdAt",["D",1786883073887],"branchVersion","branchId","535318ea-e5a3-4eda-a97e-8922da260256","id","bb9c118c-d752-4acf-85fe-331906fb455c","tdoist-notion-sync",["D",1786882664876],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","645ca711-f209-417f-accc-5cf8b2a045b1","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019f78c3-8166-77fe-8684-0f67874fd4db","tursoName","bb9c118cd7524acf85fe331906fb455c","tursoHostname","bb9c118cd7524acf85fe331906fb455c-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789571433983],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_106":102},"org",{"_98":97,"_99":100,"_101":102,"_18":55,"_103":104,"_105":25},"branch",{"_13":87,"_32":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"isOwned",7,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","tillyj","handle","displayName","Tilly J","avatar","https://lh3.googleusercontent.com/a/ACg8ocIXYLopRRQYZDDDcYXIGf49Ws5-I7kUObN4Akg8IzFETxmXNw=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":153,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":154,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":155,"_82":156,"_84":157,"_86":25},"tree",[148],"files",[148],"counts",{"_136":61,"_137":138,"_139":61,"_140":141,"_142":143},"contents",[128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":129,"_32":28,"_30":31,"_130":-5,"_41":42,"_40":14,"_131":25,"_38":132,"_13":133,"_33":37,"_35":36,"_24":25,"_134":-5,"_27":135},"3153ef98-b465-4810-9b49-e81d44c43d8f","parentId","latest",["D",1786883073887],2,"label",[28],"pulls","branches",1,"forks","envVars",{"_144":146,"_147":61},"connections",{"_144":61,"_145":61},"count","unfilledCount",5,"emptyCount",{"_43":129,"_32":28,"_30":31,"_130":-5,"_41":42,"_40":14,"_131":25,"_38":149,"_13":133,"_33":37,"_35":36,"_24":25,"_134":-5,"_150":151,"_27":152},["D",1786883073887],"children",[],[28],["D",1786882664876],["D",1789571433983],{"_98":97,"_106":102},{"_98":97,"_99":100,"_101":102,"_18":55,"_103":104,"_105":25},{"_13":87,"_32":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"ctx",{"_80":-5,"_125":191,"_192":193,"_194":195,"_196":25,"_197":25,"_198":25,"_199":200,"_201":-5,"_202":-7,"_203":-7,"_204":61,"_205":25,"_206":25,"_207":-5,"_208":25,"_209":25,"_210":25,"_211":-5},"ENV",{"_162":163,"_164":165,"_166":88,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","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",true,"preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v3