[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_480":481,"_482":483},"routes/_app.x.$handle.$name",{"_97":96,"_31":43,"_105":87,"_26":106,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":24,"_120":121,"_122":56,"_123":-5,"_124":-5,"_125":126},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_31":43,"_36":44,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":-5,"_51":-5,"_18":52,"_53":54,"_55":56,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":68,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":24},"version",197,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":20,"_34":35,"_36":37,"_38":14,"_39":40,"_23":24},"previous","deleted",false,"deletedHere","path","frontend/manifest.json","latestPath","fileId","6d528f88-f7ed-11f0-8a0d-42dde27851f2","name","manifest.json","fileType","content","{\n \"name\": \"Quail Incubator Monitor\",\n \"short_name\": \"Incubator\",\n \"description\": \"Monitor temperature and humidity for quail egg incubation\",\n \"start_url\": \"/\",\n \"display\": \"standalone\",\n \"background_color\": \"#f8fafc\",\n \"theme_color\": \"#3b82f6\",\n \"icons\": [\n {\n \"src\": \"/frontend/icons/icon-192.svg\",\n \"sizes\": \"192x192\",\n \"type\": \"image/svg+xml\"\n },\n {\n \"src\": \"/frontend/icons/icon-512.svg\",\n \"sizes\": \"512x512\",\n \"type\": \"image/svg+xml\"\n }\n ]\n}\n","createdAt",["D",1769125956185],"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",{"_97":96,"_104":100},"org",{"_97":96,"_98":-5,"_99":100,"_18":52,"_101":102,"_103":24},"branch",{"_13":86,"_31":87,"_41":40,"_88":42,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":43,"_95":96},"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",{"_41":42,"_31":43,"_36":475,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":-5,"_51":-5,"_18":52,"_53":54,"_55":56,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":476,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":477,"_81":478,"_83":479,"_85":24},"tree",[202,204,216,229,233,234,235,236],"files",[202,203,204,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],"counts",{"_191":60,"_192":193,"_194":60,"_195":196,"_197":198},"contents",[127,128,129,130,131,132,133,134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":185,"_31":186,"_29":187,"_138":-5,"_39":40,"_38":188,"_140":56,"_36":189,"_13":60,"_33":171,"_34":-5,"_23":24,"_143":-5,"_26":190},{"_41":179,"_31":180,"_29":181,"_138":-5,"_39":40,"_38":182,"_140":56,"_36":183,"_13":60,"_33":171,"_34":-5,"_23":24,"_143":-5,"_26":184},{"_41":173,"_31":174,"_29":175,"_138":-5,"_39":40,"_38":176,"_140":56,"_36":177,"_13":60,"_33":171,"_34":-5,"_23":24,"_143":-5,"_26":178},{"_41":166,"_31":167,"_29":168,"_138":-5,"_39":40,"_38":169,"_140":56,"_36":170,"_13":60,"_33":171,"_34":-5,"_23":24,"_143":-5,"_26":172},{"_41":159,"_31":160,"_29":161,"_138":-5,"_39":40,"_38":162,"_140":56,"_36":163,"_13":60,"_33":20,"_34":164,"_23":24,"_143":-5,"_26":165},{"_41":152,"_31":153,"_29":154,"_138":-5,"_39":40,"_38":155,"_140":56,"_36":156,"_13":60,"_33":20,"_34":157,"_23":24,"_143":-5,"_26":158},{"_41":145,"_31":146,"_29":147,"_138":-5,"_39":40,"_38":148,"_140":24,"_36":149,"_13":60,"_33":20,"_34":150,"_23":24,"_143":-5,"_26":151},{"_41":135,"_31":136,"_29":137,"_138":-5,"_39":40,"_38":139,"_140":56,"_36":141,"_13":60,"_33":20,"_34":142,"_23":24,"_143":-5,"_26":144},"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",[136],"81f6ddd6-f752-11f0-8d59-42dde27851f2","CLAUDE.md","81f6de80-f752-11f0-8d59-42dde27851f2",187,["D",1769059418801],"# 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/humidity data from LoRaWAN sensors (RAK7204 and NanoThings NanoTag) via ChirpStack webhooks, stores readings in SQLite, sends email alerts, and displays a React dashboard.\n\n**Live URL:** https://jhiller--32167624f5bc11f0947042dde27851f2.web.val.run\n\n## Development Commands\n\n```bash\n# Start local development with auto-sync to Val Town\nvt 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: Val Town's hosted SQLite via `https://esm.town/v/stevekrouse/sqlite`\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 routes by DevEUI: RAK7204 (default) or NanoTag (`9c65fafffe02607a`)\n3. Payloads decoded: RAK7204 uses Cayenne LPP, NanoTag uses port-based format\n4. Readings stored in separate SQLite tables per sensor type\n5. RAK7204 readings trigger alert checks (NanoTag is temperature-only, no alerts)\n6. Dashboard polls `/api/status` and `/api/readings` every 60 seconds\n\n### Sensor Calibration\nDefined in `shared/constants.ts`:\n- RAK7204: -2°F offset\n- NanoTag: +1°F offset\n- Dashboard displays calibrated values; alerts use calibrated RAK7204 temperature\n\n### Incubation Logic\n- 17-day Coturnix quail incubation starting from configured date\n- Lockdown phase begins day 15 (higher humidity target)\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\n### Frontend\n- React 18.2.0 with TailwindCSS (twind)\n- Initial data injected into HTML via `window.__INITIAL_DATA__` to avoid round-trips\n- Chart.js for historical temperature/humidity visualization\n\n## Key Conventions\n\n### Imports\n- Use `https://esm.sh` for npm packages (works in both Deno backend and browser)\n- Pin React to 18.2.0: `https://esm.sh/react@18.2.0`\n- Start React files with `/** @jsxImportSource https://esm.sh/react@18.2.0 */`\n\n### Shared Code\n- `shared/` must work in both frontend and backend\n- Cannot use `Deno` namespace in shared code\n- Types and constants live here\n\n### Database\n- Table names include version suffix (e.g., `incubator_readings_v1`)\n- Migrations run lazily on first request\n- To change schema: create new table with incremented version, don't ALTER\n\n### Val Town Specifics\n- Use `Response` constructor for redirects (not `Response.redirect`)\n- Avoid `alert()`, `prompt()`, `confirm()` browser APIs\n- Environment variables: `Deno.env.get('KEY')`\n",[146],"3224dd4a-f5bc-11f0-81d9-42dde27851f2","AGENTS.md","3224de1c-f5bc-11f0-81d9-42dde27851f2",32,["D",1768884909201],"You are an advanced assistant specialized in generating Val Town code.\n\n## Core Guidelines\n\n- Ask clarifying questions when requirements are ambiguous\n- Provide complete, functional solutions rather than skeleton implementations\n- Test your logic against edge cases before presenting the final solution\n- Ensure all code follows Val Town's specific platform requirements\n- If a section of code that you're working on is getting too complex, consider refactoring it into subcomponents\n\n## Code Standards\n\n- Generate code in TypeScript or TSX\n- Add appropriate TypeScript types and interfaces for all data structures\n- Prefer official SDKs or libraries than writing API calls directly\n- Ask the user to supply API or library documentation if you are at all unsure about it\n- **Never bake in secrets into the code** - always use environment variables\n- Include comments explaining complex logic (avoid commenting obvious operations)\n- Follow modern ES6+ conventions and functional programming practices if possible\n\n## Types of triggers\n\n### 1. HTTP Trigger\n\n- Create web APIs and endpoints\n- Handle HTTP requests and responses\n- Example structure:\n\n```ts\nexport default async function (req: Request) {\n return new Response(\"Hello World\");\n}\n```\n\nFiles that are HTTP triggers have http in their name like `foobar.http.tsx`\n\n### 2. Cron Triggers\n\n- Run on a schedule\n- Use cron expressions for timing\n- Example structure:\n\n```ts\nexport default async function () {\n // Scheduled task code\n}\n```\n\nFiles that are Cron triggers have cron in their name like `foobar.cron.tsx`\n\n### 3. Email Triggers\n\n- Process incoming emails\n- Handle email-based workflows\n- Example structure:\n\n```ts\nexport default async function (email: Email) {\n // Process email\n}\n```\n\nFiles that are Email triggers have email in their name like `foobar.email.tsx`\n\n\n## Val Town Standard Libraries\n\nVal Town provides several hosted services and utility functions.\n\n### Blob Storage\n\n```ts\nimport { blob } from \"https://esm.town/v/std/blob\";\nawait blob.setJSON(\"myKey\", { hello: \"world\" });\nlet blobDemo = await blob.getJSON(\"myKey\");\nlet appKeys = await blob.list(\"app_\");\nawait blob.delete(\"myKey\");\n```\n\n### SQLite\n\n```ts\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nconst TABLE_NAME = 'todo_app_users_2';\n// Create table - do this before usage and change table name when modifying schema\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL\n)`);\n// Query data\nconst result = await sqlite.execute(`SELECT * FROM ${TABLE_NAME} WHERE id = ?`, [1]);\n```\n\nNote: When changing a SQLite table's schema, change the table's name (e.g., add _2 or _3) to create a fresh table.\n\n### OpenAI\n\n```ts\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nconst openai = new OpenAI();\nconst completion = await openai.chat.completions.create({\n messages: [\n { role: \"user\", content: \"Say hello in a creative way\" },\n ],\n model: \"gpt-4o-mini\",\n max_tokens: 30,\n});\n```\n\n### Email\n\n```ts\nimport { email } from \"https://esm.town/v/std/email\";\n// By default emails the owner of the val\nawait email({ \n subject: \"Hi\", \n text: \"Hi\", \n html: \"

Hi

\"\n});\n```\n\n## Val Town Utility Functions\n\nVal Town provides several utility functions to help with common project tasks.\n\n### Importing Utilities\n\nAlways import utilities with version pins to avoid breaking changes:\n\n```ts\nimport { parseProject, readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n```\n\n### Available Utilities\n\n\n#### **serveFile** - Serve project files with proper content types\n\nFor example, in Hono:\n\n```ts\n// serve all files in 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\n#### **readFile** - Read files from within the project:\n\n```ts\n// Read a file from the project\nconst fileContent = await readFile(\"/frontend/index.html\", import.meta.url);\n```\n\n#### **listFiles** - List all files in the project\n\n```ts\nconst files = await listFiles(import.meta.url);\n```\n\n#### **parseProject** - Extract information about the current project from import.meta.url\n\nThis is useful for including info for linking back to a val, ie in \"view source\" urls:\n\n```ts\nconst projectVal = parseProject(import.meta.url);\nconsole.log(projectVal.username); // Owner of the project\nconsole.log(projectVal.name); // Project name\nconsole.log(projectVal.version); // Version number\nconsole.log(projectVal.branch); // Branch name\nconsole.log(projectVal.links.self.project); // URL to the project page\n```\n\nHowever, it's *extremely importing* to note that `parseProject` and other Standard Library utilities ONLY RUN ON THE SERVER.\nIf you need access to this data on the client, run it in the server and pass it to the client by splicing it into the HTML page\nor by making an API request for it.\n\n## Val Town Platform Specifics\n\n- **Redirects:** Use `return new Response(null, { status: 302, headers: { Location: \"/place/to/redirect\" }})` instead of `Response.redirect` which is broken\n- **Images:** Avoid external images or base64 images. Use emojis, unicode symbols, or icon fonts/libraries instead\n- **AI Image:** To inline generate an AI image use: `

`\n- **Storage:** DO NOT use the Deno KV module for storage\n- **Browser APIs:** DO NOT use the `alert()`, `prompt()`, or `confirm()` methods\n- **Weather Data:** Use open-meteo for weather data (doesn't require API keys) unless otherwise specified\n- **View Source:** Add a view source link by importing & using `import.meta.url.replace(\"ems.sh\", \"val.town)\"` (or passing this data to the client) and include `target=\"_top\"` attribute\n- **Error Debugging:** Add `` to HTML to capture client-side errors\n- **Error Handling:** Only use try...catch when there's a clear local resolution; Avoid catches that merely log or return 500s. Let errors bubble up with full context\n- **Environment Variables:** Use `Deno.env.get('keyname')` when you need to, but generally prefer APIs that don't require keys\n- **Imports:** Use `https://esm.sh` for npm and Deno dependencies to ensure compatibility on server and browser\n- **Storage Strategy:** Only use backend storage if explicitly required; prefer simple static client-side sites\n- **React Configuration:** When using React libraries, pin versions with `?deps=react@18.2.0,react-dom@18.2.0` and start the file with `/** @jsxImportSource https://esm.sh/react@18.2.0 */`\n- Ensure all React dependencies and sub-dependencies are pinned to the same version\n- **Styling:** Default to using TailwindCSS via `` unless otherwise specified\n\n## Project Structure and Design Patterns\n\n### Recommended Directory Structure\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Schema definitions\n│ │ ├── queries.ts # DB query functions\n│ │ └── README.md\n│ └── routes/ # Route modules\n│ ├── [route].ts\n│ └── static.ts # Static file serving\n│ ├── index.ts # Main entry point\n│ └── README.md\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx\n│ │ └── [Component].tsx\n│ ├── favicon.svg\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # Frontend JS entry point\n│ ├── README.md\n│ └── style.css\n├── README.md\n└── shared/\n ├── README.md\n └── utils.ts # Shared types and functions\n```\n\n### Backend (Hono) Best Practices\n\n- Hono is the recommended API framework\n- Main entry point should be `backend/index.ts`\n- **Static asset serving:** Use the utility functions to read and serve project files:\n ```ts\n import { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n \n // serve all files in frontend/ and shared/\n app.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\n app.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n \n // For index.html, often you'll want to bootstrap with initial data\n app.get(\"/\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject data to avoid extra round-trips\n const initialData = await fetchInitialData();\n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n });\n ```\n- Create RESTful API routes for CRUD operations\n- Always include this snippet at the top-level Hono app to re-throwing errors to see full stack traces:\n ```ts\n // Unwrap Hono errors to see original error details\n app.onError((err, c) => {\n throw err;\n });\n ```\n\n### Database Patterns\n- Run migrations on startup or comment out for performance\n- Change table names when modifying schemas rather than altering\n- Export clear query functions with proper TypeScript typing\n\n## Common Gotchas and Solutions\n\n1. **Environment Limitations:** \n - Val Town runs on Deno in a serverless context, not Node.js\n - Code in `shared/` must work in both frontend and backend environments\n - Cannot use `Deno` keyword in shared code\n - Use `https://esm.sh` for imports that work in both environments\n\n2. **SQLite Peculiarities:**\n - Limited support for ALTER TABLE operations\n - Create new tables with updated schemas and copy data when needed\n - Always run table creation before querying\n\n3. **React Configuration:**\n - All React dependencies must be pinned to 18.2.0\n - Always include `@jsxImportSource https://esm.sh/react@18.2.0` at the top of React files\n - Rendering issues often come from mismatched React versions\n\n4. **File Handling:**\n - Val Town only supports text files, not binary\n - Use the provided utilities to read files across branches and forks\n - For files in the project, use `readFile` helpers\n\n5. **API Design:**\n - `fetch` handler is the entry point for HTTP vals\n - Run the Hono app with `export default app.fetch // This is the entry point for HTTP vals`\n\n",[153],"322a1fbc-f5bc-11f0-97e8-42dde27851f2",".vtignore","322a2084-f5bc-11f0-97e8-42dde27851f2",33,["D",1768884909238],".git\n.vscode\n.cursorrules\n.DS_Store\nnode_modules\nvendor",[160],"3111a35c-f5bc-11f0-9a10-42dde27851f2","shared","3111a438-f5bc-11f0-9a10-42dde27851f2",5,["D",1768884907433],"directory",[167],"30c1433a-f5bc-11f0-90d9-42dde27851f2","frontend","30c14402-f5bc-11f0-90d9-42dde27851f2",2,["D",1768884906906],[174],"30f61524-f5bc-11f0-ab7f-42dde27851f2","backend","30f615c4-f5bc-11f0-ab7f-42dde27851f2",4,["D",1768884907253],[180],"30e42e72-f5bc-11f0-ab7f-42dde27851f2",".claude","30e42f3a-f5bc-11f0-ab7f-42dde27851f2",3,["D",1768884907128],[186],"pulls","branches",1,"forks","envVars",{"_199":193,"_201":60},"connections",{"_199":60,"_200":60},"count","unfilledCount","emptyCount",{"_41":185,"_31":186,"_29":187,"_138":-5,"_39":40,"_38":188,"_140":56,"_36":472,"_13":60,"_33":171,"_34":-5,"_23":24,"_143":-5,"_238":473,"_26":474},{"_41":464,"_31":465,"_29":466,"_138":187,"_39":40,"_38":467,"_140":24,"_36":468,"_13":272,"_33":20,"_34":469,"_23":24,"_143":-5,"_238":470,"_26":471},{"_41":179,"_31":180,"_29":181,"_138":-5,"_39":40,"_38":182,"_140":56,"_36":461,"_13":60,"_33":171,"_34":-5,"_23":24,"_143":-5,"_238":462,"_26":463},{"_41":457,"_31":448,"_29":442,"_138":181,"_39":40,"_38":379,"_140":56,"_36":458,"_13":60,"_33":171,"_34":-5,"_23":24,"_143":-5,"_238":459,"_26":460},{"_41":449,"_31":450,"_29":451,"_138":442,"_39":40,"_38":452,"_140":24,"_36":453,"_13":193,"_33":255,"_34":454,"_23":24,"_143":-5,"_238":455,"_26":456},{"_41":439,"_31":440,"_29":441,"_138":442,"_39":40,"_38":443,"_140":24,"_36":444,"_13":182,"_33":255,"_34":445,"_23":24,"_143":-5,"_238":446,"_26":447},{"_41":435,"_31":426,"_29":420,"_138":181,"_39":40,"_38":400,"_140":56,"_36":436,"_13":60,"_33":171,"_34":-5,"_23":24,"_143":-5,"_238":437,"_26":438},{"_41":427,"_31":428,"_29":429,"_138":420,"_39":40,"_38":430,"_140":24,"_36":431,"_13":347,"_33":255,"_34":432,"_23":24,"_143":-5,"_238":433,"_26":434},{"_41":417,"_31":418,"_29":419,"_138":420,"_39":40,"_38":421,"_140":24,"_36":422,"_13":322,"_33":255,"_34":423,"_23":24,"_143":-5,"_238":424,"_26":425},{"_41":412,"_31":394,"_29":388,"_138":181,"_39":40,"_38":413,"_140":56,"_36":414,"_13":60,"_33":171,"_34":-5,"_23":24,"_143":-5,"_238":415,"_26":416},{"_41":404,"_31":405,"_29":406,"_138":388,"_39":40,"_38":407,"_140":24,"_36":408,"_13":60,"_33":255,"_34":409,"_23":24,"_143":-5,"_238":410,"_26":411},{"_41":395,"_31":396,"_29":397,"_138":388,"_39":40,"_38":398,"_140":24,"_36":399,"_13":400,"_33":255,"_34":401,"_23":24,"_143":-5,"_238":402,"_26":403},{"_41":385,"_31":386,"_29":387,"_138":388,"_39":40,"_38":389,"_140":24,"_36":390,"_13":60,"_33":255,"_34":391,"_23":24,"_143":-5,"_238":392,"_26":393},{"_41":375,"_31":376,"_29":54,"_138":181,"_39":40,"_38":377,"_140":24,"_36":378,"_13":379,"_33":380,"_34":381,"_23":24,"_143":382,"_238":383,"_26":384},{"_41":173,"_31":174,"_29":175,"_138":-5,"_39":40,"_38":176,"_140":56,"_36":372,"_13":60,"_33":171,"_34":-5,"_23":24,"_143":-5,"_238":373,"_26":374},{"_41":367,"_31":316,"_29":309,"_138":175,"_39":40,"_38":368,"_140":56,"_36":369,"_13":60,"_33":171,"_34":-5,"_23":24,"_143":-5,"_238":370,"_26":371},{"_41":359,"_31":360,"_29":361,"_138":309,"_39":40,"_38":362,"_140":24,"_36":363,"_13":176,"_33":255,"_34":364,"_23":24,"_143":-5,"_238":365,"_26":366},{"_41":351,"_31":352,"_29":353,"_138":309,"_39":40,"_38":354,"_140":24,"_36":355,"_13":347,"_33":255,"_34":356,"_23":24,"_143":-5,"_238":357,"_26":358},{"_41":342,"_31":343,"_29":344,"_138":309,"_39":40,"_38":345,"_140":24,"_36":346,"_13":347,"_33":255,"_34":348,"_23":24,"_143":-5,"_238":349,"_26":350},{"_41":334,"_31":335,"_29":336,"_138":309,"_39":40,"_38":337,"_140":24,"_36":338,"_13":176,"_33":255,"_34":339,"_23":24,"_143":-5,"_238":340,"_26":341},{"_41":326,"_31":327,"_29":328,"_138":309,"_39":40,"_38":329,"_140":24,"_36":330,"_13":182,"_33":255,"_34":331,"_23":24,"_143":-5,"_238":332,"_26":333},{"_41":317,"_31":318,"_29":319,"_138":309,"_39":40,"_38":320,"_140":24,"_36":321,"_13":322,"_33":255,"_34":323,"_23":24,"_143":-5,"_238":324,"_26":325},{"_41":306,"_31":307,"_29":308,"_138":309,"_39":40,"_38":310,"_140":24,"_36":311,"_13":312,"_33":255,"_34":313,"_23":24,"_143":-5,"_238":314,"_26":315},{"_41":299,"_31":300,"_29":301,"_138":175,"_39":40,"_38":302,"_140":56,"_36":303,"_13":60,"_33":171,"_34":-5,"_23":24,"_143":-5,"_238":304,"_26":305},{"_41":291,"_31":292,"_29":293,"_138":175,"_39":40,"_38":294,"_140":24,"_36":295,"_13":188,"_33":20,"_34":296,"_23":24,"_143":-5,"_238":297,"_26":298},{"_41":283,"_31":284,"_29":285,"_138":175,"_39":40,"_38":286,"_140":56,"_36":287,"_13":60,"_33":255,"_34":288,"_23":24,"_143":-5,"_238":289,"_26":290},{"_41":279,"_31":32,"_29":30,"_138":175,"_39":40,"_38":14,"_140":24,"_36":280,"_13":60,"_33":20,"_34":35,"_23":24,"_143":-5,"_238":281,"_26":282},{"_41":166,"_31":167,"_29":168,"_138":-5,"_39":40,"_38":169,"_140":56,"_36":276,"_13":60,"_33":171,"_34":-5,"_23":24,"_143":-5,"_238":277,"_26":278},{"_41":267,"_31":268,"_29":269,"_138":168,"_39":40,"_38":270,"_140":24,"_36":271,"_13":272,"_33":255,"_34":273,"_23":24,"_143":-5,"_238":274,"_26":275},{"_41":259,"_31":260,"_29":261,"_138":168,"_39":40,"_38":262,"_140":56,"_36":263,"_13":60,"_33":255,"_34":264,"_23":24,"_143":-5,"_238":265,"_26":266},{"_41":250,"_31":251,"_29":252,"_138":168,"_39":40,"_38":253,"_140":24,"_36":254,"_13":182,"_33":255,"_34":256,"_23":24,"_143":-5,"_238":257,"_26":258},{"_41":159,"_31":160,"_29":161,"_138":-5,"_39":40,"_38":162,"_140":56,"_36":247,"_13":60,"_33":20,"_34":164,"_23":24,"_143":-5,"_238":248,"_26":249},{"_41":152,"_31":153,"_29":154,"_138":-5,"_39":40,"_38":155,"_140":56,"_36":244,"_13":60,"_33":20,"_34":157,"_23":24,"_143":-5,"_238":245,"_26":246},{"_41":145,"_31":146,"_29":147,"_138":-5,"_39":40,"_38":148,"_140":24,"_36":241,"_13":60,"_33":20,"_34":150,"_23":24,"_143":-5,"_238":242,"_26":243},{"_41":135,"_31":136,"_29":137,"_138":-5,"_39":40,"_38":139,"_140":56,"_36":237,"_13":60,"_33":20,"_34":142,"_23":24,"_143":-5,"_238":239,"_26":240},["D",1768884908674],"children",[],[136],["D",1769059418801],[],[146],["D",1768884909201],[],[153],["D",1768884909238],[],[160],"5675e0f6-f74a-11f0-8347-42dde27851f2","types.ts","3205ac72-f5bc-11f0-97e8-42dde27851f2",164,["D",1769055909856],"script","// Shared TypeScript interfaces for the Incubator Tracker\n\nexport interface SensorReading {\n id: number;\n deviceEui: string;\n timestamp: string;\n temperatureC: number;\n temperatureF: number;\n humidity: number;\n batteryVoltage: number;\n externalTempC?: number;\n rssi?: number;\n snr?: number;\n}\n\nexport interface IncubationStatus {\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\nexport interface 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 };\n}\n\nexport interface DailyTip {\n day: number;\n phase: string;\n tasks: string[];\n isSpecialDay: boolean;\n specialNote?: string;\n}\n\nexport interface DashboardData {\n currentReading: SensorReading | null;\n incubationStatus: IncubationStatus;\n alerts: AlertThresholds | null;\n recentReadings: SensorReading[];\n dailyTip: DailyTip;\n}\n\n// ChirpStack webhook payload types\nexport interface ChirpStackUplinkEvent {\n deduplicationId: string;\n time: string;\n deviceInfo: {\n tenantId: string;\n tenantName: string;\n applicationId: string;\n applicationName: string;\n deviceProfileId: string;\n deviceProfileName: string;\n deviceName: string;\n devEui: string;\n tags: Record;\n };\n devAddr: string;\n adr: boolean;\n dr: number;\n fCnt: number;\n fPort: number;\n confirmed: boolean;\n data: string; // Base64-encoded payload\n object?: Record;\n rxInfo: Array<{\n gatewayId: string;\n uplinkId: number;\n rssi: number;\n snr: number;\n channel: number;\n location?: {\n latitude: number;\n longitude: number;\n altitude: number;\n };\n context: string;\n metadata: Record;\n crcStatus: string;\n }>;\n txInfo: {\n frequency: number;\n modulation: {\n lora?: {\n bandwidth: number;\n spreadingFactor: number;\n codeRate: string;\n };\n };\n };\n}\n\nexport interface DecodedRAK7204Payload {\n batteryVoltage: number;\n temperatureCelsius: number;\n humidity: number;\n pressure?: number; // hPa\n gasResistance?: number; // kΩ\n}\n\n// NanoTag decoded payload (temperature-only sensor)\nexport interface DecodedNanoTagPayload {\n temperatureCelsius: number | null; // Most recent valid reading, null if invalid\n batteryVoltage?: number; // Only on battery status ports\n}\n\n// NanoTag reading from database\nexport interface 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",[],[167,251],"32031322-f5bc-11f0-81d9-42dde27851f2","dailyTips.ts","320313ea-f5bc-11f0-81d9-42dde27851f2",28,["D",1768884909009],"// Day-by-day care instructions for Coturnix quail incubation\nimport type { DailyTip } from \"./types.ts\";\n\nconst DAILY_TIPS: Record> = {\n 1: {\n phase: \"Setup\",\n tasks: [\n \"Turn eggs 3-5 times daily (odd number preferred)\",\n \"Mark eggs with X and O on opposite sides to track turning\",\n \"Verify temperature is stable at 101-102°F\",\n \"Keep humidity at 45-55%\",\n ],\n isSpecialDay: true,\n specialNote: \"First day! Avoid opening incubator unnecessarily.\",\n },\n 2: {\n phase: \"Setup\",\n tasks: [\n \"Turn eggs 3-5 times daily\",\n \"Monitor temperature stability\",\n \"Check humidity levels\",\n ],\n isSpecialDay: false,\n },\n 3: {\n phase: \"Setup\",\n tasks: [\n \"Turn eggs 3-5 times daily\",\n \"Embryo development beginning - keep conditions stable\",\n ],\n isSpecialDay: false,\n },\n 4: {\n phase: \"Early Development\",\n tasks: [\n \"Turn eggs 3-5 times daily\",\n \"Prepare for first candling tomorrow\",\n ],\n isSpecialDay: false,\n },\n 5: {\n phase: \"Early Development\",\n tasks: [\n \"Turn eggs 3-5 times daily\",\n \"CANDLE EGGS: Look for veins and dark spot (embryo)\",\n \"Remove clear eggs (infertile) or eggs with blood rings\",\n ],\n isSpecialDay: true,\n specialNote: \"First candling day! Grocery store eggs may have low fertility - don't be discouraged.\",\n },\n 6: {\n phase: \"Early Development\",\n tasks: [\n \"Turn eggs 3-5 times daily\",\n \"Fertile eggs should show growing vein networks\",\n ],\n isSpecialDay: false,\n },\n 7: {\n phase: \"Early Development\",\n tasks: [\n \"Turn eggs 3-5 times daily\",\n \"One week complete! Embryos developing well.\",\n ],\n isSpecialDay: false,\n },\n 8: {\n phase: \"Mid Development\",\n tasks: [\n \"Turn eggs 3-5 times daily\",\n \"Air cell at blunt end should be visible\",\n ],\n isSpecialDay: false,\n },\n 9: {\n phase: \"Mid Development\",\n tasks: [\n \"Turn eggs 3-5 times daily\",\n \"Embryo growing rapidly\",\n ],\n isSpecialDay: false,\n },\n 10: {\n phase: \"Mid Development\",\n tasks: [\n \"Turn eggs 3-5 times daily\",\n \"CANDLE EGGS: Embryo should fill ~1/3 of egg\",\n \"Air cell should be growing larger\",\n ],\n isSpecialDay: true,\n specialNote: \"Second candling day! Remove any eggs that stopped developing.\",\n },\n 11: {\n phase: \"Late Development\",\n tasks: [\n \"Turn eggs 3-5 times daily\",\n \"Embryo filling more of the egg\",\n ],\n isSpecialDay: false,\n },\n 12: {\n phase: \"Late Development\",\n tasks: [\n \"Turn eggs 3-5 times daily\",\n \"Prepare water/sponges for humidity increase at lockdown\",\n ],\n isSpecialDay: false,\n },\n 13: {\n phase: \"Late Development\",\n tasks: [\n \"Turn eggs 3-5 times daily\",\n \"Check incubator seal for lockdown\",\n ],\n isSpecialDay: false,\n },\n 14: {\n phase: \"Late Development\",\n tasks: [\n \"Turn eggs 3-5 times daily\",\n \"FINAL CANDLE: Embryo fills most of egg, large air cell\",\n \"Tomorrow is LOCKDOWN - prepare now!\",\n ],\n isSpecialDay: true,\n specialNote: \"Last candling before lockdown! Have humidity supplies ready.\",\n },\n 15: {\n phase: \"Lockdown\",\n tasks: [\n \"STOP TURNING - chicks are positioning for hatch\",\n \"INCREASE HUMIDITY to 65-75%\",\n \"Add water channels or wet sponges\",\n \"DO NOT open incubator from now on\",\n ],\n isSpecialDay: true,\n specialNote: \"LOCKDOWN BEGINS! Opening the incubator can shrink-wrap chicks.\",\n },\n 16: {\n phase: \"Lockdown\",\n tasks: [\n \"Maintain 65-75% humidity\",\n \"DO NOT open incubator\",\n \"Watch for pipping (small cracks in shells)\",\n \"Chicks may start internal pip (you won't see it)\",\n ],\n isSpecialDay: false,\n },\n 17: {\n phase: \"Hatch Day\",\n tasks: [\n \"Maintain humidity - critical!\",\n \"Watch for external pips and zipping\",\n \"Do NOT help chicks out of shells\",\n \"Hatching can take 24+ hours per chick\",\n ],\n isSpecialDay: true,\n specialNote: \"HATCH DAY! Be patient - the struggle to hatch is necessary for chick development.\",\n },\n 18: {\n phase: \"Post-Hatch\",\n tasks: [\n \"Leave chicks in incubator until fluffy and dry\",\n \"Move dry chicks to brooder (95°F)\",\n \"Provide water with marbles (prevents drowning)\",\n \"Offer chick starter feed\",\n ],\n isSpecialDay: true,\n specialNote: \"Chicks can survive 48-72 hours without food/water after hatching (absorb yolk).\",\n },\n};\n\nexport function getDailyTip(day: number): DailyTip {\n // Handle days beyond our guide\n if (day < 1) {\n return {\n day: 0,\n phase: \"Pre-incubation\",\n tasks: [\"Incubation hasn't started yet\"],\n isSpecialDay: false,\n };\n }\n\n if (day > 18) {\n return {\n day,\n phase: \"Complete\",\n tasks: [\n \"Incubation complete!\",\n \"Care for any hatched chicks in brooder\",\n \"Brooder temp: Week 1 = 95°F, reduce 5°F each week\",\n ],\n isSpecialDay: false,\n };\n }\n\n const tip = DAILY_TIPS[day];\n return {\n day,\n ...tip,\n };\n}\n\nexport function getPhaseForDay(day: number): string {\n if (day < 1) return \"Pre-incubation\";\n if (day <= 3) return \"Setup\";\n if (day <= 7) return \"Early Development\";\n if (day <= 10) return \"Mid Development\";\n if (day <= 14) return \"Late Development\";\n if (day <= 17) return \"Lockdown\";\n return \"Complete\";\n}\n",[],[167,260],"cddeea7a-f74f-11f0-80b3-42dde27851f2","constants.ts","321f3430-f5bc-11f0-97e8-42dde27851f2",179,["D",1769058257670],16,"// Sensor calibration offsets\nexport const CALIBRATION = {\n temperatureF: -2, // RAK7204 offset in Fahrenheit\n nanotagTemperatureF: 1, // NanoTag offset in Fahrenheit\n};\n\n// Device EUIs for sensor identification\nexport const DEVICE_EUIS = {\n NANOTAG: \"9c65fafffe02607a\",\n};\n\n// Incubation configuration and thresholds\n\nexport const INCUBATION_CONFIG = {\n // Dates - Coturnix quail, 17-day incubation started January 19, 2026\n // Using Pacific midnight (UTC-8) = 08:00 UTC\n startDate: new Date(\"2026-01-19T08:00:00Z\"),\n totalDays: 17,\n lockdownStartDay: 15,\n\n // Temperature thresholds (Fahrenheit) - Still-air incubator\n // Allows ±2-3°F hysteresis for heater cycling\n temp: {\n idealMin: 101,\n idealMax: 102,\n warningMin: 98, // Allow 3°F below ideal before warning\n warningMax: 105, // Allow 3°F above ideal before warning\n criticalMin: 96, // 5°F below ideal = critical\n criticalMax: 107, // 5°F above ideal = critical\n },\n\n // Humidity thresholds (%)\n humidity: {\n incubation: { min: 45, max: 55 },\n lockdown: { min: 65, max: 75 },\n },\n\n // Alert rate limiting (milliseconds)\n alerts: {\n criticalCooldown: 5 * 60 * 1000, // 5 minutes\n warningCooldown: 30 * 60 * 1000, // 30 minutes\n },\n};\n\n// Temperature conversion helpers\nexport function celsiusToFahrenheit(c: number): number {\n return (c * 9) / 5 + 32;\n}\n\nexport function fahrenheitToCelsius(f: number): number {\n return ((f - 32) * 5) / 9;\n}\n\n// Table names for SQLite\nexport const TABLES = {\n readings: \"incubator_readings_v1\",\n nanotagReadings: \"incubator_nanotag_readings_v1\",\n alerts: \"incubator_alerts_v1\",\n config: \"incubator_config_v1\",\n};\n",[],[167,268],["D",1768884907433],[230,231,232],[167],"6d528ede-f7ed-11f0-8a0d-42dde27851f2",["D",1769125956185],[],[174,32],"31b2708e-f5bc-11f0-a1cb-42dde27851f2","index.tsx","31b2714c-f5bc-11f0-a1cb-42dde27851f2",15,["D",1768884908404],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\nconst root = createRoot(document.getElementById(\"root\")!);\nroot.render();\n",[],[174,284],"b250d2ea-f5ca-11f0-a3a1-42dde27851f2","index.html","3195b9ee-f5bc-11f0-9ddc-42dde27851f2",62,["D",1768891137221],"\n\n\n \n \n Quail Incubator Monitor\n \n \n \n \n \n 🥚\">\n \n\n\n

\n \n\n\n",[],[174,292],"6d3e8c68-f7ed-11f0-8a0d-42dde27851f2","icons","6d3e8d6c-f7ed-11f0-8a0d-42dde27851f2",196,["D",1769125956055],[],[174,300],"c888aa82-f75b-11f0-9ef3-42dde27851f2","IncubationStatus.tsx","31aa9314-f5bc-11f0-bf42-42dde27851f2","313093e8-f5bc-11f0-a7c1-42dde27851f2",195,["D",1769063402686],10,"/** @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 return new Date(dateStr).toLocaleDateString(\"en-US\", {\n weekday: \"short\",\n month: \"short\",\n day: \"numeric\",\n });\n };\n\n return (\n

Incubation Progress

\n\n {/* Day counter */}\n

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

\n \n {getPhaseForDay(status.currentDay)} Phase • \n\n {status.daysRemaining > 0 ? (\n \n {status.daysRemaining}\n day{status.daysRemaining !== 1 ? \"s\" : \"\"} until hatch\n \n ) : status.phase === \"hatching\" ? (\n \n 🐣 Hatching time!\n \n ) : (\n Incubation complete\n )}\n\n \n

\n\n {/* Progress bar */}\n

\n \n

\n {/* Lockdown marker */}\n \n

\n\n {/* Key dates */}\n

Started

{formatDate(status.startDate)}

Lockdown

{formatDate(status.lockdownDate)}

Hatch

{formatDate(status.hatchDate)}

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

\n Lockdown\n

\n Maintain 65-75% humidity. Do not open incubator.\n

\n )}\n

\n );\n}\n",[],[174,316,307],"components","b25490b6-f74f-11f0-927d-42dde27851f2","HistoricalChart.tsx","31cbd4c0-f5bc-11f0-bc26-42dde27851f2",177,["D",1769058211477],17,"/** @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 SensorReading {\n timestamp: string;\n temperatureF: number;\n humidity: number;\n}\n\ninterface NanoTagReading {\n timestamp: string;\n temperatureF: number;\n}\n\ninterface Props {\n readings: SensorReading[];\n nanotagReadings: NanoTagReading[];\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\nexport function HistoricalChart({ readings, nanotagReadings }: 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 RAK7204 readings\n const filteredReadings = readings.filter(\n (r) => new Date(r.timestamp).getTime() >= cutoff\n );\n\n // Filter NanoTag readings\n const filteredNanotagReadings = nanotagReadings.filter(\n (r) => new Date(r.timestamp).getTime() >= cutoff\n );\n\n const labels = filteredReadings.map((r) => {\n const date = new Date(r.timestamp);\n return date.toLocaleTimeString(\"en-US\", {\n hour: \"2-digit\",\n minute: \"2-digit\",\n });\n });\n\n const tempData = filteredReadings.map((r) => r.temperatureF + CALIBRATION.temperatureF);\n const humidityData = filteredReadings.map((r) => r.humidity);\n\n // Map NanoTag readings to same time axis (with null for missing points)\n const nanotagTempData = filteredReadings.map((rakReading) => {\n const rakTime = new Date(rakReading.timestamp).getTime();\n // Find closest NanoTag reading within 5 minutes\n const closest = filteredNanotagReadings.find((nt) => {\n const ntTime = new Date(nt.timestamp).getTime();\n return Math.abs(ntTime - rakTime) < 5 * 60 * 1000; // 5 min tolerance\n });\n return closest ? closest.temperatureF + CALIBRATION.nanotagTemperatureF : null;\n });\n\n if (chartRef.current) {\n chartRef.current.data.labels = labels;\n chartRef.current.data.datasets[0].data = tempData;\n chartRef.current.data.datasets[1].data = humidityData;\n chartRef.current.data.datasets[2].data = nanotagTempData;\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: \"NanoThings (°F)\",\n data: nanotagTempData,\n borderColor: \"#10b981\",\n backgroundColor: \"rgba(16, 185, 129, 0.1)\",\n yAxisID: \"y\",\n tension: 0.4,\n pointRadius: 0,\n pointHoverRadius: 6,\n pointHoverBackgroundColor: \"#10b981\",\n borderWidth: 2,\n fill: false,\n // spanGaps: true,\n },\n {\n label: \"RAK (°F)\",\n data: tempData,\n borderColor: \"#3b82f6\",\n backgroundColor: \"rgba(59, 130, 246, 0.1)\",\n yAxisID: \"y\",\n tension: 0.4,\n pointRadius: 0,\n pointHoverRadius: 6,\n pointHoverBackgroundColor: \"#3b82f6\",\n borderWidth: 2,\n fill: true,\n },\n {\n label: \"Humidity (%)\",\n data: humidityData,\n borderColor: \"#94a3b8\",\n backgroundColor: \"rgba(148, 163, 184, 0.1)\",\n yAxisID: \"y1\",\n tension: 0.4,\n pointRadius: 0,\n pointHoverRadius: 6,\n pointHoverBackgroundColor: \"#94a3b8\",\n borderWidth: 2,\n fill: true,\n },\n ],\n },\n options: {\n responsive: true,\n maintainAspectRatio: false,\n interaction: {\n mode: \"index\",\n intersect: false,\n },\n plugins: {\n legend: {\n display: true,\n position: \"top\",\n align: \"end\",\n labels: {\n color: \"#64748b\",\n usePointStyle: true,\n pointStyle: \"circle\",\n padding: 20,\n font: { size: 12, family: \"Inter\" },\n },\n },\n tooltip: {\n backgroundColor: \"rgba(255, 255, 255, 0.95)\",\n titleColor: \"#1e293b\",\n bodyColor: \"#475569\",\n borderColor: \"#e2e8f0\",\n borderWidth: 1,\n padding: 12,\n cornerRadius: 6,\n displayColors: true,\n boxPadding: 6,\n },\n },\n scales: {\n x: {\n grid: { color: \"#f1f5f9\", drawBorder: false },\n ticks: { color: \"#64748b\", maxTicksLimit: 8, font: { size: 11 } },\n },\n y: {\n type: \"linear\",\n position: \"left\",\n min: 90,\n max: 115,\n grid: { color: \"#f1f5f9\", drawBorder: false },\n ticks: { color: \"#3b82f6\", font: { size: 11 } },\n title: {\n display: true,\n text: \"Temp (°F)\",\n color: \"#3b82f6\",\n font: { size: 12, weight: \"500\" },\n },\n },\n y1: {\n type: \"linear\",\n position: \"right\",\n min: 30,\n max: 90,\n grid: { drawOnChartArea: false, drawBorder: false },\n ticks: { color: \"#64748b\", font: { size: 11 } },\n title: {\n display: true,\n text: \"Humidity (%)\",\n color: \"#64748b\",\n font: { size: 12, weight: \"500\" },\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, readings, nanotagReadings, timeRange]);\n\n if (readings.length === 0) {\n return (\n

Historical Data

📊

No historical data yet

\n Data will appear once readings are received\n

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

Historical Data

\n {TIME_RANGES.map((range) => {\n const isActive = timeRange === range;\n const className = isActive\n ? \"px-3 py-1.5 rounded text-sm font-medium transition-colors bg-blue-500 text-white\"\n : \"px-3 py-1.5 rounded text-sm font-medium transition-colors text-slate-600 hover:text-slate-900\";\n return (\n setTimeRange(range)}\n className={className}\n >\n {range}\n \n );\n })}\n

\n {chartLoaded ? (\n

\n ) : (\n

\n Loading chart...\n

\n )}\n

\n );\n}\n",[],[174,316,318],"80af6362-f5cc-11f0-a65d-42dde27851f2","Header.tsx","31c5ce40-f5bc-11f0-9ddc-42dde27851f2",78,["D",1768891912949],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\n\nexport function Header() {\n return (\n

🥚

\n Quail Incubator\n

\n \n Coturnix Quail • 17-Day Incubation\n

\n );\n}\n",[],[174,316,327],"50cb2e98-f5cb-11f0-8e13-42dde27851f2","DailyTips.tsx","31a61230-f5bc-11f0-aedd-42dde27851f2",71,["D",1768891403102],"/** @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 Today's Tasks\n {tip.isSpecialDay && (\n Special Day\n )}\n

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

\n\n {/* Special note banner */}\n {tip.specialNote && (\n

{tip.specialNote}

\n )}\n\n {/* Task list */}\n

\n \n \n {task}\n \n

\n\n {/* Phase-specific tips */}\n {tip.phase === \"Lockdown\" && (\n

\n 💡\n

\n Tip: Add a wet sponge or extra water to increase\n humidity. Opening the incubator can cause chicks to get stuck.\n

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

\n 💡\n

\n Tip: Hatching can take 12-24 hours from first pip.\n The struggle is necessary for development. Only intervene after 24+ hours with no progress.\n

\n )}\n

\n );\n}\n",[],[174,316,335],"ed1da8f4-f74f-11f0-b906-42dde27851f2","CurrentReadings.tsx","31b86278-f5bc-11f0-97e8-42dde27851f2",180,["D",1769058310100],13,"/** @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\ninterface SensorReading {\n temperatureC: number;\n temperatureF: number;\n humidity: number;\n batteryVoltage: number;\n rssi?: number;\n timestamp: string;\n}\n\ninterface NanoTagReading {\n temperatureC: number;\n temperatureF: number;\n batteryVoltage: 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 };\n}\n\ninterface Props {\n reading: SensorReading | null;\n alerts: AlertThresholds | null;\n nanotagReading: NanoTagReading | null;\n}\n\nexport function CurrentReadings({ reading, alerts, nanotagReading }: Props) {\n if (!reading) {\n return (\n

Current Readings

📡

Waiting for sensor data...

\n Make sure your RAK7204 is configured\n

\n );\n }\n\n const tempStatus = alerts?.temperature.status || \"ideal\";\n const humidityTarget = alerts?.humidity.target || { min: 45, max: 55 };\n\n const getStatusPill = (status: string) => {\n switch (status) {\n case \"critical-low\":\n case \"critical-high\":\n return { pillClass: \"pill-red\", label: \"Critical\" };\n case \"warning-low\":\n case \"warning-high\":\n return { pillClass: \"pill-yellow\", label: \"Warning\" };\n default:\n return { pillClass: \"pill-green\", label: \"Ideal\" };\n }\n };\n\n const statusConfig = getStatusPill(tempStatus);\n\n const formatTime = (timestamp: string) => {\n const date = new Date(timestamp);\n return date.toLocaleTimeString(\"en-US\", {\n hour: \"2-digit\",\n minute: \"2-digit\",\n });\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 // Calculate calibrated temperatures\n const rakTempF = reading.temperatureF + CALIBRATION.temperatureF;\n const nanotagTempF = nanotagReading\n ? nanotagReading.temperatureF + CALIBRATION.nanotagTemperatureF\n : null;\n\n // Calculate average temperature (use RAK only if NanoTag unavailable)\n const avgTempF = nanotagTempF !== null\n ? (rakTempF + nanotagTempF) / 2\n : rakTempF;\n\n const rakBatteryPercent = getBatteryPercent(reading.batteryVoltage);\n const rakBatteryColor = rakBatteryPercent < 20 ? \"#ef4444\" : rakBatteryPercent < 50 ? \"#eab308\" : \"#22c55e\";\n\n const nanotagBatteryPercent = nanotagReading?.batteryVoltage\n ? getBatteryPercent(nanotagReading.batteryVoltage)\n : null;\n\n return (\n

Current Readings

\n {statusConfig.label}\n

\n\n

\n {/* Temperature (average of both sensors) */}\n

