${escapeHtml(opts.title)}

\n ${opts.body}\n

\n \n\n`;\n}\n\n// Backfill slugs at startup\n{\n const res = await sqlite.execute(`SELECT id, title FROM ${TABLE} WHERE slug IS NULL OR slug = ''`);\n for (const row of res.rows as Array<{ id: number; title: string }>) {\n const s = await slugify(row.title);\n await sqlite.execute(`UPDATE ${TABLE} SET slug = ? WHERE id = ?`, [s, row.id]);\n }\n}\n\n// Home: list posts\napp.get(\"/\", async (c) => {\n const res = await sqlite.execute(`SELECT id, title, created_at, slug FROM ${TABLE} ORDER BY id DESC`);\n const rows = res.rows as Array<{ id: number; title: string; created_at: string; slug: string }>;\n const items = rows.map((row) => `\n

\n ${escapeHtml(row.title)}\n ${new Date(row.created_at).toLocaleString()}\n

\n Edit\n

\n `).join(\"\");\n\n const body = `\n

Posts

\n Write a post\n

No posts yet. Create the first.

\n `;\n return c.html(layout({ title: \"Town Blog\", body }));\n});\n\n// New post form\napp.get(\"/new\", (c) => {\n const body = `\n \n

Preview

Start typing to see preview…

\n \n `;\n return c.html(layout({ title: \"New Post\", body }));\n});\n\n// Create post\napp.post(\"/posts\", async (c) => {\n const form = await c.req.formData();\n const title = String(form.get(\"title\") ?? \"\").trim();\n const content = String(form.get(\"content\") ?? \"\").trim();\n if (!title || !content) {\n return c.html(layout({\n title: \"New Post - Error\",\n body: `

Title and content are required.

Go back

`\n }), 400);\n }\n const createdAt = new Date().toISOString();\n const slug = await slugify(title);\n await sqlite.execute(`INSERT INTO ${TABLE} (title, content, created_at, slug) VALUES (?, ?, ?, ?)`, [title, content, createdAt, slug]);\n return redirect(`/p/${slug}`);\n});\n\n// View by slug\napp.get(\"/p/:slug\", async (c) => {\n const slug = c.req.param(\"slug\");\n const res = await sqlite.execute(`SELECT id, title, content, created_at, slug FROM ${TABLE} WHERE slug = ?`, [slug]);\n const row = res.rows[0] as { id: number; title: string; content: string; created_at: string; slug: string } | undefined;\n if (!row) return c.notFound();\n const body = `\n

${escapeHtml(row.title)}

\n Edit\n \n

${md.render(row.content)}

\n Published ${new Date(row.created_at).toLocaleString()}\n

\n `;\n return c.html(layout({ title: row.title, body }));\n});\n\n// Legacy: view by id -> redirect to slug\napp.get(\"/posts/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const res = await sqlite.execute(`SELECT slug FROM ${TABLE} WHERE id = ?`, [id]);\n const row = res.rows[0] as { slug: string } | undefined;\n if (!row || !row.slug) return c.notFound();\n return redirect(`/p/${row.slug}`);\n});\n\n// Edit form (by id)\napp.get(\"/edit/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const res = await sqlite.execute(`SELECT id, title, content FROM ${TABLE} WHERE id = ?`, [id]);\n const row = res.rows[0] as { id: number; title: string; content: string } | undefined;\n if (!row) return c.notFound();\n const body = `\n \n \n

Preview

\n \n `;\n return c.html(layout({ title: `Edit: ${row.title}`, body }));\n});\n\n// Update post (by id)\napp.post(\"/posts/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const form = await c.req.formData();\n const title = String(form.get(\"title\") ?? \"\").trim();\n const content = String(form.get(\"content\") ?? \"\").trim();\n if (!title || !content) {\n return c.html(layout({\n title: \"Edit Post - Error\",\n body: `

Title and content are required.

Go back

