[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_160":161,"_162":163},"routes/_app.x.$handle.$name",{"_16":17,"_20":21,"_90":70,"_91":92,"_68":-7,"_93":-5,"_13":94,"_95":96,"_11":97,"_98":99,"_100":101,"_102":-5,"_103":-5,"_104":105,"_106":26,"_107":108,"_109":38,"_110":-5,"_111":-5,"_112":113},"routes/_app.x.$handle.$name.search.$(branch)",{"_11":12,"_13":14,"_15":-5,"_16":17},"files",[],"project",{"_18":19,"_20":21,"_22":23,"_24":-5,"_25":26,"_27":28,"_29":28,"_30":31,"_32":-5,"_33":34,"_35":36,"_37":38,"_39":-5,"_40":-5,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":-5,"_52":53,"_54":53,"_55":56,"_57":56,"_58":56,"_59":53,"_60":53,"_61":62,"_63":64,"_65":66,"_67":26},"query","handle","joefrost0","id","77dc6897-9c33-4667-9f54-40476cdc7ec0","name","bowelle-web","createdAt",["D",1781357898744],"deletedAt","legacyEnvVars",false,"privacy","public","httpPrivacy","description","form for logging diet","imageUrl","userId","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",{"_16":17,"_89":85},"org",{"_16":17,"_82":83,"_84":85,"_33":34,"_86":87,"_88":26},"branch",{"_68":69,"_20":70,"_18":71,"_72":19,"_73":74,"_75":76,"_77":28,"_78":19,"_79":44,"_80":21,"_81":17},"isOwned","version",6,"add-timebased-updates","01914d6e-3f29-4102-a844-2fd79883bc64","projectId","forkedBranchId","34d0bdcc-4d76-4799-b917-1c3d71da3201","forkedBranchVersion",9,"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Joe Frost","avatar","https://lh3.googleusercontent.com/a/ACg8ocJBr2yZJtgTKOKSI0TYDT5l7r4wtU1A72IeMiJrhqpBX4exoASz=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","path","","adoptOrgId",{"_18":19,"_20":21,"_22":155,"_24":-5,"_25":26,"_27":28,"_29":28,"_30":31,"_32":-5,"_33":34,"_35":36,"_37":38,"_39":-5,"_40":-5,"_41":42,"_43":44,"_45":46,"_47":48,"_49":156,"_51":-5,"_52":53,"_54":53,"_55":56,"_57":56,"_58":56,"_59":53,"_60":53,"_61":157,"_63":158,"_65":159,"_67":26},"tree",[150],[150],"counts",{"_139":42,"_140":141,"_142":42,"_143":144,"_145":146},"contents",[121],"file","upstreamProject","upstreamBranch",{"_18":74,"_22":114,"_115":116,"_20":117,"_72":19,"_68":118,"_73":-5,"_75":-5,"_119":120,"_24":-5,"_67":26,"_27":28,"_81":17,"_43":44,"_80":21},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1781357898750],"updatedAt",["D",1781816580551],"main",18,"lockfileKey","1781816580741-esm.town_v_joefrost0_bowelle-web@18-main",{"_18":122,"_20":123,"_124":125,"_126":-5,"_127":71,"_128":69,"_129":38,"_22":130,"_68":131,"_132":133,"_134":135,"_136":26,"_137":-5,"_91":138},"cfe5945b-c860-4a34-8afc-fdd7e2f76b19","main.ts","fileId","019ec541-6b75-75bb-b559-f2454b24173c","parentId","branchId","branchVersion","latest",["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",[123],"pulls","branches",3,"forks","envVars",{"_147":42,"_149":42},"connections",{"_147":42,"_148":42},"count","unfilledCount","emptyCount",{"_18":122,"_20":123,"_124":125,"_126":-5,"_127":71,"_128":69,"_129":38,"_22":151,"_68":131,"_132":133,"_134":135,"_136":26,"_137":-5,"_152":153,"_91":154},["D",1781426027815],"children",[],[123],["D",1781357898744],["D",1789471840176],{"_16":17,"_89":85},{"_16":17,"_82":83,"_84":85,"_33":34,"_86":87,"_88":26},{"_68":69,"_20":70,"_18":71,"_72":19,"_73":74,"_75":76,"_77":28,"_78":19,"_79":44,"_80":21,"_81":17},"ctx",{"_61":-5,"_111":193,"_194":195,"_196":197,"_198":26,"_199":26,"_200":26,"_201":38,"_202":-5,"_203":-7,"_204":-7,"_205":42,"_206":26,"_207":26,"_208":-5,"_209":26,"_210":26,"_211":26,"_212":-5},"ENV",{"_164":165,"_166":167,"_168":117,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192},"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"]

Search