From 8cf1c857040222348c69b1981ebd3c0a937dee11 Mon Sep 17 00:00:00 2001 From: Runxi Yu Date: Sat, 15 Feb 2025 00:40:51 +0800 Subject: git_misc: COALESCE(r.description, '') --- git_misc.go | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'git_misc.go') diff --git a/git_misc.go b/git_misc.go index 7b7febb..29a2824 100644 --- a/git_misc.go +++ b/git_misc.go @@ -20,7 +20,7 @@ var ( func open_git_repo(ctx context.Context, group_name, repo_name string) (repo *git.Repository, description string, err error) { var fs_path string - err = database.QueryRow(ctx, "SELECT r.filesystem_path, r.description FROM repos r JOIN groups g ON r.group_id = g.id WHERE g.name = $1 AND r.name = $2;", group_name, repo_name).Scan(&fs_path, &description) + err = database.QueryRow(ctx, "SELECT r.filesystem_path, COALESCE(r.description, '') FROM repos r JOIN groups g ON r.group_id = g.id WHERE g.name = $1 AND r.name = $2;", group_name, repo_name).Scan(&fs_path, &description) if err != nil { return nil, "", err } -- cgit v1.2.3