[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_151":152,"_153":154},"routes/_app.x.$handle.$name",{"_94":93,"_32":45,"_102":84,"_27":36,"_13":14,"_103":-5,"_11":104,"_105":106,"_107":108,"_109":110,"_111":112,"_20":-5,"_113":-5,"_114":-5,"_115":25,"_116":117,"_118":25,"_119":-5,"_120":-5,"_121":122},"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":36,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":77,"_78":79,"_80":81,"_82":25},"version",2,"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","main.ts","latestPath","fileId","eab87030-6135-11f1-9717-1607ee4eb77e","name","fileType","script","content","","import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { createRemoteJWKSet, jwtVerify } from \"https://esm.sh/jose@5\";\n\nconst GHOST_URL = Deno.env.get(\"GHOST_URL\");\nconst GHOST_ADMIN_KEY = Deno.env.get(\"GHOST_ADMIN_KEY\");\nconst ADMIN_TOKEN = Deno.env.get(\"ADMIN_TOKEN\");\n\n// Set up DB\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS addresses (\n member_uuid TEXT PRIMARY KEY,\n name TEXT,\n address1 TEXT,\n address2 TEXT,\n city TEXT,\n state TEXT,\n zip TEXT,\n country TEXT\n )\n`);\n\nasync function getGhostAdminToken() {\n const [id, secret] = GHOST_ADMIN_KEY.split(\":\");\n const { default: jwt } = await import(\"https://esm.sh/jsonwebtoken@9\");\n return jwt.sign({}, Buffer.from(secret, \"hex\"), {\n keyid: id,\n algorithm: \"HS256\",\n expiresIn: \"5m\",\n audience: \"/admin/\",\n });\n}\n\nasync function ghostAdminFetch(path) {\n const adminToken = await getGhostAdminToken();\n const response = await fetch(`${GHOST_URL}/ghost/api/admin/${path}`, {\n headers: { Authorization: `Ghost ${adminToken}` },\n });\n return response.json();\n}\n\nasync function getPhysicalTiers() {\n const data = await ghostAdminFetch(\"tiers/?limit=all\");\n return data.tiers\n .filter((t) => t.name.startsWith(\"Physical Objects\"))\n .map((t) => ({ id: t.id, name: t.name }));\n}\n\nasync function getPhysicalMembers() {\n const tiers = await getPhysicalTiers();\n const tierIds = tiers.map((t) => t.id);\n const tierMap = Object.fromEntries(tiers.map((t) => [t.id, t.name]));\n\n // Fetch all members with their tiers\n let members = [];\n let page = 1;\n while (true) {\n const data = await ghostAdminFetch(\n `members/?limit=100&page=${page}&include=tiers`,\n );\n members = members.concat(data.members);\n if (data.meta.pagination.page >= data.meta.pagination.pages) break;\n page++;\n }\n\n return members\n .filter((m) => m.tiers?.some((t) => tierIds.includes(t.id)))\n .map((m) => {\n const tier = m.tiers.find((t) => tierIds.includes(t.id));\n return {\n uuid: m.id,\n email: m.email,\n name: m.name,\n tierName: tierMap[tier.id],\n };\n });\n}\n\nasync function getMemberUUID(email) {\n const data = await ghostAdminFetch(\n `members/?filter=email:'${encodeURIComponent(email)}'`,\n );\n return data.members?.[0]?.id ?? null;\n}\n\nasync function verifyToken(request) {\n const authHeader = request.headers.get(\"Authorization\");\n if (!authHeader?.startsWith(\"Bearer \")) return null;\n const token = authHeader.slice(7);\n const JWKS = createRemoteJWKSet(\n new URL(`${GHOST_URL}/.well-known/jwks.json`),\n );\n try {\n const { payload } = await jwtVerify(token, JWKS, {\n audience: `${GHOST_URL}/members/api`,\n issuer: `${GHOST_URL}/members/api`,\n });\n return payload.sub;\n } catch {\n return null;\n }\n}\n\nfunction checkAdminToken(request) {\n const url = new URL(request.url);\n return url.searchParams.get(\"token\") === ADMIN_TOKEN;\n}\n\nfunction toUTF16TSV(rows) {\n const tsv = rows.map((r) => r.join(\"\\t\")).join(\"\\n\");\n const buf = new ArrayBuffer(2 + tsv.length * 2);\n const view = new DataView(buf);\n view.setUint16(0, 0xFEFF, true); // BOM\n for (let i = 0; i < tsv.length; i++) {\n view.setUint16(2 + i * 2, tsv.charCodeAt(i), true);\n }\n return new Uint8Array(buf);\n}\n\nfunction adminHTML(members, addresses) {\n const addrMap = Object.fromEntries(\n addresses.map((a) => [a.member_uuid, a]),\n );\n\n const rows = members.map((m) => {\n const a = addrMap[m.uuid] || {};\n return `\n \n ${m.email}\n ${m.tierName}\n \n \n \n \n \n \n \n \n \n `;\n }).join(\"\");\n\n const token = \"TOKEN_PLACEHOLDER\";\n\n return `\n\n\n \n Member Addresses\n \n\n\n

