[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_239":240,"_241":242},"routes/_app.x.$handle.$name",{"_107":106,"_38":52,"_115":97,"_33":116,"_13":14,"_117":-5,"_11":118,"_119":120,"_121":122,"_123":124,"_125":126,"_26":-5,"_127":-5,"_128":-5,"_129":31,"_130":131,"_132":66,"_133":-5,"_134":-5,"_135":136},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_50":51,"_38":52,"_45":53,"_54":-5,"_55":31,"_56":57,"_58":57,"_59":60,"_61":-5,"_19":62,"_63":64,"_65":66,"_67":-5,"_68":-5,"_69":70,"_71":72,"_73":74,"_75":76,"_77":78,"_79":-5,"_80":81,"_82":81,"_83":84,"_85":84,"_86":84,"_87":81,"_88":81,"_89":90,"_91":92,"_93":94,"_95":31},"version",10,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","021bc48f-8953-4dff-a8db-1e28e711542e","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":39,"_40":41,"_42":44,"_45":46,"_47":14,"_48":49,"_30":31},"previous",{"_36":37,"_38":39,"_40":41,"_42":43},"deleted",false,"deletedHere","path","database/queries.ts","latestPath","fileId","366e7a14-33ce-11f1-8aa1-42b51c65c3df","name","queries.ts","fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { email } from \"https://esm.town/v/std/email\";\n\nexport interface Endpoint {\n id: number;\n name: string;\n url: string;\n alert_email: string | null;\n created_at: string;\n}\n\nexport interface Check {\n id: number;\n endpoint_id: number;\n status: number;\n response_time_ms: number;\n is_valid_json: number;\n response_body: string | null;\n changed: number;\n error: string | null;\n checked_at: string;\n}\n\nexport async function getAllEndpoints(): Promise {\n const res = await sqlite.execute(`SELECT * FROM endpoints ORDER BY created_at DESC`);\n return res.rows as unknown as Endpoint[];\n}\n\nexport async function getEndpointById(id: number): Promise {\n const res = await sqlite.execute({ sql: `SELECT * FROM endpoints WHERE id = ?`, args: [id] });\n return (res.rows as unknown as Endpoint[])[0] ?? null;\n}\n\nexport async function getLatestCheck(endpointId: number): Promise {\n const res = await sqlite.execute({\n sql: `SELECT * FROM checks WHERE endpoint_id = ? ORDER BY checked_at DESC LIMIT 1`,\n args: [endpointId],\n });\n return (res.rows as unknown as Check[])[0] ?? null;\n}\n\nexport async function getCheckHistory(endpointId: number, limit = 20): Promise {\n const res = await sqlite.execute({\n sql: `SELECT * FROM checks WHERE endpoint_id = ? ORDER BY checked_at DESC LIMIT ?`,\n args: [endpointId, limit],\n });\n return res.rows as unknown as Check[];\n}\n\nexport async function performCheck(endpoint: Endpoint): Promise {\n const start = Date.now();\n let status = 0;\n let isValidJson = false;\n let responseBody: string | null = null;\n let errorMsg: string | null = null;\n\n try {\n const res = await fetch(endpoint.url, { signal: AbortSignal.timeout(8000) });\n status = res.status;\n const elapsed = Date.now() - start;\n const text = await res.text();\n try {\n JSON.parse(text);\n isValidJson = true;\n responseBody = text;\n } catch {\n responseBody = text.slice(0, 2000); // store first 2kb even if invalid\n }\n\n // Compare with last check to detect changes\n const prev = await getLatestCheck(endpoint.id);\n const changed = prev && prev.response_body !== null && isValidJson\n ? (prev.response_body !== responseBody ? 1 : 0)\n : 0;\n\n const ins = await sqlite.execute({\n sql: `INSERT INTO checks (endpoint_id, status, response_time_ms, is_valid_json, response_body, changed, error)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n args: [endpoint.id, status, elapsed, isValidJson ? 1 : 0, responseBody, changed, null],\n });\n\n const check: Check = {\n id: Number(ins.lastInsertRowid),\n endpoint_id: endpoint.id,\n status,\n response_time_ms: elapsed,\n is_valid_json: isValidJson ? 1 : 0,\n response_body: responseBody,\n changed,\n error: null,\n checked_at: new Date().toISOString(),\n };\n\n // Send alert if changed and alert_email configured\n if (changed && endpoint.alert_email) {\n await sendChangeAlert(endpoint, check, prev!);\n }\n\n return check;\n } catch (e: any) {\n errorMsg = e.message;\n const elapsed = Date.now() - start;\n const ins = await sqlite.execute({\n sql: `INSERT INTO checks (endpoint_id, status, response_time_ms, is_valid_json, response_body, changed, error)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n args: [endpoint.id, 0, elapsed, 0, null, 0, errorMsg],\n });\n\n const prev = await getLatestCheck(endpoint.id);\n const wasUp = prev && !prev.error;\n if (wasUp && endpoint.alert_email) {\n await sendDownAlert(endpoint, errorMsg);\n }\n\n return {\n id: Number(ins.lastInsertRowid),\n endpoint_id: endpoint.id,\n status: 0,\n response_time_ms: elapsed,\n is_valid_json: 0,\n response_body: null,\n changed: 0,\n error: errorMsg,\n checked_at: new Date().toISOString(),\n };\n }\n}\n\nasync function sendChangeAlert(endpoint: Endpoint, check: Check, prev: Check) {\n const prevParsed = tryParse(prev.response_body);\n const newParsed = tryParse(check.response_body);\n await email.send({\n to: endpoint.alert_email!,\n subject: `[JSON Tracker] Change detected: ${endpoint.name}`,\n text: [\n `A change was detected in the JSON response for: ${endpoint.name}`,\n `URL: ${endpoint.url}`,\n `Checked at: ${check.checked_at}`,\n ``,\n `--- Previous response ---`,\n JSON.stringify(prevParsed, null, 2),\n ``,\n `--- New response ---`,\n JSON.stringify(newParsed, null, 2),\n ].join(\"\\n\"),\n });\n}\n\nasync function sendDownAlert(endpoint: Endpoint, error: string) {\n await email.send({\n to: endpoint.alert_email!,\n subject: `[JSON Tracker] Endpoint down: ${endpoint.name}`,\n text: [\n `Endpoint is unreachable: ${endpoint.name}`,\n `URL: ${endpoint.url}`,\n `Error: ${error}`,\n `Time: ${new Date().toISOString()}`,\n ].join(\"\\n\"),\n });\n}\n\nfunction tryParse(body: string | null | undefined) {\n if (!body) return null;\n try { return JSON.parse(body); } catch { return body; }\n}\n","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { email } from \"https://esm.town/v/std/email/main.ts\";\n\nexport interface Endpoint {\n id: number;\n name: string;\n url: string;\n alert_email: string | null;\n created_at: string;\n}\n\nexport interface Check {\n id: number;\n endpoint_id: number;\n status: number;\n response_time_ms: number;\n is_valid_json: number;\n response_body: string | null;\n changed: number;\n error: string | null;\n checked_at: string;\n}\n\nexport async function getAllEndpoints(): Promise {\n const res = await sqlite.execute(`SELECT * FROM endpoints ORDER BY created_at DESC`);\n return res.rows as unknown as Endpoint[];\n}\n\nexport async function getEndpointById(id: number): Promise {\n const res = await sqlite.execute({ sql: `SELECT * FROM endpoints WHERE id = ?`, args: [id] });\n return (res.rows as unknown as Endpoint[])[0] ?? null;\n}\n\nexport async function getLatestCheck(endpointId: number): Promise {\n const res = await sqlite.execute({\n sql: `SELECT * FROM checks WHERE endpoint_id = ? ORDER BY checked_at DESC LIMIT 1`,\n args: [endpointId],\n });\n return (res.rows as unknown as Check[])[0] ?? null;\n}\n\nexport async function getCheckHistory(endpointId: number, limit = 20): Promise {\n const res = await sqlite.execute({\n sql: `SELECT * FROM checks WHERE endpoint_id = ? ORDER BY checked_at DESC LIMIT ?`,\n args: [endpointId, limit],\n });\n return res.rows as unknown as Check[];\n}\n\nexport async function performCheck(endpoint: Endpoint): Promise {\n const start = Date.now();\n let status = 0;\n let isValidJson = false;\n let responseBody: string | null = null;\n let errorMsg: string | null = null;\n\n try {\n const res = await fetch(endpoint.url, { signal: AbortSignal.timeout(8000) });\n status = res.status;\n const elapsed = Date.now() - start;\n const text = await res.text();\n try {\n JSON.parse(text);\n isValidJson = true;\n responseBody = text;\n } catch {\n responseBody = text.slice(0, 2000); // store first 2kb even if invalid\n }\n\n // Compare with last check to detect changes\n const prev = await getLatestCheck(endpoint.id);\n const changed = prev && prev.response_body !== null && isValidJson\n ? (prev.response_body !== responseBody ? 1 : 0)\n : 0;\n\n const ins = await sqlite.execute({\n sql: `INSERT INTO checks (endpoint_id, status, response_time_ms, is_valid_json, response_body, changed, error)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n args: [endpoint.id, status, elapsed, isValidJson ? 1 : 0, responseBody, changed, null],\n });\n\n const check: Check = {\n id: Number(ins.lastInsertRowid),\n endpoint_id: endpoint.id,\n status,\n response_time_ms: elapsed,\n is_valid_json: isValidJson ? 1 : 0,\n response_body: responseBody,\n changed,\n error: null,\n checked_at: new Date().toISOString(),\n };\n\n // Send alert if changed and alert_email configured\n if (changed && endpoint.alert_email) {\n await sendChangeAlert(endpoint, check, prev!);\n }\n\n return check;\n } catch (e: any) {\n errorMsg = e.message;\n const elapsed = Date.now() - start;\n const ins = await sqlite.execute({\n sql: `INSERT INTO checks (endpoint_id, status, response_time_ms, is_valid_json, response_body, changed, error)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n args: [endpoint.id, 0, elapsed, 0, null, 0, errorMsg],\n });\n\n const prev = await getLatestCheck(endpoint.id);\n const wasUp = prev && !prev.error;\n if (wasUp && endpoint.alert_email) {\n await sendDownAlert(endpoint, errorMsg);\n }\n\n return {\n id: Number(ins.lastInsertRowid),\n endpoint_id: endpoint.id,\n status: 0,\n response_time_ms: elapsed,\n is_valid_json: 0,\n response_body: null,\n changed: 0,\n error: errorMsg,\n checked_at: new Date().toISOString(),\n };\n }\n}\n\nasync function sendChangeAlert(endpoint: Endpoint, check: Check, prev: Check) {\n const prevParsed = tryParse(prev.response_body);\n const newParsed = tryParse(check.response_body);\n await email.send({\n to: endpoint.alert_email!,\n subject: `[JSON Tracker] Change detected: ${endpoint.name}`,\n text: [\n `A change was detected in the JSON response for: ${endpoint.name}`,\n `URL: ${endpoint.url}`,\n `Checked at: ${check.checked_at}`,\n ``,\n `--- Previous response ---`,\n JSON.stringify(prevParsed, null, 2),\n ``,\n `--- New response ---`,\n JSON.stringify(newParsed, null, 2),\n ].join(\"\\n\"),\n });\n}\n\nasync function sendDownAlert(endpoint: Endpoint, error: string) {\n await email.send({\n to: endpoint.alert_email!,\n subject: `[JSON Tracker] Endpoint down: ${endpoint.name}`,\n text: [\n `Endpoint is unreachable: ${endpoint.name}`,\n `URL: ${endpoint.url}`,\n `Error: ${error}`,\n `Time: ${new Date().toISOString()}`,\n ].join(\"\\n\"),\n });\n}\n\nfunction tryParse(body: string | null | undefined) {\n if (!body) return null;\n try { return JSON.parse(body); } catch { return body; }\n}\n","createdAt",["D",1775748393716],"branchVersion","branchId","1b6bb3e0-33cd-11f1-9c01-42b51c65c3df","id","1b6b4112-33cd-11f1-9c01-42b51c65c3df","json-endpoint-tracker",["D",1775709144649],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Track and monitor JSON endpoints with live status checks","imageUrl","4ee10b0b-8f57-4da7-b68f-6ec2967fc4a8","pinnedFileId","39661c00-33cd-11f1-9fe0-42b51c65c3df","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","68f15e90-6e36-4142-b40d-594bcb1dbd17","tursoName","1b6b411233cd11f19c0142b51c65c3df","tursoHostname","1b6b411233cd11f19c0142b51c65c3df-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789551045218],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_107":106,"_114":110},"org",{"_107":106,"_108":-5,"_109":110,"_19":62,"_111":112,"_113":31},"branch",{"_13":96,"_38":97,"_50":49,"_98":51,"_99":-5,"_100":-5,"_101":-5,"_102":-5,"_103":-5,"_104":52,"_105":106},"isOwned",14,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","masiyou","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJicFlpaVA2c1RFMHhvdnMyMHQ4S3FiWXZsNyJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_50":51,"_38":52,"_45":234,"_54":-5,"_55":31,"_56":57,"_58":57,"_59":60,"_61":-5,"_19":62,"_63":64,"_65":66,"_67":-5,"_68":-5,"_69":70,"_71":72,"_73":74,"_75":76,"_77":235,"_79":-5,"_80":81,"_82":81,"_83":84,"_85":84,"_86":84,"_87":81,"_88":81,"_89":236,"_91":237,"_93":238,"_95":31},"tree",[191,194,196,197,198],"files",[191,192,193,194,195,196,197,198],"counts",{"_181":70,"_182":164,"_183":70,"_184":185,"_186":187},"contents",[137,138,139,140,141],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_50":175,"_38":176,"_36":177,"_145":-5,"_48":49,"_47":178,"_147":66,"_45":179,"_13":70,"_40":173,"_42":-5,"_30":31,"_151":-5,"_33":180},{"_50":168,"_38":169,"_36":170,"_145":-5,"_48":49,"_47":171,"_147":66,"_45":172,"_13":70,"_40":173,"_42":-5,"_30":31,"_151":-5,"_33":174},{"_50":161,"_38":162,"_36":163,"_145":-5,"_48":49,"_47":164,"_147":66,"_45":165,"_13":70,"_40":26,"_42":166,"_30":31,"_151":-5,"_33":167},{"_50":153,"_38":154,"_36":64,"_145":-5,"_48":49,"_47":155,"_147":66,"_45":156,"_13":157,"_40":158,"_42":159,"_30":31,"_151":-5,"_33":160},{"_50":142,"_38":143,"_36":144,"_145":-5,"_48":49,"_47":146,"_147":66,"_45":148,"_13":70,"_40":149,"_42":150,"_30":31,"_151":-5,"_33":152},"392c1d1a-33ce-11f1-8b7b-42b51c65c3df","poller.ts","392c1dce-33ce-11f1-8b7b-42b51c65c3df","parentId",7,"latest",["D",1775709624050],"interval","import { runMigrations } from \"./database/migrations.ts\";\nimport { getAllEndpoints, performCheck } from \"./database/queries.ts\";\n\n// Runs on a schedule to check all endpoints automatically\nexport default async function (_interval: Interval) {\n await runMigrations();\n const endpoints = await getAllEndpoints();\n console.log(`Polling ${endpoints.length} endpoint(s)...`);\n for (const ep of endpoints) {\n try {\n const result = await performCheck(ep);\n console.log(`[${ep.name}] status=${result.status} changed=${result.changed} valid_json=${result.is_valid_json}`);\n } catch (e: any) {\n console.error(`[${ep.name}] poller error: ${e.message}`);\n }\n }\n}\n","label",[143],"42a0dc1e-33ce-11f1-ab2c-42b51c65c3df","main.ts",8,["D",1775709639917],2,"http","import { Hono } from \"npm:hono\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport {\n getAllEndpoints,\n getEndpointById,\n getLatestCheck,\n getCheckHistory,\n performCheck,\n} from \"./database/queries.ts\";\n\nconst app = new Hono();\napp.onError((err) => Promise.reject(err));\n\nawait runMigrations();\n\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// API: list endpoints with latest check\napp.get(\"/api/endpoints\", async (c) => {\n const endpoints = await getAllEndpoints();\n const result = [];\n for (const ep of endpoints) {\n const latest = await getLatestCheck(ep.id);\n result.push({ ...ep, latest_check: latest });\n }\n return c.json(result);\n});\n\n// API: add endpoint\napp.post(\"/api/endpoints\", async (c) => {\n const { name, url, alert_email } = await c.req.json();\n if (!name || !url) return c.json({ error: \"name and url required\" }, 400);\n const ins = await sqlite.execute({\n sql: `INSERT INTO endpoints (name, url, alert_email) VALUES (?, ?, ?)`,\n args: [name, url, alert_email || null],\n });\n return c.json({ id: ins.lastInsertRowid, name, url, alert_email: alert_email || null });\n});\n\n// API: update endpoint (name, url, alert_email)\napp.patch(\"/api/endpoints/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const body = await c.req.json();\n const ep = await getEndpointById(id);\n if (!ep) return c.json({ error: \"not found\" }, 404);\n const name = body.name ?? ep.name;\n const url = body.url ?? ep.url;\n const alert_email = \"alert_email\" in body ? (body.alert_email || null) : ep.alert_email;\n await sqlite.execute({\n sql: `UPDATE endpoints SET name = ?, url = ?, alert_email = ? WHERE id = ?`,\n args: [name, url, alert_email, id],\n });\n return c.json({ id, name, url, alert_email });\n});\n\n// API: delete endpoint\napp.delete(\"/api/endpoints/:id\", async (c) => {\n const id = c.req.param(\"id\");\n await sqlite.execute({ sql: `DELETE FROM checks WHERE endpoint_id = ?`, args: [id] });\n await sqlite.execute({ sql: `DELETE FROM endpoints WHERE id = ?`, args: [id] });\n return c.json({ ok: true });\n});\n\n// API: check now\napp.post(\"/api/endpoints/:id/check\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const ep = await getEndpointById(id);\n if (!ep) return c.json({ error: \"not found\" }, 404);\n const result = await performCheck(ep);\n return c.json(result);\n});\n\n// API: history for endpoint\napp.get(\"/api/endpoints/:id/history\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const rows = await getCheckHistory(id, 20);\n return c.json(rows);\n});\n\n// Serve frontend HTML\napp.get(\"/*\", (c) => serveFile(\"/frontend/index.html\", import.meta.url));\n\nexport default app.fetch;\n",[154],"28648a0e-33cd-11f1-ba79-42b51c65c3df","README.md","28648aae-33cd-11f1-ba79-42b51c65c3df",1,["D",1775709166393],"# json-endpoint-tracker",[162],"c6a6e5a4-33cd-11f1-a7ac-42b51c65c3df","frontend","941eb54b-2072-4e4e-acc4-185931734af6",3,["D",1775709431907],"directory",[169],"2b5f19bc-33ce-11f1-96e9-42b51c65c3df","database","830171b4-dc9b-4408-ac45-48e63c9edaff",5,["D",1775709600896],[176],"pulls","branches","forks","envVars",{"_188":70,"_190":70},"connections",{"_188":70,"_189":70},"count","unfilledCount","emptyCount",{"_50":175,"_38":176,"_36":177,"_145":-5,"_48":49,"_47":178,"_147":66,"_45":231,"_13":70,"_40":173,"_42":-5,"_30":31,"_151":-5,"_200":232,"_33":233},{"_50":224,"_38":225,"_36":226,"_145":177,"_48":49,"_47":178,"_147":66,"_45":227,"_13":70,"_40":41,"_42":228,"_30":31,"_151":-5,"_200":229,"_33":230},{"_50":220,"_38":39,"_36":37,"_145":177,"_48":49,"_47":14,"_147":31,"_45":221,"_13":164,"_40":41,"_42":44,"_30":31,"_151":-5,"_200":222,"_33":223},{"_50":168,"_38":169,"_36":170,"_145":-5,"_48":49,"_47":171,"_147":66,"_45":217,"_13":70,"_40":173,"_42":-5,"_30":31,"_151":-5,"_200":218,"_33":219},{"_50":209,"_38":210,"_36":211,"_145":170,"_48":49,"_47":212,"_147":31,"_45":213,"_13":164,"_40":26,"_42":214,"_30":31,"_151":-5,"_200":215,"_33":216},{"_50":161,"_38":162,"_36":163,"_145":-5,"_48":49,"_47":164,"_147":66,"_45":206,"_13":70,"_40":26,"_42":166,"_30":31,"_151":-5,"_200":207,"_33":208},{"_50":153,"_38":154,"_36":64,"_145":-5,"_48":49,"_47":155,"_147":66,"_45":203,"_13":157,"_40":158,"_42":159,"_30":31,"_151":-5,"_200":204,"_33":205},{"_50":142,"_38":143,"_36":144,"_145":-5,"_48":49,"_47":146,"_147":66,"_45":199,"_13":70,"_40":149,"_42":150,"_30":31,"_151":-5,"_200":201,"_33":202},["D",1775709624050],"children",[],[143],["D",1775709639917],[],[154],["D",1775709166393],[],[162],"634858de-33ce-11f1-abd3-42b51c65c3df","index.html","c6a69428-33cd-11f1-a7ac-42b51c65c3df",9,["D",1775709694698],"\n\n\n \n \n JSON Endpoint Tracker\n \n\n\n

