[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_539":540,"_541":542},"routes/_app.x.$handle.$name",{"_100":99,"_32":46,"_108":90,"_27":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_20":-5,"_120":-5,"_121":-5,"_122":25,"_123":124,"_125":59,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",283,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","backend/routes/api.ts","latestPath","fileId","31e96b7a-f5bc-11f0-b018-42dde27851f2","name","api.ts","fileType","script","content","// Dashboard API endpoints\nimport { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport {\n getAlertHistory,\n getLatestNanoTagReading,\n getLatestNanoTagBatteryVoltage,\n getRecentNanoTagReadings,\n} from \"../database/queries.ts\";\nimport {\n calculateIncubationStatus,\n getAlertThresholds,\n getCurrentDailyTip,\n getCurrentMode,\n activateBrooderMode,\n getHatchDate,\n} from \"../services/incubation.ts\";\nimport {\n calculateBrooderStatus,\n getBrooderAlertThresholds,\n evaluateOutdoorReadiness,\n getChickAgeDays,\n} from \"../services/brooder.ts\";\nimport { fetchWeatherForecast } from \"../services/weather.ts\";\nimport { getDailyTip } from \"../../shared/dailyTips.ts\";\nimport { CALIBRATION } from \"../../shared/constants.ts\";\nimport type { NanoTagReading } from \"../../shared/types.ts\";\n\nexport const apiRouter = new Hono();\n\n// Build the dashboard \"current reading\" from the latest NanoTag reading.\n// temperatureF is raw; the frontend applies the NanoTag calibration offset for display.\nfunction toCurrentReading(nano: NanoTagReading | null) {\n if (!nano) return null;\n return {\n timestamp: nano.timestamp,\n temperatureC: nano.temperatureC,\n temperatureF: nano.temperatureF,\n batteryVoltage: nano.batteryVoltage,\n rssi: nano.rssi ?? null,\n humidity: null, // NanoTag has no humidity sensor\n };\n}\n\n// Get current status (main dashboard endpoint)\napiRouter.get(\"/status\", async (c) => {\n const nano = await getLatestNanoTagReading();\n const currentReading = toCurrentReading(nano);\n const mode = await getCurrentMode();\n\n // Calibrated NanoTag temperature for alert evaluation\n const calibratedTempF = nano ? nano.temperatureF + CALIBRATION.nanotagTemperatureF : 0;\n\n // Return mode-specific response\n if (mode === \"brooder\") {\n const hatchDate = await getHatchDate();\n if (!hatchDate) {\n return c.json({ error: \"Brooder mode active but no hatch date set\" }, 500);\n }\n\n const brooderStatus = calculateBrooderStatus(hatchDate);\n const alerts = nano\n ? getBrooderAlertThresholds(calibratedTempF, null, brooderStatus.chickAgeDays)\n : null;\n\n // Fetch weather for outdoor readiness\n const forecast = await fetchWeatherForecast();\n const outdoorReadiness = evaluateOutdoorReadiness(brooderStatus.chickAgeDays, forecast);\n\n return c.json({\n mode: \"brooder\",\n currentReading,\n brooderStatus,\n alerts,\n outdoorReadiness,\n });\n }\n\n // Default: incubation mode\n const incubationStatus = calculateIncubationStatus();\n const dailyTip = getCurrentDailyTip();\n const alerts = nano\n ? getAlertThresholds(calibratedTempF, null, incubationStatus.currentDay)\n : null;\n\n return c.json({\n mode: \"incubation\",\n currentReading,\n incubationStatus,\n alerts,\n dailyTip,\n });\n});\n\n// Get NanoTag readings for time range (for charts)\napiRouter.get(\"/readings/nanotag\", async (c) => {\n const minutesParam = c.req.query(\"minutes\");\n const minutes = minutesParam ? parseInt(minutesParam, 10) : 1440; // Default 24 hours\n\n if (isNaN(minutes) || minutes < 1) {\n return c.json({ error: \"Invalid minutes parameter\" }, 400);\n }\n\n const readings = await getRecentNanoTagReadings(Math.min(minutes, 10080)); // Max 1 week\n return c.json(readings);\n});\n\n// Get alert history\napiRouter.get(\"/alerts\", async (c) => {\n const limitParam = c.req.query(\"limit\");\n const limit = limitParam ? parseInt(limitParam, 10) : 50;\n\n if (isNaN(limit) || limit < 1) {\n return c.json({ error: \"Invalid limit parameter\" }, 400);\n }\n\n const alerts = await getAlertHistory(Math.min(limit, 200));\n return c.json(alerts);\n});\n\n// Get incubation configuration and status\napiRouter.get(\"/config\", (c) => {\n const status = calculateIncubationStatus();\n const dailyTip = getCurrentDailyTip();\n\n return c.json({\n ...status,\n dailyTip,\n });\n});\n\n// Get daily tip for a specific day (for testing/preview)\napiRouter.get(\"/tip/:day\", (c) => {\n const dayParam = c.req.param(\"day\");\n const day = parseInt(dayParam, 10);\n\n if (isNaN(day) || day < 0) {\n return c.json({ error: \"Invalid day parameter\" }, 400);\n }\n\n return c.json(getDailyTip(day));\n});\n\n// --- Brooder Mode Endpoints ---\n\n// Activate brooder mode\napiRouter.post(\"/brooder/activate\", async (c) => {\n try {\n const body = await c.req.json().catch(() => ({}));\n const hatchDate = body.hatchDate ? new Date(body.hatchDate) : undefined;\n\n // Validate hatch date if provided\n if (hatchDate && isNaN(hatchDate.getTime())) {\n return c.json({ error: \"Invalid hatchDate format. Use ISO 8601.\" }, 400);\n }\n\n await activateBrooderMode(hatchDate);\n\n const actualHatchDate = await getHatchDate();\n const brooderStatus = actualHatchDate\n ? calculateBrooderStatus(actualHatchDate)\n : null;\n\n return c.json({\n success: true,\n message: \"Brooder mode activated\",\n brooderStatus,\n });\n } catch (error) {\n console.error(\"Error activating brooder mode:\", error);\n return c.json({ error: \"Failed to activate brooder mode\" }, 500);\n }\n});\n\n// Get brooder status (if in brooder mode)\napiRouter.get(\"/brooder/status\", async (c) => {\n const mode = await getCurrentMode();\n\n if (mode !== \"brooder\") {\n return c.json({ error: \"Not in brooder mode\", currentMode: mode }, 400);\n }\n\n const hatchDate = await getHatchDate();\n if (!hatchDate) {\n return c.json({ error: \"Brooder mode active but no hatch date set\" }, 500);\n }\n\n const brooderStatus = calculateBrooderStatus(hatchDate);\n const forecast = await fetchWeatherForecast();\n const outdoorReadiness = evaluateOutdoorReadiness(brooderStatus.chickAgeDays, forecast);\n\n return c.json({\n brooderStatus,\n outdoorReadiness,\n });\n});\n\n// Get weather forecast\napiRouter.get(\"/weather\", async (c) => {\n const forecast = await fetchWeatherForecast();\n return c.json(forecast);\n});\n","// Dashboard API endpoints\nimport { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport {\n getAlertHistory,\n getLatestNanoTagReading,\n getLatestNanoTagBatteryVoltage,\n getRecentNanoTagReadings,\n} from \"../database/queries.ts\";\nimport {\n calculateIncubationStatus,\n getAlertThresholds,\n getCurrentDailyTip,\n getCurrentMode,\n activateBrooderMode,\n getHatchDate,\n} from \"../services/incubation.ts\";\nimport {\n calculateBrooderStatus,\n getBrooderAlertThresholds,\n evaluateOutdoorReadiness,\n getChickAgeDays,\n} from \"../services/brooder.ts\";\nimport { fetchWeatherForecast } from \"../services/weather.ts\";\nimport { getDailyTip } from \"../../shared/dailyTips.ts\";\nimport { CALIBRATION } from \"../../shared/constants.ts\";\nimport type { NanoTagReading } from \"../../shared/types.ts\";\n\nexport const apiRouter = new Hono();\n\n// Build the dashboard \"current reading\" from the latest NanoTag reading.\n// temperatureF is raw; the frontend applies the NanoTag calibration offset for display.\nfunction toCurrentReading(nano: NanoTagReading | null, batteryVoltage: number | null) {\n if (!nano) return null;\n return {\n timestamp: nano.timestamp,\n temperatureC: nano.temperatureC,\n temperatureF: nano.temperatureF,\n batteryVoltage, // last known battery voltage (from a battery-status packet)\n rssi: nano.rssi ?? null,\n humidity: null, // NanoTag has no humidity sensor\n };\n}\n\n// Get current status (main dashboard endpoint)\napiRouter.get(\"/status\", async (c) => {\n const nano = await getLatestNanoTagReading();\n const batteryVoltage = await getLatestNanoTagBatteryVoltage();\n const currentReading = toCurrentReading(nano, batteryVoltage);\n const mode = await getCurrentMode();\n\n // Calibrated NanoTag temperature for alert evaluation\n const calibratedTempF = nano ? nano.temperatureF + CALIBRATION.nanotagTemperatureF : 0;\n\n // Return mode-specific response\n if (mode === \"brooder\") {\n const hatchDate = await getHatchDate();\n if (!hatchDate) {\n return c.json({ error: \"Brooder mode active but no hatch date set\" }, 500);\n }\n\n const brooderStatus = calculateBrooderStatus(hatchDate);\n const alerts = nano\n ? getBrooderAlertThresholds(calibratedTempF, null, brooderStatus.chickAgeDays)\n : null;\n\n // Fetch weather for outdoor readiness\n const forecast = await fetchWeatherForecast();\n const outdoorReadiness = evaluateOutdoorReadiness(brooderStatus.chickAgeDays, forecast);\n\n return c.json({\n mode: \"brooder\",\n currentReading,\n brooderStatus,\n alerts,\n outdoorReadiness,\n });\n }\n\n // Default: incubation mode\n const incubationStatus = calculateIncubationStatus();\n const dailyTip = getCurrentDailyTip();\n const alerts = nano\n ? getAlertThresholds(calibratedTempF, null, incubationStatus.currentDay)\n : null;\n\n return c.json({\n mode: \"incubation\",\n currentReading,\n incubationStatus,\n alerts,\n dailyTip,\n });\n});\n\n// Get NanoTag readings for time range (for charts)\napiRouter.get(\"/readings/nanotag\", async (c) => {\n const minutesParam = c.req.query(\"minutes\");\n const minutes = minutesParam ? parseInt(minutesParam, 10) : 1440; // Default 24 hours\n\n if (isNaN(minutes) || minutes < 1) {\n return c.json({ error: \"Invalid minutes parameter\" }, 400);\n }\n\n const readings = await getRecentNanoTagReadings(Math.min(minutes, 10080)); // Max 1 week\n return c.json(readings);\n});\n\n// Get alert history\napiRouter.get(\"/alerts\", async (c) => {\n const limitParam = c.req.query(\"limit\");\n const limit = limitParam ? parseInt(limitParam, 10) : 50;\n\n if (isNaN(limit) || limit < 1) {\n return c.json({ error: \"Invalid limit parameter\" }, 400);\n }\n\n const alerts = await getAlertHistory(Math.min(limit, 200));\n return c.json(alerts);\n});\n\n// Get incubation configuration and status\napiRouter.get(\"/config\", (c) => {\n const status = calculateIncubationStatus();\n const dailyTip = getCurrentDailyTip();\n\n return c.json({\n ...status,\n dailyTip,\n });\n});\n\n// Get daily tip for a specific day (for testing/preview)\napiRouter.get(\"/tip/:day\", (c) => {\n const dayParam = c.req.param(\"day\");\n const day = parseInt(dayParam, 10);\n\n if (isNaN(day) || day < 0) {\n return c.json({ error: \"Invalid day parameter\" }, 400);\n }\n\n return c.json(getDailyTip(day));\n});\n\n// --- Brooder Mode Endpoints ---\n\n// Activate brooder mode\napiRouter.post(\"/brooder/activate\", async (c) => {\n try {\n const body = await c.req.json().catch(() => ({}));\n const hatchDate = body.hatchDate ? new Date(body.hatchDate) : undefined;\n\n // Validate hatch date if provided\n if (hatchDate && isNaN(hatchDate.getTime())) {\n return c.json({ error: \"Invalid hatchDate format. Use ISO 8601.\" }, 400);\n }\n\n await activateBrooderMode(hatchDate);\n\n const actualHatchDate = await getHatchDate();\n const brooderStatus = actualHatchDate\n ? calculateBrooderStatus(actualHatchDate)\n : null;\n\n return c.json({\n success: true,\n message: \"Brooder mode activated\",\n brooderStatus,\n });\n } catch (error) {\n console.error(\"Error activating brooder mode:\", error);\n return c.json({ error: \"Failed to activate brooder mode\" }, 500);\n }\n});\n\n// Get brooder status (if in brooder mode)\napiRouter.get(\"/brooder/status\", async (c) => {\n const mode = await getCurrentMode();\n\n if (mode !== \"brooder\") {\n return c.json({ error: \"Not in brooder mode\", currentMode: mode }, 400);\n }\n\n const hatchDate = await getHatchDate();\n if (!hatchDate) {\n return c.json({ error: \"Brooder mode active but no hatch date set\" }, 500);\n }\n\n const brooderStatus = calculateBrooderStatus(hatchDate);\n const forecast = await fetchWeatherForecast();\n const outdoorReadiness = evaluateOutdoorReadiness(brooderStatus.chickAgeDays, forecast);\n\n return c.json({\n brooderStatus,\n outdoorReadiness,\n });\n});\n\n// Get weather forecast\napiRouter.get(\"/weather\", async (c) => {\n const forecast = await fetchWeatherForecast();\n return c.json(forecast);\n});\n","createdAt",["D",1783460632730],"branchVersion","branchId","5306ba64-f5b8-11f0-aa92-42dde27851f2","id","53067216-f5b8-11f0-aa92-42dde27851f2","IncubatorTempHumidityTracker",["D",1768883246417],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","d251f9a0-ef29-11ef-b0ef-a9e402d41f57","pinnedFileId","32167624-f5bc-11f0-9470-42dde27851f2","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","7dc0a550-a6a9-426f-8cc0-c1e24f3e9522","tursoName","53067216f5b811f0aa9242dde27851f2","tursoHostname","53067216f5b811f0aa9242dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789527031073],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_107":103},"org",{"_100":99,"_101":-5,"_102":103,"_18":55,"_104":105,"_106":25},"branch",{"_13":89,"_32":90,"_44":43,"_91":45,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":46,"_98":99},"isOwned",287,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","jhiller","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ydEhoSjBDdW5lY3JwdWh5SVdiN0Z6dFRLcXIifQ","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_32":46,"_39":534,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":535,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":536,"_84":537,"_86":538,"_88":25},"tree",[205,207,221,238,242,243,244,245],"files",[205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245],"counts",{"_194":63,"_195":196,"_197":63,"_198":199,"_200":201},"contents",[130,131,132,133,134,135,136,137],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":189,"_32":190,"_30":191,"_141":-5,"_42":43,"_41":153,"_143":59,"_39":192,"_13":63,"_34":175,"_36":-5,"_24":25,"_146":-5,"_27":193},{"_44":183,"_32":184,"_30":185,"_141":-5,"_42":43,"_41":186,"_143":59,"_39":187,"_13":63,"_34":175,"_36":-5,"_24":25,"_146":-5,"_27":188},{"_44":177,"_32":178,"_30":179,"_141":-5,"_42":43,"_41":180,"_143":59,"_39":181,"_13":63,"_34":175,"_36":-5,"_24":25,"_146":-5,"_27":182},{"_44":170,"_32":171,"_30":172,"_141":-5,"_42":43,"_41":173,"_143":59,"_39":174,"_13":63,"_34":175,"_36":-5,"_24":25,"_146":-5,"_27":176},{"_44":163,"_32":164,"_30":165,"_141":-5,"_42":43,"_41":166,"_143":59,"_39":167,"_13":63,"_34":20,"_36":168,"_24":25,"_146":-5,"_27":169},{"_44":156,"_32":157,"_30":158,"_141":-5,"_42":43,"_41":159,"_143":59,"_39":160,"_13":63,"_34":20,"_36":161,"_24":25,"_146":-5,"_27":162},{"_44":148,"_32":149,"_30":150,"_141":-5,"_42":43,"_41":151,"_143":59,"_39":152,"_13":153,"_34":20,"_36":154,"_24":25,"_146":-5,"_27":155},{"_44":138,"_32":139,"_30":140,"_141":-5,"_42":43,"_41":142,"_143":59,"_39":144,"_13":63,"_34":20,"_36":145,"_24":25,"_146":-5,"_27":147},"31cfa0dc-f5bc-11f0-920d-42dde27851f2","deno.json","31cfa1ae-f5bc-11f0-920d-42dde27851f2","parentId",19,"latest",["D",1768884908674],"{\n \"$schema\": \"https://raw.githubusercontent.com/denoland/deno/98f62cee78e85bfc47c62ed703777c6bc8794f1c/cli/schemas/config-file.v1.json\",\n \"lock\": false,\n \"compilerOptions\": {\n \"noImplicitAny\": false,\n \"strict\": true,\n \"types\": [\"https://www.val.town/types/valtown.d.ts\"],\n \"lib\": [\n \"dom\",\n \"dom.iterable\",\n \"dom.asynciterable\",\n \"deno.ns\",\n \"deno.unstable\"\n ]\n },\n \"lint\": {\n \"include\": [\"deno:/https/esm.town/**/*\"],\n \"rules\": {\n \"exclude\": [\"no-explicit-any\"]\n }\n },\n \"node_modules_dir\": false,\n \"experimental\": {\n \"unstable-node-globals\": true,\n \"unstable-temporal\": true,\n \"unstable-worker-options\": true,\n \"unstable-sloppy-imports\": true\n }\n}","label",[139],"b5fa3335-06c6-4540-b4f6-592ed25e8ca8","CLAUDE.md","81f6de80-f752-11f0-8d59-42dde27851f2",275,["D",1783402413414],3,"# CLAUDE.md\n\nThis file provides guidance to Claude Code (claude.ai/code) when working with code in this repository.\n\n## Project Overview\n\nQuail egg incubator monitoring system built on Val Town. Receives temperature data from a single LoRaWAN sensor — a NanoThings NanoTag — via ChirpStack webhooks, stores readings in SQLite, sends temperature email alerts, and displays a React dashboard.\n\n**Live URL:** https://quail-incubator.val.run/\n\n> **Sensor history:** The system originally ran a RAK7204 (temp + humidity, Cayenne LPP) alongside the NanoTag. As of July 2026 the RAK7204 was retired and the NanoTag (temperature-only) is the sole sensor. There is no humidity sensor anymore — humidity monitoring and humidity alerts were removed.\n\n## Development Commands\n\n```bash\n# Start local development with auto-sync to Val Town\n~/.deno/bin/vt watch\n\n# The app auto-deploys on save - no build step required\n```\n\n## Architecture\n\n### Platform: Val Town\n- Runs on Deno in a serverless context (not Node.js)\n- Entry point: `backend/index.http.tsx` exports `app.fetch`\n- Database: **per-val (project-scoped) SQLite** via `https://esm.town/v/std/sqlite/main.ts`\n- Email: Val Town's email service via `https://esm.town/v/std/email`\n- File serving: `https://esm.town/v/std/utils` for `readFile` and `serveFile`\n\n### Data Flow\n1. ChirpStack sends LoRaWAN uplinks to `/webhook/chirpstack?event=up`\n2. Webhook processes only the configured NanoTag DevEUI (`shared/constants.ts` → `DEVICE_EUIS.NANOTAG`); any other device is logged and ignored\n3. NanoTag payload decoded by fPort: ports 26/27 = temperature, ports 1/13/21/31/32 = battery\n4. Temperature readings stored in `incubator_nanotag_readings_v1`\n5. Each temperature reading triggers a temperature alert check (calibrated NanoTag temp). Humidity is passed as `null` throughout, so humidity alert checks are skipped\n6. Dashboard polls `/api/status` and `/api/readings/nanotag` every 60 seconds\n\n### Sensor Calibration\nDefined in `shared/constants.ts`:\n- NanoTag: +1°F offset (`CALIBRATION.nanotagTemperatureF`)\n- Backend stores raw temperature; the dashboard and alert logic apply the offset\n\n### Incubation Logic\n- 17-day Coturnix quail incubation starting from `INCUBATION_CONFIG.startDate`\n- Lockdown phase begins day 15 (advisory only — no humidity sensor to enforce it)\n- Temperature thresholds: ideal 101-102°F, warning ±3°F, critical ±5°F\n- Alerts rate-limited: critical every 5 min, warning every 30 min\n- Mode (`incubation`/`brooder`) and `hatch_date` are stored in the `incubator_config_v1` table; brooder mode auto-activates on day 19+. To restart the clock for a new batch, update `INCUBATION_CONFIG.startDate` AND clear the `mode`/`hatch_date` config rows (or start from a fresh per-val DB).\n\n### Frontend\n- React 18.2.0. Layout utilities via twind (Tailwind CDN); the visual design lives in a hand-written CSS system in `frontend/index.html` (`\n\n\n

