[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_175":176,"_177":178},"routes/_app.x.$handle.$name",{"_107":106,"_38":51,"_116":95,"_33":117,"_13":14,"_118":-5,"_11":119,"_120":121,"_122":123,"_124":125,"_126":127,"_26":-5,"_128":-5,"_129":130,"_131":31,"_132":133,"_134":65,"_135":-5,"_136":-5,"_137":138},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_49":50,"_38":51,"_44":52,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":69,"_70":71,"_72":73,"_74":75,"_76":77,"_78":-5,"_79":80,"_81":80,"_82":83,"_84":83,"_85":83,"_86":80,"_87":80,"_88":89,"_90":91,"_92":93,"_94":31},"version",6,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","2ccebcff-2be5-4ca7-a78f-5a22b4583a17","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":34,"_39":40,"_41":43,"_44":45,"_46":14,"_47":48,"_30":31},"previous",{"_36":37,"_38":34,"_39":40,"_41":42},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","019ec541-6b75-75bb-b559-f2454b24173c","name","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

Log an entry

\n\n

\n When\n

Now

A past day

\n\n

\n Date\n \n

\n\n

\n Type\n

Bowel Movement

Breakfast

Lunch

Dinner

Snack

Water

Symptom

Note

\n\n

\n Bristol Scale\n

1
Hard lumps

2
Lumpy

3
Cracked

4
Normal

5
Soft blobs

6
Mushy

7
Watery

\n\n

\n Amount\n

A little

Moderate

A lot

\n\n

\n Water\n \n

\n\n

\n Description\n \n

\n\n

\n Notes (optional)\n \n

\n\n \n

\n\n

View entries for a date

\n \n

Log an entry

\n\n

\n When\n

Now

A past day

\n\n

\n Date\n \n

\n\n

\n Type\n

Bowel Movement

Breakfast

Lunch

Dinner

Snack

Water

Symptom

Note

\n\n

\n Bristol Scale\n

1
Hard lumps

2
Lumpy

3
Cracked

4
Normal

5
Soft blobs

6
Mushy

7
Watery

\n\n

\n Amount\n

A little

Moderate

A lot

\n\n

\n Water\n \n

\n\n

\n Description\n \n

\n\n

\n Notes (optional)\n \n

\n\n \n

\n\n

View entries for a date

\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 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 timestamp: r[0],\n entry_type: r[1],\n bristol_scale: r[2],\n amount: r[3],\n description: r[4],\n quantity: r[5],\n notes: r[6],\n }));\n\n return Response.json({ date, entries });\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 // Default to \"now\". If the client supplied an explicit timestamp (e.g. a\n // past day picked from the calendar), validate it and use that instead.\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}","createdAt",["D",1781426027815],"branchVersion","branchId","01914d6e-3f29-4102-a844-2fd79883bc64","id","77dc6897-9c33-4667-9f54-40476cdc7ec0","bowelle-web",["D",1781357898744],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","form for logging diet","imageUrl","7d65ca3a-47d1-4f81-9e34-bf374921e34e","pinnedFileId","2344d2de-672d-11f1-85ff-1607ee4eb77e","pinPreview",true,"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",{"_107":106,"_115":111},"org",{"_107":106,"_108":109,"_110":111,"_19":61,"_112":113,"_114":31},"branch",{"_13":14,"_38":95,"_49":48,"_96":50,"_97":98,"_99":100,"_101":56,"_102":50,"_103":71,"_104":51,"_105":106},"isOwned","add-timebased-updates","projectId","forkedBranchId","34d0bdcc-4d76-4799-b917-1c3d71da3201","forkedBranchVersion",9,"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",{"_49":50,"_38":51,"_44":170,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":69,"_70":71,"_72":73,"_74":75,"_76":171,"_78":-5,"_79":80,"_81":80,"_82":83,"_84":83,"_85":83,"_86":80,"_87":80,"_88":172,"_90":173,"_92":174,"_94":31},"tree",[165],"files",[165],"counts",{"_154":69,"_155":156,"_157":69,"_158":159,"_160":161},"contents",[146],"upstreamProject","upstreamBranch",{"_49":98,"_44":139,"_140":141,"_38":142,"_96":50,"_13":143,"_97":-5,"_99":-5,"_144":145,"_53":-5,"_94":31,"_55":56,"_105":106,"_70":71,"_104":51},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1781357898750],"updatedAt",["D",1781816580551],"main",18,"lockfileKey","1781816580741-esm.town_v_joefrost0_bowelle-web@18-main",{"_49":147,"_38":34,"_36":37,"_148":-5,"_47":48,"_46":14,"_149":65,"_44":150,"_13":151,"_39":40,"_41":43,"_30":31,"_152":-5,"_33":153},"cfe5945b-c860-4a34-8afc-fdd7e2f76b19","parentId","latest",["D",1781426027815],5,"label",[34],"pulls","branches",3,"forks","envVars",{"_162":69,"_164":69},"connections",{"_162":69,"_163":69},"count","unfilledCount","emptyCount",{"_49":147,"_38":34,"_36":37,"_148":-5,"_47":48,"_46":14,"_149":65,"_44":166,"_13":151,"_39":40,"_41":43,"_30":31,"_152":-5,"_167":168,"_33":169},["D",1781426027815],"children",[],[34],["D",1781357898744],["D",1789471840176],{"_107":106,"_115":111},{"_107":106,"_108":109,"_110":111,"_19":61,"_112":113,"_114":31},{"_13":14,"_38":95,"_49":48,"_96":50,"_97":98,"_99":100,"_101":56,"_102":50,"_103":71,"_104":51,"_105":106},"ctx",{"_88":-5,"_136":208,"_209":210,"_211":212,"_213":31,"_214":31,"_215":31,"_216":65,"_217":-5,"_218":-7,"_219":-7,"_220":69,"_221":31,"_222":31,"_223":-5,"_224":31,"_225":31,"_226":31,"_227":-5},"ENV",{"_179":180,"_181":182,"_183":142,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195,"_196":197,"_198":199,"_200":201,"_202":203,"_204":205,"_206":207},"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 · v6