Ejemplo n.º 1
0
func (repo *PgRepository) CreateGame(game *model.Game) error {
	err := game.Validate(repo)
	if err != nil {
		return err
	}

	t := time.Now()

	var id int
	err = repo.manager.db.QueryRow(`INSERT INTO game(season_id, start_time, home_team_id, away_team_id, created, modified)
	    VALUES($1, $2, $3, $4, $5, $6) RETURNING id`,
		game.Season.ID, game.StartTime, game.HomeTeam.ID, game.AwayTeam.ID, t, t).Scan(&id)

	if err != nil {
		return err
	}

	game.ID = id
	game.Created = t
	game.Modified = t

	return nil
}