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",[152],"322a1fbc-f5bc-11f0-97e8-42dde27851f2",["D",1768884909238],[27],"3111a35c-f5bc-11f0-9a10-42dde27851f2","shared","3111a438-f5bc-11f0-9a10-42dde27851f2",5,["D",1768884907433],"directory",[162],"30c1433a-f5bc-11f0-90d9-42dde27851f2","frontend","30c14402-f5bc-11f0-90d9-42dde27851f2",2,["D",1768884906906],[169],"30f61524-f5bc-11f0-ab7f-42dde27851f2","backend","30f615c4-f5bc-11f0-ab7f-42dde27851f2",4,["D",1768884907253],[175],"30e42e72-f5bc-11f0-ab7f-42dde27851f2",".claude","30e42f3a-f5bc-11f0-ab7f-42dde27851f2",3,["D",1768884907128],[181],"pulls","branches","forks","envVars",{"_193":138,"_195":59},"connections",{"_193":59,"_194":59},"count","unfilledCount","emptyCount",{"_40":180,"_31":181,"_29":182,"_137":-5,"_38":39,"_37":183,"_139":55,"_35":448,"_13":59,"_32":166,"_33":-5,"_23":24,"_142":-5,"_230":449,"_26":450},{"_40":440,"_31":441,"_29":442,"_137":182,"_38":39,"_37":443,"_139":24,"_35":444,"_13":59,"_32":20,"_33":445,"_23":24,"_142":-5,"_230":446,"_26":447},{"_40":174,"_31":175,"_29":176,"_137":-5,"_38":39,"_37":177,"_139":55,"_35":437,"_13":59,"_32":166,"_33":-5,"_23":24,"_142":-5,"_230":438,"_26":439},{"_40":432,"_31":423,"_29":417,"_137":176,"_38":39,"_37":433,"_139":55,"_35":434,"_13":59,"_32":166,"_33":-5,"_23":24,"_142":-5,"_230":435,"_26":436},{"_40":424,"_31":425,"_29":426,"_137":417,"_38":39,"_37":427,"_139":24,"_35":428,"_13":59,"_32":141,"_33":429,"_23":24,"_142":-5,"_230":430,"_26":431},{"_40":414,"_31":415,"_29":416,"_137":417,"_38":39,"_37":418,"_139":24,"_35":419,"_13":59,"_32":141,"_33":420,"_23":24,"_142":-5,"_230":421,"_26":422},{"_40":409,"_31":400,"_29":394,"_137":176,"_38":39,"_37":410,"_139":55,"_35":411,"_13":59,"_32":166,"_33":-5,"_23":24,"_142":-5,"_230":412,"_26":413},{"_40":401,"_31":402,"_29":403,"_137":394,"_38":39,"_37":404,"_139":24,"_35":405,"_13":59,"_32":141,"_33":406,"_23":24,"_142":-5,"_230":407,"_26":408},{"_40":391,"_31":392,"_29":393,"_137":394,"_38":39,"_37":395,"_139":24,"_35":396,"_13":59,"_32":141,"_33":397,"_23":24,"_142":-5,"_230":398,"_26":399},{"_40":386,"_31":369,"_29":363,"_137":176,"_38":39,"_37":387,"_139":55,"_35":388,"_13":59,"_32":166,"_33":-5,"_23":24,"_142":-5,"_230":389,"_26":390},{"_40":378,"_31":379,"_29":380,"_137":363,"_38":39,"_37":381,"_139":24,"_35":382,"_13":59,"_32":141,"_33":383,"_23":24,"_142":-5,"_230":384,"_26":385},{"_40":370,"_31":371,"_29":372,"_137":363,"_38":39,"_37":373,"_139":24,"_35":374,"_13":59,"_32":141,"_33":375,"_23":24,"_142":-5,"_230":376,"_26":377},{"_40":360,"_31":361,"_29":362,"_137":363,"_38":39,"_37":364,"_139":24,"_35":365,"_13":59,"_32":141,"_33":366,"_23":24,"_142":-5,"_230":367,"_26":368},{"_40":351,"_31":352,"_29":53,"_137":176,"_38":39,"_37":353,"_139":24,"_35":354,"_13":59,"_32":355,"_33":356,"_23":24,"_142":357,"_230":358,"_26":359},{"_40":168,"_31":169,"_29":170,"_137":-5,"_38":39,"_37":171,"_139":55,"_35":348,"_13":59,"_32":166,"_33":-5,"_23":24,"_142":-5,"_230":349,"_26":350},{"_40":343,"_31":294,"_29":288,"_137":170,"_38":39,"_37":344,"_139":55,"_35":345,"_13":59,"_32":166,"_33":-5,"_23":24,"_142":-5,"_230":346,"_26":347},{"_40":335,"_31":336,"_29":337,"_137":288,"_38":39,"_37":338,"_139":24,"_35":339,"_13":59,"_32":141,"_33":340,"_23":24,"_142":-5,"_230":341,"_26":342},{"_40":327,"_31":328,"_29":329,"_137":288,"_38":39,"_37":330,"_139":24,"_35":331,"_13":59,"_32":141,"_33":332,"_23":24,"_142":-5,"_230":333,"_26":334},{"_40":319,"_31":320,"_29":321,"_137":288,"_38":39,"_37":322,"_139":24,"_35":323,"_13":59,"_32":141,"_33":324,"_23":24,"_142":-5,"_230":325,"_26":326},{"_40":311,"_31":312,"_29":313,"_137":288,"_38":39,"_37":314,"_139":24,"_35":315,"_13":59,"_32":141,"_33":316,"_23":24,"_142":-5,"_230":317,"_26":318},{"_40":303,"_31":304,"_29":305,"_137":288,"_38":39,"_37":306,"_139":24,"_35":307,"_13":59,"_32":141,"_33":308,"_23":24,"_142":-5,"_230":309,"_26":310},{"_40":295,"_31":296,"_29":297,"_137":288,"_38":39,"_37":298,"_139":24,"_35":299,"_13":59,"_32":141,"_33":300,"_23":24,"_142":-5,"_230":301,"_26":302},{"_40":285,"_31":286,"_29":287,"_137":288,"_38":39,"_37":289,"_139":24,"_35":290,"_13":59,"_32":141,"_33":291,"_23":24,"_142":-5,"_230":292,"_26":293},{"_40":277,"_31":278,"_29":279,"_137":170,"_38":39,"_37":280,"_139":24,"_35":281,"_13":59,"_32":20,"_33":282,"_23":24,"_142":-5,"_230":283,"_26":284},{"_40":269,"_31":270,"_29":271,"_137":170,"_38":39,"_37":272,"_139":55,"_35":273,"_13":59,"_32":141,"_33":274,"_23":24,"_142":-5,"_230":275,"_26":276},{"_40":161,"_31":162,"_29":163,"_137":-5,"_38":39,"_37":164,"_139":55,"_35":266,"_13":59,"_32":166,"_33":-5,"_23":24,"_142":-5,"_230":267,"_26":268},{"_40":258,"_31":259,"_29":260,"_137":163,"_38":39,"_37":261,"_139":24,"_35":262,"_13":59,"_32":141,"_33":263,"_23":24,"_142":-5,"_230":264,"_26":265},{"_40":250,"_31":251,"_29":252,"_137":163,"_38":39,"_37":253,"_139":55,"_35":254,"_13":59,"_32":141,"_33":255,"_23":24,"_142":-5,"_230":256,"_26":257},{"_40":242,"_31":243,"_29":244,"_137":163,"_38":39,"_37":245,"_139":24,"_35":246,"_13":59,"_32":141,"_33":247,"_23":24,"_142":-5,"_230":248,"_26":249},{"_40":158,"_31":27,"_29":30,"_137":-5,"_38":39,"_37":14,"_139":55,"_35":239,"_13":59,"_32":20,"_33":34,"_23":24,"_142":-5,"_230":240,"_26":241},{"_40":151,"_31":152,"_29":153,"_137":-5,"_38":39,"_37":154,"_139":55,"_35":236,"_13":59,"_32":20,"_33":156,"_23":24,"_142":-5,"_230":237,"_26":238},{"_40":144,"_31":145,"_29":146,"_137":-5,"_38":39,"_37":147,"_139":55,"_35":233,"_13":59,"_32":20,"_33":149,"_23":24,"_142":-5,"_230":234,"_26":235},{"_40":134,"_31":135,"_29":136,"_137":-5,"_38":39,"_37":138,"_139":24,"_35":229,"_13":59,"_32":141,"_33":105,"_23":24,"_142":-5,"_230":231,"_26":232},["D",1768883246428],"children",[],[135],["D",1768884908674],[],[145],["D",1768884909201],[],[152],["D",1768884909238],[],[27],"3205abbe-f5bc-11f0-97e8-42dde27851f2","types.ts","3205ac72-f5bc-11f0-97e8-42dde27851f2",29,["D",1768884909032],"// 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 DecodedLHT65Payload {\n batteryVoltage: number;\n temperatureCelsius: number;\n humidity: number;\n externalSensorType: number;\n externalTemperature?: number;\n}\n",[],[162,243],"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",[],[162,251],"321f3368-f5bc-11f0-97e8-42dde27851f2","constants.ts","321f3430-f5bc-11f0-97e8-42dde27851f2",31,["D",1768884909200],"// Incubation configuration and thresholds\n\nexport const INCUBATION_CONFIG = {\n // Dates - Coturnix quail, 17-day incubation started January 19, 2026\n startDate: new Date(\"2026-01-19T00:00:00Z\"),\n totalDays: 17,\n lockdownStartDay: 15,\n\n // Temperature thresholds (Fahrenheit) - Still-air incubator\n temp: {\n idealMin: 101,\n idealMax: 102,\n warningMin: 100,\n warningMax: 103,\n criticalMin: 99,\n criticalMax: 104,\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 alerts: \"incubator_alerts_v1\",\n config: \"incubator_config_v1\",\n};\n",[],[162,259],["D",1768884907433],[222,223,224],[162],"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",[],[169,270],"3195b944-f5bc-11f0-9ddc-42dde27851f2","index.html","3195b9ee-f5bc-11f0-9ddc-42dde27851f2",10,["D",1768884908300],"\n\n\n \n \n Quail Incubator Monitor\n \n \n 🥚\">\n \n\n\n

