${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 `;\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 `;\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 slug FROM ${TABLE} WHERE id = ?`, [id]);\n const currentSlug = (current.rows[0] as { slug: string } | undefined)?.slug ?? null;\n const newSlug = currentSlug && 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;",[],[140,176],["D",1763162789385],[164],[140],"6bd87044-c1b2-11f0-bccc-42dde27851f2","extensions.json","6bd87184-c1b2-11f0-bccc-42dde27851f2",7,["D",1763163250612],"{\n \"recommendations\": [\n \"denoland.vscode-deno\"\n ]\n}",[],[146,187],["D",1763163250398],[162],[146],["D",1763161677088],{"_97":96,"_104":100},{"_97":96,"_98":-5,"_99":100,"_18":55,"_101":102,"_103":25},{"_13":86,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"ctx",{"_79":-5,"_123":234,"_235":236,"_237":238,"_239":25,"_240":25,"_241":25,"_242":59,"_243":-5,"_244":-7,"_245":-7,"_246":63,"_247":25,"_248":25,"_249":-5,"_250":25,"_251":25,"_252":25,"_253":-5},"ENV",{"_205":206,"_207":208,"_209":87,"_210":211,"_212":213,"_214":215,"_216":217,"_218":219,"_220":221,"_222":223,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233},"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"]

Diff · v9