[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_293":294,"_295":296},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_220":-5,"_20":221,"_22":222,"_223":224,"_225":226,"_26":227,"_24":228,"_229":-5,"_230":-5,"_231":57,"_232":233,"_234":48,"_235":-5,"_236":-5,"_237":238},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","nmsilva","name","esp32-sensors","branchName","main","version","path","web","project",{"_36":163,"_13":14,"_49":164,"_165":-5,"_166":57,"_167":168,"_169":168,"_170":-5,"_171":-5,"_172":173,"_174":-5,"_175":57,"_176":-5,"_177":-5,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":-5,"_189":190,"_191":190,"_192":193,"_194":193,"_195":193,"_196":190,"_197":190,"_198":199,"_200":201,"_202":203,"_204":57},"tree",[82,83,84,85,86,87],"file",{"_36":76,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":77,"_47":48,"_49":78,"_17":79,"_52":80,"_54":-5,"_56":57,"_58":-5,"_18":81},"contents",[33,34,35],"upstream","pull","ahead","behind","envVars",{"_36":68,"_13":69,"_39":70,"_41":42,"_43":44,"_45":71,"_47":48,"_49":72,"_17":73,"_52":53,"_54":74,"_56":57,"_58":-5,"_18":75},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":63,"_47":48,"_49":64,"_17":65,"_52":53,"_54":66,"_56":57,"_58":-5,"_18":67},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_18":59},"id","f16ff4ae-1273-11f1-bd3b-42dde27851f2","sensors.tsx","fileId","7cb0ad98-1269-11f1-9769-42dde27851f2","parentId","ea4d9618-1273-11f1-a347-42dde27851f2","branchId","60c1671a-0d84-11f1-9715-42dde27851f2","branchVersion",66,"latest",true,"createdAt",["D",1772042460619],8,"fileType","http","content","/** @jsxImportSource https://esm.sh/react */\nimport React, { useCallback, useEffect, useState } from \"https://esm.sh/react\";\nimport { createRoot } from \"https://esm.sh/react-dom/client\";\n\nconst BASE_URL =\n \"https://nmsilva--70f64edc0e8a11f1840f42dde27851f2.web.val.run\";\nconst DASHBOARD_URL =\n \"https://nmsilva--915ee1020e8a11f1964f42dde27851f2.web.val.run\";\nconst SENSOR_EDIT_URL =\n \"https://nmsilva--63355eea127311f19e2442dde27851f2.web.val.run\";\nconst POLL_INTERVAL_MS = 60_000;\n\ntype Sensor = {\n id: number;\n name: string;\n port: string;\n created_at: string;\n};\n\nfunction formatDate(created_at: string) {\n const d = new Date(created_at + \"Z\");\n return d.toLocaleDateString([], {\n day: \"numeric\",\n month: \"short\",\n year: \"numeric\",\n });\n}\n\nfunction SensorCard({ sensor }: { sensor: Sensor }) {\n return (\n

\n {sensor.name}\n

\n \n {sensor.port}\n \n \n registered {formatDate(sensor.created_at)}\n \n

\n \n Edit\n \n \n View Dashboard →\n \n

