backend/routes/genre/genre.go

   1 package genre
   2
   3 import (
   4         "encoding/json"
   5         "git.jacobcasper.com/brackets/env"
   6         "git.jacobcasper.com/brackets/routes"
   7         "git.jacobcasper.com/brackets/types"
   8         "log"
   9         "net/http"
  10 )
  11
  12 func Index(env *env.Env) routes.Handler {
  13         return func(w http.ResponseWriter, r *http.Request) {
  14                 if r.Method != "GET" {
  15                         http.Error(w, http.StatusText(http.StatusMethodNotAllowed), http.StatusMethodNotAllowed)
  16                         return
  17                 }
  18
  19                 w.Header().Set("Access-Control-Allow-Origin", env.CorsOrigin)
  20                 w.Header().Set("Vary", "Origin")
  21                 w.Header().Set("Content-Type", "application/json")
  22
  23                 genreName := r.FormValue("name")
  24                 if genreName != "" {
  25                         genre := types.Genre{}
  26                         row := env.Db.Db.QueryRow(`
  27 SELECT ID, NAME
  28 FROM GENRE
  29 WHERE NAME = lower(?)`,
  30                                 genreName,
  31                         )
  32                         if err := row.Scan(&genre.ID, &genre.Name); err != nil {
  33                                 http.Error(w, http.StatusText(http.StatusInternalServerError), http.StatusInternalServerError)
  34                                 return
  35                         }
  36                         b, err := json.Marshal(genre)
  37                         if err != nil {
  38                                 log.Print(err)
  39                                 http.Error(w, http.StatusText(http.StatusInternalServerError), http.StatusInternalServerError)
  40                                 return
  41                         }
  42                         w.Write(b)
  43                         return
  44                 }
  45
  46                 rows, err := env.Db.Db.Query(`
  47 SELECT ID, NAME
  48 FROM GENRE`,
  49                 )
  50                 if err != nil {
  51                         http.Error(w, http.StatusText(http.StatusInternalServerError), http.StatusInternalServerError)
  52                         return
  53                 }
  54                 defer rows.Close()
  55
  56                 genres := make([]types.Genre, 0)
  57                 for rows.Next() {
  58                         genre := types.Genre{}
  59                         if err := rows.Scan(&genre.ID, &genre.Name); err != nil {
  60                                 http.Error(w, http.StatusText(http.StatusInternalServerError), http.StatusInternalServerError)
  61                                 return
  62                         }
  63                         genres = append(genres, genre)
  64                 }
  65                 if err = rows.Err(); err != nil {
  66                         log.Print(err)
  67                         http.Error(w, http.StatusText(http.StatusInternalServerError), http.StatusInternalServerError)
  68                         return
  69                 }
  70                 b, err := json.Marshal(genres)
  71                 if err != nil {
  72                         log.Print(err)
  73                         http.Error(w, http.StatusText(http.StatusInternalServerError), http.StatusInternalServerError)
  74                         return
  75                 }
  76                 w.Write(b)
  77         }
  78 }