commit 12af87e5b63aac20c9dccd1dd437b0b9db2ba113 parent 8b38039a288497bdf27fa0bfa464806d7aaa8154 Author: breadcat <breadcat@users.noreply.github.com> Date: Fri, 17 Oct 2025 09:22:11 +0100 Update autocompletes to not show empty categories Diffstat:
| M | main.go | | | 8 | +++++++- |
1 file changed, 7 insertions(+), 1 deletion(-)
diff --git a/main.go b/main.go @@ -824,7 +824,13 @@ func fileHandler(w http.ResponseWriter, r *http.Request) { return } - catRows, _ := db.Query("SELECT name FROM categories ORDER BY name") + catRows, _ := db.Query(` + SELECT DISTINCT c.name + FROM categories c + JOIN tags t ON t.category_id = c.id + JOIN file_tags ft ON ft.tag_id = t.id + ORDER BY c.name + `) var cats []string for catRows.Next() { var c string