From: Jacob Casper <dev@jacobcasper.com>
Date: Sun, 19 Apr 2020 05:04:23 +0000 (-0500)
Subject: Order genres alphabetically
X-Git-Url: https://git.jacobcasper.com/?p=brackets.git;a=commitdiff_plain;h=67e00f5c12b7062f553434565cb0e09ab7a6c260

Order genres alphabetically
---

diff --git a/backend/routes/genre/genre.go b/backend/routes/genre/genre.go
index 0304b64..a3808e0 100644
--- a/backend/routes/genre/genre.go
+++ b/backend/routes/genre/genre.go
@@ -45,7 +45,8 @@ WHERE NAME = lower(?)`,
 
 		rows, err := env.Db.Db.Query(`
 SELECT ID, NAME
-FROM GENRE`,
+FROM GENRE
+ORDER BY NAME ASC`,
 		)
 		if err != nil {
 			http.Error(w, http.StatusText(http.StatusInternalServerError), http.StatusInternalServerError)