${esc(error)}

` : \"\";\n const val = value ? ` value=\"${esc(value)}\"` : \"\";\n return page(`\n ${errorBlock}\n \n `);\n}\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const path = url.pathname;\n\n // One-time setup: POST /setup\n if (path === \"/setup\" && req.method === \"POST\") {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS bigmessage_entries (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n text TEXT NOT NULL,\n ip_address TEXT NOT NULL,\n created_on DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP\n )\n `);\n return new Response(\"Table created.\", { status: 200 });\n }\n\n // GET /\n if ((path === \"/\" || path === \"\") && req.method === \"GET\") {\n const result = await sqlite.execute(\n \"SELECT text FROM bigmessage_entries ORDER BY created_on DESC LIMIT 1\",\n );\n const text = result.rows.length > 0 ? esc(String(result.rows[0][0])) : \"\";\n return page(`\n Go ahead and change the text!\n

${text}

\n `);\n }\n\n // GET /change\n if (path === \"/change\" && req.method === \"GET\") {\n return formHtml();\n }\n\n // POST /change\n if (path === \"/change\" && req.method === \"POST\") {\n const form = await req.formData();\n const text = String(form.get(\"text\") || \"\").trim();\n\n const error = validate(text);\n if (error) return formHtml(error, text);\n\n const ip = req.headers.get(\"x-forwarded-for\")?.split(\",\")[0]?.trim() ||\n \"unknown\";\n\n await sqlite.execute({\n sql: \"INSERT INTO bigmessage_entries (text, ip_address) VALUES (?, ?)\",\n args: [text, ip],\n });\n\n // prune old entries\n await sqlite.execute({\n sql: `DELETE FROM bigmessage_entries WHERE id NOT IN (\n SELECT id FROM bigmessage_entries ORDER BY created_on DESC LIMIT ?\n )`,\n args: [MAX_LOG_ENTRIES],\n });\n\n return new Response(null, { status: 303, headers: { Location: \"/\" } });\n }\n\n // GET /log\n if (path === \"/log\" && req.method === \"GET\") {\n const result = await sqlite.execute({\n sql:\n \"SELECT text, ip_address, created_on FROM bigmessage_entries ORDER BY created_on DESC LIMIT ?\",\n args: [MAX_LOG_ENTRIES],\n });\n const rows = result.rows\n .map((r) =>\n `

${esc(String(r[2]))} ${\n esc(String(r[1]))\n } — ${esc(String(r[0]))}

`\n )\n .join(\"\\n\");\n return page(rows || \"

No entries yet.

\");\n }\n\n return new Response(\"Not Found\", { status: 404 });\n}","deleted","label",[100],"permalink","https://www.val.town/x/timerickson/bigmessage/code/main.ts","extension","actionData","errors"]