Email Inbox

Email Inbox

\n `;\n\n if (emails.length === 0) {\n html += `

No emails found

`;\n } else {\n html += `

\n
\n ${email.from}\n ${timeStr}\n
\n
${email.subject}
\n
\n ${statusText}\n
\n

\";\n }\n\n html += `\n \n \n \n `;\n\n return html;\n}\n\nexport default async function server(request: Request): Promise {\n try {\n const emails = await fetchEmails();\n const html = renderEmailList(emails);\n\n return new Response(html, {\n headers: {\n \"Content-Type\": \"text/html\",\n \"Cache-Control\": \"no-cache, no-store, must-revalidate\",\n },\n });\n } catch (error) {\n console.error(\"Error rendering emails:\", error);\n return new Response(\"Internal Server Error\", { status: 500 });\n }\n}\n","label",[132],"2e6e6e3e-0dc6-11f0-be6d-569c3dd06744","reciever","2b544ae8-0d17-11f0-b79f-569c3dd06744",50,["D",1743380528205],22,"email","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nconst SCHEMA_VERSION = 8; // Increment when schema changes\n\nexport default async function(e) {\n try {\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS emails_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n \"to\" TEXT NOT NULL,\n cc TEXT,\n bcc TEXT,\n \"from\" TEXT NOT NULL,\n subject TEXT,\n text TEXT,\n html TEXT,\n time DATETIME DEFAULT CURRENT_TIMESTAMP,\n read BOOLEAN DEFAULT 0\n )`,\n );\n\n await sqlite.execute(\n {\n sql: `INSERT INTO emails_${SCHEMA_VERSION} (\"to\", cc, bcc, \"from\", subject, text, html)\n VALUES (:to,:cc, :bcc, :from,:subject, :text, :html)`,\n args: {\n to: e.to,\n cc: e.cc || \"\",\n bcc: e.bcc || \"\",\n from: e.from,\n subject: e.subject || \"\",\n html: e.html || \"\",\n text: e.text || \"\",\n },\n },\n );\n\n return { success: true };\n } catch (error) {\n console.error(\"Failed to save email:\", error);\n // throw new Error(\"Failed to save email to database\");\n }\n}",[144],"a908a1b4-531c-11f0-80bf-f69ea79377d9","deno.json","a908a25e-531c-11f0-80bf-f69ea79377d9",56,["D",1751004300851],0,"{\n \"$schema\": \"https://raw.githubusercontent.com/denoland/deno/348900b8b79f4a434cab4c74b3bc8d4d2fa8ee74/cli/schemas/config-file.v1.json\",\n \"lock\": false,\n \"compilerOptions\": {\n \"noImplicitAny\": false,\n \"strict\": false,\n \"types\": [\n \"https://www.val.town/types/valtown.d.ts\"\n ],\n \"lib\": [\n \"dom\",\n \"dom.iterable\",\n \"dom.asynciterable\",\n \"deno.ns\",\n \"deno.unstable\"\n ]\n },\n \"lint\": {\n \"files\": {\n \"include\": [\n \"deno:/https/esm.town/**/*\"\n ]\n },\n \"rules\": {\n \"exclude\": [\n \"no-explicit-any\"\n ]\n }\n },\n \"node_modules_dir\": false,\n \"experimental\": {\n \"unstable-node-globals\": true,\n \"unstable-temporal\": true,\n \"unstable-worker-options\": true,\n \"unstable-sloppy-imports\": true\n }\n}",[153],"a90dceaa-531c-11f0-8ee1-f69ea79377d9",".vtignore","a90dcf5e-531c-11f0-8ee1-f69ea79377d9",57,["D",1751004300851],".git\n.vscode\n.cursorrules\n.DS_Store\nnode_modules\nvendor",[161],"eda5e21a-5320-11f0-83c0-f69ea79377d9","shared","eda5e2ce-5320-11f0-83c0-f69ea79377d9",59,["D",1751006133955],[168],"eddb73b2-5320-11f0-9534-f69ea79377d9","memory-bank","eddb745c-5320-11f0-9534-f69ea79377d9",60,["D",1751006134306],[174],"pulls","branches","forks","envVars",{"_186":157,"_188":157},"connections",{"_186":157,"_187":157},"count","unfilledCount","emptyCount",{"_41":173,"_31":174,"_29":175,"_134":-5,"_39":40,"_38":176,"_136":56,"_36":216,"_13":157,"_33":34,"_35":-5,"_23":24,"_141":-5,"_197":217,"_26":218},{"_41":167,"_31":168,"_29":169,"_134":-5,"_39":40,"_38":170,"_136":56,"_36":213,"_13":157,"_33":34,"_35":-5,"_23":24,"_141":-5,"_197":214,"_26":215},{"_41":209,"_31":32,"_29":30,"_134":169,"_39":40,"_38":14,"_136":56,"_36":210,"_13":157,"_33":34,"_35":-5,"_23":24,"_141":-5,"_197":211,"_26":212},{"_41":160,"_31":161,"_29":162,"_134":-5,"_39":40,"_38":163,"_136":56,"_36":206,"_13":157,"_33":20,"_35":165,"_23":24,"_141":-5,"_197":207,"_26":208},{"_41":152,"_31":153,"_29":154,"_134":-5,"_39":40,"_38":155,"_136":24,"_36":203,"_13":157,"_33":20,"_35":158,"_23":24,"_141":-5,"_197":204,"_26":205},{"_41":143,"_31":144,"_29":145,"_134":-5,"_39":40,"_38":146,"_136":24,"_36":200,"_13":148,"_33":149,"_35":150,"_23":24,"_141":-5,"_197":201,"_26":202},{"_41":131,"_31":132,"_29":133,"_134":-5,"_39":40,"_38":135,"_136":24,"_36":196,"_13":138,"_33":139,"_35":140,"_23":24,"_141":-5,"_197":198,"_26":199},["D",1751004300853],"children",[],[132],["D",1743380528205],[],[144],["D",1751004300851],[],[153],["D",1751004300851],[],[161],"ee0a8c4c-5320-11f0-8865-f69ea79377d9",["D",1751006134617],[],[168,32],["D",1751006133955],[191],[168],["D",1751006134306],[],[174],["D",1743305327329],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":52,"_99":100,"_101":24},{"_13":84,"_31":85,"_41":40,"_86":42,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":43,"_93":94},"ctx",{"_77":-5,"_122":256,"_257":258,"_259":260,"_261":24,"_262":24,"_263":24,"_264":56,"_265":-5,"_266":-7,"_267":-7,"_268":157,"_269":24,"_270":24,"_271":-5,"_272":24,"_273":24,"_274":24,"_275":-5},"ENV",{"_227":228,"_229":230,"_231":85,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","a3e067d4463eea85f6334f8e583e8516ae58c4f6","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"]

Diff · v61