🔍 JSON Endpoint Tracker

\n view source\n

Add Endpoint

\n \n \n \n \n

\n\n\n\n\n",[],[169,210],["D",1775709431907],[195],[169],"7db1ea8c-3428-11f1-a1e1-42b51c65c3df",["D",1775748393716],[],[176,39],"2b5ef374-33ce-11f1-96e9-42b51c65c3df","migrations.ts","2b5ef41e-33ce-11f1-96e9-42b51c65c3df",["D",1775709600896],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function runMigrations() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS endpoints (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n url TEXT NOT NULL,\n alert_email TEXT,\n created_at TEXT DEFAULT (datetime('now'))\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS checks (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n endpoint_id INTEGER,\n status INTEGER,\n response_time_ms INTEGER,\n is_valid_json INTEGER,\n response_body TEXT,\n changed INTEGER DEFAULT 0,\n error TEXT,\n checked_at TEXT DEFAULT (datetime('now'))\n )\n `);\n\n // Migrate existing endpoints table: add alert_email if missing\n try {\n await sqlite.execute(`ALTER TABLE endpoints ADD COLUMN alert_email TEXT`);\n } catch { /* column already exists */ }\n\n // Migrate existing checks table: add response_body if missing\n try {\n await sqlite.execute(`ALTER TABLE checks ADD COLUMN response_body TEXT`);\n } catch { /* column already exists */ }\n\n // Migrate existing checks table: add changed if missing\n try {\n await sqlite.execute(`ALTER TABLE checks ADD COLUMN changed INTEGER DEFAULT 0`);\n } catch { /* column already exists */ }\n}\n",[],[176,225],["D",1775709600896],[192,193],[176],["D",1775709144649],["D",1789551045218],{"_107":106,"_114":110},{"_107":106,"_108":-5,"_109":110,"_19":62,"_111":112,"_113":31},{"_13":96,"_38":97,"_50":49,"_98":51,"_99":-5,"_100":-5,"_101":-5,"_102":-5,"_103":-5,"_104":52,"_105":106},"ctx",{"_89":-5,"_134":272,"_273":274,"_275":276,"_277":31,"_278":31,"_279":31,"_280":66,"_281":-5,"_282":-7,"_283":-7,"_284":70,"_285":31,"_286":31,"_287":-5,"_288":31,"_289":31,"_290":31,"_291":-5},"ENV",{"_243":244,"_245":246,"_247":97,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257,"_258":259,"_260":261,"_262":263,"_264":265,"_266":267,"_268":269,"_270":271},"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 · v10