Пример #1
0
def show_series():
    """ Show series information between two teams for a season."""
    rd = setup_nav()
    form = SeriesSummaryForm(request.form)
    teamgames = get_r_seasons()
    # Update season choices based on teamgames data
    form.season.choices = [(x, str(x)[0:4] + "-" + str(x)[4:])
                           for x in sorted(teamgames.keys(), reverse=True)]

    if request.method == "POST":
        period = constants.periods_options[form.period.data]["value"]
    else:
        # All periods by default
        period = [0]
        period.extend(
            constants.periods_options[constants.periods["default"]]["value"])

    tablecolumns = form.tablecolumns.data

    # Find games where these teams faced each other
    games = GamesTest.query.filter(
        GamesTest.season == form.season.data,
        or_(GamesTest.hometeam == form.team1.data,
            GamesTest.hometeam == form.team2.data),
        or_(GamesTest.awayteam == form.team1.data,
            GamesTest.awayteam == form.team2.data))
    gcodes = set()
    for game in games:
        gcodes.add(game.gcode)

    # Overall game data
    gamedata = []
    # Team specific data for table
    teams = []
    # Goalie specific data for goalie table
    goalies = []

    # Values that should be skipped in accumulation
    skip = [
        "period", "home", "Opponent", "gamestate", "gcode", "Team", "TOI",
        "Gm", "ID", "season"
    ]

    gamefound = set()
    foundplayers = set()
    goaliefound = set()
    playerfound = set()
    away = []
    home = []
    allplayers = []
    playerteams = {}
    players = set()
    coplayers = {}
    pbp = []
    # For each gcode, get the RData file for that game
    for gcode in gcodes:
        rdata = get_rdata("http://data.war-on-ice.net/games/" +
                          str(form.season.data) + str(gcode) + ".RData")
        pbp.extend(rdata["playbyplay"])
        rteamrun = rdata["teamrun"]
        coplayers = get_coplayers(rdata, coplayers)
        for tr in sorted(rteamrun, key=lambda x: x["TOI"], reverse=True):
            gid = str(tr["gcode"]) + str(tr["season"]) + str(tr["Team"])
            if tr["period"] in period and int(tr["gamestate"]) == int(
                    form.teamstrengths.data) and gid not in gamefound:
                gamefound.add(gid)
                ar = None
                for team in teams:
                    if team["Team"] == tr["Team"]:
                        ar = team
                        break
                if ar is None:
                    tr["MSF"] = int(tr["FF"]) - int(tr["SF"])
                    tr["BSF"] = tr["CF"] - tr["MSF"] - tr["SF"]
                    teams.append(tr)
                else:
                    for key in tr:
                        if key not in skip:
                            ar[key] += tr[key]
                    ar["MSF"] += int(tr["FF"]) - int(tr["SF"])
                    ar["BSF"] += tr["CF"] - (int(tr["FF"]) -
                                             int(tr["SF"])) - tr["SF"]
                    ar["TOI"] += float(tr["TOI"])
        rgoalies = rdata["goalierun"]
        for tr in sorted(rgoalies, key=lambda x: x["TOI"], reverse=True):
            gid = str(tr["gcode"]) + str(tr["season"]) + str(tr["Team"]) + str(
                tr["ID"])
            if tr["period"] in period and tr["gamestate"] == int(
                    form.teamstrengths.data) and gid not in goaliefound:
                goaliefound.add(gid)
                ar = None
                for goalie in goalies:
                    if goalie["ID"] == tr["ID"] and goalie["Team"] == tr[
                            "Team"]:
                        ar = goalie
                        break
                if ar is None:
                    tr["gu"] = tr["goals.0"]
                    tr["su"] = tr["shots.0"]
                    tr["gl"] = tr["goals.1"]
                    tr["sl"] = tr["shots.1"]
                    tr["gm"] = tr["goals.2"]
                    tr["sm"] = tr["shots.2"]
                    tr["gh"] = tr["goals.3"] + tr["goals.4"]
                    tr["sh"] = tr["shots.3"] + tr["shots.4"]
                    tr["TOI"] = float(
                        tr["TOI"])  # round(float(tr["TOI"]) / 60.0, 1)
                    tr["Gm"] = 1
                    goalies.append(tr)
                    foundplayers.add(tr["ID"])
                else:
                    ar["gu"] += tr["goals.0"]
                    ar["su"] += tr["shots.0"]
                    ar["gl"] += tr["goals.1"]
                    ar["sl"] += tr["shots.1"]
                    ar["gm"] += tr["goals.2"]
                    ar["sm"] += tr["shots.2"]
                    ar["gh"] += tr["goals.3"] + tr["goals.4"]
                    ar["sh"] += tr["shots.3"] + tr["shots.4"]
                    ar["TOI"] += float(
                        tr["TOI"])  #round(float(tr["TOI"]) / 60.0, 1)
                    ar["Gm"] += 1
        rplayerrun = rdata["playerrun"]
        for tr in sorted(rplayerrun, key=lambda x: x["TOI"], reverse=True):
            if tr["ID"] not in foundplayers:
                foundplayers.add(tr["ID"])
            gid = str(tr["gcode"]) + str(tr["season"]) + str(tr["Team"]) + str(
                tr["ID"])
            if tr["period"] in period and tr["gamestate"] == int(
                    form.teamstrengths.data) and gid not in playerfound:
                playerfound.add(gid)
                players.add(tr["ID"])
                ar = None
                pteam = None
                for p in allplayers:
                    if p["ID"] == tr["ID"]:
                        ar = p
                        break
                if ar is None:
                    tr["G"] = int(tr["GOAL1"] + tr["GOAL2"] + tr["GOAL3"] +
                                  tr["GOAL4"])
                    tr["TOI"] = float(
                        tr["TOI"])  # round(float(tr["TOI"]) / 60.0, 1)
                    tr["Gm"] = 1
                    allplayers.append(tr)
                    playerteams[tr["ID"]] = tr["Team"]
                else:
                    for key in tr:
                        if key not in skip:
                            ar[key] += tr[key]
                    ar["G"] += int(tr["GOAL1"] + tr["GOAL2"] + tr["GOAL3"] +
                                   tr["GOAL4"])
                    ar["TOI"] += float(
                        tr["TOI"])  # round(float(tr["TOI"]) / 60.0, 1)
                    ar["Gm"] += 1

    ht = None
    at = None
    for player in allplayers:
        if ht is None:
            home.append(player)
            ht = player["Team"]
        elif ht == player["Team"]:
            home.append(player)
        elif at == None:
            away.append(player)
        else:
            away.append(player)

    for co in coplayers:
        matchup = coplayers[co]
        for p in ["p1", "p2"]:
            foundplayers.add(matchup[p])

    woiid = get_player_info(foundplayers)

    hvh, hometeam, awayteam = get_hvh(coplayers, playerteams, woiid)

    homecorsi = []
    awaycorsi = []
    for line in home:
        for key in line:
            if type(line[key]).__module__ == "numpy" and numpy.isnan(
                    line[key]):
                line[key] = 0
        if line["ID"] in woiid and woiid[line["ID"]]["pos"] != "G":
            line["full_name"] = str(woiid[line["ID"]]["full_name"])
            homecorsi.append(line)
    for line in away:
        for key in line:
            if type(line[key]).__module__ == "numpy" and numpy.isnan(
                    line[key]):
                line[key] = 0
        if line["ID"] in woiid and woiid[line["ID"]]["pos"] != "G":
            line["full_name"] = str(woiid[line["ID"]]["full_name"])
            awaycorsi.append(line)
    # ev.team
    pbphome = []
    pbpaway = []
    scoresituations = int(form.scoresituations.data)
    for play in pbp:
        if play["period"] in period and (
                play["score.diff.cat"] == scoresituations or scoresituations
                == 7) and play["etype"] in ["GOAL", "SHOT", "BLOCK", "MISS"]:
            for key in play:
                if type(play[key]).__module__ == "numpy" and numpy.isnan(
                        play[key]):
                    play[key] = 0
            # get Names
            if play["ev.player.1"] != "xxxxxxxNA":
                play["P1"] = woiid[play["ev.player.1"]]["full_name"]
            if play["ev.player.2"] != "xxxxxxxNA":
                play["P2"] = woiid[play["ev.player.2"]]["full_name"]
            if play["ev.player.3"] != "xxxxxxxNA":
                play["P3"] = woiid[play["ev.player.3"]]["full_name"]
            if play["ev.team"] == hometeam:
                if int(form.teamstrengths.data) in calc_strengths(play, True):
                    pbphome.append(play)
            elif play["ev.team"] == awayteam:
                if int(form.teamstrengths.data) in calc_strengths(play, False):
                    pbpaway.append(play)

    return render_template("game/series.html",
                           rd=rd,
                           hvh=hvh,
                           form=form,
                           woiid=woiid,
                           teamrun=teams,
                           goalies=goalies,
                           hometeam=hometeam,
                           awayteam=awayteam,
                           gamedata=gamedata,
                           coplayers=coplayers,
                           home=home,
                           homecorsi=homecorsi,
                           away=away,
                           awaycorsi=awaycorsi,
                           pbphome=pbphome,
                           pbpaway=pbpaway,
                           tablecolumns=int(tablecolumns))
