[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_101":102,"_103":104},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","kotoko","name","pooplog","path","main.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":53,"_54":-5,"_55":56,"_57":25,"_58":32,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_13":44},"permalink","https://www.val.town/x/kotoko/pooplog/code/main.ts","extension","id","8ef914a9-31ea-4abf-b77d-7d395914f69c","fileId","50d99eca-9ca5-11f1-8fbb-1607ee4eb77e","parentId","branchId","f6aaf0ad-0c44-4611-b212-0d16b7921fa6","branchVersion",17,"latest",true,"createdAt",["D",1787237774900],"version",16,"fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nexport default async function (req: Request): Promise {\n // 1. Initialize SQLite database table if it doesn't exist yet\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS poop_logs (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n date TEXT NOT NULL,\n time TEXT NOT NULL,\n person TEXT NOT NULL,\n type TEXT NOT NULL,\n icon TEXT NOT NULL,\n stink INTEGER NOT NULL,\n isDiarrhea INTEGER NOT NULL,\n notes TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // 2. Handle POST request (saving a new entry)\n if (\n req.method === \"POST\" &&\n req.headers.get(\"Content-Type\")?.includes(\"application/json\")\n ) {\n try {\n const data = await req.json();\n await sqlite.execute({\n sql:\n `INSERT INTO poop_logs (date, time, person, type, icon, stink, isDiarrhea, notes) \n VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n data.date,\n data.time,\n data.person,\n data.type,\n data.icon,\n data.stink,\n data.isDiarrhea ? 1 : 0,\n data.notes || \"\",\n ],\n });\n return Response.json({ success: true });\n } catch (err) {\n return Response.json({ success: false, error: err.message }, {\n status: 500,\n });\n }\n }\n\n // 3. Handle GET request (fetching logs for initial render)\n const dbRows = await sqlite.execute(\n `SELECT * FROM poop_logs ORDER BY date DESC, time DESC`,\n );\n const initialLogs = dbRows.rows.map((row) => ({\n id: row[0],\n date: row[1],\n time: row[2],\n person: row[3],\n type: row[4],\n icon: row[5],\n stink: row[6],\n isDiarrhea: Boolean(row[7]),\n notes: row[8],\n }));\n\n // 4. Render HTML and inject the saved logs into the client\n const html = `\n\n\n \n \n Our Little Poop Log ♡\n \n\n \n\n\n\n

\n \n Shared Poop Calendar\n

Our Little Poop Log

I can't wait to see your poops

\n\n

\n \n \n

\n\n

\n \n

1. Who Made the Deposit?

\n \n \n

\n\n

2. Date & Time

\n \n \n

\n\n

3. Classification

\n \n \n

\n\n

4. Stink-O-Meter Potency

\n Measurement:\n 5 / 10 • Noticeable 👃\n

\n \n

\n\n

\n ⚠️ Diarrhea Warning\n Check if liquidity / code red was reached\n

\n \n \n \n \n

\n\n

5. Field Notes (Optional)

\n \n

\n\n \n

\n\n

\n \n

August 2026

\n \n

\n\n

Daily Timeline

\n Click any day to view\n

\n\n \n

\n\n \n\n`;\n\n return new Response(html, {\n headers: {\n \"Content-Type\": \"text/html; charset=utf-8\",\n },\n });\n}","deleted",false,"label",[14],"2fd66905-94c7-48e5-b16f-0c26dc65ee14",["D",1787236926475],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","userId","019c30ef-02e7-769a-8678-ec06aca6bdae","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019c30ef-02e7-769a-8678-f2429da12a47","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_100":96},"org",{"_9":10,"_94":-5,"_95":96,"_55":56,"_97":98,"_99":42},"branch",{"_35":30,"_11":85,"_22":28,"_86":45,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":12,"_93":10},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzM5SEtLTWkxbVdBbzdURXJ4bHlOYXMzVFhINyJ9","tier","free","canRestrictVals","profileImageUrl","ctx",{"_78":-5,"_134":135,"_136":137,"_138":139,"_140":42,"_141":42,"_142":42,"_143":32,"_144":-5,"_145":-7,"_146":-7,"_147":62,"_148":42,"_149":42,"_150":-5,"_151":42,"_152":42,"_153":42,"_154":-5},"ENV",{"_105":106,"_107":108,"_109":85,"_110":111,"_112":113,"_114":115,"_116":117,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133},"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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]