Email Inbox

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_245":246,"_247":248},"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",63,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":20,"_34":35,"_36":37,"_38":14,"_39":40,"_23":24},"previous","deleted",false,"deletedHere","path","memory-bank/techContext.md","latestPath","fileId","ee393704-5320-11f0-bc0d-f69ea79377d9","name","techContext.md","fileType","content","# Tech Context\n\n## Technologies Used\n- **Val Town:** The primary platform for hosting and running the webmail application, providing serverless capabilities for HTTP and email triggers.\n- **Deno:** The runtime environment used by Val Town for executing TypeScript code, ensuring compatibility with modern JavaScript features.\n- **SQLite:** The database solution provided by Val Town for persistent storage of email data.\n- **Drizzle ORM:** An Object-Relational Mapping tool used for type-safe database interactions with SQLite, enhancing maintainability over raw SQL.\n- **TypeScript:** The programming language used for writing the application, ensuring type safety and better development experience.\n- **@libsql/client:** A library used with Drizzle ORM to interact with SQLite databases in a way compatible with Val Town's environment.\n\n## Development Setup\n- **Val Town Environment:** Scripts are deployed as vals within Val Town, with `webmail.ts` serving as an HTTP endpoint and `reciever.ts` as an email trigger.\n- **Code Structure:** Organized into `webmail.ts` for frontend and data fetching, `reciever.ts` for email processing, and `shared/db/schema.ts` for database schema definitions.\n\n## Technical Constraints\n- **Serverless Limitations:** Must operate within Val Town's serverless constraints, affecting how migrations and file management are handled.\n- **SQLite Compatibility:** Need to ensure database operations are compatible with Val Town's SQLite implementation, using `@libsql/client` for connectivity.\n\n## Dependencies\n- **Val Town Standard Libraries:** Utilizes `sqlite` from `https://esm.town/v/std/sqlite` for initial database access.\n- **Drizzle ORM Packages:** Includes `npm:drizzle-orm`, `npm:drizzle-orm/libsql`, and `npm:@libsql/client` for ORM functionality and database connectivity.\n- **No External Secrets:** Following Val Town best practices, no API keys or secrets are hardcoded; environment variables would be used if needed.\n\n## Tool Usage Patterns\n- **Drizzle ORM Query Builder:** Used for constructing type-safe queries and inserts in both `webmail.ts` and `reciever.ts`.\n- **Migration Management:** Drizzle ORM's migration system is set up for schema management, pending user-provided migration files or alternative strategies.\n","createdAt",["D",1751006134907],"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":241,"_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":242,"_79":243,"_81":244,"_83":24},"tree",[199,201,203,204,205,206,207],"files",[199,200,201,202,203,204,205,206,207],"counts",{"_189":149,"_190":61,"_191":149,"_192":193,"_194":195},"contents",[125,126,127,128,129,130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":183,"_31":184,"_29":185,"_135":-5,"_39":40,"_38":186,"_137":56,"_36":187,"_13":149,"_33":181,"_34":-5,"_23":24,"_142":-5,"_26":188},{"_41":176,"_31":177,"_29":178,"_135":-5,"_39":40,"_38":179,"_137":56,"_36":180,"_13":149,"_33":181,"_34":-5,"_23":24,"_142":-5,"_26":182},{"_41":169,"_31":170,"_29":171,"_135":-5,"_39":40,"_38":172,"_137":56,"_36":173,"_13":149,"_33":20,"_34":174,"_23":24,"_142":-5,"_26":175},{"_41":162,"_31":163,"_29":164,"_135":-5,"_39":40,"_38":165,"_137":24,"_36":166,"_13":149,"_33":20,"_34":167,"_23":24,"_142":-5,"_26":168},{"_41":153,"_31":154,"_29":155,"_135":-5,"_39":40,"_38":156,"_137":24,"_36":157,"_13":158,"_33":159,"_34":160,"_23":24,"_142":-5,"_26":161},{"_41":144,"_31":145,"_29":146,"_135":-5,"_39":40,"_38":147,"_137":24,"_36":148,"_13":149,"_33":150,"_34":151,"_23":24,"_142":94,"_26":152},{"_41":132,"_31":133,"_29":134,"_135":-5,"_39":40,"_38":136,"_137":24,"_36":138,"_13":139,"_33":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","reciever.ts","ee36700a-5320-11f0-88fb-f69ea79377d9",62,["D",1751006134904],0,"script","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",[145],"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}",[154],"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}",[163],"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",[170],"eda5e21a-5320-11f0-83c0-f69ea79377d9","shared","eda5e2ce-5320-11f0-83c0-f69ea79377d9",59,["D",1751006133955],"directory",[177],"eddb73b2-5320-11f0-9534-f69ea79377d9","memory-bank","eddb745c-5320-11f0-9534-f69ea79377d9",60,["D",1751006134306],[184],"pulls","branches","forks","envVars",{"_196":149,"_198":149},"connections",{"_196":149,"_197":149},"count","unfilledCount","emptyCount",{"_41":183,"_31":184,"_29":185,"_135":-5,"_39":40,"_38":186,"_137":56,"_36":238,"_13":149,"_33":181,"_34":-5,"_23":24,"_142":-5,"_209":239,"_26":240},{"_41":234,"_31":32,"_29":30,"_135":185,"_39":40,"_38":14,"_137":24,"_36":235,"_13":149,"_33":20,"_34":35,"_23":24,"_142":-5,"_209":236,"_26":237},{"_41":176,"_31":177,"_29":178,"_135":-5,"_39":40,"_38":179,"_137":56,"_36":231,"_13":149,"_33":181,"_34":-5,"_23":24,"_142":-5,"_209":232,"_26":233},{"_41":224,"_31":225,"_29":226,"_135":178,"_39":40,"_38":227,"_137":56,"_36":228,"_13":149,"_33":181,"_34":-5,"_23":24,"_142":-5,"_209":229,"_26":230},{"_41":169,"_31":170,"_29":171,"_135":-5,"_39":40,"_38":172,"_137":56,"_36":221,"_13":149,"_33":20,"_34":174,"_23":24,"_142":-5,"_209":222,"_26":223},{"_41":162,"_31":163,"_29":164,"_135":-5,"_39":40,"_38":165,"_137":24,"_36":218,"_13":149,"_33":20,"_34":167,"_23":24,"_142":-5,"_209":219,"_26":220},{"_41":153,"_31":154,"_29":155,"_135":-5,"_39":40,"_38":156,"_137":24,"_36":215,"_13":158,"_33":159,"_34":160,"_23":24,"_142":-5,"_209":216,"_26":217},{"_41":144,"_31":145,"_29":146,"_135":-5,"_39":40,"_38":147,"_137":24,"_36":212,"_13":149,"_33":150,"_34":151,"_23":24,"_142":94,"_209":213,"_26":214},{"_41":132,"_31":133,"_29":134,"_135":-5,"_39":40,"_38":136,"_137":24,"_36":208,"_13":139,"_33":140,"_34":141,"_23":24,"_142":-5,"_209":210,"_26":211},["D",1751004300853],"children",[],[133],["D",1751006134904],[],[145],["D",1743380528205],[],[154],["D",1751004300851],[],[163],["D",1751004300851],[],[170],"ee0a8c4c-5320-11f0-8865-f69ea79377d9","db","ee0a8d0a-5320-11f0-8865-f69ea79377d9",61,["D",1751006134617],[],[177,225],["D",1751006133955],[202],[177],"ee393650-5320-11f0-bc0d-f69ea79377d9",["D",1751006134907],[],[184,32],["D",1751006134306],[200],[184],["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":278,"_279":280,"_281":282,"_283":24,"_284":24,"_285":24,"_286":56,"_287":-5,"_288":-7,"_289":-7,"_290":149,"_291":24,"_292":24,"_293":-5,"_294":24,"_295":24,"_296":24,"_297":-5},"ENV",{"_249":250,"_251":252,"_253":85,"_254":255,"_256":257,"_258":259,"_260":261,"_262":263,"_264":265,"_266":267,"_268":269,"_270":271,"_272":273,"_274":275,"_276":277},"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 · v63