Пример #2
0
def show_series():
    """ Show series information between two teams for a season."""
    rd = setup_nav()
    form = SeriesSummaryForm(request.form)
    teamgames = get_r_seasons()
    # Update season choices based on teamgames data
    form.season.choices = [(x, str(x)[0:4] + "-" + str(x)[4:]) for x in sorted(teamgames.keys(), reverse=True)]

    if request.method == "POST":
        period = constants.periods_options[form.period.data]["value"]
    else:
        # All periods by default
        period = [0]
        period.extend(constants.periods_options[constants.periods["default"]]["value"])

    tablecolumns = form.tablecolumns.data

    # Find games where these teams faced each other
    games = GamesTest.query.filter(GamesTest.season==form.season.data, or_(GamesTest.hometeam==form.team1.data, GamesTest.hometeam==form.team2.data),
        or_(GamesTest.awayteam==form.team1.data, GamesTest.awayteam==form.team2.data))
    gcodes = set()
    for game in games:
        gcodes.add(game.gcode)

    # Overall game data
    gamedata = []
    # Team specific data for table
    teams = []
    # Goalie specific data for goalie table
    goalies = []

    # Values that should be skipped in accumulation
    skip = ["period", "home", "Opponent", "gamestate", "gcode", "Team", "TOI", "Gm", "ID", "season"]

    gamefound = set()
    foundplayers = set()
    goaliefound = set()
    playerfound = set()
    away = []
    home = []
    allplayers = []
    playerteams = {}
    players = set()
    coplayers = {}
    pbp = []
    # For each gcode, get the RData file for that game
    for gcode in gcodes:
        rdata = get_rdata("http://data.war-on-ice.net/games/" + str(form.season.data) + str(gcode) + ".RData")
        pbp.extend(rdata["playbyplay"])
        rteamrun = rdata["teamrun"]
        coplayers = get_coplayers(rdata, coplayers)
        for tr in sorted(rteamrun, key=lambda x: x["TOI"], reverse=True):
            gid = str(tr["gcode"]) + str(tr["season"]) + str(tr["Team"])
            if tr["period"] in period and int(tr["gamestate"]) == int(form.teamstrengths.data) and gid not in gamefound:
                gamefound.add(gid)
                ar = None
                for team in teams:
                    if team["Team"] == tr["Team"]:
                        ar = team
                        break
                if ar is None:
                    tr["MSF"] = int(tr["FF"]) - int(tr["SF"])
                    tr["BSF"] = tr["CF"] - tr["MSF"] - tr["SF"]
                    teams.append(tr)
                else:
                    for key in tr:
                        if key not in skip:
                            ar[key] += tr[key]
                    ar["MSF"] += int(tr["FF"]) - int(tr["SF"])
                    ar["BSF"] += tr["CF"] - (int(tr["FF"]) - int(tr["SF"])) - tr["SF"]
                    ar["TOI"] += float(tr["TOI"])
        rgoalies = rdata["goalierun"]
        for tr in sorted(rgoalies, key=lambda x: x["TOI"], reverse=True):
            gid = str(tr["gcode"]) + str(tr["season"]) + str(tr["Team"]) + str(tr["ID"])
            if tr["period"] in period and tr["gamestate"] == int(form.teamstrengths.data) and gid not in goaliefound:
                goaliefound.add(gid)
                ar = None
                for goalie in goalies:
                    if goalie["ID"] == tr["ID"] and goalie["Team"] == tr["Team"]:
                        ar = goalie
                        break
                if ar is None:
                    tr["gu"] = tr["goals.0"]
                    tr["su"] = tr["shots.0"]
                    tr["gl"] = tr["goals.1"]
                    tr["sl"] = tr["shots.1"]
                    tr["gm"] = tr["goals.2"]
                    tr["sm"] = tr["shots.2"]
                    tr["gh"] = tr["goals.3"] + tr["goals.4"]
                    tr["sh"] = tr["shots.3"] + tr["shots.4"]
                    tr["TOI"] = float(tr["TOI"]) # round(float(tr["TOI"]) / 60.0, 1)
                    tr["Gm"] = 1
                    goalies.append(tr)
                    foundplayers.add(tr["ID"])
                else:
                    ar["gu"] += tr["goals.0"]
                    ar["su"] += tr["shots.0"]
                    ar["gl"] += tr["goals.1"]
                    ar["sl"] += tr["shots.1"]
                    ar["gm"] += tr["goals.2"]
                    ar["sm"] += tr["shots.2"]
                    ar["gh"] += tr["goals.3"] + tr["goals.4"]
                    ar["sh"] += tr["shots.3"] + tr["shots.4"]
                    ar["TOI"] += float(tr["TOI"])  #round(float(tr["TOI"]) / 60.0, 1)
                    ar["Gm"] += 1
        rplayerrun = rdata["playerrun"]
        for tr in sorted(rplayerrun, key=lambda x: x["TOI"], reverse=True):
            if tr["ID"] not in foundplayers:
                foundplayers.add(tr["ID"])
            gid = str(tr["gcode"]) + str(tr["season"]) + str(tr["Team"]) + str(tr["ID"])
            if tr["period"] in period and tr["gamestate"] == int(form.teamstrengths.data) and gid not in playerfound:
                playerfound.add(gid)
                players.add(tr["ID"])
                ar = None
                pteam = None
                for p in allplayers:
                    if p["ID"] == tr["ID"]:
                        ar = p
                        break
                if ar is None:
                    tr["G"] = int(tr["GOAL1"] + tr["GOAL2"] + tr["GOAL3"] + tr["GOAL4"])
                    tr["TOI"] = float(tr["TOI"]) # round(float(tr["TOI"]) / 60.0, 1)
                    tr["Gm"] = 1
                    allplayers.append(tr)
                    playerteams[tr["ID"]] = tr["Team"]
                else:
                    for key in tr:
                        if key not in skip:
                            ar[key] += tr[key]
                    ar["G"] += int(tr["GOAL1"] + tr["GOAL2"] + tr["GOAL3"] + tr["GOAL4"])
                    ar["TOI"] += float(tr["TOI"]) # round(float(tr["TOI"]) / 60.0, 1)
                    ar["Gm"] += 1

    ht = None
    at = None
    for player in allplayers:
        if ht is None:
            home.append(player)
            ht = player["Team"]
        elif ht == player["Team"]:
            home.append(player)
        elif at == None:
            away.append(player)
        else:
            away.append(player)

    for co in coplayers:
        matchup = coplayers[co]
        for p in ["p1", "p2"]:
            foundplayers.add(matchup[p])

    woiid = get_player_info(foundplayers)

    hvh, hometeam, awayteam = get_hvh(coplayers, playerteams, woiid)

    homecorsi = []
    awaycorsi = []
    for line in home:
        for key in line:
            if type(line[key]).__module__ == "numpy" and numpy.isnan(line[key]):
                line[key] = 0
        if line["ID"] in woiid and woiid[line["ID"]]["pos"] != "G":
            line["full_name"] = str(woiid[line["ID"]]["full_name"])
            homecorsi.append(line)
    for line in away:
        for key in line:
            if type(line[key]).__module__ == "numpy" and numpy.isnan(line[key]):
                line[key] = 0
        if line["ID"] in woiid and woiid[line["ID"]]["pos"] != "G":
            line["full_name"] = str(woiid[line["ID"]]["full_name"])
            awaycorsi.append(line)
    # ev.team
    pbphome = []
    pbpaway = []
    scoresituations = int(form.scoresituations.data)
    for play in pbp:
        if play["period"] in period and (play["score.diff.cat"] == scoresituations or scoresituations == 7) and play["etype"] in ["GOAL", "SHOT", "BLOCK", "MISS"]:
            for key in play:
                if type(play[key]).__module__ == "numpy" and numpy.isnan(play[key]):
                    play[key] = 0
            # get Names
            if play["ev.player.1"] != "xxxxxxxNA":
                play["P1"] = woiid[play["ev.player.1"]]["full_name"]
            if play["ev.player.2"] != "xxxxxxxNA":
                play["P2"] = woiid[play["ev.player.2"]]["full_name"]
            if play["ev.player.3"] != "xxxxxxxNA":
                play["P3"] = woiid[play["ev.player.3"]]["full_name"]
            if play["ev.team"] == hometeam:
                if int(form.teamstrengths.data) in calc_strengths(play, True):
                    pbphome.append(play)
            elif play["ev.team"] == awayteam:
                if int(form.teamstrengths.data) in calc_strengths(play, False):
                    pbpaway.append(play)

    return render_template("game/series.html",
        rd=rd,
        hvh=hvh,
        form=form,
        woiid=woiid,
        teamrun=teams,
        goalies=goalies,
        hometeam=hometeam,
        awayteam=awayteam,
        gamedata=gamedata,
        coplayers=coplayers,
        home=home, homecorsi=homecorsi,
        away=away, awaycorsi=awaycorsi,
        pbphome=pbphome, pbpaway=pbpaway,
        tablecolumns=int(tablecolumns))
