[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_105":106,"_107":108},"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","cleanup.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/cleanup.ts","extension","id","1991f12a-bc48-4557-b1e4-9a114a04e4aa","fileId","8f0c68da-9e9e-11f1-b1dc-1607ee4eb77e","parentId","branchId","f6270933-d28e-4442-aed6-55a0986596aa","branchVersion",64,"latest",true,"createdAt",["D",1787492145382],"version",5,"fileType","interval","content","const DB = () => Deno.env.get(\"DB_URL\");\nconst SEC = () => Deno.env.get(\"FB_SECRET\");\nconst SESSION_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\nexport default async function (_req: Request): Promise {\n const [allUsers, allModules, allComments, allSessions] = await Promise.all([\n fbGet(\"users\"),\n fbGet(\"modules\"),\n fbGet(\"comments\"),\n fbGet(\"sessions\"),\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 const sessions = (allSessions || {}) as Record<\n string,\n { username: string; createdAt: number }\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\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 sessionsByUser: Record = {};\n for (const [tok, sess] of Object.entries(sessions)) {\n if (!sess || !sess.username) continue;\n const u = sess.username.toLowerCase().trim();\n const isActive = sess.createdAt && (now - sess.createdAt) < SESSION_MAX_AGE;\n if (isActive) usersWithActivity.add(u);\n if (!sessionsByUser[u]) sessionsByUser[u] = [];\n sessionsByUser[u].push(tok);\n }\n\n for (const username of Object.keys(allUsers as Record)) {\n const key = username.toLowerCase().trim();\n if (usersWithActivity.has(key)) continue;\n\n await fbDelete(`users/${key}`);\n\n if (sessionsByUser[key]) {\n for (const tok of sessionsByUser[key]) {\n await fbDelete(`sessions/${tok}`);\n }\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,"_104":100},"org",{"_9":10,"_97":98,"_99":100,"_54":55,"_101":102,"_103":42},"branch",{"_35":87,"_11":88,"_22":28,"_89":45,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":12,"_96":10},"isOwned",72,"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,"_138":139,"_140":141,"_142":143,"_144":42,"_145":42,"_146":42,"_147":32,"_148":-5,"_149":-7,"_150":-7,"_151":61,"_152":42,"_153":42,"_154":-5,"_155":42,"_156":42,"_157":42,"_158":-5},"ENV",{"_109":110,"_111":112,"_113":88,"_114":115,"_116":117,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133,"_134":135,"_136":137},"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"]