public async Task Read_total_players_with_bowling_average_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.ReadTotalPlayersWithBowlingAverage(filter).ConfigureAwait(false);
var bowlingFigures = _databaseFixture.TestData.Matches
.SelectMany(x => x.MatchInnings)
.SelectMany(x => x.BowlingFigures);
var expected = bowlingFigures
.Where(x => x.Wickets > 0 && x.RunsConceded.HasValue)
.Select(x => x.Bowler.Player.PlayerId)
.Where(x =>
bowlingFigures.Count(bf => bf.Bowler.Player.PlayerId == x && bf.RunsConceded.HasValue) >= filter.MinimumQualifyingInnings)
.Distinct()
.Count();
Assert.Equal(expected, result);
}
public async Task Read_total_players_with_bowling_average_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.ReadTotalPlayersWithBowlingAverage(filter).ConfigureAwait(false);
var bowlingFigures = _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.BowlingTeam.Team.TeamId == _databaseFixture.TestData.TeamWithFullDetails.TeamId.Value)
.SelectMany(x => x.BowlingFigures);
var expected = bowlingFigures
.Where(x => x.Wickets > 0 && x.RunsConceded.HasValue)
.Select(x => x.Bowler.Player.PlayerId)
.Distinct()
.Count();
Assert.Equal(expected, result);
}
public async Task Read_total_players_with_bowling_average_supports_filter_by_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.ReadTotalPlayersWithBowlingAverage(filter).ConfigureAwait(false);
var bowlingFigures = _databaseFixture.TestData.Matches
.Where(x => x.StartTime >= filter.FromDate && x.StartTime <= filter.UntilDate)
.SelectMany(x => x.MatchInnings)
.SelectMany(x => x.BowlingFigures);
var expected = bowlingFigures
.Where(x => x.Wickets > 0 && x.RunsConceded.HasValue)
.Select(x => x.Bowler.Player.PlayerId)
.Distinct()
.Count();
Assert.Equal(expected, result);
}
