[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_168":169,"_170":171},"routes/_app.x.$handle.$name",{"_101":100,"_37":49,"_109":91,"_32":110,"_13":14,"_111":-5,"_11":112,"_113":114,"_115":116,"_117":118,"_119":120,"_26":-5,"_121":-5,"_122":-5,"_123":30,"_124":125,"_126":30,"_127":-5,"_128":-5,"_129":130},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_47":48,"_37":49,"_42":50,"_51":-5,"_52":30,"_53":54,"_55":54,"_56":57,"_58":-5,"_19":59,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":-5,"_71":-5,"_72":-5,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":84,"_85":86,"_87":88,"_89":30},"version",2,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","523d3b24-3103-4236-ad2a-e37486e5df90","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":33,"_38":39,"_40":41,"_42":43,"_44":14,"_45":46,"_29":30},"previous","deleted",false,"deletedHere","path","commitfest.ts","latestPath","fileId","755ef5f2-a6c7-11f1-8c42-1607ee4eb77e","name","fileType","script","content","// Fetch a PostgreSQL commitfest patch page and extract its history table,\n// which the commitfest JSON API does not expose.\n\nexport interface HistoryEntry {\n date: string;\n who: string;\n what: string;\n}\n\nexport interface PatchInfo {\n id: number;\n title: string;\n url: string;\n history: HistoryEntry[];\n}\n\nexport class AppError extends Error {\n status: number;\n constructor(message: string, status = 500) {\n super(message);\n this.status = status;\n }\n}\n\n/** Collapse HTML into plain text: strip tags and decode the common entities. */\nfunction decodeEntities(s: string): string {\n return s\n .replace(/<[^>]+>/g, \"\")\n .replace(/ /g, \" \")\n .replace(/&/g, \"&\")\n .replace(/</g, \"<\")\n .replace(/>/g, \">\")\n .replace(/"/g, '\"')\n .replace(/'/gi, \"'\")\n .replace(/'/g, \"'\")\n .replace(///gi, \"/\")\n .replace(/&#(\\d+);/g, (_, n) => String.fromCharCode(Number(n)))\n .replace(/\\s+/g, \" \")\n .trim();\n}\n\nfunction extractTitle(html: string): string {\n const m = html.match(/\\s*Title\\s*<\\/th>\\s*]*>([\\s\\S]*?)<\\/td>/i);\n return m ? decodeEntities(m[1]) : \"\";\n}\n\nfunction extractHistory(html: string): HistoryEntry[] {\n // Anchor on the `History` cell. The first `` after it is the\n // nested history table; its first `

` closes it.\n const anchor = html.indexOf(\"History\");\n if (anchor === -1) return [];\n const tableStart = html.indexOf(\"\", tableStart);\n if (tableEnd === -1) return [];\n\n const tableHtml = html.slice(tableStart, tableEnd);\n const entries: HistoryEntry[] = [];\n\n const rowRe = /]*>([\\s\\S]*?)<\\/tr>/gi;\n let rm: RegExpExecArray | null;\n while ((rm = rowRe.exec(tableHtml))) {\n // Skip header row (contains , not three ).\n const cells = [...rm[1].matchAll(/]*>([\\s\\S]*?)<\\/td>/gi)];\n if (cells.length !== 3) continue;\n entries.push({\n date: decodeEntities(cells[0][1]),\n who: decodeEntities(cells[1][1]),\n what: decodeEntities(cells[2][1]),\n });\n }\n return entries;\n}\n\nexport async function fetchPatch(id: number | string): Promise {\n const url = `https://commitfest.postgresql.org/patch/${id}/`;\n const res = await fetch(url, {\n headers: { \"User-Agent\": \"cf-rss (+https://val.town/mootari/cf-rss)\" },\n redirect: \"follow\",\n });\n if (res.status === 404) {\n throw new AppError(`Patch ${id} not found`, 404);\n }\n if (!res.ok) {\n throw new AppError(`commitfest returned HTTP ${res.status}`, 502);\n }\n const html = await res.text();\n return {\n id: Number(id),\n title: extractTitle(html),\n url,\n history: extractHistory(html),\n };\n}\n","createdAt",["D",1788351102297],"branchVersion","branchId","277bd56f-e1f2-4860-ab1d-825ac0ba658c","id","f91ca2e2-7113-4e4b-96aa-86f5439f3875","cf-rss",["D",1788351095345],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Commitfest patch history as an RSS feed","imageUrl","bd61c49b-f855-4fa8-b249-7c6b35c00fb8","pinnedFileId","7141722e-a6c7-11f1-b0ba-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","e576abfa-ab5a-4d5d-9341-3aa9d0b00c42","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_101":100,"_108":104},"org",{"_101":100,"_102":-5,"_103":104,"_19":59,"_105":106,"_107":30},"branch",{"_13":90,"_37":91,"_47":46,"_92":48,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":49,"_99":100},"isOwned",46,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","mootari","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yVkpXNXhUYUJCM0N5RGNBNklRUWJrZXdOWmIucG5nIn0","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_47":48,"_37":49,"_42":164,"_51":-5,"_52":30,"_53":54,"_55":54,"_56":57,"_58":-5,"_19":59,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":-5,"_71":-5,"_72":-5,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":165,"_85":166,"_87":167,"_89":30},"tree",[155,156],"files",[155,156],"counts",{"_145":67,"_146":136,"_147":67,"_148":149,"_150":151},"contents",[131,132],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_47":142,"_37":33,"_35":36,"_135":-5,"_45":46,"_44":14,"_137":30,"_42":143,"_13":67,"_38":39,"_40":41,"_29":30,"_140":-5,"_32":144},{"_47":133,"_37":134,"_35":61,"_135":-5,"_45":46,"_44":136,"_137":30,"_42":138,"_13":67,"_38":39,"_40":139,"_29":30,"_140":49,"_32":141},"323a9d0b-41b3-400b-a368-91faaeebbaf6","main.ts","parentId",1,"latest",["D",1788351095387],"// placeholder","label",[134],"edb7120e-7c67-464a-9234-26da9b251baf",["D",1788351102297],[33],"pulls","branches","forks","envVars",{"_152":67,"_154":67},"connections",{"_152":67,"_153":67},"count","unfilledCount","emptyCount",{"_47":142,"_37":33,"_35":36,"_135":-5,"_45":46,"_44":14,"_137":30,"_42":161,"_13":67,"_38":39,"_40":41,"_29":30,"_140":-5,"_158":162,"_32":163},{"_47":133,"_37":134,"_35":61,"_135":-5,"_45":46,"_44":136,"_137":30,"_42":157,"_13":67,"_38":39,"_40":139,"_29":30,"_140":49,"_158":159,"_32":160},["D",1788351095387],"children",[],[134],["D",1788351102297],[],[33],["D",1788351095345],{"_101":100,"_108":104},{"_101":100,"_102":-5,"_103":104,"_19":59,"_105":106,"_107":30},{"_13":90,"_37":91,"_47":46,"_92":48,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":49,"_99":100},"ctx",{"_83":-5,"_128":201,"_202":203,"_204":205,"_206":30,"_207":30,"_208":30,"_209":63,"_210":-5,"_211":-7,"_212":-7,"_213":67,"_214":30,"_215":30,"_216":-5,"_217":30,"_218":30,"_219":30,"_220":-5},"ENV",{"_172":173,"_174":175,"_176":91,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200},"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 · v2