[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_198":199,"_200":201},"routes/_app.x.$handle.$name",{"_99":98,"_32":45,"_108":89,"_27":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_20":-5,"_120":-5,"_121":-5,"_122":25,"_123":124,"_125":59,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",32,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","report.ts","latestPath","fileId","824ea762-672f-11f1-99f9-1607ee4eb77e","name","fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nfunction daysAgoISO(n: number): string {\n const d = new Date();\n d.setUTCDate(d.getUTCDate() - n);\n d.setUTCHours(0, 0, 0, 0);\n return d.toISOString();\n}\n\nasync function getStats(start: string, end: string, days: number) {\n const bm = await sqlite.execute({\n sql: `SELECT COUNT(*) as cnt, AVG(bristol_scale) as avg_bristol\n FROM bowel_entries\n WHERE entry_type = 'bowel_movement' AND timestamp >= ? AND timestamp < ?`,\n args: [start, end],\n });\n\n const bristolDist = await sqlite.execute({\n sql: `SELECT bristol_scale, COUNT(*) as cnt\n FROM bowel_entries\n WHERE entry_type = 'bowel_movement' AND timestamp >= ? AND timestamp < ?\n GROUP BY bristol_scale ORDER BY bristol_scale`,\n args: [start, end],\n });\n\n const amountDist = await sqlite.execute({\n sql: `SELECT amount, COUNT(*) as cnt\n FROM bowel_entries\n WHERE entry_type = 'bowel_movement' AND timestamp >= ? AND timestamp < ?\n GROUP BY amount`,\n args: [start, end],\n });\n\n const flares = await sqlite.execute({\n sql: `SELECT COUNT(*) as cnt FROM bowel_entries\n WHERE timestamp >= ? AND timestamp < ?\n AND (notes LIKE '%flare%' OR description LIKE '%flare%' OR notes LIKE '%mucus%')`,\n args: [start, end],\n });\n\n const total = Number(bm.rows[0][0]);\n const avgBristol = bm.rows[0][1] != null ? Number(bm.rows[0][1]) : null;\n\n return {\n bm_total: total,\n avg_bm_per_day: Math.round((total / days) * 100) / 100,\n avg_bristol_scale: avgBristol != null ? Math.round(avgBristol * 10) / 10 : null,\n bristol_distribution: bristolDist.rows.map((r) => ({ scale: r[0], count: Number(r[1]) })),\n amount_distribution: amountDist.rows.map((r) => ({ amount: r[0], count: Number(r[1]) })),\n flare_or_mucus_mentions: Number(flares.rows[0][0]),\n };\n}\n\nexport default async function (req: Request) {\n const url = new URL(req.url);\n const days = parseInt(url.searchParams.get(\"days\") || \"7\");\n\n const periodStart = daysAgoISO(days);\n const periodEnd = new Date().toISOString();\n const prevStart = daysAgoISO(days * 2);\n const prevEnd = periodStart;\n\n const current = await getStats(periodStart, periodEnd, days);\n const previous = await getStats(prevStart, prevEnd, days);\n\n return Response.json({\n period_days: days,\n period_start: periodStart,\n period_end: periodEnd,\n current,\n previous,\n });\n}import { sqlite } from \"https://esm.town/v/std/sqlite\";\n args: [start, end],\n });\n\n const flares = await sqlite.execute({\n sql: `SELECT COUNT(*) as cnt FROM bowel_entries\n WHERE timestamp >= ? AND timestamp < ?\n AND (notes LIKE '%flare%' OR description LIKE '%flare%' OR notes LIKE '%mucus%')`,\n args: [start, end],\n });\n\n const total = Number(bm.rows[0][0]);\n const avgBristol = bm.rows[0][1] != null ? Number(bm.rows[0][1]) : null;\n\n return {\n bm_total: total,\n avg_bm_per_day: Math.round((total / days) * 100) / 100,\n avg_bristol_scale: avgBristol != null ? Math.round(avgBristol * 10) / 10 : null,\n bristol_distribution: bristolDist.rows.map((r) => ({ scale: r[0], count: Number(r[1]) })),\n amount_distribution: amountDist.rows.map((r) => ({ amount: r[0], count: Number(r[1]) })),\n flare_or_mucus_mentions: Number(flares.rows[0][0]),\n };\n}\n\nexport default async function (req: Request) {\n const url = new URL(req.url);\n const days = parseInt(url.searchParams.get(\"days\") || \"7\");\n\n const periodStart = daysAgoISO(days);\n const periodEnd = new Date().toISOString();\n const prevStart = daysAgoISO(days * 2);\n const prevEnd = periodStart;\n\n const current = await getStats(periodStart, periodEnd, days);\n const previous = await getStats(prevStart, prevEnd, days);\n\n return Response.json({\n period_days: days,\n period_start: periodStart,\n period_end: periodEnd,\n current,\n previous,\n });\n}","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nfunction daysAgoISO(n: number): string {\n const d = new Date();\n d.setUTCDate(d.getUTCDate() - n);\n d.setUTCHours(0, 0, 0, 0);\n return d.toISOString();\n}\n\nasync function getStats(start: string, end: string, days: number) {\n const bm = await sqlite.execute({\n sql: `SELECT COUNT(*) as cnt, AVG(bristol_scale) as avg_bristol\n FROM bowel_entries\n WHERE entry_type = 'bowel_movement' AND timestamp >= ? AND timestamp < ?`,\n args: [start, end],\n });\n\n const bristolDist = await sqlite.execute({\n sql: `SELECT bristol_scale, COUNT(*) as cnt\n FROM bowel_entries\n WHERE entry_type = 'bowel_movement' AND timestamp >= ? AND timestamp < ?\n GROUP BY bristol_scale ORDER BY bristol_scale`,\n args: [start, end],\n });\n\n const amountDist = await sqlite.execute({\n sql: `SELECT amount, COUNT(*) as cnt\n FROM bowel_entries\n WHERE entry_type = 'bowel_movement' AND timestamp >= ? AND timestamp < ?\n GROUP BY amount`,\n args: [start, end],\n });\n\n const flares = await sqlite.execute({\n sql: `SELECT COUNT(*) as cnt FROM bowel_entries\n WHERE timestamp >= ? AND timestamp < ?\n AND (notes LIKE '%flare%' OR description LIKE '%flare%' OR notes LIKE '%mucus%')`,\n args: [start, end],\n });\n\n const total = Number(bm.rows[0][0]);\n const avgBristol = bm.rows[0][1] != null ? Number(bm.rows[0][1]) : null;\n\n return {\n bm_total: total,\n avg_bm_per_day: Math.round((total / days) * 100) / 100,\n avg_bristol_scale: avgBristol != null\n ? Math.round(avgBristol * 10) / 10\n : null,\n bristol_distribution: bristolDist.rows.map((r) => ({\n scale: r[0],\n count: Number(r[1]),\n })),\n amount_distribution: amountDist.rows.map((r) => ({\n amount: r[0],\n count: Number(r[1]),\n })),\n flare_or_mucus_mentions: Number(flares.rows[0][0]),\n };\n}\n\nexport default async function (req: Request) {\n const url = new URL(req.url);\n const days = parseInt(url.searchParams.get(\"days\") || \"7\");\n\n const periodStart = daysAgoISO(days);\n const periodEnd = new Date().toISOString();\n const prevStart = daysAgoISO(days * 2);\n const prevEnd = periodStart;\n\n const current = await getStats(periodStart, periodEnd, days);\n const previous = await getStats(prevStart, prevEnd, days);\n\n return Response.json({\n period_days: days,\n period_start: periodStart,\n period_end: periodEnd,\n current,\n previous,\n });\n}","createdAt",["D",1781359280643],"branchVersion","branchId","e09a2179-1b60-448b-ab27-3cfdd988dfb5","id","ca1c225f-681d-4e85-8487-622b4aac8e6a","bowelle-api",["D",1781355745817],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","track food and bowel movements","imageUrl","7d65ca3a-47d1-4f81-9e34-bf374921e34e","pinnedFileId","2002e00c-6728-11f1-9f1e-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019ea3ad-2eb5-706c-a3f0-0505d3c7d8ed","tursoName","ca1c225f681d4e858487622b4aac8e6a","tursoHostname","ca1c225f681d4e858487622b4aac8e6a-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789471840176],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_107":103},"org",{"_99":98,"_100":101,"_102":103,"_18":55,"_104":105,"_106":25},"branch",{"_13":14,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","joefrost0","handle","displayName","Joe Frost","avatar","https://lh3.googleusercontent.com/a/ACg8ocJBr2yZJtgTKOKSI0TYDT5l7r4wtU1A72IeMiJrhqpBX4exoASz=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":193,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":194,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":195,"_84":196,"_86":197,"_88":25},"tree",[176,177,178,179],"files",[176,177,178,179],"counts",{"_165":63,"_166":167,"_168":63,"_169":170,"_171":172},"contents",[130,131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":156,"_32":157,"_30":158,"_135":-5,"_41":42,"_40":159,"_136":59,"_38":160,"_13":161,"_33":162,"_35":163,"_24":25,"_139":-5,"_27":164},{"_43":149,"_32":150,"_30":57,"_135":-5,"_41":42,"_40":151,"_136":59,"_38":152,"_13":153,"_33":34,"_35":154,"_24":25,"_139":-5,"_27":155},{"_43":141,"_32":142,"_30":143,"_135":-5,"_41":42,"_40":144,"_136":59,"_38":145,"_13":146,"_33":34,"_35":147,"_24":25,"_139":-5,"_27":148},{"_43":134,"_32":28,"_30":31,"_135":-5,"_41":42,"_40":14,"_136":59,"_38":137,"_13":138,"_33":34,"_35":37,"_24":25,"_139":-5,"_27":140},"5a7f2e22-a889-479e-b800-40dd247dfaa1","parentId","latest",["D",1781359280643],8,"label",[28],"a01355f8-a2e2-436d-979b-a38f0114fd71","read.ts","1f15b56a-6729-11f1-8560-1607ee4eb77e",14,["D",1781356553679],5,"import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nexport default async function (req: Request) {\n const url = new URL(req.url);\n const from = url.searchParams.get(\"from\"); // ISO date, e.g. 2026-06-01\n const to = url.searchParams.get(\"to\");\n const entryType = url.searchParams.get(\"type\"); // optional filter\n\n let sql = `SELECT * FROM bowel_entries WHERE 1=1`;\n const args: unknown[] = [];\n\n if (from) {\n sql += ` AND timestamp >= ?`;\n args.push(from);\n }\n if (to) {\n sql += ` AND timestamp <= ?`;\n args.push(to);\n }\n if (entryType) {\n sql += ` AND entry_type = ?`;\n args.push(entryType);\n }\n\n sql += ` ORDER BY timestamp DESC LIMIT 200`;\n\n const result = await sqlite.execute({ sql, args });\n return Response.json({ entries: result.rows });\n}",[142],"b314548a-d641-4fe9-8d6a-121ac7217c1a","main.ts",19,["D",1781357514082],9,"import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS bowel_entries (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n timestamp TEXT NOT NULL,\n entry_type TEXT NOT NULL,\n bristol_scale INTEGER,\n amount TEXT,\n description TEXT,\n quantity REAL,\n notes TEXT\n )\n`);\n\ntry {\n await sqlite.execute(`ALTER TABLE bowel_entries ADD COLUMN amount TEXT`);\n} catch {\n // already exists\n}\n\nasync function insertEntry(entry: Record) {\n const {\n timestamp,\n entry_type,\n bristol_scale,\n amount,\n description,\n quantity,\n notes,\n } = entry;\n if (!entry_type) return null;\n\n const ts = (typeof timestamp === \"string\" && timestamp.trim().length > 0)\n ? timestamp\n : new Date().toISOString();\n\n await sqlite.execute({\n sql:\n `INSERT INTO bowel_entries (timestamp, entry_type, bristol_scale, amount, description, quantity, notes)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n args: [\n ts,\n entry_type,\n bristol_scale != null ? Number(bristol_scale) : null,\n amount ?? null,\n description ?? null,\n quantity != null ? Number(quantity) : null,\n notes ?? null,\n ],\n });\n return ts;\n}\n\nexport default async function (req: Request) {\n const url = new URL(req.url);\n\n // GET with query params - single entry logging\n if (req.method === \"GET\" && url.searchParams.has(\"entry_type\")) {\n const entry = Object.fromEntries(url.searchParams.entries());\n const ts = await insertEntry(entry);\n return Response.json({ status: \"ok\", timestamp: ts });\n }\n\n if (req.method !== \"POST\") {\n return Response.json({ status: \"ready\" });\n }\n\n let body;\n try {\n body = await req.json();\n } catch {\n return Response.json({ status: \"error\", message: \"Invalid JSON\" }, {\n status: 400,\n });\n }\n\n const entries = Array.isArray(body) ? body : [body];\n let inserted = 0;\n for (const entry of entries) {\n const ts = await insertEntry(entry);\n if (ts) inserted++;\n }\n\n return Response.json({ status: \"ok\", inserted });\n}",[150],"2eeac1b4-2b1e-4c13-b72c-db83c6f35f2e","debug.ts","f3fec6da-672a-11f1-b61e-1607ee4eb77e",17,["D",1781356970741],2,"script","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS bowel_entries (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n timestamp TEXT NOT NULL,\n entry_type TEXT NOT NULL,\n bristol_scale INTEGER,\n amount TEXT,\n description TEXT,\n quantity REAL,\n notes TEXT\n )\n`);\n\n// Migration: add amount column if this table was created before it existed\ntry {\n await sqlite.execute(`ALTER TABLE bowel_entries ADD COLUMN amount TEXT`);\n} catch {\n // column already exists - ignore\n}\n\nexport default async function (req: Request) {\n if (req.method !== \"POST\") {\n return Response.json({ status: \"ready\" });\n }\n\n let body;\n try {\n body = await req.json();\n } catch {\n return Response.json({ status: \"error\", message: \"Invalid JSON\" }, {\n status: 400,\n });\n }\n\n const entries = Array.isArray(body) ? body : [body];\n let inserted = 0;\n\n for (const entry of entries) {\n const {\n timestamp,\n entry_type,\n bristol_scale,\n amount,\n description,\n quantity,\n notes,\n } = entry;\n if (!entry_type) continue;\n\n const ts = (typeof timestamp === \"string\" && timestamp.trim().length > 0)\n ? timestamp\n : new Date().toISOString();\n\n await sqlite.execute({\n sql:\n `INSERT INTO bowel_entries (timestamp, entry_type, bristol_scale, amount, description, quantity, notes)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n args: [\n ts,\n entry_type,\n bristol_scale ?? null,\n amount ?? null,\n description ?? null,\n quantity ?? null,\n notes ?? null,\n ],\n });\n inserted++;\n }\n\n return Response.json({ status: \"ok\", inserted });\n}",[157],"pulls","branches",1,"forks","envVars",{"_173":63,"_175":63},"connections",{"_173":63,"_174":63},"count","unfilledCount","emptyCount",{"_43":156,"_32":157,"_30":158,"_135":-5,"_41":42,"_40":159,"_136":59,"_38":190,"_13":161,"_33":162,"_35":163,"_24":25,"_139":-5,"_181":191,"_27":192},{"_43":149,"_32":150,"_30":57,"_135":-5,"_41":42,"_40":151,"_136":59,"_38":187,"_13":153,"_33":34,"_35":154,"_24":25,"_139":-5,"_181":188,"_27":189},{"_43":141,"_32":142,"_30":143,"_135":-5,"_41":42,"_40":144,"_136":59,"_38":184,"_13":146,"_33":34,"_35":147,"_24":25,"_139":-5,"_181":185,"_27":186},{"_43":134,"_32":28,"_30":31,"_135":-5,"_41":42,"_40":14,"_136":59,"_38":180,"_13":138,"_33":34,"_35":37,"_24":25,"_139":-5,"_181":182,"_27":183},["D",1781359280643],"children",[],[28],["D",1781356553679],[],[142],["D",1781357514082],[],[150],["D",1781356970741],[],[157],["D",1781355745817],["D",1789471840176],{"_99":98,"_107":103},{"_99":98,"_100":101,"_102":103,"_18":55,"_104":105,"_106":25},{"_13":14,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"ctx",{"_82":-5,"_127":231,"_232":233,"_234":235,"_236":25,"_237":25,"_238":25,"_239":59,"_240":-5,"_241":-7,"_242":-7,"_243":63,"_244":25,"_245":25,"_246":-5,"_247":25,"_248":25,"_249":25,"_250":-5},"ENV",{"_202":203,"_204":205,"_206":89,"_207":208,"_209":210,"_211":212,"_213":214,"_215":216,"_217":218,"_219":220,"_221":222,"_223":224,"_225":226,"_227":228,"_229":230},"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 · v32