Пример #3
0
def show_game_summary_tables(gameId):
    rd = setup_nav()

    if request.method == "GET":
        tablecolumns = request.args.get("tablecolumns")
        teamstrengths = request.args.get("teamstrengths")
        scoresituations = request.args.get("scoresituation")
        period = constants.periods_options[request.args.get("period")]["value"]
    else:
        tablecolumns = "0"
        teamstrengths = constants.strength_situations_dict[
            constants.strength_situations["default"]]["value"]
        scoresituations = constants.score_situations_dict[
            constants.score_situations["default"]]["value"]
        period = [0]
        period.extend(
            constants.periods_options[constants.periods["default"]]["value"])

    # Get game information from URL
    season = gameId[0:8]
    gcode = gameId[8:]

    # Prepare form results for queries
    scorediffcat = int(scoresituations)
    gamestate = int(teamstrengths)
    period = [int(x) for x in period]

    rdata = get_rdata("http://data.war-on-ice.net/games/" + season + gcode +
                      ".RData")

    eventcount = {
        "homepp": [],
        "awaypp": [],
        "4v4": [],
        "homegoal": [],
        "awaygoal": [],
        "emptynet": [],
        "homesc": [{
            "seconds": 0,
            "value": 0
        }],
        "awaysc": [{
            "seconds": 0,
            "value": 0
        }],
        "homesa": [{
            "seconds": 0,
            "value": 0
        }],
        "awaysa": [{
            "seconds": 0,
            "value": 0
        }],
        "pend": []
    }
    pbp = rdata["playbyplay"]

    rteamrun = rdata["teamrun"]
    teamrun = []
    teams = set()
    hometeam = ""
    awayteam = ""
    previous = 1000
    for tr in sorted(rteamrun, key=lambda x: x["TOI"], reverse=True):
        if hometeam == "" and tr["home"] == 1:
            hometeam = tr["Team"]
        elif awayteam == "" and tr["home"] == 0:
            awayteam = tr["Team"]
        if tr["period"] in period and tr["gamestate"] == gamestate:
            if tr["Team"] not in teams:
                tr["MSF"] = int(tr["FF"]) - int(tr["SF"])
                tr["BSF"] = tr["CF"] - tr["MSF"] - tr["SF"]
                tr["TOI"] = float(
                    tr["TOI"])  # round(float(tr["TOI"]) / 60.0, 1)
                teamrun.append(tr)
                teams.add(tr["Team"])
    goalies = []
    rgoalies = rdata["goalierun"]
    teams = set()
    foundplayers = set()
    for tr in sorted(rgoalies, key=lambda x: x["TOI"], reverse=True):
        if tr["period"] in period and tr["gamestate"] == gamestate:
            if tr["ID"] not in foundplayers:
                tr["gu"] = tr["goals.0"]
                tr["su"] = tr["shots.0"]
                tr["gl"] = tr["goals.1"]
                tr["sl"] = tr["shots.1"]
                tr["gm"] = tr["goals.2"]
                tr["sm"] = tr["shots.2"]
                tr["gh"] = tr["goals.3"] + tr["goals.4"]
                tr["sh"] = tr["shots.3"] + tr["shots.4"]
                tr["TOI"] = float(
                    tr["TOI"])  # round(float(tr["TOI"]) / 60.0, 1)
                goalies.append(tr)
                teams.add(tr["Team"])
                foundplayers.add(tr["ID"])

    rplayerrun = rdata["playerrun"]
    away = []
    home = []
    players = set()
    playerteams = {}
    for tr in sorted(rplayerrun, key=lambda x: x["TOI"], reverse=True):
        if tr["ID"] not in foundplayers:
            foundplayers.add(tr["ID"])
            playerteams[tr["ID"]] = tr["Team"]
        if tr["period"] in period and tr["gamestate"] == gamestate and tr[
                "ID"] not in players:
            players.add(tr["ID"])
            tr["G"] = int(tr["GOAL1"] + tr["GOAL2"] + tr["GOAL3"] +
                          tr["GOAL4"])
            tr["TOI"] = float(tr["TOI"])  #round(float(tr["TOI"]) / 60.0, 1)
            if tr["home"] == 1:
                home.append(tr)
            else:
                away.append(tr)

    # Get GamesTest information
    gamedata = GamesTest.query.filter_by(season=season,
                                         gcode=int(gcode)).first()

    woiid = get_player_info(foundplayers)

    homecorsi = []
    awaycorsi = []
    for line in home:
        for key in line:
            if type(line[key]).__module__ == "numpy" and numpy.isnan(
                    line[key]):
                line[key] = 0
        if line["ID"] in woiid and woiid[line["ID"]]["pos"] != "G":
            line["full_name"] = str(woiid[line["ID"]]["full_name"])
            homecorsi.append(line)
    for line in away:
        for key in line:
            if type(line[key]).__module__ == "numpy" and numpy.isnan(
                    line[key]):
                line[key] = 0
        if line["ID"] in woiid and woiid[line["ID"]]["pos"] != "G":
            line["full_name"] = str(woiid[line["ID"]]["full_name"])
            awaycorsi.append(line)

    pbphome = []
    pbpaway = []

    for play in pbp:
        if play["period"] in period and (play["score.diff.cat"]
                                         == int(scoresituations)
                                         or int(scoresituations) == 7):
            if play["etype"] in ["MISS", "GOAL", "SHOT", "BLOCK"]:
                # Shot Attempt
                if play["ev.team"] == hometeam:
                    if gamestate in calc_strengths(play, True):
                        eventcount["homesa"].append({
                            "seconds":
                            play["seconds"],
                            "value":
                            len(eventcount["homesa"])
                        })
                        eventcount["homesc"] = calc_sc(eventcount["homesc"],
                                                       play)
                else:
                    if gamestate in calc_strengths(play, False):
                        eventcount["awaysa"].append({
                            "seconds":
                            play["seconds"],
                            "value":
                            len(eventcount["awaysa"])
                        })
                        eventcount["awaysc"] = calc_sc(eventcount["awaysc"],
                                                       play)
                # Goal
                if play["etype"] == "GOAL":
                    if play["ev.team"] == hometeam:
                        eventcount["homegoal"].append({
                            "seconds":
                            play["seconds"],
                            "value":
                            len(eventcount["homegoal"]) + 1
                        })
                    else:
                        eventcount["awaygoal"].append({
                            "seconds":
                            play["seconds"],
                            "value":
                            len(eventcount["awaygoal"]) + 1
                        })
            elif play["etype"] == "PENL":
                # Penalty
                seconds = int(re.findall("\d+", play["type"])[0]) * 60
                if play["ev.team"] == hometeam:
                    eventcount["awaypp"].append({
                        "seconds": play["seconds"],
                        "length": seconds
                    })
                elif play["ev.team"] == awayteam:
                    eventcount["homepp"].append({
                        "seconds": play["seconds"],
                        "length": seconds
                    })
            elif play["etype"] == "PEND":
                # Period End
                eventcount["pend"].append(play["seconds"])
            if play["etype"] in ["MISS", "GOAL", "SHOT", "BLOCK", "MISS"]:
                for key in play:
                    if type(play[key]).__module__ == "numpy" and numpy.isnan(
                            play[key]):
                        play[key] = 0
                # get Names
                if play["ev.player.1"] != "xxxxxxxNA":
                    play["P1"] = woiid[play["ev.player.1"]]["full_name"]
                if play["ev.player.2"] != "xxxxxxxNA":
                    play["P2"] = woiid[play["ev.player.2"]]["full_name"]
                if play["ev.player.3"] != "xxxxxxxNA":
                    play["P3"] = woiid[play["ev.player.3"]]["full_name"]
                if play["ev.team"] == hometeam:
                    if gamestate in calc_strengths(play, True):
                        pbphome.append(play)
                elif play["ev.team"] == awayteam:
                    if gamestate in calc_strengths(play, False):
                        pbpaway.append(play)

    # Find PowerPlay Goals
    eventcount = findPPGoal(eventcount, "homepp", "homegoal")
    eventcount = findPPGoal(eventcount, "awaypp", "awaygoal")

    homelast = eventcount["homesa"][-1]["seconds"]
    awaylast = eventcount["awaysa"][-1]["seconds"]

    if homelast < awaylast:
        eventcount["homesa"].append({
            "seconds": awaylast,
            "value": eventcount["homesa"][-1]["value"]
        })
    elif homelast > awaylast:
        eventcount["awaysa"].append({
            "seconds": homelast,
            "value": eventcount["awaysa"][-1]["value"]
        })

    homelast = eventcount["homesc"][-1]["seconds"]
    awaylast = eventcount["awaysc"][-1]["seconds"]

    if homelast < awaylast:
        eventcount["homesc"].append({
            "seconds": awaylast,
            "value": eventcount["homesc"][-1]["value"]
        })
    elif homelast > awaylast:
        eventcount["awaysc"].append({
            "seconds": homelast,
            "value": eventcount["awaysc"][-1]["value"]
        })

    # Get coplayer data
    coplayers = get_coplayers(rdata)
    hvh, hometeam, awayteam = get_hvh(coplayers, playerteams, woiid)

    return render_template('game/gamesummarytables.html',
                           tablecolumns=int(tablecolumns),
                           home=home,
                           homecorsi=homecorsi,
                           away=away,
                           awaycorsi=awaycorsi,
                           gamedata=gamedata,
                           goalies=goalies,
                           woiid=woiid,
                           pbphome=pbphome,
                           pbpaway=pbpaway,
                           teamrun=teamrun,
                           eventcount=eventcount,
                           hvh=hvh)
