import { Hono } from "npm:hono"; import { sqlite } from "https://esm.town/v/std/sqlite?v=4"; import { html } from "https://esm.town/v/stevekrouse/html?v=5"; // Initialize SQLite database and comments table if it doesn't exist const initDB = async () => { await sqlite.execute(` CREATE TABLE IF NOT EXISTS comments ( id INTEGER PRIMARY KEY AUTOINCREMENT, text TEXT NOT NULL, timestamp DATETIME DEFAULT CURRENT_TIMESTAMP ) `); }; await initDB(); const app = new Hono(); // Serves the comment page app.get("/", async (c) => { const result = await sqlite.execute("SELECT * FROM comments ORDER BY timestamp DESC"); const comments = result.rows; return html(` Comment Box

Comment Box

${comments.map(comment => `

${comment.text}

${new Date(comment.timestamp).toLocaleString()}

`).join('')}

`); }); // Handles the comment submission app.post("/comment", async c => { const formData = await c.req.parseBody(); const text = formData.text; // Insert the comment into the database await sqlite.execute("INSERT INTO comments (text) VALUES (?)", [text]); // Redirect back to the main page return c.redirect("/"); }); export default app.fetch;

valle_tmp_888865450629273105329300182726127