📬 Email Streak Tracker

Streak: 🔥 {streak} days

\n\n

\n \n \n

\n\n

\n \n

{monthName} {year}

\n \n

\n\n

\n {[\"S\", \"M\", \"T\", \"W\", \"T\", \"F\", \"S\"].map((d) =>

{d}

)}\n

\n\n

\n {calendarDays.map((day, i) => day ? (\n

\n {new Date(day.date).getDate()}\n

\n ) : (\n

\n ))}\n

\n\n View Source ↗\n

\n );\n}\n\nfunction client() { createRoot(document.getElementById(\"root\")).render(); }\nif (typeof document !== \"undefined\") client();\n\nexport default async function server(req: Request) {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const TABLE = \"emailstreaktracker_emails_v2\";\n\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS ${TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n received_at TEXT,\n from_email TEXT,\n subject TEXT\n )`\n );\n\n const url = new URL(req.url);\n\n if (req.method === \"POST\" && url.pathname === \"/simulateEmail\") {\n await sqlite.execute(\n `INSERT INTO ${TABLE} (received_at, from_email, subject) VALUES (?, ?, ?)` ,\n [new Date().toISOString(), \"simulator@val.town\", \"Simulated email\"]\n );\n console.log(\"Simulated email inserted at\", new Date().toISOString());\n return new Response(JSON.stringify({ ok: true }), { headers: { \"content-type\": \"application/json\" } });\n }\n\n if (req.method === \"POST\" && url.pathname === \"/resetData\") {\n await sqlite.execute(`DELETE FROM ${TABLE}`);\n console.log(\"All email data reset at\", new Date().toISOString());\n return new Response(JSON.stringify({ ok: true }), { headers: { \"content-type\": \"application/json\" } });\n }\n\n if (url.pathname === \"/data\") {\n const tz = url.searchParams.get(\"tz\") || \"UTC\";\n const rows = (await sqlite.execute(`SELECT received_at FROM ${TABLE}`)).rows;\n const dates = rows.map(r => ({ date: new Date(r.received_at).toLocaleDateString(\"en-CA\", { timeZone: tz }) }));\n\n const unique = [...new Set(dates.map(d => d.date))];\n unique.sort();\n let streak = 0;\n let today = new Date().toLocaleDateString(\"en-CA\", { timeZone: tz });\n for (let i = unique.length - 1; i >= 0; i--) {\n const d = new Date(unique[i]);\n const diff = (new Date(today).getTime() - d.getTime()) / 86400000;\n if (diff < streak + 1.5) streak++;\n else break;\n }\n\n return new Response(JSON.stringify({ dates, streak }), { headers: { \"content-type\": \"application/json\" } });\n }\n\n return new Response(`Email Streak Calendar

`, { headers: { \"content-type\": \"text/html; charset=utf-8\" } });\n}","deleted","label","children",[],[99],{"_103":169,"_95":170,"_151":171,"_153":-5,"_154":137,"_155":136,"_156":157,"_105":172,"_100":32,"_159":173,"_161":174,"_163":22,"_164":-5,"_165":175,"_98":176},"514f08c4-ae9c-11f0-b4f3-0224a6c84d84","onEmail.ts","019a07a2-8dfd-723d-8a44-2d19aa3b7ad5",["D",1761064684996],"email","export default async function (e: Email) {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n\n // Use a fixed, static table name to avoid Val Town SQL parsing issues\n const TABLE = \"emailstreaktracker_emails_v2\";\n\n // Ensure table exists\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS ${TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n received_at TEXT,\n from_email TEXT,\n subject TEXT\n )`\n );\n\n // Extract content text (fallbacks in case the field is nested or empty)\n let body = \"\";\n try {\n if (e.text) body = e.text;\n else if (e.html) body = e.html;\n else if (e.raw) body = e.raw;\n else body = JSON.stringify(e);\n } catch {\n body = \"(could not parse body)\";\n }\n\n // Insert a record safely with parameterized values\n await sqlite.execute(\n `INSERT INTO ${TABLE} (received_at, from_email, subject) VALUES (?, ?, ?)`,\n [new Date().toISOString(), e.from || \"unknown\", e.subject || \"(no subject)\"]\n );\n\n console.log(\"📧 Email received:\", {\n from: e.from,\n subject: e.subject,\n time: new Date().toISOString(),\n content: body?.slice(0, 1000) || \"(no content)\", // log only\n });\n}",[],[170],"files",[149,168],"counts",{"_181":32,"_182":136,"_183":32,"_184":185},"pulls","branches","forks","envVars",{"_186":32,"_187":32},"count","emptyCount","contents",[],"file",{"_103":150,"_154":137,"_151":152,"_95":99,"_161":162,"_159":160,"_100":32,"_153":-5,"_105":192,"_155":136,"_164":-5,"_98":193},["D",1761064684996],[99],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.code.$",{"_93":94,"_95":96,"_97":43,"_100":-7,"_98":99,"_101":202,"_147":207,"_177":214,"_190":215,"_188":218,"_219":-5,"_220":-5,"_221":-5,"_222":-5,"_223":224},{"_103":104,"_95":96,"_105":203,"_107":-5,"_108":22,"_109":110,"_111":-5,"_112":-5,"_14":113,"_114":-5,"_115":22,"_116":-5,"_117":32,"_16":118,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_23":204,"_131":205,"_134":206,"_146":22},["D",1761064684996],{"_93":94,"_129":130},{"_93":94,"_133":130},{"_100":136,"_95":43,"_103":137,"_138":104,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":96,"_145":94},[208,211],{"_103":150,"_95":99,"_151":152,"_153":-5,"_154":137,"_155":136,"_156":157,"_105":158,"_100":32,"_159":160,"_161":162,"_163":22,"_164":-5,"_165":209,"_98":210},[],[99],{"_103":169,"_95":170,"_151":171,"_153":-5,"_154":137,"_155":136,"_156":157,"_105":172,"_100":32,"_159":173,"_161":174,"_163":22,"_164":-5,"_165":212,"_98":213},[],[170],[208,211],{"_103":150,"_154":137,"_151":152,"_95":99,"_161":162,"_159":160,"_100":32,"_153":-5,"_105":216,"_155":136,"_164":-5,"_98":217},["D",1761064684996],[99],[],"upstream","pull","ahead","behind","templates",[225,242],{"_103":226,"_95":227,"_105":228,"_107":-5,"_108":22,"_109":110,"_111":229,"_112":230,"_14":231,"_114":232,"_115":157,"_116":233,"_117":234,"_16":235,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_23":236,"_131":239,"_134":240,"_146":22},"8e7382ae-d835-11ef-bbbf-e6cdfca9ef9f","markdownBlogStarter",["D",1737491000655],"Starter template for a markdown blog","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/44a31e5c-3e8a-48a8-d067-5785c0b08200/square512","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","a4a9ad14-d835-11ef-8351-e6cdfca9ef9f",167,12,"e81e7335-6d4c-4764-a902-d0962bbfa9f7",{"_93":237,"_129":238},"stevekrouse","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg",{"_93":237,"_133":238},{"_103":241,"_95":43,"_100":233,"_138":226,"_139":-5,"_140":-5},"8e73c264-d835-11ef-bbbf-e6cdfca9ef9f",{"_103":243,"_95":244,"_105":245,"_107":-5,"_108":22,"_109":110,"_111":246,"_112":-5,"_14":247,"_114":248,"_115":157,"_116":249,"_117":250,"_16":251,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_23":252,"_131":255,"_134":256,"_146":22},"96102714-f528-11ef-aa68-569c3dd06744","reactHonoStarter",["D",1740674013689],"Starter template with client-side React & Hono server","c9143560-63b6-444f-8f9f-e2647fabe09f","a9b2b20a-f528-11ef-9e98-569c3dd06744",39,14,"c606f87f-4d7e-48c8-9c39-ef5ab94aec49",{"_93":253,"_129":254},"std","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJVaVhpQ1BId3dscVpBbkdZVWlMNjJtcjkxWS5wbmcifQ",{"_93":253,"_133":254},{"_103":257,"_95":43,"_100":258,"_138":243,"_139":-5,"_140":-5},"961078ea-f528-11ef-aa68-569c3dd06744",72,"actionData","errors"]

dcm31

email-streak-tracker-template