📬 Check your email

\n We sent a sign-in link to {email}.\n

\n );\n }\n\n return (\n

\n \n Email\n setEmail((e.target as HTMLInputElement).value)}\n placeholder=\"you@example.com\"\n class=\"mt-1 block w-full px-3 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-blue-500 focus:border-blue-500 outline-none\"\n disabled={status === \"sending\"}\n />\n \n \n {status === \"sending\" ? \"Sending…\" : \"Send magic link\"}\n \n {status === \"error\" &&

{errorMsg}

}\n \n );\n}",[188,94,75],"5ec82147-a1d2-4fcf-b744-8d02b3351754",["D",1784363970193],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport { createAuthClient } from \"https://esm.sh/better-auth@1.6.9/react?deps=react@18.2.0,react-dom@18.2.0\";\nimport { magicLinkClient } from \"https://esm.sh/better-auth@1.6.9/client/plugins?deps=react@18.2.0,react-dom@18.2.0\";\n\nconst authClient = createAuthClient({\n plugins: [magicLinkClient()],\n});\n\ntype User = {\n id: string;\n email: string;\n name: string;\n image?: string | null;\n};\n\ntype PillLog = {\n id: number;\n timestamp: number;\n dose: number;\n};\n\nexport function Dashboard({ user }: { user: User }) {\n const [logs, setLogs] = useState([]);\n const [nfcUrl, setNfcUrl] = useState(null);\n const [loading, setLoading] = useState(true);\n const [showLogging, setShowLogging] = useState(false);\n\n const fetchStats = async () => {\n try {\n const res = await fetch(\"/api/pill/stats\");\n const data = await res.json();\n setLogs(data.logs || []);\n } catch (e) {\n console.error(\"Failed to fetch stats\", e);\n } finally {\n setLoading(false);\n }\n };\n\n useEffect(() => {\n fetchStats();\n const interval = setInterval(fetchStats, 60000);\n return () => clearInterval(interval);\n }, []);\n\n const logPill = async (dose: number) => {\n await fetch(\"/api/pill/log\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ dose }),\n });\n fetchStats();\n };\n\n const generateNfcUrl = async () => {\n const res = await fetch(\"/api/pill/nfc-token\", { method: \"POST\" });\n const data = await res.json();\n setNfcUrl(data.url);\n };\n\n const lastPill = logs[0];\n const timeSinceLast = lastPill\n ? Math.floor((Date.now() - lastPill.timestamp) / (1000 * 60))\n : null;\n\n const formatTime = (minutes: number) => {\n const hrs = Math.floor(minutes / 60);\n const mins = minutes % 60;\n if (hrs === 0) return `${mins}m`;\n return `${hrs}h ${mins}m`;\n };\n\n // Sunrise logic (6 AM)\n const getSunrise = (date: Date) => {\n const s = new Date(date);\n s.setHours(6, 0, 0, 0);\n return s;\n };\n\n const today = new Date();\n const currentSunrise = getSunrise(today);\n if (today < currentSunrise) {\n currentSunrise.setDate(currentSunrise.getDate() - 1);\n }\n const tookToday = logs.some((log) =>\n log.timestamp > currentSunrise.getTime()\n );\n\n // Consolidated History: Today (index 0) + 14 Past Days\n const history = Array.from({ length: 15 }, (_, i) => {\n const s = new Date(currentSunrise);\n s.setDate(s.getDate() - i);\n const nextS = new Date(s);\n nextS.setDate(s.getDate() + 1);\n\n const dayLogs = logs.filter((log) =>\n log.timestamp >= s.getTime() && log.timestamp < nextS.getTime()\n );\n return {\n date: s,\n doses: dayLogs.reduce((acc, log) => acc + log.dose, 0),\n isToday: i === 0,\n };\n });\n\n // Protection Logic - Last 7 Past Days (indices 1 to 7)\n const past7Days = history.slice(1, 8);\n const missedCount = past7Days.filter((d) => d.doses === 0).length;\n const activeDaysCount = past7Days.filter((d) => d.doses > 0).length;\n\n // Double dose catch-up rule\n let hasDoubleDoseCatchup = false;\n const doubleDoseDayIndex = past7Days.findIndex((d) => d.doses >= 2);\n if (doubleDoseDayIndex !== -1) {\n // Check if every day AFTER the most recent double dose has >= 1 dose\n const daysAfterDoubleDose = past7Days.slice(0, doubleDoseDayIndex);\n hasDoubleDoseCatchup = daysAfterDoubleDose.every((d) => d.doses >= 1);\n }\n\n const isVeryHigh = (missedCount <= 1) || hasDoubleDoseCatchup;\n const isHigh = activeDaysCount >= 4;\n\n const veryHighReason = missedCount === 0\n ? \"Perfect Adherence (Past 7 Days)\"\n : missedCount === 1\n ? \"Strong Adherence (6/7 Past Days)\"\n : hasDoubleDoseCatchup\n ? \"Recent Double Dose Catch-up\"\n : null;\n\n const maxCount = Math.max(...history.map((d) => d.doses), 1);\n const chartData = [...history].reverse();\n\n return (\n

\n \n \n

