Email Inbox

Email Inbox

\n \n\n

\n \n \n",[],[174,339],"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}",[],[174,355,347],"components","27cfcfc6-540e-11f0-bedb-f69ea79377d9",89,["D",1751108022260],[200],[174,355],["D",1751108018626],[199,201,202],[174],"8d5bd692-541c-11f0-830e-f69ea79377d9","utils.ts","28721cc2-540e-11f0-a4d6-f69ea79377d9",99,["D",1751114205579],"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",[],[180,365],"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;",[],[180,373],["D",1751108018944],[196,197],[180],["D",1743305327329],{"_97":96,"_104":100},{"_97":96,"_98":-5,"_99":100,"_18":55,"_101":102,"_103":49},{"_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,"_123":420,"_421":422,"_423":424,"_425":49,"_426":49,"_427":49,"_428":25,"_429":-5,"_430":-7,"_431":-7,"_432":157,"_433":49,"_434":49,"_435":-5,"_436":49,"_437":49,"_438":49,"_439":-5},"ENV",{"_391":392,"_393":394,"_395":87,"_396":397,"_398":399,"_400":401,"_402":403,"_404":405,"_406":407,"_408":409,"_410":411,"_412":413,"_414":415,"_416":417,"_418":419},"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 · v102