main.go

package main

import (
	"database/sql"
	"encoding/json"
	"fmt"
	"log"
	"net/http"

	_ "github.com/go-sql-driver/mysql"
	"github.com/gorilla/mux"
)

//Game struct
type Game struct {
	GameID   int    `json:"game_id"`
	GameName string `json:"game_name"`
	Genre    Genre  `json:"Genre"`
}

//Genre struct
type Genre struct {
	GenreID   int    `json:"genre_id"`
	GenreName string `json:"genre_name"`
}

func getGames() []Game {
	var games []Game

	db, err := sql.Open("mysql", "root:kane@(127.0.0.1:3306)/gogames")
	if err != nil {
		panic(err.Error())
	}
	defer db.Close()
	fmt.Println("success!!")

	rows, err := db.Query("SELECT game_id, game_name, genre_id, genre_name FROM games LEFT JOIN genres ON genre_id = genre_fk")
	if err != nil {
		panic(err.Error())
	}
	for rows.Next() {
		var game Game

		rows.Scan(&game.GameID, &game.GameName, &game.Genre.GenreID, &game.Genre.GenreName)

		games = append(games, game)
	}

	return games
}

func returnGames(w http.ResponseWriter, r *http.Request) {
	w.Header().Set("Content-Type", "application/json")
	json.NewEncoder(w).Encode(getGames())
}

func createGame(w http.ResponseWriter, r *http.Request) {
	w.Header().Set("Content-Type", "application/json")

	db, err := sql.Open("mysql", "root:kane@(127.0.0.1:3306)/gogames")
	if err != nil {
		log.Fatal(err)
	}
	defer db.Close()

	stmt, err := db.Prepare("INSERT INTO games(game_name, genre_fk) VALUES( ?, ?)")
	if err != nil {
		log.Fatal(err)
	}
	defer stmt.Close()

	var game Game
	_ = json.NewDecoder(r.Body).Decode(&game)

	if _, err := stmt.Exec(game.GameName, game.Genre.GenreID); err != nil {
		log.Fatal(err)
	}

	fmt.Println("success!!")

}

func main() {
	r := mux.NewRouter()

	r.HandleFunc("/games", returnGames).Methods("GET")
	r.HandleFunc("/games", createGame).Methods("POST")

	log.Fatal(http.ListenAndServe(":4444", r))
}