// ListEvents should return a JSON list of events for a particular stadium. func ListEvents(c *gin.Context) { stadium := c.Param("stadium") if stadium == "" { errMsg := "Error: no stadium specified when requesting events!" fmt.Println(errMsg) c.JSON(http.StatusBadRequest, map[string]string{"status": errMsg}) } // Store the new event in the DB dbConn, dbErr := db.GetDBConnection() if dbErr != nil { fmt.Printf("Found err: %s\n", dbErr.Error()) c.JSON(http.StatusInternalServerError, map[string]string{"status": "Error cannot connect to DB!"}) return } // Find the `sid` by which the events will be selected var outStadium model.Stadium dbConn.Table("stadiums").Where("name = ?", stadium).First(&outStadium) fmt.Printf("Found sid=%d\n", outStadium.Sid) fmt.Printf("Getting events for stadium: %s\n", stadium) // Select all events in the events table by the `sid` eventList := make([]model.Event, 0, 3) dbConn.Where(&model.Event{Sid: outStadium.Sid}).Find(&eventList) response := make(map[string][]model.Event) response["events"] = eventList c.JSON(http.StatusOK, response) }
// CreateEvent is responsible for reading and parsing the JSON // string from the request body and persisting it ... somewhere. func CreateEvent(c *gin.Context) { var evt model.Event fmt.Printf("Content-Type from request: %s\n", c.ContentType()) err := c.Bind(&evt) if err == nil { fmt.Printf("Creating event: %v...\n", evt) // Store the new event in the DB dbConn, dbErr := db.GetDBConnection() if dbErr != nil { fmt.Printf("Found err: %s\n", dbErr.Error()) c.JSON(http.StatusInternalServerError, map[string]string{"status": "Error cannot connect to DB!"}) return } // Find the `sid` value that should be used when inserting the new event var outStadium model.Stadium dbConn.Table("stadiums").Where("name = ?", evt.Stadium.Name).First(&outStadium) fmt.Printf("Found sid=%d\n", outStadium.Sid) if outStadium.Sid == 0 { fmt.Println("Didn't find a stadium with that name!!") c.JSON(http.StatusBadRequest, map[string]string{"status": "Error no stadium with that name"}) return } evt.Sid = outStadium.Sid dbConn.Create(&evt) c.JSON(http.StatusCreated, map[string]string{"status": "Success"}) } else { errMsg := fmt.Sprintf("Error: %s", err.Error()) fmt.Println(errMsg) c.JSON(http.StatusBadRequest, map[string]string{"status": errMsg}) } }