[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_172":173,"_174":175},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_131":-5,"_20":132,"_22":133,"_134":135,"_136":137,"_25":138,"_24":-5,"_139":-5,"_140":141,"_142":51,"_143":144,"_145":69,"_146":-5,"_147":-5,"_148":149},"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":28,"_29":-5,"_30":31,"_32":33,"_34":-5},"handle","joefrost0","name","bowelle-web","branchName","add-timebased-updates","version","path","","project",{"_35":43,"_13":14,"_37":84,"_49":-5,"_85":51,"_52":53,"_86":53,"_87":88,"_89":-5,"_90":91,"_92":93,"_94":69,"_95":-5,"_96":-5,"_97":31,"_55":56,"_98":99,"_100":101,"_102":103,"_104":-5,"_105":106,"_107":106,"_108":109,"_110":109,"_111":109,"_112":106,"_113":106,"_114":115,"_116":117,"_118":119,"_50":51},"tree",[79],"file","contents",[58],"upstream",{"_35":36,"_37":38,"_39":40,"_13":41,"_42":43,"_17":44,"_45":-5,"_46":-5,"_47":48,"_49":-5,"_50":51,"_52":53,"_54":12,"_55":56,"_57":14},"pull","ahead",0,"behind",9,"envVars","id","34d0bdcc-4d76-4799-b917-1c3d71da3201","createdAt",["D",1781357898750],"updatedAt",["D",1781816580551],"main","projectId","77dc6897-9c33-4667-9f54-40476cdc7ec0",18,"forkedBranchId","forkedBranchVersion","lockfileKey","1781816580741-esm.town_v_joefrost0_bowelle-web@18-main","deletedAt","isOwned",false,"privacy","public","userHandle","orgId","019ea3ad-2eb5-706c-a3f0-0505d3c7d8ed","projectName",{"_35":59,"_13":60,"_61":62,"_63":-5,"_64":65,"_66":67,"_68":69,"_37":70,"_17":71,"_72":73,"_74":75,"_76":51,"_77":-5,"_18":78},"cfe5945b-c860-4a34-8afc-fdd7e2f76b19","main.ts","fileId","019ec541-6b75-75bb-b559-f2454b24173c","parentId","branchId","01914d6e-3f29-4102-a844-2fd79883bc64","branchVersion",6,"latest",true,["D",1781426027815],5,"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

\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}","deleted","label",[60],{"_35":59,"_13":60,"_61":62,"_63":-5,"_64":65,"_66":67,"_68":69,"_37":80,"_17":71,"_72":73,"_74":75,"_76":51,"_77":-5,"_81":82,"_18":83},["D",1781426027815],"children",[],[60],["D",1781357898744],"legacyEnvVars","httpPrivacy","description","form for logging diet","imageUrl","userId","7d65ca3a-47d1-4f81-9e34-bf374921e34e","pinnedFileId","2344d2de-672d-11f1-85ff-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount","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,"_130":126},"org",{"_11":12,"_123":124,"_125":126,"_90":91,"_127":128,"_129":51},"branch",{"_17":67,"_13":16,"_35":65,"_42":43,"_45":36,"_46":33,"_120":53,"_121":43,"_122":56,"_57":14,"_54":12},"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","displayName","Joe Frost","avatar","https://lh3.googleusercontent.com/a/ACg8ocJBr2yZJtgTKOKSI0TYDT5l7r4wtU1A72IeMiJrhqpBX4exoASz=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_35":43,"_13":14,"_37":167,"_49":-5,"_85":51,"_52":53,"_86":53,"_87":88,"_89":-5,"_90":91,"_92":93,"_94":69,"_95":-5,"_96":-5,"_97":31,"_55":56,"_98":99,"_100":101,"_102":168,"_104":-5,"_105":106,"_107":106,"_108":109,"_110":109,"_111":109,"_112":106,"_113":106,"_114":169,"_116":170,"_118":171,"_50":51},[164],"files",[164],"counts",{"_154":31,"_155":156,"_157":31,"_34":158,"_159":160},[152],"upstreamProject","upstreamBranch",{"_35":36,"_37":150,"_39":151,"_13":41,"_42":43,"_17":44,"_45":-5,"_46":-5,"_47":48,"_49":-5,"_50":51,"_52":53,"_54":12,"_55":56,"_57":14},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1781357898750],["D",1781816580551],{"_35":59,"_13":60,"_61":62,"_63":-5,"_64":65,"_66":67,"_68":69,"_37":70,"_17":71,"_72":73,"_74":75,"_76":51,"_77":-5,"_18":153},[60],"pulls","branches",3,"forks",{"_161":31,"_163":31},"connections",{"_161":31,"_162":31},"count","unfilledCount","emptyCount",{"_35":59,"_13":60,"_61":62,"_63":-5,"_64":65,"_66":67,"_68":69,"_37":80,"_17":71,"_72":73,"_74":75,"_76":51,"_77":-5,"_81":165,"_18":166},[],[60],["D",1781357898744],["D",1789471840176],{"_11":12,"_130":126},{"_11":12,"_123":124,"_125":126,"_90":91,"_127":128,"_129":51},{"_17":67,"_13":16,"_35":65,"_42":43,"_45":36,"_46":33,"_120":53,"_121":43,"_122":56,"_57":14,"_54":12},"ctx",{"_114":-5,"_147":205,"_206":207,"_208":209,"_210":51,"_211":51,"_212":51,"_213":69,"_214":-5,"_215":-7,"_216":-7,"_217":31,"_218":51,"_219":51,"_220":-5,"_221":51,"_222":51,"_223":51,"_224":-5},"ENV",{"_176":177,"_178":179,"_180":41,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204},"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"]

Code