\n );\n}\n\nfunction App() {\n const [sensors, setSensors] = useState(null);\n const [lastUpdated, setLastUpdated] = useState(null);\n const [error, setError] = useState(null);\n\n const fetchSensors = useCallback(async () => {\n try {\n const res = await fetch(`${BASE_URL}/sensors`);\n if (!res.ok) throw new Error(`HTTP ${res.status}`);\n const data: Sensor[] = await res.json();\n setSensors(data);\n setLastUpdated(new Date());\n setError(null);\n } catch (e: any) {\n setError(e.message);\n }\n }, []);\n\n useEffect(() => {\n fetchSensors();\n const id = setInterval(fetchSensors, POLL_INTERVAL_MS);\n return () => clearInterval(id);\n }, [fetchSensors]);\n\n return (\n

\n {/* Header */}\n

ESP32 Sensors

\n {sensors === null\n ? \"Loading…\"\n : `${sensors.length} sensor${\n sensors.length !== 1 ? \"s\" : \"\"\n } registered`}\n

\n {lastUpdated\n ? (\n <>\n Last updated\n
\n {lastUpdated.toLocaleTimeString()}\n \n )\n : (\n \"Loading…\"\n )}\n

\n\n {/* Error banner */}\n {error && (\n

\n ❌ {error}\n

\n )}\n\n {/* Sensor list */}\n {sensors === null\n ?

Loading…

\n : sensors.length === 0\n ? (\n

\n No sensors registered yet.\n

\n )\n : (\n

\n {sensors.map((s) => )}\n

\n )}\n

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\n\nif (typeof document !== \"undefined\") {\n client();\n}\n\nexport default async function server(request: Request): Promise {\n return new Response(\n `\n \n \n ESP32 Sensors\n \n \n \n \n

\n \n \n \n \n `,\n { headers: { \"Content-Type\": \"text/html\" } },\n );\n}","deleted",false,"label",[19,38],"ef8dadb6-1273-11f1-8f41-42dde27851f2","sensor-edit.tsx","63355eea-1273-11f1-9e24-42dde27851f2",65,["D",1772042457447],6,"/** @jsxImportSource https://esm.sh/react */\nimport React, { useEffect, useState } from \"https://esm.sh/react\";\nimport { createRoot } from \"https://esm.sh/react-dom/client\";\n\nconst BASE_URL =\n \"https://nmsilva--70f64edc0e8a11f1840f42dde27851f2.web.val.run\";\nconst SENSORS_URL =\n \"https://nmsilva--7cb0ad98126911f1976942dde27851f2.web.val.run\";\n\ntype Sensor = {\n id: number;\n name: string;\n port: string;\n created_at: string;\n};\n\nfunction formatDate(created_at: string) {\n const d = new Date(created_at + \"Z\");\n return d.toLocaleDateString([], {\n day: \"numeric\",\n month: \"short\",\n year: \"numeric\",\n });\n}\n\nfunction App() {\n const sensorId = new URLSearchParams(window.location.search).get(\"sensorId\");\n\n const [sensor, setSensor] = useState(null);\n const [loadError, setLoadError] = useState(null);\n\n // Edit form state\n const [editName, setEditName] = useState(\"\");\n const [editKey, setEditKey] = useState(\"\");\n const [saving, setSaving] = useState(false);\n const [saveError, setSaveError] = useState(null);\n const [saveSuccess, setSaveSuccess] = useState(false);\n\n // Delete section state\n const [deleteKey, setDeleteKey] = useState(\"\");\n const [deleting, setDeleting] = useState(false);\n const [deleteError, setDeleteError] = useState(null);\n\n useEffect(() => {\n if (!sensorId) return;\n fetch(`${BASE_URL}/sensors/${sensorId}`)\n .then((r) => (r.ok ? r.json() : Promise.reject(`HTTP ${r.status}`)))\n .then((data) => {\n setSensor(data);\n setEditName(data.name);\n setLoadError(null);\n })\n .catch((e) => setLoadError(String(e)));\n }, [sensorId]);\n\n async function handleSave() {\n setSaving(true);\n setSaveError(null);\n try {\n const res = await fetch(`${BASE_URL}/sensors/${sensorId}`, {\n method: \"PATCH\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ access_key: editKey, name: editName }),\n });\n const data = await res.json();\n if (!res.ok) throw new Error(data.error ?? `HTTP ${res.status}`);\n setSensor(data);\n setSaveSuccess(true);\n setTimeout(() => setSaveSuccess(false), 3000);\n } catch (e: any) {\n setSaveError(e.message);\n } finally {\n setSaving(false);\n }\n }\n\n async function handleDelete() {\n setDeleting(true);\n setDeleteError(null);\n try {\n const res = await fetch(`${BASE_URL}/sensors/${sensorId}`, {\n method: \"DELETE\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ access_key: deleteKey }),\n });\n const data = await res.json();\n if (!res.ok) throw new Error(data.error ?? `HTTP ${res.status}`);\n window.location.href = SENSORS_URL;\n } catch (e: any) {\n setDeleteError(e.message);\n setDeleting(false);\n }\n }\n\n if (!sensorId) {\n return (\n

\n Missing sensorId query parameter.\n

\n \n ← Back to Sensors\n \n

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

\n {/* Back link */}\n \n ← Back to Sensors\n \n\n {/* Loading state */}\n {!sensor && !loadError && (\n

Loading…

\n )}\n\n {/* Load error */}\n {loadError && (\n

\n ❌ {loadError}\n

\n )}\n\n {sensor && (\n <>\n {/* Header */}\n

\n {sensor.name}\n

\n \n {sensor.port}\n \n \n registered {formatDate(sensor.created_at)}\n \n

\n\n {/* Edit section */}\n

\n \n Edit sensor\n \n\n

\n Name\n setEditName(e.target.value)}\n className=\"w-full rounded-lg bg-gray-900 border border-gray-600 text-white px-3 py-2 text-sm focus:outline-none focus:ring-2 focus:ring-indigo-500\"\n />\n

\n\n

\n Access key\n setEditKey(e.target.value)}\n placeholder=\"••••••••\"\n className=\"w-full rounded-lg bg-gray-900 border border-gray-600 text-white px-3 py-2 text-sm focus:outline-none focus:ring-2 focus:ring-indigo-500\"\n />\n

\n\n {saveSuccess && (\n

\n ✓ Saved!\n

\n )}\n {saveError && (\n

\n ❌ {saveError}\n

\n )}\n\n \n {saving ? \"Saving…\" : \"Save changes\"}\n \n

\n\n {/* Delete section */}\n

\n \n Danger zone\n \n

\n Deletes the sensor and all its readings. This cannot be undone.\n

\n\n

\n Access key\n setDeleteKey(e.target.value)}\n placeholder=\"••••••••\"\n className=\"w-full rounded-lg bg-gray-900 border border-gray-600 text-white px-3 py-2 text-sm focus:outline-none focus:ring-2 focus:ring-red-500\"\n />\n

\n\n {deleteError && (\n

\n ❌ {deleteError}\n

\n )}\n\n \n {deleting ? \"Deleting…\" : \"Delete sensor\"}\n \n

\n \n )}\n

\n \n \n \n \n `,\n { headers: { \"Content-Type\": \"text/html\" } },\n );\n}",[19,61],"ee337c34-1273-11f1-b64c-42dde27851f2","dashboard.tsx","915ee102-0e8a-11f1-964f-42dde27851f2",64,["D",1772042455177],13,"/** @jsxImportSource https://esm.sh/react */\nimport React, { useCallback, useEffect, useState } from \"https://esm.sh/react\";\nimport { createRoot } from \"https://esm.sh/react-dom/client\";\nimport {\n CartesianGrid,\n Legend,\n Line,\n LineChart,\n ResponsiveContainer,\n Tooltip,\n XAxis,\n YAxis,\n} from \"https://esm.sh/recharts\";\n\nconst BASE_URL =\n \"https://nmsilva--70f64edc0e8a11f1840f42dde27851f2.web.val.run\";\nconst SENSORS_URL =\n \"https://nmsilva--7cb0ad98126911f1976942dde27851f2.web.val.run\";\nconst POLL_INTERVAL_MS = 10_000;\n\nfunction formatTime(recorded_at: string) {\n const d = new Date(recorded_at + \"Z\"); // treat as UTC\n return d.toLocaleTimeString([], {\n hour: \"2-digit\",\n minute: \"2-digit\",\n second: \"2-digit\",\n });\n}\n\nfunction StatCard({\n label,\n value,\n unit,\n color,\n}: {\n label: string;\n value: number | null;\n unit: string;\n color: string;\n}) {\n return (\n

\n \n {label}\n \n \n {value != null ? value.toFixed(1) : \"—\"}\n {unit}\n \n

\n );\n}\n\nfunction App() {\n const sensorId = new URLSearchParams(window.location.search).get(\"sensorId\");\n\n const [sensorName, setSensorName] = useState(null);\n const [readings, setReadings] = useState([]);\n const [lastUpdated, setLastUpdated] = useState(null);\n const [error, setError] = useState(null);\n\n useEffect(() => {\n if (!sensorId) return;\n fetch(`${BASE_URL}/sensors/${sensorId}`)\n .then((r) => (r.ok ? r.json() : Promise.reject(`HTTP ${r.status}`)))\n .then((data) => setSensorName(data.name ?? data.port ?? null))\n .catch((e) => setError(String(e)));\n }, [sensorId]);\n\n const fetchData = useCallback(async () => {\n if (!sensorId) return;\n try {\n const res = await fetch(`${BASE_URL}/sensors/${sensorId}/readings`);\n if (!res.ok) throw new Error(`HTTP ${res.status}`);\n const data = await res.json();\n\n // Normalise: val town sqlite returns { columns, rows } or plain array\n let rows: any[] = [];\n if (Array.isArray(data)) {\n rows = data;\n } else if (data.rows) {\n // { columns: [...], rows: [[...], ...] }\n rows = data.rows;\n }\n\n // Sort ascending by recorded_at, keep last 50 points\n rows.sort((a, b) => a.recorded_at?.localeCompare(b.recorded_at));\n setReadings(rows.slice(-50));\n setLastUpdated(new Date());\n setError(null);\n } catch (e: any) {\n setError(e.message);\n }\n }, [sensorId]);\n\n useEffect(() => {\n fetchData();\n const id = setInterval(fetchData, POLL_INTERVAL_MS);\n return () => clearInterval(id);\n }, [fetchData]);\n\n if (!sensorId) {\n return (\n

\n Missing sensorId query parameter.\n

\n );\n }\n\n const latest = readings.at(-1);\n\n const chartData = readings.map((r) => ({\n time: formatTime(r.recorded_at),\n temperature: Number(r.temperature),\n humidity: Number(r.humidity),\n }));\n\n console.log({ chartData, readings });\n\n return (\n

\n {/* Back link */}\n \n ← Back to Sensors\n \n\n {/* Header */}\n

\n ESP32 Sensor Dashboard\n

\n {sensorName ?? latest?.port ?? \"—\"} · auto-refresh every{\" \"}\n {POLL_INTERVAL_MS / 1000}s\n

\n {lastUpdated\n ? (\n <>\n Last updated\n
\n {lastUpdated.toLocaleTimeString()}\n \n )\n : (\n \"Loading…\"\n )}\n

\n\n {/* Error banner */}\n {error && (\n

\n ❌ {error}\n

\n )}\n\n {/* Stat cards */}\n

\n \n \n

\n \n Readings\n \n \n {readings.length}\n \n

\n\n {/* Chart */}\n

\n History\n

\n {readings.length === 0\n ? (\n

\n No data yet…\n

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

\n \n \n \n \n `,\n { headers: { \"Content-Type\": \"text/html\" } },\n );\n}",[19,69],"ebf97ee6-1273-11f1-af25-42dde27851f2",63,["D",1772042451459],1,"directory",[19],{"_36":146,"_13":147,"_39":148,"_41":-5,"_43":44,"_45":149,"_47":48,"_49":150,"_17":79,"_52":80,"_54":-5,"_56":57,"_58":-5,"_94":151,"_18":152},{"_36":128,"_13":129,"_39":130,"_41":-5,"_43":44,"_45":131,"_47":48,"_49":132,"_17":79,"_52":80,"_54":-5,"_56":57,"_58":-5,"_94":133,"_18":134},{"_36":76,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":77,"_47":48,"_49":113,"_17":79,"_52":80,"_54":-5,"_56":57,"_58":-5,"_94":114,"_18":115},{"_36":105,"_13":106,"_39":107,"_41":-5,"_43":44,"_45":108,"_47":48,"_49":109,"_17":65,"_52":53,"_54":110,"_56":57,"_58":-5,"_94":111,"_18":112},{"_36":97,"_13":98,"_39":99,"_41":-5,"_43":44,"_45":100,"_47":48,"_49":101,"_17":65,"_52":53,"_54":102,"_56":57,"_58":-5,"_94":103,"_18":104},{"_36":88,"_13":89,"_39":90,"_41":-5,"_43":44,"_45":91,"_47":48,"_49":92,"_17":65,"_52":53,"_54":93,"_56":57,"_58":-5,"_94":95,"_18":96},"88bccde8-1263-11f1-88af-42dde27851f2","main.ts","60c307fa-0d84-11f1-9715-42dde27851f2",31,["D",1772035413014],"// @ts-ignore — npm: specifier resolved by Val Town's Deno runtime\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst ACCESS_KEY = \"b31c58a5-75b8-4b93-9e4a-51cf5204cf24\";\n\nexport default async function (req) {\n // Only accept POST\n if (req.method !== \"POST\") {\n return Response.json({ error: \"Method not allowed\" }, { status: 405 });\n }\n\n let body;\n try {\n body = await req.json();\n } catch {\n return Response.json({ error: \"Invalid JSON body\" }, { status: 400 });\n }\n\n console.log(body);\n\n const { access_key, port, temperature, humidity } = body;\n\n // Validate access key\n if (access_key !== ACCESS_KEY) {\n return Response.json({ error: \"Unauthorized\" }, { status: 401 });\n }\n\n // Validate required fields\n if (!port || temperature == null || humidity == null) {\n return Response.json(\n { error: \"Missing required fields: port, temperature, humidity\" },\n { status: 400 },\n );\n }\n\n // ── Table creation (runs on every cold start) ──────────────────────────────\n\n // Sensors lookup table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS sensors (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n port TEXT NOT NULL UNIQUE,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )\n `);\n\n // Sensor readings table (original schema, kept for cold-start idempotency)\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS sensor_readings (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n port TEXT NOT NULL,\n temperature REAL NOT NULL,\n humidity REAL NOT NULL,\n recorded_at TEXT NOT NULL DEFAULT (datetime('now'))\n )\n `);\n\n // ── One-time migration: add sensor_id column if not present ────────────────\n const tableInfo = await sqlite.execute(`PRAGMA table_info(sensor_readings)`);\n const columns = tableInfo.rows.map((r: unknown[]) => r[1]); // column index 1 = name\n\n if (!columns.includes(\"sensor_id\")) {\n // Back-fill sensors from distinct ports already in the table\n await sqlite.execute(`\n INSERT OR IGNORE INTO sensors (name, port)\n SELECT DISTINCT port, port FROM sensor_readings\n `);\n // Add sensor_id column\n await sqlite.execute(\n `ALTER TABLE sensor_readings ADD COLUMN sensor_id INTEGER`,\n );\n // Back-fill sensor_id on existing rows\n await sqlite.execute(`\n UPDATE sensor_readings\n SET sensor_id = (SELECT id FROM sensors WHERE port = sensor_readings.port)\n `);\n }\n\n // ── Upsert sensor and resolve its id ──────────────────────────────────────\n await sqlite.execute(\n `INSERT OR IGNORE INTO sensors (name, port) VALUES (?, ?)`,\n [port, port],\n );\n const sensorRow = await sqlite.execute(\n `SELECT id FROM sensors WHERE port = ?`,\n [port],\n );\n const sensor_id = sensorRow.rows[0][0];\n\n // ── Insert reading ─────────────────────────────────────────────────────────\n await sqlite.execute(\n `INSERT INTO sensor_readings (sensor_id, port, temperature, humidity)\n VALUES (?, ?, ?, ?)`,\n [sensor_id, port, temperature, humidity],\n );\n\n return Response.json({ ok: true }, { status: 201 });\n}","children",[],[89],"e60cad56-1259-11f1-92e8-42dde27851f2","configs.ts","45acae50-0e8b-11f1-8f1e-42dde27851f2",29,["D",1772031274607],"// Learn more: https://docs.val.town/vals/http/\nexport default async function (req: Request): Promise {\n return Response.json({\n \"send_interval\": 30000,\n \"sensor_pins\": [4],\n \"access_key\": \"b31c58a5-75b8-4b93-9e4a-51cf5204cf24\",\n \"data_url\": \"https://nmsilva--60c307fa0d8411f1971542dde27851f2.web.val.run\",\n });\n}",[],[98],"7d001726-1263-11f1-9203-42dde27851f2","api.ts","70f64edc-0e8a-11f1-840f-42dde27851f2",30,["D",1772035393325],"// @ts-ignore — npm: specifier resolved by Val Town's Deno runtime\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n// @ts-ignore — npm: specifier resolved by Val Town's Deno runtime\nimport { cors } from \"npm:hono/cors\";\n// @ts-ignore — npm: specifier resolved by Val Town's Deno runtime\nimport { Hono } from \"npm:hono@4.0.8\";\n\nconst ACCESS_KEY = \"b31c58a5-75b8-4b93-9e4a-51cf5204cf24\";\n\n// eslint-disable-next-line @typescript-eslint/no-explicit-any\nconst app = new Hono();\n\napp.use(\"*\", cors());\n\n// Returns a positive integer or null if raw is not a valid id\nfunction parseId(raw: string): number | null {\n const n = parseInt(raw, 10);\n return Number.isInteger(n) && n > 0 && String(n) === raw ? n : null;\n}\n\n// GET /sensors\napp.get(\"/sensors\", async (c: any) => {\n const { rows } = await sqlite.execute(\n `SELECT id, name, port, created_at FROM sensors ORDER BY id ASC`,\n );\n return c.json(\n rows.map((r: unknown[]) => ({\n id: r[0],\n name: r[1],\n port: r[2],\n created_at: r[3],\n })),\n );\n});\n\n// GET /sensors/:id\napp.get(\"/sensors/:id\", async (c: any) => {\n const id = parseId(c.req.param(\"id\"));\n if (id === null) return c.json({ error: \"Invalid sensor id\" }, 400);\n\n const { rows } = await sqlite.execute(\n `SELECT id, name, port, created_at FROM sensors WHERE id = ?`,\n [id],\n );\n if (rows.length === 0) return c.json({ error: \"Sensor not found\" }, 404);\n\n const r = rows[0] as unknown[];\n return c.json({ id: r[0], name: r[1], port: r[2], created_at: r[3] });\n});\n\n// PATCH /sensors/:id\napp.patch(\"/sensors/:id\", async (c: any) => {\n const id = parseId(c.req.param(\"id\"));\n if (id === null) return c.json({ error: \"Invalid sensor id\" }, 400);\n\n let body: Record;\n try {\n body = await c.req.json();\n } catch {\n return c.json({ error: \"Invalid JSON body\" }, 400);\n }\n\n if (body.access_key !== ACCESS_KEY) {\n return c.json({ error: \"Unauthorized\" }, 401);\n }\n if (!body.name) {\n return c.json({ error: \"Missing required field: name\" }, 400);\n }\n\n const check = await sqlite.execute(`SELECT id FROM sensors WHERE id = ?`, [\n id,\n ]);\n if (check.rows.length === 0) {\n return c.json({ error: \"Sensor not found\" }, 404);\n }\n\n await sqlite.execute(`UPDATE sensors SET name = ? WHERE id = ?`, [\n body.name,\n id,\n ]);\n\n const { rows } = await sqlite.execute(\n `SELECT id, name, port, created_at FROM sensors WHERE id = ?`,\n [id],\n );\n const r = rows[0] as unknown[];\n return c.json({ id: r[0], name: r[1], port: r[2], created_at: r[3] });\n});\n\n// DELETE /sensors/:id\napp.delete(\"/sensors/:id\", async (c: any) => {\n const id = parseId(c.req.param(\"id\"));\n if (id === null) return c.json({ error: \"Invalid sensor id\" }, 400);\n\n let body: Record;\n try {\n body = await c.req.json();\n } catch {\n return c.json({ error: \"Invalid JSON body\" }, 400);\n }\n\n if (body.access_key !== ACCESS_KEY) {\n return c.json({ error: \"Unauthorized\" }, 401);\n }\n\n const check = await sqlite.execute(`SELECT id FROM sensors WHERE id = ?`, [\n id,\n ]);\n if (check.rows.length === 0) {\n return c.json({ error: \"Sensor not found\" }, 404);\n }\n\n const countResult = await sqlite.execute(\n `SELECT COUNT(*) FROM sensor_readings WHERE sensor_id = ?`,\n [id],\n );\n const readings_removed = (countResult.rows[0] as unknown[])[0];\n\n await sqlite.execute(`DELETE FROM sensor_readings WHERE sensor_id = ?`, [id]);\n await sqlite.execute(`DELETE FROM sensors WHERE id = ?`, [id]);\n\n return c.json({ deleted: { sensor_id: id, readings_removed } });\n});\n\n// GET /sensors/:id/readings\napp.get(\"/sensors/:id/readings\", async (c: any) => {\n const id = parseId(c.req.param(\"id\"));\n if (id === null) return c.json({ error: \"Invalid sensor id\" }, 400);\n\n const check = await sqlite.execute(`SELECT id FROM sensors WHERE id = ?`, [\n id,\n ]);\n if (check.rows.length === 0) {\n return c.json({ error: \"Sensor not found\" }, 404);\n }\n\n const rawLimit = c.req.query(\"limit\");\n const limit = rawLimit\n ? Math.min(Math.max(parseInt(rawLimit, 10) || 100, 1), 500)\n : 100;\n\n const { rows } = await sqlite.execute(\n `SELECT id, sensor_id, port, temperature, humidity, recorded_at\n FROM sensor_readings\n WHERE sensor_id = ?\n ORDER BY recorded_at DESC\n LIMIT ?`,\n [id, limit],\n );\n return c.json(\n rows.map((r: unknown[]) => ({\n id: r[0],\n sensor_id: r[1],\n port: r[2],\n temperature: r[3],\n humidity: r[4],\n recorded_at: r[5],\n })),\n );\n});\n\nexport default app.fetch;",[],[106],["D",1772042451459],[116,117,118],[19],{"_36":68,"_13":69,"_39":70,"_41":42,"_43":44,"_45":71,"_47":48,"_49":125,"_17":73,"_52":53,"_54":74,"_56":57,"_58":-5,"_94":126,"_18":127},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":63,"_47":48,"_49":122,"_17":65,"_52":53,"_54":66,"_56":57,"_58":-5,"_94":123,"_18":124},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":119,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_94":120,"_18":121},["D",1772042460619],[],[19,38],["D",1772042457447],[],[19,61],["D",1772042455177],[],[19,69],"f473cf6c-126a-11f1-b1ed-42dde27851f2","fake","f23bf454-126a-11f1-b98f-42dde27851f2",47,["D",1772038600206],[135],[129],{"_36":136,"_13":137,"_39":138,"_41":130,"_43":44,"_45":139,"_47":48,"_49":140,"_17":141,"_52":142,"_54":143,"_56":57,"_58":-5,"_94":144,"_18":145},"0a012960-126b-11f1-9236-42dde27851f2","fake_sensors_valtown.ts","f612b0a4-126a-11f1-9ddb-42dde27851f2",51,["D",1772038636368],3,"interval","/**\n * fake_sensors_valtown.ts — Val Town scheduled val\n *\n * Simulates N ESP32-like sensors posting to the data endpoint.\n * Deploy as a Val Town **cron** val (e.g. every 5 minutes).\n *\n * Val Town docs: https://docs.val.town/types/cron/\n */\n\nconst DATA_URL =\n \"https://nmsilva--60c307fa0d8411f1971542dde27851f2.web.val.run\";\nconst ACCESS_KEY = \"b31c58a5-75b8-4b93-9e4a-51cf5204cf24\";\n\nconst SENSOR_COUNT = 3;\n\n// Build sensor port identifiers: GPIO4, GPIO5, GPIO6, …\nconst sensors = Array.from({ length: SENSOR_COUNT }, (_, i) => `GPIO${4 + i}`);\n\nfunction randomBetween(min: number, max: number): number {\n return Math.round((Math.random() * (max - min) + min) * 10) / 10;\n}\n\nasync function sendReading(port: string): Promise {\n const payload = {\n access_key: ACCESS_KEY,\n port,\n temperature: randomBetween(20, 25),\n humidity: randomBetween(50, 60),\n };\n\n const res = await fetch(DATA_URL, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(payload),\n });\n const data = await res.json();\n console.log(\n `[${new Date().toISOString()}] ${port} ${res.status} ` +\n `temp=${payload.temperature}°C hum=${payload.humidity}% →`,\n data,\n );\n}\n\n// Val Town cron entry point — export a default async function\nexport default async function (): Promise {\n console.log(`Simulating ${SENSOR_COUNT} sensor(s): ${sensors.join(\", \")}`);\n console.log(`Target: ${DATA_URL}`);\n\n await Promise.all(sensors.map(sendReading));\n\n console.log(\"Done.\");\n}",[],[129,137],"12fdeda0-1266-11f1-a64e-42dde27851f2","database","10001ae2-1266-11f1-8a9e-42dde27851f2",34,["D",1772036503963],[153],[147],{"_36":154,"_13":155,"_39":156,"_41":148,"_43":44,"_45":157,"_47":48,"_49":158,"_17":159,"_52":142,"_54":160,"_56":57,"_58":-5,"_94":161,"_18":162},"6438c5be-1266-11f1-b1be-42dde27851f2","migrations.ts","16a3eedc-1266-11f1-98b0-42dde27851f2",39,["D",1772036640243],4,"// @ts-ignore — npm: specifier resolved by Val Town's Deno runtime\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n/**\n * Runs all database migrations in order.\n * Safe to call on every cold start — all operations are idempotent.\n *\n * Migration 0 — initial schema\n * Creates `sensors` and `sensor_readings` tables if they do not exist.\n *\n * Migration 1 — add sensor_id to sensor_readings\n * Detects the old schema (no `sensor_id` column), back-fills `sensors`\n * from distinct ports, adds the column, and back-fills the FK values.\n */\nexport async function runMigrations(): Promise {\n // ── Migration 0: initial schema ────────────────────────────────────────────\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS sensors (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n port TEXT NOT NULL UNIQUE,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS sensor_readings (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n port TEXT NOT NULL,\n temperature REAL NOT NULL,\n humidity REAL NOT NULL,\n recorded_at TEXT NOT NULL DEFAULT (datetime('now'))\n )\n `);\n\n // ── Migration 1: add sensor_id column ─────────────────────────────────────\n\n const tableInfo = await sqlite.execute(`PRAGMA table_info(sensor_readings)`);\n const columns = tableInfo.rows.map((r: unknown[]) => r[1]); // index 1 = name\n\n if (!columns.includes(\"sensor_id\")) {\n // Back-fill sensors from distinct ports already in the table\n await sqlite.execute(`\n INSERT OR IGNORE INTO sensors (name, port)\n SELECT DISTINCT port, port FROM sensor_readings\n `);\n\n await sqlite.execute(\n `ALTER TABLE sensor_readings ADD COLUMN sensor_id INTEGER`,\n );\n\n await sqlite.execute(`\n UPDATE sensor_readings\n SET sensor_id = (SELECT id FROM sensors WHERE port = sensor_readings.port)\n `);\n }\n}\n\n// Learn more: https://docs.val.town/vals/cron/\nexport default async function () {\n await runMigrations();\n\n console.log(`Migrations complete!`);\n}",[],[147,155],"60c0f244-0d84-11f1-9715-42dde27851f2",["D",1771499763519],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","1e4d2157-cdd6-42c8-a0ed-7d707498307a","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","eec31d76-5f30-4859-9ad3-ead49204cdd9","tursoName","60c0f2440d8411f1971542dde27851f2","tursoHostname","60c0f2440d8411f1971542dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789528252206],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_219":215},"org",{"_11":12,"_213":-5,"_214":215,"_172":173,"_216":217,"_218":57},"branch",{"_17":46,"_13":16,"_36":44,"_205":163,"_206":-5,"_207":-5,"_208":-5,"_209":-5,"_210":-5,"_211":14,"_212":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yZlNYVHdvT3FqSExKd0Y5Qmx5WllLWVR6UjMifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":163,"_13":14,"_49":288,"_165":-5,"_166":57,"_167":168,"_169":168,"_170":-5,"_171":-5,"_172":173,"_174":-5,"_175":57,"_176":-5,"_177":-5,"_178":179,"_180":181,"_182":183,"_184":185,"_186":289,"_188":-5,"_189":190,"_191":190,"_192":193,"_194":193,"_195":193,"_196":190,"_197":190,"_198":290,"_200":291,"_202":292,"_204":57},[255,257,259,263,264,265],"files",[255,256,257,258,259,260,261,262,263,264,265],"counts",{"_246":179,"_247":79,"_248":179,"_32":249,"_250":251},[240,241,242],{"_36":76,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":77,"_47":48,"_49":78,"_17":79,"_52":80,"_54":-5,"_56":57,"_58":-5,"_18":239},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],{"_36":68,"_13":69,"_39":70,"_41":42,"_43":44,"_45":71,"_47":48,"_49":72,"_17":73,"_52":53,"_54":74,"_56":57,"_58":-5,"_18":245},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":63,"_47":48,"_49":64,"_17":65,"_52":53,"_54":66,"_56":57,"_58":-5,"_18":244},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_18":243},[19,38],[19,61],[19,69],"pulls","branches","forks",{"_252":179,"_254":179},"connections",{"_252":179,"_253":179},"count","unfilledCount","emptyCount",{"_36":146,"_13":147,"_39":148,"_41":-5,"_43":44,"_45":149,"_47":48,"_49":150,"_17":79,"_52":80,"_54":-5,"_56":57,"_58":-5,"_94":286,"_18":287},{"_36":154,"_13":155,"_39":156,"_41":148,"_43":44,"_45":157,"_47":48,"_49":158,"_17":159,"_52":142,"_54":160,"_56":57,"_58":-5,"_94":284,"_18":285},{"_36":128,"_13":129,"_39":130,"_41":-5,"_43":44,"_45":131,"_47":48,"_49":132,"_17":79,"_52":80,"_54":-5,"_56":57,"_58":-5,"_94":282,"_18":283},{"_36":136,"_13":137,"_39":138,"_41":130,"_43":44,"_45":139,"_47":48,"_49":140,"_17":141,"_52":142,"_54":143,"_56":57,"_58":-5,"_94":280,"_18":281},{"_36":76,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":77,"_47":48,"_49":113,"_17":79,"_52":80,"_54":-5,"_56":57,"_58":-5,"_94":278,"_18":279},{"_36":68,"_13":69,"_39":70,"_41":42,"_43":44,"_45":71,"_47":48,"_49":125,"_17":73,"_52":53,"_54":74,"_56":57,"_58":-5,"_94":276,"_18":277},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":63,"_47":48,"_49":122,"_17":65,"_52":53,"_54":66,"_56":57,"_58":-5,"_94":274,"_18":275},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":119,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_94":272,"_18":273},{"_36":105,"_13":106,"_39":107,"_41":-5,"_43":44,"_45":108,"_47":48,"_49":109,"_17":65,"_52":53,"_54":110,"_56":57,"_58":-5,"_94":270,"_18":271},{"_36":97,"_13":98,"_39":99,"_41":-5,"_43":44,"_45":100,"_47":48,"_49":101,"_17":65,"_52":53,"_54":102,"_56":57,"_58":-5,"_94":268,"_18":269},{"_36":88,"_13":89,"_39":90,"_41":-5,"_43":44,"_45":91,"_47":48,"_49":92,"_17":65,"_52":53,"_54":93,"_56":57,"_58":-5,"_94":266,"_18":267},[],[89],[],[98],[],[106],[],[19,38],[],[19,61],[],[19,69],[260,261,262],[19],[],[129,137],[258],[129],[],[147,155],[256],[147],["D",1771499763519],["D",1789528252206],{"_11":12,"_219":215},{"_11":12,"_213":-5,"_214":215,"_172":173,"_216":217,"_218":57},{"_17":46,"_13":16,"_36":44,"_205":163,"_206":-5,"_207":-5,"_208":-5,"_209":-5,"_210":-5,"_211":14,"_212":12},"ctx",{"_198":-5,"_236":326,"_327":328,"_329":330,"_331":57,"_332":57,"_333":57,"_334":48,"_335":-5,"_336":-7,"_337":-7,"_338":179,"_339":57,"_340":57,"_341":-5,"_342":57,"_343":57,"_344":57,"_345":-5},"ENV",{"_297":298,"_299":300,"_301":16,"_302":303,"_304":305,"_306":307,"_308":309,"_310":311,"_312":313,"_314":315,"_316":317,"_318":319,"_320":321,"_322":323,"_324":325},"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"]