Email Inbox

Email Inbox

\n \n\n

\n \n \n",[],[176,346],"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}",[],[176,362,354],"components","27cfcfc6-540e-11f0-bedb-f69ea79377d9",89,["D",1751108022260],[202],[176,362],["D",1751108018626],[201,203,204],[176],"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",[],[182,372],"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;",[],[182,381],["D",1751108018944],[198,199],[182],["D",1743305327329],{"_94":93,"_101":97},{"_94":93,"_95":-5,"_96":97,"_18":51,"_98":99,"_100":24},{"_13":83,"_31":84,"_40":39,"_85":41,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":42,"_92":93},"ctx",{"_76":-5,"_121":428,"_429":430,"_431":432,"_433":24,"_434":24,"_435":24,"_436":55,"_437":-5,"_438":-7,"_439":-7,"_440":153,"_441":24,"_442":24,"_443":-5,"_444":24,"_445":24,"_446":24,"_447":-5},"ENV",{"_399":400,"_401":402,"_403":84,"_404":405,"_406":407,"_408":409,"_410":411,"_412":413,"_414":415,"_416":417,"_418":419,"_420":421,"_422":423,"_424":425,"_426":427},"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 · v122