public async Task Read_total_players_with_batting_strike_rate_supports_minimum_qualifying_innings()
{
var filter = new StatisticsFilter {
MinimumQualifyingInnings = 5
};
var queryBuilder = new Mock <IStatisticsQueryBuilder>();
queryBuilder.Setup(x => x.BuildWhereClause(It.IsAny <StatisticsFilter>())).Returns((string.Empty, new Dictionary <string, object>()));
var dataSource = new SqlServerBestPlayerAverageStatisticsDataSource(_databaseFixture.ConnectionFactory, queryBuilder.Object, Mock.Of <IPlayerDataSource>());
var result = await dataSource.ReadTotalPlayersWithBattingStrikeRate(filter).ConfigureAwait(false);
var playerInnings = _databaseFixture.TestData.Matches
.SelectMany(x => x.MatchInnings)
.SelectMany(x => x.PlayerInnings);
var expected = playerInnings
.Where(x => x.RunsScored.HasValue && x.BallsFaced.HasValue)
.Select(x => x.Batter.Player.PlayerId)
.Where(x => playerInnings.Any(pi => pi.Batter.Player.PlayerId == x && pi.RunsScored.HasValue && pi.BallsFaced.HasValue && pi.BallsFaced > 0) &&
playerInnings.Count(pi => pi.Batter.Player.PlayerId == x && pi.RunsScored.HasValue && pi.BallsFaced.HasValue) >= filter.MinimumQualifyingInnings)
.Distinct()
.Count();
Assert.Equal(expected, result);
}
public async Task Read_total_players_with_batting_strike_rate_supports_filter_by_club_id()
{
var filter = new StatisticsFilter {
Club = _databaseFixture.TestData.TeamWithFullDetails.Club
};
var queryBuilder = new Mock <IStatisticsQueryBuilder>();
queryBuilder.Setup(x => x.BuildWhereClause(filter)).Returns((" AND ClubId = @ClubId", new Dictionary <string, object> {
{ "ClubId", _databaseFixture.TestData.TeamWithFullDetails.Club.ClubId }
}));
var dataSource = new SqlServerBestPlayerAverageStatisticsDataSource(_databaseFixture.ConnectionFactory, queryBuilder.Object, Mock.Of <IPlayerDataSource>());
var result = await dataSource.ReadTotalPlayersWithBattingStrikeRate(filter).ConfigureAwait(false);
var playerInnings = _databaseFixture.TestData.Matches
.Where(x => x.Teams.Select(t => t.Team.TeamId).Contains(_databaseFixture.TestData.TeamWithFullDetails.TeamId.Value))
.SelectMany(x => x.MatchInnings)
.Where(i => i.BattingTeam.Team.TeamId == _databaseFixture.TestData.TeamWithFullDetails.TeamId.Value)
.SelectMany(x => x.PlayerInnings);
var expected = playerInnings
.Where(x => x.RunsScored.HasValue && x.BallsFaced.HasValue)
.Select(x => x.Batter.Player.PlayerId)
.Where(x => playerInnings.Any(pi => pi.Batter.Player.PlayerId == x && pi.RunsScored.HasValue && pi.BallsFaced.HasValue && pi.BallsFaced > 0))
.Distinct()
.Count();
Assert.Equal(expected, result);
}
public async Task Read_total_players_with_batting_strike_rate_supports_filter_date()
{
var dateRangeGenerator = new DateRangeGenerator();
var(fromDate, untilDate) = dateRangeGenerator.SelectDateRangeToTest(_databaseFixture.TestData.Matches);
var filter = new StatisticsFilter {
FromDate = fromDate, UntilDate = untilDate
};
var queryBuilder = new Mock <IStatisticsQueryBuilder>();
queryBuilder.Setup(x => x.BuildWhereClause(filter)).Returns((" AND MatchStartTime >= @FromDate AND MatchStartTime <= @UntilDate", new Dictionary <string, object> {
{ "FromDate", filter.FromDate }, { "UntilDate", filter.UntilDate }
}));
var dataSource = new SqlServerBestPlayerAverageStatisticsDataSource(_databaseFixture.ConnectionFactory, queryBuilder.Object, Mock.Of <IPlayerDataSource>());
var result = await dataSource.ReadTotalPlayersWithBattingStrikeRate(filter).ConfigureAwait(false);
var playerInnings = _databaseFixture.TestData.Matches
.Where(x => x.StartTime >= filter.FromDate && x.StartTime <= filter.UntilDate)
.SelectMany(x => x.MatchInnings)
.SelectMany(x => x.PlayerInnings);
var expected = playerInnings
.Where(x => x.RunsScored.HasValue && x.BallsFaced.HasValue)
.Select(x => x.Batter.Player.PlayerId)
.Where(x => playerInnings.Any(pi => pi.Batter.Player.PlayerId == x && pi.RunsScored.HasValue && pi.BallsFaced.HasValue && pi.BallsFaced > 0))
.Distinct()
.Count();
Assert.Equal(expected, result);
}
