My Todos

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_220":221,"_222":223},"routes/_app.x.$handle.$name",{"_105":104,"_38":51,"_114":95,"_33":115,"_13":14,"_116":-5,"_11":117,"_118":119,"_120":121,"_122":123,"_124":125,"_26":-5,"_126":-5,"_127":-5,"_128":31,"_129":130,"_131":64,"_132":-5,"_133":-5,"_134":135},"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":37,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":76,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":88,"_89":90,"_91":92,"_93":31},"version",12,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","5bfdeeb0-8f8d-4741-9d83-e88acde6b5c8","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","ad281d64-9c05-11f1-932d-1607ee4eb77e","name","fileType","http","content","import { parseVal, serveImmutableFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { Root } from \"./frontend/root.tsx\";\n\n// Set up the todos table\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS todos (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user TEXT NOT NULL,\n text TEXT NOT NULL,\n done INTEGER DEFAULT 0,\n created_at TEXT DEFAULT (datetime('now'))\n)`);\n\nconst app = new Hono();\n\n// Identify the current user via Val Town's auth header\nfunction currentUser(c: { req: { header(name: string): string | undefined } }): string {\n return c.req.header(\"X-Val-Town-User\") ?? \"anonymous\";\n}\n\n// Serve the (never-cached) HTML shell at the root /\napp.get(\"/\", (c) => c.html(Root()));\n\n// Serve frontend files at the version-addressed URLs Root() stamps, cached immutably\napp.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path));\n\n// View source redirect\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// ---- API endpoints ----\napp.get(\"/api/me\", (c) => c.json({ user: currentUser(c) }));\n\napp.get(\"/api/todos\", async (c) => {\n const result = await sqlite.execute({ sql: `SELECT * FROM todos ORDER BY id DESC LIMIT 100`, args: [] });\n return c.json(result.rows);\n});\n\napp.post(\"/api/todos\", async (c) => {\n const user = currentUser(c);\n const { text } = await c.req.json();\n if (!text) return c.json({ error: \"text required\" }, 400);\n await sqlite.execute({ sql: `INSERT INTO todos (user, text) VALUES (?, ?)`, args: [user, text] });\n return c.json({ ok: true });\n});\n\napp.delete(\"/api/todos\", async (c) => {\n const user = currentUser(c);\n const { id } = await c.req.json();\n await sqlite.execute({ sql: `DELETE FROM todos WHERE id = ? AND user = ?`, args: [id, user] });\n return c.json({ ok: true });\n});\n\napp.patch(\"/api/todos\", async (c) => {\n const user = currentUser(c);\n const { id, done } = await c.req.json();\n await sqlite.execute({ sql: `UPDATE todos SET done = ? WHERE id = ? AND user = ?`, args: [done ? 1 : 0, id, user] });\n return c.json({ ok: true });\n});\n\n// Unwrap and rethrow Hono errors as the original error\napp.onError((err) => Promise.reject(err));\n\n// HTTP vals expect an exported \"fetch handler\"\nexport default app.fetch;\n","import { parseVal, serveImmutableFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { getOAuthUserData, oauthMiddleware } from \"https://esm.town/v/std/oauth/middleware.ts\";\nimport { Root } from \"./frontend/root.tsx\";\n\n// Set up the todos table\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS todos (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user TEXT NOT NULL,\n text TEXT NOT NULL,\n done INTEGER DEFAULT 0,\n created_at TEXT DEFAULT (datetime('now'))\n)`);\n\nconst app = new Hono();\n\n// Identify the current user via Val Town's auth header\nfunction currentUser(c: { req: { header(name: string): string | undefined } }): string {\n return c.req.header(\"X-Val-Town-User\") ?? \"anonymous\";\n}\n\n// Serve the (never-cached) HTML shell at the root /\napp.get(\"/\", (c) => c.html(Root()));\n\n// Serve frontend files at the version-addressed URLs Root() stamps, cached immutably\napp.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path));\n\n// View source redirect\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// ---- API endpoints ----\napp.get(\"/api/me\", (c) => c.json({ user: currentUser(c) }));\n\napp.get(\"/api/todos\", async (c) => {\n const result = await sqlite.execute({ sql: `SELECT * FROM todos ORDER BY id DESC LIMIT 100`, args: [] });\n return c.json(result.rows);\n});\n\napp.post(\"/api/todos\", async (c) => {\n const user = currentUser(c);\n const { text } = await c.req.json();\n if (!text) return c.json({ error: \"text required\" }, 400);\n await sqlite.execute({ sql: `INSERT INTO todos (user, text) VALUES (?, ?)`, args: [user, text] });\n return c.json({ ok: true });\n});\n\napp.delete(\"/api/todos\", async (c) => {\n const user = currentUser(c);\n const { id } = await c.req.json();\n await sqlite.execute({ sql: `DELETE FROM todos WHERE id = ? AND user = ?`, args: [id, user] });\n return c.json({ ok: true });\n});\n\napp.patch(\"/api/todos\", async (c) => {\n const user = currentUser(c);\n const { id, done } = await c.req.json();\n await sqlite.execute({ sql: `UPDATE todos SET done = ? WHERE id = ? AND user = ?`, args: [done ? 1 : 0, id, user] });\n return c.json({ ok: true });\n});\n\n// Unwrap and rethrow Hono errors as the original error\napp.onError((err) => Promise.reject(err));\n\n// HTTP vals expect an exported \"fetch handler\"\nexport default app.fetch;\n","createdAt",["D",1787168648013],"branchVersion","branchId","f5b6e2f0-ecfe-43de-b706-6197bf74aca4","id","dee36eda-d5a7-4fc5-8de4-4e94d9634713","per-user-todos",["D",1787168352197],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Todo list app where each user has their own todos","imageUrl","be579f59-6fc7-4939-b072-7d31e47ac2ab","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a01b88-7f08-71fd-bb42-b55e8bacd525","tursoName","dee36edad5a74fc58de44e94d9634713","tursoHostname","dee36edad5a74fc58de44e94d9634713-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789517443998],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_105":104,"_113":109},"org",{"_105":104,"_106":107,"_108":109,"_19":61,"_110":111,"_112":31},"branch",{"_13":94,"_38":95,"_49":48,"_96":50,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":51,"_103":104},"isOwned",20,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","ocarater","handle","displayName","João Silva","avatar","https://lh3.googleusercontent.com/a/ACg8ocJXHIU_lyI9J_43_34g5gViz084XuSJN5sj0Mgzynd033utFQ=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_49":50,"_38":51,"_44":215,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":37,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":216,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":217,"_89":218,"_91":219,"_93":31},"tree",[163,169],"files",[163,164,165,166,167,168,169],"counts",{"_152":68,"_153":154,"_155":68,"_156":157,"_158":159},"contents",[136,137],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_49":145,"_38":146,"_36":147,"_139":-5,"_47":48,"_46":148,"_140":64,"_44":149,"_13":68,"_39":150,"_41":-5,"_30":31,"_143":-5,"_33":151},{"_49":138,"_38":34,"_36":37,"_139":-5,"_47":48,"_46":14,"_140":31,"_44":141,"_13":142,"_39":40,"_41":43,"_30":31,"_143":-5,"_33":144},"91339184-2b1a-44a7-a547-0d33964fe22b","parentId","latest",["D",1787168648013],5,"label",[34],"1c29abe4-bade-4d40-b0a3-441350097cec","frontend","01a01b8a-98dd-7649-bb37-029616a01d29",4,["D",1787168463076],"directory",[146],"pulls","branches",1,"forks","envVars",{"_160":68,"_162":68},"connections",{"_160":68,"_161":68},"count","unfilledCount","emptyCount",{"_49":145,"_38":146,"_36":147,"_139":-5,"_47":48,"_46":148,"_140":64,"_44":212,"_13":68,"_39":150,"_41":-5,"_30":31,"_143":-5,"_171":213,"_33":214},{"_49":207,"_38":206,"_36":199,"_139":147,"_47":48,"_46":208,"_140":64,"_44":209,"_13":68,"_39":150,"_41":-5,"_30":31,"_143":-5,"_171":210,"_33":211},{"_49":196,"_38":197,"_36":198,"_139":199,"_47":48,"_46":200,"_140":31,"_44":201,"_13":202,"_39":178,"_41":203,"_30":31,"_143":-5,"_171":204,"_33":205},{"_49":189,"_38":190,"_36":191,"_139":147,"_47":48,"_46":148,"_140":64,"_44":192,"_13":68,"_39":26,"_41":193,"_30":31,"_143":-5,"_171":194,"_33":195},{"_49":182,"_38":183,"_36":184,"_139":147,"_47":48,"_46":148,"_140":64,"_44":185,"_13":68,"_39":178,"_41":186,"_30":31,"_143":-5,"_171":187,"_33":188},{"_49":174,"_38":175,"_36":176,"_139":147,"_47":48,"_46":142,"_140":64,"_44":177,"_13":154,"_39":178,"_41":179,"_30":31,"_143":-5,"_171":180,"_33":181},{"_49":138,"_38":34,"_36":37,"_139":-5,"_47":48,"_46":14,"_140":31,"_44":170,"_13":142,"_39":40,"_41":43,"_30":31,"_143":-5,"_171":172,"_33":173},["D",1787168648013],"children",[],[34],"0c178dec-4137-4ab8-afda-70369d5b6969","root.tsx","01a01b8a-98de-71a9-9b1e-a6842e2760ae",["D",1787168466501],"script","/** @jsxImportSource npm:hono@4/jsx */\nimport { raw } from \"npm:hono@4/html\";\nimport { immutableFileUrl } from \"https://esm.town/v/std/utils/index.ts\";\n\n// The HTML shell for the app. It is never cached, so immutableFileUrl can stamp\n// the current val version into each asset URL — the browser caches those\n// immutably, and publishing the val changes the URLs, refetching exactly once.\nexport function Root() {\n return (\n <>\n {raw(\"\")}\n \n \n \n \n My Todos\n

Diff · v12