{tookToday ? \"Took today\" : \"Not yet taken\"}

\n\n {timeSinceLast !== null && (\n

Since last pill

{formatTime(timeSinceLast)}

\n )}\n

\n\n

Protection Status

\n {isVeryHigh\n ? \"🛡️ Very High Protection\"\n : isHigh\n ? \"🛡️ High Protection\"\n : \"⚠️ Low Protection\"}\n {isVeryHigh && veryHighReason && (\n {veryHighReason}\n )}\n

\n {isVeryHigh ? \"✓\" : \"○\"}\n

Very High Protection Standard

\n {missedCount <= 1\n ? `Met: ${7 - missedCount}/7 past days taken`\n : hasDoubleDoseCatchup\n ? \"Met: Double dose followed by perfect adherence\"\n : \"Unmet: Requires ≤ 1 miss in past 7 days\"}\n

\n {isHigh ? \"✓\" : \"○\"}\n

High Protection Standard

\n {activeDaysCount}/7 active past days ({isHigh\n ? \"Met\"\n : \"Requires ≥ 4\"})\n

\n\n

\n setShowLogging(!showLogging)}\n className=\"btn-outline flex items-center justify-between\"\n >\n {showLogging ? \"Hide Logging\" : \"Manual Logging\"}\n {showLogging ? \"▲\" : \"▼\"}\n \n\n {showLogging && (\n

\n \n \n

\n )}\n

\n\n

History (Last 14 Days + Today)

\n {chartData.map((day, i) => (\n

\n \n {day.doses > 0 && {day.doses}\n }\n {day.isToday && day.doses === 0 && (\n ?\n )}\n

\n \n {day.isToday ? \"T\" : day.date.getDate()}\n \n

\n ))}\n

\n\n

\n \n {nfcUrl && (\n

{nfcUrl}

\n navigator.clipboard.writeText(nfcUrl)}\n className=\"text-xs text-blue-500 underline mt-1\"\n >\n Copy URL\n \n

\n )}\n

\n\n

Signed in as {user.email}

\n authClient.signOut().then(() => location.reload())}\n className=\"text-xs text-red-500 underline\"\n >\n Sign out\n \n

\n\n \n \n );\n}",[188,94,87],"893c6f36-945d-4afd-9196-e86149935451",["D",1784363970193],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { SignIn } from \"./SignIn.tsx\";\nimport { Dashboard } from \"./Dashboard.tsx\";\n\nimport { createAuthClient } from \"https://esm.sh/better-auth@1.6.9/react?deps=react@18.2.0,react-dom@18.2.0\";\nimport { magicLinkClient } from \"https://esm.sh/better-auth@1.6.9/client/plugins?deps=react@18.2.0,react-dom@18.2.0\";\n\nconst authClient = createAuthClient({\n plugins: [magicLinkClient()],\n});\n\nexport function App() {\n // Reactive session — updates automatically on sign in / sign out.\n const { data: session, isPending } = authClient.useSession();\n\n return (\n

Pill Tracker

\n Track your daily doses with ease.\n

\n\n {isPending\n ?

Loading…

\n : session?.user\n ? \n : }\n\n

\n View source\n

\n );\n}",[188,94,92],"pulls","branches","forks","envVars",{"_88":212,"_213":26},"connections",{"_88":26,"_211":26},"unfilledCount",2,"emptyCount",{"_33":357,"_13":328,"_73":323,"_43":-5,"_35":36,"_182":40,"_183":24,"_37":358,"_39":26,"_76":95,"_185":-5,"_78":30,"_186":-5,"_240":359,"_17":360},{"_33":350,"_13":351,"_73":352,"_43":323,"_35":36,"_182":40,"_183":24,"_37":353,"_39":26,"_76":77,"_185":354,"_78":30,"_186":-5,"_240":355,"_17":356},{"_33":343,"_13":344,"_73":345,"_43":323,"_35":36,"_182":40,"_183":24,"_37":346,"_39":26,"_76":77,"_185":347,"_78":30,"_186":-5,"_240":348,"_17":349},{"_33":336,"_13":337,"_73":338,"_43":323,"_35":36,"_182":40,"_183":24,"_37":339,"_39":26,"_76":77,"_185":340,"_78":30,"_186":-5,"_240":341,"_17":342},{"_33":329,"_13":330,"_73":331,"_43":323,"_35":36,"_182":89,"_183":24,"_37":332,"_39":40,"_76":77,"_185":333,"_78":30,"_186":-5,"_240":334,"_17":335},{"_33":320,"_13":321,"_73":322,"_43":323,"_35":36,"_182":280,"_183":24,"_37":324,"_39":26,"_76":77,"_185":325,"_78":30,"_186":-5,"_240":326,"_17":327},{"_33":316,"_13":315,"_73":310,"_43":-5,"_35":36,"_182":212,"_183":24,"_37":317,"_39":26,"_76":95,"_185":-5,"_78":30,"_186":-5,"_240":318,"_17":319},{"_33":307,"_13":308,"_73":309,"_43":310,"_35":36,"_182":212,"_183":24,"_37":311,"_39":26,"_76":77,"_185":312,"_78":30,"_186":-5,"_240":313,"_17":314},{"_33":303,"_13":188,"_73":181,"_43":-5,"_35":36,"_182":40,"_183":24,"_37":304,"_39":26,"_76":95,"_185":-5,"_78":30,"_186":-5,"_240":305,"_17":306},{"_33":180,"_13":94,"_73":93,"_43":181,"_35":36,"_182":40,"_183":24,"_37":300,"_39":26,"_76":95,"_185":-5,"_78":30,"_186":-5,"_240":301,"_17":302},{"_33":200,"_13":92,"_73":91,"_43":93,"_35":36,"_182":40,"_183":24,"_37":297,"_39":26,"_76":77,"_185":202,"_78":30,"_186":-5,"_240":298,"_17":299},{"_33":196,"_13":87,"_73":86,"_43":93,"_35":36,"_182":40,"_183":24,"_37":294,"_39":26,"_76":77,"_185":198,"_78":30,"_186":-5,"_240":295,"_17":296},{"_33":192,"_13":75,"_73":74,"_43":93,"_35":36,"_182":40,"_183":24,"_37":291,"_39":26,"_76":77,"_185":194,"_78":30,"_186":-5,"_240":292,"_17":293},{"_33":284,"_13":285,"_73":286,"_43":181,"_35":36,"_182":40,"_183":24,"_37":287,"_39":26,"_76":21,"_185":288,"_78":30,"_186":-5,"_240":289,"_17":290},{"_33":275,"_13":276,"_73":277,"_43":181,"_35":36,"_182":278,"_183":24,"_37":279,"_39":280,"_76":21,"_185":281,"_78":30,"_186":-5,"_240":282,"_17":283},{"_33":267,"_13":268,"_73":269,"_43":181,"_35":36,"_182":134,"_183":24,"_37":270,"_39":271,"_76":77,"_185":272,"_78":30,"_186":-5,"_240":273,"_17":274},{"_33":259,"_13":260,"_73":261,"_43":181,"_35":36,"_182":262,"_183":24,"_37":263,"_39":40,"_76":21,"_185":264,"_78":30,"_186":-5,"_240":265,"_17":266},{"_33":251,"_13":252,"_73":253,"_43":-5,"_35":36,"_182":254,"_183":24,"_37":255,"_39":40,"_76":21,"_185":256,"_78":30,"_186":-5,"_240":257,"_17":258},{"_33":243,"_13":244,"_73":107,"_43":-5,"_35":36,"_182":245,"_183":24,"_37":246,"_39":247,"_76":238,"_185":248,"_78":30,"_186":-5,"_240":249,"_17":250},{"_33":234,"_13":235,"_73":236,"_43":-5,"_35":36,"_182":40,"_183":24,"_37":237,"_39":26,"_76":238,"_185":239,"_78":30,"_186":-5,"_240":241,"_17":242},"5a08602f-2e13-4a60-8f0f-02a2f48fc753","public-index.ts","019f7461-6ee4-74b9-881f-e64708a88cea",["D",1784363970193],"http","import { serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { Hono } from \"npm:hono\";\n\nconst app = new Hono<{}>();\n\n// Public NFC endpoint\napp.get(\"/api/pill/track/:token\", async (c) => {\n const token = c.req.param(\"token\");\n\n const result = await sqlite.execute(\n \"SELECT userId FROM nfc_tokens WHERE token = ?\",\n [token],\n );\n\n if (result.rows.length === 0) {\n return c.html(\"

Invalid or expired token

\", 404);\n }\n\n const userId = result.rows[0].userId;\n\n await sqlite.execute(\n \"INSERT INTO pill_logs (userId, timestamp, dose) VALUES (?, ?, ?)\",\n [userId, Date.now(), 1],\n );\n\n // Redirect to success page\n return c.redirect(\"/success\", 303);\n});\n\n// Success page route\napp.get(\"/success\", () => {\n return serveFile(\"/frontend/success.html\");\n});\n\n// Unwrap and rethrow Hono errors as the original error\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;","children",[],[235],"38a529a4-0207-487e-a0f6-11105c522949","index.ts",34,["D",1784465027728],5,"import { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { Hono } from \"npm:hono@4.12.23\";\nimport { auth } from \"./backend/auth.ts\";\nimport { ensureSchema } from \"./backend/schema.ts\";\nimport { WATER_CONFIG, DB_TABLES } from \"./config/constants.ts\";\nimport {\n getTodayStartTime,\n getTodayEndTime,\n getProgressPercentage,\n} from \"./backend/water-utils.ts\";\n\n// Create Better Auth's tables on first run. Idempotent (CREATE TABLE IF NOT EXISTS).\nawait ensureSchema();\n\nconst app = new Hono<{\n Variables: {\n user: typeof auth.$Infer.Session.user | null;\n session: typeof auth.$Infer.Session.session | null;\n };\n}>();\n\n// Mount Better Auth — handles /api/auth/sign-in/magic-link, /api/auth/get-session, etc.\napp.on([\"GET\", \"POST\"], \"/api/auth/*\", (c) => auth.handler(c.req.raw));\n\n// Make the session available to downstream routes via c.get(\"user\") / c.get(\"session\").\napp.use(\"*\", async (c, next) => {\n const session = await auth.api.getSession({\n headers: c.req.raw.headers,\n });\n c.set(\"user\", session?.user ?? null);\n c.set(\"session\", session?.session ?? null);\n await next();\n});\n\n// ============ WATER TRACKING ENDPOINTS ============\n\n// Log water intake\napp.post(\"/api/water/log\", async (c) => {\n const user = c.get(\"user\");\n if (!user) return c.json({ error: \"Not authenticated\" }, 401);\n\n const { milliliters, source = \"manual\" } = await c.req.json() as {\n milliliters?: number;\n source?: string;\n };\n\n if (!milliliters || milliliters < 1) {\n return c.json({ error: \"Invalid milliliters\" }, 400);\n }\n\n const now = Date.now();\n await sqlite.execute(\n `INSERT INTO ${DB_TABLES.WATER_LOGS} (userId, timestamp, milliliters, source, createdAt) VALUES (?, ?, ?, ?, ?)`,\n [user.id, now, milliliters, source, now],\n );\n\n return c.json({ success: true, timestamp: now });\n});\n\n// Get today's water intake\napp.get(\"/api/water/today\", async (c) => {\n const user = c.get(\"user\");\n if (!user) return c.json({ error: \"Not authenticated\" }, 401);\n\n const todayStart = getTodayStartTime();\n const todayEnd = getTodayEndTime();\n\n const result = await sqlite.execute(\n `SELECT id, timestamp, milliliters, source FROM ${DB_TABLES.WATER_LOGS} \n WHERE userId = ? AND timestamp >= ? AND timestamp < ? \n ORDER BY timestamp DESC`,\n [user.id, todayStart, todayEnd],\n );\n\n const logs = result.rows.map((row) => ({\n id: row.id as number,\n timestamp: row.timestamp as number,\n milliliters: row.milliliters as number,\n source: row.source as string,\n }));\n\n const totalToday = logs.reduce((sum, log) => sum + log.milliliters, 0);\n const percentage = getProgressPercentage(totalToday);\n\n return c.json({\n totalToday,\n target: WATER_CONFIG.DAILY_TARGET_ML,\n percentage,\n logs,\n resetHour: WATER_CONFIG.RESET_HOUR_UTC,\n });\n});\n\n// Get water intake history (last N days)\napp.get(\"/api/water/history\", async (c) => {\n const user = c.get(\"user\");\n if (!user) return c.json({ error: \"Not authenticated\" }, 401);\n\n const days = parseInt(c.req.query(\"days\") || \"7\");\n // Start from the beginning of the current water day, then go back N days\n const nDaysAgo = getTodayStartTime() - days * 24 * 60 * 60 * 1000;\n\n const result = await sqlite.execute(\n `SELECT timestamp, milliliters FROM ${DB_TABLES.WATER_LOGS} \n WHERE userId = ? AND timestamp >= ? \n ORDER BY timestamp DESC`,\n [user.id, nDaysAgo],\n );\n\n // Group by water day (shifts the boundary to the 5 AM UTC reset hour\n // so entries between midnight and 5 AM UTC are grouped with the previous day)\n const resetOffsetMs = WATER_CONFIG.RESET_HOUR_UTC * 60 * 60 * 1000;\n const byDay = new Map();\n\n for (const row of result.rows) {\n const adjusted = new Date((row.timestamp as number) - resetOffsetMs);\n const dateKey = adjusted.toISOString().split(\"T\")[0];\n const current = byDay.get(dateKey) || 0;\n byDay.set(dateKey, current + (row.milliliters as number));\n }\n\n const history = Array.from(byDay.entries())\n .sort(([dateA], [dateB]) => dateB.localeCompare(dateA))\n .map(([date, total]) => ({\n date,\n total,\n percentage: getProgressPercentage(total),\n }));\n\n return c.json({ history });\n});\n\n// Delete a log entry\napp.delete(\"/api/water/:id\", async (c) => {\n const user = c.get(\"user\");\n if (!user) return c.json({ error: \"Not authenticated\" }, 401);\n\n const id = c.req.param(\"id\");\n const result = await sqlite.execute(\n `DELETE FROM ${DB_TABLES.WATER_LOGS} WHERE id = ? AND userId = ?`,\n [id, user.id],\n );\n\n if (result.rowsAffected === 0) {\n return c.json({ error: \"Not found\" }, 404);\n }\n\n return c.json({ success: true });\n});\n\n// ============ NFC ENDPOINTS ============\n\n// Create NFC device — returns a tap URL to write to the NFC tag\napp.post(\"/api/nfc/device\", async (c) => {\n const user = c.get(\"user\");\n if (!user) return c.json({ error: \"Not authenticated\" }, 401);\n\n const { milliliters, name } = await c.req.json() as {\n milliliters?: number;\n name?: string;\n };\n\n const token = crypto.randomUUID();\n const deviceId = crypto.randomUUID();\n const ml = Math.max(\n WATER_CONFIG.MIN_ML_PER_TAP,\n Math.min(milliliters || WATER_CONFIG.DEFAULT_ML_PER_TAP, WATER_CONFIG.MAX_ML_PER_TAP),\n );\n const now = Date.now();\n\n await sqlite.execute(\n `INSERT INTO ${DB_TABLES.NFC_DEVICES} (id, userId, token, milliliters, name, createdAt, updatedAt) VALUES (?, ?, ?, ?, ?, ?, ?)`,\n [deviceId, user.id, token, ml, name || `NFC Device ${deviceId.slice(0, 8)}`, now, now],\n );\n\n const origin = new URL(c.req.url).origin;\n const tapUrl = `${origin}/api/nfc/tap/${token}`;\n\n return c.json({ deviceId, token, milliliters: ml, name: name || `NFC Device ${deviceId.slice(0, 8)}`, tapUrl });\n});\n\n// Tap NFC device (log water intake)\napp.get(\"/api/nfc/tap/:token\", async (c) => {\n const token = c.req.param(\"token\");\n\n const result = await sqlite.execute(\n `SELECT id, userId, milliliters FROM ${DB_TABLES.NFC_DEVICES} WHERE token = ?`,\n [token],\n );\n\n if (result.rows.length === 0) {\n return c.text(\"NFC device not found\", 404);\n }\n\n const device = result.rows[0];\n const now = Date.now();\n\n // Log the water intake\n await sqlite.execute(\n `INSERT INTO ${DB_TABLES.WATER_LOGS} (userId, timestamp, milliliters, source, createdAt) VALUES (?, ?, ?, ?, ?)`,\n [device.userId as string, now, device.milliliters as number, \"nfc\", now],\n );\n\n const ml = device.milliliters as number;\n // Redirect to success page so a browser refresh doesn't re-log\n return c.redirect(`/success?ml=${ml}`);\n});\n\n// Success page (no logging — safe to refresh)\napp.get(\"/success\", (c) => serveFile(\"/frontend/success.html\"));\n\n// Get user's NFC devices\napp.get(\"/api/nfc/devices\", async (c) => {\n const user = c.get(\"user\");\n if (!user) return c.json({ error: \"Not authenticated\" }, 401);\n\n const result = await sqlite.execute(\n `SELECT id, token, milliliters, name, createdAt FROM ${DB_TABLES.NFC_DEVICES} WHERE userId = ? ORDER BY createdAt DESC`,\n [user.id],\n );\n\n const devices = result.rows.map((row) => ({\n id: row.id as string,\n token: row.token as string,\n milliliters: row.milliliters as number,\n name: row.name as string,\n createdAt: row.createdAt as number,\n }));\n\n return c.json({ devices });\n});\n\n// Update NFC device\napp.patch(\"/api/nfc/device/:id\", async (c) => {\n const user = c.get(\"user\");\n if (!user) return c.json({ error: \"Not authenticated\" }, 401);\n\n const id = c.req.param(\"id\");\n const { milliliters, name } = await c.req.json() as {\n milliliters?: number;\n name?: string;\n };\n\n const updates: string[] = [];\n const values: (string | number)[] = [];\n\n if (milliliters !== undefined) {\n const ml = Math.max(\n WATER_CONFIG.MIN_ML_PER_TAP,\n Math.min(milliliters, WATER_CONFIG.MAX_ML_PER_TAP),\n );\n updates.push(\"milliliters = ?\");\n values.push(ml);\n }\n\n if (name !== undefined) {\n updates.push(\"name = ?\");\n values.push(name);\n }\n\n if (updates.length === 0) {\n return c.json({ error: \"Nothing to update\" }, 400);\n }\n\n updates.push(\"updatedAt = ?\");\n values.push(Date.now());\n values.push(id);\n values.push(user.id);\n\n const result = await sqlite.execute(\n `UPDATE ${DB_TABLES.NFC_DEVICES} SET ${updates.join(\", \")} WHERE id = ? AND userId = ?`,\n values,\n );\n\n if (result.rowsAffected === 0) {\n return c.json({ error: \"Not found\" }, 404);\n }\n\n return c.json({ success: true });\n});\n\n// Delete NFC device\napp.delete(\"/api/nfc/device/:id\", async (c) => {\n const user = c.get(\"user\");\n if (!user) return c.json({ error: \"Not authenticated\" }, 401);\n\n const id = c.req.param(\"id\");\n const result = await sqlite.execute(\n `DELETE FROM ${DB_TABLES.NFC_DEVICES} WHERE id = ? AND userId = ?`,\n [id, user.id],\n );\n\n if (result.rowsAffected === 0) {\n return c.json({ error: \"Not found\" }, 404);\n }\n\n return c.json({ success: true });\n});\n\n// ============ FRONTEND ============\n\n// Serve the frontend\napp.get(\"/\", () => serveFile(\"/frontend/index.html\"));\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path));\n\n// View source redirect\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// Unwrap and rethrow Hono errors as the original error so we get real stack traces.\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n",[],[244],"4e09f6e7-fb9f-471d-b2c7-5f56ddebe291","README.md","019f7461-6ee4-74b9-881f-dcc6c26efd2c",8,["D",1784364219802],"# 💧 Water Intake Tracker\n\nA modern web app to track your daily water intake with a 2L daily goal. Features manual logging, NFC device registration for quick taps, and automatic daily reset at 5 AM UTC.\n\n## Features\n\n- ✅ **Daily Goal Tracking** - Visual progress bar towards 2L daily target\n- 📱 **Quick Add Buttons** - Log common amounts (250ml, 500ml, 750ml, 1L) with one tap\n- 🎯 **Custom Amount** - Add any custom amount you drank\n- 🏷️ **Water Log History** - View all today's entries with timestamps\n- 📴 **NFC Integration** - Register NFC devices/tags that auto-log water on tap\n- 🔄 **Daily Reset** - Automatic reset at 5 AM UTC each day\n- 🔐 **Authentication** - Magic link sign-in via Better Auth\n- 📊 **Stats** - Track your water intake over time\n\n## Architecture\n\n```\n├── config/\n│ └── constants.ts # All configuration constants in one place\n├── backend/\n│ ├── schema.ts # SQLite schema with water & NFC tables\n│ ├── water-utils.ts # Utility functions for water tracking\n│ └── auth.ts # Better Auth configuration\n├── frontend/\n│ ├── index.html # Main HTML template\n│ └── index.tsx # React app with tab-based UI\n└── index.ts # Hono API server with all endpoints\n```\n\n## Configuration\n\nAll constants are defined in `config/constants.ts`:\n\n```typescript\nexport const WATER_CONFIG = {\n DAILY_TARGET_ML: 2000, // Change daily goal here (in ml)\n RESET_HOUR_UTC: 5, // Change reset time here (UTC)\n QUICK_ADD_AMOUNTS: [250, 500, 750, 1000],\n MIN_ML_PER_TAP: 100, // Minimum per NFC tap\n MAX_ML_PER_TAP: 1000, // Maximum per NFC tap\n DEFAULT_ML_PER_TAP: 500, // Default amount for new NFC devices\n};\n```\n\n## API Endpoints\n\n### Water Tracking\n\n- `POST /api/water/log` - Log water intake\n ```json\n { \"milliliters\": 500, \"source\": \"manual\" }\n ```\n\n- `GET /api/water/today` - Get today's intake and logs\n- `GET /api/water/history?days=7` - Get intake history\n- `DELETE /api/water/:id` - Delete a log entry\n\n### NFC Devices\n\n- `POST /api/nfc/register` - Start NFC device registration (returns registration URL)\n- `POST /api/nfc/device` - Complete NFC device registration\n- `GET /api/nfc/devices` - Get user's registered NFC devices\n- `PATCH /api/nfc/device/:id` - Update device settings\n- `DELETE /api/nfc/device/:id` - Delete a device\n- `GET /api/nfc/tap/:token` - NFC tap endpoint (logs water automatically)\n\n## How NFC Works\n\n1. **Register Device**\n - Click \"Start Registration\" in NFC Devices tab\n - A QR code is generated with a registration URL\n - Share/scan the QR with your NFC device/app\n\n2. **Complete Registration**\n - When the device scans the link, you specify the water amount (default 500ml)\n - Device is saved and ready to use\n\n3. **Log Water**\n - Each tap of the registered NFC device logs water automatically\n - Shows success page with logged amount\n\n## Database Schema\n\n### water_logs\n- `id` - Auto-increment primary key\n- `userId` - User who logged the water\n- `timestamp` - When water was logged\n- `milliliters` - Amount of water (in ml)\n- `source` - \"manual\" or \"nfc\"\n- `createdAt` - Record creation time\n\n### nfc_devices\n- `id` - Device UUID\n- `userId` - Owner of the device\n- `token` - Unique tap token\n- `milliliters` - Amount logged per tap\n- `name` - Device name\n- `createdAt` - When registered\n- `updatedAt` - Last update time\n\n### nfc_tokens\n- `token` - Registration token (UUID)\n- `userId` - User registering the device\n- `createdAt` - Token creation time\n\n## Daily Reset\n\nThe app automatically treats the day as starting at **5 AM UTC** and ending at the next 5 AM UTC. This is calculated server-side in `getTodayStartTime()` so it works regardless of user timezone.\n\nTo change the reset time, edit `RESET_HOUR_UTC` in `config/constants.ts`.\n\n## Usage\n\n1. Sign in with magic link\n2. Click quick-add buttons or enter custom amount\n3. Watch your progress bar fill up\n4. Optionally register NFC devices for one-tap logging\n5. Check history anytime\n\n## Tech Stack\n\n- **Backend**: Hono (TypeScript)\n- **Database**: SQLite with Val Town blob storage\n- **Frontend**: React with Twind CSS\n- **Auth**: Better Auth with magic links\n- **Runtime**: Deno on Val Town\n",[],[252],"eb77ce26-e9da-40a3-9497-49fd639bf05e","success.html","019f7461-6ee4-74b9-881f-d6e3a26918a1",33,["D",1784465023085],"\n\n \n \n \n Water Logged\n \n \n \n

💧

Water Logged!

—

added to your daily intake

\n Go to Dashboard\n

\n \n \n\n",[],[188,260],"c11435f4-7dcb-40e3-a339-ba9f90590f78","index.tsx","019f7461-6ee4-74b9-881f-d020075e4cf0",["D",1784465181334],20,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { createAuthClient } from \"https://esm.sh/better-auth@1.6.9/react?deps=react@18.2.0,react-dom@18.2.0\";\nimport { magicLinkClient } from \"https://esm.sh/better-auth@1.6.9/client/plugins?deps=react@18.2.0,react-dom@18.2.0\";\n\nconst authClient = createAuthClient({\n plugins: [magicLinkClient()],\n});\n\nconst WATER_CONFIG = {\n DAILY_TARGET_ML: 2000,\n QUICK_ADD_AMOUNTS: [250, 500, 750, 1000],\n RESET_HOUR_UTC: 5,\n};\n\ninterface WaterLog {\n id: number;\n timestamp: number;\n milliliters: number;\n source: string;\n}\n\ninterface TodayData {\n totalToday: number;\n target: number;\n percentage: number;\n logs: WaterLog[];\n resetHour: number;\n}\n\ninterface NFCDevice {\n id: string;\n token: string;\n milliliters: number;\n name: string;\n createdAt: number;\n}\n\ninterface HistoryEntry {\n date: string;\n total: number;\n percentage: number;\n}\n\nfunction App() {\n const [isAuthenticated, setIsAuthenticated] = useState(false);\n const [loading, setLoading] = useState(true);\n const [todayData, setTodayData] = useState(null);\n const [nfcDevices, setNfcDevices] = useState([]);\n const [activeTab, setActiveTab] = useState<\"today\" | \"history\" | \"nfc\">(\"today\");\n const [toast, setToast] = useState<{ message: string; type: \"success\" | \"error\" } | null>(null);\n const [customMl, setCustomMl] = useState(\"\");\n const [history, setHistory] = useState([]);\n const [newNfcName, setNewNfcName] = useState(\"\");\n const [newNfcMl, setNewNfcMl] = useState(\"500\");\n const [createdTapUrl, setCreatedTapUrl] = useState(null);\n const [editingDeviceId, setEditingDeviceId] = useState(null);\n const [editMl, setEditMl] = useState(\"\");\n\n const [email, setEmail] = useState(\"\");\n const [signInStatus, setSignInStatus] = useState<\"idle\" | \"sending\" | \"sent\" | \"error\">(\"idle\");\n\n // Check authentication\n useEffect(() => {\n const checkAuth = async () => {\n try {\n const res = await fetch(\"/api/auth/get-session\");\n const data = await res.json();\n setIsAuthenticated(!!data.session);\n if (data.session) {\n await loadTodayData();\n await loadNfcDevices();\n await loadHistory();\n }\n } catch (err) {\n console.error(\"Auth check failed:\", err);\n } finally {\n setLoading(false);\n }\n };\n checkAuth();\n }, []);\n\n const loadTodayData = async () => {\n try {\n const res = await fetch(\"/api/water/today\");\n if (res.ok) {\n const data = await res.json();\n setTodayData(data);\n }\n } catch (err) {\n console.error(\"Failed to load today data:\", err);\n }\n };\n\n const loadNfcDevices = async () => {\n try {\n const res = await fetch(\"/api/nfc/devices\");\n if (res.ok) {\n const data = await res.json();\n setNfcDevices(data.devices);\n }\n } catch (err) {\n console.error(\"Failed to load NFC devices:\", err);\n }\n };\n\n const loadHistory = async () => {\n try {\n const res = await fetch(\"/api/water/history?days=7\");\n if (res.ok) {\n const data = await res.json();\n setHistory(data.history || []);\n }\n } catch (err) {\n console.error(\"Failed to load history:\", err);\n }\n };\n\n const handleQuickAdd = async (ml: number) => {\n try {\n const res = await fetch(\"/api/water/log\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ milliliters: ml, source: \"manual\" }),\n });\n\n if (res.ok) {\n showToast(`Added ${ml}ml of water!`, \"success\");\n await loadTodayData();\n await loadHistory();\n setCustomMl(\"\");\n }\n } catch (err) {\n showToast(\"Failed to log water\", \"error\");\n }\n };\n\n const handleCustomAdd = async () => {\n const ml = parseInt(customMl);\n if (!ml || ml < 1) {\n showToast(\"Please enter a valid amount\", \"error\");\n return;\n }\n await handleQuickAdd(ml);\n };\n\n const handleDeleteLog = async (id: number) => {\n try {\n const res = await fetch(`/api/water/${id}`, { method: \"DELETE\" });\n if (res.ok) {\n showToast(\"Log deleted\", \"success\");\n await loadTodayData();\n await loadHistory();\n }\n } catch (err) {\n showToast(\"Failed to delete log\", \"error\");\n }\n };\n\n const handleCreateNfc = async () => {\n const ml = parseInt(newNfcMl);\n if (!ml || ml < 1) {\n showToast(\"Enter a valid amount\", \"error\");\n return;\n }\n try {\n const res = await fetch(\"/api/nfc/device\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ name: newNfcName || undefined, milliliters: ml }),\n });\n if (res.ok) {\n const data = await res.json();\n setCreatedTapUrl(data.tapUrl);\n setNewNfcName(\"\");\n setNewNfcMl(\"500\");\n await loadNfcDevices();\n showToast(\"NFC device created! Copy the link below.\", \"success\");\n }\n } catch (err) {\n showToast(\"Failed to create NFC device\", \"error\");\n }\n };\n\n const handleUpdateDeviceMl = async (id: string) => {\n const ml = parseInt(editMl);\n if (!ml || ml < 1) {\n showToast(\"Enter a valid amount\", \"error\");\n return;\n }\n try {\n const res = await fetch(`/api/nfc/device/${id}`, {\n method: \"PATCH\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ milliliters: ml }),\n });\n if (res.ok) {\n setEditingDeviceId(null);\n await loadNfcDevices();\n showToast(\"Amount updated\", \"success\");\n }\n } catch (err) {\n showToast(\"Failed to update\", \"error\");\n }\n };\n\n const handleDeleteDevice = async (id: string) => {\n try {\n const res = await fetch(`/api/nfc/device/${id}`, { method: \"DELETE\" });\n if (res.ok) {\n showToast(\"Device deleted\", \"success\");\n await loadNfcDevices();\n }\n } catch (err) {\n showToast(\"Failed to delete device\", \"error\");\n }\n };\n\n const showToast = (message: string, type: \"success\" | \"error\") => {\n setToast({ message, type });\n setTimeout(() => setToast(null), 3000);\n };\n\n if (loading) {\n return (\n

\n );\n }\n\n if (!isAuthenticated) {\n return (\n

💧 Water Tracker

\n {signInStatus === \"sent\" ? (\n

📬 Check your email

\n We sent a sign-in link to {email}.\n

\n ) : (\n {\n e.preventDefault();\n setSignInStatus(\"sending\");\n const { error } = await authClient.signIn.magicLink({\n email,\n callbackURL: \"/\",\n });\n if (error) {\n setSignInStatus(\"error\");\n } else {\n setSignInStatus(\"sent\");\n }\n }}\n className=\"space-y-3\"\n >\n setEmail(e.target.value)}\n placeholder=\"you@example.com\"\n className=\"w-full px-4 py-3 border border-gray-300 rounded-lg focus:outline-none focus:ring-2 focus:ring-blue-500\"\n disabled={signInStatus === \"sending\"}\n />\n \n {signInStatus === \"sending\" ? \"Sending…\" : \"Send magic link\"}\n \n {signInStatus === \"error\" && (\n

Failed to send magic link. Try again.

\n )}\n \n )}\n

\n );\n }\n\n const percentage = todayData?.percentage || 0;\n const total = todayData?.totalToday || 0;\n const target = todayData?.target || WATER_CONFIG.DAILY_TARGET_ML;\n\n return (\n

\n {/* Header */}\n

💧 Water Tracker

\n authClient.signOut().then(() => location.reload())}\n className=\"text-sm text-gray-600 hover:text-gray-900\"\n >\n Sign out\n \n

