private bool CheckPlayRunnerForUpdate(Feeds.PlayByPlayFeed.Runner feedRunner, GamePlayRunner dbRunner, RunnerLocation startLocation, RunnerLocation endLocation)
{
return(dbRunner.IsEarned != feedRunner.Details.Earned ||
dbRunner.IsOut != feedRunner.Movement.IsOut ||
dbRunner.IsScore != (endLocation == RunnerLocation.Home_End) ||
dbRunner.IsTeamUnearned != feedRunner.Details.TeamUnearned ||
dbRunner.MovementReason != feedRunner.Details.MovementReason ||
dbRunner.OutLocation != ((feedRunner.Movement.IsOut ?? false)
? GetRunnerLocationFromString(feedRunner.Movement.OutBase, false)
: (RunnerLocation?)null) ||
dbRunner.OutNumber != feedRunner.Movement.OutNumber ||
dbRunner.PlayEvent != feedRunner.Details.Event ||
dbRunner.PlayEventType != feedRunner.Details.EventType ||
dbRunner.PlayIndex != feedRunner.Details.PlayIndex ||
dbRunner.PitcherResponsibleID != feedRunner.Details.ResponsiblePitcher?.Id ||
CheckPlayRunnerFieldingCreditsForUpdate(feedRunner.Credits, dbRunner.FieldingCredits));
}
public void Run(Model.MlbStatsContext context)
{
Feeds.PlayByPlayFeed feed;
using (var client = new WebClient())
{
var url = Feeds.PlayByPlayFeed.GetFeedUrl(this.GameId);
string rawJson = JsonUtility.GetRawJsonFromUrl(url);;
if (rawJson == null)
{
return;
}
feed = Feeds.PlayByPlayFeed.FromJson(rawJson);
if (feed != null && feed.AllPlays != null && feed.AllPlays.Count > 0)
{
var dbGame = context.Games.SingleOrDefault(x => x.GameID == this.GameId);
if (dbGame == null)
{
throw new NullReferenceException($"GAME NOT FOUND IN DB: {this.GameId}");
}
int season = dbGame.Season;
var dbTrajectoriesDict = context.HitTrajectoryTypes.ToDictionary(x => x.Code, y => y.HitTrajectoryTypeID);
var dbPitchResultsDict = context.PitchResultTypes.ToDictionary(x => x.Code, y => y.PitchResultTypeID);
var dbPitchTypesDict = context.PitchTypes.ToDictionary(x => x.Code, y => y.PitchTypeID);
var dbPlaysDict = context.GamePlays.Where(x => x.GameID == dbGame.GameID).ToDictionary(x => x.GamePlayIndex);
var dbPlayRunnersLookup = context.GamePlayRunners.Include("FieldingCredits").Where(x => x.GamePlay.GameID == dbGame.GameID).ToLookup(x => x.PlayIndex);
var dbPlayPitchesLookup = context.GamePlayPitches.Where(x => x.GamePlay.GameID == dbGame.GameID).ToLookup(x => x.GamePlay.GamePlayIndex).ToDictionary(x => x.Key, y => y.ToDictionary(z => (int)z.GamePlayEventIndex, z => z));
var dbPlayActionsLookup = context.GamePlayActions.Where(x => x.GamePlay.GameID == dbGame.GameID).ToLookup(x => x.GamePlay.GamePlayIndex).ToDictionary(x => x.Key, y => y.ToDictionary(z => (int)z.GamePlayEventIndex, z => z));
var dbPlayPickoffsLookup = context.GamePlayPickoffs.Where(x => x.GamePlay.GameID == dbGame.GameID).ToLookup(x => x.GamePlay.GamePlayIndex).ToDictionary(x => x.Key, y => y.ToDictionary(z => (int)z.GamePlayEventIndex, z => z));
var feedPlayers = feed.AllPlays.Where(x => x.Matchup?.Pitcher != null && x.Matchup?.Batter != null)
.SelectMany(x => new[] {
new {
IsHome = x.About.HalfInning != "top",
PlayerId = x.Matchup.Batter.Id,
Name = x.Matchup.Batter.FullName,
Link = x.Matchup.Batter.Link
},
new {
IsHome = x.About.HalfInning == "top",
PlayerId = x.Matchup.Pitcher.Id,
Name = x.Matchup.Pitcher.FullName,
Link = x.Matchup.Pitcher.Link
}
})
.GroupBy(x => x.PlayerId)
.Select(x => x.FirstOrDefault())
.Where(x => x != null)
.ToList();
var feedPlayerIds = feedPlayers.Select(x => x.PlayerId).ToList();
var dbPlayersDict = context.Players.Where(x => feedPlayerIds.Contains(x.PlayerID)).ToDictionary(x => x.PlayerID);
foreach (var feedPlayer in feedPlayers)
{
if (!dbPlayersDict.ContainsKey(feedPlayer.PlayerId))
{
int teamId = feedPlayer.IsHome ? dbGame.HomeTeamID.Value : dbGame.AwayTeamID.Value;
var dbPlayer = new Player
{
PlayerID = feedPlayer.PlayerId,
PlayerLink = feedPlayer.Link,
FullName = feedPlayer.Name
};
dbPlayersDict.Add(dbPlayer.PlayerID, dbPlayer);
context.Players.Add(dbPlayer);
var pts = new PlayerTeamSeason {
Player = dbPlayer, TeamID = teamId, Season = season
};
context.PlayerTeamSeasons.Add(pts);
}
}
context.SaveChanges();
// TODO: IF ANY PLAY HAS CHANGED, DELETE ALL PLAYS AND REPROCESS FROM SCRATCH
Player pitcher = null;
foreach (var feedPlay in feed.AllPlays)
{
short playIndex = feedPlay.AtBatIndex;
byte outCount = 0;
RunnerLocation startRunners = RunnerLocation.None, endRunners = RunnerLocation.None;
if (feedPlay.Runners != null && feedPlay.Runners.Count > 0)
{
outCount = (byte)feedPlay.Runners.Count(x => x.Movement.IsOut ?? false);
var feedRunnersByRunnerId = feedPlay.Runners.GroupBy(x => x.Details.Runner.Id).ToList();
foreach (var feedRunner in feedRunnersByRunnerId)
{
var start = (RunnerLocation)feedRunner.Select(x => GetRunnerLocationFromString(x.Movement?.Start, true)).Min(x => (int)x);
var end = (RunnerLocation)feedRunner.Select(x => GetRunnerLocationFromString(x.Movement?.End, false)).Max(x => (int)x);
if (start != RunnerLocation.Home_End)
{
startRunners = startRunners | start;
}
if (end != RunnerLocation.Home_End)
{
endRunners = endRunners | end;
}
}
}
bool isNew = !dbPlaysDict.TryGetValue(feedPlay.AtBatIndex, out GamePlay dbPlay);
if (isNew)
{
dbPlay = new GamePlay
{
Game = dbGame,
GamePlayIndex = playIndex,
Season = season,
IsInningTop = string.Equals(feedPlay.About.HalfInning, "top"),
Inning = feedPlay.About.Inning,
};
dbPlaysDict.Add(playIndex, dbPlay);
context.GamePlays.Add(dbPlay);
}
bool isUpdate = false;
if (!isNew)
{
isUpdate = CheckPlayForUpdate(feedPlay, dbPlay, outCount, startRunners, endRunners);
}
var feedPitcher = feedPlay.Matchup.Pitcher;
if (feedPitcher != null && (pitcher == null || pitcher.PlayerID != feedPitcher.Id))
{
pitcher = dbPlayersDict[feedPitcher.Id];
}
var feedBatter = feedPlay.Matchup.Batter;
if (!dbPlayersDict.TryGetValue(feedBatter.Id, out Player batter))
{
batter = dbPlayersDict[feedPlay.Matchup.Batter.Id];
}
if (isNew || isUpdate)
{
dbPlay.StartTime = feedPlay.About.StartTime;
dbPlay.EndTime = feedPlay.About.EndTime;
dbPlay.IsReview = feedPlay.About.HasReview;
dbPlay.PlayType = feedPlay.Result.Type;
dbPlay.PlayEvent = feedPlay.Result.Event;
dbPlay.PlayEventType = feedPlay.Result.EventType;
dbPlay.GamePlayDescription = feedPlay.Result.Description;
dbPlay.ScoreAway = feedPlay.Result.AwayScore;
dbPlay.ScoreHome = feedPlay.Result.HomeScore;
dbPlay.RunsScored = feedPlay.Result.Rbi;
dbPlay.RunnerStatusStart = startRunners;
dbPlay.RunnerStatusEnd = endRunners;
dbPlay.BatterID = batter.PlayerID;
dbPlay.PitcherID = pitcher.PlayerID;
dbPlay.BatterHand = feedPlay.Matchup.BatSide.Code[0];
dbPlay.PitcherHand = feedPlay.Matchup.PitchHand.Code[0];
dbPlay.BatterSplit = feedPlay.Matchup.Splits?.Batter;
dbPlay.PitcherSplit = feedPlay.Matchup.Splits?.Pitcher;
dbPlay.Strikes = (byte)feedPlay.Count.Strikes;
dbPlay.Balls = (byte)feedPlay.Count.Balls;
dbPlay.OutsEnd = (byte)feedPlay.Count.Outs;
dbPlay.OutsStart = (byte)(feedPlay.Count.Outs - outCount);
}
var dbPlayRunners = dbPlayRunnersLookup[playIndex];
var feedRunners = feedPlay.Runners;
if (feedRunners != null && feedRunners.Count > 0)
{
foreach (var feedRunner in feedRunners)
{
if (feedRunner.Movement != null && feedRunner.Details != null)
{
var runnerId = feedRunner.Details.Runner.Id;
var startLocation = GetRunnerLocationFromString(feedRunner.Movement.Start, true);
var endLocation = GetRunnerLocationFromString(feedRunner.Movement.Start, false);
var dbPlayRunner = dbPlayRunners.SingleOrDefault(x => x.RunnerID == runnerId && x.StartRunnerLocation == startLocation);
bool isRunnerNew = false;
if (dbPlayRunner == null)
{
isRunnerNew = true;
dbPlayRunner = new GamePlayRunner
{
GamePlay = dbPlay,
RunnerID = runnerId,
StartRunnerLocation = startLocation,
EndRunnerLocation = endLocation
};
if (dbPlay.Runners == null)
{
dbPlay.Runners = new List <GamePlayRunner>();
}
dbPlay.Runners.Add(dbPlayRunner);
}
bool isRunnerUpdate = false;
if (!isNew)
{
isRunnerUpdate = CheckPlayRunnerForUpdate(feedRunner, dbPlayRunner, startLocation, endLocation);
}
if (isRunnerNew || isRunnerUpdate)
{
dbPlayRunner.IsEarned = feedRunner.Details.Earned;
dbPlayRunner.IsOut = feedRunner.Movement.IsOut;
dbPlayRunner.IsScore = endLocation == RunnerLocation.Home_End;
dbPlayRunner.IsTeamUnearned = feedRunner.Details.TeamUnearned;
dbPlayRunner.MovementReason = feedRunner.Details.MovementReason;
dbPlayRunner.OutLocation = (dbPlayRunner.IsOut ?? false)
? GetRunnerLocationFromString(feedRunner.Movement.OutBase, false)
: (RunnerLocation?)null;
dbPlayRunner.OutNumber = feedRunner.Movement.OutNumber;
dbPlayRunner.PlayEvent = feedRunner.Details.Event;
dbPlayRunner.PlayEventType = feedRunner.Details.EventType;
dbPlayRunner.PlayIndex = feedRunner.Details.PlayIndex;
dbPlayRunner.PitcherResponsibleID = feedRunner.Details.ResponsiblePitcher?.Id;
if (feedRunner.Credits != null && feedRunner.Credits.Count > 0)
{
if (dbPlayRunner.FieldingCredits == null)
{
dbPlayRunner.FieldingCredits = new List <GamePlayFieldingCredit>();
}
var dbCreditsToDelete = dbPlayRunner.FieldingCredits.ToList(); // EAGER LOAD
foreach (var feedCredit in feedRunner.Credits)
{
var creditType = GetCreditTypeFromString(feedCredit.CreditCredit);
var dbCredit = dbPlayRunner.FieldingCredits.SingleOrDefault(x => x.FielderID == feedCredit.Player.Id && x.CreditType == creditType);
if (dbCredit != null)
{
dbCreditsToDelete.Remove(dbCredit);
dbCredit.CreditType = creditType;
dbCredit.FielderID = feedCredit.Player.Id;
dbCredit.PosAbbr = feedCredit.Position?.Abbreviation;
context.SaveChanges();
}
else
{
dbCredit = new GamePlayFieldingCredit
{
PlayRunner = dbPlayRunner,
PlayRunnerID = dbPlayRunner.GamePlayRunnerID,
CreditType = creditType,
FielderID = feedCredit.Player.Id,
PosAbbr = feedCredit.Position?.Abbreviation
};
context.GamePlayFieldingCredits.Add(dbCredit);
context.SaveChanges();
}
}
foreach (var dbCredit in dbCreditsToDelete)
{
context.GamePlayFieldingCredits.Remove(dbCredit);
context.SaveChanges();
}
}
}
}
}
}
var dbPlayPitchesDict = dbPlayPitchesLookup.ContainsKey(playIndex) ? dbPlayPitchesLookup[playIndex] : null;
var dbPlayActionsDict = dbPlayActionsLookup.ContainsKey(playIndex) ? dbPlayActionsLookup[playIndex] : null;
var dbPlayPickoffsDict = dbPlayPickoffsLookup.ContainsKey(playIndex) ? dbPlayPickoffsLookup[playIndex] : null;
var feedPlayEvents = feedPlay.PlayEvents;
if (feedPlayEvents != null && feedPlayEvents.Count > 0)
{
foreach (var feedPlayEvent in feedPlayEvents)
{
if (string.Equals(feedPlayEvent.Type, "pitch", StringComparison.InvariantCultureIgnoreCase))
{
bool isNewPitch = false;
if (dbPlayPitchesDict == null || !dbPlayPitchesDict.TryGetValue(feedPlayEvent.Index, out GamePlayPitch dbPitch))
{
isNewPitch = true;
dbPitch = new GamePlayPitch
{
Batter = batter,
BatterID = batter.PlayerID,
Pitcher = pitcher,
PitcherID = pitcher.PlayerID,
GamePlay = dbPlay,
GamePlayID = dbPlay.GamePlayID,
GamePlayEventIndex = feedPlayEvent.Index,
MlbPlayID = feedPlayEvent.PlayId,
PfxId = feedPlayEvent.PfxId
};
context.GamePlayPitches.Add(dbPitch);
}
bool isUpdatedPitch = false;
// TODO: CHECK FOR UPDATES TO PITCH
if (isNewPitch || isUpdatedPitch)
{
dbPitch.PitchNumber = feedPlayEvent.PitchNumber;
dbPitch.Balls = feedPlayEvent.Count?.Balls;
dbPitch.Strikes = feedPlayEvent.Count?.Strikes;
dbPitch.Outs = feedPlayEvent.Count?.Outs;
dbPitch.StartSpeed = feedPlayEvent.PitchData?.StartSpeed;
dbPitch.StrikeZoneBottom = feedPlayEvent.PitchData?.StrikeZoneBottom;
dbPitch.StrikeZoneTop = feedPlayEvent.PitchData?.StrikeZoneTop;
dbPitch.EndSpeed = feedPlayEvent.PitchData?.EndSpeed;
dbPitch.NastyFactor = feedPlayEvent.PitchData?.NastyFactor;
dbPitch.P_A_X = feedPlayEvent.PitchData?.Coordinates.A_X;
dbPitch.P_A_Y = feedPlayEvent.PitchData?.Coordinates.A_Y;
dbPitch.P_A_Z = feedPlayEvent.PitchData?.Coordinates.A_Z;
dbPitch.P_PFX_X = feedPlayEvent.PitchData?.Coordinates.PFX_X;
dbPitch.P_PFX_Z = feedPlayEvent.PitchData?.Coordinates.PFX_Z;
dbPitch.P_P_X = feedPlayEvent.PitchData?.Coordinates.P_X;
dbPitch.P_P_Z = feedPlayEvent.PitchData?.Coordinates.P_Z;
dbPitch.P_V_X0 = feedPlayEvent.PitchData?.Coordinates.V_X0;
dbPitch.P_V_Y0 = feedPlayEvent.PitchData?.Coordinates.V_Y0;
dbPitch.P_V_Z0 = feedPlayEvent.PitchData?.Coordinates.V_Z0;
dbPitch.P_X = feedPlayEvent.PitchData?.Coordinates.X;
dbPitch.P_X0 = feedPlayEvent.PitchData?.Coordinates.X0;
dbPitch.P_Y = feedPlayEvent.PitchData?.Coordinates.Y;
dbPitch.P_Y0 = feedPlayEvent.PitchData?.Coordinates.Y0;
dbPitch.P_Z0 = feedPlayEvent.PitchData?.Coordinates.Z0;
dbPitch.P_BreakAngle = feedPlayEvent.PitchData?.Breaks?.BreakAngle;
dbPitch.P_BreakLength = feedPlayEvent.PitchData?.Breaks?.BreakLength;
dbPitch.P_Break_Y = feedPlayEvent.PitchData?.Breaks?.BreakY;
dbPitch.P_SpinDirection = feedPlayEvent.PitchData?.Breaks?.SpinDirection;
dbPitch.P_SpinRate = feedPlayEvent.PitchData?.Breaks?.SpinRate;
dbPitch.P_Zone = feedPlayEvent.PitchData?.Zone;
dbPitch.P_TypeConfidence = feedPlayEvent.PitchData?.TypeConfidence;
dbPitch.H_Coord_X = feedPlayEvent.HitData?.Coordinates?.CoordX;
dbPitch.H_Coord_Y = feedPlayEvent.HitData?.Coordinates?.CoordY;
dbPitch.H_Hardness = feedPlayEvent.HitData?.Hardness;
dbPitch.H_LaunchAngle = feedPlayEvent.HitData?.LaunchAngle;
dbPitch.H_LaunchSpeed = feedPlayEvent.HitData?.LaunchSpeed;
dbPitch.H_TotalDistance = feedPlayEvent.HitData?.TotalDistance;
dbPitch.H_Location = feedPlayEvent.HitData?.Location;
dbPitch.HasReview = feedPlayEvent.Details?.HasReview;
dbPitch.IsBall = feedPlayEvent.Details?.IsBall;
dbPitch.IsInPlay = feedPlayEvent.Details?.IsInPlay;
dbPitch.IsStrike = feedPlayEvent.Details?.IsStrike;
dbPitch.TimeSec = feedPlayEvent.StartTime.HasValue && feedPlayEvent.EndTime.HasValue
? (short?)(feedPlayEvent.EndTime.Value - feedPlayEvent.StartTime.Value).TotalSeconds
: null;
var trajectoryKey = feedPlayEvent.HitData?.Trajectory;
dbPitch.H_TrajectoryTypeID = (!string.IsNullOrEmpty(trajectoryKey) && dbTrajectoriesDict.TryGetValue(trajectoryKey, out byte b1)) ? b1 : (byte?)null;
var pitchResultKey = feedPlayEvent.Details?.Code;
dbPitch.PitchResultTypeID = (!string.IsNullOrEmpty(pitchResultKey) && dbPitchResultsDict.TryGetValue(pitchResultKey, out byte b2)) ? b2 : (byte?)null;
var pitchTypeKey = feedPlayEvent?.Details?.Type?.Code;
dbPitch.PitchTypeID = (!string.IsNullOrEmpty(pitchTypeKey) && dbPitchTypesDict.TryGetValue(pitchTypeKey, out byte b3)) ? b3 : (byte?)null;
}
}
else if (string.Equals(feedPlayEvent.Type, "action", StringComparison.InvariantCultureIgnoreCase))
{
}
else if (string.Equals(feedPlayEvent.Type, "pickoff", StringComparison.InvariantCultureIgnoreCase))
{
}
else
{
throw new ArgumentException("UNEXPECTED PLAY EVENT TYPE");
}
}
}
}
context.SaveChanges();
}
}
}