\n \n\n\n",[],[169,278],"31aa924c-f5bc-11f0-bf42-42dde27851f2","IncubationStatus.tsx","31aa9314-f5bc-11f0-bf42-42dde27851f2","313093e8-f5bc-11f0-a7c1-42dde27851f2",13,["D",1768884908403],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\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 phaseConfig = {\n incubation: { color: \"bg-blue-600\", label: \"Incubation\", emoji: \"🥚\" },\n lockdown: { color: \"bg-yellow-600\", label: \"Lockdown\", emoji: \"🔒\" },\n hatching: { color: \"bg-green-600\", label: \"Hatching\", emoji: \"🐣\" },\n complete: { color: \"bg-gray-600\", label: \"Complete\", emoji: \"✅\" },\n };\n\n const config = phaseConfig[status.phase];\n\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 Day {status.currentDay}\n / 17\n

\n \n {config.emoji} {config.label} Phase\n

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

\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 ACTIVE\n

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

\n )}\n\n {/* Countdown */}\n

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

\n \n );\n}\n",[],[169,294,286],"components","31cbd3e4-f5bc-11f0-bc26-42dde27851f2","HistoricalChart.tsx","31cbd4c0-f5bc-11f0-bc26-42dde27851f2",18,["D",1768884908604],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useEffect, useRef, useState } from \"https://esm.sh/react@18.2.0\";\n\ninterface SensorReading {\n timestamp: string;\n temperatureF: number;\n humidity: number;\n}\n\ninterface Props {\n readings: SensorReading[];\n}\n\n// Declare Chart.js global\ndeclare const Chart: any;\n\nexport function HistoricalChart({ readings }: Props) {\n const canvasRef = useRef(null);\n const chartRef = useRef(null);\n const [chartLoaded, setChartLoaded] = useState(false);\n const [timeRange, setTimeRange] = useState<\"6h\" | \"12h\" | \"24h\">(\"24h\");\n\n // Load Chart.js dynamically\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 // Initialize and update chart\n useEffect(() => {\n if (!chartLoaded || !canvasRef.current) return;\n\n // Filter readings based on time range\n const now = Date.now();\n const rangeMs = {\n \"6h\": 6 * 60 * 60 * 1000,\n \"12h\": 12 * 60 * 60 * 1000,\n \"24h\": 24 * 60 * 60 * 1000,\n };\n const cutoff = now - rangeMs[timeRange];\n\n const filteredReadings = readings.filter(\n (r) => new Date(r.timestamp).getTime() >= cutoff\n );\n\n // Prepare data\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);\n const humidityData = filteredReadings.map((r) => r.humidity);\n\n // Create or update chart\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.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: \"Temperature (°F)\",\n data: tempData,\n borderColor: \"#ef4444\",\n backgroundColor: \"rgba(239, 68, 68, 0.1)\",\n yAxisID: \"y\",\n tension: 0.3,\n pointRadius: 2,\n fill: true,\n },\n {\n label: \"Humidity (%)\",\n data: humidityData,\n borderColor: \"#3b82f6\",\n backgroundColor: \"rgba(59, 130, 246, 0.1)\",\n yAxisID: \"y1\",\n tension: 0.3,\n pointRadius: 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 scales: {\n x: {\n grid: { color: \"#374151\" },\n ticks: { color: \"#9ca3af\", maxTicksLimit: 12 },\n },\n y: {\n type: \"linear\",\n position: \"left\",\n min: 95,\n max: 110,\n grid: { color: \"#374151\" },\n ticks: { color: \"#ef4444\" },\n title: {\n display: true,\n text: \"Temperature (°F)\",\n color: \"#ef4444\",\n },\n },\n y1: {\n type: \"linear\",\n position: \"right\",\n min: 30,\n max: 90,\n grid: { drawOnChartArea: false },\n ticks: { color: \"#3b82f6\" },\n title: {\n display: true,\n text: \"Humidity (%)\",\n color: \"#3b82f6\",\n },\n },\n },\n plugins: {\n legend: {\n labels: { color: \"#e5e7eb\" },\n },\n tooltip: {\n backgroundColor: \"#1f2937\",\n borderColor: \"#374151\",\n borderWidth: 1,\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, 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 {([\"6h\", \"12h\", \"24h\"] as const).map((range) => (\n setTimeRange(range)}\n className={`px-3 py-1 rounded text-sm transition ${\n timeRange === range\n ? \"bg-blue-600 text-white\"\n : \"bg-gray-700 text-gray-300 hover:bg-gray-600\"\n }`}\n >\n {range}\n \n ))}\n

