[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_169":170,"_171":172},"routes/_app.x.$handle.$name",{"_97":96,"_33":46,"_105":87,"_28":106,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":27,"_120":121,"_122":25,"_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",{"_44":45,"_33":46,"_39":47,"_48":-5,"_49":27,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":57,"_58":25,"_59":25,"_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":27},"version",35,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":27,"_28":29,"_30":29},"file",{"_31":32,"_33":29,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":27},"previous",{"_31":32,"_33":29,"_34":35,"_36":37},"deleted",true,"deletedHere",false,"path","reciever","latestPath","fileId","2b544ae8-0d17-11f0-b79f-569c3dd06744","name","fileType","email","content","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 ${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 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}","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 ${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 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 (\"to\", cc, bcc, \"from\", subject, text, html, time, read)\n VALUES (:to, :cc, :bcc, :from,:subject, :text, :html,: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}","createdAt",["D",1743377905578],"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",{"_97":96,"_104":100},"org",{"_97":96,"_98":-5,"_99":100,"_18":55,"_101":102,"_103":27},"branch",{"_13":86,"_33":87,"_44":43,"_88":45,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":46,"_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",{"_44":45,"_33":46,"_39":165,"_48":-5,"_49":27,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":57,"_58":25,"_59":25,"_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":166,"_81":167,"_83":168,"_85":27},"tree",[156,157],"files",[156,157],"counts",{"_145":146,"_147":63,"_148":146,"_149":150,"_151":152},"contents",[127,128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":141,"_33":29,"_31":32,"_132":-5,"_42":43,"_41":14,"_134":27,"_39":142,"_13":143,"_34":35,"_36":38,"_24":27,"_139":-5,"_28":144},{"_44":129,"_33":130,"_31":131,"_132":-5,"_42":43,"_41":133,"_134":27,"_39":135,"_13":136,"_34":137,"_36":138,"_24":27,"_139":-5,"_28":140},"ba0fcbfc-0dbe-11f0-875a-569c3dd06744","webmail","810adf6a-0d17-11f0-8812-569c3dd06744","parentId",33,"latest",["D",1743377326491],21,"http","/** @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\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 ${KEY}_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 )}\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}","label",[130],"133968a4-0dc0-11f0-9fb8-569c3dd06744",["D",1743377905578],12,[29],"pulls",0,"branches","forks","envVars",{"_153":146,"_155":146},"connections",{"_153":146,"_154":146},"count","unfilledCount","emptyCount",{"_44":141,"_33":29,"_31":32,"_132":-5,"_42":43,"_41":14,"_134":27,"_39":162,"_13":143,"_34":35,"_36":38,"_24":27,"_139":-5,"_159":163,"_28":164},{"_44":129,"_33":130,"_31":131,"_132":-5,"_42":43,"_41":133,"_134":27,"_39":158,"_13":136,"_34":137,"_36":138,"_24":27,"_139":-5,"_159":160,"_28":161},["D",1743377326491],"children",[],[130],["D",1743377905578],[],[29],["D",1743305327329],{"_97":96,"_104":100},{"_97":96,"_98":-5,"_99":100,"_18":55,"_101":102,"_103":27},{"_13":86,"_33":87,"_44":43,"_88":45,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":46,"_95":96},"ctx",{"_79":-5,"_124":202,"_203":204,"_205":206,"_207":27,"_208":27,"_209":27,"_210":25,"_211":-5,"_212":-7,"_213":-7,"_214":146,"_215":27,"_216":27,"_217":-5,"_218":27,"_219":27,"_220":27,"_221":-5},"ENV",{"_173":174,"_175":176,"_177":87,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195,"_196":197,"_198":199,"_200":201},"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 · v35