${esc(subject)}

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_157":158,"_159":160},"routes/_app.x.$handle.$name",{"_98":97,"_32":45,"_106":88,"_27":100,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":25,"_120":121,"_122":123,"_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","88fc3ae2-670d-11f1-9dc9-1607ee4eb77e","name","fileType","script","content","// BiB Newsletter Feed Server\n// Trigger type: HTTP\n// Returns an Atom feed of your stored newsletters.\n//\n// Before saving this val, go to val.town Settings → Environment Variables\n// and add: BIB_FEED_SECRET = (any random string, e.g. \"nx7bq2m4\")\n//\n// Your feed URL will then be:\n// https://-bibfeedserver.web.val.run/feed/\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nconst SECRET = Deno.env.get(\"BIB_FEED_SECRET\") ?? \"\";\n\nexport default async function (req: Request): Promise {\n const path = new URL(req.url).pathname;\n\n if (path !== `/feed/${SECRET}`) {\n return new Response(\"Not found\", { status: 404 });\n }\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS bib_newsletters (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n received_at TEXT NOT NULL,\n sender TEXT,\n subject TEXT,\n html TEXT,\n body TEXT\n )\n `);\n\n const result = await sqlite.execute(`\n SELECT id, received_at, sender, subject, html, body\n FROM bib_newsletters\n ORDER BY received_at DESC\n LIMIT 50\n `);\n\n const esc = (s: unknown) =>\n String(s ?? \"\")\n .replace(/&/g, \"&\")\n .replace(//g, \">\");\n\n const entries = result.rows.map(([id, received_at, sender, subject, html, body]) => ` \n urn:bib:${id}\n ${esc(subject)}\n ${esc(sender)}\n ${new Date(String(received_at)).toISOString()}\n \n `);\n\n const feed = `\n\n BiB Newsletters\n urn:bib:newsletters\n ${new Date().toISOString()}\n${entries.join(\"\\n\")}\n`;\n\n return new Response(feed, {\n headers: {\n \"Content-Type\": \"text/xml; charset=utf-8\",\n \"Cache-Control\": \"no-store\",\n },\n });\n}","http","createdAt",["D",1781344407462],"branchVersion","branchId","5d7521ea-2cd4-46cf-9a71-1d40f8a5faa6","id","5ba31df5-f59c-4359-9cde-fb231df90da3","emailreceiver",["D",1781344325536],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","email receiver","imageUrl","4f3e5766-db71-43ab-8d6b-8959207c9f91","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019ec05c-5d19-7488-b0d3-0c6697faad30","tursoName","5ba31df5f59c43599cdefb231df90da3","tursoHostname","5ba31df5f59c43599cdefb231df90da3-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789506649022],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_105":100},"org",{"_98":97,"_99":100,"_101":100,"_18":55,"_102":103,"_104":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",18,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","bibtool","handle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":152,"_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":153,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":154,"_82":155,"_84":156,"_86":25},"tree",[147],"files",[147],"counts",{"_136":61,"_137":138,"_139":61,"_140":141,"_142":143},"contents",[128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"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},"a39bb03c-1ad1-4f64-8a10-af57640f798a","parentId","latest",["D",1781344407462],2,"label",[28],"pulls","branches",1,"forks","envVars",{"_144":133,"_146":61},"connections",{"_144":61,"_145":61},"count","unfilledCount","emptyCount",{"_43":129,"_32":28,"_30":31,"_130":-5,"_41":42,"_40":14,"_131":25,"_38":148,"_13":133,"_33":37,"_35":36,"_24":25,"_134":-5,"_149":150,"_27":151},["D",1781344407462],"children",[],[28],["D",1781344325536],["D",1789506649022],{"_98":97,"_105":100},{"_98":97,"_99":100,"_101":100,"_18":55,"_102":103,"_104":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":190,"_191":192,"_193":194,"_195":25,"_196":25,"_197":25,"_198":123,"_199":-5,"_200":-7,"_201":-7,"_202":61,"_203":25,"_204":25,"_205":-5,"_206":25,"_207":25,"_208":25,"_209":-5},"ENV",{"_161":162,"_163":164,"_165":88,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189},"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 · v3