\n \n\n\n",[],[178,305],"732391a0-f7ed-11f0-829a-42dde27851f2","icon-512.svg","73239240-f7ed-11f0-829a-42dde27851f2","6d3e8d6c-f7ed-11f0-8a0d-42dde27851f2",198,["D",1769125965943],"\n",[],[178,322,314],"icons","7327aa60-f7ed-11f0-ae21-42dde27851f2","icon-192.svg","7327ab1e-f7ed-11f0-ae21-42dde27851f2",199,["D",1769125965955],"\n",[],[178,322,324],"776c0a6c-f7ed-11f0-8480-42dde27851f2","apple-touch-icon.svg","776c0b84-f7ed-11f0-8480-42dde27851f2",200,["D",1769125973131],"\n",[],[178,322,332],"6d3e8c68-f7ed-11f0-8a0d-42dde27851f2",196,["D",1769125956055],[232,233,234],[178,322],"c3028023-0733-4157-b1b0-8847040e7a10","IncubationStatus.tsx","31aa9314-f5bc-11f0-bf42-42dde27851f2","313093e8-f5bc-11f0-a7c1-42dde27851f2",268,["D",1783402026632],12,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { getPhaseForDay } from \"../../shared/dailyTips.ts\";\n\ninterface IncubationStatusData {\n currentDay: number;\n daysRemaining: number;\n phase: \"incubation\" | \"lockdown\" | \"hatching\" | \"complete\";\n lockdownDate: string;\n hatchDate: string;\n startDate: string;\n progressPercent: number;\n}\n\ninterface Props {\n status: IncubationStatusData;\n}\n\nexport function IncubationStatus({ status }: Props) {\n const formatDate = (dateStr: string) =>\n new Date(dateStr).toLocaleDateString(\"en-US\", { month: \"short\", day: \"numeric\" });\n\n const clampedProgress = Math.max(0, Math.min(100, status.progressPercent));\n const lockdownPct = (14 / 17) * 100;\n\n return (\n

\n The Incubation\n {getPhaseForDay(status.currentDay)}\n

\n\n

\n\n {/* Day count */}\n

\n {status.currentDay}\n \n / 17\n \n

\n {status.daysRemaining > 0\n ? `${status.daysRemaining} day${status.daysRemaining !== 1 ? \"s\" : \"\"} until hatch`\n : status.phase === \"hatching\"\n ? \"hatching time 🐣\"\n : \"incubation complete\"}\n

\n\n {/* Ruled timeline with lockdown tick */}\n

\n \n

\n\n {/* Milestone dates */}\n

Set

{formatDate(status.startDate)}

Lockdown

{formatDate(status.lockdownDate)}

Hatch

{formatDate(status.hatchDate)}

\n\n {/* Lockdown advisory */}\n {status.phase === \"lockdown\" && (\n

\n ✦\n

\n Lockdown. Keep humidity high (65–75%) and do not open the incubator.\n

\n )}\n

