aboutsummaryrefslogtreecommitdiff
path: root/http_handle_index.go
diff options
context:
space:
mode:
Diffstat (limited to 'http_handle_index.go')
-rw-r--r--http_handle_index.go20
1 files changed, 1 insertions, 19 deletions
diff --git a/http_handle_index.go b/http_handle_index.go
index 41a55e8..ee92c49 100644
--- a/http_handle_index.go
+++ b/http_handle_index.go
@@ -5,30 +5,12 @@ import (
)
func handle_index(w http.ResponseWriter, r *http.Request, params map[string]any) {
- rows, err := database.Query(r.Context(), "SELECT name, COALESCE(description, '') FROM groups")
+ groups, err := query_name_desc_list(r.Context(), "SELECT name, COALESCE(description, '') FROM groups")
if err != nil {
http.Error(w, "Error querying groups: "+err.Error(), http.StatusInternalServerError)
return
}
- defer rows.Close()
-
- groups := []name_desc_t{}
- for rows.Next() {
- var groupName, groupDescription string
- if err := rows.Scan(&groupName, &groupDescription); err != nil {
- http.Error(w, "Error scanning group: "+err.Error(), http.StatusInternalServerError)
- return
- }
- groups = append(groups, name_desc_t{groupName, groupDescription})
- }
-
- if err := rows.Err(); err != nil {
- http.Error(w, "Error iterating over rows: "+err.Error(), http.StatusInternalServerError)
- return
- }
-
params["groups"] = groups
-
err = templates.ExecuteTemplate(w, "index", params)
if err != nil {
http.Error(w, "Error rendering template: "+err.Error(), http.StatusInternalServerError)