\n {chartLoaded ? (\n

\n ) : (\n

\n Loading chart...\n

\n )}\n

\n\n {/* Reference lines legend */}\n

\n Ideal temp range (101-102°F)\n

\n );\n}\n",[],[169,294,296],"31c5cd46-f5bc-11f0-9ddc-42dde27851f2","Header.tsx","31c5ce40-f5bc-11f0-9ddc-42dde27851f2",17,["D",1768884908600],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\n\ninterface Props {\n lastUpdate: Date;\n}\n\nexport function Header({ lastUpdate }: Props) {\n const formatTime = (date: Date) => {\n return date.toLocaleTimeString(\"en-US\", {\n hour: \"2-digit\",\n minute: \"2-digit\",\n });\n };\n\n return (\n

\n 🥚\n

Quail Incubator Monitor

Coturnix Quail • 17-Day Incubation

Last updated

{formatTime(lastUpdate)}

\n );\n}\n",[],[169,294,304],"31a61122-f5bc-11f0-aedd-42dde27851f2","DailyTips.tsx","31a61230-f5bc-11f0-aedd-42dde27851f2",12,["D",1768884908397],"/** @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 phaseColors: Record = {\n \"Pre-incubation\": \"border-gray-500\",\n Setup: \"border-blue-500\",\n \"Early Development\": \"border-blue-400\",\n \"Mid Development\": \"border-purple-500\",\n \"Late Development\": \"border-orange-500\",\n Lockdown: \"border-yellow-500\",\n \"Hatch Day\": \"border-green-500\",\n \"Post-Hatch\": \"border-green-400\",\n Complete: \"border-gray-500\",\n };\n\n const phaseEmojis: Record = {\n \"Pre-incubation\": \"⏳\",\n Setup: \"🔧\",\n \"Early Development\": \"🌱\",\n \"Mid Development\": \"📈\",\n \"Late Development\": \"🔍\",\n Lockdown: \"🔒\",\n \"Hatch Day\": \"🐣\",\n \"Post-Hatch\": \"🐤\",\n Complete: \"✅\",\n };\n\n const borderColor = phaseColors[tip.phase] || \"border-gray-500\";\n const emoji = phaseEmojis[tip.phase] || \"📋\";\n\n return (\n \n

\n {emoji} Today's Tasks\n {tip.isSpecialDay && (\n \n ⭐ Special Day\n \n )}\n

\n Day {tip.day} • {tip.phase} Phase\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 {/* Quick tips based on phase */}\n {tip.phase === \"Lockdown\" && (\n

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

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

\n 💡 Tip: It can take 12-24 hours from first pip to\n full hatch. The struggle is necessary for the chick's development.\n Only intervene after 24+ hours if no progress is made.\n

\n )}\n \n );\n}\n",[],[169,294,312],"31b861c4-f5bc-11f0-97e8-42dde27851f2","CurrentReadings.tsx","31b86278-f5bc-11f0-97e8-42dde27851f2",16,["D",1768884908451],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\n\ninterface SensorReading {\n temperatureC: number;\n temperatureF: number;\n humidity: number;\n batteryVoltage: number;\n rssi?: number;\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}\n\nexport function CurrentReadings({ reading, alerts }: Props) {\n if (!reading) {\n return (\n

