projects
/
brackets.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
66744c0
)
Fix not requesting enough data for Scan
author
Jacob Casper
<dev@jacobcasper.com>
Fri, 17 Apr 2020 03:16:16 +0000
(22:16 -0500)
committer
Jacob Casper
<dev@jacobcasper.com>
Fri, 17 Apr 2020 03:16:16 +0000
(22:16 -0500)
backend/routes/artist/artist.go
patch
|
blob
|
blame
|
history
diff --git
a/backend/routes/artist/artist.go
b/backend/routes/artist/artist.go
index
d26f66d
..
5a584e3
100644
(file)
--- a/
backend/routes/artist/artist.go
+++ b/
backend/routes/artist/artist.go
@@
-166,7
+166,7
@@
func ByGenre(env *env.Env) routes.Handler {
genreName := r.FormValue("genre_name")
if genreName != "" {
rows, err := env.Db.Db.Query(`
genreName := r.FormValue("genre_name")
if genreName != "" {
rows, err := env.Db.Db.Query(`
-SELECT a.ID, a.NAME
+SELECT a.ID, a.NAME
, a.POPULARITY
FROM ARTIST a
JOIN ARTIST_GENRE_XREF x ON a.ID = x.ARTIST_ID
JOIN GENRE g ON g.ID = x.GENRE_ID
FROM ARTIST a
JOIN ARTIST_GENRE_XREF x ON a.ID = x.ARTIST_ID
JOIN GENRE g ON g.ID = x.GENRE_ID
@@
-185,6
+185,7
@@
WHERE g.NAME = lower(?)
for rows.Next() {
artist := types.Artist{}
if err := rows.Scan(&artist.ID, &artist.Name, &artist.Popularity); err != nil {
for rows.Next() {
artist := types.Artist{}
if err := rows.Scan(&artist.ID, &artist.Name, &artist.Popularity); err != nil {
+ log.Print(err)
http.Error(w, http.StatusText(http.StatusInternalServerError), http.StatusInternalServerError)
return
}
http.Error(w, http.StatusText(http.StatusInternalServerError), http.StatusInternalServerError)
return
}