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}","label",[138],"pulls","branches",3,"forks","envVars",{"_161":20,"_163":20},"connections",{"_161":20,"_162":20},"count","unfilledCount","emptyCount",{"_32":137,"_13":138,"_139":140,"_141":-5,"_142":56,"_143":55,"_144":77,"_34":165,"_41":146,"_147":148,"_149":150,"_62":26,"_151":-5,"_166":167,"_110":168},["D",1781426027815],"children",[],[138],["D",1781357898744],["D",1789558275908],{"_11":12,"_109":105},{"_11":12,"_102":103,"_104":105,"_72":73,"_106":107,"_108":26},{"_41":55,"_13":16,"_32":56,"_39":40,"_43":33,"_44":22,"_57":50,"_58":40,"_59":53,"_54":14,"_51":12},"ctx",{"_97":-5,"_131":207,"_208":209,"_210":211,"_212":26,"_213":26,"_214":26,"_215":77,"_216":-5,"_217":-7,"_218":-7,"_219":20,"_220":26,"_221":26,"_222":-5,"_223":26,"_224":26,"_225":26,"_226":-5},"ENV",{"_178":179,"_180":181,"_182":38,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206},"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"]

Compare

Mergeadd-timebased-updatesintomain