Email Inbox

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_235":236,"_237":238},"routes/_app.x.$handle.$name",{"_95":94,"_31":43,"_103":85,"_26":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":24,"_118":119,"_120":56,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_31":43,"_36":44,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":-5,"_51":-5,"_18":52,"_53":54,"_55":56,"_57":56,"_58":59,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":24},"version",62,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":27,"_32":33,"_34":35,"_36":37,"_38":14,"_39":40,"_23":24},"previous","deleted",false,"deletedHere","path","reciever.ts","latestPath","fileId","ee36700a-5320-11f0-88fb-f69ea79377d9","name","fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite?v=6\";\nimport { drizzle } from \"npm:drizzle-orm/libsql\";\nimport { migrate } from \"npm:drizzle-orm/libsql/migrator\";\nimport { emails } from \"./shared/db/schema.ts\";\n\nexport default async function(e: Email) {\n try {\n // biome-ignore lint/suspicious/noExplicitAny: \n const db = drizzle(sqlite as any);\n await migrate(db, { migrationsFolder: \"./drizzle\" });\n\n await db.insert(emails).values({\n to: e.to,\n cc: e.cc || \"\",\n bcc: e.bcc || \"\",\n from: e.from,\n subject: e.subject || \"\",\n text: e.text || \"\",\n html: e.html || \"\"\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}\n","createdAt",["D",1751006134904],"branchVersion","branchId","17369570-0d17-11f0-ac1c-569c3dd06744","id","173638f0-0d17-11f0-ac1c-569c3dd06744","Emails",["D",1743305327329],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","6ee8d4be-4952-42e0-9af1-3cd70a4b1a0d","pinnedFileId","289806e4-540e-11f0-aa91-f69ea79377d9","pinPreview",true,"pinMigrated","screenshotVersion",55,"likeCount",1,"orgId","01e8fd10-daeb-42d8-b8ad-92b2960c546c","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":52,"_99":100,"_101":24},"branch",{"_13":84,"_31":85,"_41":40,"_86":42,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":43,"_93":94},"isOwned",143,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","avycado13","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yaWFYb0QxQXRnUmdpaTI1M05nS1prc1NXVVkifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_41":42,"_31":43,"_36":231,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":-5,"_51":-5,"_18":52,"_53":54,"_55":56,"_57":56,"_58":59,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":232,"_79":233,"_81":234,"_83":24},"tree",[194,195,197,198,199,200,201],"files",[194,195,196,197,198,199,200,201],"counts",{"_184":146,"_185":61,"_186":146,"_187":188,"_189":190},"contents",[125,126,127,128,129,130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":178,"_31":179,"_29":180,"_135":-5,"_39":40,"_38":181,"_137":56,"_36":182,"_13":146,"_32":176,"_34":-5,"_23":24,"_142":-5,"_26":183},{"_41":171,"_31":172,"_29":173,"_135":-5,"_39":40,"_38":174,"_137":56,"_36":175,"_13":146,"_32":176,"_34":-5,"_23":24,"_142":-5,"_26":177},{"_41":164,"_31":165,"_29":166,"_135":-5,"_39":40,"_38":167,"_137":56,"_36":168,"_13":146,"_32":20,"_34":169,"_23":24,"_142":-5,"_26":170},{"_41":157,"_31":158,"_29":159,"_135":-5,"_39":40,"_38":160,"_137":24,"_36":161,"_13":146,"_32":20,"_34":162,"_23":24,"_142":-5,"_26":163},{"_41":148,"_31":149,"_29":150,"_135":-5,"_39":40,"_38":151,"_137":24,"_36":152,"_13":153,"_32":154,"_34":155,"_23":24,"_142":-5,"_26":156},{"_41":144,"_31":27,"_29":30,"_135":-5,"_39":40,"_38":14,"_137":24,"_36":145,"_13":146,"_32":33,"_34":35,"_23":24,"_142":94,"_26":147},{"_41":132,"_31":133,"_29":134,"_135":-5,"_39":40,"_38":136,"_137":24,"_36":138,"_13":139,"_32":140,"_34":141,"_23":24,"_142":-5,"_26":143},"a91619f2-531c-11f0-bfee-f69ea79377d9","webmail.ts","810adf6a-0d17-11f0-8812-569c3dd06744","parentId",58,"latest",["D",1751004300853],30,"http","/** Webmail application for Val Town */\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nconst SCHEMA_VERSION = 8; // Increment when schema changes\n\ninterface Email {\n id: number;\n to: string;\n cc?: string;\n bcc?: string;\n from: string;\n subject: string;\n time: string;\n read: boolean;\n}\n\nasync function ensureEmailTable() {\n await sqlite.execute(`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 NOT NULL,\n text TEXT,\n html TEXT,\n time DATETIME DEFAULT CURRENT_TIMESTAMP,\n read BOOLEAN DEFAULT 0\n )`);\n}\n\nasync function fetchEmails(inputLimit?: number, inputOffset?: number): Promise {\n await ensureEmailTable();\n\n // Explicitly convert and validate parameters\n const limit = Math.max(1, Math.min(100, Math.floor(Number(inputLimit) || 20)));\n const offset = Math.max(0, Math.floor(Number(inputOffset) || 0));\n\n try {\n const result = await sqlite.execute({\n sql: `SELECT id, \"to\", cc, bcc, \"from\", subject, time, read \n FROM emails_${SCHEMA_VERSION} \n ORDER BY time DESC \n LIMIT ? OFFSET ?`,\n args: [limit, offset],\n });\n return result.rows as Email[];\n } catch (error) {\n console.error(\"Error in fetchEmails:\", error);\n throw error;\n }\n}\n\nfunction renderEmailList(emails: Email[]): string {\n let html = `\n \n \n \n \n \n Email Inbox\n \n \n \n

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",[133],"ee366f38-5320-11f0-88fb-f69ea79377d9",["D",1751006134904],0,[27],"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}",[149],"a908a1b4-531c-11f0-80bf-f69ea79377d9","deno.json","a908a25e-531c-11f0-80bf-f69ea79377d9",56,["D",1751004300851],"{\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}",[158],"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",[165],"eda5e21a-5320-11f0-83c0-f69ea79377d9","shared","eda5e2ce-5320-11f0-83c0-f69ea79377d9",59,["D",1751006133955],"directory",[172],"eddb73b2-5320-11f0-9534-f69ea79377d9","memory-bank","eddb745c-5320-11f0-9534-f69ea79377d9",60,["D",1751006134306],[179],"pulls","branches","forks","envVars",{"_191":146,"_193":146},"connections",{"_191":146,"_192":146},"count","unfilledCount","emptyCount",{"_41":178,"_31":179,"_29":180,"_135":-5,"_39":40,"_38":181,"_137":56,"_36":228,"_13":146,"_32":176,"_34":-5,"_23":24,"_142":-5,"_203":229,"_26":230},{"_41":171,"_31":172,"_29":173,"_135":-5,"_39":40,"_38":174,"_137":56,"_36":225,"_13":146,"_32":176,"_34":-5,"_23":24,"_142":-5,"_203":226,"_26":227},{"_41":218,"_31":219,"_29":220,"_135":173,"_39":40,"_38":221,"_137":56,"_36":222,"_13":146,"_32":176,"_34":-5,"_23":24,"_142":-5,"_203":223,"_26":224},{"_41":164,"_31":165,"_29":166,"_135":-5,"_39":40,"_38":167,"_137":56,"_36":215,"_13":146,"_32":20,"_34":169,"_23":24,"_142":-5,"_203":216,"_26":217},{"_41":157,"_31":158,"_29":159,"_135":-5,"_39":40,"_38":160,"_137":24,"_36":212,"_13":146,"_32":20,"_34":162,"_23":24,"_142":-5,"_203":213,"_26":214},{"_41":148,"_31":149,"_29":150,"_135":-5,"_39":40,"_38":151,"_137":24,"_36":209,"_13":153,"_32":154,"_34":155,"_23":24,"_142":-5,"_203":210,"_26":211},{"_41":144,"_31":27,"_29":30,"_135":-5,"_39":40,"_38":14,"_137":24,"_36":206,"_13":146,"_32":33,"_34":35,"_23":24,"_142":94,"_203":207,"_26":208},{"_41":132,"_31":133,"_29":134,"_135":-5,"_39":40,"_38":136,"_137":24,"_36":202,"_13":139,"_32":140,"_34":141,"_23":24,"_142":-5,"_203":204,"_26":205},["D",1751004300853],"children",[],[133],["D",1751006134904],[],[27],["D",1743380528205],[],[149],["D",1751004300851],[],[158],["D",1751004300851],[],[165],"ee0a8c4c-5320-11f0-8865-f69ea79377d9","db","ee0a8d0a-5320-11f0-8865-f69ea79377d9",61,["D",1751006134617],[],[172,219],["D",1751006133955],[196],[172],["D",1751006134306],[],[179],["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":268,"_269":270,"_271":272,"_273":24,"_274":24,"_275":24,"_276":56,"_277":-5,"_278":-7,"_279":-7,"_280":146,"_281":24,"_282":24,"_283":-5,"_284":24,"_285":24,"_286":24,"_287":-5},"ENV",{"_239":240,"_241":242,"_243":85,"_244":245,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257,"_258":259,"_260":261,"_262":263,"_264":265,"_266":267},"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 · v62