[{"_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,"_32":45,"_109":90,"_27":104,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_20":-5,"_120":-5,"_121":-5,"_122":25,"_123":124,"_125":59,"_126":-5,"_127":-5,"_128":129},"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":57,"_58":59,"_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":25},"version",30,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","assign-teams.tsx","latestPath","fileId","21597b3e-6ac3-11f1-8cd3-1607ee4eb77e","name","fileType","http","content","// One-off: add a \"Team\" select property to the roster and assign each row.\n// Gated behind FIX_KEY. Dry run by default; send header x-apply: true to write.\n// Delete this file when done.\n\nconst NOTION_TOKEN = Deno.env.get(\"NOTION_TOKEN\");\nconst FIX_KEY = Deno.env.get(\"FIX_KEY\");\nconst NOTION_VERSION = \"2025-09-03\";\nconst ONLINE_DS = \"9f3e6237-4908-4bf9-b64f-6f7e13cce320\"; // roster data source\n\nconst TEAMS = [\"Team 1\", \"Team 2\", \"Team 3\", \"Team 4\", \"Team 5\", \"Team 6\"];\nconst TEAM_COLORS: Record = {\n \"Team 1\": \"blue\",\n \"Team 2\": \"green\",\n \"Team 3\": \"orange\",\n \"Team 4\": \"pink\",\n \"Team 5\": \"purple\",\n \"Team 6\": \"yellow\",\n};\n\n// Read from the attached team sheet, matched to the full names in the roster.\nconst MAPPING: Record = {\n \"Team 1\": [\"Ibrahim Afzal\", \"Jack Signorelli\", \"Nikhil Venkatesh\", \"Amogh Patil\", \"Ishaan Dutta\"],\n \"Team 2\": [\"Sunjana Devraj\", \"Ananya Avadhuta\", \"Gökçe Nur Güzel\", \"Angelina Radziyevska\", \"Jake Mckeegan\"],\n \"Team 3\": [\"Wilbur Chen\", \"Ahmet Selim Şen\", \"Daniella Bayagbona\", \"Dilvin Lacin\", \"Yelda Naz Usal\"],\n \"Team 4\": [\"Jane Huang\", \"Kexuan Chen\", \"Angelina Williams\", \"Vreni Raina\"],\n \"Team 5\": [\"Kellan Stapleton\", \"Ethan Lo\", \"Ishan Venkatesh\", \"Jehoo Lee\"],\n \"Team 6\": [\"Aditya Garg\", \"Ved Guttikonda\", \"Vittesh Taneja\", \"Richa Kurup\"],\n};\n\nconst norm = (s: string) => (s || \"\").trim().toLocaleLowerCase().replace(/\\s+/g, \" \");\n\nconst NAME_TO_TEAM: Record = {};\nfor (const [team, names] of Object.entries(MAPPING)) {\n for (const n of names) NAME_TO_TEAM[norm(n)] = team;\n}\n\nfunction notion(path: string, method: string, body?: unknown) {\n return fetch(`https://api.notion.com/v1/${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}\n\nfunction plain(prop: any): string {\n const items = prop?.title ?? prop?.rich_text ?? [];\n return items.map((p: any) => p?.plain_text ?? \"\").join(\"\").trim();\n}\n\nasync function fetchAll(): Promise {\n const rows: any[] = [];\n let cursor: string | undefined;\n do {\n const body: any = { page_size: 100 };\n if (cursor) body.start_cursor = cursor;\n const r = await notion(`data_sources/${ONLINE_DS}/query`, \"POST\", body);\n const j = await r.json();\n if (!r.ok) throw new Error(\"query failed: \" + JSON.stringify(j));\n rows.push(...(j.results ?? []));\n cursor = j.has_more ? j.next_cursor : undefined;\n } while (cursor);\n return rows;\n}\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const key = req.headers.get(\"x-fix-key\") ?? url.searchParams.get(\"key\");\n if (!FIX_KEY || key !== FIX_KEY) return new Response(\"unauthorized\", { status: 401 });\n if (!NOTION_TOKEN) {\n return new Response(JSON.stringify({ ok: false, error: \"missing NOTION_TOKEN\" }, null, 2),\n { status: 200, headers: { \"Content-Type\": \"application/json\" } });\n }\n const apply = req.headers.get(\"x-apply\") === \"true\" || url.searchParams.get(\"apply\") === \"true\";\n\n let rows: any[];\n try {\n rows = await fetchAll();\n } catch (e) {\n return new Response(JSON.stringify({ ok: false, error: String(e) }, null, 2),\n { status: 200, headers: { \"Content-Type\": \"application/json\" } });\n }\n\n const planned: any[] = [];\n const unassigned: any[] = [];\n const seen = new Set();\n for (const page of rows) {\n const title = plain(page.properties?.[\"Notion Page\"]);\n const currentTeam = page.properties?.[\"Team\"]?.select?.name ?? null;\n const team = NAME_TO_TEAM[norm(title)];\n if (team) { planned.push({ id: page.id, name: title, team, currentTeam }); seen.add(norm(title)); }\n else unassigned.push({ id: page.id, name: title, currentTeam });\n }\n const alreadyCorrect = planned.filter((c) => c.currentTeam === c.team).length;\n const missingFromDB = Object.keys(NAME_TO_TEAM)\n .filter((n) => !seen.has(n))\n .map((n) => ({ name: n, team: NAME_TO_TEAM[n] }));\n\n const perTeam: Record = {};\n for (const c of planned) perTeam[c.team] = (perTeam[c.team] || 0) + 1;\n\n let propertyResult: any = \"skipped (dry run)\";\n let assigned = 0;\n const errors: any[] = [];\n\n if (apply) {\n const pr = await notion(`data_sources/${ONLINE_DS}`, \"PATCH\", {\n properties: { Team: { select: { options: TEAMS.map((t) => ({ name: t, color: TEAM_COLORS[t] })) } } },\n });\n propertyResult = pr.ok ? \"ok\" : await pr.json();\n if (pr.ok) {\n for (const c of planned) {\n const res = await notion(`pages/${c.id}`, \"PATCH\", {\n properties: { Team: { select: { name: c.team } } },\n });\n if (res.ok) assigned++;\n else errors.push({ id: c.id, name: c.name, error: await res.json() });\n await new Promise((r) => setTimeout(r, 150));\n }\n }\n }\n\n return new Response(JSON.stringify({\n mode: apply ? \"APPLIED\" : \"DRY RUN\",\n totalRows: rows.length,\n toAssign: planned.length,\n perTeam,\n unassigned,\n missingFromDB,\n propertyResult,\n assigned,\n errors,\n planned,\n }, null, 2), { status: 200, headers: { \"Content-Type\": \"application/json\" } });\n}\n","// One-off: add a \"Team\" select property to the roster and assign each row.\n// Gated behind FIX_KEY. Dry run by default; send header x-apply: true to write.\n// Delete this file when done.\n\nconst NOTION_TOKEN = Deno.env.get(\"NOTION_TOKEN\");\nconst FIX_KEY = Deno.env.get(\"FIX_KEY\");\nconst NOTION_VERSION = \"2025-09-03\";\nconst ONLINE_DS = \"9f3e6237-4908-4bf9-b64f-6f7e13cce320\"; // roster data source\n\nconst TEAMS = [\"Team 1\", \"Team 2\", \"Team 3\", \"Team 4\", \"Team 5\", \"Team 6\"];\nconst TEAM_COLORS: Record = {\n \"Team 1\": \"blue\",\n \"Team 2\": \"green\",\n \"Team 3\": \"orange\",\n \"Team 4\": \"pink\",\n \"Team 5\": \"purple\",\n \"Team 6\": \"yellow\",\n};\n\n// Read from the attached team sheet, matched to the full names in the roster.\nconst MAPPING: Record = {\n \"Team 1\": [\"Ibrahim Afzal\", \"Jack Signorelli\", \"Nikhil Venkatesh\", \"Amogh Patil\", \"Ishaan Dutta\"],\n \"Team 2\": [\"Sunjana Devraj\", \"Ananya Avadhuta\", \"Gökçe Nur Güzel\", \"Angelina Radziyevska\", \"Jake Mckeegan\"],\n \"Team 3\": [\"Wilbur Chen\", \"Ahmet Selim Şen\", \"Daniella Bayagbona\", \"Dilvin Lacin\", \"Yelda Naz Usal\"],\n \"Team 4\": [\"Jane Huang\", \"Kexuan Chen\", \"Angelina Williams\", \"Vreni Raina\"],\n \"Team 5\": [\"Kellan Stapleton\", \"Ethan Lo\", \"Ishan Venkatesh\", \"Jehoo Lee\"],\n \"Team 6\": [\"Aditya Garg\", \"Ved Guttikonda\", \"Vittesh Taneja\", \"Richa Kurup\"],\n};\n\nconst norm = (s: string) => (s || \"\").trim().toLocaleLowerCase().replace(/\\s+/g, \" \");\n\nconst NAME_TO_TEAM: Record = {};\nfor (const [team, names] of Object.entries(MAPPING)) {\n for (const n of names) NAME_TO_TEAM[norm(n)] = team;\n}\n\nfunction notion(path: string, method: string, body?: unknown) {\n return fetch(`https://api.notion.com/v1/${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}\n\nfunction plain(prop: any): string {\n const items = prop?.title ?? prop?.rich_text ?? [];\n return items.map((p: any) => p?.plain_text ?? \"\").join(\"\").trim();\n}\n\nasync function fetchAll(): Promise {\n const rows: any[] = [];\n let cursor: string | undefined;\n do {\n const body: any = { page_size: 100 };\n if (cursor) body.start_cursor = cursor;\n const r = await notion(`data_sources/${ONLINE_DS}/query`, \"POST\", body);\n const j = await r.json();\n if (!r.ok) throw new Error(\"query failed: \" + JSON.stringify(j));\n rows.push(...(j.results ?? []));\n cursor = j.has_more ? j.next_cursor : undefined;\n } while (cursor);\n return rows;\n}\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const key = req.headers.get(\"x-fix-key\") ?? url.searchParams.get(\"key\");\n if (!FIX_KEY || key !== FIX_KEY) return new Response(\"unauthorized\", { status: 401 });\n if (!NOTION_TOKEN) {\n return new Response(JSON.stringify({ ok: false, error: \"missing NOTION_TOKEN\" }, null, 2),\n { status: 200, headers: { \"Content-Type\": \"application/json\" } });\n }\n const apply = req.headers.get(\"x-apply\") === \"true\" || url.searchParams.get(\"apply\") === \"true\";\n\n let rows: any[];\n try {\n rows = await fetchAll();\n } catch (e) {\n return new Response(JSON.stringify({ ok: false, error: String(e) }, null, 2),\n { status: 200, headers: { \"Content-Type\": \"application/json\" } });\n }\n\n const planned: any[] = [];\n const unassigned: any[] = [];\n const seen = new Set();\n for (const page of rows) {\n const title = plain(page.properties?.[\"Notion Page\"]);\n const currentTeam = page.properties?.[\"Team\"]?.select?.name ?? null;\n const team = NAME_TO_TEAM[norm(title)];\n if (team) { planned.push({ id: page.id, name: title, team, currentTeam }); seen.add(norm(title)); }\n else unassigned.push({ id: page.id, name: title, currentTeam });\n }\n const alreadyCorrect = planned.filter((c) => c.currentTeam === c.team).length;\n const missingFromDB = Object.keys(NAME_TO_TEAM)\n .filter((n) => !seen.has(n))\n .map((n) => ({ name: n, team: NAME_TO_TEAM[n] }));\n\n const perTeam: Record = {};\n for (const c of planned) perTeam[c.team] = (perTeam[c.team] || 0) + 1;\n\n let propertyResult: any = \"skipped (dry run)\";\n let assigned = 0;\n const errors: any[] = [];\n\n if (apply) {\n const pr = await notion(`data_sources/${ONLINE_DS}`, \"PATCH\", {\n properties: { Team: { select: { options: TEAMS.map((t) => ({ name: t, color: TEAM_COLORS[t] })) } } },\n });\n propertyResult = pr.ok ? \"ok\" : await pr.json();\n if (pr.ok) {\n for (const c of planned) {\n const res = await notion(`pages/${c.id}`, \"PATCH\", {\n properties: { Team: { select: { name: c.team } } },\n });\n if (res.ok) assigned++;\n else errors.push({ id: c.id, name: c.name, error: await res.json() });\n await new Promise((r) => setTimeout(r, 150));\n }\n }\n }\n\n return new Response(JSON.stringify({\n mode: apply ? \"APPLIED\" : \"DRY RUN\",\n totalRows: rows.length,\n toAssign: planned.length,\n alreadyCorrect,\n perTeam,\n unassigned,\n missingFromDB,\n propertyResult,\n assigned,\n errors,\n planned,\n }, null, 2), { status: 200, headers: { \"Content-Type\": \"application/json\" } });\n}\n","createdAt",["D",1781752288635],"branchVersion","branchId","6ea9e81e-5f84-11f1-8ea9-1607ee4eb77e","id","6ea94daa-5f84-11f1-8ea9-1607ee4eb77e","logistics-sync",["D",1780515782210],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Form to Notion sync","imageUrl","57b8f323-328a-47b3-86c3-c762ebff5f42","pinnedFileId","10db2ebc-692c-11f1-8ac0-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019e8ef8-82d4-720f-b07f-808c7f165c8a","tursoName","6ea94daa5f8411f18ea91607ee4eb77e","tursoHostname","6ea94daa5f8411f18ea91607ee4eb77e-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789512647429],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_108":104},"org",{"_100":99,"_101":102,"_103":104,"_18":55,"_105":106,"_107":25},"branch",{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"isOwned",67,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","sadok","handle","displayName","Sadok Cervantes","avatar","","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":180,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_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":25},"tree",[167,168,169],"files",[167,168,169],"counts",{"_155":63,"_156":157,"_158":63,"_159":160,"_161":162},"contents",[130,131,132],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":151,"_32":28,"_30":31,"_136":-5,"_41":42,"_40":14,"_138":25,"_38":152,"_13":153,"_33":34,"_35":37,"_24":25,"_142":-5,"_27":154},{"_43":144,"_32":145,"_30":57,"_136":-5,"_41":42,"_40":146,"_138":59,"_38":147,"_13":148,"_33":34,"_35":149,"_24":25,"_142":-5,"_27":150},{"_43":133,"_32":134,"_30":135,"_136":-5,"_41":42,"_40":137,"_138":25,"_38":139,"_13":140,"_33":34,"_35":141,"_24":25,"_142":-5,"_27":143},"0c474e9a-2f36-4960-b174-dbc861429ca8","main.tsx","6eac93de-5f84-11f1-8ea9-1607ee4eb77e","parentId",24,"latest",["D",1781592531962],16,"// Webhook: form POST -> match a person by email in the roster data source\n// -> pull the source-of-truth name -> create one arrival row and one\n// departure row with the relation set. No match -> rows are still created\n// without the relation so nothing is lost, and a Slack alert is sent so the\n// email can be fixed or the record linked manually.\n//\n// Notion API 2025-09-03 (data sources).\n//\n// Env vars (Val Town -> Settings -> Environment Variables):\n// NOTION_TOKEN Notion integration secret (required)\n// SLACK_DM_CHANNEL Slack member ID for the no-match alert (required)\n//\n// SLACK_TOKEN is injected by Val Town's Slack connection.\n\nimport { WebClient } from \"npm:@slack/web-api\";\n\nconst NOTION_TOKEN = Deno.env.get(\"NOTION_TOKEN\");\nconst SLACK_DM_CHANNEL = Deno.env.get(\"SLACK_DM_CHANNEL\");\nconst SLACK_TOKEN = Deno.env.get(\"SLACK_TOKEN\");\n\nconst NOTION_VERSION = \"2025-09-03\";\n\n// Data source IDs — required by Notion API 2025-09-03\nconst STUDENT_DS = \"3b9cd139-473f-4100-b5e2-e9aa69486832\";\nconst ARRIVALS_DS = \"0c73e5f4-9e2f-4e52-90ce-c5a86ab57c64\";\nconst DEPARTURES_DS = \"268eee30-2306-4f40-a54a-c2aeaad623ab\";\n\nfunction notion(path: string, method: string, body?: unknown) {\n return fetch(`https://api.notion.com/v1/${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}\n\nasync function slackNotify(text: string) {\n if (!SLACK_TOKEN || !SLACK_DM_CHANNEL) {\n console.warn(\"Slack not configured; skipping alert:\", text);\n return;\n }\n try {\n const slack = new WebClient(SLACK_TOKEN);\n await slack.chat.postMessage({ channel: SLACK_DM_CHANNEL, text });\n } catch (e) {\n console.error(\"Slack notify failed\", e);\n }\n}\n\nfunction norm(s: string): string {\n return (s || \"\").replace(/&/g, \"&\").replace(/\\s+/g, \" \").trim().toLowerCase();\n}\n\nfunction buildFieldMap(fields: any[]): Record {\n const map: Record = {};\n for (const f of fields || []) {\n let value = f.value;\n if (Array.isArray(value) && Array.isArray(f.options)) {\n value = value\n .map((id: string) => f.options.find((o: any) => o.id === id)?.text ?? id)\n .join(\", \");\n } else if (Array.isArray(value)) {\n value = value.join(\", \");\n }\n map[norm(f.label)] = value == null ? \"\" : String(value);\n }\n return map;\n}\n\nconst title = (v: string) => ({ title: [{ text: { content: v || \"\" } }] });\nconst rich = (v: string) => (v ? { rich_text: [{ text: { content: v } }] } : { rich_text: [] });\nconst sel = (v: string) => (v ? { select: { name: v } } : { select: null });\nconst mail = (v: string) => (v ? { email: v } : { email: null });\n\nexport default async function (req: Request): Promise {\n if (req.method !== \"POST\") {\n return new Response(\"listener live\", { status: 200 });\n }\n if (!NOTION_TOKEN) {\n console.error(\"Missing NOTION_TOKEN env var\");\n return new Response(\"server not configured\", { status: 500 });\n }\n\n let payload: any;\n try {\n payload = await req.json();\n } catch {\n return new Response(\"bad json\", { status: 400 });\n }\n\n const data = payload?.data ?? {};\n const m = buildFieldMap(data.fields);\n\n const email = (m[\"student email\"] || \"\").trim();\n const tallyFirst = (m[\"student first name\"] || \"\").trim();\n const tallyLast = (m[\"student last name\"] || \"\").trim();\n\n const arriveMethod = m[\"how will the student arrive?\"] || \"\";\n const arriveAirport = m[\"arrival airport\"] || \"\";\n const arriveFlight = m[\"arrival airline & flight number\"] || \"\";\n const arriveTime = m[\"arrival time (24-hour format)\"] || \"\";\n\n const departMethod = m[\"how will the student depart?\"] || \"\";\n const departAirport = m[\"departure airport\"] || \"\";\n const departFlight = m[\"departure airline & flight number\"] || \"\";\n const departTime = m[\"departure time (24-hour format)\"] || \"\";\n\n if (!email) {\n console.warn(\"Submission has no email; skipping\", data?.submissionId);\n return new Response(JSON.stringify({ ok: false, reason: \"no email\" }), {\n status: 200,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n // 1) Match student by email\n const q = await notion(`data_sources/${STUDENT_DS}/query`, \"POST\", {\n filter: { property: \"Email\", email: { equals: email } },\n page_size: 1,\n });\n const qj = await q.json();\n if (!q.ok) {\n console.error(\"Notion student query failed\", qj);\n return new Response(\"notion query error\", { status: 502 });\n }\n\n const student = qj.results?.[0];\n const tallyFull = `${tallyFirst} ${tallyLast}`.trim();\n let fullName = tallyFull;\n let studentRelation: { id: string }[] = [];\n\n if (student) {\n studentRelation = [{ id: student.id }];\n const p = student.properties || {};\n fullName = p[\"Notion Page\"]?.title?.[0]?.plain_text || tallyFull;\n } else {\n await slackNotify(\n `:warning: *Logistics sync - no match found*\\n` +\n `Student: *${tallyFirst} ${tallyLast}*\\n` +\n `Email submitted: \\`${email}\\`\\n` +\n `Unlinked Arrival + Departure rows were created. Fix the email on the student record or link them manually in Notion.`,\n );\n }\n\n // 2) Create Arrivals row\n const arrivalProps: Record = {\n \"Notion Page\": title(fullName),\n \"Method\": sel(arriveMethod),\n \"Airport\": sel(arriveAirport),\n \"Airline/Flight\": rich(arriveFlight),\n \"Date/Time\": rich(arriveTime),\n };\n if (studentRelation.length) arrivalProps[\"Student Relation\"] = { relation: studentRelation };\n\n const aRes = await notion(\"pages\", \"POST\", {\n parent: { type: \"data_source_id\", data_source_id: ARRIVALS_DS },\n properties: arrivalProps,\n });\n if (!aRes.ok) console.error(\"Arrival create failed\", await aRes.json());\n\n // 3) Create Departures row\n const departureProps: Record = {\n \"Notion Page\": title(fullName),\n \"Method\": sel(departMethod),\n \"Airport\": sel(departAirport),\n \"Airline/Flight\": rich(departFlight),\n \"Date/Time\": rich(departTime),\n };\n if (studentRelation.length) departureProps[\"Student Relation\"] = { relation: studentRelation };\n\n const dRes = await notion(\"pages\", \"POST\", {\n parent: { type: \"data_source_id\", data_source_id: DEPARTURES_DS },\n properties: departureProps,\n });\n if (!dRes.ok) console.error(\"Departure create failed\", await dRes.json());\n\n return new Response(\n JSON.stringify({\n ok: true,\n matched: !!student,\n email,\n arrivalCreated: aRes.ok,\n departureCreated: dRes.ok,\n }),\n { status: 200, headers: { \"Content-Type\": \"application/json\" } },\n );\n}\n","label",[134],"ac67e68e-0a48-4d8a-a886-8c59aca67e22","fix-online-names.tsx",26,["D",1781592560697],8,"// One-off: fix titles in a roster data source.\n//\n// Current state per row: title (\"Notion Page\") holds the FIRST name,\n// \"First Name\" column is empty, \"Last Name\" is populated.\n// This sets the title to \"First Last\" and copies the first name into \"First Name\".\n//\n// Safe to re-run: only rows whose \"First Name\" is still empty are touched.\n// Output lists names, so the endpoint is gated behind FIX_KEY.\n//\n// GET ...?key=FIX_KEY -> dry run, returns the planned changes\n// GET ...?key=FIX_KEY&apply=true -> writes the changes\n//\n// Delete this file once the migration is done.\n\nconst NOTION_TOKEN = Deno.env.get(\"NOTION_TOKEN\");\nconst FIX_KEY = Deno.env.get(\"FIX_KEY\");\nconst NOTION_VERSION = \"2025-09-03\";\n// redeploy nonce 1\nconst ONLINE_DS = \"9f3e6237-4908-4bf9-b64f-6f7e13cce320\"; // roster data source\n\nfunction notion(path: string, method: string, body?: unknown) {\n return fetch(`https://api.notion.com/v1/${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}\n\nfunction plain(prop: any): string {\n const items = prop?.title ?? prop?.rich_text ?? [];\n return items.map((p: any) => p?.plain_text ?? \"\").join(\"\").trim();\n}\n\nfunction titleCase(s: string): string {\n return (s || \"\")\n .trim()\n .split(/\\s+/)\n .map((w) => (w ? w[0].toLocaleUpperCase() + w.slice(1).toLocaleLowerCase() : w))\n .join(\" \");\n}\n\nasync function fetchAll(): Promise {\n const rows: any[] = [];\n let cursor: string | undefined;\n do {\n const body: any = { page_size: 100 };\n if (cursor) body.start_cursor = cursor;\n const r = await notion(`data_sources/${ONLINE_DS}/query`, \"POST\", body);\n const j = await r.json();\n if (!r.ok) throw new Error(\"query failed: \" + JSON.stringify(j));\n rows.push(...(j.results ?? []));\n cursor = j.has_more ? j.next_cursor : undefined;\n } while (cursor);\n return rows;\n}\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const providedKey = req.headers.get(\"x-fix-key\") ?? url.searchParams.get(\"key\");\n if (!FIX_KEY || providedKey !== FIX_KEY) {\n return new Response(\"unauthorized\", { status: 401 });\n }\n if (!NOTION_TOKEN) return new Response(\"missing NOTION_TOKEN\", { status: 500 });\n\n const apply = req.headers.get(\"x-apply\") === \"true\" || url.searchParams.get(\"apply\") === \"true\";\n\n let rows: any[];\n try {\n rows = await fetchAll();\n } catch (e) {\n return new Response(JSON.stringify({ ok: false, error: String(e) }, null, 2), {\n status: 200,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n const planned: any[] = [];\n const flagged: any[] = [];\n let skipped = 0;\n\n for (const page of rows) {\n const p = page.properties || {};\n const currentTitle = plain(p[\"Notion Page\"]); // = first name today\n const existingFirst = plain(p[\"First Name\"]);\n const last = plain(p[\"Last Name\"]);\n\n if (existingFirst) { skipped++; continue; } // already fixed\n if (!currentTitle) { skipped++; continue; } // nothing to derive from\n\n const first = titleCase(currentTitle);\n const tcLast = titleCase(last);\n const newTitle = `${first} ${tcLast}`.trim();\n const change = { id: page.id, first, last: tcLast, newTitle };\n if (!tcLast) flagged.push(change);\n planned.push(change);\n }\n\n let applied = 0;\n const errors: any[] = [];\n if (apply) {\n for (const c of planned) {\n const res = await notion(`pages/${c.id}`, \"PATCH\", {\n properties: {\n \"Notion Page\": { title: [{ text: { content: c.newTitle } }] },\n \"First Name\": { rich_text: [{ text: { content: c.first } }] },\n },\n });\n if (res.ok) applied++;\n else errors.push({ id: c.id, error: await res.json() });\n await new Promise((r) => setTimeout(r, 350)); // stay under ~3 req/s\n }\n }\n\n return new Response(\n JSON.stringify({\n mode: apply ? \"APPLIED\" : \"DRY RUN\",\n totalRows: rows.length,\n toProcess: planned.length,\n skippedAlreadyDoneOrEmpty: skipped,\n flaggedMissingLastName: flagged,\n applied,\n errors,\n planned,\n }, null, 2),\n { status: 200, headers: { \"Content-Type\": \"application/json\" } },\n );\n}\n",[145],"472c2140-5933-470b-9a85-e87fa91c1ffd",["D",1781752288635],3,[28],"pulls","branches",1,"forks","envVars",{"_163":165,"_166":63},"connections",{"_163":157,"_164":63},"count","unfilledCount",7,"emptyCount",{"_43":151,"_32":28,"_30":31,"_136":-5,"_41":42,"_40":14,"_138":25,"_38":177,"_13":153,"_33":34,"_35":37,"_24":25,"_142":-5,"_171":178,"_27":179},{"_43":144,"_32":145,"_30":57,"_136":-5,"_41":42,"_40":146,"_138":59,"_38":174,"_13":148,"_33":34,"_35":149,"_24":25,"_142":-5,"_171":175,"_27":176},{"_43":133,"_32":134,"_30":135,"_136":-5,"_41":42,"_40":137,"_138":25,"_38":170,"_13":140,"_33":34,"_35":141,"_24":25,"_142":-5,"_171":172,"_27":173},["D",1781592531962],"children",[],[134],["D",1781592560697],[],[145],["D",1781752288635],[],[28],["D",1780515782210],["D",1789512647429],{"_100":99,"_108":104},{"_100":99,"_101":102,"_103":104,"_18":55,"_105":106,"_107":25},{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"ctx",{"_82":-5,"_127":218,"_219":220,"_221":222,"_223":25,"_224":25,"_225":25,"_226":59,"_227":-5,"_228":-7,"_229":-7,"_230":63,"_231":25,"_232":25,"_233":-5,"_234":25,"_235":25,"_236":25,"_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 · v30