\n {avgTempF.toFixed(1)}°\n

Temperature

\n Target: 101-102°F\n

\n\n {/* Humidity */}\n

\n {reading.humidity.toFixed(0)}%\n

Humidity

\n Target: {humidityTarget.min}-{humidityTarget.max}%\n

\n\n {/* Sensor rows */}\n

\n {/* RAK sensor row */}\n

\n RAK7204\n

\n \n {Math.round(rakBatteryPercent)}%\n

\n {rakTempF.toFixed(1)}°F\n {formatTime(reading.timestamp)}\n

\n\n {/* NanoThings sensor row */}\n

\n NanoThings\n {nanotagReading?.batteryVoltage && nanotagBatteryPercent !== null ? (\n

\n \n {Math.round(nanotagBatteryPercent)}%\n

\n ) : (\n —\n )}\n

\n {nanotagTempF !== null ? (\n <>\n {nanotagTempF.toFixed(1)}°F\n {formatTime(nanotagReading!.timestamp)}\n \n ) : (\n No data\n )}\n

\n );\n}\n",[],[174,316,343],"bc52300c-f74d-11f0-9d8a-42dde27851f2","App.tsx","3199d0ce-f5bc-11f0-aedd-42dde27851f2",168,["D",1769057369244],"/** @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 { DailyTips } from \"./DailyTips.tsx\";\nimport { HistoricalChart } from \"./HistoricalChart.tsx\";\nimport { AlertBanner } from \"./AlertBanner.tsx\";\n\n// Types matching backend\ninterface SensorReading {\n id: number;\n deviceEui: string;\n timestamp: string;\n temperatureC: number;\n temperatureF: number;\n humidity: number;\n batteryVoltage: number;\n rssi?: number;\n snr?: number;\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 };\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\ninterface DashboardData {\n currentReading: SensorReading | null;\n incubationStatus: IncubationStatusData;\n alerts: AlertThresholds | null;\n recentReadings: SensorReading[];\n nanotagReadings: NanoTagReading[];\n dailyTip: DailyTip;\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, readingsRes, nanotagRes] = await Promise.all([\n fetch(\"/api/status\"),\n fetch(\"/api/readings?minutes=1440\"),\n fetch(\"/api/readings/nanotag?minutes=1440\"),\n ]);\n\n if (!statusRes.ok || !readingsRes.ok || !nanotagRes.ok) {\n throw new Error(\"Failed to fetch data\");\n }\n\n const status = await statusRes.json();\n const recentReadings = await readingsRes.json();\n const nanotagReadings = await nanotagRes.json();\n\n setData({\n ...status,\n recentReadings,\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 if (loading) {\n return (\n

🥚

\n Loading incubator data...\n

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

⚠️

Failed to load data

{error}

\n window.location.reload()}\n className=\"mt-6 px-6 py-3 bg-blue-500 hover:bg-blue-600 rounded-md font-semibold text-white transition-colors\"\n >\n Try Again\n \n

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

📊

No data available

Waiting for sensor readings...

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

\n\n {data.alerts && (\n \n )}\n\n

\n 0 ? data.nanotagReadings[data.nanotagReadings.length - 1] : null}\n />\n \n

\n\n

\n \n

\n\n \n

\n );\n}\n",[],[174,316,352],"2ec88e08-f5cb-11f0-bfe4-42dde27851f2","AlertBanner.tsx","31ae4180-f5bc-11f0-9ddc-42dde27851f2",70,["D",1768891346043],"/** @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 };\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 pillClass: \"pill-red\",\n pillLabel: \"Critical\",\n title: \"Temperature Too Low\",\n message: `Temperature at ${alerts.temperature.current.toFixed(1)}°F is dangerously low. Embryo development at risk.`,\n action: \"Check heat source immediately.\",\n bgClass: \"bg-red-50\",\n };\n case \"critical-high\":\n return {\n pillClass: \"pill-red\",\n pillLabel: \"Critical\",\n title: \"Temperature Too High\",\n message: `Temperature at ${alerts.temperature.current.toFixed(1)}°F is dangerously high. Risk of embryo damage.`,\n action: \"Reduce heat or improve ventilation immediately.\",\n bgClass: \"bg-red-50\",\n };\n case \"warning-low\":\n return {\n pillClass: \"pill-yellow\",\n pillLabel: \"Warning\",\n title: \"Temperature Low\",\n message: `Temperature at ${alerts.temperature.current.toFixed(1)}°F is below optimal range.`,\n action: \"Consider adjusting heat source.\",\n bgClass: \"bg-yellow-50\",\n };\n case \"warning-high\":\n return {\n pillClass: \"pill-yellow\",\n pillLabel: \"Warning\",\n title: \"Temperature High\",\n message: `Temperature at ${alerts.temperature.current.toFixed(1)}°F is above optimal range.`,\n action: \"Consider improving ventilation.\",\n bgClass: \"bg-yellow-50\",\n };\n default:\n return null;\n }\n };\n\n const alert = getMessage();\n if (!alert) return null;\n\n return (\n

\n {alert.pillLabel}\n

{alert.title}

{alert.message}

{alert.action}

\n\n {/* Temperature display */}\n

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