Пример #4
0
def show_game_summary_tables(gameId):
    rd = setup_nav()

    if request.method == "GET":
        tablecolumns = request.args.get("tablecolumns")
        teamstrengths = request.args.get("teamstrengths")
        scoresituations = request.args.get("scoresituation")
        period = constants.periods_options[request.args.get("period")]["value"]
    else:
        tablecolumns = "0"
        teamstrengths = constants.strength_situations_dict[constants.strength_situations["default"]]["value"]
        scoresituations = constants.score_situations_dict[constants.score_situations["default"]]["value"]
        period = [0]
        period.extend(constants.periods_options[constants.periods["default"]]["value"])

    # Get game information from URL
    season = gameId[0:8]
    gcode = gameId[8:]
    
    # Prepare form results for queries
    scorediffcat = int(scoresituations)
    gamestate = int(teamstrengths)
    period = [int(x) for x in period]

    rdata = get_rdata("http://data.war-on-ice.net/games/" + season + gcode + ".RData")

    eventcount = {"homepp": [], "awaypp": [], "4v4": [], "homegoal": [], "awaygoal": [], "emptynet": [],
        "homesc": [{"seconds": 0, "value": 0}], "awaysc": [{"seconds": 0, "value": 0}], "homesa": [{"seconds": 0, "value": 0}], "awaysa": [{"seconds": 0, "value": 0}], "pend": []}
    pbp = rdata["playbyplay"]

    rteamrun = rdata["teamrun"]
    teamrun = []
    teams = set()
    hometeam = ""
    awayteam = ""
    previous = 1000
    for tr in sorted(rteamrun, key=lambda x: x["TOI"], reverse=True):
        if hometeam == "" and tr["home"] == 1:
            hometeam = tr["Team"]
        elif awayteam == "" and tr["home"] == 0:
            awayteam = tr["Team"]
        if tr["period"] in period and tr["gamestate"] == gamestate:
            if tr["Team"] not in teams:
                tr["MSF"] = int(tr["FF"]) - int(tr["SF"])
                tr["BSF"] = tr["CF"] - tr["MSF"] - tr["SF"]
                tr["TOI"] = float(tr["TOI"]) # round(float(tr["TOI"]) / 60.0, 1)
                teamrun.append(tr)
                teams.add(tr["Team"])
    goalies = []
    rgoalies = rdata["goalierun"]
    teams = set()
    foundplayers = set()
    for tr in sorted(rgoalies, key=lambda x: x["TOI"], reverse=True):
        if tr["period"] in period and tr["gamestate"] == gamestate:
            if tr["ID"] not in foundplayers:
                tr["gu"] = tr["goals.0"]
                tr["su"] = tr["shots.0"]
                tr["gl"] = tr["goals.1"]
                tr["sl"] = tr["shots.1"]
                tr["gm"] = tr["goals.2"]
                tr["sm"] = tr["shots.2"]
                tr["gh"] = tr["goals.3"] + tr["goals.4"]
                tr["sh"] = tr["shots.3"] + tr["shots.4"]
                tr["TOI"] = float(tr["TOI"]) # round(float(tr["TOI"]) / 60.0, 1)
                goalies.append(tr)
                teams.add(tr["Team"])
                foundplayers.add(tr["ID"])

    rplayerrun = rdata["playerrun"]
    away = []
    home = []
    players = set()
    playerteams = {}
    for tr in sorted(rplayerrun, key=lambda x: x["TOI"], reverse=True):
        if tr["ID"] not in foundplayers:
            foundplayers.add(tr["ID"])
            playerteams[tr["ID"]] = tr["Team"]
        if tr["period"] in period and tr["gamestate"] == gamestate and tr["ID"] not in players:
            players.add(tr["ID"])
            tr["G"] = int(tr["GOAL1"] + tr["GOAL2"] + tr["GOAL3"] + tr["GOAL4"])
            tr["TOI"] = float(tr["TOI"]) #round(float(tr["TOI"]) / 60.0, 1)
            if tr["home"] == 1:
                home.append(tr)
            else:
                away.append(tr)

    # Get GamesTest information
    gamedata = GamesTest.query.filter_by(season=season,
        gcode=int(gcode)).first()

    woiid = get_player_info(foundplayers)

    homecorsi = []
    awaycorsi = []
    for line in home:
        for key in line:
            if type(line[key]).__module__ == "numpy" and numpy.isnan(line[key]):
                line[key] = 0
        if line["ID"] in woiid and woiid[line["ID"]]["pos"] != "G":
            line["full_name"] = str(woiid[line["ID"]]["full_name"])
            homecorsi.append(line)
    for line in away:
        for key in line:
            if type(line[key]).__module__ == "numpy" and numpy.isnan(line[key]):
                line[key] = 0
        if line["ID"] in woiid and woiid[line["ID"]]["pos"] != "G":
            line["full_name"] = str(woiid[line["ID"]]["full_name"])
            awaycorsi.append(line)

    pbphome = []
    pbpaway = []

    for play in pbp:
        if play["period"] in period and (play["score.diff.cat"] == int(scoresituations) or int(scoresituations) == 7):
            if play["etype"] in ["MISS", "GOAL", "SHOT", "BLOCK"]:
                # Shot Attempt
                if play["ev.team"] == hometeam:
                    if gamestate in calc_strengths(play, True):
                        eventcount["homesa"].append({"seconds": play["seconds"], "value": len(eventcount["homesa"])})
                        eventcount["homesc"] = calc_sc(eventcount["homesc"], play)
                else:
                    if gamestate in calc_strengths(play, False):
                        eventcount["awaysa"].append({"seconds": play["seconds"], "value": len(eventcount["awaysa"])})
                        eventcount["awaysc"] = calc_sc(eventcount["awaysc"], play)
                # Goal
                if play["etype"] == "GOAL":
                    if play["ev.team"] == hometeam:
                        eventcount["homegoal"].append({"seconds": play["seconds"], "value": len(eventcount["homegoal"]) + 1})
                    else:
                        eventcount["awaygoal"].append({"seconds": play["seconds"], "value": len(eventcount["awaygoal"]) + 1})
            elif play["etype"] == "PENL":
                # Penalty
                seconds = int(re.findall("\d+", play["type"])[0]) * 60
                if play["ev.team"] == hometeam:
                    eventcount["awaypp"].append({"seconds": play["seconds"], "length": seconds})
                elif play["ev.team"] == awayteam:
                    eventcount["homepp"].append({"seconds": play["seconds"], "length": seconds})
            elif play["etype"] == "PEND":
                # Period End
                eventcount["pend"].append(play["seconds"])
            if play["etype"] in ["MISS", "GOAL", "SHOT", "BLOCK", "MISS"]:
                for key in play:
                    if type(play[key]).__module__ == "numpy" and numpy.isnan(play[key]):
                        play[key] = 0
                # get Names
                if play["ev.player.1"] != "xxxxxxxNA":
                    play["P1"] = woiid[play["ev.player.1"]]["full_name"]
                if play["ev.player.2"] != "xxxxxxxNA":
                    play["P2"] = woiid[play["ev.player.2"]]["full_name"]
                if play["ev.player.3"] != "xxxxxxxNA":
                    play["P3"] = woiid[play["ev.player.3"]]["full_name"]
                if play["ev.team"] == hometeam:
                    if gamestate in calc_strengths(play, True):
                        pbphome.append(play)
                elif play["ev.team"] == awayteam:
                    if gamestate in calc_strengths(play, False):
                        pbpaway.append(play)

    # Find PowerPlay Goals
    eventcount = findPPGoal(eventcount, "homepp", "homegoal")
    eventcount = findPPGoal(eventcount, "awaypp", "awaygoal")

    homelast = eventcount["homesa"][-1]["seconds"]
    awaylast = eventcount["awaysa"][-1]["seconds"]

    if homelast < awaylast:
        eventcount["homesa"].append({"seconds": awaylast, "value": eventcount["homesa"][-1]["value"]})
    elif homelast > awaylast:
        eventcount["awaysa"].append({"seconds": homelast, "value": eventcount["awaysa"][-1]["value"]})

    homelast = eventcount["homesc"][-1]["seconds"]
    awaylast = eventcount["awaysc"][-1]["seconds"]

    if homelast < awaylast:
        eventcount["homesc"].append({"seconds": awaylast, "value": eventcount["homesc"][-1]["value"]})
    elif homelast > awaylast:
        eventcount["awaysc"].append({"seconds": homelast, "value": eventcount["awaysc"][-1]["value"]})

    # Get coplayer data
    coplayers = get_coplayers(rdata)
    hvh, hometeam, awayteam = get_hvh(coplayers, playerteams, woiid)

    return render_template('game/gamesummarytables.html',
        tablecolumns=int(tablecolumns),
        home=home, homecorsi=homecorsi,
        away=away, awaycorsi=awaycorsi,
        gamedata=gamedata,
        goalies=goalies,
        woiid=woiid,
        pbphome=pbphome, pbpaway=pbpaway,
        teamrun=teamrun,
        eventcount=eventcount,
        hvh=hvh)