SQLite Query Interface

← Back to Home

\n\n

SQL Query

\n\n ${queryError ? `\n

\n Error: ${queryError}\n

\n ` : \"\"}\n\n ${queryResult ? `\n

Query Results

\n ${queryResult.rows && queryResult.rows.length > 0 ? `\n \n \n \n ${queryResult.columns ? queryResult.columns.map((col: string) => ``).join(\"\") : \"\"}\n \n \n \n ${queryResult.rows.map((row: any) => `\n \n ${Array.isArray(row)\n ? row.map(cell => ``).join(\"\")\n : Object.values(row).map(cell => ``).join(\"\")\n }\n \n `).join(\"\")}\n \n

${col}
${cell !== null ? cell : \"NULL\"}	${cell !== null ? cell : \"NULL\"}

\n ${queryResult.rows.length} row(s) returned\n

\n ` : `\n

Query executed successfully. No rows returned.

\n `}\n

\n ` : \"\"}\n\n ${!query ? `\n

Available Tables

Below are all the tables in the SQLite database:

\n\n ${tables.length > 0 ? `\n \n \n \n \n \n \n \n ${tables.map((row: any) => `\n \n \n \n `).join(\"\")}\n \n

Table Name
${row[0] \|\| row.name}

\n ` : `\n

\n No tables found in the database.\n

\n `}\n

\n ` : \"\"}\n `;\n\n return c.html(renderPageLayout('SQLite Query Interface', body));\n } catch (error) {\n const message = error instanceof Error ? error.message : \"Unknown error\";\n return c.html(`

Error: ${message}

`, 500);\n }\n}","deleted","label",[98],"permalink","https://www.val.town/x/flymaster/lifehub/code/sql.ts","extension","actionData","errors"]