\n Current temp\n

\n );\n}\n",[],[174,316,360],"31309302-f5bc-11f0-a7c1-42dde27851f2",6,["D",1768884907625],[218,219,220,221,222,223,224],[174,316],["D",1768884906906],[217,225,226,227,228],[174],"d7fd3b3c-f737-11f0-bc87-42dde27851f2","index.http.tsx",148,["D",1769047966731],7,"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 { getLatestReading, getRecentReadings, getRecentNanoTagReadings } from \"./database/queries.ts\";\nimport { calculateIncubationStatus, getCurrentDailyTip, getAlertThresholds } from \"./services/incubation.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 // Inject initial data to avoid extra round-trips\n const currentReading = await getLatestReading();\n const incubationStatus = calculateIncubationStatus();\n const dailyTip = getCurrentDailyTip();\n // Apply calibration for alert thresholds\n const calibratedTempF = currentReading\n ? currentReading.temperatureF + CALIBRATION.temperatureF\n : 0;\n const alerts = currentReading\n ? getAlertThresholds(\n calibratedTempF,\n currentReading.humidity,\n incubationStatus.currentDay\n )\n : null;\n\n const initialData = {\n currentReading,\n incubationStatus,\n dailyTip,\n alerts,\n recentReadings: await getRecentReadings(24 * 60), // Last 24 hours\n nanotagReadings: await getRecentNanoTagReadings(24 * 60), // Last 24 hours\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",[],[180,376],"31f2247c-f5bc-11f0-97e8-42dde27851f2","incubation.ts","31f22526-f5bc-11f0-97e8-42dde27851f2","317da458-f5bc-11f0-9ddc-42dde27851f2",25,["D",1768884908905],"// Incubation phase and status calculations\nimport { INCUBATION_CONFIG } from \"../../shared/constants.ts\";\nimport { getDailyTip } from \"../../shared/dailyTips.ts\";\nimport type { IncubationStatus, AlertThresholds, DailyTip } 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,\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\n let humidityStatus: AlertThresholds[\"humidity\"][\"status\"];\n if (humidity < humidityTarget.min) {\n humidityStatus = \"low\";\n } else if (humidity > humidityTarget.max) {\n humidityStatus = \"high\";\n } else {\n humidityStatus = \"ideal\";\n }\n\n return {\n temperature: {\n current: temperatureF,\n status: tempStatus,\n },\n humidity: {\n current: humidity,\n target: humidityTarget,\n status: humidityStatus,\n },\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",[],[180,394,386],"services","69e5da2e-f74a-11f0-8a16-42dde27851f2","decoder.ts","31fa7226-f5bc-11f0-b5fb-42dde27851f2",166,["D",1769055942468],8,"// RAK7204 LoRaWAN payload decoder (Cayenne LPP format)\nimport type { DecodedRAK7204Payload, DecodedNanoTagPayload } from \"../../shared/types.ts\";\n\n/**\n * Cayenne LPP channel types used by RAK7204\n */\nconst LPP_TYPES = {\n ANALOG_INPUT: 0x02, // 2 bytes, 0.01 signed\n TEMPERATURE: 0x67, // 2 bytes, 0.1°C signed\n HUMIDITY: 0x68, // 1 byte, 0.5% unsigned\n BAROMETER: 0x73, // 2 bytes, 0.1 hPa unsigned\n};\n\n/**\n * Decode RAK7204 Cayenne LPP payload\n *\n * Payload structure (variable length, TLV format):\n * Each field: [channel] [type] [data...]\n *\n * RAK7204 fields:\n * - Battery: channel 0x08, type 0x02 (analog), 2 bytes, multiplier 0.01V\n * - Humidity: channel 0x07, type 0x68, 1 byte, multiplier 0.5%\n * - Pressure: channel 0x06, type 0x73, 2 bytes, multiplier 0.1 hPa\n * - Temperature: channel 0x02, type 0x67, 2 bytes, multiplier 0.1°C signed\n * - Gas Resistance: channel 0x04, type 0x02 (analog), 2 bytes, multiplier 0.01 kΩ\n */\nexport function decodeRAK7204Payload(base64Data: string): DecodedRAK7204Payload {\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: DecodedRAK7204Payload = {\n batteryVoltage: 0,\n temperatureCelsius: 0,\n humidity: 0,\n };\n\n let i = 0;\n while (i < bytes.length - 2) {\n const channel = bytes[i];\n const type = bytes[i + 1];\n i += 2;\n\n switch (type) {\n case LPP_TYPES.ANALOG_INPUT: {\n // 2 bytes signed, multiplier depends on channel\n if (i + 2 > bytes.length) break;\n let value = (bytes[i] << 8) | bytes[i + 1];\n // Handle signed value\n if (value > 0x7fff) value -= 0x10000;\n\n if (channel === 0x08) {\n // Battery voltage: 0.01V multiplier\n result.batteryVoltage = value * 0.01;\n } else if (channel === 0x04) {\n // Gas resistance: 0.01 kΩ multiplier\n result.gasResistance = value * 0.01;\n }\n i += 2;\n break;\n }\n\n case LPP_TYPES.TEMPERATURE: {\n // 2 bytes signed, 0.1°C\n if (i + 2 > bytes.length) break;\n let value = (bytes[i] << 8) | bytes[i + 1];\n if (value > 0x7fff) value -= 0x10000;\n result.temperatureCelsius = value * 0.1;\n i += 2;\n break;\n }\n\n case LPP_TYPES.HUMIDITY: {\n // 1 byte unsigned, 0.5%\n if (i + 1 > bytes.length) break;\n result.humidity = bytes[i] * 0.5;\n i += 1;\n break;\n }\n\n case LPP_TYPES.BAROMETER: {\n // 2 bytes unsigned, 0.1 hPa\n if (i + 2 > bytes.length) break;\n const value = (bytes[i] << 8) | bytes[i + 1];\n result.pressure = value * 0.1;\n i += 2;\n break;\n }\n\n default:\n // Unknown type, try to skip (assume 2 bytes)\n i += 2;\n break;\n }\n }\n\n return result;\n}\n\n/**\n * Validate decoded payload values are within reasonable ranges\n */\nexport function validatePayload(decoded: DecodedRAK7204Payload): { valid: boolean; errors: string[] } {\n const errors: string[] = [];\n\n // Battery should be between 2.0V and 4.5V\n if (decoded.batteryVoltage < 2.0 || decoded.batteryVoltage > 4.5) {\n errors.push(`Battery voltage ${decoded.batteryVoltage}V outside expected range (2.0-4.5V)`);\n }\n\n // Temperature should be between -40°C and 85°C (BME680 operating range)\n if (decoded.temperatureCelsius < -40 || decoded.temperatureCelsius > 85) {\n errors.push(`Temperature ${decoded.temperatureCelsius}°C outside sensor range (-40 to 85°C)`);\n }\n\n // Humidity should be between 0% and 100%\n if (decoded.humidity < 0 || decoded.humidity > 100) {\n errors.push(`Humidity ${decoded.humidity}% outside valid range (0-100%)`);\n }\n\n return {\n valid: errors.length === 0,\n errors,\n };\n}\n\n// --- NanoTag Decoder ---\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",[],[180,394,396],"31fe3b9a-f5bc-11f0-97e8-42dde27851f2","alerts.ts","31fe3c4e-f5bc-11f0-97e8-42dde27851f2",27,["D",1768884908973],"// Email alert service with rate limiting\nimport { email } from \"https://esm.town/v/std/email\";\nimport { INCUBATION_CONFIG } from \"../../shared/constants.ts\";\nimport { getLastAlertTime, recordAlert } from \"../database/queries.ts\";\nimport { getTargetHumidity } from \"./incubation.ts\";\n\ninterface AlertToSend {\n level: \"critical\" | \"warning\";\n type: \"temperature\" | \"humidity\";\n message: string;\n}\n\n/**\n * Check temperature and humidity against thresholds and send rate-limited email alerts\n */\nexport async function checkAndSendAlerts(\n temperatureF: number,\n humidity: number,\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)\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 // 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\n- Humidity: ${humidity.toFixed(1)}%\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
Humidity: ${humidity.toFixed(1)}%
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",[],[180,394,405],"317da3cc-f5bc-11f0-9ddc-42dde27851f2",9,["D",1768884908132],[212,213,214],[180,394],"7778de98-f74a-11f0-ac5f-42dde27851f2","webhook.ts","31ee8a74-f5bc-11f0-97e8-42dde27851f2","3163c466-f5bc-11f0-9a10-42dde27851f2",167,["D",1769055965238],"// ChirpStack webhook handler for RAK7204 and NanoTag sensors\nimport { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport {\n decodeRAK7204Payload,\n validatePayload,\n decodeNanoTagPayload,\n validateNanoTagPayload,\n} from \"../services/decoder.ts\";\nimport { insertReading, insertNanoTagReading } from \"../database/queries.ts\";\nimport { checkAndSendAlerts } from \"../services/alerts.ts\";\nimport { calculateIncubationStatus } from \"../services/incubation.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 // Route by DevEUI\n if (devEui === DEVICE_EUIS.NANOTAG.toLowerCase()) {\n // --- NanoTag Processing ---\n return await handleNanoTagUplink(c, payload, rxInfo);\n } else {\n // --- RAK7204 Processing (default) ---\n return await handleRAK7204Uplink(c, payload, rxInfo);\n }\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// --- RAK7204 Handler ---\nasync function handleRAK7204Uplink(c: any, payload: ChirpStackUplinkEvent, rxInfo: any) {\n const decoded = decodeRAK7204Payload(payload.data);\n\n const validation = validatePayload(decoded);\n if (!validation.valid) {\n console.warn(\"RAK7204 payload validation warnings:\", validation.errors);\n }\n\n const temperatureF = celsiusToFahrenheit(decoded.temperatureCelsius);\n\n await insertReading({\n deviceEui: payload.deviceInfo.devEui,\n timestamp: payload.time || new Date().toISOString(),\n temperatureC: decoded.temperatureCelsius,\n temperatureF: temperatureF,\n humidity: decoded.humidity,\n batteryVoltage: decoded.batteryVoltage,\n rssi: rxInfo?.rssi,\n snr: rxInfo?.snr,\n rawPayload: payload.data,\n });\n\n // Check for alerts (RAK7204 only, using calibrated temperature)\n const calibratedTempF = temperatureF + CALIBRATION.temperatureF;\n const status = calculateIncubationStatus();\n await checkAndSendAlerts(calibratedTempF, decoded.humidity, status.currentDay);\n\n return c.json({\n status: \"success\",\n sensor: \"RAK7204\",\n decoded: {\n temperatureF_raw: temperatureF.toFixed(1),\n temperatureF_calibrated: calibratedTempF.toFixed(1),\n humidity: decoded.humidity,\n batteryVoltage: decoded.batteryVoltage,\n },\n day: status.currentDay,\n phase: status.phase,\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 // Skip if no temperature reading (battery-only ports)\n if (decoded.temperatureCelsius === null) {\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 return c.json({\n status: \"success\",\n sensor: \"NanoTag\",\n decoded: {\n temperatureC: decoded.temperatureCelsius.toFixed(2),\n temperatureF_raw: temperatureF.toFixed(1),\n temperatureF_calibrated: (temperatureF + CALIBRATION.nanotagTemperatureF).toFixed(1),\n },\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",[],[180,426,418],"routes","48e5fc52-f752-11f0-9eef-42dde27851f2","api.ts","31e96b7a-f5bc-11f0-b018-42dde27851f2",185,["D",1769059323078],"// Dashboard API endpoints\nimport { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport {\n getLatestReading,\n getRecentReadings,\n getReadingsInRange,\n getAlertHistory,\n getRecentNanoTagReadings,\n} from \"../database/queries.ts\";\nimport {\n calculateIncubationStatus,\n getAlertThresholds,\n getCurrentDailyTip,\n} from \"../services/incubation.ts\";\nimport { getDailyTip } from \"../../shared/dailyTips.ts\";\nimport { CALIBRATION } from \"../../shared/constants.ts\";\n\nexport const apiRouter = new Hono();\n\n// Get current status (main dashboard endpoint)\napiRouter.get(\"/status\", async (c) => {\n const currentReading = await getLatestReading();\n const incubationStatus = calculateIncubationStatus();\n const dailyTip = getCurrentDailyTip();\n\n // Apply calibration for alert thresholds\n const calibratedTempF = currentReading\n ? currentReading.temperatureF + CALIBRATION.temperatureF\n : 0;\n const alerts = currentReading\n ? getAlertThresholds(\n calibratedTempF,\n currentReading.humidity,\n incubationStatus.currentDay\n )\n : null;\n\n return c.json({\n currentReading,\n incubationStatus,\n alerts,\n dailyTip,\n });\n});\n\n// Get readings for time range (for charts)\napiRouter.get(\"/readings\", 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 getRecentReadings(Math.min(minutes, 10080)); // Max 1 week\n return c.json(readings);\n});\n\n// Get NanoTag readings for time range\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 readings between specific timestamps\napiRouter.get(\"/readings/range\", async (c) => {\n const start = c.req.query(\"start\");\n const end = c.req.query(\"end\");\n\n if (!start || !end) {\n return c.json({ error: \"start and end parameters required\" }, 400);\n }\n\n // Validate ISO date format\n const startDate = new Date(start);\n const endDate = new Date(end);\n\n if (isNaN(startDate.getTime()) || isNaN(endDate.getTime())) {\n return c.json({ error: \"Invalid date format. Use ISO 8601 format.\" }, 400);\n }\n\n const readings = await getReadingsInRange(start, end);\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",[],[180,426,428],"3163c358-f5bc-11f0-9a10-42dde27851f2",["D",1768884907969],[209,210],[180,426],"4ca244b8-f752-11f0-9a4f-42dde27851f2","queries.ts","31d98cb4-f5bc-11f0-aedd-42dde27851f2","314929f8-f5bc-11f0-9ddc-42dde27851f2",186,["D",1769059329346],"// Database query functions for incubator tracking\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLES } from \"../../shared/constants.ts\";\nimport type { SensorReading, NanoTagReading } from \"../../shared/types.ts\";\n\ninterface InsertReadingParams {\n deviceEui: string;\n timestamp: string;\n temperatureC: number;\n temperatureF: number;\n humidity: number;\n batteryVoltage: number;\n externalTempC?: number;\n rssi?: number;\n snr?: number;\n rawPayload?: string;\n}\n\nexport async function insertReading(params: InsertReadingParams): Promise {\n const result = await sqlite.execute(\n `\n INSERT INTO ${TABLES.readings}\n (device_eui, timestamp, temperature_c, temperature_f, humidity, battery_voltage, external_temp_c, rssi, snr, raw_payload)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `,\n [\n params.deviceEui,\n params.timestamp,\n params.temperatureC,\n params.temperatureF,\n params.humidity,\n params.batteryVoltage,\n params.externalTempC ?? null,\n params.rssi ?? null,\n params.snr ?? null,\n params.rawPayload ?? null,\n ]\n );\n return result.lastInsertRowid as number;\n}\n\nfunction rowToReading(row: Record): SensorReading {\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 humidity: row.humidity as number,\n batteryVoltage: row.battery_voltage as number,\n externalTempC: row.external_temp_c as number | undefined,\n rssi: row.rssi as number | undefined,\n snr: row.snr as number | undefined,\n };\n}\n\nexport async function getLatestReading(): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${TABLES.readings}\n ORDER BY timestamp DESC\n LIMIT 1\n `);\n\n if (result.rows.length === 0) return null;\n return rowToReading(result.rows[0] as Record);\n}\n\nexport async function getRecentReadings(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.readings}\n WHERE timestamp >= ?\n ORDER BY timestamp ASC\n `,\n [cutoff]\n );\n\n return result.rows.map((row) => rowToReading(row as Record));\n}\n\nexport async function getReadingsInRange(start: string, end: string): Promise {\n const result = await sqlite.execute(\n `\n SELECT * FROM ${TABLES.readings}\n WHERE timestamp >= ? AND timestamp <= ?\n ORDER BY timestamp ASC\n `,\n [start, end]\n );\n\n return result.rows.map((row) => rowToReading(row as Record));\n}\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,\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",[],[180,448,440],"database","755797a2-f737-11f0-82fb-42dde27851f2","migrations.ts","31e3a032-f5bc-11f0-b5fb-42dde27851f2",137,["D",1769047801226],"// SQLite schema definitions for incubator tracking\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLES, INCUBATION_CONFIG } from \"../../shared/constants.ts\";\n\nexport async function runMigrations(): Promise {\n // Sensor readings timeseries\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.readings} (\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 humidity REAL NOT NULL,\n battery_voltage REAL NOT NULL,\n external_temp_c REAL,\n rssi INTEGER,\n snr REAL,\n raw_payload TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Create index for efficient time-range queries\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_readings_timestamp\n ON ${TABLES.readings}(timestamp DESC)\n `);\n\n // NanoTag sensor readings (temperature only, simpler schema)\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\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",[],[180,448,450],"31492868-f5bc-11f0-9ddc-42dde27851f2",["D",1768884907798],[206,207],[180,448],["D",1768884907253],[205,208,211,215],[180],"ed206e10-f739-11f0-bce4-42dde27851f2","settings.local.json","31df6a30-f5bc-11f0-97e8-42dde27851f2",158,["D",1769048861191],"{\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 ]\n }\n}\n",[],[186,465],["D",1768884907128],[203],[186],["D",1768883246417],["D",1789527031073],{"_97":96,"_104":100},{"_97":96,"_98":-5,"_99":100,"_18":52,"_101":102,"_103":24},{"_13":86,"_31":87,"_41":40,"_88":42,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":43,"_95":96},"ctx",{"_79":-5,"_124":513,"_514":515,"_516":517,"_518":24,"_519":24,"_520":24,"_521":56,"_522":-5,"_523":-7,"_524":-7,"_525":60,"_526":24,"_527":24,"_528":-5,"_529":24,"_530":24,"_531":24,"_532":-5},"ENV",{"_484":485,"_486":487,"_488":87,"_489":490,"_491":492,"_493":494,"_495":496,"_497":498,"_499":500,"_501":502,"_503":504,"_505":506,"_507":508,"_509":510,"_511":512},"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 · v197