Steve Krouse

\n Steve Krouse\n

\n \n \n \n \n \n \n \n \n \n

\n);\n\nconst Navigation = () => (\n \n);\n\nasync function getHits() {\n const [, , { rows: [[monthHits]] }, { rows: [[todayHits]] }] = await sqlite.batch([\n \"CREATE TABLE IF NOT EXISTS stevekrouse_com_hits (timestamp DATETIME DEFAULT CURRENT_TIMESTAMP)\",\n \"INSERT INTO stevekrouse_com_hits DEFAULT VALUES\",\n \"SELECT COUNT(*) FROM stevekrouse_com_hits where strftime('%m', timestamp) = strftime('%m', 'now') AND strftime('%Y', timestamp) = strftime('%Y', 'now')\",\n \"SELECT COUNT(*) from stevekrouse_com_hits where strftime('%m', timestamp) = strftime('%m', 'now') AND strftime('%Y', timestamp) = strftime('%Y', 'now') AND strftime('%d', timestamp) = strftime('%d', 'now')\",\n ]);\n if (todayHits % 100 === 0) email({ subject: `You got ${todayHits} hits today! (${monthHits} this month)` });\n return { monthHits, todayHits };\n}\n\nexport default async (request: Request) => {\n const url = new URL(request.url);\n \n // Add placeholder routes for new navigation pages\n switch (url.pathname) {\n case \"/writing\":\n return new Response(\"Writing page coming soon!\");\n case \"/reading\":\n return new Response(\"Reading page coming soon!\");\n case \"/listening\":\n return new Response(\"Listening page coming soon!\");\n case \"/dancing\":\n return new Response(\"Dancing page coming soon!\");\n case \"/about\":\n return new Response(\"About page coming soon!\");\n case \"/contact\":\n return new Response(\"Contact page coming soon!\");\n case \"/favicon.ico\": \n return new Response(null, { status: 404 });\n case \"/test.json\": \n return Response.json({ ok: true });\n case \"/\":\n break;\n default:\n return fetch(\n `https://stevekrouse.github.io/${url.pathname}${url.search}`,\n request as any as RequestInit,\n );\n }\n\n const { monthHits, todayHits } = await getHits();\n return new Response(\n renderToString(\n \n \n Steve Krouse\n \n