Current Readings

📡

Waiting for sensor data...

\n Make sure your LHT65 is configured and transmitting\n

\n );\n }\n\n const tempStatus = alerts?.temperature.status || \"ideal\";\n const humidityStatus = alerts?.humidity.status || \"ideal\";\n const humidityTarget = alerts?.humidity.target || { min: 45, max: 55 };\n\n const tempColorMap = {\n \"critical-low\": \"text-blue-500\",\n \"warning-low\": \"text-yellow-500\",\n ideal: \"text-green-500\",\n \"warning-high\": \"text-yellow-500\",\n \"critical-high\": \"text-red-500\",\n };\n\n const tempBgMap = {\n \"critical-low\": \"bg-blue-500/10 border-blue-500/30\",\n \"warning-low\": \"bg-yellow-500/10 border-yellow-500/30\",\n ideal: \"bg-green-500/10 border-green-500/30\",\n \"warning-high\": \"bg-yellow-500/10 border-yellow-500/30\",\n \"critical-high\": \"bg-red-500/10 border-red-500/30\",\n };\n\n const humidityColorMap = {\n low: \"text-yellow-500\",\n ideal: \"text-blue-400\",\n high: \"text-yellow-500\",\n };\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 return (\n

Current Readings

\n\n

\n {/* Temperature */}\n

