SQLite Logs

\n \n \n \n ${\n result.rows.length === 0\n ? \"

No logs found. Try a different search query.

\"\n : `\n \n \n \n \n \n \n \n ${\n result.rows.map(row => `\n \n \n \n \n `).join(\"\")\n }\n \n

Time	Log
${new Date(row.ts).toLocaleString()}	\n ${escapeHtml(row.line)} \n ${escapeHtml(row.line)} \n

`\n }\n \n

\n ${renderPagination(page, result.pagination.pages, search, limit, order)}\n

\n\n \n\n`;\n\n return new Response(html, {\n headers: {\n \"Content-Type\": \"text/html; charset=utf-8\",\n },\n });\n}\n\n// Helper function to escape HTML for safe rendering\nfunction escapeHtml(unsafe: string): string {\n return unsafe\n .replace(/&/g, \"&\")\n .replace(//g, \">\")\n .replace(/\"/g, \""\")\n .replace(/'/g, \"'\");\n}\n\n// Helper function to render pagination links\nfunction renderPagination(\n currentPage: number,\n totalPages: number,\n search: string,\n limit: number,\n order: string,\n): string {\n if (totalPages <= 1) {\n return \"\";\n }\n\n let links = [];\n\n // Previous page link\n if (currentPage > 1) {\n links.push(\n `Previous`,\n );\n } else {\n links.push(`Previous`);\n }\n\n // Page number links\n const maxPagesToShow = 5;\n let startPage = Math.max(1, currentPage - Math.floor(maxPagesToShow / 2));\n let endPage = Math.min(totalPages, startPage + maxPagesToShow - 1);\n\n if (endPage - startPage + 1 < maxPagesToShow) {\n startPage = Math.max(1, endPage - maxPagesToShow + 1);\n }\n\n for (let i = startPage; i <= endPage; i++) {\n if (i === currentPage) {\n links.push(`${i}`);\n } else {\n links.push(`${i}`);\n }\n }\n\n // Next page link\n if (currentPage < totalPages) {\n links.push(\n `Next`,\n );\n } else {\n links.push(`Next`);\n }\n\n return links.join(\"\");\n}","deleted","label",[98],"permalink","https://www.val.town/x/stevekrouse/sqlitelogs/code/main.tsx","extension","actionData","errors"]