\n Received Emails ({emails.length})\n

\n {emails.length === 0 ? (\n

No emails received yet.

\n ) : (\n \n \n \n \n \n \n \n \n \n {emails.map((e) => (\n \n \n \n \n \n ))}\n \n

Sender	Subject	Received
{e.sender}	\n {e.subject ? e.subject : (no subject)}\n	{e.received_at} UTC

\n )}\n\n

\n Sent Emails ({sentEmails.length})\n

\n {sentEmails.length === 0 ? (\n

No emails sent yet.

\n ) : (\n \n \n \n \n \n \n \n \n \n {sentEmails.map((e) => (\n \n \n \n \n \n ))}\n \n

Recipient	Subject	Sent
{e.recipient}	\n {e.subject ? e.subject : (no subject)}\n	{e.sent_at} UTC

\n )}\n \n \n );\n\n return new Response(\"\" + renderToString(page), {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n}\n","label",[121],"1bf1deb6-2878-4a24-b75a-618756904e5d",["D",1780948854495],"// Learn more: https://docs.val.town/vals/email/\nimport { recordEmail } from \"./db.ts\";\n\nexport default async function (e: Email) {\n console.log(\"Received email from\", e.from, \"subject:\", e.subject);\n await recordEmail(e.from, e.subject);\n}\n","potluck-email-receiver",[74],"e9cc46cd-aa36-4c11-9556-3914eb296ea0",["D",1780964926725],"import { email } from \"https://esm.town/v/std/email\";\nimport { recordSentEmail } from \"./db.ts\";\n\nconst RECIPIENT = \"potluck.mittal@gmail.com\";\nconst SUBJECT = \"Hi Potluck\";\n\nexport default async function (interval: Interval) {\n const easternTime = new Intl.DateTimeFormat(\"en-US\", {\n timeZone: \"America/New_York\",\n dateStyle: \"full\",\n timeStyle: \"long\",\n }).format(new Date());\n\n await email({\n to: RECIPIENT,\n subject: SUBJECT,\n text: `The current time is ${easternTime} (Eastern).`,\n });\n\n await recordSentEmail(RECIPIENT, SUBJECT);\n}\n",[147],"53fd8a3b-923f-45c6-a17f-bda24a8c7dd8",["D",1780950218085],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst TABLE = \"received_emails\";\n\nexport async function initDb() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n sender TEXT NOT NULL,\n subject TEXT,\n received_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`);\n}\n\nexport async function recordEmail(sender: string, subject?: string) {\n await initDb();\n await sqlite.execute({\n sql: `INSERT INTO ${TABLE} (sender, subject) VALUES (?, ?)`,\n args: [sender, subject ?? null],\n });\n}\n\nexport interface EmailRow {\n id: number;\n sender: string;\n subject: string | null;\n received_at: string;\n}\n\nexport async function listEmails(): Promise {\n await initDb();\n const result = await sqlite.execute(\n `SELECT id, sender, subject, received_at FROM ${TABLE} ORDER BY id DESC`,\n );\n return result.rows as unknown as EmailRow[];\n}\n\nconst SENT_TABLE = \"sent_emails\";\n\nexport async function initSentDb() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${SENT_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n recipient TEXT NOT NULL,\n subject TEXT,\n sent_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`);\n}\n\nexport async function recordSentEmail(recipient: string, subject?: string) {\n await initSentDb();\n await sqlite.execute({\n sql: `INSERT INTO ${SENT_TABLE} (recipient, subject) VALUES (?, ?)`,\n args: [recipient, subject ?? null],\n });\n}\n\nexport interface SentEmailRow {\n id: number;\n recipient: string;\n subject: string | null;\n sent_at: string;\n}\n\nexport async function listSentEmails(): Promise {\n await initSentDb();\n const result = await sqlite.execute(\n `SELECT id, recipient, subject, sent_at FROM ${SENT_TABLE} ORDER BY id DESC`,\n );\n return result.rows as unknown as SentEmailRow[];\n}\n",[105],"pulls","branches","forks","envVars",{"_311":20,"_313":20},"connections",{"_311":20,"_312":20},"count","unfilledCount","emptyCount",{"_43":300,"_13":105,"_72":104,"_53":-5,"_45":46,"_284":151,"_285":218,"_47":328,"_49":50,"_75":76,"_287":302,"_77":24,"_289":-5,"_319":329,"_258":330},{"_43":296,"_13":147,"_72":146,"_53":-5,"_45":46,"_284":201,"_285":218,"_47":325,"_49":90,"_75":148,"_287":298,"_77":24,"_289":-5,"_319":326,"_258":327},{"_43":291,"_13":74,"_72":73,"_53":-5,"_45":46,"_284":108,"_285":218,"_47":322,"_49":90,"_75":95,"_287":293,"_77":24,"_289":294,"_319":323,"_258":324},{"_43":283,"_13":121,"_72":120,"_53":-5,"_45":46,"_284":187,"_285":218,"_47":318,"_49":115,"_75":122,"_287":288,"_77":24,"_289":-5,"_319":320,"_258":321},["D",1780950238640],"children",[],[121],["D",1780948854495],[],[74],["D",1780964926725],[],[147],["D",1780950218085],[],[105],["D",1780948765962],["D",1789501878689],{"_11":12,"_257":80},{"_11":12,"_252":253,"_79":80,"_25":78,"_254":255,"_256":24},{"_49":201,"_13":16,"_43":46,"_244":206,"_245":-5,"_246":-5,"_247":-5,"_248":-5,"_249":-5,"_250":14,"_251":12},"ctx",{"_61":-5,"_276":369,"_370":371,"_372":373,"_374":24,"_375":24,"_376":24,"_377":218,"_378":-5,"_379":-7,"_380":-7,"_381":20,"_382":24,"_383":24,"_384":-5,"_385":24,"_386":24,"_387":24,"_388":-5},"ENV",{"_340":341,"_342":343,"_344":16,"_345":346,"_347":348,"_349":350,"_351":352,"_353":354,"_355":356,"_357":358,"_359":360,"_361":362,"_363":364,"_365":366,"_367":368},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","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"]

History