database.go: query_list[T any]

1 files changed, 3 insertions, 20 deletions

diff --git a/http_handle_group_index.go b/http_handle_group_index.go
index c034853..834c0da 100644
--- a/http_handle_group_index.go
+++ b/http_handle_group_index.go
@@ -7,28 +7,11 @@ import (
 func handle_group_repos(w http.ResponseWriter, r *http.Request, params map[string]any) {
 	group_name := params["group_name"]
 
-	var names []string
-	rows, err := database.Query(r.Context(), "SELECT r.name FROM repos r JOIN groups g ON r.group_id = g.id WHERE g.name = $1;", group_name)
+	names, err := query_list[string](r.Context(), "SELECT r.name FROM repos r JOIN groups g ON r.group_id = g.id WHERE g.name = $1;", group_name)
 	if err != nil {
-		http.Error(w, "Error getting groups:: "+err.Error(), http.StatusInternalServerError)
-		return
-	}
-	defer rows.Close()
-
-	for rows.Next() {
-		var name string
-		if err := rows.Scan(&name); err != nil {
-			http.Error(w, "Error scanning row:: "+err.Error(), http.StatusInternalServerError)
-			return
-		}
-		names = append(names, name)
+	    http.Error(w, "Error getting groups:: "+err.Error(), http.StatusInternalServerError)
+	    return
 	}
-
-	if err := rows.Err(); err != nil {
-		http.Error(w, "Error iterating over rows:: "+err.Error(), http.StatusInternalServerError)
-		return
-	}
-
 	params["repos"] = names
 
 	err = templates.ExecuteTemplate(w, "group_repos", params)