\n );\n}\n",[],[178,354,345],"components","806749ce-96c3-4677-a7ea-c9d42441467a","HistoricalChart.tsx","31cbd4c0-f5bc-11f0-bc26-42dde27851f2",273,["D",1783402198622],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useEffect, useRef, useState } from \"https://esm.sh/react@18.2.0\";\nimport { CALIBRATION } from \"../../shared/constants.ts\";\n\ninterface NanoTagReading {\n timestamp: string;\n temperatureF: number;\n}\n\ninterface Props {\n nanotagReadings: NanoTagReading[];\n targetTemp?: { min: number; max: number }; // For brooder mode\n}\n\ndeclare const Chart: any;\n\ntype TimeRange = \"1h\" | \"6h\" | \"12h\" | \"24h\";\n\nconst TIME_RANGES: TimeRange[] = [\"1h\", \"6h\", \"12h\", \"24h\"];\n\nconst HOUR_MS = 60 * 60 * 1000;\n\nconst RANGE_MS: Record = {\n \"1h\": 1 * HOUR_MS,\n \"6h\": 6 * HOUR_MS,\n \"12h\": 12 * HOUR_MS,\n \"24h\": 24 * HOUR_MS,\n};\n\n// Almanac palette (mirrors CSS variables)\nconst INK_BLUE = \"#294061\";\nconst OLIVE = \"#5b6836\";\nconst RULE = \"#cabf9c\";\nconst INK_SOFT = \"#6f6553\";\n\nexport function HistoricalChart({ nanotagReadings, targetTemp }: Props): JSX.Element {\n const canvasRef = useRef(null);\n const chartRef = useRef(null);\n const [chartLoaded, setChartLoaded] = useState(false);\n const [timeRange, setTimeRange] = useState(\"24h\");\n\n useEffect(() => {\n if (typeof Chart !== \"undefined\") {\n setChartLoaded(true);\n return;\n }\n\n const script = document.createElement(\"script\");\n script.src = \"https://cdn.jsdelivr.net/npm/chart.js@4.4.1/dist/chart.umd.min.js\";\n script.onload = () => setChartLoaded(true);\n document.head.appendChild(script);\n }, []);\n\n useEffect(() => {\n if (!chartLoaded || !canvasRef.current) return;\n\n const cutoff = Date.now() - RANGE_MS[timeRange];\n\n // Filter NanoTag readings to the selected time range\n const filtered = nanotagReadings.filter(\n (r) => new Date(r.timestamp).getTime() >= cutoff\n );\n\n const labels = filtered.map((r) => {\n const date = new Date(r.timestamp);\n return date.toLocaleTimeString(\"en-US\", {\n hour: \"numeric\",\n minute: \"2-digit\",\n });\n });\n\n const tempData = filtered.map((r) => r.temperatureF + CALIBRATION.nanotagTemperatureF);\n\n // Target temperature band (upper and lower bounds)\n const targetMax = targetTemp ? targetTemp.max : 102;\n const targetMin = targetTemp ? targetTemp.min : 101;\n const targetUpperData = filtered.map(() => targetMax);\n const targetLowerData = filtered.map(() => targetMin);\n\n if (chartRef.current) {\n chartRef.current.data.labels = labels;\n chartRef.current.data.datasets[0].data = targetUpperData;\n chartRef.current.data.datasets[1].data = targetLowerData;\n chartRef.current.data.datasets[2].data = tempData;\n chartRef.current.update();\n } else {\n const ctx = canvasRef.current.getContext(\"2d\");\n chartRef.current = new Chart(ctx, {\n type: \"line\",\n data: {\n labels,\n datasets: [\n {\n label: \"Ideal Upper\",\n data: targetUpperData,\n borderColor: \"rgba(91, 104, 54, 0.35)\",\n backgroundColor: \"transparent\",\n yAxisID: \"y\",\n tension: 0,\n pointRadius: 0,\n pointHoverRadius: 0,\n borderWidth: 1,\n borderDash: [3, 3],\n fill: false,\n },\n {\n label: \"Ideal Lower\",\n data: targetLowerData,\n borderColor: \"rgba(91, 104, 54, 0.35)\",\n backgroundColor: \"rgba(91, 104, 54, 0.10)\",\n yAxisID: \"y\",\n tension: 0,\n pointRadius: 0,\n pointHoverRadius: 0,\n borderWidth: 1,\n borderDash: [3, 3],\n fill: \"-1\", // Fill the ideal band between the two bounds\n },\n {\n label: \"NanoThings (°F)\",\n data: tempData,\n borderColor: INK_BLUE,\n backgroundColor: \"rgba(41, 64, 97, 0.08)\",\n yAxisID: \"y\",\n tension: 0.35,\n pointRadius: 0,\n pointHoverRadius: 5,\n pointHoverBackgroundColor: INK_BLUE,\n borderWidth: 2,\n fill: true,\n },\n ],\n },\n options: {\n responsive: true,\n maintainAspectRatio: false,\n font: { family: \"Spectral\" },\n interaction: { mode: \"index\", intersect: false },\n plugins: {\n legend: {\n display: true,\n position: \"top\",\n align: \"end\",\n labels: {\n color: INK_SOFT,\n usePointStyle: true,\n pointStyle: \"line\",\n padding: 18,\n font: { size: 12, family: \"Spectral\" },\n filter: (item: any) => item.datasetIndex > 1, // Hide the ideal band from legend\n },\n },\n tooltip: {\n backgroundColor: \"#f6eeda\",\n titleColor: \"#294061\",\n bodyColor: \"#2b2419\",\n borderColor: RULE,\n borderWidth: 1,\n padding: 10,\n cornerRadius: 2,\n displayColors: false,\n titleFont: { family: \"Spectral\", weight: \"600\" },\n bodyFont: { family: \"Fraunces\" },\n filter: (item: any) => item.datasetIndex > 1,\n },\n },\n scales: {\n x: {\n grid: { color: \"rgba(202, 191, 156, 0.4)\", drawBorder: false },\n ticks: { color: INK_SOFT, maxTicksLimit: 7, font: { size: 11, family: \"Spectral\" } },\n },\n y: {\n type: \"linear\",\n position: \"left\",\n min: targetTemp ? targetTemp.min - 15 : 90,\n max: targetTemp ? targetTemp.max + 10 : 115,\n grid: { color: \"rgba(202, 191, 156, 0.4)\", drawBorder: false },\n ticks: { color: INK_SOFT, font: { size: 11, family: \"Fraunces\" } },\n title: {\n display: true,\n text: \"Temperature (°F)\",\n color: INK_SOFT,\n font: { size: 11, family: \"Spectral\", weight: \"600\" },\n },\n },\n },\n },\n });\n }\n\n return () => {\n if (chartRef.current) {\n chartRef.current.destroy();\n chartRef.current = null;\n }\n };\n }, [chartLoaded, nanotagReadings, timeRange]);\n\n if (nanotagReadings.length === 0) {\n return (\n

\n Temperature Record\n

📈

No record yet

\n Readings will be plotted as they arrive\n

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

\n Temperature Record\n

\n {TIME_RANGES.map((range, i) => {\n const isActive = timeRange === range;\n return (\n setTimeRange(range)}\n className=\"label\"\n style={{\n padding: \"0.3rem 0.6rem\",\n fontSize: \"0.6rem\",\n letterSpacing: \"0.1em\",\n cursor: \"pointer\",\n borderLeft: i === 0 ? \"none\" : \"1px solid var(--rule)\",\n background: isActive ? \"var(--ink-blue)\" : \"transparent\",\n color: isActive ? \"var(--paper)\" : \"var(--ink-faint)\",\n }}\n >\n {range}\n \n );\n })}\n

\n {chartLoaded ? (\n

\n ) : (\n

\n Drawing the chart…\n

\n )}\n

\n );\n}\n",[],[178,354,356],"a2010a63-e3ae-4ffa-8caf-0640d832a27e","Header.tsx","31c5ce40-f5bc-11f0-9ddc-42dde27851f2",264,["D",1783401863478],6,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\n\nexport function Header() {\n const today = new Date().toLocaleDateString(\"en-US\", {\n weekday: \"long\",\n month: \"long\",\n day: \"numeric\",\n year: \"numeric\",\n });\n\n return (\n

Daily Incubation Register

\n\n

\n\n \n The Quail Almanac\n \n\n

\n\n

\n Coturnix Quail\n \n 17-day watch\n \n {today}\n

\n );\n}\n",[],[178,354,364],"5e6af184-3f2e-494b-9c65-9b05e2de78b5","DailyTips.tsx","31a61230-f5bc-11f0-aedd-42dde27851f2",269,["D",1783402065318],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\n\ninterface DailyTip {\n day: number;\n phase: string;\n tasks: string[];\n isSpecialDay: boolean;\n specialNote?: string;\n}\n\ninterface Props {\n tip: DailyTip;\n}\n\nexport function DailyTips({ tip }: Props) {\n const showEgg = tip.phase === \"Hatch Day\" || tip.phase === \"Post-Hatch\";\n\n return (\n

\n The Day's Labors\n

\n Day {tip.day} · {tip.phase}\n {showEgg && 🐣}\n

\n {tip.isSpecialDay && Marked Day}\n

\n\n

\n\n {/* Special note — a left-ruled editorial aside */}\n {tip.specialNote && (\n

{tip.specialNote}

\n )}\n\n {/* Ledger of tasks */}\n

\n ✦\n \n {task}\n \n \n );\n })}\n

\n\n {/* Phase footnote */}\n {tip.phase === \"Lockdown\" && (\n

\n Note —{\" \"}\n Add a wet sponge or extra water to raise humidity. Opening the incubator now can cause chicks to get stuck.\n

\n )}\n\n {tip.phase === \"Hatch Day\" && (\n

\n Note —{\" \"}\n Hatching can take 12–24 hours from first pip. The struggle is necessary; only intervene after 24+ hours with no progress.\n

\n )}\n

\n );\n}\n",[],[178,354,373],"36a0392f-0747-4b06-a107-1fec4007e086","CurrentReadings.tsx","31b86278-f5bc-11f0-97e8-42dde27851f2",267,["D",1783401983843],17,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { CALIBRATION } from \"../../shared/constants.ts\";\n\n// Current reading from the NanoTag (temperature-only sensor). temperatureF is raw;\n// the NanoTag calibration offset is applied here for display.\ninterface CurrentReading {\n temperatureC: number;\n temperatureF: number;\n batteryVoltage: number | null;\n rssi?: number | null;\n timestamp: string;\n}\n\ninterface AlertThresholds {\n temperature: {\n current: number;\n status: \"critical-low\" | \"warning-low\" | \"ideal\" | \"warning-high\" | \"critical-high\";\n };\n humidity: {\n current: number;\n target: { min: number; max: number };\n status: \"low\" | \"ideal\" | \"high\";\n } | null;\n}\n\ninterface Props {\n reading: CurrentReading | null;\n alerts: AlertThresholds | null;\n targetTemp?: { min: number; max: number }; // For brooder mode\n}\n\nexport function CurrentReadings({ reading, alerts, targetTemp }: Props) {\n if (!reading) {\n return (\n

\n Coop Temperature\n

📡

\n Awaiting the NanoTag\n

\n Powered on and joined to the network?\n

\n );\n }\n\n const tempStatus = alerts?.temperature.status || \"ideal\";\n\n const statusConfig = (() => {\n switch (tempStatus) {\n case \"critical-low\":\n case \"critical-high\":\n return { pillClass: \"pill-red\", label: \"Critical\", ink: \"var(--oxblood)\" };\n case \"warning-low\":\n case \"warning-high\":\n return { pillClass: \"pill-yellow\", label: \"Watch\", ink: \"var(--gold)\" };\n default:\n return { pillClass: \"pill-green\", label: \"Ideal\", ink: \"var(--ink-blue)\" };\n }\n })();\n\n const formatTime = (timestamp: string) => {\n const date = new Date(timestamp);\n return date.toLocaleTimeString(\"en-US\", { hour: \"numeric\", minute: \"2-digit\" });\n };\n\n // Battery percentage (2.5V = 0%, 3.6V = 100%)\n const getBatteryPercent = (voltage: number) => {\n const min = 2.5;\n const max = 3.6;\n return Math.max(0, Math.min(100, ((voltage - min) / (max - min)) * 100));\n };\n\n // Calibrated NanoTag temperature\n const tempF = reading.temperatureF + CALIBRATION.nanotagTemperatureF;\n const targetMin = targetTemp ? targetTemp.min : 101;\n const targetMax = targetTemp ? targetTemp.max : 102;\n\n const batteryPercent =\n reading.batteryVoltage != null ? getBatteryPercent(reading.batteryVoltage) : null;\n const batteryColor =\n batteryPercent == null\n ? \"var(--rule-strong)\"\n : batteryPercent < 20\n ? \"var(--oxblood)\"\n : batteryPercent < 50\n ? \"var(--gold)\"\n : \"var(--olive)\";\n\n return (\n

\n Coop Temperature\n {statusConfig.label}\n

\n\n

\n\n {/* The reading */}\n

\n \n {tempF.toFixed(1)}\n °F\n

\n ideal range {targetMin}–{targetMax}°F\n

\n\n

