// This approach uses the Hono framework to set up routes for handling comments. // We will store comments in an SQLite database using the `std/sqlite` module for persistence. // The main route serves the HTML form and displays the comments. // The POST route handles new comment submissions. import { Hono } from "npm:hono"; import { html } from "https://esm.town/v/stevekrouse/html"; import { sqlite } from "https://esm.town/v/std/sqlite"; // Create a table for storing comments if it does not exist await sqlite.execute(` CREATE TABLE IF NOT EXISTS comments ( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, comment TEXT NOT NULL, timestamp DATETIME DEFAULT CURRENT_TIMESTAMP ) `); // Define the Hono app const app = new Hono(); // Helper function to fetch all comments from the database async function fetchComments() { const result = await sqlite.execute(`SELECT * FROM comments ORDER BY timestamp DESC`); return result.rows; } // Main route: serves the HTML form and displays comments app.get("/", async (c) => { const comments = await fetchComments(); const commentsHTML = comments.map( (row) => `

${row[1]} (${row[3]}):

${row[2]}

` ).join(""); const body = ` Comment Box

Comment Box

Previous Comments

${commentsHTML}

`; return c.html(body); }); // POST route: handles new comment submissions app.post("/comment", async (c) => { const data = await c.req.parseBody(); const { name, comment } = data; if (name && comment) { await sqlite.execute( "INSERT INTO comments (name, comment) VALUES (?, ?)", [name, comment] ); } return c.redirect("/"); }); // Export the fetch handler to be used by the runtime export default app.fetch;

valle_tmp_393084135551327933207099179023125