📱 Screen Time Tracker

Total Screen Time

{formatTime(totalScreenTime)}

{isTracking ? \"🟢 Tracking Active\" : \"🔴 Not Tracking\"}

\n \n {isTracking ? \"Stop Tracking\" : \"Start Tracking\"}\n \n

\n Tracking starts automatically when the page is visible\n

\n \n View Source\n \n \n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const KEY = \"screenTimeTrackerApp\";\n const SCHEMA_VERSION = 2;\n\n // Create table for tracking screen time sessions\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_screentime_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n start_time INTEGER NOT NULL,\n end_time INTEGER,\n duration INTEGER\n )\n `);\n\n // Handle routing\n const url = new URL(request.url);\n\n if (url.pathname === \"/screen-time\") {\n // Fetch total screen time\n const result = await sqlite.execute(`\n SELECT COALESCE(SUM(duration), 0) as total_time \n FROM ${KEY}_screentime_${SCHEMA_VERSION}\n `);\n return Response.json({ totalTime: result.rows[0].total_time || 0 });\n }\n\n if (request.method === \"POST\") {\n const now = Date.now();\n\n if (url.pathname === \"/start-tracking\") {\n // Start a new tracking session\n await sqlite.execute(\n `\n INSERT INTO ${KEY}_screentime_${SCHEMA_VERSION} (start_time) \n VALUES (?)\n `,\n [now],\n );\n return Response.json({ startTime: now });\n }\n\n if (url.pathname === \"/stop-tracking\") {\n // Stop the most recent tracking session\n const lastSession = await sqlite.execute(`\n SELECT id, start_time \n FROM ${KEY}_screentime_${SCHEMA_VERSION} \n WHERE end_time IS NULL \n ORDER BY id DESC \n LIMIT 1\n `);\n\n if (lastSession.rows.length > 0) {\n const duration = Math.floor((now - lastSession.rows[0].start_time) / 1000);\n await sqlite.execute(\n `\n UPDATE ${KEY}_screentime_${SCHEMA_VERSION} \n SET end_time = ?, duration = ? \n WHERE id = ?\n `,\n [now, duration, lastSession.rows[0].id],\n );\n\n // Fetch total screen time after update\n const totalResult = await sqlite.execute(`\n SELECT COALESCE(SUM(duration), 0) as total_time \n FROM ${KEY}_screentime_${SCHEMA_VERSION}\n `);\n\n return Response.json({\n endTime: now,\n totalTime: totalResult.rows[0].total_time,\n });\n }\n }\n }\n\n // Serve the main HTML\n return new Response(\n `\n \n \n Screen Time Tracker\n \n \n \n

\n \n \n \n \n `,\n {\n headers: { \"content-type\": \"text/html\" },\n },\n );\n}","deleted","label",[99],"permalink","https://www.val.town/x/khumo/screenTimeTrackerApp/code/main.tsx","extension","actionData","errors"]