Health Log

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_158":159,"_160":161},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_120":-5,"_20":121,"_22":122,"_123":124,"_125":126,"_25":127,"_24":-5,"_128":-5,"_129":-5,"_130":53,"_131":132,"_133":44,"_134":-5,"_135":-5,"_136":137},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","joefrost0","name","bowelle-web","branchName","main","version","path","","project",{"_33":61,"_13":14,"_45":62,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":69,"_70":-5,"_71":72,"_73":37,"_74":44,"_75":-5,"_76":-5,"_77":78,"_79":80,"_81":82,"_83":84,"_85":86,"_87":-5,"_88":89,"_90":89,"_91":92,"_93":92,"_94":92,"_95":89,"_96":89,"_97":98,"_99":100,"_101":102,"_103":53},"tree",[56],"file","contents",[32],"upstream","pull","ahead","behind","envVars",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":55},"id","9171b775-83c4-472a-b372-aed956b93c08","main.ts","fileId","2344d2de-672d-11f1-85ff-1607ee4eb77e","parentId","branchId","34d0bdcc-4d76-4799-b917-1c3d71da3201","branchVersion",18,"latest",true,"createdAt",["D",1781816580551],17,"fileType","http","content","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\nconst HTML = `\n\n\n\n\nHealth Log\n\n\n\n \n

\n \n

\n\n

\n \n\n

Log an entry

\n\n

\n When\n

Now

Past date

\n\n

\n Date\n \n

\n\n

\n Type\n

Bowel

Breakfast

Lunch

Dinner

Snack

Water

Symptom

Note

\n\n

\n Bristol Scale\n

1
Hard

2
Lumpy

3
Cracked

4
Normal

5
Soft

6
Mushy

7
Watery

\n\n

\n Amount\n

A little

Moderate

A lot

\n\n

\n \n

\n\n

\n Description\n \n

\n\n

\n Notes (optional)\n \n

\n\n \n

\n\n

View entries

\n Date\n \n

\n \n

\n\n\n\n`;\n\nexport default async function (req: Request) {\n const url = new URL(req.url);\n\n if (req.method === \"GET\" && url.pathname === \"/summary\") {\n const date = url.searchParams.get(\"date\");\n if (!date) {\n return Response.json({ status: \"error\", message: \"date is required\" }, {\n status: 400,\n });\n }\n\n const start = `${date}T00:00:00.000Z`;\n const end = `${date}T23:59:59.999Z`;\n\n const result = await sqlite.execute({\n sql:\n `SELECT id, timestamp, entry_type, bristol_scale, amount, description, quantity, notes\n FROM bowel_entries\n WHERE timestamp >= ? AND timestamp <= ?\n ORDER BY timestamp ASC`,\n args: [start, end],\n });\n\n const entries = result.rows.map((r) => ({\n id: r[0],\n timestamp: r[1],\n entry_type: r[2],\n bristol_scale: r[3],\n amount: r[4],\n description: r[5],\n quantity: r[6],\n notes: r[7],\n }));\n\n return Response.json({ date, entries });\n }\n\n if (req.method === \"DELETE\" && url.pathname.startsWith(\"/entry/\")) {\n const id = url.pathname.split(\"/\").pop();\n\n if (!id || isNaN(Number(id))) {\n return Response.json({ status: \"error\", message: \"invalid id\" }, {\n status: 400,\n });\n }\n\n await sqlite.execute({\n sql: `DELETE FROM bowel_entries WHERE id = ?`,\n args: [Number(id)],\n });\n\n return Response.json({ status: \"ok\", deleted_id: Number(id) });\n }\n\n if (req.method === \"GET\") {\n return new Response(HTML, { headers: { \"Content-Type\": \"text/html\" } });\n }\n\n if (req.method === \"POST\") {\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 {\n entry_type,\n bristol_scale,\n amount,\n description,\n quantity,\n notes,\n timestamp,\n } = body;\n if (!entry_type) {\n return Response.json({\n status: \"error\",\n message: \"entry_type is required\",\n }, { status: 400 });\n }\n\n let ts = new Date().toISOString();\n if (timestamp != null) {\n const parsed = new Date(timestamp);\n if (isNaN(parsed.getTime())) {\n return Response.json({\n status: \"error\",\n message: \"invalid timestamp\",\n }, { status: 400 });\n }\n ts = parsed.toISOString();\n }\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\n return Response.json({ status: \"ok\", timestamp: ts });\n }\n\n return Response.json({ status: \"ready\" });\n}","deleted",false,"label",[35],{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":59,"_18":60},["D",1781816580551],"children",[],[35],"77dc6897-9c33-4667-9f54-40476cdc7ec0",["D",1781357898744],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","form for logging diet","imageUrl","userId","7d65ca3a-47d1-4f81-9e34-bf374921e34e","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019ea3ad-2eb5-706c-a3f0-0505d3c7d8ed","tursoName","77dc68979c3346679f5440476cdc7ec0","tursoHostname","77dc68979c3346679f5440476cdc7ec0-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789471840176],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_119":115},"org",{"_11":12,"_112":113,"_114":115,"_71":72,"_116":117,"_118":53},"branch",{"_17":42,"_13":16,"_33":40,"_104":61,"_105":-5,"_106":-5,"_107":-5,"_108":-5,"_109":-5,"_110":14,"_111":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Joe Frost","avatar","https://lh3.googleusercontent.com/a/ACg8ocJBr2yZJtgTKOKSI0TYDT5l7r4wtU1A72IeMiJrhqpBX4exoASz=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":61,"_13":14,"_45":153,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":69,"_70":-5,"_71":72,"_73":37,"_74":44,"_75":-5,"_76":-5,"_77":78,"_79":80,"_81":82,"_83":84,"_85":154,"_87":-5,"_88":89,"_90":89,"_91":92,"_93":92,"_94":92,"_95":89,"_96":89,"_97":155,"_99":156,"_101":157,"_103":53},[150],"files",[150],"counts",{"_140":78,"_141":142,"_143":78,"_31":144,"_145":146},[138],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":139},[35],"pulls","branches",3,"forks",{"_147":78,"_149":78},"connections",{"_147":78,"_148":78},"count","unfilledCount","emptyCount",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":151,"_18":152},[],[35],["D",1781357898744],["D",1789471840176],{"_11":12,"_119":115},{"_11":12,"_112":113,"_114":115,"_71":72,"_116":117,"_118":53},{"_17":42,"_13":16,"_33":40,"_104":61,"_105":-5,"_106":-5,"_107":-5,"_108":-5,"_109":-5,"_110":14,"_111":12},"ctx",{"_97":-5,"_135":191,"_192":193,"_194":195,"_196":53,"_197":53,"_198":53,"_199":44,"_200":-5,"_201":-7,"_202":-7,"_203":78,"_204":53,"_205":53,"_206":-5,"_207":53,"_208":53,"_209":53,"_210":-5},"ENV",{"_162":163,"_164":165,"_166":16,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190},"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"]

Set PIN

Health Log

Log an entry

View entries

Code