b5159e8976
However, the enum tree is not supported since they do not support them. But other than that, mysql and maria DB seem to both be supported.
83 lines
2.2 KiB
Go
83 lines
2.2 KiB
Go
package templates
|
|
|
|
import (
|
|
"fmt"
|
|
)
|
|
|
|
// Result list definition
|
|
const result_list_open string = `<ul id="query-results">`
|
|
const result_list_close string = `</ul>`
|
|
|
|
// Result item definition
|
|
const result_item string = `
|
|
<li class="overflow-x-auto overflow-y-hidden bg-white rounded-lg shadow-md mb-8">
|
|
%s
|
|
</li>
|
|
`
|
|
|
|
// Table wrapper definitions
|
|
const table_open string = `<table class="min-w-full divide-y divide-gray-200">`
|
|
const table_close string = `</table>`
|
|
|
|
// Header definitions
|
|
const table_head_open string = `<thead class="bg-gray-50"><tr>`
|
|
const table_head_close string = `</tr></thead>`
|
|
const table_head_row string = `<th scope="col" class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">%s</th>`
|
|
|
|
// Body definitions
|
|
const table_body_open string = `<tbody class="bg-white divide-y divide-gray-200">`
|
|
const table_body_close string = `</tbody>`
|
|
const table_body_row string = `<td class="px-6 py-4 whitespace-nowrap">%v</td>`
|
|
|
|
// Error message
|
|
const query_error_message string = `<p id="query-error" hx-swap-oob="outerHTML" class="text-red-500 py-2 text-sm">Query Error: %s</p>`
|
|
const query_error_message_blank string = `<p id="query-error" hx-swap-oob="outerHTML" class="text-red-500 py-2 text-sm hidden"></p>`
|
|
|
|
func ErrorQueryResults(e error) string {
|
|
return fmt.Sprintf(query_error_message, e.Error()) + result_list_open + result_list_close
|
|
}
|
|
|
|
func ConcatResults(items []string) string {
|
|
var html string = query_error_message_blank + result_list_open
|
|
|
|
for _, h := range items {
|
|
html += h
|
|
}
|
|
|
|
return html + result_list_close
|
|
}
|
|
|
|
func QueryResult(cols []string, rows []map[string]interface{}) string {
|
|
var head string = generateHead(cols)
|
|
|
|
body := table_body_open
|
|
for _, row := range rows {
|
|
body += generateRow(cols, row)
|
|
}
|
|
|
|
body += table_body_close
|
|
|
|
return fmt.Sprintf(result_item, table_open+head+body+table_close)
|
|
}
|
|
|
|
// Generate the tables head row
|
|
func generateHead(cols []string) string {
|
|
var html string = table_head_open
|
|
|
|
for _, col := range cols {
|
|
html += fmt.Sprintf(table_head_row, col)
|
|
}
|
|
|
|
return html + table_head_close
|
|
}
|
|
|
|
func generateRow(cols []string, data map[string]interface{}) string {
|
|
var row string = "<tr>"
|
|
|
|
for _, col := range cols {
|
|
row += fmt.Sprintf(table_body_row, data[col])
|
|
}
|
|
|
|
return row + "</tr>"
|
|
}
|