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))
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))
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)
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)