📬 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",[98],"permalink","https://www.val.town/x/dcm31/email-streak-tracker-template/code/main.tsx","extension","actionData","errors"]