\n\n {/* Sensor footnote */}\n

\n NanoThings\n {reading.batteryVoltage != null && batteryPercent !== null ? (\n \n \n {Math.round(batteryPercent)}%\n \n ) : (\n —\n )}\n

\n logged {formatTime(reading.timestamp)}\n

\n );\n}\n",[],[178,354,381],"a5ca6e03-bb2f-44a7-a96f-882b9ebceb99","BrooderStatus.tsx","54698e82-013d-11f1-af41-42dde27851f2",272,["D",1783402146464],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport type { BrooderStatus as BrooderStatusData, OutdoorReadiness, WeatherForecast } from \"../../shared/types.ts\";\n\ninterface Props {\n status: BrooderStatusData;\n outdoorReadiness?: OutdoorReadiness;\n}\n\nexport function BrooderStatus({ status, outdoorReadiness }: Props) {\n const formatDate = (dateStr: string) =>\n new Date(dateStr).toLocaleDateString(\"en-US\", { month: \"short\", day: \"numeric\" });\n\n // Progress through the 5-week (35-day) brooder period\n const progressPercent = Math.min(100, (status.chickAgeDays / 35) * 100);\n\n return (\n

\n The Brooder\n Brooding\n

\n\n

\n\n {/* Age */}\n

\n {status.chickAgeWeek}\n \n / 5\n \n

\n week {status.chickAgeWeek}, day {status.chickAgeDayOfWeek}\n {status.chickAgeDays > 1 && ` · ${status.chickAgeDays} days old`}\n

\n\n {/* Ruled timeline with week ticks */}\n

\n {[1, 2, 3, 4].map((week) => (\n \n ))}\n

\n\n {/* Target temperature */}\n

Target Temp

\n {status.targetTemp.min}–{status.targetTemp.max}°F\n

\n {status.nextTempChange && (\n

\n In {status.nextTempChange.daysUntil} day{status.nextTempChange.daysUntil !== 1 ? \"s\" : \"\"}\n

\n {status.nextTempChange.newTarget.min}–{status.nextTempChange.newTarget.max}°F\n

\n )}\n

\n\n {/* Outdoor readiness */}\n {outdoorReadiness && (\n \n

\n {outdoorReadiness.isReady ? \"🌳\" : \"🏠\"}\n \n {outdoorReadiness.isReady ? \"Ready for Outdoors\" : \"Indoor Care Needed\"}\n \n

{outdoorReadiness.reason}

\n {!outdoorReadiness.isReady && outdoorReadiness.forecast.length > 0 && (\n

\n {outdoorReadiness.forecast.map((day: WeatherForecast) => (\n = 50 ? \"var(--olive)\" : \"var(--oxblood)\" }}\n >\n {new Date(day.date).toLocaleDateString(\"en-US\", { weekday: \"short\" })} {Math.round(day.minTempF)}°\n \n ))}\n

\n )}\n

\n )}\n\n {/* Hatched footnote */}\n

\n Hatched {formatDate(status.hatchDate)}\n

\n );\n}\n",[],[178,354,390],"e46f78ce-1b8c-41c5-8400-cc4c4e39f98f","App.tsx","3199d0ce-f5bc-11f0-aedd-42dde27851f2",281,["D",1783460615773],22,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { Header } from \"./Header.tsx\";\nimport { CurrentReadings } from \"./CurrentReadings.tsx\";\nimport { IncubationStatus } from \"./IncubationStatus.tsx\";\nimport { BrooderStatus } from \"./BrooderStatus.tsx\";\nimport { DailyTips } from \"./DailyTips.tsx\";\nimport { HistoricalChart } from \"./HistoricalChart.tsx\";\nimport { AlertBanner } from \"./AlertBanner.tsx\";\n\n// The dashboard's current reading, derived from the NanoTag (temperature-only sensor).\ninterface CurrentReading {\n timestamp: string;\n temperatureC: number;\n temperatureF: number;\n batteryVoltage: number | null;\n rssi?: number | null;\n humidity: null;\n}\n\ninterface IncubationStatusData {\n currentDay: number;\n daysRemaining: number;\n phase: \"incubation\" | \"lockdown\" | \"hatching\" | \"complete\";\n lockdownDate: string;\n hatchDate: string;\n startDate: string;\n progressPercent: number;\n}\n\ninterface AlertThresholds {\n temperature: {\n current: number;\n status: \"critical-low\" | \"warning-low\" | \"ideal\" | \"warning-high\" | \"critical-high\";\n };\n humidity: {\n current: number;\n target: { min: number; max: number };\n status: \"low\" | \"ideal\" | \"high\";\n } | null;\n}\n\ninterface DailyTip {\n day: number;\n phase: string;\n tasks: string[];\n isSpecialDay: boolean;\n specialNote?: string;\n}\n\ninterface NanoTagReading {\n id: number;\n deviceEui: string;\n timestamp: string;\n temperatureC: number;\n temperatureF: number;\n batteryVoltage: number | null;\n fport: number;\n rssi?: number;\n snr?: number;\n}\n\n// Brooder mode types\ninterface BrooderStatusData {\n mode: \"brooder\";\n hatchDate: string;\n chickAgeDays: number;\n chickAgeWeek: number;\n chickAgeDayOfWeek: number;\n targetTemp: { min: number; max: number };\n nextTempChange: {\n daysUntil: number;\n newTarget: { min: number; max: number };\n } | null;\n}\n\ninterface WeatherForecast {\n date: string;\n minTempF: number;\n maxTempF: number;\n}\n\ninterface OutdoorReadiness {\n isReady: boolean;\n reason: string;\n chickAgeWeeks: number;\n forecast: WeatherForecast[];\n meetsAgeCriteria: boolean;\n meetsWeatherCriteria: boolean;\n coldestNightF: number | null;\n}\n\n// Unified dashboard data with mode support\ninterface DashboardData {\n mode: \"incubation\" | \"brooder\";\n currentReading: CurrentReading | null;\n // Incubation mode fields\n incubationStatus?: IncubationStatusData;\n dailyTip?: DailyTip;\n alerts?: AlertThresholds | null;\n // Brooder mode fields\n brooderStatus?: BrooderStatusData;\n outdoorReadiness?: OutdoorReadiness;\n // Common fields\n nanotagReadings: NanoTagReading[];\n}\n\ndeclare global {\n interface Window {\n __INITIAL_DATA__?: DashboardData;\n }\n}\n\nexport function App() {\n const [data, setData] = useState(\n window.__INITIAL_DATA__ || null\n );\n const [loading, setLoading] = useState(!window.__INITIAL_DATA__);\n const [error, setError] = useState(null);\n\n // Fetch data on mount and every 60 seconds\n useEffect(() => {\n async function fetchData() {\n try {\n const [statusRes, nanotagRes] = await Promise.all([\n fetch(\"/api/status\"),\n fetch(\"/api/readings/nanotag?minutes=1440\"),\n ]);\n\n if (!statusRes.ok || !nanotagRes.ok) {\n throw new Error(\"Failed to fetch data\");\n }\n\n const status = await statusRes.json();\n const nanotagReadings = await nanotagRes.json();\n\n setData({\n ...status,\n nanotagReadings,\n });\n setError(null);\n } catch (err) {\n console.error(\"Failed to fetch data:\", err);\n setError(err instanceof Error ? err.message : \"Unknown error\");\n } finally {\n setLoading(false);\n }\n }\n\n if (!window.__INITIAL_DATA__) {\n fetchData();\n }\n\n const interval = setInterval(fetchData, 60000);\n return () => clearInterval(interval);\n }, []);\n\n // Determine if we're in brooder mode\n const isBrooderMode = data?.mode === \"brooder\";\n\n if (loading) {\n return (\n

{isBrooderMode ? \"🐥\" : \"🥚\"}

\n Turning to today's page…\n

Reading the register

\n );\n }\n\n if (error && !data) {\n return (\n

🕯️

\n The page would not turn\n

{error}

\n window.location.reload()}\n className=\"mt-6 pill pill-blue\"\n style={{ padding: \"0.5rem 1.25rem\", cursor: \"pointer\", fontSize: \"0.7rem\" }}\n >\n Try Again\n \n

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

🥚

Nothing recorded yet

Awaiting the first reading

\n );\n }\n\n // Suppress alerts entirely when chicks are ready for outdoors\n const isReadyForOutdoors = isBrooderMode && data.outdoorReadiness?.isReady;\n const alerts = isReadyForOutdoors ? null : data.alerts;\n\n return (\n

\n\n {alerts && (\n

\n \n

\n )}\n\n

\n \n {isBrooderMode && data.brooderStatus ? (\n \n ) : data.incubationStatus ? (\n \n ) : null}\n

\n\n {/* Only show daily tips in incubation mode */}\n {!isBrooderMode && data.dailyTip && (\n

\n \n

\n )}\n\n

\n \n

\n\n \n

\n );\n}\n",[],[178,354,398],"4e157b6e-55b9-439f-acda-aec7626fac7e","AlertBanner.tsx","31ae4180-f5bc-11f0-9ddc-42dde27851f2",271,["D",1783402108126],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\n\ninterface AlertThresholds {\n temperature: {\n current: number;\n status: \"critical-low\" | \"warning-low\" | \"ideal\" | \"warning-high\" | \"critical-high\";\n };\n humidity: {\n current: number;\n target: { min: number; max: number };\n status: \"low\" | \"ideal\" | \"high\";\n } | null;\n}\n\ninterface Props {\n alerts: AlertThresholds;\n}\n\nexport function AlertBanner({ alerts }: Props) {\n const tempStatus = alerts.temperature.status;\n const isCritical = tempStatus === \"critical-low\" || tempStatus === \"critical-high\";\n\n // Only show banner for non-ideal conditions\n if (tempStatus === \"ideal\") {\n return null;\n }\n\n const getMessage = () => {\n switch (tempStatus) {\n case \"critical-low\":\n return {\n title: \"Temperature Too Low\",\n message: `The reading of ${alerts.temperature.current.toFixed(1)}°F is dangerously low. Embryo development is at risk.`,\n action: \"Check the heat source at once.\",\n };\n case \"critical-high\":\n return {\n title: \"Temperature Too High\",\n message: `The reading of ${alerts.temperature.current.toFixed(1)}°F is dangerously high. Risk of embryo damage.`,\n action: \"Reduce heat or improve ventilation at once.\",\n };\n case \"warning-low\":\n return {\n title: \"Temperature Low\",\n message: `The reading of ${alerts.temperature.current.toFixed(1)}°F is below the ideal range.`,\n action: \"Consider adjusting the heat source.\",\n };\n case \"warning-high\":\n return {\n title: \"Temperature High\",\n message: `The reading of ${alerts.temperature.current.toFixed(1)}°F is above the ideal range.`,\n action: \"Consider improving ventilation.\",\n };\n default:\n return null;\n }\n };\n\n const alert = getMessage();\n if (!alert) return null;\n\n const accent = isCritical ? \"var(--oxblood)\" : \"var(--gold)\";\n\n return (\n \n

