[{"_1":2,"_291":-5,"_292":-5},"loaderData",{"_3":4,"_91":92,"_252":253},"root",{"_5":6,"_34":35,"_64":65},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":22,"_29":22,"_30":22,"_31":32,"_33":22},"auth",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"tokenType","session_token","sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","ENV",{"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61,"_62":63},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","40d33e9c7bacd1f32863183408ee0e4ae3e5f5a3","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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","API_URL","https://api.val.town","clerkState",{"_66":67},"__internal_clerk_state",{"_68":69,"_70":45,"_71":72,"_73":72,"_74":22,"_75":72,"_76":72,"_77":72,"_78":72,"_79":80,"_89":22,"_90":22},"__clerk_ssr_state",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_81":22,"_21":22,"_82":72,"_83":84,"_85":72,"_86":45,"_87":22,"_88":72},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/_app.x.$handle.$name",{"_93":94,"_95":96,"_97":98,"_99":100,"_101":102,"_103":104,"_155":156,"_224":225,"_226":227,"_235":236,"_168":237,"_240":-5,"_241":242,"_248":22,"_249":22,"_250":251},"handle","neverstew","name","emailHole","branchName","fix-sqlite","path","main.tsx","version",15,"project",{"_105":106,"_95":96,"_107":108,"_109":-5,"_110":111,"_112":113,"_114":-5,"_115":-5,"_14":116,"_117":118,"_119":111,"_120":121,"_122":123,"_16":124,"_125":126,"_127":126,"_128":129,"_130":129,"_131":129,"_132":126,"_133":126,"_23":134,"_137":138,"_140":141,"_154":22},"id","29ed15ca-20c4-11f0-bd7c-569c3dd06744","createdAt",["D",1745468733754],"deletedAt","legacyEnvVars",true,"privacy","unlisted","description","imageUrl","8acb974a-4b91-4d4a-b000-6f28827b7e16","pinnedFileId","29f19ffa-20c4-11f0-bd7c-569c3dd06744","pinPreview","screenshotVersion",12,"likeCount",1,"b74060f0-0f1d-44f1-bee2-bdb9c9cf72e4","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_135":136},"profileImageUrl","https://secure.gravatar.com/avatar/109fa713caf4e083c57622b7c6dad365.jpg?s=200&d=identicon","org",{"_93":94,"_139":136},"avatar","branch",{"_101":142,"_95":98,"_105":143,"_144":106,"_145":146,"_147":148,"_149":113,"_150":106,"_151":124,"_152":96,"_153":94},24,"71e540e2-7e15-11f0-8c01-0224a6c84d84","projectId","forkedBranchId","29edde7e-20c4-11f0-bd7c-569c3dd06744","forkedBranchVersion",19,"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","tree",[157,176,186,197,206,214],{"_105":158,"_95":159,"_160":161,"_162":-5,"_163":143,"_164":123,"_165":111,"_107":166,"_101":32,"_167":168,"_169":170,"_171":22,"_172":-5,"_173":174,"_99":175},"71f6da00-7e15-11f0-9ab8-0224a6c84d84","README.md","fileId","0198c99c-0490-776c-837d-2d6b9bdcb310","parentId","branchId","branchVersion","latest",["D",1755729101974],"fileType","file","content","# ️📨🕳️\n\nIt's the last fifteen minutes of fame for your emails (unless a new email arrives...)\n\nSend your landing page signups, WiFi sign-ins and other junk here to never be troubled again.\n\nGot a sensitive one? No problem, just send yourself another email!\n\n## Playground \n[Email me!](mailto:neverstew.peachGoat@valtown.email)\n\n## Get Your Own\n### Related\n[database migrations](https://www.val.town/v/neverstew/emailMigrations)\n\n[email handler](https://www.val.town/v/neverstew/peachGoat)\n\n[cleanup](https://www.val.town/v/neverstew/emailHoleCleanup)\n### Steps\nFork this and the two vals above. Then, run the database migrations in order. \n\nTroublemakers could just use this one...\n\nMigrated from folder: emailHole/emailHole","deleted","label","children",[],[159],{"_105":177,"_95":178,"_160":179,"_162":-5,"_163":143,"_164":180,"_165":22,"_107":181,"_101":123,"_167":182,"_169":183,"_171":22,"_172":-5,"_173":184,"_99":185},"17b94a54-7e16-11f0-9c84-0224a6c84d84","blackSilkworm","0198c99c-0493-75b1-8b3d-3a22ca1f43b0",11,["D",1755729380068],"script","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite/main.tsx\";\nconsole.log(await sqlite.execute(`select * from emails`))",[],[178],{"_105":187,"_95":188,"_160":189,"_162":-5,"_163":143,"_164":190,"_165":22,"_107":191,"_101":192,"_167":193,"_169":194,"_171":22,"_172":-5,"_173":195,"_99":196},"0d171b8a-7e16-11f0-a5d6-0224a6c84d84","emailHoleCleanup","0198c99c-0493-75b1-8b3d-3d6da0453b82",10,["D",1755729362235],3,"interval","import { startOfDay } from \"https://esm.sh/date-fns/startOfDay.mjs\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite/main.tsx\";\n\nexport default async function (interval: Interval) {\n const endPoint = startOfDay(new Date());\n await sqlite.execute(`delete from emails where timestamp < ${endPoint.getTime()}`)\n}",[],[188],{"_105":198,"_95":199,"_160":200,"_162":-5,"_163":143,"_164":201,"_165":22,"_107":202,"_101":123,"_167":182,"_169":203,"_171":22,"_172":-5,"_173":204,"_99":205},"fe49de30-7e15-11f0-a5d6-0224a6c84d84","emailMigrations","0198c99c-0493-75b1-8b3d-40062439d269",7,["D",1755729337395],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite/main.tsx\";\n\nawait sqlite.execute(`alter table emails add column timestamp int`)",[],[199],{"_105":207,"_95":100,"_160":208,"_162":-5,"_163":143,"_164":102,"_165":22,"_107":209,"_101":201,"_167":210,"_169":211,"_171":22,"_172":-5,"_173":212,"_99":213},"59350ba2-7e17-11f0-afcc-0224a6c84d84","0198c99c-0493-75b1-8b3d-47362330ca1b",["D",1755729919433],"http","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite/main.tsx\";\nimport { emailAddress, parseVal } from \"https://esm.town/v/std/utils/index.ts\";\n\nconst MAIN_EMAIL = \"neverstew.peachGoat@valtown.email\";\nconst EMAIL = parseVal(import.meta.url).branch === \"main\"\n ? MAIN_EMAIL\n : await emailAddress(\"/peachGoat\");\n\nconst DEFAULT = `\n\n\n\n\n\n\nNO EMAILS IN LAST 15 MINUTES
\nEmail me!\n\n\n`;\nexport default async function (req: Request): Promise {\n const now = new Date().getTime();\n const fifteenMins = 15 * 60 * 1000;\n const { rows: [latestEmail] } = await sqlite.execute(\n `select * from emails where timestamp > ? order by timestamp desc limit 1`,\n [now - fifteenMins],\n );\n return new Response(latestEmail?.content || DEFAULT, {\n headers: { \"Content-Type\": \"text/html\" },\n });\n}",[],[100],{"_105":215,"_95":216,"_160":217,"_162":-5,"_163":143,"_164":121,"_165":22,"_107":218,"_101":219,"_167":220,"_169":221,"_171":22,"_172":-5,"_173":222,"_99":223},"51312504-7e16-11f0-8bd6-0224a6c84d84","peachGoat","0198c99c-0493-75b1-8b3d-4a7a8a764ae6",["D",1755729476489],2,"email","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite/main.tsx\";\n\nexport default async function(e: Email) {\n console.log(e)\n await sqlite.execute(`insert into emails (content, timestamp) values (? , ?)`, [e.html || e.text, new Date().getTime() ]);\n}",[],[216],"files",[157,176,186,197,206,214],"counts",{"_228":32,"_229":219,"_230":32,"_231":232},"pulls","branches","forks","envVars",{"_233":32,"_234":32},"count","emptyCount","contents",[],{"_105":207,"_95":100,"_160":208,"_162":-5,"_163":143,"_164":102,"_165":22,"_107":238,"_101":201,"_167":210,"_169":211,"_171":22,"_172":-5,"_99":239},["D",1755729919433],[100],"upstreamProject","upstreamBranch",{"_105":146,"_107":243,"_244":245,"_95":43,"_144":106,"_101":148,"_145":-5,"_147":-5,"_246":247,"_109":-5,"_154":22,"_112":113,"_153":94,"_16":124,"_152":96},["D",1745468733754],"updatedAt",["D",1755741682684],"lockfileKey","1755744011517-esm.town_v_neverstew_emailHole@19-main","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.version.$version.code.$",{"_93":94,"_95":96,"_97":98,"_101":102,"_99":100,"_103":254,"_155":259,"_224":278,"_168":279,"_235":281,"_282":283,"_286":-5,"_287":32,"_288":32,"_289":290},{"_105":106,"_95":96,"_107":255,"_109":-5,"_110":111,"_112":113,"_114":-5,"_115":-5,"_14":116,"_117":118,"_119":111,"_120":121,"_122":123,"_16":124,"_125":126,"_127":126,"_128":129,"_130":129,"_131":129,"_132":126,"_133":126,"_23":256,"_137":257,"_140":258,"_154":22},["D",1745468733754],{"_93":94,"_135":136},{"_93":94,"_139":136},{"_101":142,"_95":98,"_105":143,"_144":106,"_145":146,"_147":148,"_149":113,"_150":106,"_151":124,"_152":96,"_153":94},[260,263,266,269,272,275],{"_105":158,"_95":159,"_160":161,"_162":-5,"_163":143,"_164":123,"_165":111,"_107":166,"_101":32,"_167":168,"_169":170,"_171":22,"_172":-5,"_173":261,"_99":262},[],[159],{"_105":177,"_95":178,"_160":179,"_162":-5,"_163":143,"_164":180,"_165":22,"_107":181,"_101":123,"_167":182,"_169":183,"_171":22,"_172":-5,"_173":264,"_99":265},[],[178],{"_105":187,"_95":188,"_160":189,"_162":-5,"_163":143,"_164":190,"_165":22,"_107":191,"_101":192,"_167":193,"_169":194,"_171":22,"_172":-5,"_173":267,"_99":268},[],[188],{"_105":198,"_95":199,"_160":200,"_162":-5,"_163":143,"_164":201,"_165":22,"_107":202,"_101":123,"_167":182,"_169":203,"_171":22,"_172":-5,"_173":270,"_99":271},[],[199],{"_105":207,"_95":100,"_160":208,"_162":-5,"_163":143,"_164":102,"_165":22,"_107":209,"_101":201,"_167":210,"_169":211,"_171":22,"_172":-5,"_173":273,"_99":274},[],[100],{"_105":215,"_95":216,"_160":217,"_162":-5,"_163":143,"_164":121,"_165":22,"_107":218,"_101":219,"_167":220,"_169":221,"_171":22,"_172":-5,"_173":276,"_99":277},[],[216],[260,263,266,269,272,275],{"_105":207,"_95":100,"_160":208,"_162":-5,"_163":143,"_164":102,"_165":22,"_107":238,"_101":201,"_167":210,"_169":211,"_171":22,"_172":-5,"_99":280},[100],[],"upstream",{"_105":146,"_107":284,"_244":285,"_95":43,"_144":106,"_101":148,"_145":-5,"_147":-5,"_246":247,"_109":-5,"_154":22,"_112":113,"_153":94,"_16":124,"_152":96},["D",1745468733754],["D",1755741682684],"pull","ahead","behind","templates",[],"actionData","errors"]