[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_104":105,"_106":107},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","gexcysanchez","name","sunprot-modules-db","path","clean.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":-5,"_53":-5,"_54":55,"_56":-5,"_57":42,"_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":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_13":44},"permalink","https://www.val.town/x/gexcysanchez/sunprot-modules-db/code/clean.ts","extension","id","ed86e182-53f6-4442-bb9b-eaf9ce2b9b2f","fileId","8d121dfa-aa7d-11f1-b063-1607ee4eb77e","parentId","branchId","f6270933-d28e-4442-aed6-55a0986596aa","branchVersion",72,"latest",true,"createdAt",["D",1789109008680],"version",3,"fileType","interval","content","const DB = () => Deno.env.get(\"DB_URL\");\nconst SEC = () => Deno.env.get(\"FB_SECRET\");\nconst CF_ACCOUNT_ID = () => Deno.env.get(\"CF_ACCOUNT_ID\");\nconst CF_KV_NAMESPACE_ID = () => Deno.env.get(\"CF_KV_NAMESPACE_ID\");\nconst CF_API_TOKEN = () => Deno.env.get(\"CF_API_TOKEN\");\nconst SESSION_MAX_AGE = 14 * 24 * 60 * 60 * 1000;\nconst ACCOUNT_MAX_AGE = 14 * 24 * 60 * 60 * 1000;\n\nasync function fbGet(path: string) {\n const r = await fetch(`${DB()}/${path}.json?auth=${SEC()}`);\n if (!r.ok) throw new Error(\"db \" + r.status);\n return r.json();\n}\n\nasync function fbDelete(path: string) {\n const r = await fetch(`${DB()}/${path}.json?auth=${SEC()}`, {\n method: \"DELETE\",\n });\n if (!r.ok) throw new Error(\"db \" + r.status);\n return r.json();\n}\n\nasync function kvList(prefix: string): Promise {\n const keys: string[] = [];\n let cursor: string | null = null;\n\n do {\n const params = new URLSearchParams({ prefix, limit: \"1000\" });\n if (cursor) params.set(\"cursor\", cursor);\n const r = await fetch(\n `https://api.cloudflare.com/client/v4/accounts/${CF_ACCOUNT_ID()}/storage/kv/namespaces/${CF_KV_NAMESPACE_ID()}/keys?${params}`,\n { headers: { Authorization: `Bearer ${CF_API_TOKEN()}` } },\n );\n if (!r.ok) throw new Error(\"kv list \" + r.status);\n const data = await r.json();\n for (const k of data.result ?? []) keys.push(k.name);\n cursor = data.result_info?.cursor ?? null;\n } while (cursor);\n\n return keys;\n}\n\nasync function kvGet(key: string): Promise {\n const r = await fetch(\n `https://api.cloudflare.com/client/v4/accounts/${CF_ACCOUNT_ID()}/storage/kv/namespaces/${CF_KV_NAMESPACE_ID()}/values/${\n encodeURIComponent(key)\n }`,\n { headers: { Authorization: `Bearer ${CF_API_TOKEN()}` } },\n );\n if (r.status === 404) return null;\n if (!r.ok) throw new Error(\"kv get \" + r.status);\n try {\n return await r.json();\n } catch {\n return null;\n }\n}\n\nasync function kvDelete(key: string): Promise {\n const r = await fetch(\n `https://api.cloudflare.com/client/v4/accounts/${CF_ACCOUNT_ID()}/storage/kv/namespaces/${CF_KV_NAMESPACE_ID()}/values/${\n encodeURIComponent(key)\n }`,\n {\n method: \"DELETE\",\n headers: { Authorization: `Bearer ${CF_API_TOKEN()}` },\n },\n );\n if (!r.ok && r.status !== 404) throw new Error(\"kv delete \" + r.status);\n}\n\nexport default async function (_req: Request): Promise {\n const [allUsers, allModules, allComments] = await Promise.all([\n fbGet(\"users\"),\n fbGet(\"modules\"),\n fbGet(\"comments\"),\n ]);\n\n if (!allUsers || typeof allUsers !== \"object\") {\n return new Response(null, { status: 204 });\n }\n\n const modules = (allModules || {}) as Record>;\n const comments = (allComments || {}) as Record<\n string,\n Record\n >;\n\n const usersWithActivity = new Set();\n const now = Date.now();\n\n for (const mod of Object.values(modules)) {\n if (mod.owner) {\n usersWithActivity.add(String(mod.owner).toLowerCase().trim());\n }\n if (mod.creator) {\n usersWithActivity.add(String(mod.creator).toLowerCase().trim());\n }\n const reviews = (mod.reviews || {}) as Record;\n for (const reviewer of Object.keys(reviews)) {\n usersWithActivity.add(reviewer.toLowerCase().trim());\n }\n }\n\n for (const modComments of Object.values(comments)) {\n for (\n const comment of Object.values(\n modComments as Record>,\n )\n ) {\n if (comment.username) {\n usersWithActivity.add(String(comment.username).toLowerCase().trim());\n }\n }\n }\n\n const userSessionKeys = await kvList(\"user_session:\");\n const sessionsByUser: Record = {};\n\n for (const kvKey of userSessionKeys) {\n const username = kvKey.replace(\"user_session:\", \"\");\n const data = await kvGet(kvKey) as\n | { token: string; createdAt: number }\n | null;\n if (!data || !data.token || !data.createdAt) continue;\n const isActive = (now - data.createdAt) < SESSION_MAX_AGE;\n if (isActive) usersWithActivity.add(username);\n sessionsByUser[username] = data.token;\n }\n\n for (\n const [username, user] of Object.entries(\n allUsers as Record>,\n )\n ) {\n const key = username.toLowerCase().trim();\n if (usersWithActivity.has(key)) continue;\n\n const createdAt = typeof user.createdAt === \"number\" ? user.createdAt : 0;\n if (createdAt && (now - createdAt) < ACCOUNT_MAX_AGE) continue;\n\n await fbDelete(`users/${key}`);\n\n if (sessionsByUser[key]) {\n await kvDelete(`session:${sessionsByUser[key]}`);\n await kvDelete(`user_session:${key}`);\n }\n }\n\n return new Response(null, { status: 204 });\n}","deleted",false,"label",[14],"aad57c4b-6371-4ffe-890b-2f787b7c8e35",["D",1783552548469],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","35b1a91c-8fcc-4040-bc0f-e1cb277a7282","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019e1d1b-adbb-76f7-a82a-b4232abb1bd1","tursoName","aad57c4b63714ffe890b2f787b7c8e35","tursoHostname","aad57c4b63714ffe890b2f787b7c8e35-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789472446807],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_103":99},"org",{"_9":10,"_96":97,"_98":99,"_54":55,"_100":101,"_102":42},"branch",{"_35":30,"_11":87,"_22":28,"_88":45,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":12,"_95":10},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Gexcy Sanchez","avatar","https://lh3.googleusercontent.com/a/ACg8ocJD6WSSYPd2CVI2O3PHd4vtUwhkw7rC8Zf4-yjll4kHtQqmbYs=s96-c","tier","free","canRestrictVals","profileImageUrl","ctx",{"_80":-5,"_137":138,"_139":140,"_141":142,"_143":42,"_144":42,"_145":42,"_146":32,"_147":-5,"_148":-7,"_149":-7,"_150":61,"_151":42,"_152":42,"_153":-5,"_154":42,"_155":42,"_156":42,"_157":-5},"ENV",{"_108":109,"_110":111,"_112":87,"_113":114,"_115":116,"_117":118,"_119":120,"_121":122,"_123":124,"_125":126,"_127":128,"_129":130,"_131":132,"_133":134,"_135":136},"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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]