Sleep Tracker

\n Point a webhook at this val and every request gets stored as-is, and\n bodies shaped like an Apple Health sleep export get parsed into\n nightly stats. View them on the{\" \"}\n sleep page{\" \"}\n or the raw log page.\n

POST /webhook

\n Accepts any HTTP method and any body. Try it:\n

\ncurl -X POST {\"{\"}your-val-url{\"}\"}/webhook -d '{\"{\"}\"hello\": \"world\"{\"}\"}'\n

\n ,\n ));\n\nasync function handleWebhook(c: any) {\n const body = await c.req.text();\n const headers = JSON.stringify(Object.fromEntries(c.req.raw.headers));\n\n await sqlite.execute({\n sql: \"INSERT INTO webhook_requests (received_at, method, url, headers, body) VALUES (?, ?, ?, ?, ?)\",\n args: [new Date().toISOString(), c.req.method, c.req.url, headers, body],\n });\n\n const nightsSaved = await upsertNightSummaries(body);\n\n return c.json({ ok: true, nightsSaved });\n}\n\napp.all(\"/webhook\", handleWebhook);\napp.all(\"/webhook/*\", handleWebhook);\n\napp.get(\"/sleep\", async (c) => {\n const filterDevice = c.req.query(\"device\") ?? \"all\";\n\n let rows: SleepNightRow[];\n if (filterDevice === \"all\") {\n const result = await sqlite.execute(\"SELECT * FROM sleep_nights ORDER BY night_date DESC LIMIT 200\");\n rows = result.rows as unknown as SleepNightRow[];\n } else {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM sleep_nights WHERE device = ? ORDER BY night_date DESC LIMIT 200\",\n args: [filterDevice],\n });\n rows = result.rows as unknown as SleepNightRow[];\n }\n\n const deviceResult = await sqlite.execute(\n \"SELECT DISTINCT device FROM sleep_nights WHERE device IS NOT NULL ORDER BY device\",\n );\n const devices = deviceResult.rows.map((r) => r.device as string);\n\n return c.html(\n \n

Sleep Stats

\n Device:\n c.json({ count: ++count }));\n```\n\n**Static files.** `serveFile` reads the file by path and serves it with the\nright content-type. `.ts` files are transpiled to JS on request by Val Town — so\nyou can write `public/counter.ts` and reference it as\n`

Code