private Match resultSetToMatch(ResultSet rs) throws SQLException {
        Match match = new Match();
        match.setId(rs.getLong("id"));
        match.setHomeTeam(teamMngr.findTeamByID(rs.getLong("hometeamid")));
        match.setAwayTeam(teamMngr.findTeamByID(rs.getLong("awayteamid")));
        match.setDatePlayed(rs.getDate("date"));
        match.setOwnGoals(new Score(rs.getInt("homeowngoals"), rs.getInt("awayowngoals")));
        match.setAdvantageGoals(new Score(rs.getInt("homeadvantagegoals"), rs.getInt("awayadvantagegoals")));
        match.setAdvantageGoals(new Score(rs.getInt("homecontumationgoals"), rs.getInt("awaycontumationgoals")));
        match.setTechnicalGoals(new Score(rs.getInt("hometechnicalgoals"), rs.getInt("awaytechnicalgoals")));
        match.setGoalsScored(getGoalsForMatch(match.getId()));
        switch (rs.getString("matchresult")) {
            case "REGULAR_TIME":
                match.setResult(MatchResult.REGULAR_TIME);
                break;
            case "OVER_TIME":
                match.setResult(MatchResult.OVER_TIME);
                break;
            case "CONTUMATED":
                match.setResult(MatchResult.CONTUMATED);
                break;
            case "PENALTIES":
                match.setResult(MatchResult.PENALTIES);
                break;
            case "DRAW":
                match.setResult(MatchResult.DRAW);
                break;
        }
        return match;
    }