Request Collector

\n {fullRequest ? (\n

Request Details

\n \n \n \n \n \n \n \n \n \n

ID	{fullRequest.id}
Method	{fullRequest.method}
URL	{fullRequest.url}
IP	{fullRequest.ip}
Timestamp	{fullRequest.timestamp}
Headers	{fullRequest.headers}

Back to summary

\n ) : (\n <>\n

Summary Statistics

Total Requests: {stats.totalRequests}
Unique IPs: {stats.uniqueIPs}
Most Common Method: {stats.mostCommonMethod}
Most Common Path: {stats.mostCommonPath}

Recent Requests

\n \n \n \n \n \n \n \n \n \n \n {requests.map((req) => (\n \n \n \n \n \n \n ))}\n \n

ID	Method	URL	Timestamp
{req.id}	{req.method}	{req.url}	{req.timestamp}

\n \n )}\n

\n View Source\n

\n );\n}\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const SCHEMA_VERSION = 1;\n const KEY = \"requestCollector\";\n\n // Create table if not exists\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_requests_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n method TEXT,\n url TEXT,\n headers TEXT,\n ip TEXT,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Save request data\n const url = new URL(request.url);\n const headers = JSON.stringify(Object.fromEntries(request.headers));\n const ip = request.headers.get('x-forwarded-for') || 'unknown';\n\n await sqlite.execute(`\n INSERT INTO ${KEY}_requests_${SCHEMA_VERSION} (method, url, headers, ip)\n VALUES (?, ?, ?, ?)\n `, [request.method, url.pathname, headers, ip]);\n\n // Check if a specific request ID is requested\n const requestedId = url.searchParams.get('id');\n let fullRequest;\n\n if (requestedId) {\n const result = await sqlite.execute(`\n SELECT id, method, url, headers, ip, timestamp\n FROM ${KEY}_requests_${SCHEMA_VERSION}\n WHERE id = ?\n `, [requestedId]);\n \n if (result.rows.length > 0) {\n fullRequest = result.rows[0] as RequestData;\n fullRequest.headers = JSON.stringify(JSON.parse(fullRequest.headers), null, 2);\n }\n }\n\n // Fetch recent requests\n const requests = await sqlite.execute(`\n SELECT id, method, url, timestamp\n FROM ${KEY}_requests_${SCHEMA_VERSION}\n ORDER BY timestamp DESC\n LIMIT 10\n `);\n\n // Calculate statistics\n const stats = await sqlite.execute(`\n SELECT \n COUNT(*) as totalRequests,\n COUNT(DISTINCT ip) as uniqueIPs,\n (SELECT method FROM ${KEY}_requests_${SCHEMA_VERSION} GROUP BY method ORDER BY COUNT(*) DESC LIMIT 1) as mostCommonMethod,\n (SELECT url FROM ${KEY}_requests_${SCHEMA_VERSION} GROUP BY url ORDER BY COUNT(*) DESC LIMIT 1) as mostCommonPath\n FROM ${KEY}_requests_${SCHEMA_VERSION}\n `);\n\n const appHtml = renderToString(\n \n );\n\n return new Response(`\n \n \n \n \n \n Request Collector\n \n \n \n ${appHtml}\n \n \n `, {\n headers: { 'Content-Type': 'text/html' }\n });\n}\n\nconst css = `\n body {\n font-family: Arial, sans-serif;\n line-height: 1.6;\n color: #333;\n max-width: 800px;\n margin: 0 auto;\n padding: 20px;\n }\n h1, h2 {\n color: #2c3e50;\n }\n table {\n width: 100%;\n border-collapse: collapse;\n margin-top: 20px;\n }\n th, td {\n border: 1px solid #ddd;\n padding: 8px;\n text-align: left;\n }\n th {\n background-color: #f2f2f2;\n }\n tr:nth-child(even) {\n background-color: #f9f9f9;\n }\n pre {\n white-space: pre-wrap;\n word-wrap: break-word;\n }\n`;","deleted","label",[98],"permalink","https://www.val.town/x/maxm/requestCollector/code/main.tsx","extension","actionData","errors"]