[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_170":171,"_172":173},"routes/_app.x.$handle.$name",{"_98":97,"_34":47,"_106":88,"_28":107,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":27,"_121":122,"_123":25,"_124":-5,"_125":-5,"_126":127},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_45":46,"_34":47,"_40":48,"_49":-5,"_50":27,"_51":52,"_53":52,"_54":-5,"_55":-5,"_18":56,"_57":58,"_59":25,"_60":25,"_61":62,"_63":64,"_65":66,"_67":-5,"_68":-5,"_69":-5,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":27},"version",47,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":27,"_28":29,"_30":31},"file",{"_32":33,"_34":29,"_35":36,"_37":39,"_40":41,"_42":14,"_43":44,"_24":27},"previous",{"_32":33,"_34":29,"_35":36,"_37":38},"deleted",true,"deletedHere",false,"path","webmail","latestPath","webmail.ts","fileId","810adf6a-0d17-11f0-8812-569c3dd06744","name","fileType","http","content","/** @jsxImportSource https://esm.sh/preact@10.19.2 */\nimport { render } from \"https://esm.sh/preact-render-to-string@6.2.0\";\nimport { h } from \"https://esm.sh/preact@10.19.2\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nconst SCHEMA_VERSION = 6; // 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 console.log(`Fetching emails with validated params - Limit: ${limit}, Offset: ${offset}`);\n\n // Explicitly use prepared statement with validated parameters\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 console.log(`Fetched ${result.rows.length} emails`);\n\n // Log first email for debugging\n if (result.rows.length > 0) {\n console.log(\"First email:\", JSON.stringify(result.rows[0], null, 2));\n }\n\n return result.rows as Email[];\n\n // ...rest of function\n }\n catch (error) {\n console.error(\"Detailed Error in fetchEmails:\", {\n message: error.message,\n name: error.name,\n code: error.code,\n stack: error.stack,\n limit,\n offset,\n });\n throw error;\n }\n // ...error handling\n}\nfunction EmailList({ emails }: { emails: Email[] }) {\n return (\n \n \n 📬 Email Inbox\n \n {emails.length === 0\n ? (\n

\n No emails found 📭\n

\n )\n : (\n

\n \n {email.from}\n \n \n {new Date(email.time).toLocaleString()}\n \n

\n \n {email.subject}\n

\n \n \n {email.read ? \"✅ Read\" : \"🔴 Unread\"}\n \n \n \n ))}\n

\n No emails found 📭\n

\n )\n : (\n

\n \n {email.from}\n \n \n {new Date(email.time).toLocaleString()}\n \n

\n \n {email.subject}\n

\n \n \n {email.read ? \"✅ Read\" : \"🔴 Unread\"}\n \n \n \n ))}\n

\n )}\n \n \n View Source 🔍\n \n \n \n );\n}\n\nexport default async function server(request: Request): Promise {\n try {\n const emails = await fetchEmails();\n const html = render();\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: ${error.message}`, { status: 500 });\n }\n}","createdAt",["D",1743379729055],"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","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",{"_98":97,"_105":101},"org",{"_98":97,"_99":-5,"_100":101,"_18":56,"_102":103,"_104":27},"branch",{"_13":87,"_34":88,"_45":44,"_89":46,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":47,"_96":97},"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",{"_45":46,"_34":47,"_40":166,"_49":-5,"_50":27,"_51":52,"_53":52,"_54":-5,"_55":-5,"_18":56,"_57":58,"_59":25,"_60":25,"_61":62,"_63":64,"_65":66,"_67":-5,"_68":-5,"_69":-5,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":167,"_82":168,"_84":169,"_86":27},"tree",[157,158],"files",[157,158],"counts",{"_146":147,"_148":64,"_149":147,"_150":151,"_152":153},"contents",[128,129],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_45":137,"_34":138,"_32":139,"_131":-5,"_43":44,"_42":140,"_132":27,"_40":141,"_13":142,"_35":143,"_37":144,"_24":27,"_135":-5,"_28":145},{"_45":130,"_34":29,"_32":33,"_131":-5,"_43":44,"_42":14,"_132":27,"_40":133,"_13":134,"_35":36,"_37":39,"_24":27,"_135":-5,"_28":136},"521a05d4-0dc4-11f0-ab81-569c3dd06744","parentId","latest",["D",1743379729055],26,"label",[29],"49aad360-0dc4-11f0-84b9-569c3dd06744","reciever","2b544ae8-0d17-11f0-b79f-569c3dd06744",45,["D",1743379714903],19,"email","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nconst SCHEMA_VERSION = 7; // 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 NOT NULL,\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 from: e.from,\n cc: e.cc,\n bcc: e.bcc,\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}",[138],"pulls",0,"branches","forks","envVars",{"_154":147,"_156":147},"connections",{"_154":147,"_155":147},"count","unfilledCount","emptyCount",{"_45":137,"_34":138,"_32":139,"_131":-5,"_43":44,"_42":140,"_132":27,"_40":163,"_13":142,"_35":143,"_37":144,"_24":27,"_135":-5,"_160":164,"_28":165},{"_45":130,"_34":29,"_32":33,"_131":-5,"_43":44,"_42":14,"_132":27,"_40":159,"_13":134,"_35":36,"_37":39,"_24":27,"_135":-5,"_160":161,"_28":162},["D",1743379729055],"children",[],[29],["D",1743379714903],[],[138],["D",1743305327329],{"_98":97,"_105":101},{"_98":97,"_99":-5,"_100":101,"_18":56,"_102":103,"_104":27},{"_13":87,"_34":88,"_45":44,"_89":46,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":47,"_96":97},"ctx",{"_80":-5,"_125":203,"_204":205,"_206":207,"_208":27,"_209":27,"_210":27,"_211":25,"_212":-5,"_213":-7,"_214":-7,"_215":147,"_216":27,"_217":27,"_218":-5,"_219":27,"_220":27,"_221":27,"_222":-5},"ENV",{"_174":175,"_176":177,"_178":88,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202},"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 · v47