\n {isCritical ? \"Urgent Notice\" : \"Notice\"}\n \n {alert.title}\n \n

{alert.message}

{alert.action}

\n\n

\n {alerts.temperature.current.toFixed(1)}°\n

Current

\n \n );\n}\n",[],[178,354,407],"31309302-f5bc-11f0-a7c1-42dde27851f2",["D",1768884907625],[223,224,225,226,227,228,229,230],[178,354],["D",1768884906906],[222,231,235,236,237],[178],"f55e6c69-3d5c-4601-8ff1-424619ac91a4","index.http.tsx",280,["D",1783460609597],10,"http","// Main Hono HTTP entry point for Incubator Tracker\nimport { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { serveFile, readFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport { webhookRouter } from \"./routes/webhook.ts\";\nimport { apiRouter } from \"./routes/api.ts\";\nimport { getLatestNanoTagReading, getLatestNanoTagBatteryVoltage, getRecentNanoTagReadings } from \"./database/queries.ts\";\nimport {\n calculateIncubationStatus,\n getCurrentDailyTip,\n getAlertThresholds,\n getCurrentMode,\n getHatchDate,\n} from \"./services/incubation.ts\";\nimport {\n calculateBrooderStatus,\n getBrooderAlertThresholds,\n evaluateOutdoorReadiness,\n} from \"./services/brooder.ts\";\nimport { fetchWeatherForecast } from \"./services/weather.ts\";\nimport { CALIBRATION } from \"../shared/constants.ts\";\n\nconst app = new Hono();\n\n// Simple health check (before any middleware)\napp.get(\"/health\", (c) => c.json({ status: \"ok\", timestamp: new Date().toISOString() }));\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Run migrations lazily on first request\nlet migrationsRun = false;\napp.use(\"*\", async (c, next) => {\n if (!migrationsRun) {\n try {\n await runMigrations();\n migrationsRun = true;\n } catch (err) {\n console.error(\"Migration error:\", err);\n return c.json({ error: \"Migration failed\", details: String(err) }, 500);\n }\n }\n return next();\n});\n\n// Mount routes\napp.route(\"/webhook\", webhookRouter);\napp.route(\"/api\", apiRouter);\n\n// Serve static files from frontend/ and shared/\napp.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", (c) => serveFile(c.req.path, import.meta.url));\n\n// Serve main dashboard with initial data\napp.get(\"/\", async (c) => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n\n // Current reading comes from the NanoTag (the sole sensor). temperatureF is raw;\n // the frontend applies the NanoTag calibration offset for display.\n const nano = await getLatestNanoTagReading();\n const currentReading = nano\n ? {\n timestamp: nano.timestamp,\n temperatureC: nano.temperatureC,\n temperatureF: nano.temperatureF,\n batteryVoltage: nano.batteryVoltage,\n rssi: nano.rssi ?? null,\n humidity: null, // NanoTag has no humidity sensor\n }\n : null;\n const mode = await getCurrentMode();\n\n // Calibrated NanoTag temperature for alert thresholds\n const calibratedTempF = nano ? nano.temperatureF + CALIBRATION.nanotagTemperatureF : 0;\n\n // Build mode-aware initial data\n let initialData;\n\n if (mode === \"brooder\") {\n const hatchDate = await getHatchDate();\n if (hatchDate) {\n const brooderStatus = calculateBrooderStatus(hatchDate);\n const alerts = nano\n ? getBrooderAlertThresholds(calibratedTempF, null, brooderStatus.chickAgeDays)\n : null;\n const forecast = await fetchWeatherForecast();\n const outdoorReadiness = evaluateOutdoorReadiness(brooderStatus.chickAgeDays, forecast);\n\n initialData = {\n mode: \"brooder\",\n currentReading,\n brooderStatus,\n alerts,\n outdoorReadiness,\n nanotagReadings: await getRecentNanoTagReadings(24 * 60),\n };\n }\n }\n\n // Default to incubation mode if not brooder or no hatch date\n if (!initialData) {\n const incubationStatus = calculateIncubationStatus();\n const dailyTip = getCurrentDailyTip();\n const alerts = nano\n ? getAlertThresholds(calibratedTempF, null, incubationStatus.currentDay)\n : null;\n\n initialData = {\n mode: \"incubation\",\n currentReading,\n incubationStatus,\n dailyTip,\n alerts,\n nanotagReadings: await getRecentNanoTagReadings(24 * 60),\n };\n }\n\n const dataScript = ``;\n\n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n});\n\n// This is the entry point for HTTP vals\nexport default app.fetch;\n","quail-incubator",[],[184,422],"54720a30-013d-11f1-9089-42dde27851f2","weather.ts","54720af8-013d-11f1-9089-42dde27851f2","317da458-f5bc-11f0-9ddc-42dde27851f2",218,["D",1770149834611],"// Weather API integration using Open-Meteo (free, no API key required)\nimport { WEATHER_LOCATION } from \"../../shared/constants.ts\";\nimport type { WeatherForecast } from \"../../shared/types.ts\";\n\n// Cache weather data for 1 hour to avoid excessive API calls\nlet weatherCache: {\n data: WeatherForecast[];\n fetchedAt: number;\n} | null = null;\n\nconst CACHE_DURATION_MS = 60 * 60 * 1000; // 1 hour\n\n/**\n * Fetch 7-day weather forecast from Open-Meteo\n * Returns cached data if available and fresh\n */\nexport async function fetchWeatherForecast(): Promise {\n // Return cached data if fresh\n if (weatherCache && Date.now() - weatherCache.fetchedAt < CACHE_DURATION_MS) {\n return weatherCache.data;\n }\n\n const { latitude, longitude, timezone } = WEATHER_LOCATION;\n const url = new URL(\"https://api.open-meteo.com/v1/forecast\");\n url.searchParams.set(\"latitude\", latitude.toString());\n url.searchParams.set(\"longitude\", longitude.toString());\n url.searchParams.set(\"daily\", \"temperature_2m_min,temperature_2m_max\");\n url.searchParams.set(\"temperature_unit\", \"fahrenheit\");\n url.searchParams.set(\"timezone\", timezone);\n url.searchParams.set(\"forecast_days\", \"7\");\n\n try {\n const response = await fetch(url.toString());\n if (!response.ok) {\n throw new Error(`Weather API error: ${response.status} ${response.statusText}`);\n }\n\n const data = await response.json();\n\n // Validate response structure\n if (!data.daily?.time || !data.daily?.temperature_2m_min || !data.daily?.temperature_2m_max) {\n throw new Error(\"Invalid weather API response structure\");\n }\n\n // Transform to our format\n const forecast: WeatherForecast[] = data.daily.time.map(\n (date: string, i: number) => ({\n date,\n minTempF: data.daily.temperature_2m_min[i],\n maxTempF: data.daily.temperature_2m_max[i],\n })\n );\n\n // Cache the result\n weatherCache = {\n data: forecast,\n fetchedAt: Date.now(),\n };\n\n return forecast;\n } catch (error) {\n console.error(\"Failed to fetch weather:\", error);\n\n // Return cached data even if stale (better than nothing)\n if (weatherCache?.data) {\n console.warn(\"Returning stale weather cache\");\n return weatherCache.data;\n }\n\n // Return empty array as last resort\n return [];\n }\n}\n\n/**\n * Clear the weather cache (useful for testing)\n */\nexport function clearWeatherCache(): void {\n weatherCache = null;\n}\n",[],[184,440,432],"services","e4782ef4-a5ce-48fe-b2cc-109fa6be132f","incubation.ts","31f22526-f5bc-11f0-97e8-42dde27851f2",244,["D",1783399317355],"// Incubation phase and status calculations\nimport { INCUBATION_CONFIG } from \"../../shared/constants.ts\";\nimport { getDailyTip } from \"../../shared/dailyTips.ts\";\nimport { getConfig, setConfig } from \"../database/queries.ts\";\nimport type { IncubationStatus, AlertThresholds, DailyTip, SystemMode } from \"../../shared/types.ts\";\n\n/**\n * Calculate the current incubation day (1-based)\n */\nexport function getCurrentDay(startDate: Date = INCUBATION_CONFIG.startDate): number {\n const now = new Date();\n const diffMs = now.getTime() - startDate.getTime();\n const diffDays = Math.floor(diffMs / (1000 * 60 * 60 * 24));\n return diffDays + 1; // Day 1 is the first day\n}\n\n/**\n * Determine the current incubation phase\n */\nexport function getPhase(\n day: number\n): \"incubation\" | \"lockdown\" | \"hatching\" | \"complete\" {\n if (day < 1) return \"incubation\";\n if (day < INCUBATION_CONFIG.lockdownStartDay) return \"incubation\";\n if (day <= INCUBATION_CONFIG.totalDays) return \"lockdown\";\n if (day <= INCUBATION_CONFIG.totalDays + 1) return \"hatching\";\n return \"complete\";\n}\n\n/**\n * Calculate full incubation status\n */\nexport function calculateIncubationStatus(\n startDate: Date = INCUBATION_CONFIG.startDate\n): IncubationStatus {\n const currentDay = getCurrentDay(startDate);\n const daysRemaining = Math.max(0, INCUBATION_CONFIG.totalDays - currentDay + 1);\n const phase = getPhase(currentDay);\n\n // Calculate dates\n const lockdownDate = new Date(startDate);\n lockdownDate.setDate(lockdownDate.getDate() + INCUBATION_CONFIG.lockdownStartDay - 1);\n\n const hatchDate = new Date(startDate);\n hatchDate.setDate(hatchDate.getDate() + INCUBATION_CONFIG.totalDays - 1);\n\n // Progress percentage (0-100)\n const progressPercent = Math.min(\n 100,\n Math.max(0, ((currentDay - 1) / INCUBATION_CONFIG.totalDays) * 100)\n );\n\n return {\n currentDay,\n daysRemaining,\n phase,\n lockdownDate: lockdownDate.toISOString(),\n hatchDate: hatchDate.toISOString(),\n startDate: startDate.toISOString(),\n progressPercent,\n };\n}\n\n/**\n * Get the target humidity range for the current phase\n */\nexport function getTargetHumidity(day: number): { min: number; max: number } {\n if (day >= INCUBATION_CONFIG.lockdownStartDay) {\n return INCUBATION_CONFIG.humidity.lockdown;\n }\n return INCUBATION_CONFIG.humidity.incubation;\n}\n\n/**\n * Evaluate current readings against thresholds\n */\nexport function getAlertThresholds(\n temperatureF: number,\n humidity: number | null,\n currentDay: number\n): AlertThresholds {\n const { temp } = INCUBATION_CONFIG;\n const humidityTarget = getTargetHumidity(currentDay);\n\n // Determine temperature status\n let tempStatus: AlertThresholds[\"temperature\"][\"status\"];\n if (temperatureF < temp.criticalMin) {\n tempStatus = \"critical-low\";\n } else if (temperatureF > temp.criticalMax) {\n tempStatus = \"critical-high\";\n } else if (temperatureF < temp.warningMin) {\n tempStatus = \"warning-low\";\n } else if (temperatureF > temp.warningMax) {\n tempStatus = \"warning-high\";\n } else {\n tempStatus = \"ideal\";\n }\n\n // Determine humidity status (null when no humidity sensor is present)\n let humidity_: AlertThresholds[\"humidity\"] = null;\n if (humidity !== null) {\n let humidityStatus: \"low\" | \"ideal\" | \"high\";\n if (humidity < humidityTarget.min) {\n humidityStatus = \"low\";\n } else if (humidity > humidityTarget.max) {\n humidityStatus = \"high\";\n } else {\n humidityStatus = \"ideal\";\n }\n humidity_ = { current: humidity, target: humidityTarget, status: humidityStatus };\n }\n\n return {\n temperature: {\n current: temperatureF,\n status: tempStatus,\n },\n humidity: humidity_,\n };\n}\n\n/**\n * Get the daily tip for the current day\n */\nexport function getCurrentDailyTip(\n startDate: Date = INCUBATION_CONFIG.startDate\n): DailyTip {\n const currentDay = getCurrentDay(startDate);\n return getDailyTip(currentDay);\n}\n\n// --- Mode Detection ---\n\n/**\n * Get the current system mode from config or auto-detect\n * Auto-transitions to brooder mode on day 19+ (2 days after expected hatch)\n */\nexport async function getCurrentMode(): Promise {\n // Check for explicit mode setting in config\n const modeConfig = await getConfig(\"mode\");\n if (modeConfig === \"brooder\") return \"brooder\";\n if (modeConfig === \"complete\") return \"complete\";\n\n // Check if incubation is complete and should auto-transition\n const status = calculateIncubationStatus();\n\n // Day 19+ (2 days after expected hatch of day 17)\n // Auto-transition to brooder mode\n if (status.currentDay >= 19 && status.phase === \"complete\") {\n // Auto-set hatch date if not already set (assume hatched on day 17)\n let hatchDateConfig = await getConfig(\"hatch_date\");\n if (!hatchDateConfig) {\n // Calculate hatch date as day 17 of incubation\n const hatchDate = new Date(INCUBATION_CONFIG.startDate);\n hatchDate.setDate(hatchDate.getDate() + INCUBATION_CONFIG.totalDays - 1);\n await setConfig(\"hatch_date\", hatchDate.toISOString());\n hatchDateConfig = hatchDate.toISOString();\n }\n\n // Update mode in config for future calls\n await setConfig(\"mode\", \"brooder\");\n return \"brooder\";\n }\n\n return \"incubation\";\n}\n\n/**\n * Activate brooder mode\n * Sets hatch date to now if not provided\n */\nexport async function activateBrooderMode(hatchDate?: Date): Promise {\n const date = hatchDate || new Date();\n await setConfig(\"hatch_date\", date.toISOString());\n await setConfig(\"mode\", \"brooder\");\n}\n\n/**\n * Get the stored hatch date from config\n */\nexport async function getHatchDate(): Promise {\n const hatchDateConfig = await getConfig(\"hatch_date\");\n return hatchDateConfig ? new Date(hatchDateConfig) : null;\n}\n\n/**\n * Reset to incubation mode (for testing or new batch)\n */\nexport async function resetToIncubationMode(): Promise {\n await setConfig(\"mode\", \"incubation\");\n // Note: hatch_date is preserved for historical reference\n}\n",[],[184,440,442],"f857926d-458e-45a1-a7fc-52b0d28669df","decoder.ts","31fa7226-f5bc-11f0-b5fb-42dde27851f2",249,["D",1783399402179],"// NanoThings NanoTag LoRaWAN payload decoder (temperature-only sensor)\nimport type { DecodedNanoTagPayload } from \"../../shared/types.ts\";\n\n/**\n * NanoTag port assignments\n */\nconst NANOTAG_PORTS = {\n TEMPERATURE: [26, 27],\n BATTERY: [1, 13, 21, 31, 32],\n};\n\n/**\n * Decode NanoTag payload based on fPort\n *\n * Port 26/27: Temperature readings (may contain array, we take the last valid one)\n * - Each reading is 2 bytes: (byte0 << 8) | byte1\n * - 0xFFFF = invalid/out-of-range reading\n * - Temperature (C) = (value - 5000) / 100\n *\n * Port 1/13/21/31/32: Battery status\n * - 2 bytes: voltage in mV (big-endian)\n */\nexport function decodeNanoTagPayload(base64Data: string, fPort: number): DecodedNanoTagPayload {\n // Decode base64 to bytes\n const binaryString = atob(base64Data);\n const bytes = new Uint8Array(binaryString.length);\n for (let i = 0; i < binaryString.length; i++) {\n bytes[i] = binaryString.charCodeAt(i);\n }\n\n const result: DecodedNanoTagPayload = {\n temperatureCelsius: null,\n };\n\n // Temperature ports (26, 27) - may contain multiple readings, take the last valid one\n if (NANOTAG_PORTS.TEMPERATURE.includes(fPort)) {\n for (let i = 0; i + 1 < bytes.length; i += 2) {\n const rawValue = (bytes[i] << 8) | bytes[i + 1];\n\n // Skip invalid readings (0xFFFF = out of range, 0xFFFC+ = sensor errors)\n if (rawValue >= 0xfffc) {\n continue;\n }\n\n // Keep updating - last valid reading wins\n result.temperatureCelsius = (rawValue - 5000) / 100;\n }\n }\n // Battery status ports (1, 13, 21, 31, 32)\n else if (NANOTAG_PORTS.BATTERY.includes(fPort)) {\n // Battery voltage is sent as 2 bytes in mV (big-endian)\n if (bytes.length >= 2) {\n const voltageMillivolts = (bytes[0] << 8) | bytes[1];\n result.batteryVoltage = voltageMillivolts / 1000; // Convert mV to V\n }\n }\n\n return result;\n}\n\n/**\n * Validate NanoTag payload\n */\nexport function validateNanoTagPayload(decoded: DecodedNanoTagPayload): { valid: boolean; errors: string[] } {\n const errors: string[] = [];\n\n if (decoded.temperatureCelsius !== null) {\n if (decoded.temperatureCelsius < -40 || decoded.temperatureCelsius > 85) {\n errors.push(`Temperature ${decoded.temperatureCelsius}C outside expected range (-40 to 85C)`);\n }\n }\n\n if (decoded.batteryVoltage !== undefined) {\n if (decoded.batteryVoltage < 2.0 || decoded.batteryVoltage > 3.5) {\n errors.push(`Battery voltage ${decoded.batteryVoltage}V outside expected range (2.0-3.5V)`);\n }\n }\n\n return {\n valid: errors.length === 0,\n errors,\n };\n}\n",[],[184,440,450],"8a67d270-397b-49d5-84b4-8aae260eaac7","brooder.ts","5460662c-013d-11f1-af41-42dde27851f2",245,["D",1783399332641],"// Brooder phase and status calculations\nimport { BROODER_CONFIG } from \"../../shared/constants.ts\";\nimport type {\n BrooderStatus,\n BrooderAlertThresholds,\n OutdoorReadiness,\n WeatherForecast,\n} from \"../../shared/types.ts\";\n\n/**\n * Calculate chick age in days from hatch date\n * Day 1 is the hatch day\n */\nexport function getChickAgeDays(hatchDate: Date): number {\n const now = new Date();\n const diffMs = now.getTime() - hatchDate.getTime();\n const diffDays = Math.floor(diffMs / (1000 * 60 * 60 * 24));\n return Math.max(1, diffDays + 1); // Minimum day 1\n}\n\n/**\n * Get the current week number (1-based, capped at 5 for week 5+)\n */\nexport function getChickAgeWeek(ageDays: number): number {\n return Math.min(5, Math.ceil(ageDays / 7));\n}\n\n/**\n * Get target temperature range for current chick age\n */\nexport function getTargetTemperature(ageDays: number): { min: number; max: number } {\n const schedule = BROODER_CONFIG.temperatureSchedule;\n\n for (const entry of schedule) {\n if (entry.maxDays === null || ageDays <= entry.maxDays) {\n return { ...entry.target };\n }\n }\n\n // Default to week 5+ range (last entry)\n const lastEntry = schedule[schedule.length - 1];\n return { ...lastEntry.target };\n}\n\n/**\n * Get temperature thresholds (warning and critical bounds) for current chick age\n */\nexport function getTemperatureThresholds(ageDays: number): {\n target: { min: number; max: number };\n warningMin: number;\n warningMax: number;\n criticalMin: number;\n criticalMax: number;\n} {\n const schedule = BROODER_CONFIG.temperatureSchedule;\n\n let entry = schedule[schedule.length - 1];\n for (const e of schedule) {\n if (e.maxDays === null || ageDays <= e.maxDays) {\n entry = e;\n break;\n }\n }\n\n return {\n target: { ...entry.target },\n warningMin: entry.target.min - entry.warningOffset,\n warningMax: entry.target.max + entry.warningOffset,\n criticalMin: entry.target.min - entry.criticalOffset,\n criticalMax: entry.target.max + entry.criticalOffset,\n };\n}\n\n/**\n * Calculate full brooder status\n */\nexport function calculateBrooderStatus(hatchDate: Date): BrooderStatus {\n const chickAgeDays = getChickAgeDays(hatchDate);\n const chickAgeWeek = getChickAgeWeek(chickAgeDays);\n const chickAgeDayOfWeek = ((chickAgeDays - 1) % 7) + 1;\n const targetTemp = getTargetTemperature(chickAgeDays);\n\n // Calculate next temperature change\n let nextTempChange: BrooderStatus[\"nextTempChange\"] = null;\n\n if (chickAgeWeek < 5) {\n // Days until end of current week\n const daysUntilNextWeek = 7 - chickAgeDayOfWeek + 1;\n const nextWeekDays = chickAgeDays + daysUntilNextWeek;\n const nextTarget = getTargetTemperature(nextWeekDays);\n\n // Only show if temperature actually changes\n if (nextTarget.min !== targetTemp.min || nextTarget.max !== targetTemp.max) {\n nextTempChange = {\n daysUntil: daysUntilNextWeek,\n newTarget: nextTarget,\n };\n }\n }\n\n return {\n mode: \"brooder\",\n hatchDate: hatchDate.toISOString(),\n chickAgeDays,\n chickAgeWeek,\n chickAgeDayOfWeek,\n targetTemp,\n nextTempChange,\n };\n}\n\n/**\n * Evaluate current readings against brooder thresholds\n */\nexport function getBrooderAlertThresholds(\n temperatureF: number,\n humidity: number | null,\n chickAgeDays: number\n): BrooderAlertThresholds {\n const thresholds = getTemperatureThresholds(chickAgeDays);\n const humidityTarget = BROODER_CONFIG.humidity;\n\n // Determine temperature status\n let tempStatus: BrooderAlertThresholds[\"temperature\"][\"status\"];\n if (temperatureF < thresholds.criticalMin) {\n tempStatus = \"critical-low\";\n } else if (temperatureF > thresholds.criticalMax) {\n tempStatus = \"critical-high\";\n } else if (temperatureF < thresholds.warningMin) {\n tempStatus = \"warning-low\";\n } else if (temperatureF > thresholds.warningMax) {\n tempStatus = \"warning-high\";\n } else {\n tempStatus = \"ideal\";\n }\n\n // Determine humidity status (null when no humidity sensor is present)\n let humidity_: BrooderAlertThresholds[\"humidity\"] = null;\n if (humidity !== null) {\n let humidityStatus: \"low\" | \"ideal\" | \"high\";\n if (humidity < humidityTarget.min) {\n humidityStatus = \"low\";\n } else if (humidity > humidityTarget.max) {\n humidityStatus = \"high\";\n } else {\n humidityStatus = \"ideal\";\n }\n humidity_ = { current: humidity, target: humidityTarget, status: humidityStatus };\n }\n\n return {\n temperature: {\n current: temperatureF,\n target: thresholds.target,\n status: tempStatus,\n },\n humidity: humidity_,\n };\n}\n\n/**\n * Evaluate outdoor readiness based on chick age and weather forecast\n */\nexport function evaluateOutdoorReadiness(\n chickAgeDays: number,\n forecast: WeatherForecast[]\n): OutdoorReadiness {\n const { outdoorReadiness: criteria } = BROODER_CONFIG;\n const chickAgeWeeks = chickAgeDays / 7;\n\n const meetsAgeCriteria = chickAgeWeeks >= criteria.minChickAgeWeeks;\n\n // Check if next N consecutive days have min temps above threshold\n const relevantForecast = forecast.slice(0, criteria.consecutiveDays);\n const coldestNightF =\n relevantForecast.length > 0\n ? Math.min(...relevantForecast.map((f) => f.minTempF))\n : null;\n\n const meetsWeatherCriteria =\n relevantForecast.length >= criteria.consecutiveDays &&\n relevantForecast.every((f) => f.minTempF >= criteria.minNightTempF);\n\n const isReady = meetsAgeCriteria && meetsWeatherCriteria;\n\n let reason: string;\n if (isReady) {\n reason = \"Chicks are old enough and weather is warm enough for outdoor transition.\";\n } else if (!meetsAgeCriteria) {\n const weeksRemaining = criteria.minChickAgeWeeks - chickAgeWeeks;\n if (weeksRemaining > 1) {\n reason = `Chicks need ${weeksRemaining.toFixed(1)} more weeks before outdoor transition.`;\n } else {\n const daysRemaining = Math.ceil(weeksRemaining * 7);\n reason = `Chicks need ${daysRemaining} more day${daysRemaining !== 1 ? \"s\" : \"\"} before outdoor transition.`;\n }\n } else {\n reason = `Nighttime temps too cold (${coldestNightF?.toFixed(0)}°F forecast). Need ${criteria.minNightTempF}°F+ for ${criteria.consecutiveDays} consecutive nights.`;\n }\n\n return {\n isReady,\n reason,\n chickAgeWeeks,\n forecast: relevantForecast,\n meetsAgeCriteria,\n meetsWeatherCriteria,\n coldestNightF,\n };\n}\n",[],[184,440,458],"d0118b9f-4ffe-4ea9-84e8-95415b50cfcf","alerts.ts","31fe3c4e-f5bc-11f0-97e8-42dde27851f2",243,["D",1783399297612],"// Email alert service with rate limiting\nimport { email } from \"https://esm.town/v/std/email\";\nimport { INCUBATION_CONFIG, BROODER_CONFIG } from \"../../shared/constants.ts\";\nimport { getLastAlertTime, recordAlert } from \"../database/queries.ts\";\nimport { getTargetHumidity } from \"./incubation.ts\";\nimport { getTargetTemperature, getTemperatureThresholds } from \"./brooder.ts\";\n\ninterface AlertToSend {\n level: \"critical\" | \"warning\";\n type: \"temperature\" | \"humidity\";\n message: string;\n}\n\n/**\n * Render the \"Current Readings\" list for an alert email.\n * Humidity is omitted entirely when null (the NanoTag has no humidity sensor).\n */\nfunction readingLines(temperatureF: number, humidity: number | null): { text: string; html: string } {\n const humidityText = humidity !== null ? `\\n- Humidity: ${humidity.toFixed(1)}%` : \"\";\n const humidityHtml =\n humidity !== null\n ? `

