projects
/
brackets.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Track artist popularity
[brackets.git]
/
routes
/
artist
/
artist.go
diff --git
a/routes/artist/artist.go
b/routes/artist/artist.go
index
33122f5
..
d26f66d
100644
(file)
--- a/
routes/artist/artist.go
+++ b/
routes/artist/artist.go
@@
-24,12
+24,12
@@
func Index(env *env.Env) routes.Handler {
if artistId != "" {
artist := types.Artist{}
row := env.Db.Db.QueryRow(`
if artistId != "" {
artist := types.Artist{}
row := env.Db.Db.QueryRow(`
-SELECT ID, NAME
+SELECT ID, NAME
, POPULARITY
FROM ARTIST
WHERE ID = ?`,
artistId,
)
FROM ARTIST
WHERE ID = ?`,
artistId,
)
- if err := row.Scan(&artist.ID, &artist.Name); err != nil {
+ if err := row.Scan(&artist.ID, &artist.Name
, &artist.Popularity
); err != nil {
http.Error(w, http.StatusText(http.StatusInternalServerError), http.StatusInternalServerError)
return
}
http.Error(w, http.StatusText(http.StatusInternalServerError), http.StatusInternalServerError)
return
}
@@
-44,7
+44,7
@@
WHERE ID = ?`,
}
rows, err := env.Db.Db.Query(`
}
rows, err := env.Db.Db.Query(`
-SELECT ID, NAME
+SELECT ID, NAME
, POPULARITY
FROM ARTIST
LIMIT 20`,
)
FROM ARTIST
LIMIT 20`,
)
@@
-57,7
+57,7
@@
LIMIT 20`,
artists := make([]types.Artist, 0)
for rows.Next() {
artist := types.Artist{}
artists := make([]types.Artist, 0)
for rows.Next() {
artist := types.Artist{}
- if err := rows.Scan(&artist.ID, &artist.Name); err != nil {
+ if err := rows.Scan(&artist.ID, &artist.Name
, &artist.Popularity
); err != nil {
http.Error(w, http.StatusText(http.StatusInternalServerError), http.StatusInternalServerError)
return
}
http.Error(w, http.StatusText(http.StatusInternalServerError), http.StatusInternalServerError)
return
}
@@
-104,10
+104,11
@@
func Add(env *env.Env) routes.Handler {
defer env.Db.Mu.Unlock()
env.Db.Db.Exec(`
INSERT INTO ARTIST
defer env.Db.Mu.Unlock()
env.Db.Db.Exec(`
INSERT INTO ARTIST
-(ID, NAME)
-VALUES (?, ?)`,
+(ID, NAME
, POPULARITY
)
+VALUES (?, ?
, ?
)`,
artist.ID,
artist.Name,
artist.ID,
artist.Name,
+ artist.Popularity,
)
for _, genre := range artist.Genres {
)
for _, genre := range artist.Genres {
@@
-183,7
+184,7
@@
WHERE g.NAME = lower(?)
artists := make([]types.Artist, 0)
for rows.Next() {
artist := types.Artist{}
artists := make([]types.Artist, 0)
for rows.Next() {
artist := types.Artist{}
- if err := rows.Scan(&artist.ID, &artist.Name); err != nil {
+ if err := rows.Scan(&artist.ID, &artist.Name
, &artist.Popularity
); err != nil {
http.Error(w, http.StatusText(http.StatusInternalServerError), http.StatusInternalServerError)
return
}
http.Error(w, http.StatusText(http.StatusInternalServerError), http.StatusInternalServerError)
return
}