From 114dd59d703d00efe86ad02eb956aa5343daa08e Mon Sep 17 00:00:00 2001 From: Runxi Yu Date: Wed, 19 Feb 2025 21:24:47 +0800 Subject: all: Use COALESCE to handle some nullable database fields --- http_handle_repo_contrib_index.go | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'http_handle_repo_contrib_index.go') diff --git a/http_handle_repo_contrib_index.go b/http_handle_repo_contrib_index.go index 94a24b8..e864dfa 100644 --- a/http_handle_repo_contrib_index.go +++ b/http_handle_repo_contrib_index.go @@ -11,7 +11,7 @@ type id_title_status_t struct { } func handle_repo_contrib_index(w http.ResponseWriter, r *http.Request, params map[string]any) { - rows, err := database.Query(r.Context(), "SELECT id, title, status FROM merge_requests WHERE repo_id = $1", params["repo_id"]) + rows, err := database.Query(r.Context(), "SELECT id, COALESCE(title, 'Untitled'), status FROM merge_requests WHERE repo_id = $1", params["repo_id"]) if err != nil { http.Error(w, "Error querying merge requests: "+err.Error(), http.StatusInternalServerError) return -- cgit v1.2.3