`\n }), 400);\n }\n // If title changed, update slug as well (preserve uniqueness)\n const current = await sqlite.execute(`SELECT title, slug FROM ${TABLE} WHERE id = ?`, [id]);\n const currentRow = current.rows[0] as { title: string; slug: string } | undefined;\n const currentSlug = currentRow?.slug ?? null;\n const newSlug = currentRow && currentRow.title !== title ? await slugify(title) : currentSlug;\n await sqlite.execute(`UPDATE ${TABLE} SET title = ?, content = ?, slug = ? WHERE id = ?`, [title, content, newSlug, id]);\n return redirect(`/p/${newSlug}`);\n});\n\n// Delete post (by id)\napp.post(\"/posts/:id/delete\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n await sqlite.execute(`DELETE FROM ${TABLE} WHERE id = ?`, [id]);\n return redirect(\"/\");\n});\n\nexport default app.fetch;",[],[74,82],"6bb7ff3a-c1b2-11f0-bccc-42dde27851f2",".vscode","6bb7fff8-c1b2-11f0-bccc-42dde27851f2",6,["D",1763163250398],[98],[92],{"_34":99,"_13":100,"_37":101,"_39":93,"_41":42,"_43":102,"_45":46,"_47":103,"_17":59,"_50":24,"_51":104,"_53":54,"_55":-5,"_66":105,"_18":106},"6bd87044-c1b2-11f0-bccc-42dde27851f2","extensions.json","6bd87184-c1b2-11f0-bccc-42dde27851f2",7,["D",1763163250612],"{\n \"recommendations\": [\n \"denoland.vscode-deno\"\n ]\n}",[],[92,100],"c1f38774-c1ae-11f0-8e92-42dde27851f2",["D",1763161677088],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","userId","fa602270-d767-476a-be2a-1070a19b692d","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","f4b8cdfb-e8ce-48da-840c-727b846965e1","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_160":156},"org",{"_11":12,"_154":-5,"_155":156,"_117":118,"_157":158,"_159":54},"branch",{"_17":84,"_13":16,"_34":42,"_146":107,"_147":-5,"_148":-5,"_149":-5,"_150":-5,"_151":-5,"_152":14,"_153":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yYXNFTjNuRzhRY0xQQnJPdkVVTnpMZXJQVUwifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_34":107,"_13":14,"_47":211,"_109":-5,"_110":54,"_111":112,"_113":112,"_114":115,"_116":-5,"_117":118,"_119":83,"_120":46,"_121":46,"_122":-5,"_123":59,"_124":125,"_126":-5,"_127":-5,"_128":-5,"_129":-5,"_130":131,"_132":131,"_133":134,"_135":134,"_136":134,"_137":131,"_138":131,"_139":212,"_141":213,"_143":214,"_145":54},[193,195,197],"files",[193,194,195,196,197,198],"counts",{"_184":59,"_185":49,"_186":59,"_32":187,"_188":189},[182],{"_34":57,"_41":42,"_37":40,"_13":19,"_51":-5,"_50":58,"_17":59,"_39":-5,"_47":180,"_43":49,"_55":-5,"_18":181},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1763162716573],[19],{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":24,"_51":52,"_53":54,"_55":-5,"_18":183},[19,36],"pulls","branches","forks",{"_190":59,"_192":59},"connections",{"_190":59,"_191":59},"count","unfilledCount","emptyCount",{"_34":91,"_13":92,"_37":93,"_39":-5,"_41":42,"_43":94,"_45":46,"_47":95,"_17":59,"_50":58,"_51":-5,"_53":54,"_55":-5,"_66":209,"_18":210},{"_34":99,"_13":100,"_37":101,"_39":93,"_41":42,"_43":102,"_45":46,"_47":103,"_17":59,"_50":24,"_51":104,"_53":54,"_55":-5,"_66":207,"_18":208},{"_34":73,"_13":74,"_37":75,"_39":-5,"_41":42,"_43":76,"_45":46,"_47":77,"_17":59,"_50":58,"_51":-5,"_53":54,"_55":-5,"_66":205,"_18":206},{"_34":81,"_13":82,"_37":83,"_39":75,"_41":42,"_43":84,"_45":46,"_47":85,"_17":86,"_50":87,"_51":88,"_53":54,"_55":-5,"_66":203,"_18":204},{"_34":57,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":49,"_45":46,"_47":65,"_17":59,"_50":58,"_51":-5,"_53":54,"_55":-5,"_66":201,"_18":202},{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":70,"_17":49,"_50":24,"_51":52,"_53":54,"_55":-5,"_66":199,"_18":200},[],[19,36],[198],[19],[],[74,82],[196],[74],[],[92,100],[194],[92],["D",1763161677088],{"_11":12,"_160":156},{"_11":12,"_154":-5,"_155":156,"_117":118,"_157":158,"_159":54},{"_17":84,"_13":16,"_34":42,"_146":107,"_147":-5,"_148":-5,"_149":-5,"_150":-5,"_151":-5,"_152":14,"_153":12},"ctx",{"_139":-5,"_177":248,"_249":250,"_251":252,"_253":54,"_254":54,"_255":54,"_256":46,"_257":-5,"_258":-7,"_259":-7,"_260":59,"_261":54,"_262":54,"_263":-5,"_264":54,"_265":54,"_266":54,"_267":-5},"ENV",{"_219":220,"_221":222,"_223":16,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247},"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"]