📬 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",[],[150],{"_102":169,"_95":170,"_151":171,"_153":-5,"_154":136,"_155":135,"_156":157,"_104":172,"_99":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",[148,168],"counts",{"_181":32,"_182":135,"_183":32,"_184":185},"pulls","branches","forks","envVars",{"_186":32,"_187":32},"count","emptyCount","contents",[190,193],{"_102":149,"_95":150,"_151":152,"_153":-5,"_154":136,"_155":135,"_156":157,"_104":191,"_99":32,"_159":160,"_161":162,"_163":22,"_164":-5,"_98":192},["D",1761064684996],[150],{"_102":169,"_95":170,"_151":171,"_153":-5,"_154":136,"_155":135,"_156":157,"_104":194,"_99":32,"_159":173,"_161":174,"_163":22,"_164":-5,"_98":195},["D",1761064684996],[170],"file","upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name._index",{"_93":94,"_95":96,"_97":-7,"_99":-7,"_100":205,"_188":210,"_215":-7,"_216":-5,"_217":-5,"_177":218,"_225":226,"_227":-5,"_228":-5},{"_102":103,"_95":96,"_104":206,"_106":-5,"_107":22,"_108":109,"_110":-5,"_111":-5,"_14":112,"_113":-5,"_114":22,"_115":-5,"_116":32,"_16":117,"_118":119,"_120":119,"_121":122,"_123":122,"_124":122,"_125":119,"_126":119,"_23":207,"_130":208,"_133":209,"_145":22},["D",1761064684996],{"_93":94,"_128":129},{"_93":94,"_132":129},{"_99":135,"_95":43,"_102":136,"_137":103,"_138":-5,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":96,"_144":94},[211,213],{"_102":149,"_95":150,"_151":152,"_153":-5,"_154":136,"_155":135,"_156":157,"_104":191,"_99":32,"_159":160,"_161":162,"_163":22,"_164":-5,"_98":212},[150],{"_102":169,"_95":170,"_151":171,"_153":-5,"_154":136,"_155":135,"_156":157,"_104":194,"_99":32,"_159":173,"_161":174,"_163":22,"_164":-5,"_98":214},[170],"readme","upstream","pull",[219,222],{"_102":149,"_95":150,"_151":152,"_153":-5,"_154":136,"_155":135,"_156":157,"_104":158,"_99":32,"_159":160,"_161":162,"_163":22,"_164":-5,"_165":220,"_98":221},[],[150],{"_102":169,"_95":170,"_151":171,"_153":-5,"_154":136,"_155":135,"_156":157,"_104":172,"_99":32,"_159":173,"_161":174,"_163":22,"_164":-5,"_165":223,"_98":224},[],[170],"previews",[219],"ahead","behind","actionData","errors"]

dcm31

email-streak-tracker-template