Commonplace

A private repository for thoughts, readings, and observations.

\n \n

Entries

\n\n\n`;\n}\n\n// --- BACKEND API (HONO ROUTER) ---\nconst app = new Hono();\n\n// Enable CORS to allow the frontend, which is served from the same val, to make API calls.\napp.use(\"/api/*\", cors());\n\n// API Endpoint: Retrieve all entries\napp.get(\"/api/entries\", async (c) => {\n try {\n const { results } = await sqlite.execute(\"SELECT * FROM entries ORDER BY created_at DESC\");\n return c.json({ success: true, data: results });\n } catch (e) {\n console.error(\"Failed to fetch entries:\", e);\n return c.json({ success: false, error: \"Database query failed\" }, 500);\n }\n});\n\n// API Endpoint: Create a new entry\napp.post(\"/api/entries\", async (c) => {\n try {\n const { content, source, tags } = await c.req.json();\n if (!content || typeof content !== \"string\" || content.trim() === \"\") {\n return c.json({ success: false, error: \"Content field is mandatory and cannot be empty\" }, 400);\n }\n await sqlite.execute({\n sql: \"INSERT INTO entries (content, source, tags) VALUES (:content, :source, :tags)\",\n args: {\n content: content.trim(),\n source: source || null,\n tags: tags || null,\n },\n });\n return c.json({ success: true, message: \"Entry created successfully\" }, 201);\n } catch (e) {\n console.error(\"Failed to create entry:\", e);\n return c.json({ success: false, error: \"Failed to write to the database\" }, 500);\n }\n});\n\n// API Endpoint: Delete an entry\napp.delete(\"/api/entries/:id\", async (c) => {\n try {\n const id = c.req.param(\"id\");\n if (!id || isNaN(parseInt(id, 10))) {\n return c.json({ success: false, error: \"A valid numeric ID is required\" }, 400);\n }\n const result = await sqlite.execute({\n sql: \"DELETE FROM entries WHERE id = :id\",\n args: { id: parseInt(id, 10) },\n });\n if (result.rowsAffected === 0) {\n return c.json({ success: false, error: \"Entry not found\" }, 404);\n }\n return c.json({ success: true, message: \"Entry deleted\" });\n } catch (e) {\n console.error(\"Failed to delete entry:\", e);\n return c.json({ success: false, error: \"Database deletion failed\" }, 500);\n }\n});\n\n/**\n * The main request handler for the val.\n * - For requests to the root path (\"/\"), it serves the HTML interface.\n * - For all other paths, it delegates to the Hono API router.\n * @param {Request} req - The incoming HTTP request.\n * @returns {Response} An HTTP response.\n */\nexport default async function(req: Request): Promise {\n const url = new URL(req.url);\n\n if (url.pathname === \"/\") {\n const sourceUrl = `https://${url.hostname}${url.pathname}`;\n return new Response(generateHtml(sourceUrl), {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n }\n\n // Delegate API requests to the Hono application\n return app.fetch(req);\n}","deleted","label",[98],"permalink","https://www.val.town/x/legal/commonplace/code/main.tsx","extension","actionData","errors"]