Member Addresses

\n Download TSV\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n ${rows}\n

Email	Tier	Name	Address	Address Line 2	City	State	Zip	Country

\n \n\n`;\n}\n\nexport default async function handler(request) {\n const url = new URL(request.url);\n const path = url.pathname;\n\n // Member-facing routes\n if (path === \"/address\") {\n const email = await verifyToken(request);\n if (!email) {\n return new Response(JSON.stringify({ error: \"Unauthorized\" }), {\n status: 401,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n const memberUUID = await getMemberUUID(email);\n if (!memberUUID) {\n return new Response(JSON.stringify({ error: \"Member not found\" }), {\n status: 404,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n if (request.method === \"GET\") {\n const result = await sqlite.execute(\n \"SELECT * FROM addresses WHERE member_uuid = ?\",\n [memberUUID],\n );\n const address = result.rows[0] ?? null;\n return new Response(JSON.stringify({ address }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n if (request.method === \"POST\") {\n const { name, address1, address2, city, state, zip, country } =\n await request.json();\n await sqlite.execute(\n `INSERT INTO addresses (member_uuid, name, address1, address2, city, state, zip, country)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)\n ON CONFLICT(member_uuid) DO UPDATE SET\n name=excluded.name,\n address1=excluded.address1,\n address2=excluded.address2,\n city=excluded.city,\n state=excluded.state,\n zip=excluded.zip,\n country=excluded.country`,\n [memberUUID, name, address1, address2, city, state, zip, country],\n );\n return new Response(JSON.stringify({ success: true }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n }\n\n // Admin routes\n if (path === \"/admin\" || path === \"/admin/save\") {\n if (!checkAdminToken(request)) {\n return new Response(\"Unauthorized\", { status: 401 });\n }\n\n if (path === \"/admin/save\" && request.method === \"POST\") {\n const {\n member_uuid,\n name,\n address1,\n address2,\n city,\n state,\n zip,\n country,\n } = await request.json();\n await sqlite.execute(\n `INSERT INTO addresses (member_uuid, name, address1, address2, city, state, zip, country)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)\n ON CONFLICT(member_uuid) DO UPDATE SET\n name=excluded.name,\n address1=excluded.address1,\n address2=excluded.address2,\n city=excluded.city,\n state=excluded.state,\n zip=excluded.zip,\n country=excluded.country`,\n [member_uuid, name, address1, address2, city, state, zip, country],\n );\n return new Response(JSON.stringify({ success: true }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n if (path === \"/admin\" && request.method === \"GET\") {\n const members = await getPhysicalMembers();\n const uuids = members.map((m) => `'${m.uuid}'`).join(\",\");\n const addrResult = uuids.length\n ? await sqlite.execute(\n `SELECT * FROM addresses WHERE member_uuid IN (${uuids})`,\n )\n : { rows: [] };\n\n if (url.searchParams.get(\"download\") === \"1\") {\n const addrMap = Object.fromEntries(\n addrResult.rows.map((a) => [a.member_uuid, a]),\n );\n const header = [\n \"Email\",\n \"Name\",\n \"Address\",\n \"Address Line 2\",\n \"City\",\n \"State\",\n \"Zipcode\",\n \"Country\",\n \"Ounces\",\n \"Length\",\n \"Width\",\n \"Height\",\n \"Tier\",\n ];\n const rows = [\n header,\n ...members.map((m) => {\n const a = addrMap[m.uuid] || {};\n return [\n m.email,\n a.name || \"\",\n a.address1 || \"\",\n a.address2 || \"\",\n a.city || \"\",\n a.state || \"\",\n a.zip || \"\",\n a.country || \"\",\n \"\",\n \"\",\n \"\",\n \"\",\n m.tierName,\n ];\n }),\n ];\n const tsv = toUTF16TSV(rows);\n return new Response(tsv, {\n headers: {\n \"Content-Type\": \"text/tab-separated-values; charset=utf-16\",\n \"Content-Disposition\": 'attachment; filename=\"addresses.txt\"',\n },\n });\n }\n\n const html = adminHTML(members, addrResult.rows)\n .replaceAll(\"TOKEN_PLACEHOLDER\", ADMIN_TOKEN);\n return new Response(html, {\n headers: { \"Content-Type\": \"text/html\" },\n });\n }\n }\n\n return new Response(\"Not found\", { status: 404 });\n}","createdAt",["D",1780702824078],"branchVersion","branchId","0326d693-b7fc-42b4-9c15-ac8fce34c7e2","id","b69e0fb2-de21-412f-b7f5-7e2fb4b6c395","avclub-rolodex",["D",1780701962396],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","78d840e0-15a9-11f0-a1b0-11dba95637f5","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","d9636d82-7655-4bde-8177-f99101e28946","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_94":93,"_101":97},"org",{"_94":93,"_95":-5,"_96":97,"_18":54,"_98":99,"_100":25},"branch",{"_13":83,"_32":84,"_43":42,"_85":44,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":45,"_92":93},"isOwned",18,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","palomakop","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ2VzU0Y2Z5UkMzR2VjY0o4bjJZdkxwdW43RSIsImluaXRpYWxzIjoiUEsifQ","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":147,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":36,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":148,"_78":149,"_80":150,"_82":25},"tree",[142],"files",[142],"counts",{"_131":60,"_132":128,"_133":60,"_134":135,"_136":137},"contents",[123],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":124,"_32":28,"_30":31,"_125":-5,"_41":42,"_40":14,"_126":25,"_38":127,"_13":128,"_33":34,"_35":37,"_24":25,"_129":-5,"_27":130},"2b88ab84-5a2a-4828-982e-9b9c33fde554","parentId","latest",["D",1780702824078],1,"label",[28],"pulls","branches","forks","envVars",{"_138":140,"_141":60},"connections",{"_138":60,"_139":60},"count","unfilledCount",4,"emptyCount",{"_43":124,"_32":28,"_30":31,"_125":-5,"_41":42,"_40":14,"_126":25,"_38":143,"_13":128,"_33":34,"_35":37,"_24":25,"_129":-5,"_144":145,"_27":146},["D",1780702824078],"children",[],[28],["D",1780701962396],{"_94":93,"_101":97},{"_94":93,"_95":-5,"_96":97,"_18":54,"_98":99,"_100":25},{"_13":83,"_32":84,"_43":42,"_85":44,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":45,"_92":93},"ctx",{"_76":-5,"_120":184,"_185":186,"_187":188,"_189":25,"_190":25,"_191":25,"_192":193,"_194":-5,"_195":-7,"_196":-7,"_197":60,"_198":25,"_199":25,"_200":-5,"_201":25,"_202":25,"_203":25,"_204":-5},"ENV",{"_155":156,"_157":158,"_159":84,"_160":161,"_162":163,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183},"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",true,"preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v2