Email Inbox

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_385":386,"_387":388},"routes/_app.x.$handle.$name",{"_97":96,"_32":45,"_105":87,"_27":106,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":25,"_120":121,"_122":58,"_123":-5,"_124":-5,"_125":126},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":58,"_60":61,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":25},"version",118,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","reciever.ts","latestPath","fileId","ee36700a-5320-11f0-88fb-f69ea79377d9","name","fileType","email","content","import { sqlite } from \"https://esm.town/v/std/sqlite?v=6\";\nimport { drizzle } from \"npm:drizzle-orm/libsql\";\nimport { emails } from \"./shared/db/schema.ts\";\nimport { OpenAI } from \"https://esm.town/v/std/openai?v=5\";\nimport { email } from \"https://esm.town/v/std/email?v=13\";\n\nconst openai = new OpenAI();\n\nexport default async function (e: Email) {\n\ttry {\n\t\t// biome-ignore lint/suspicious/noExplicitAny: \n\t\tconst db = drizzle(sqlite as any);\n\n\t\tawait db.insert(emails).values({\n\t\t\tto: e.to,\n\t\t\tcc: e.cc || \"\",\n\t\t\tbcc: e.bcc || \"\",\n\t\t\tfrom: e.from,\n\t\t\tsubject: e.subject || \"\",\n\t\t\ttext: e.text || \"\",\n\t\t\thtml: e.html || \"\",\n\t\t});\n\n\t\tconst response = await openai.chat.completions.create({\n\t\t\tmodel: \"gpt-4\",\n\t\t\tmessages: [\n\t\t\t\t{\n\t\t\t\t\trole: \"system\",\n\t\t\t\t\tcontent:\n\t\t\t\t\t\t\"You are an AI that classifies whether an email is important to the user so it can be forwarded to their main inbox. Reply with 'Important' or 'Not Important' and a one-line reason.\",\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\trole: \"user\",\n\t\t\t\t\tcontent: `Is the following email important?\\n\\n${e.text}\\n\\n${e.html}`,\n\t\t\t\t},\n\t\t\t],\n\t\t\ttemperature: 0,\n\t\t});\n\t\tconst result = response.choices[0].message.content;\n\t\tif (result.trim().toLowerCase().startsWith(\"important\")) {\n\t\t\tconsole.log(\"✅ This email is important.\");\n\t\t\tawait email({\n\t\t\t\tsubject: `From the inbox: ${e.subject}`,\n\t\t\t\ttext: `From: ${e.from}\\nTo: ${e.to}\\n CC: ${e.cc}\\n BCC: ${e.bcc}\\n\\n ${e.text} \\n\\n -- The system flagged this as important based on the following:\\n${result}`,\n\t\t\t\thtml: e.html,\n\t\t\t\treplyTo: e.from,\n\t\t\t\tfrom: { email: \"avycado13@valtown.email\", name: \"Avys Inbox\" },\n\t\t\t\tattachments: e.attachments\n\t\t\t\t\t? await Promise.all(\n\t\t\t\t\t\t\te.attachments.map(async (attachment) => ({\n\t\t\t\t\t\t\t\tfilename: attachment.name,\n\t\t\t\t\t\t\t\ttype: attachment.type,\n\t\t\t\t\t\t\t\tcontent: btoa(await attachment.text()),\n\t\t\t\t\t\t\t\tdisposition: \"attachment\",\n\t\t\t\t\t\t\t})),\n\t\t\t\t\t\t)\n\t\t\t\t\t: [],\n\t\t\t});\n\t\t} else if (result.trim().toLowerCase().startsWith(\"not important\")) {\n\t\t\tconsole.log(\"ℹ️ This email is not important.\");\n\t\t} else {\n\t\t\tconsole.log(\"❓ Unable to determine importance:\", result);\n\t\t}\n\n\t\treturn { success: true };\n\t} catch (error) {\n\t\tconsole.error(\"Failed to save email:\", error);\n\t\t// throw new Error(\"Failed to save email to database\");\n\t}\n}\n","import { sqlite } from \"https://esm.town/v/std/sqlite?v=6\";\nimport { drizzle } from \"npm:drizzle-orm/libsql\";\nimport { emails } from \"./shared/db/schema.ts\";\nimport { OpenAI } from \"https://esm.town/v/std/openai?v=5\";\nimport { email } from \"https://esm.town/v/std/email?v=13\";\n\nconst openai = new OpenAI();\n\nexport default async function (e: Email) {\n\ttry {\n\t\t// biome-ignore lint/suspicious/noExplicitAny: \n\t\tconst db = drizzle(sqlite as any);\n\n\t\tawait db.insert(emails).values({\n\t\t\tto: e.to,\n\t\t\tcc: e.cc || \"\",\n\t\t\tbcc: e.bcc || \"\",\n\t\t\tfrom: e.from,\n\t\t\tsubject: e.subject || \"\",\n\t\t\ttext: e.text || \"\",\n\t\t\thtml: e.html || \"\",\n\t\t});\n\n\t\tconst response = await openai.chat.completions.create({\n\t\t\tmodel: \"gpt-4\",\n\t\t\tmessages: [\n\t\t\t\t{\n\t\t\t\t\trole: \"system\",\n\t\t\t\t\tcontent:\n\t\t\t\t\t\t\"You are an AI that classifies whether an email is important to the user so it can be forwarded to their main inbox. you are to Reply with 'Important' or 'Not Important' and a one-line reason.\",\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\trole: \"user\",\n\t\t\t\t\tcontent: `Is the following email important?\\n\\n${e.subject}\\n\\n${e.text}\\n\\n${e.html}`,\n\t\t\t\t},\n\t\t\t],\n\t\t\ttemperature: 0,\n\t\t});\n\t\tconst result = response.choices[0].message.content;\n\t\tif (result.trim().toLowerCase().startsWith(\"important\")) {\n\t\t\tconsole.log(\"✅ This email is important.\");\n\t\t\tawait email({\n\t\t\t\tsubject: `From the inbox: ${e.subject}`,\n\t\t\t\ttext: `From: ${e.from}\\nTo: ${e.to}\\n CC: ${e.cc}\\n BCC: ${e.bcc}\\n\\n ${e.text} \\n\\n -- The system flagged this as important based on the following:\\n${result}`,\n\t\t\t\thtml: e.html,\n\t\t\t\treplyTo: e.from,\n\t\t\t\tfrom: { email: \"avycado13@valtown.email\", name: \"Avys Inbox\" },\n\t\t\t\tattachments: e.attachments\n\t\t\t\t\t? await Promise.all(\n\t\t\t\t\t\t\te.attachments.map(async (attachment) => ({\n\t\t\t\t\t\t\t\tfilename: attachment.name,\n\t\t\t\t\t\t\t\ttype: attachment.type,\n\t\t\t\t\t\t\t\tcontent: btoa(await attachment.text()),\n\t\t\t\t\t\t\t\tdisposition: \"attachment\",\n\t\t\t\t\t\t\t})),\n\t\t\t\t\t\t)\n\t\t\t\t\t: [],\n\t\t\t});\n\t\t} else if (result.trim().toLowerCase().startsWith(\"not important\")) {\n\t\t\tconsole.log(\"ℹ️ This email is not important.\");\n\t\t} else {\n\t\t\tconsole.log(\"❓ Unable to determine importance:\", result);\n\t\t}\n\n\t\treturn { success: true };\n\t} catch (error) {\n\t\tconsole.error(\"Failed to save email:\", error);\n\t\t// throw new Error(\"Failed to save email to database\");\n\t}\n}\n","createdAt",["D",1751798959077],"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",{"_97":96,"_104":100},"org",{"_97":96,"_98":-5,"_99":100,"_18":54,"_101":102,"_103":25},"branch",{"_13":86,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"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",{"_43":44,"_32":45,"_38":381,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":58,"_60":61,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":382,"_81":383,"_83":384,"_85":25},"tree",[191,194,199,206,213,214,215],"files",[191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215],"counts",{"_181":153,"_182":63,"_183":153,"_184":185,"_186":187},"contents",[127,128,129,130,131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":175,"_32":176,"_30":177,"_135":-5,"_41":42,"_40":178,"_136":58,"_38":179,"_13":153,"_33":161,"_35":-5,"_24":25,"_139":-5,"_27":180},{"_43":169,"_32":170,"_30":171,"_135":-5,"_41":42,"_40":172,"_136":58,"_38":173,"_13":153,"_33":161,"_35":-5,"_24":25,"_139":-5,"_27":174},{"_43":163,"_32":164,"_30":165,"_135":-5,"_41":42,"_40":166,"_136":58,"_38":167,"_13":153,"_33":161,"_35":-5,"_24":25,"_139":-5,"_27":168},{"_43":156,"_32":157,"_30":158,"_135":-5,"_41":42,"_40":159,"_136":58,"_38":160,"_13":153,"_33":161,"_35":-5,"_24":25,"_139":-5,"_27":162},{"_43":148,"_32":149,"_30":150,"_135":-5,"_41":42,"_40":151,"_136":58,"_38":152,"_13":153,"_33":20,"_35":154,"_24":25,"_139":-5,"_27":155},{"_43":141,"_32":142,"_30":143,"_135":-5,"_41":42,"_40":144,"_136":58,"_38":145,"_13":63,"_33":20,"_35":146,"_24":25,"_139":-5,"_27":147},{"_43":134,"_32":28,"_30":31,"_135":-5,"_41":42,"_40":14,"_136":25,"_38":137,"_13":138,"_33":34,"_35":37,"_24":25,"_139":96,"_27":140},"de3fbe8a-5a56-11f0-9b18-f69ea79377d9","parentId","latest",["D",1751798959077],18,"label",[28],"dd8aa6be-533d-11f0-a078-f69ea79377d9","deno.json","a908a25e-531c-11f0-80bf-f69ea79377d9",82,["D",1751018561684],"{\n\t\"$schema\": \"https://raw.githubusercontent.com/denoland/deno/348900b8b79f4a434cab4c74b3bc8d4d2fa8ee74/cli/schemas/config-file.v1.json\",\n\t\"lock\": false,\n\t\"compilerOptions\": {\n\t\t\"noImplicitAny\": false,\n\t\t\"strict\": false,\n\t\t\"types\": [\"https://www.val.town/types/valtown.d.ts\"],\n\t\t\"lib\": [\n\t\t\t\"dom\",\n\t\t\t\"dom.iterable\",\n\t\t\t\"dom.asynciterable\",\n\t\t\t\"deno.ns\",\n\t\t\t\"deno.unstable\"\n\t\t]\n\t},\n\t\"lint\": {\n\t\t\"files\": {\n\t\t\t\"include\": [\"deno:/https/esm.town/**/*\"]\n\t\t},\n\t\t\"rules\": {\n\t\t\t\"exclude\": [\"no-explicit-any\"]\n\t\t}\n\t},\n\t\"node_modules_dir\": false,\n\t\"experimental\": {\n\t\t\"unstable-node-globals\": true,\n\t\t\"unstable-temporal\": true,\n\t\t\"unstable-worker-options\": true,\n\t\t\"unstable-sloppy-imports\": true\n\t},\n\t\"tasks\": {\n\t\t\"migrate\": \"deno run -A npm:drizzle-kit generate --config=shared/db/drizzle.config.ts\"\n\t}\n}\n",[142],"a90dceaa-531c-11f0-8ee1-f69ea79377d9",".vtignore","a90dcf5e-531c-11f0-8ee1-f69ea79377d9",57,["D",1751004300851],0,".git\n.vscode\n.cursorrules\n.DS_Store\nnode_modules\nvendor",[149],"eda5e21a-5320-11f0-83c0-f69ea79377d9","shared","eda5e2ce-5320-11f0-83c0-f69ea79377d9",59,["D",1751006133955],"directory",[157],"eddb73b2-5320-11f0-9534-f69ea79377d9","memory-bank","eddb745c-5320-11f0-9534-f69ea79377d9",60,["D",1751006134306],[164],"25a56c06-540e-11f0-bb1f-f69ea79377d9","frontend","25a56cce-540e-11f0-bb1f-f69ea79377d9",87,["D",1751108018626],[170],"25d62a8a-540e-11f0-a0f8-f69ea79377d9","backend","25d62c42-540e-11f0-a0f8-f69ea79377d9",88,["D",1751108018944],[176],"pulls","branches","forks","envVars",{"_188":153,"_190":153},"connections",{"_188":153,"_189":153},"count","unfilledCount","emptyCount",{"_43":175,"_32":176,"_30":177,"_135":-5,"_41":42,"_40":178,"_136":58,"_38":378,"_13":153,"_33":161,"_35":-5,"_24":25,"_139":-5,"_217":379,"_27":380},{"_43":370,"_32":371,"_30":56,"_135":177,"_41":42,"_40":372,"_136":25,"_38":373,"_13":366,"_33":374,"_35":375,"_24":25,"_139":-5,"_217":376,"_27":377},{"_43":361,"_32":362,"_30":363,"_135":177,"_41":42,"_40":364,"_136":25,"_38":365,"_13":366,"_33":232,"_35":367,"_24":25,"_139":-5,"_217":368,"_27":369},{"_43":169,"_32":170,"_30":171,"_135":-5,"_41":42,"_40":172,"_136":58,"_38":358,"_13":153,"_33":161,"_35":-5,"_24":25,"_139":-5,"_217":359,"_27":360},{"_43":353,"_32":352,"_30":346,"_135":171,"_41":42,"_40":354,"_136":58,"_38":355,"_13":153,"_33":161,"_35":-5,"_24":25,"_139":-5,"_217":356,"_27":357},{"_43":343,"_32":344,"_30":345,"_135":346,"_41":42,"_40":347,"_136":25,"_38":348,"_13":153,"_33":232,"_35":349,"_24":25,"_139":-5,"_217":350,"_27":351},{"_43":335,"_32":336,"_30":337,"_135":171,"_41":42,"_40":338,"_136":58,"_38":339,"_13":153,"_33":20,"_35":340,"_24":25,"_139":-5,"_217":341,"_27":342},{"_43":327,"_32":328,"_30":329,"_135":171,"_41":42,"_40":330,"_136":58,"_38":331,"_13":153,"_33":232,"_35":332,"_24":25,"_139":-5,"_217":333,"_27":334},{"_43":163,"_32":164,"_30":165,"_135":-5,"_41":42,"_40":166,"_136":58,"_38":324,"_13":153,"_33":161,"_35":-5,"_24":25,"_139":-5,"_217":325,"_27":326},{"_43":316,"_32":317,"_30":318,"_135":165,"_41":42,"_40":319,"_136":25,"_38":320,"_13":63,"_33":20,"_35":321,"_24":25,"_139":-5,"_217":322,"_27":323},{"_43":308,"_32":309,"_30":310,"_135":165,"_41":42,"_40":311,"_136":25,"_38":312,"_13":63,"_33":20,"_35":313,"_24":25,"_139":-5,"_217":314,"_27":315},{"_43":300,"_32":301,"_30":302,"_135":165,"_41":42,"_40":303,"_136":58,"_38":304,"_13":63,"_33":20,"_35":305,"_24":25,"_139":-5,"_217":306,"_27":307},{"_43":292,"_32":293,"_30":294,"_135":165,"_41":42,"_40":295,"_136":25,"_38":296,"_13":63,"_33":20,"_35":297,"_24":25,"_139":-5,"_217":298,"_27":299},{"_43":284,"_32":285,"_30":286,"_135":165,"_41":42,"_40":287,"_136":25,"_38":288,"_13":63,"_33":20,"_35":289,"_24":25,"_139":-5,"_217":290,"_27":291},{"_43":276,"_32":277,"_30":278,"_135":165,"_41":42,"_40":279,"_136":25,"_38":280,"_13":63,"_33":20,"_35":281,"_24":25,"_139":-5,"_217":282,"_27":283},{"_43":156,"_32":157,"_30":158,"_135":-5,"_41":42,"_40":159,"_136":58,"_38":273,"_13":153,"_33":161,"_35":-5,"_24":25,"_139":-5,"_217":274,"_27":275},{"_43":268,"_32":236,"_30":229,"_135":158,"_41":42,"_40":269,"_136":58,"_38":270,"_13":153,"_33":161,"_35":-5,"_24":25,"_139":-5,"_217":271,"_27":272},{"_43":263,"_32":262,"_30":256,"_135":229,"_41":42,"_40":264,"_136":58,"_38":265,"_13":153,"_33":161,"_35":-5,"_24":25,"_139":-5,"_217":266,"_27":267},{"_43":253,"_32":254,"_30":255,"_135":256,"_41":42,"_40":257,"_136":58,"_38":258,"_13":153,"_33":20,"_35":259,"_24":25,"_139":-5,"_217":260,"_27":261},{"_43":245,"_32":246,"_30":247,"_135":229,"_41":42,"_40":248,"_136":58,"_38":249,"_13":153,"_33":232,"_35":250,"_24":25,"_139":-5,"_217":251,"_27":252},{"_43":237,"_32":238,"_30":239,"_135":229,"_41":42,"_40":240,"_136":58,"_38":241,"_13":153,"_33":232,"_35":242,"_24":25,"_139":-5,"_217":243,"_27":244},{"_43":226,"_32":227,"_30":228,"_135":229,"_41":42,"_40":230,"_136":58,"_38":231,"_13":153,"_33":232,"_35":233,"_24":25,"_139":-5,"_217":234,"_27":235},{"_43":148,"_32":149,"_30":150,"_135":-5,"_41":42,"_40":151,"_136":58,"_38":223,"_13":153,"_33":20,"_35":154,"_24":25,"_139":-5,"_217":224,"_27":225},{"_43":141,"_32":142,"_30":143,"_135":-5,"_41":42,"_40":144,"_136":58,"_38":220,"_13":63,"_33":20,"_35":146,"_24":25,"_139":-5,"_217":221,"_27":222},{"_43":134,"_32":28,"_30":31,"_135":-5,"_41":42,"_40":14,"_136":25,"_38":216,"_13":138,"_33":34,"_35":37,"_24":25,"_139":96,"_217":218,"_27":219},["D",1751798959077],"children",[],[28],["D",1751018561684],[],[142],["D",1751004300851],[],[149],"ee43528e-5320-11f0-a13c-f69ea79377d9","schema.ts","ee435360-5320-11f0-a13c-f69ea79377d9","ee0a8d0a-5320-11f0-8865-f69ea79377d9",65,["D",1751006134908],"script","import { integer, sqliteTable, text } from \"npm:drizzle-orm/sqlite-core\";\n\nexport const emails = sqliteTable(\"emails\", {\n id: integer(\"id\").primaryKey({ autoIncrement: true }),\n to: text(\"to\").notNull(),\n cc: text(\"cc\"),\n bcc: text(\"bcc\"),\n from: text(\"from\").notNull(),\n subject: text(\"subject\").notNull(),\n text: text(\"text\"),\n html: text(\"html\"),\n time: text(\"time\").default(\"CURRENT_TIMESTAMP\"),\n read: integer(\"read\", { mode: \"boolean\" }).default(false),\n});\n",[],[157,236,227],"db","e367b868-533f-11f0-885e-f69ea79377d9","migrator.ts","e367b8fe-533f-11f0-885e-f69ea79377d9",84,["D",1751019431133],"import type { Database } from \"npm:@libsql/client\";\n\nexport abstract class Migration {\n protected db: Database;\n public readonly name: string;\n\n constructor(db: Database, name: string) {\n this.db = db;\n this.name = name;\n }\n\n protected get upSQL(): string | null {\n return null;\n }\n\n protected get downSQL(): string | null {\n const up = this.upSQL;\n if (!up) return null;\n\n const createMatch = up.match(/CREATE\\s+TABLE\\s+(IF\\s+NOT\\s+EXISTS\\s+)?([`\"\\[]?)(\\w+)\\2/i);\n if (createMatch) {\n const tableName = createMatch[3];\n return `DROP TABLE IF EXISTS \"${tableName}\";`;\n }\n\n const alterMatch = up.match(/ALTER\\s+TABLE\\s+([`\"\\[]?)(\\w+)\\1\\s+ADD\\s+COLUMN\\s+([`\"\\[]?)(\\w+)\\3/i);\n if (alterMatch) {\n const tableName = alterMatch[2];\n const columnName = alterMatch[4];\n return `-- Manual reversal may be required\\n-- Consider using: ALTER TABLE \"${tableName}\" DROP COLUMN \"${columnName}\";`;\n }\n\n return null;\n }\n\n async up(): Promise {\n const sql = this.upSQL;\n if (!sql) {\n throw new Error(`Migration ${this.name} does not implement 'up' method or provide 'upSQL'.`);\n }\n await this.db.execute(sql);\n }\n\n async down(): Promise {\n const sql = this.downSQL;\n if (!sql) {\n throw new Error(`Migration ${this.name} does not implement 'down' method or provide 'downSQL'.`);\n }\n await this.db.execute(sql);\n }\n}",[],[157,236,238],"dd32090a-533d-11f0-a083-f69ea79377d9","drizzle.config.ts","dd3209b4-533d-11f0-a083-f69ea79377d9",76,["D",1751018561683],"import { defineConfig } from \"npm:drizzle-kit\";\n\nexport default defineConfig({\n\tschema: \"./schema.ts\",\n\tout: \"./migrations\",\n dialect: \"sqlite\",\n\tverbose: true,\n\tstrict: true,\n});\n",[],[157,236,246],"dd264714-533d-11f0-b48e-f69ea79377d9","0000_initial_schema.sql","dd2647e6-533d-11f0-b48e-f69ea79377d9","dcfa134c-533d-11f0-a676-f69ea79377d9",74,["D",1751018561681],"-- Migration file generated manually for initial schema setup\nCREATE TABLE IF NOT EXISTS emails (\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 TEXT DEFAULT CURRENT_TIMESTAMP,\n read INTEGER DEFAULT 0\n);\n",[],[157,236,262,254],"migrations","dcfa12a2-533d-11f0-a676-f69ea79377d9",73,["D",1751018561389],[209],[157,236,262],"ee0a8c4c-5320-11f0-8865-f69ea79377d9",61,["D",1751006134617],[208,210,211,212],[157,236],["D",1751006133955],[207],[157],"dd2a6cf4-533d-11f0-ab28-f69ea79377d9","techContext.md","ee393704-5320-11f0-bc0d-f69ea79377d9",75,["D",1751018561684],"# Tech Context\n\n## Technologies Used\n\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\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\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\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\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",[],[164,277],"dd719af2-533d-11f0-ab28-f69ea79377d9","systemPatterns.md","ee6be500-5320-11f0-942a-f69ea79377d9",81,["D",1751018562131],"# System Patterns\n\n## System Architecture\n\nThe Webmail for Val Town application follows a serverless architecture within the Val Town platform, leveraging its HTTP and email trigger capabilities:\n\n- **Frontend:** A simple HTML interface rendered by `webmail.ts` for displaying emails in an inbox format.\n- **Backend:** Two main scripts, `webmail.ts` for serving the web interface and fetching emails, and `reciever.ts` for processing incoming emails via an email trigger.\n- **Database:** Utilizes Val Town's provided SQLite database for storing email data, accessed through Drizzle ORM for type-safe operations.\n\n## Key Technical Decisions\n\n- **Drizzle ORM Adoption:** Chosen for database interactions to ensure type safety and maintainability over raw SQL queries.\n- **SQLite with LibSQL:** Using `@libsql/client` with Drizzle ORM to interact with SQLite in a way compatible with Val Town's environment.\n- **Migration Approach:** Opting for Drizzle's migration system to manage schema changes, pending user input on migration file setup.\n\n## Design Patterns in Use\n\n- **Separation of Concerns:** Database schema is defined in `shared/db/schema.ts` for reuse across `webmail.ts` and `reciever.ts`.\n- **Type-Safe Queries:** Leveraging Drizzle ORM's query builder to construct type-safe database operations, reducing runtime errors.\n\n## Component Relationships\n\n- **Webmail Interface (`webmail.ts`):** Fetches email data from the SQLite database using Drizzle ORM and renders it as HTML.\n- **Email Receiver (`reciever.ts`):** Captures incoming emails via Val Town's email trigger and inserts them into the database using Drizzle ORM.\n- **Shared Schema (`shared/db/schema.ts`):** Defines the structure of the email table, ensuring consistency across different parts of the application.\n\n## Critical Implementation Paths\n\n- **Email Fetching Flow:** HTTP request -> `webmail.ts` -> Drizzle ORM query -> SQLite database -> Render HTML with email data.\n- **Email Reception Flow:** Incoming email -> `reciever.ts` (email trigger) -> Drizzle ORM insert -> SQLite database storage.\n",[],[164,285],"dd6b174a-533d-11f0-8333-f69ea79377d9","projectbrief.md","ee684602-5320-11f0-a762-f69ea79377d9",80,["D",1751018562124],"# Project Brief\n\n## Project Name: Webmail for Val Town\n\n## Overview\n\nThis project is a webmail application designed for use within the Val Town platform. It aims to provide users with a simple and effective way to manage their emails directly from a web interface hosted on Val Town.\n\n## Core Requirements\n\n- **Email Fetching:** Ability to retrieve emails from a data store.\n- **Email Display:** Present emails in a user-friendly inbox format with details such as sender, subject, and time.\n- **Email Processing:** Handle incoming emails through an email trigger for storage and management.\n- **Database Management:** Use a robust ORM like Drizzle for type-safe database interactions.\n\n## Goals\n\n- To create a seamless email management experience within Val Town.\n- Ensure maintainability and scalability through modern development practices and tools like Drizzle ORM.\n- Provide clear documentation for future development and troubleshooting via a structured memory bank.\n",[],[164,293],"dd5d6eba-533d-11f0-bdfd-f69ea79377d9","progress.md","ee3c8c06-5320-11f0-9466-f69ea79377d9",79,["D",1751018562000],"# Progress\n\n## What Works\n\n- **Email Fetching and Display:** The `webmail.ts` script successfully fetches emails from the SQLite database using Drizzle ORM and renders them in an HTML interface.\n- **Email Reception and Storage:** The `reciever.ts` script processes incoming emails via an email trigger and inserts them into the database using Drizzle ORM.\n- **Type-Safe Schema:** The database schema is defined in `shared/db/schema.ts`, ensuring type safety across the application.\n\n## What's Left to Build\n\n- **Migration File Setup:** User needs to provide or confirm the migration files or an alternative method for Drizzle ORM to handle table creation.\n- **Full Testing:** Need to test the application with the final migration setup to ensure all database operations work as expected in the Val Town environment.\n\n## Current Status\n\n- **Database Upgrade:** The application has been upgraded to use Drizzle ORM for queries and inserts. Migration setup for table creation is in progress, pending user input.\n- **Memory Bank Initialization:** All core memory bank files have been created to document the project's context, architecture, and progress.\n\n## Known Issues\n\n- **Migration Pending:** Without the migration files or an alternative approach, table creation via Drizzle ORM migrations is not fully operational. User intervention is required to finalize this setup.\n\n## Evolution of Project Decisions\n\n- **Initial Setup:** Started with raw SQLite queries for database operations in Val Town.\n- **ORM Adoption:** Decided to upgrade to Drizzle ORM for improved type safety and maintainability, leading to updates in `webmail.ts` and `reciever.ts`.\n- **Migration Strategy:** Opted for Drizzle's migration system for schema management, currently awaiting user-provided files or alternative instructions for completion.\n- **Documentation:** Established a memory bank to ensure continuity and clarity after memory resets, covering project brief, product context, active work, system patterns, tech context, and progress.\n",[],[164,301],"dd57be8e-533d-11f0-80dd-f69ea79377d9","productContext.md","ee61a7a2-5320-11f0-811a-f69ea79377d9",78,["D",1751018561998],"# Product Context\n\n## Purpose\n\nThe Webmail for Val Town application exists to simplify email management for users within the Val Town ecosystem. It addresses the need for a straightforward, integrated email solution that operates seamlessly in a serverless environment.\n\n## Problems Solved\n\n- **Accessibility:** Provides access to emails without the need for external email clients.\n- **Management:** Allows users to view and organize their inbox directly through a web interface.\n- **Integration:** Works within Val Town's unique environment, leveraging its capabilities for email triggers and data storage.\n\n## How It Works\n\n- **Email Reception:** Incoming emails are captured via an email trigger defined in `reciever.ts` and stored in a SQLite database.\n- **Email Display:** The `webmail.ts` script fetches emails from the database and renders them in an HTML interface, displaying key information like sender, subject, and receipt time.\n- **Database Interaction:** Utilizes Drizzle ORM for type-safe and maintainable database operations, ensuring data integrity and ease of schema management.\n\n## User Experience Goals\n\n- **Simplicity:** Offer a clean, intuitive inbox view that requires minimal user effort to navigate.\n- **Responsiveness:** Ensure the interface loads quickly and operates efficiently within Val Town's serverless constraints.\n- **Reliability:** Maintain data consistency and provide accurate email status (read/unread) through robust database interactions.\n",[],[164,309],"dd3f8062-533d-11f0-a676-f69ea79377d9","activeContext.md","ee5035d0-5320-11f0-b79a-f69ea79377d9",77,["D",1751018561683],"# Active Context\n\n## Current Work Focus\n\n- Migration of the Deno app to use Drizzle ORM for database management.\n- Manually created initial schema migration file for SQLite database in Val Town environment.\n\n## Recent Changes\n\n- Added Drizzle configuration file at `shared/db/drizzle.config.ts`.\n- Updated `deno.json` to include a migration task (though execution faced issues).\n- Manually generated initial migration file at `shared/db/migrations/0000_initial_schema.sql` to define the `emails` table schema.\n\n## Next Steps\n\n- Ensure the migration file is compatible with Val Town's SQLite setup.\n- Update the application to use Drizzle ORM for database operations if required.\n- Document any further learnings or adjustments needed for Drizzle integration in Val Town.\n\n## Active Decisions and Considerations\n\n- Decided to manually generate migration files due to compatibility issues with `drizzle-kit` in Val Town.\n- Focus on maintaining existing data integrity during migration.\n\n## Important Patterns and Preferences\n\n- Use of TypeScript for all code files.\n- Adherence to Val Town's specific platform requirements and constraints.\n\n## Learnings and Project Insights\n\n- Running `drizzle-kit` directly in Val Town environment poses challenges due to module resolution issues.\n- Manual migration file creation is a viable workaround for initial schema setup in constrained environments like Val Town.\n",[],[164,317],["D",1751006134306],[200,201,202,203,204,205],[164],"281048f8-540e-11f0-b8bd-f69ea79377d9","index.tsx","281049c0-540e-11f0-b8bd-f69ea79377d9",90,["D",1751108022684],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\nconst root = document.getElementById(\"root\");\nif (!root) {\n throw new Error(\"No root element found\");\n}\n\ncreateRoot(root).render();",[],[170,328],"283b04ee-540e-11f0-a941-f69ea79377d9","index.html","283b05b6-540e-11f0-a941-f69ea79377d9",91,["D",1751108022964],"\n \n \n \n \n Email Inbox\n \n \n \n

Email Inbox

\n \n\n

\n \n \n",[],[170,336],"2874e33a-540e-11f0-aa91-f69ea79377d9","App.tsx","2874e3e4-540e-11f0-aa91-f69ea79377d9","27cfd07a-540e-11f0-bedb-f69ea79377d9",93,["D",1751108023330],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\n\nexport function App() {\n const [emails, setEmails] = useState([]);\n const [loading, setLoading] = useState(true);\n const [error, setError] = useState(null);\n\n useEffect(() => {\n async function fetchEmails() {\n try {\n const res = await fetch(\"/api/emails\");\n if (!res.ok) throw new Error(\"Failed to fetch emails\");\n const data = await res.json();\n setEmails(data);\n } catch (err) {\n setError((err as Error).message);\n } finally {\n setLoading(false);\n }\n }\n\n fetchEmails();\n }, []);\n\n if (loading) return

Loading emails...

;\n if (error) return

Error: {error}

;\n if (emails.length === 0) return

No emails found

;\n\n return (\n

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

\n );\n}",[],[170,352,344],"components","27cfcfc6-540e-11f0-bedb-f69ea79377d9",89,["D",1751108022260],[196],[170,352],["D",1751108018626],[195,197,198],[170],"8d5bd692-541c-11f0-830e-f69ea79377d9","utils.ts","28721cc2-540e-11f0-a4d6-f69ea79377d9",99,["D",1751114205579],2,"import { sqlite } from \"https://esm.town/v/std/sqlite?v=6\";\nimport { sql } from \"npm:drizzle-orm\";\nimport { drizzle } from \"npm:drizzle-orm/libsql\";\nimport { emails } from \"../shared/db/schema.ts\"; // Import the emails schema\n\n// Define an interface that matches the structure of the emails schema\nexport interface EmailSchema {\n id: number;\n to: string;\n cc: string | null;\n bcc: string | null;\n from: string;\n subject: string;\n text: string | null;\n html: string | null;\n time: string;\n read: boolean;\n}\n\nexport async function fetchEmails(\n inputLimit?: number,\n inputOffset?: number,\n): Promise {\n const limit = Math.max(\n 1,\n Math.min(100, Math.floor(Number(inputLimit) || 20)),\n );\n const offset = Math.max(0, Math.floor(Number(inputOffset) || 0));\n\n console.log(\"fetchEmails called with:\", { inputLimit, inputOffset });\n console.log(\"Processed limit and offset:\", { limit, offset });\n\n try {\n // biome-ignore lint/suspicious/noExplicitAny: \n const db = drizzle(sqlite as any);\n\n console.log(\"Executing email query with:\", { limit, offset });\n\n const result = await db\n .select({\n id: emails.id,\n to: emails.to,\n cc: emails.cc,\n bcc: emails.bcc,\n from: emails.from,\n subject: emails.subject,\n time: emails.time,\n read: emails.read,\n })\n .from(emails)\n .orderBy(sql`time DESC`)\n .limit(limit)\n .offset(offset);\n\n console.log(\"Email query successful. Rows returned:\", result.length);\n\n return result as unknown as EmailSchema[];\n } catch (error) {\n console.error(\"Error in fetchEmails:\", {\n message: error instanceof Error ? error.message : String(error),\n stack: error instanceof Error ? error.stack : undefined,\n });\n throw error;\n }\n}\n",[],[176,362],"8d687e4c-541c-11f0-ae98-f69ea79377d9","index.ts",100,["D",1751114205580],"http","import { serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport { fetchEmails } from \"./utils.ts\";\nconst app = new Hono();\n\n// Serve index.html at the root /\napp.get(\"/\", async c => {\n return serveFile(\"/frontend/index.html\", import.meta.url);\n});\n\n// Serve all /frontend files\napp.get(\"/frontend/**/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Add your API routes here\n// app.get(\"/api/data\", c => c.json({ hello: \"world\" }));\n\n// Unwrap and rethrow Hono errors as the original error\n// If you delete this, all errors will be \"Internal Server Error\"\napp.onError((err, c) => {\n throw err;\n});\n\napp.get(\"/api/emails\", async c => {\n console.log(\"GET /api/emails: Request received\");\n\n try {\n const emails = await fetchEmails();\n console.log(\"GET /api/emails: Emails fetched successfully\", emails);\n return c.json(emails);\n } catch (err) {\n console.error(\"GET /api/emails: Error fetching emails\", {\n error: err,\n stack: err instanceof Error ? err.stack : undefined,\n });\n return c.json({ error: \"Failed to fetch emails\" }, 500);\n }\n});\n\n// HTTP vals expect an exported \"fetch handler\"\n// This is how you \"run the server\" in Val Town with Hono\nexport default app.fetch;",[],[176,371],["D",1751108018944],[192,193],[176],["D",1743305327329],{"_97":96,"_104":100},{"_97":96,"_98":-5,"_99":100,"_18":54,"_101":102,"_103":25},{"_13":86,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"ctx",{"_79":-5,"_124":418,"_419":420,"_421":422,"_423":25,"_424":25,"_425":25,"_426":58,"_427":-5,"_428":-7,"_429":-7,"_430":153,"_431":25,"_432":25,"_433":-5,"_434":25,"_435":25,"_436":25,"_437":-5},"ENV",{"_389":390,"_391":392,"_393":87,"_394":395,"_396":397,"_398":399,"_400":401,"_402":403,"_404":405,"_406":407,"_408":409,"_410":411,"_412":413,"_414":415,"_416":417},"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"]

Diff · v118