\n\n {/* Toast */}\n {toast && (\n \n {toast.message}\n

\n )}\n\n

\n {/* Tabs */}\n

\n setActiveTab(\"today\")}\n className={`px-4 py-2 rounded-lg font-medium transition-colors ${\n activeTab === \"today\"\n ? \"bg-blue-500 text-white\"\n : \"bg-gray-200 text-gray-700 hover:bg-gray-300\"\n }`}\n >\n Today\n \n setActiveTab(\"history\")}\n className={`px-4 py-2 rounded-lg font-medium transition-colors ${\n activeTab === \"history\"\n ? \"bg-blue-500 text-white\"\n : \"bg-gray-200 text-gray-700 hover:bg-gray-300\"\n }`}\n >\n History\n \n setActiveTab(\"nfc\")}\n className={`px-4 py-2 rounded-lg font-medium transition-colors ${\n activeTab === \"nfc\"\n ? \"bg-blue-500 text-white\"\n : \"bg-gray-200 text-gray-700 hover:bg-gray-300\"\n }`}\n >\n NFC Devices\n \n

\n\n {/* Today Tab */}\n {activeTab === \"today\" && (\n

\n {/* Progress Card */}\n

{total}ml

of {target}ml daily goal

\n {percentage < 100 ? \"🥛\" : \"🎉\"}\n

\n\n {/* Progress Bar */}\n

\n {percentage}% complete\n

\n\n {/* Quick Add Buttons */}\n

\n {WATER_CONFIG.QUICK_ADD_AMOUNTS.map((ml) => (\n handleQuickAdd(ml)}\n className=\"bg-blue-500 hover:bg-blue-600 text-white py-3 rounded-lg font-medium transition-colors\"\n >\n +{ml}ml\n \n ))}\n

\n\n {/* Custom Amount */}\n

\n setCustomMl(e.target.value)}\n className=\"flex-1 px-4 py-2 border border-gray-300 rounded-lg focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n \n Add\n \n

💡 1g of water = 1ml — so 500g on the scale is 500ml

\n\n {/* Today's Logs */}\n

Today's Logs

\n {todayData?.logs && todayData.logs.length > 0 ? (\n

\n {todayData.logs.map((log) => (\n \n

\n {log.milliliters}ml\n

\n {new Date(log.timestamp).toLocaleTimeString()} · {log.source}\n

\n handleDeleteLog(log.id)}\n className=\"text-red-500 hover:text-red-700 text-sm font-medium ml-4\"\n >\n Delete\n \n

\n ))}\n

\n ) : (\n

No water logged yet today

\n )}\n

\n \n )}\n\n {/* History Tab */}\n {activeTab === \"history\" && (\n

Last 7 Days

\n {history.length > 0 ? (() => {\n const maxTotal = Math.max(...history.map((d) => d.total), WATER_CONFIG.DAILY_TARGET_ML);\n const chartData = [...history].reverse();\n return (\n

\n {chartData.map((entry, i) => {\n const barHeight = maxTotal > 0 ? (entry.total / maxTotal) * 100 : 0;\n const metGoal = entry.percentage >= 100;\n const dayLabel = new Date(entry.date + \"T00:00:00\").toLocaleDateString(undefined, { weekday: \"short\", day: \"numeric\" });\n return (\n

{entry.total}ml

{dayLabel}

\n );\n })}\n

\n );\n })() : (\n

No history yet

\n )}\n {history.length > 0 && (\n

\n \n \n Below goal\n \n \n \n Goal met\n \n

\n )}\n \n )}\n\n {/* NFC Devices Tab */}\n {activeTab === \"nfc\" && (\n

\n {/* Add New NFC Device */}\n

Add NFC Device

\n Create a tap link to write to your NFC tag. Tapping the tag will log water automatically — no sign-in needed.\n

\n setNewNfcName(e.target.value)}\n placeholder=\"Device name (e.g. Water Bottle)\"\n className=\"w-full px-4 py-2 border border-gray-300 rounded-lg focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n

