${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;","deleted","label",[169,153],"backend","permalink","https://www.val.town/x/lamplightdev/town-centre/code/backend/index.ts","extension","actionData","errors"]