\n {reading.temperatureF.toFixed(1)}°F\n

\n ({reading.temperatureC.toFixed(1)}°C)\n

Temperature

Target: 101-102°F

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

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

Humidity

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

\n\n {/* Footer info */}\n

\n Battery: \n \n {reading.batteryVoltage.toFixed(2)}V\n \n

\n {reading.rssi !== undefined && (\n

\n Signal: \n {reading.rssi} dBm\n

\n )}\n

\n At: \n {formatTime(reading.timestamp)}\n

\n );\n}\n",[],[169,294,320],"3199d010-f5bc-11f0-aedd-42dde27851f2","App.tsx","3199d0ce-f5bc-11f0-aedd-42dde27851f2",11,["D",1768884908306],"/** @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 DashboardData {\n currentReading: SensorReading | null;\n incubationStatus: IncubationStatusData;\n alerts: AlertThresholds | null;\n recentReadings: SensorReading[];\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 [lastUpdate, setLastUpdate] = useState(new Date());\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] = await Promise.all([\n fetch(\"/api/status\"),\n fetch(\"/api/readings?minutes=1440\"),\n ]);\n\n if (!statusRes.ok || !readingsRes.ok) {\n throw new Error(\"Failed to fetch data\");\n }\n\n const status = await statusRes.json();\n const recentReadings = await readingsRes.json();\n\n setData({\n ...status,\n recentReadings,\n });\n setLastUpdate(new Date());\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

🥚

Loading incubator data...

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

⚠️

Failed to load data

{error}

\n window.location.reload()}\n className=\"mt-4 px-4 py-2 bg-blue-600 rounded-lg hover:bg-blue-700 transition\"\n >\n Retry\n \n

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

No data available

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

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

\n \n \n

\n\n

\n \n

\n\n \n\n \n

\n );\n}\n",[],[169,294,328],"31ae40e0-f5bc-11f0-9ddc-42dde27851f2","AlertBanner.tsx","31ae4180-f5bc-11f0-9ddc-42dde27851f2",14,["D",1768884908460],"/** @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 const isWarning = tempStatus === \"warning-low\" || tempStatus === \"warning-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 icon: \"🚨\",\n title: \"CRITICAL: 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 bgColor: \"bg-red-900/80\",\n borderColor: \"border-red-500\",\n };\n case \"critical-high\":\n return {\n icon: \"🚨\",\n title: \"CRITICAL: 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 bgColor: \"bg-red-900/80\",\n borderColor: \"border-red-500\",\n };\n case \"warning-low\":\n return {\n icon: \"⚠️\",\n title: \"Warning: Temperature Low\",\n message: `Temperature at ${alerts.temperature.current.toFixed(1)}°F is below optimal range.`,\n action: \"Consider adjusting heat source.\",\n bgColor: \"bg-yellow-900/60\",\n borderColor: \"border-yellow-500\",\n };\n case \"warning-high\":\n return {\n icon: \"⚠️\",\n title: \"Warning: Temperature High\",\n message: `Temperature at ${alerts.temperature.current.toFixed(1)}°F is above optimal range.`,\n action: \"Consider improving ventilation.\",\n bgColor: \"bg-yellow-900/60\",\n borderColor: \"border-yellow-500\",\n };\n default:\n return null;\n }\n };\n\n const alert = getMessage();\n if (!alert) return null;\n\n return (\n \n

\n {alert.icon}\n

{alert.title}

{alert.message}

{alert.action}

\n \n );\n}\n",[],[169,294,336],"31309302-f5bc-11f0-a7c1-42dde27851f2",6,["D",1768884907625],[212,213,214,215,216,217,218],[169,294],["D",1768884906906],[211,219,220],[169],"3216750c-f5bc-11f0-9470-42dde27851f2","index.http.tsx",30,["D",1768884908810],"http","// Main Hono HTTP entry point for Incubator Tracker\nimport { Hono } from \"npm: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 } from \"./database/queries.ts\";\nimport { calculateIncubationStatus, getCurrentDailyTip, getAlertThresholds } from \"./services/incubation.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Run migrations on startup\nawait runMigrations();\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 const alerts = currentReading\n ? getAlertThresholds(\n currentReading.temperatureF,\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 };\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",[],[175,352],"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",[],[175,369,361],"services","31fa7154-f5bc-11f0-b5fb-42dde27851f2","decoder.ts","31fa7226-f5bc-11f0-b5fb-42dde27851f2",26,["D",1768884908959],"// Dragino LHT65 LoRaWAN payload decoder\n// Decodes the internal SHT20 temperature and humidity sensor\nimport type { DecodedLHT65Payload } from \"../../shared/types.ts\";\n\n/**\n * Decode LHT65 base64 payload\n *\n * Byte structure (11 bytes total):\n * - Bytes 0-1: Battery Voltage (mV) - ((bytes[0] << 8 | bytes[1]) & 0x3FFF) / 1000\n * - Bytes 2-3: SHT20 Temperature - Signed 16-bit, divide by 100 for °C\n * - Bytes 4-5: SHT20 Humidity - (bytes[4] << 8 | bytes[5]) / 10 for %\n * - Byte 6: External Sensor Type - 0=None, 1=DS18B20\n * - Bytes 7-8: DS18B20 Temperature (if external sensor present)\n * - Bytes 9-10: Reserved/Status\n */\nexport function decodeLHT65Payload(base64Data: string): DecodedLHT65Payload {\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 if (bytes.length < 6) {\n throw new Error(`Invalid LHT65 payload: expected at least 6 bytes, got ${bytes.length}`);\n }\n\n // Battery voltage (bytes 0-1)\n // Bit 15-14 are status bits, bits 13-0 are voltage in mV\n const batteryRaw = (bytes[0] << 8) | bytes[1];\n const batteryVoltage = (batteryRaw & 0x3fff) / 1000;\n\n // SHT20 internal temperature (bytes 2-3) - signed 16-bit integer\n let tempRaw = (bytes[2] << 8) | bytes[3];\n // Handle negative temperatures (two's complement)\n if (tempRaw > 0x7fff) {\n tempRaw = tempRaw - 0x10000;\n }\n const temperatureCelsius = tempRaw / 100;\n\n // SHT20 internal humidity (bytes 4-5)\n const humidityRaw = (bytes[4] << 8) | bytes[5];\n const humidity = humidityRaw / 10;\n\n // External sensor type (byte 6) - only if we have enough bytes\n const externalSensorType = bytes.length > 6 ? bytes[6] & 0x7f : 0;\n\n // External DS18B20 temperature (bytes 7-8) if present\n let externalTemperature: number | undefined;\n if (externalSensorType === 1 && bytes.length > 8) {\n let extTempRaw = (bytes[7] << 8) | bytes[8];\n if (extTempRaw > 0x7fff) {\n extTempRaw = extTempRaw - 0x10000;\n }\n externalTemperature = extTempRaw / 100;\n }\n\n return {\n batteryVoltage,\n temperatureCelsius,\n humidity,\n externalSensorType,\n externalTemperature,\n };\n}\n\n/**\n * Validate decoded payload values are within reasonable ranges\n */\nexport function validatePayload(decoded: DecodedLHT65Payload): { valid: boolean; errors: string[] } {\n const errors: string[] = [];\n\n // Battery should be between 2.0V and 4.0V\n if (decoded.batteryVoltage < 2.0 || decoded.batteryVoltage > 4.0) {\n errors.push(`Battery voltage ${decoded.batteryVoltage}V outside expected range (2.0-4.0V)`);\n }\n\n // Temperature should be between -40°C and 85°C (SHT20 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",[],[175,369,371],"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",[],[175,369,379],"317da3cc-f5bc-11f0-9ddc-42dde27851f2",9,["D",1768884908132],[206,207,208],[175,369],"31ee89b6-f5bc-11f0-97e8-42dde27851f2","webhook.ts","31ee8a74-f5bc-11f0-97e8-42dde27851f2","3163c466-f5bc-11f0-9a10-42dde27851f2",24,["D",1768884908881],"// ChirpStack webhook handler for Dragino LHT65\nimport { Hono } from \"npm:hono@3.11.7\";\nimport { decodeLHT65Payload, validatePayload } from \"../services/decoder.ts\";\nimport { insertReading } from \"../database/queries.ts\";\nimport { checkAndSendAlerts } from \"../services/alerts.ts\";\nimport { calculateIncubationStatus } from \"../services/incubation.ts\";\nimport { celsiusToFahrenheit } 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 // Decode the LHT65 payload\n const decoded = decodeLHT65Payload(payload.data);\n\n // Validate decoded values\n const validation = validatePayload(decoded);\n if (!validation.valid) {\n console.warn(\"Payload validation warnings:\", validation.errors);\n }\n\n const temperatureF = celsiusToFahrenheit(decoded.temperatureCelsius);\n\n // Extract signal info from first gateway\n const rxInfo = payload.rxInfo?.[0];\n\n // Store in database\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 externalTempC: decoded.externalTemperature,\n rssi: rxInfo?.rssi,\n snr: rxInfo?.snr,\n rawPayload: payload.data,\n });\n\n // Check for alerts\n const status = calculateIncubationStatus();\n await checkAndSendAlerts(temperatureF, decoded.humidity, status.currentDay);\n\n return c.json({\n status: \"success\",\n decoded: {\n temperatureC: decoded.temperatureCelsius,\n temperatureF: temperatureF.toFixed(1),\n humidity: decoded.humidity,\n batteryVoltage: decoded.batteryVoltage,\n },\n day: status.currentDay,\n phase: status.phase,\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// Health check endpoint\nwebhookRouter.get(\"/health\", (c) => {\n return c.json({ status: \"ok\", timestamp: new Date().toISOString() });\n});\n",[],[175,400,392],"routes","31e96ac6-f5bc-11f0-b018-42dde27851f2","api.ts","31e96b7a-f5bc-11f0-b018-42dde27851f2",23,["D",1768884908846],"// Dashboard API endpoints\nimport { Hono } from \"npm:hono@3.11.7\";\nimport {\n getLatestReading,\n getRecentReadings,\n getReadingsInRange,\n getAlertHistory,\n} from \"../database/queries.ts\";\nimport {\n calculateIncubationStatus,\n getAlertThresholds,\n getCurrentDailyTip,\n} from \"../services/incubation.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 const alerts = currentReading\n ? getAlertThresholds(\n currentReading.temperatureF,\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 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 const { getDailyTip } = require(\"../../shared/dailyTips.ts\");\n return c.json(getDailyTip(day));\n});\n",[],[175,400,402],"3163c358-f5bc-11f0-9a10-42dde27851f2",8,["D",1768884907969],[203,204],[175,400],"31d98c00-f5bc-11f0-aedd-42dde27851f2","queries.ts","31d98cb4-f5bc-11f0-aedd-42dde27851f2","314929f8-f5bc-11f0-9ddc-42dde27851f2",20,["D",1768884908719],"// Database query functions for incubator tracking\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLES } from \"../../shared/constants.ts\";\nimport type { SensorReading } 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",[],[175,423,415],"database","31e39f74-f5bc-11f0-b5fb-42dde27851f2","migrations.ts","31e3a032-f5bc-11f0-b5fb-42dde27851f2",22,["D",1768884908808],"// 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 // 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",[],[175,423,425],"31492868-f5bc-11f0-9ddc-42dde27851f2",7,["D",1768884907798],[200,201],[175,423],["D",1768884907253],[199,202,205,209],[175],"31df697c-f5bc-11f0-97e8-42dde27851f2","settings.local.json","31df6a30-f5bc-11f0-97e8-42dde27851f2",21,["D",1768884908706],"{\n \"permissions\": {\n \"allow\": [\n \"WebSearch\",\n \"WebFetch(domain:www.chirpstack.io)\",\n \"WebFetch(domain:gist.github.com)\",\n \"Bash(vt push)\"\n ]\n }\n}\n",[],[181,441],["D",1768884907128],[197],[181],["D",1768883246417],["D",1789527031073],{"_96":95,"_103":99},{"_96":95,"_97":-5,"_98":99,"_18":51,"_100":101,"_102":24},{"_13":85,"_31":86,"_40":39,"_87":41,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":42,"_94":95},"ctx",{"_78":-5,"_123":489,"_490":491,"_492":493,"_494":24,"_495":24,"_496":24,"_497":55,"_498":-5,"_499":-7,"_500":-7,"_501":59,"_502":24,"_503":24,"_504":-5,"_505":24,"_506":24,"_507":24,"_508":-5},"ENV",{"_460":461,"_462":463,"_464":86,"_465":466,"_467":468,"_469":470,"_471":472,"_473":474,"_475":476,"_477":478,"_479":480,"_481":482,"_483":484,"_485":486,"_487":488},"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 · v33