[{"_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",26,"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 */\nimport { basicAuth } from \"https://esm.town/v/pomdtr/basicAuth\";\nimport { verifyToken } from \"https://esm.town/v/pomdtr/verifyToken\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { h } from \"npm:preact\";\nimport { render } from \"npm:preact-render-to-string\";\n\nasync function fetchEmails() {\n return await sqlite.execute(`SELECT id, to, cc, bcc, from, subject, time, read FROM emails`);\n}\n\nfunction EmailList({ emails }) {\n return (\n \n

Inbox

\n
\n From: {email.from}\n
\n
\n To: {email.to}\n
\n {email.cc && (\n
\n CC: {email.cc}\n
\n )}\n {email.bcc && (\n
\n BCC: {email.bcc}\n
\n )}\n
\n Subject: {email.subject}\n
\n
Sent: {email.time}
\n
\n {email.read ? \"Read\" : \"Unread\"}\n
\n

\n \n );\n}\n\nasync function home(req: Request): Promise {\n const emails = await fetchEmails();\n const html = render();\n\n return new Response(html, {\n headers: { \"Content-Type\": \"text/html\" },\n });\n}\n// export default basicAuth(home, { verifyUser: (_, password) => verifyToken(password) });\nexport default home","/** @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 KEY = new URL(import.meta.url).pathname.split(\"/\").at(-1);\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(`\n CREATE TABLE IF NOT EXISTS ${KEY}_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 time DATETIME DEFAULT CURRENT_TIMESTAMP,\n read BOOLEAN DEFAULT 0\n )\n `);\n\n // Insert a sample email if table is empty\n const checkEmpty = await sqlite.execute(`\n SELECT COUNT(*) as count \n FROM ${KEY}_emails_${SCHEMA_VERSION}\n `);\n\n if (checkEmpty.rows[0].count === 0) {\n await sqlite.execute(\n `\n INSERT INTO ${KEY}_emails_${SCHEMA_VERSION} \n (\"to\", \"from\", subject, read, time) \n VALUES (?, ?, ?, ?, datetime('now'))\n `,\n [\n \"user@example.com\",\n \"sender@example.com\",\n \"Sample Email\",\n 0,\n ],\n );\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 `SELECT id, \"to\", cc, bcc, \"from\", subject, time, read \n FROM ${KEY}_emails_${SCHEMA_VERSION} \n ORDER BY time DESC \n LIMIT ? OFFSET ?`,\n [limit, offset],\n );\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 } 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}\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 )}\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",1743376925301],"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},"caef12d0-0dbd-11f0-80f3-569c3dd06744","parentId","latest",["D",1743376925301],14,"label",[29],"baed1ecc-0d1d-11f0-ace0-569c3dd06744","reciever","2b544ae8-0d17-11f0-b79f-569c3dd06744",17,["D",1743308178968],10,"email","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nexport default async function(e) {\n try {\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS emails (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n to TEXT,\n cc TEXT,\n bcc TEXT,\n from TEXT,\n subject TEXT,\n html TEXT,\n text TEXT,\n time TEXT,\n read BOOLEAN,\n )`,\n );\n\n await sqlite.execute(\n {\n sql: `INSERT INTO emails (to, from, cc, bcc,subject, html, text, time, read)\n VALUES (:to, :from, :cc, :bcc,:subject, :html, :text,:time, :read)`,\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 time: new Date().toISOString(),\n read: false,\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",1743376925301],"children",[],[29],["D",1743308178968],[],[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 · v26