${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;",[],[180,187],[180],{"_103":197,"_95":198,"_151":199,"_153":-5,"_154":137,"_155":200,"_157":158,"_105":201,"_100":32,"_160":161,"_162":-5,"_163":22,"_164":-5,"_165":202,"_98":212},"2d89afc0-c1b1-11f0-896e-42dde27851f2","frontend","2d89b0a6-c1b1-11f0-896e-42dde27851f2",1,["D",1763162716573],[203],{"_103":204,"_95":205,"_151":206,"_153":199,"_154":137,"_155":207,"_157":158,"_105":208,"_100":200,"_160":173,"_162":209,"_163":22,"_164":-5,"_165":210,"_98":211},"e64f5bd0-c1b2-11f0-a173-42dde27851f2","style.css","7b3952a2-c1b1-11f0-9ebc-42dde27851f2",9,["D",1763163456067],":root{--bg:#ffffff;--text:#111827;--muted:#6b7280;--line:#e5e7eb;--line-strong:#d1d5db;--accent:#111827;--accent-weak:#f3f4f6;--btn:#111827;--btn-text:#ffffff}\n*{box-sizing:border-box}\nhtml,body{margin:0;padding:0}\nbody{font:16px/1.6 system-ui,-apple-system,Segoe UI,Roboto,Ubuntu,Cantarell,Noto Sans,sans-serif;background:var(--bg);color:var(--text)}\n.container{max-width:760px;margin:0 auto;padding:24px}\n\n.site-header{border-bottom:1px solid var(--line);background:#fff;position:sticky;top:0}\n.site-title{font-size:18px;margin:0}\n.site-title a{text-decoration:none;color:var(--text)}\n.site-nav{display:flex;gap:12px;align-items:center}\n.site-footer{border-top:1px solid var(--line);padding:16px 0;margin-top:48px}\n.muted{color:var(--muted)}\n\n.card{border:1px solid var(--line);border-radius:12px;background:#fff;overflow:hidden}\n.card + .card{margin-top:16px}\n.card-head,.card-foot{display:flex;justify-content:space-between;align-items:center;padding:14px 16px;border-bottom:1px solid var(--line)}\n.card-foot{border-top:1px solid var(--line);border-bottom:none}\n.card h2{font-size:18px;margin:0}\n\n.post-list{list-style:none;margin:0;padding:0}\n.post-item{border-top:1px solid var(--line)}\n.post-item:first-child{border-top:none}\n.post-row{display:flex;justify-content:space-between;gap:12px;padding:14px 16px}\n.post-meta{display:flex;flex-direction:column}\n.post-title{font-weight:600;color:var(--text);text-decoration:none}\n.post-title:hover{opacity:.9}\n.timestamp{color:var(--muted);font-size:12px;margin-top:2px}\n.post-actions{display:flex;gap:8px}\n.post-actions .link{font-size:14px}\n.empty{padding:14px 16px;color:var(--muted)}\n\n.link{color:var(--text);text-decoration:none;border-bottom:1px solid var(--line)}\n.link:hover{border-bottom-color:var(--line-strong)}\n\n.btn{display:inline-flex;align-items:center;gap:8px;padding:8px 12px;border:1px solid var(--line);border-radius:8px;background:var(--accent-weak);color:var(--text);text-decoration:none;cursor:pointer}\n.btn:hover{background:#eef2f7}\n.btn.primary{background:var(--btn);color:var(--btn-text);border-color:#111}\n.btn.primary:hover{filter:brightness(.96)}\n\n.form{padding:16px}\n.form-row{display:flex;flex-direction:column;gap:8px;padding:12px 0;border-top:1px solid var(--line)}\n.form-row:first-child{border-top:none}\nlabel{font-weight:600}\ninput[type=text], textarea{width:100%;padding:10px 12px;border:1px solid var(--line);border-radius:8px;background:#fff;color:var(--text)}\ninput[type=text]:focus, textarea:focus{outline:none;border-color:var(--line-strong);box-shadow:0 0 0 3px rgba(17,24,39,.05)}\n.form-actions{display:flex;gap:12px;padding-top:16px;border-top:1px solid var(--line)}\n\n.post-content{padding:16px;border-top:1px solid var(--line);border-bottom:1px solid var(--line)}\n\n/* Minimal prose styling for Markdown */\n.prose{line-height:1.7}\n.prose h1,.prose h2,.prose h3{margin:1.2em 0 .6em;font-weight:700}\n.prose h1{font-size:1.6rem}\n.prose h2{font-size:1.3rem}\n.prose h3{font-size:1.1rem}\n.prose p{margin:.8em 0}\n.prose ul,.prose ol{margin:.8em 0;padding-left:1.2em}\n.prose li+li{margin-top:.25em}\n.prose a{color:var(--text);border-bottom:1px solid var(--line)}\n.prose a:hover{border-bottom-color:var(--line-strong)}\n.prose code{background:#f8fafc;border:1px solid var(--line);border-radius:6px;padding:.1em .3em;font-family:ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;font-size:.95em}\n.prose pre{background:#0b1020;color:#e5e7eb;border-radius:8px;padding:12px;overflow:auto;border:1px solid #11182720}\n.prose pre code{background:transparent;border:none;padding:0;color:inherit}\n.prose blockquote{border-left:3px solid var(--line-strong);margin:1em 0;padding:.1em 1em;color:var(--muted)}\n.error{color:#b91c1c}\n",[],[198,205],[198],"files",[149,167,178,185,196,203],"counts",{"_217":32,"_218":200,"_219":32,"_220":221},"pulls","branches","forks","envVars",{"_222":32,"_223":32},"count","emptyCount","contents",[226],{"_103":168,"_95":169,"_151":170,"_153":152,"_154":137,"_155":171,"_157":158,"_105":227,"_100":32,"_160":173,"_162":174,"_163":22,"_164":-5,"_98":228},["D",1763163250612],[99,169],{"_103":150,"_95":99,"_151":152,"_153":-5,"_154":137,"_155":156,"_157":158,"_105":230,"_100":32,"_160":161,"_162":-5,"_163":22,"_164":-5,"_98":231},["D",1763163250398],[99],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.code.$",{"_93":94,"_95":96,"_97":43,"_100":-7,"_98":99,"_101":240,"_147":245,"_213":264,"_173":265,"_224":267,"_270":-5,"_271":-5,"_272":-5,"_273":-5,"_274":275},{"_103":104,"_95":96,"_105":241,"_107":-5,"_108":22,"_109":110,"_111":72,"_112":-5,"_14":113,"_114":-5,"_115":22,"_116":-5,"_117":32,"_16":118,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_23":242,"_131":243,"_134":244,"_146":22},["D",1763161677088],{"_93":94,"_129":130},{"_93":94,"_133":130,"_14":113},{"_100":136,"_95":43,"_103":137,"_138":104,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":96,"_145":94},[246,252,258],{"_103":150,"_95":99,"_151":152,"_153":-5,"_154":137,"_155":156,"_157":158,"_105":159,"_100":32,"_160":161,"_162":-5,"_163":22,"_164":-5,"_165":247,"_98":251},[248],{"_103":168,"_95":169,"_151":170,"_153":152,"_154":137,"_155":171,"_157":158,"_105":172,"_100":32,"_160":173,"_162":174,"_163":22,"_164":-5,"_165":249,"_98":250},[],[99,169],[99],{"_103":179,"_95":180,"_151":181,"_153":-5,"_154":137,"_155":182,"_157":158,"_105":183,"_100":32,"_160":161,"_162":-5,"_163":22,"_164":-5,"_165":253,"_98":257},[254],{"_103":186,"_95":187,"_151":188,"_153":181,"_154":137,"_155":136,"_157":158,"_105":189,"_100":190,"_160":191,"_162":192,"_163":22,"_164":-5,"_165":255,"_98":256},[],[180,187],[180],{"_103":197,"_95":198,"_151":199,"_153":-5,"_154":137,"_155":200,"_157":158,"_105":201,"_100":32,"_160":161,"_162":-5,"_163":22,"_164":-5,"_165":259,"_98":263},[260],{"_103":204,"_95":205,"_151":206,"_153":199,"_154":137,"_155":207,"_157":158,"_105":208,"_100":200,"_160":173,"_162":209,"_163":22,"_164":-5,"_165":261,"_98":262},[],[198,205],[198],[246,248,252,254,258,260],{"_103":150,"_95":99,"_151":152,"_153":-5,"_154":137,"_155":156,"_157":158,"_105":230,"_100":32,"_160":161,"_162":-5,"_163":22,"_164":-5,"_98":266},[99],[268],{"_103":168,"_95":169,"_151":170,"_153":152,"_154":137,"_155":171,"_157":158,"_105":227,"_100":32,"_160":173,"_162":174,"_163":22,"_164":-5,"_98":269},[99,169],"upstream","pull","ahead","behind","templates",[],"actionData","errors"]

lamplightdev

town-centre