import { Hono } from "https://esm.sh/hono"; import { sqlite } from "https://esm.town/v/stevekrouse/sqlite"; const app = new Hono(); const KEY = new URL(import.meta.url).pathname.split("/").at(-1); const SCHEMA_VERSION = 5; // Increment this when making schema changes const ADMIN_TOKEN = Deno.env.get('ADMIN_TOKEN') || 'default_insecure_token'; // Sanitize title to create a URL-friendly identifier function sanitizeTitle(title: string): string { return title .toLowerCase() .replace(/[^a-z0-9]+/g, '-') .replace(/^-+|-+$/g, ''); } // Ensure table exists and is up to date async function setupDatabase() { // Check if the table exists const tableCheck = await sqlite.execute(` SELECT name FROM sqlite_master WHERE type='table' AND name='${KEY}_pages_${SCHEMA_VERSION}' `); // If table doesn't exist, create it with the latest schema if (tableCheck.rows.length === 0) { await sqlite.execute(` CREATE TABLE ${KEY}_pages_${SCHEMA_VERSION} ( id INTEGER PRIMARY KEY AUTOINCREMENT, title TEXT UNIQUE NOT NULL, content TEXT NOT NULL, content_type TEXT DEFAULT 'text/html', created_at DATETIME DEFAULT CURRENT_TIMESTAMP ) `); // If an old table exists, migrate data const oldTableCheck = await sqlite.execute(` SELECT name FROM sqlite_master WHERE type='table' AND name='${KEY}_pages_${SCHEMA_VERSION-1}' `); if (oldTableCheck.rows.length > 0) { // Migrate data, using title instead of slug await sqlite.execute(` INSERT INTO ${KEY}_pages_${SCHEMA_VERSION} (title, content, content_type, created_at) SELECT title, content, content_type, created_at FROM ${KEY}_pages_${SCHEMA_VERSION-1} `); // Optionally drop the old table await sqlite.execute(`DROP TABLE ${KEY}_pages_${SCHEMA_VERSION-1}`); } } } // Home page with page creation form app.get("/", async (c) => { await setupDatabase(); // Fetch existing pages const pagesResult = await sqlite.execute(` SELECT title FROM ${KEY}_pages_${SCHEMA_VERSION} ORDER BY created_at DESC `); const pagesList = pagesResult.rows.map(row => `

` ).join(''); return c.html(` Static Page Manager

📄 Static Page Manager

Existing Pages

${pagesList} View Source `); }); // Create a new page app.post("/create", async (c) => { const formData = await c.req.parseBody(); const token = formData.token as string; const title = formData.title as string; const content = formData.content as string; const content_type = formData.content_type as string || 'text/html'; // Check admin token if (token !== ADMIN_TOKEN) { return new Response('Unauthorized', { status: 403 }); } try { await sqlite.execute(` INSERT INTO ${KEY}_pages_${SCHEMA_VERSION} (title, content, content_type) VALUES (?, ?, ?) `, [title, content, content_type]); } catch (error) { // Handle potential unique constraint violation if (error.message.includes('UNIQUE constraint failed')) { return new Response('A page with this title already exists', { status: 400 }); } throw error; } return c.redirect("/"); }); // View a specific page by title app.get("/static/:title", async (c) => { const inputTitle = c.req.param("title"); // Find pages where the sanitized input matches the sanitized title in the database const pageResult = await sqlite.execute(` SELECT content, content_type, title FROM ${KEY}_pages_${SCHEMA_VERSION} WHERE LOWER(REPLACE(REPLACE(REPLACE(title, ' ', '-'), '/[^a-z0-9-]/g', ''), '--', '-')) = ? `, [inputTitle]); const page = pageResult.rows[0]; if (!page) { return c.text("Page not found", 404); } return new Response(page.content, { headers: { 'Content-Type': page.content_type || 'text/html' } }); }); export default app.fetch;

philz