\n setNewNfcMl(e.target.value)}\n placeholder=\"ml per tap\"\n className=\"flex-1 px-4 py-2 border border-gray-300 rounded-lg focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n \n Create\n \n

\n {createdTapUrl && (\n

📋 Copy this link to your NFC tag:

\n \n {\n navigator.clipboard.writeText(createdTapUrl);\n showToast(\"Link copied!\", \"success\");\n }}\n className=\"bg-blue-500 hover:bg-blue-600 text-white px-4 py-2 rounded-lg text-sm font-medium whitespace-nowrap\"\n >\n Copy\n \n

\n setCreatedTapUrl(null)}\n className=\"mt-2 text-xs text-gray-500 underline\"\n >\n Dismiss\n \n

\n )}\n

\n\n {/* Device List */}\n

Your Devices

\n {nfcDevices.length > 0 ? (\n

\n {nfcDevices.map((device) => {\n const tapUrl = `${location.origin}/api/nfc/tap/${device.token}`;\n return (\n

{device.name}

{device.milliliters}ml per tap

\n {/* Copy tap link */}\n

\n \n {\n navigator.clipboard.writeText(tapUrl);\n showToast(\"Link copied!\", \"success\");\n }}\n className=\"bg-gray-200 hover:bg-gray-300 text-gray-700 px-3 py-1.5 rounded text-xs font-medium whitespace-nowrap\"\n >\n Copy\n \n

\n {/* Edit amount */}\n {editingDeviceId === device.id ? (\n

\n setEditMl(e.target.value)}\n placeholder=\"ml\"\n className=\"w-24 px-3 py-1.5 text-sm border border-gray-300 rounded-lg\"\n />\n handleUpdateDeviceMl(device.id)}\n className=\"bg-emerald-500 hover:bg-emerald-600 text-white px-3 py-1.5 rounded-lg text-sm font-medium\"\n >\n Save\n \n setEditingDeviceId(null)}\n className=\"text-gray-500 text-sm px-2\"\n >\n Cancel\n \n

\n ) : (\n

\n {\n setEditingDeviceId(device.id);\n setEditMl(String(device.milliliters));\n }}\n className=\"text-blue-500 hover:text-blue-700 text-sm font-medium\"\n >\n Edit amount\n \n handleDeleteDevice(device.id)}\n className=\"text-red-500 hover:text-red-700 text-sm font-medium\"\n >\n Delete\n \n

\n )}\n

\n );\n })}\n

\n ) : (\n

No NFC devices yet. Create one above!

\n )}\n

\n )}\n \n \n );\n}\n\nconst root = createRoot(document.getElementById(\"root\")!);\nroot.render();\n",[],[188,268],"6a8ead63-2143-44b4-a8f2-ad0deb9c066a","index.html","019f7461-6ee4-74b9-881f-cead947034b9",11,["D",1784364783086],4,"\n\n \n \n \n Water Intake Tracker\n \n \n \n \n \n

\n \n \n \n\n",[],[188,276],"77dc03e8-0545-4969-9c06-da01b16e33c5","favicon.svg","019f7461-6ee4-74b9-881f-cb6ca68ec92e",["D",1784363970193],"\n",[],[188,285],["D",1784363970193],[],[188,94,75],["D",1784363970193],[],[188,94,87],["D",1784363970193],[],[188,94,92],["D",1784363970193],[224,225,226],[188,94],"c23acb1e-6c97-496e-a850-6865b3317d86",["D",1784363970193],[223,227,228,229,230],[188],"87984f4a-7924-4ece-b136-58389137b02d","constants.ts","8d4135a2-8284-11f1-974b-1607ee4eb77e","1b54eaa7-101b-4278-9f64-0c227dfbb344",["D",1784364124194],"// Water intake tracking configuration\nexport const WATER_CONFIG = {\n // Daily target in milliliters (2 liters)\n DAILY_TARGET_ML: 2000,\n \n // Time in hours when daily intake resets (5 AM UTC)\n RESET_HOUR_UTC: 5,\n \n // Common water intake amounts (in ml) for quick add buttons\n QUICK_ADD_AMOUNTS: [250, 500, 750, 1000],\n \n // Minimum and maximum ml per NFC tap\n MIN_ML_PER_TAP: 100,\n MAX_ML_PER_TAP: 1000,\n \n // Default amount per NFC tap\n DEFAULT_ML_PER_TAP: 500,\n} as const;\n\n// UI Configuration\nexport const UI_CONFIG = {\n // Colors for progress visualization\n PROGRESS_COLORS: {\n EMPTY: \"#e5e7eb\", // gray-200\n PARTIAL: \"#3b82f6\", // blue-500\n FULL: \"#10b981\", // emerald-500\n OVER: \"#8b5cf6\", // violet-500\n },\n \n // Toast/notification durations (in ms)\n TOAST_DURATION: 3000,\n} as const;\n\n// Database table names\nexport const DB_TABLES = {\n USER: \"user\",\n SESSION: \"session\",\n ACCOUNT: \"account\",\n VERIFICATION: \"verification\",\n WATER_LOGS: \"water_logs\",\n NFC_TOKENS: \"nfc_tokens\",\n NFC_DEVICES: \"nfc_devices\",\n} as const;\n",[],[315,308],"config","923e0a26-76cd-4e0c-942a-5ed9cb2fc009",["D",1784364124194],[221],[315],"1e7f8849-6668-44c0-8578-60014cfbac62","water-utils.ts","95283716-8284-11f1-887b-1607ee4eb77e","019f7461-6ee4-74b9-881f-b70bb89663dc",["D",1784364137484],"import { WATER_CONFIG } from \"../config/constants.ts\";\n\n/**\n * Get today's start time based on the reset hour (5 AM UTC)\n */\nexport function getTodayStartTime(): number {\n const now = new Date();\n const todayStart = new Date(now);\n todayStart.setUTCHours(WATER_CONFIG.RESET_HOUR_UTC, 0, 0, 0);\n\n // If we haven't reached 5 AM yet today, yesterday's 5 AM is the start\n if (todayStart.getTime() > now.getTime()) {\n todayStart.setUTCDate(todayStart.getUTCDate() - 1);\n }\n\n return todayStart.getTime();\n}\n\n/**\n * Get the end of today (tomorrow's reset time)\n */\nexport function getTodayEndTime(): number {\n return getTodayStartTime() + 24 * 60 * 60 * 1000;\n}\n\n/**\n * Check if a timestamp is in today's cycle\n */\nexport function isToday(timestamp: number): boolean {\n const start = getTodayStartTime();\n const end = getTodayEndTime();\n return timestamp >= start && timestamp < end;\n}\n\n/**\n * Format milliliters nicely (e.g., 500ml, 1.5L)\n */\nexport function formatWater(milliliters: number): string {\n if (milliliters >= 1000) {\n return `${(milliliters / 1000).toFixed(1)}L`;\n }\n return `${milliliters}ml`;\n}\n\n/**\n * Get color for progress bar based on percentage\n */\nexport function getProgressColor(percentage: number): string {\n if (percentage <= 0) return \"#e5e7eb\"; // empty - gray\n if (percentage < 100) return \"#3b82f6\"; // partial - blue\n if (percentage === 100) return \"#10b981\"; // full - emerald\n return \"#8b5cf6\"; // over - violet\n}\n\n/**\n * Calculate percentage of daily target\n */\nexport function getProgressPercentage(current: number): number {\n return Math.round((current / WATER_CONFIG.DAILY_TARGET_ML) * 100);\n}\n",[],[328,321],"backend","0bfc9a92-b5c7-41c8-8938-f5a2c3bfe4d7","schema.ts","019f7461-6ee4-74b9-881f-b2f15ed8bf7f",["D",1784364130522],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { DB_TABLES } from \"../config/constants.ts\";\n\n// Better Auth's standard SQLite schema for core auth + magic link.\n// Magic link uses the `verification` table — no extra plugin tables needed.\n//\n// We run this on startup so the template works with zero setup.\n// Better Auth manages all reads/writes via Kysely; we just ensure the tables exist.\nexport async function ensureSchema() {\n await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS user (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n email TEXT NOT NULL UNIQUE,\n emailVerified INTEGER NOT NULL DEFAULT 0,\n image TEXT,\n createdAt INTEGER NOT NULL,\n updatedAt INTEGER NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS session (\n id TEXT PRIMARY KEY,\n userId TEXT NOT NULL REFERENCES user(id) ON DELETE CASCADE,\n token TEXT NOT NULL UNIQUE,\n expiresAt INTEGER NOT NULL,\n ipAddress TEXT,\n userAgent TEXT,\n createdAt INTEGER NOT NULL,\n updatedAt INTEGER NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS account (\n id TEXT PRIMARY KEY,\n userId TEXT NOT NULL REFERENCES user(id) ON DELETE CASCADE,\n accountId TEXT NOT NULL,\n providerId TEXT NOT NULL,\n accessToken TEXT,\n refreshToken TEXT,\n accessTokenExpiresAt INTEGER,\n refreshTokenExpiresAt INTEGER,\n scope TEXT,\n idToken TEXT,\n password TEXT,\n createdAt INTEGER NOT NULL,\n updatedAt INTEGER NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS verification (\n id TEXT PRIMARY KEY,\n identifier TEXT NOT NULL,\n value TEXT NOT NULL,\n expiresAt INTEGER NOT NULL,\n createdAt INTEGER NOT NULL,\n updatedAt INTEGER NOT NULL\n )`,\n // Water intake logs\n `CREATE TABLE IF NOT EXISTS ${DB_TABLES.WATER_LOGS} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n userId TEXT NOT NULL REFERENCES user(id) ON DELETE CASCADE,\n timestamp INTEGER NOT NULL,\n milliliters INTEGER NOT NULL,\n source TEXT NOT NULL DEFAULT 'manual',\n createdAt INTEGER NOT NULL\n )`,\n // NFC device registration (stores ml amount per device)\n `CREATE TABLE IF NOT EXISTS ${DB_TABLES.NFC_DEVICES} (\n id TEXT PRIMARY KEY,\n userId TEXT NOT NULL REFERENCES user(id) ON DELETE CASCADE,\n token TEXT NOT NULL UNIQUE,\n milliliters INTEGER NOT NULL DEFAULT 500,\n name TEXT,\n createdAt INTEGER NOT NULL,\n updatedAt INTEGER NOT NULL\n )`,\n // NFC tokens for one-time tap registration\n `CREATE TABLE IF NOT EXISTS ${DB_TABLES.NFC_TOKENS} (\n token TEXT PRIMARY KEY,\n userId TEXT NOT NULL REFERENCES user(id) ON DELETE CASCADE,\n createdAt INTEGER NOT NULL\n )`,\n ]);\n}\n",[],[328,330],"ec576171-e7a6-4217-888d-80eca159d8cb","schema-drizzle.ts","019f7461-6ee4-74b9-881f-acfcb46b90fd",["D",1784363970193],"import { integer, sqliteTable, text } from \"npm:drizzle-orm@0.45.2/sqlite-core\";\n\nexport const user = sqliteTable(\"user\", {\n id: text(\"id\").primaryKey(),\n name: text(\"name\").notNull(),\n email: text(\"email\").notNull().unique(),\n // Explicitly mapping the camelCase columns from your SQL\n emailVerified: integer(\"emailVerified\").notNull(),\n image: text(\"image\"),\n createdAt: integer(\"createdAt\").notNull(),\n updatedAt: integer(\"updatedAt\").notNull(),\n});\n\nexport const session = sqliteTable(\"session\", {\n id: text(\"id\").primaryKey(),\n userId: text(\"userId\").notNull().references(() => user.id, {\n onDelete: \"cascade\",\n }),\n token: text(\"token\").notNull().unique(),\n // Explicitly matching your SQL column name here!\n expiresAt: integer(\"expiresAt\").notNull(),\n ipAddress: text(\"ipAddress\"),\n userAgent: text(\"userAgent\"),\n createdAt: integer(\"createdAt\").notNull(),\n updatedAt: integer(\"updatedAt\").notNull(),\n});\n\nexport const account = sqliteTable(\"account\", {\n id: text(\"id\").primaryKey(),\n userId: text(\"userId\").notNull().references(() => user.id, {\n onDelete: \"cascade\",\n }),\n accountId: text(\"accountId\").notNull(),\n providerId: text(\"providerId\").notNull(),\n accessToken: text(\"accessToken\"),\n refreshToken: text(\"refreshToken\"),\n accessTokenExpiresAt: integer(\"accessTokenExpiresAt\"),\n refreshTokenExpiresAt: integer(\"refreshTokenExpiresAt\"),\n scope: text(\"scope\"),\n idToken: text(\"idToken\"),\n password: text(\"password\"),\n createdAt: integer(\"createdAt\").notNull(),\n updatedAt: integer(\"updatedAt\").notNull(),\n});\nexport const verification = sqliteTable(\"verification\", {\n id: text(\"id\").primaryKey(),\n identifier: text(\"identifier\").notNull(),\n value: text(\"value\").notNull(),\n expiresAt: integer(\"expiresAt\").notNull(),\n createdAt: integer(\"createdAt\").notNull(),\n updatedAt: integer(\"updatedAt\").notNull(),\n});\n",[],[328,337],"20e1fdd7-f528-481a-b80e-b651e4254523","drizzle.ts","019f7461-6ee4-74b9-881f-a9fc4aca20f6",["D",1784363970193],"import { drizzle } from \"npm:drizzle-orm@0.45.2/libsql/web\";\nimport { createClient } from \"npm:@libsql/client@0.17.4/web\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// Export your clean, edge-safe database instance\nexport const db = drizzle({ client: sqlite });",[],[328,344],"711ebc6a-6d9b-4591-af6b-08aca8d4660c","auth.ts","019f7461-6ee3-75ce-ac8f-6422488024bb",["D",1784363970193],"import { email as sendEmail } from \"https://esm.town/v/std/email\";\nimport { httpEndpoint, parseVal } from \"https://esm.town/v/std/utils/index.ts\";\nimport { betterAuth } from \"npm:better-auth@1.6.20\";\nimport { magicLink } from \"npm:better-auth@1.6.20/plugins\";\nimport { drizzleAdapter } from \"npm:@better-auth/drizzle-adapter@1.6.20\";\nimport { db } from \"./drizzle.ts\";\nimport * as authSchema from \"./schema-drizzle.ts\"; // Import the tables above\n\n// Vals can be reached from multiple URLs (the *.web.val.run preview URL,\n// custom domains, branch deploys, etc). Better Auth's dynamic baseURL form\n// derives the URL from each incoming request and validates it against\n// allowedHosts. The fallback is used when running outside an HTTP context\n// (e.g. cron jobs, scripts).\nconst fallback = await httpEndpoint();\n\n// A secret is required to sign session tokens. We default to a per-val auto\n// secret so the template works with zero setup — but for production you should\n// set BETTER_AUTH_SECRET so sessions survive code edits across val versions.\nconst { username, name } = parseVal();\nconst secret = Deno.env.get(\"BETTER_AUTH_SECRET\") ??\n `val-town-default-${username}-${name}`;\n\nconst validEmail = Deno.env.get(\"EMAIL\");\n\n// Val Town's `std/sqlite` is already an `@libsql/client` Client,\n// so we can hand it straight to Better Auth's Kysely libsql dialect.\n// Zero database setup required.\nexport const auth = betterAuth({\n baseURL: {\n // Accept any host so this works on the *.web.val.run preview URL,\n // custom domains, and any future deployment URL. For production you\n // should narrow this to the specific hosts you serve from, e.g.\n // [\"myapp.com\", \"*.web.val.run\"].\n allowedHosts: [\"*.web.val.run\"],\n protocol: \"auto\",\n fallback,\n },\n secret,\n database: drizzleAdapter(db, {\n provider: \"sqlite\",\n schema: authSchema,\n }),\n // Disable email+password — this template is magic link only.\n emailAndPassword: { enabled: false },\n plugins: [\n magicLink({\n sendMagicLink: async ({ email, url }) => {\n await sendEmail({\n subject: \"Your sign-in link\",\n text: `Click to sign in: ${url}\\n\\nThis link expires in 5 minutes.`,\n html: `

Click to sign in:

` +\n `

${url}

` +\n `

This link expires in 5 minutes.

`,\n });\n },\n }),\n ],\n});",[],[328,351],"7a1a713a-cb84-4008-936d-3760d8860d1c",["D",1784363970193],[215,216,217,218,219],[328],["D",1784363970193],["D",1789525843977],{"_11":12,"_149":81},{"_11":12,"_145":-5,"_80":81,"_31":79,"_146":147,"_148":30},{"_39":134,"_13":16,"_33":36,"_135":97,"_136":70,"_137":138,"_139":101,"_140":141,"_142":42,"_143":14,"_144":12},"ctx",{"_52":-5,"_170":399,"_400":401,"_402":403,"_404":30,"_405":30,"_406":30,"_407":24,"_408":-5,"_409":-7,"_410":-7,"_411":26,"_412":30,"_413":30,"_414":-5,"_415":30,"_416":30,"_417":30,"_418":-5},"ENV",{"_370":371,"_372":373,"_374":16,"_375":376,"_377":378,"_379":380,"_381":382,"_383":384,"_385":386,"_387":388,"_389":390,"_391":392,"_393":394,"_395":396,"_397":398},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

History · components