Humidity: ${humidity.toFixed(1)}%

`\n : \"\";\n return { text: humidityText, html: humidityHtml };\n}\n\n/**\n * Check temperature (and humidity, if available) against thresholds and send rate-limited email alerts.\n * `humidity` is null when the reading comes from a temperature-only sensor (NanoTag); humidity\n * checks are skipped in that case.\n */\nexport async function checkAndSendAlerts(\n temperatureF: number,\n humidity: number | null,\n currentDay: number\n): Promise {\n const { temp, alerts: alertConfig } = INCUBATION_CONFIG;\n const isLockdown = currentDay >= INCUBATION_CONFIG.lockdownStartDay;\n const humidityTarget = getTargetHumidity(currentDay);\n\n const alertsToSend: AlertToSend[] = [];\n\n // Temperature checks\n if (temperatureF < temp.criticalMin) {\n alertsToSend.push({\n level: \"critical\",\n type: \"temperature\",\n message: `CRITICAL: Temperature too LOW at ${temperatureF.toFixed(1)}°F (below ${temp.criticalMin}°F). Embryo development at risk!`,\n });\n } else if (temperatureF > temp.criticalMax) {\n alertsToSend.push({\n level: \"critical\",\n type: \"temperature\",\n message: `CRITICAL: Temperature too HIGH at ${temperatureF.toFixed(1)}°F (above ${temp.criticalMax}°F). Risk of embryo damage!`,\n });\n } else if (temperatureF < temp.warningMin) {\n alertsToSend.push({\n level: \"warning\",\n type: \"temperature\",\n message: `WARNING: Temperature low at ${temperatureF.toFixed(1)}°F (below ${temp.warningMin}°F). Consider adjusting.`,\n });\n } else if (temperatureF > temp.warningMax) {\n alertsToSend.push({\n level: \"warning\",\n type: \"temperature\",\n message: `WARNING: Temperature high at ${temperatureF.toFixed(1)}°F (above ${temp.warningMax}°F). Consider adjusting.`,\n });\n }\n\n // Humidity warnings (significant deviation from target) — only when humidity is available\n if (humidity !== null) {\n const humidityDeviation = 10; // Alert if 10% outside target range\n if (humidity < humidityTarget.min - humidityDeviation) {\n alertsToSend.push({\n level: \"warning\",\n type: \"humidity\",\n message: `WARNING: Humidity too low at ${humidity.toFixed(1)}% (target: ${humidityTarget.min}-${humidityTarget.max}% for ${isLockdown ? \"lockdown\" : \"incubation\"} phase)`,\n });\n } else if (humidity > humidityTarget.max + humidityDeviation) {\n alertsToSend.push({\n level: \"warning\",\n type: \"humidity\",\n message: `WARNING: Humidity too high at ${humidity.toFixed(1)}% (target: ${humidityTarget.min}-${humidityTarget.max}% for ${isLockdown ? \"lockdown\" : \"incubation\"} phase)`,\n });\n }\n }\n\n const lines = readingLines(temperatureF, humidity);\n\n // Process alerts with rate limiting\n for (const alert of alertsToSend) {\n const cooldown =\n alert.level === \"critical\"\n ? alertConfig.criticalCooldown\n : alertConfig.warningCooldown;\n\n const lastSent = await getLastAlertTime(alert.type, alert.level);\n const now = Date.now();\n\n if (!lastSent || now - lastSent.getTime() >= cooldown) {\n // Send email\n await email({\n subject: `[Incubator ${alert.level.toUpperCase()}] Day ${currentDay} - ${alert.type}`,\n text: `${alert.message}\n\nCurrent Readings:\n- Temperature: ${temperatureF.toFixed(1)}°F${lines.text}\n- Day: ${currentDay} of ${INCUBATION_CONFIG.totalDays}\n- Phase: ${isLockdown ? \"Lockdown\" : \"Incubation\"}\n\n---\nQuail Egg Incubator Monitor`,\n html: `\n

\n ${alert.level === \"critical\" ? \"🚨\" : \"⚠️\"} Incubator ${alert.level.toUpperCase()} Alert\n

${alert.message}

Current Readings

Temperature: ${temperatureF.toFixed(1)}°F
Day: ${currentDay} of ${INCUBATION_CONFIG.totalDays}
Phase: ${isLockdown ? \"Lockdown\" : \"Incubation\"}

\n Quail Egg Incubator Monitor\n

\n `,\n });\n\n // Record the alert\n await recordAlert(alert.type, alert.level, temperatureF, humidity, alert.message);\n }\n }\n}\n\n/**\n * Check temperature (and humidity, if available) against brooder thresholds and send rate-limited email alerts.\n * `humidity` is null when the reading comes from a temperature-only sensor (NanoTag).\n */\nexport async function checkAndSendBrooderAlerts(\n temperatureF: number,\n humidity: number | null,\n chickAgeDays: number\n): Promise {\n const { alerts: alertConfig, humidity: humidityTarget, humidityAlertOffset } = BROODER_CONFIG;\n const thresholds = getTemperatureThresholds(chickAgeDays);\n const targetTemp = getTargetTemperature(chickAgeDays);\n const week = Math.ceil(chickAgeDays / 7);\n\n const alertsToSend: AlertToSend[] = [];\n\n // Temperature checks\n if (temperatureF < thresholds.criticalMin) {\n alertsToSend.push({\n level: \"critical\",\n type: \"temperature\",\n message: `CRITICAL: Brooder temperature too LOW at ${temperatureF.toFixed(1)}°F (below ${thresholds.criticalMin}°F). Chicks at risk of hypothermia!`,\n });\n } else if (temperatureF > thresholds.criticalMax) {\n alertsToSend.push({\n level: \"critical\",\n type: \"temperature\",\n message: `CRITICAL: Brooder temperature too HIGH at ${temperatureF.toFixed(1)}°F (above ${thresholds.criticalMax}°F). Chicks at risk of overheating!`,\n });\n } else if (temperatureF < thresholds.warningMin) {\n alertsToSend.push({\n level: \"warning\",\n type: \"temperature\",\n message: `WARNING: Brooder temperature low at ${temperatureF.toFixed(1)}°F. Target for Week ${week}: ${targetTemp.min}-${targetTemp.max}°F`,\n });\n } else if (temperatureF > thresholds.warningMax) {\n alertsToSend.push({\n level: \"warning\",\n type: \"temperature\",\n message: `WARNING: Brooder temperature high at ${temperatureF.toFixed(1)}°F. Target for Week ${week}: ${targetTemp.min}-${targetTemp.max}°F`,\n });\n }\n\n // Humidity warnings (relaxed) — only when humidity is available\n if (humidity !== null) {\n if (humidity < humidityTarget.min - humidityAlertOffset) {\n alertsToSend.push({\n level: \"warning\",\n type: \"humidity\",\n message: `WARNING: Brooder humidity very low at ${humidity.toFixed(1)}% (target: ${humidityTarget.min}-${humidityTarget.max}%)`,\n });\n } else if (humidity > humidityTarget.max + humidityAlertOffset) {\n alertsToSend.push({\n level: \"warning\",\n type: \"humidity\",\n message: `WARNING: Brooder humidity very high at ${humidity.toFixed(1)}% (target: ${humidityTarget.min}-${humidityTarget.max}%)`,\n });\n }\n }\n\n const lines = readingLines(temperatureF, humidity);\n\n // Process alerts with rate limiting\n for (const alert of alertsToSend) {\n const cooldown =\n alert.level === \"critical\"\n ? alertConfig.criticalCooldown\n : alertConfig.warningCooldown;\n\n const lastSent = await getLastAlertTime(alert.type, alert.level);\n const now = Date.now();\n\n if (!lastSent || now - lastSent.getTime() >= cooldown) {\n // Send email\n await email({\n subject: `[Brooder ${alert.level.toUpperCase()}] Week ${week}, Day ${chickAgeDays} - ${alert.type}`,\n text: `${alert.message}\n\nCurrent Readings:\n- Temperature: ${temperatureF.toFixed(1)}°F${lines.text}\n- Chick Age: Week ${week}, Day ${chickAgeDays}\n- Target Temp: ${targetTemp.min}-${targetTemp.max}°F\n\n---\nQuail Chick Brooder Monitor`,\n html: `\n

\n ${alert.level === \"critical\" ? \"🚨\" : \"⚠️\"} Brooder ${alert.level.toUpperCase()} Alert\n

${alert.message}

Current Readings

Temperature: ${temperatureF.toFixed(1)}°F
Chick Age: Week ${week}, Day ${chickAgeDays}
Target Temp: ${targetTemp.min}-${targetTemp.max}°F

\n Quail Chick Brooder Monitor\n

\n `,\n });\n\n // Record the alert\n await recordAlert(alert.type, alert.level, temperatureF, humidity, alert.message);\n }\n }\n}\n",[],[184,440,466],"317da3cc-f5bc-11f0-9ddc-42dde27851f2",["D",1768884908132],[215,216,217,218,219],[184,440],"cef7cf3c-5455-4666-a12a-45769004195e","webhook.ts","31ee8a74-f5bc-11f0-97e8-42dde27851f2","3163c466-f5bc-11f0-9a10-42dde27851f2",282,["D",1783460626946],"// ChirpStack webhook handler — NanoThings NanoTag (temperature-only) is the sole sensor\nimport { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport {\n decodeNanoTagPayload,\n validateNanoTagPayload,\n} from \"../services/decoder.ts\";\nimport { insertNanoTagReading, setConfig } from \"../database/queries.ts\";\nimport { checkAndSendAlerts, checkAndSendBrooderAlerts } from \"../services/alerts.ts\";\nimport {\n calculateIncubationStatus,\n getCurrentMode,\n getHatchDate,\n} from \"../services/incubation.ts\";\nimport { getChickAgeDays, evaluateOutdoorReadiness } from \"../services/brooder.ts\";\nimport { fetchWeatherForecast } from \"../services/weather.ts\";\nimport { celsiusToFahrenheit, CALIBRATION, DEVICE_EUIS } from \"../../shared/constants.ts\";\nimport type { ChirpStackUplinkEvent } from \"../../shared/types.ts\";\n\nexport const webhookRouter = new Hono();\n\n// ChirpStack sends event type as query parameter\nwebhookRouter.post(\"/chirpstack\", async (c) => {\n const event = c.req.query(\"event\");\n\n // Only process uplink events\n if (event !== \"up\") {\n return c.json({ status: \"ignored\", event, message: \"Only uplink events are processed\" });\n }\n\n try {\n const payload: ChirpStackUplinkEvent = await c.req.json();\n\n // Validate required fields\n if (!payload.data) {\n return c.json({ status: \"error\", message: \"Missing payload data\" }, 400);\n }\n if (!payload.deviceInfo?.devEui) {\n return c.json({ status: \"error\", message: \"Missing device EUI\" }, 400);\n }\n\n const devEui = payload.deviceInfo.devEui.toLowerCase();\n const rxInfo = payload.rxInfo?.[0];\n\n // Only the configured NanoTag is processed; anything else is ignored.\n if (devEui !== DEVICE_EUIS.NANOTAG.toLowerCase()) {\n console.warn(`Ignoring uplink from unrecognized device: ${devEui}`);\n return c.json({\n status: \"ignored\",\n devEui,\n message: \"Uplink is not from the configured NanoTag sensor\",\n });\n }\n\n return await handleNanoTagUplink(c, payload, rxInfo);\n } catch (error) {\n console.error(\"Webhook error:\", error);\n return c.json(\n {\n status: \"error\",\n message: error instanceof Error ? error.message : String(error),\n },\n 500\n );\n }\n});\n\n// --- NanoTag Handler ---\nasync function handleNanoTagUplink(c: any, payload: ChirpStackUplinkEvent, rxInfo: any) {\n const fPort = payload.fPort;\n const decoded = decodeNanoTagPayload(payload.data, fPort);\n\n const validation = validateNanoTagPayload(decoded);\n if (!validation.valid) {\n console.warn(\"NanoTag payload validation warnings:\", validation.errors);\n }\n\n // Battery-status ports carry no temperature. Persist the latest battery voltage\n // (for display) and stop — these packets are not stored as temperature readings.\n if (decoded.temperatureCelsius === null) {\n if (decoded.batteryVoltage != null) {\n await setConfig(\"nanotag_battery_v\", decoded.batteryVoltage.toString());\n await setConfig(\"nanotag_battery_at\", payload.time || new Date().toISOString());\n }\n return c.json({\n status: \"success\",\n sensor: \"NanoTag\",\n message: \"Battery status or invalid temperature reading\",\n batteryVoltage: decoded.batteryVoltage,\n fPort,\n });\n }\n\n const temperatureF = celsiusToFahrenheit(decoded.temperatureCelsius);\n\n await insertNanoTagReading({\n deviceEui: payload.deviceInfo.devEui,\n timestamp: payload.time || new Date().toISOString(),\n temperatureC: decoded.temperatureCelsius,\n temperatureF: temperatureF,\n batteryVoltage: decoded.batteryVoltage,\n fport: fPort,\n rssi: rxInfo?.rssi,\n snr: rxInfo?.snr,\n rawPayload: payload.data,\n });\n\n // Temperature alerts using calibrated NanoTag temperature.\n // Humidity is null — the NanoTag has no humidity sensor, so humidity alerts are skipped.\n const calibratedTempF = temperatureF + CALIBRATION.nanotagTemperatureF;\n const mode = await getCurrentMode();\n\n if (mode === \"brooder\") {\n const hatchDate = await getHatchDate();\n if (hatchDate) {\n const chickAgeDays = getChickAgeDays(hatchDate);\n\n // Skip alerts if chicks are ready for outdoors\n const forecast = await fetchWeatherForecast();\n const outdoorReadiness = evaluateOutdoorReadiness(chickAgeDays, forecast);\n if (!outdoorReadiness.isReady) {\n await checkAndSendBrooderAlerts(calibratedTempF, null, chickAgeDays);\n }\n\n return c.json({\n status: \"success\",\n sensor: \"NanoTag\",\n mode: \"brooder\",\n decoded: {\n temperatureC: decoded.temperatureCelsius.toFixed(2),\n temperatureF_raw: temperatureF.toFixed(1),\n temperatureF_calibrated: calibratedTempF.toFixed(1),\n },\n chickAgeDays,\n chickAgeWeek: Math.ceil(chickAgeDays / 7),\n fPort,\n });\n }\n }\n\n // Incubation mode (default)\n const status = calculateIncubationStatus();\n await checkAndSendAlerts(calibratedTempF, null, status.currentDay);\n\n return c.json({\n status: \"success\",\n sensor: \"NanoTag\",\n mode: \"incubation\",\n decoded: {\n temperatureC: decoded.temperatureCelsius.toFixed(2),\n temperatureF_raw: temperatureF.toFixed(1),\n temperatureF_calibrated: calibratedTempF.toFixed(1),\n },\n day: status.currentDay,\n phase: status.phase,\n fPort,\n });\n}\n\n// Health check endpoint\nwebhookRouter.get(\"/health\", (c) => {\n return c.json({ status: \"ok\", timestamp: new Date().toISOString() });\n});\n",[],[184,486,478],"routes","0d3714ee-7898-4942-9c4f-e730a07a6b24",["D",1783460632730],[],[184,486,33],"3163c358-f5bc-11f0-9a10-42dde27851f2",8,["D",1768884907969],[212,213],[184,486],"4dcb6354-7cbc-4f2b-b836-4339c908bed2","queries.ts","31d98cb4-f5bc-11f0-aedd-42dde27851f2","314929f8-f5bc-11f0-9ddc-42dde27851f2",278,["D",1783460604397],"// Database query functions for incubator tracking (per-val database)\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { TABLES } from \"../../shared/constants.ts\";\nimport type { NanoTagReading } from \"../../shared/types.ts\";\n\ninterface AlertRecord {\n id: number;\n alertType: string;\n alertLevel: string;\n temperatureF: number | null;\n humidity: number | null;\n message: string;\n sentAt: string;\n}\n\nexport async function getLastAlertTime(alertType: string, alertLevel: string): Promise {\n const result = await sqlite.execute(\n `\n SELECT sent_at FROM ${TABLES.alerts}\n WHERE alert_type = ? AND alert_level = ?\n ORDER BY sent_at DESC LIMIT 1\n `,\n [alertType, alertLevel]\n );\n\n if (result.rows.length === 0) return null;\n return new Date((result.rows[0] as Record).sent_at as string);\n}\n\nexport async function recordAlert(\n alertType: string,\n alertLevel: string,\n tempF: number,\n humidity: number | null,\n message: string\n): Promise {\n await sqlite.execute(\n `\n INSERT INTO ${TABLES.alerts} (alert_type, alert_level, temperature_f, humidity, message)\n VALUES (?, ?, ?, ?, ?)\n `,\n [alertType, alertLevel, tempF, humidity, message]\n );\n}\n\nexport async function getAlertHistory(limit: number = 50): Promise {\n const result = await sqlite.execute(\n `\n SELECT * FROM ${TABLES.alerts}\n ORDER BY sent_at DESC\n LIMIT ?\n `,\n [limit]\n );\n\n return result.rows.map((row) => {\n const r = row as Record;\n return {\n id: r.id as number,\n alertType: r.alert_type as string,\n alertLevel: r.alert_level as string,\n temperatureF: r.temperature_f as number | null,\n humidity: r.humidity as number | null,\n message: r.message as string,\n sentAt: r.sent_at as string,\n };\n });\n}\n\nexport async function getConfig(key: string): Promise {\n const result = await sqlite.execute(\n `\n SELECT value FROM ${TABLES.config} WHERE key = ?\n `,\n [key]\n );\n\n if (result.rows.length === 0) return null;\n return (result.rows[0] as Record).value as string;\n}\n\nexport async function setConfig(key: string, value: string): Promise {\n await sqlite.execute(\n `\n INSERT OR REPLACE INTO ${TABLES.config} (key, value, updated_at)\n VALUES (?, ?, CURRENT_TIMESTAMP)\n `,\n [key, value]\n );\n}\n\n// --- NanoTag Query Functions ---\n\ninterface InsertNanoTagReadingParams {\n deviceEui: string;\n timestamp: string;\n temperatureC: number;\n temperatureF: number;\n batteryVoltage?: number;\n fport: number;\n rssi?: number;\n snr?: number;\n rawPayload?: string;\n}\n\nexport async function insertNanoTagReading(params: InsertNanoTagReadingParams): Promise {\n const result = await sqlite.execute(\n `\n INSERT INTO ${TABLES.nanotagReadings}\n (device_eui, timestamp, temperature_c, temperature_f, battery_voltage, fport, rssi, snr, raw_payload)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)\n `,\n [\n params.deviceEui,\n params.timestamp,\n params.temperatureC,\n params.temperatureF,\n params.batteryVoltage ?? null,\n params.fport,\n params.rssi ?? null,\n params.snr ?? null,\n params.rawPayload ?? null,\n ]\n );\n return result.lastInsertRowid as number;\n}\n\nfunction rowToNanoTagReading(row: Record): NanoTagReading {\n return {\n id: row.id as number,\n deviceEui: row.device_eui as string,\n timestamp: row.timestamp as string,\n temperatureC: row.temperature_c as number,\n temperatureF: row.temperature_f as number,\n batteryVoltage: row.battery_voltage as number | null,\n fport: row.fport as number,\n rssi: row.rssi as number | undefined,\n snr: row.snr as number | undefined,\n };\n}\n\nexport async function getLatestNanoTagReading(): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${TABLES.nanotagReadings}\n ORDER BY timestamp DESC\n LIMIT 1\n `);\n\n if (result.rows.length === 0) return null;\n return rowToNanoTagReading(result.rows[0] as Record);\n}\n\nexport async function getRecentNanoTagReadings(minutes: number): Promise {\n const cutoff = new Date(Date.now() - minutes * 60 * 1000).toISOString();\n\n const result = await sqlite.execute(\n `\n SELECT * FROM ${TABLES.nanotagReadings}\n WHERE timestamp >= ?\n ORDER BY timestamp ASC\n `,\n [cutoff]\n );\n\n return result.rows.map((row) => rowToNanoTagReading(row as Record));\n}\n\n// Latest battery voltage seen from a NanoTag battery-status packet.\n// Battery rides on separate fPorts (not temperature packets), so it's persisted\n// in the config table by the webhook and read back here for display.\nexport async function getLatestNanoTagBatteryVoltage(): Promise {\n const v = await getConfig(\"nanotag_battery_v\");\n if (v == null) return null;\n const n = parseFloat(v);\n return Number.isFinite(n) ? n : null;\n}\n",[],[184,505,497],"database","f0702c81-c627-492e-a69f-7d21333c13b0","migrations.ts","31e3a032-f5bc-11f0-b5fb-42dde27851f2",241,["D",1783399227206],"// SQLite schema definitions for incubator tracking (per-val database)\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { TABLES, INCUBATION_CONFIG } from \"../../shared/constants.ts\";\n\nexport async function runMigrations(): Promise {\n // NanoTag sensor readings (temperature only) — the sole sensor\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.nanotagReadings} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n device_eui TEXT NOT NULL,\n timestamp TEXT NOT NULL,\n temperature_c REAL NOT NULL,\n temperature_f REAL NOT NULL,\n battery_voltage REAL,\n fport INTEGER NOT NULL,\n rssi INTEGER,\n snr REAL,\n raw_payload TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Create index for NanoTag time-range queries\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_nanotag_readings_timestamp\n ON ${TABLES.nanotagReadings}(timestamp DESC)\n `);\n\n // Alert history table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.alerts} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n alert_type TEXT NOT NULL,\n alert_level TEXT NOT NULL,\n temperature_f REAL,\n humidity REAL,\n message TEXT NOT NULL,\n sent_at TEXT DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Configuration table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.config} (\n key TEXT PRIMARY KEY,\n value TEXT NOT NULL,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Set incubation start date if not exists (record-keeping; day calc uses INCUBATION_CONFIG)\n await sqlite.execute(\n `\n INSERT OR IGNORE INTO ${TABLES.config} (key, value)\n VALUES ('incubation_start_date', ?)\n `,\n [INCUBATION_CONFIG.startDate.toISOString()]\n );\n}\n",[],[184,505,507],"31492868-f5bc-11f0-9ddc-42dde27851f2",7,["D",1768884907798],[209,210],[184,505],["D",1768884907253],[208,211,214,220],[184],"c77bb990-03db-11f1-9e85-42dde27851f2","settings.local.json","31df6a30-f5bc-11f0-97e8-42dde27851f2",233,["D",1770437790429],20,"{\n \"permissions\": {\n \"allow\": [\n \"WebSearch\",\n \"WebFetch(domain:www.chirpstack.io)\",\n \"WebFetch(domain:gist.github.com)\",\n \"Bash(vt push)\",\n \"Bash(curl:*)\",\n \"Bash(vt status:*)\",\n \"Bash(vt --help:*)\",\n \"Bash(vt browse:*)\",\n \"WebFetch(domain:www.val.town)\",\n \"WebFetch(domain:docs.val.town)\",\n \"Bash(vt tail:*)\",\n \"Bash(timeout 10 vt tail:*)\",\n \"Bash(python3:*)\",\n \"Bash(deno check:*)\",\n \"Bash(vt pull:*)\",\n \"Bash(claude mcp add:*)\",\n \"Bash(vt list:*)\",\n \"WebFetch(domain:docs.rakwireless.com)\",\n \"WebFetch(domain:forum.rakwireless.com)\",\n \"WebFetch(domain:learn.rakwireless.com)\",\n \"WebFetch(domain:gist.githubusercontent.com)\",\n \"Skill(ralph-loop:ralph-loop)\",\n \"WebFetch(domain:web.archive.org)\",\n \"WebFetch(domain:github.com)\",\n \"WebFetch(domain:raw.githubusercontent.com)\",\n \"Bash(vt watch:*)\",\n \"Bash(~/.deno/bin/vt dev:*)\",\n \"WebFetch(domain:jhiller--32167624f5bc11f0947042dde27851f2.web.val.run)\",\n \"Bash(~/.deno/bin/vt push:*)\"\n ]\n }\n}\n",[],[190,523],["D",1768884907128],[206],[190],["D",1768883246417],["D",1789527031073],{"_100":99,"_107":103},{"_100":99,"_101":-5,"_102":103,"_18":55,"_104":105,"_106":25},{"_13":89,"_32":90,"_44":43,"_91":45,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":46,"_98":99},"ctx",{"_82":-5,"_127":572,"_573":574,"_575":576,"_577":25,"_578":25,"_579":25,"_580":59,"_581":-5,"_582":-7,"_583":-7,"_584":63,"_585":25,"_586":25,"_587":-5,"_588":25,"_589":25,"_590":25,"_591":-5},"ENV",{"_543":544,"_545":546,"_547":90,"_548":549,"_550":551,"_552":553,"_554":555,"_556":557,"_558":559,"_560":561,"_562":563,"_564":565,"_566":567,"_568":569,"_570":571},"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"]

Diff · v283