[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_213":214,"_215":216},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_162":-5,"_20":163,"_22":164,"_165":166,"_167":168,"_26":169,"_24":170,"_171":-5,"_172":-5,"_173":52,"_174":175,"_176":43,"_177":-5,"_178":-5,"_179":180},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","neverstew","name","emailHole","branchName","main","version","path","emailHoleCleanup","project",{"_33":107,"_13":14,"_44":108,"_109":-5,"_110":43,"_111":112,"_113":114,"_115":-5,"_116":-5,"_117":118,"_119":72,"_120":43,"_121":-5,"_122":123,"_124":46,"_125":126,"_127":-5,"_128":-5,"_129":-5,"_130":-5,"_131":132,"_133":132,"_134":135,"_136":135,"_137":135,"_138":132,"_139":132,"_140":141,"_142":143,"_144":145,"_146":52},"tree",[55,56,57,58,59,60],"file",{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":45,"_17":46,"_47":48,"_49":50,"_51":52,"_53":-5,"_18":54},"contents",[],"upstream","pull","ahead","behind","envVars","id","bca75544-7e32-11f0-9301-0224a6c84d84","fileId","8b06011e-20c4-11f0-a01c-569c3dd06744","parentId","branchId","29edde7e-20c4-11f0-bd7c-569c3dd06744","branchVersion",19,"latest",true,"createdAt",["D",1755741682684],1,"fileType","interval","content","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}","deleted",false,"label",[19],{"_33":99,"_13":100,"_35":101,"_37":-5,"_38":39,"_40":46,"_42":43,"_44":102,"_17":103,"_47":24,"_49":104,"_51":52,"_53":-5,"_67":105,"_18":106},{"_33":92,"_13":93,"_35":94,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":95,"_17":46,"_47":85,"_49":96,"_51":52,"_53":-5,"_67":97,"_18":98},{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":89,"_17":46,"_47":48,"_49":50,"_51":52,"_53":-5,"_67":90,"_18":91},{"_33":80,"_13":81,"_35":82,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":83,"_17":84,"_47":85,"_49":86,"_51":52,"_53":-5,"_67":87,"_18":88},{"_33":70,"_13":71,"_35":72,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":73,"_17":74,"_47":75,"_49":76,"_51":52,"_53":77,"_67":78,"_18":79},{"_33":61,"_13":62,"_35":63,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":64,"_17":46,"_47":65,"_49":66,"_51":52,"_53":-5,"_67":68,"_18":69},"bca75ca6-7e32-11f0-9301-0224a6c84d84","peachGoat","8b0ca8de-20c4-11f0-9ec7-569c3dd06744",["D",1755741682684],"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}","children",[],[62],"bca75878-7e32-11f0-9301-0224a6c84d84","main.tsx","29f19ffa-20c4-11f0-bd7c-569c3dd06744",["D",1755741682684],13,"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}","emailhole",[],[71],"bca756ca-7e32-11f0-9301-0224a6c84d84","emailMigrations","689c9e46-20fe-11f0-9fd8-569c3dd06744",["D",1755741682684],2,"script","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite/main.tsx\";\n\nawait sqlite.execute(`alter table emails add column timestamp int`)",[],[81],["D",1755741682684],[],[19],"bca74ed2-7e32-11f0-9301-0224a6c84d84","blackSilkworm","8b000138-20c4-11f0-a0b5-569c3dd06744",["D",1755741682684],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite/main.tsx\";\nconsole.log(await sqlite.execute(`select * from emails`))",[],[93],"29f1d920-20c4-11f0-bd7c-569c3dd06744","README.md","29f1d9a2-20c4-11f0-bd7c-569c3dd06744",["D",1714013588029],0,"# ️📨🕳️\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",[],[100],"29ed15ca-20c4-11f0-bd7c-569c3dd06744",["D",1745468733754],"deletedAt","legacyEnvVars","privacy","unlisted","httpPrivacy","public","description","imageUrl","userId","8acb974a-4b91-4d4a-b000-6f28827b7e16","pinnedFileId","pinPreview","pinMigrated","screenshotVersion",12,"likeCount","orgId","b74060f0-0f1d-44f1-bee2-bdb9c9cf72e4","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_161":157},"org",{"_11":12,"_155":-5,"_156":157,"_117":118,"_158":159,"_160":52},"branch",{"_17":41,"_13":16,"_33":39,"_147":107,"_148":-5,"_149":-5,"_150":-5,"_151":-5,"_152":-5,"_153":14,"_154":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://secure.gravatar.com/avatar/109fa713caf4e083c57622b7c6dad365.jpg?s=200&d=identicon","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":107,"_13":14,"_44":209,"_109":-5,"_110":43,"_111":112,"_113":114,"_115":-5,"_116":-5,"_117":118,"_119":72,"_120":43,"_121":-5,"_122":123,"_124":46,"_125":126,"_127":-5,"_128":-5,"_129":-5,"_130":-5,"_131":132,"_133":132,"_134":135,"_136":135,"_137":135,"_138":132,"_139":132,"_140":210,"_142":211,"_144":212,"_146":52},[191,192,193,194,195,196],"files",[191,192,193,194,195,196],"counts",{"_182":103,"_183":84,"_184":103,"_32":185,"_186":187},[],{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":45,"_17":46,"_47":48,"_49":50,"_51":52,"_53":-5,"_18":181},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],"pulls","branches","forks",{"_188":103,"_190":103},"connections",{"_188":103,"_189":103},"count","unfilledCount","emptyCount",{"_33":99,"_13":100,"_35":101,"_37":-5,"_38":39,"_40":46,"_42":43,"_44":102,"_17":103,"_47":24,"_49":104,"_51":52,"_53":-5,"_67":207,"_18":208},{"_33":92,"_13":93,"_35":94,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":95,"_17":46,"_47":85,"_49":96,"_51":52,"_53":-5,"_67":205,"_18":206},{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":89,"_17":46,"_47":48,"_49":50,"_51":52,"_53":-5,"_67":203,"_18":204},{"_33":80,"_13":81,"_35":82,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":83,"_17":84,"_47":85,"_49":86,"_51":52,"_53":-5,"_67":201,"_18":202},{"_33":70,"_13":71,"_35":72,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":73,"_17":74,"_47":75,"_49":76,"_51":52,"_53":77,"_67":199,"_18":200},{"_33":61,"_13":62,"_35":63,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":64,"_17":46,"_47":65,"_49":66,"_51":52,"_53":-5,"_67":197,"_18":198},[],[62],[],[71],[],[81],[],[19],[],[93],[],[100],["D",1745468733754],{"_11":12,"_161":157},{"_11":12,"_155":-5,"_156":157,"_117":118,"_158":159,"_160":52},{"_17":41,"_13":16,"_33":39,"_147":107,"_148":-5,"_149":-5,"_150":-5,"_151":-5,"_152":-5,"_153":14,"_154":12},"ctx",{"_140":-5,"_178":246,"_247":248,"_249":250,"_251":52,"_252":52,"_253":52,"_254":43,"_255":-5,"_256":-7,"_257":-7,"_258":103,"_259":52,"_260":52,"_261":-5,"_262":52,"_263":52,"_264":52,"_265":-5},"ENV",{"_217":218,"_219":220,"_221":16,"_222":223,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","c73f21da490985bff19c279eb0e09db24d688e4f","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"]