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 }