public async Task Read_team_listings_supports_case_insensitive_filter_by_team_name_where_the_club_name_is_different() { var team = _databaseFixture.Clubs.Where(x => x.Teams.Count > 1).SelectMany(x => x.Teams).First(x => !x.Club.ClubName.Contains(x.TeamName, StringComparison.OrdinalIgnoreCase)); var teamDataSource = new SqlServerTeamListingDataSource(_databaseFixture.ConnectionFactory); var query = new TeamListingFilter { Query = team.TeamName.ToUpperInvariant() }; var results = await teamDataSource.ReadTeamListings(query).ConfigureAwait(false); foreach (var result in results) { var club = _databaseFixture.Clubs.SingleOrDefault(x => x.ClubId == result.TeamListingId); if (club != null) { var clubNameMatches = club.ClubName.Contains(team.TeamName, StringComparison.OrdinalIgnoreCase); var teamNameMatches = club.Teams.Any(x => x.TeamName.Contains(team.TeamName, StringComparison.OrdinalIgnoreCase)); Assert.True(clubNameMatches || teamNameMatches); } else { var resultTeam = _databaseFixture.Teams.SingleOrDefault(x => x.TeamId == result.TeamListingId); Assert.Contains(team.TeamName, result.ClubOrTeamName, StringComparison.OrdinalIgnoreCase); } } if (team.Club.Teams.Count > 1) { Assert.NotNull(results.SingleOrDefault(x => x.TeamListingId == team.Club.ClubId)); } else { Assert.NotNull(results.SingleOrDefault(x => x.TeamListingId == team.TeamId)); } }
public async Task Read_total_teams_supports_no_filter() { var teamDataSource = new SqlServerTeamListingDataSource(_databaseFixture.ConnectionFactory); var result = await teamDataSource.ReadTotalTeams(null).ConfigureAwait(false); Assert.Equal(_databaseFixture.TeamListings.Count, result); }
public async Task Read_team_listings_returns_team_for_club_with_one_team() { var teamDataSource = new SqlServerTeamListingDataSource(_databaseFixture.ConnectionFactory); var results = await teamDataSource.ReadTeamListings(null).ConfigureAwait(false); Assert.NotNull(results.SingleOrDefault(x => x.TeamListingId == _databaseFixture.ClubWithOneTeam.Teams.First().TeamId)); Assert.Null(results.SingleOrDefault(x => x.TeamListingId == _databaseFixture.ClubWithOneTeam.ClubId)); }
public async Task Read_total_teams_supports_case_insensitive_filter_by_player_type() { var teamDataSource = new SqlServerTeamListingDataSource(_databaseFixture.ConnectionFactory); var query = new TeamListingFilter { Query = "LaDiEs" }; var result = await teamDataSource.ReadTotalTeams(query).ConfigureAwait(false); Assert.Equal(_databaseFixture.TeamListings.Count(x => x.PlayerTypes.Contains(PlayerType.Ladies)), result); }
public async Task Read_total_teams_supports_case_insensitive_filter_by_club_with_administrative_area() { var teamDataSource = new SqlServerTeamListingDataSource(_databaseFixture.ConnectionFactory); var query = new TeamListingFilter { Query = _databaseFixture.MatchLocationForClub.AdministrativeArea.ToUpperInvariant() }; var result = await teamDataSource.ReadTotalTeams(query).ConfigureAwait(false); Assert.Equal(_databaseFixture.TeamListings.Count(x => x.MatchLocations.Any(ml => ml.AdministrativeArea.Contains(query.Query, StringComparison.OrdinalIgnoreCase))), result); }
public async Task Read_total_teams_supports_case_insensitive_filter_by_club_name() { var teamDataSource = new SqlServerTeamListingDataSource(_databaseFixture.ConnectionFactory); var query = new TeamListingFilter { Query = "ClUB MiNiMaL" }; var result = await teamDataSource.ReadTotalTeams(query).ConfigureAwait(false); Assert.Equal(_databaseFixture.TeamListings.Count(x => x.ClubOrTeamName.Contains(query.Query, StringComparison.OrdinalIgnoreCase)), result); }
public async Task Read_total_teams_supports_case_insensitive_filter_by_team_town() { var teamDataSource = new SqlServerTeamListingDataSource(_databaseFixture.ConnectionFactory); var query = new TeamListingFilter { Query = _databaseFixture.TeamWithFullDetails.MatchLocations.First().Town.ToUpperInvariant() }; var result = await teamDataSource.ReadTotalTeams(query).ConfigureAwait(false); Assert.Equal(_databaseFixture.Teams.Where(x => x.Club == null).Count(x => x.MatchLocations.Any(ml => ml.Town.Contains(query.Query, StringComparison.OrdinalIgnoreCase))), result); }
public async Task Read_team_listings_supports_no_filter() { var teamDataSource = new SqlServerTeamListingDataSource(_databaseFixture.ConnectionFactory); var result = await teamDataSource.ReadTeamListings(null).ConfigureAwait(false); Assert.Equal(_databaseFixture.TeamListings.Count, result.Count); foreach (var team in _databaseFixture.TeamListings) { Assert.NotNull(result.SingleOrDefault(x => x.TeamListingId == team.TeamListingId)); } }
public async Task Read_team_listings_supports_case_insensitive_filter_by_club_name() { var teamDataSource = new SqlServerTeamListingDataSource(_databaseFixture.ConnectionFactory); var query = new TeamListingFilter { Query = "ClUB MiNiMaL" }; var result = await teamDataSource.ReadTeamListings(query).ConfigureAwait(false); Assert.Equal(_databaseFixture.TeamListings.Count(x => x.ClubOrTeamName.Contains(query.Query, StringComparison.OrdinalIgnoreCase)), result.Count); foreach (var listing in _databaseFixture.TeamListings.Where(x => x.ClubOrTeamName.Contains(query.Query, StringComparison.OrdinalIgnoreCase))) { Assert.NotNull(result.SingleOrDefault(x => x.TeamListingId == listing.TeamListingId)); } }
public async Task Read_total_teams_supports_case_insensitive_filter_by_team_name_where_the_club_name_is_different() { var team = _databaseFixture.Clubs.Where(x => x.Teams.Count > 1).SelectMany(x => x.Teams).First(x => !x.Club.ClubName.Contains(x.TeamName, StringComparison.OrdinalIgnoreCase)); var teamDataSource = new SqlServerTeamListingDataSource(_databaseFixture.ConnectionFactory); var query = new TeamListingFilter { Query = team.TeamName.ToUpperInvariant() }; var result = await teamDataSource.ReadTotalTeams(query).ConfigureAwait(false); var matchedByClubName = _databaseFixture.Clubs.Where(x => x.ClubName.Contains(query.Query, StringComparison.OrdinalIgnoreCase)); var matchedByTeamName = _databaseFixture.Teams.Where(x => x.TeamName.Contains(query.Query, StringComparison.OrdinalIgnoreCase) && (x.Club == null || !matchedByClubName.Select(c => x.Club.ClubId.Value).Contains(x.Club.ClubId.Value))); Assert.Equal(matchedByClubName.Count() + matchedByTeamName.Count(x => x.Club == null) + matchedByTeamName.Where(x => x.Club != null).Select(x => x.Club.ClubId.Value).Distinct().Count(), result); }
public async Task Read_total_teams_supports_filter_by_team_type_for_club_with_no_teams() { var teamDataSource = new SqlServerTeamListingDataSource(_databaseFixture.ConnectionFactory); var query = new TeamListingFilter { TeamTypes = new List <TeamType?> { null } }; var result = await teamDataSource.ReadTotalTeams(query).ConfigureAwait(false); var expected = _databaseFixture.Clubs.Count(c => !c.Teams.Any()); Assert.Equal(expected, result); }
public async Task Read_total_teams_supports_filter_by_team_type() { var teamDataSource = new SqlServerTeamListingDataSource(_databaseFixture.ConnectionFactory); var query = new TeamListingFilter { TeamTypes = new List <TeamType?> { TeamType.Representative } }; var result = await teamDataSource.ReadTotalTeams(query).ConfigureAwait(false); var expected = _databaseFixture.TeamListings .Count(x => _databaseFixture.Teams.Where(t => t.TeamType == TeamType.Representative).Select(t => t.TeamId.Value).Contains(x.TeamListingId.Value) || _databaseFixture.Clubs.Where(c => c.Teams.Any(t => t.TeamType == TeamType.Representative)).Select(c => c.ClubId.Value).Contains(x.TeamListingId.Value)); Assert.Equal(expected, result); }
public async Task Read_team_listings_supports_case_insensitive_filter_by_club_with_administrative_area() { var teamDataSource = new SqlServerTeamListingDataSource(_databaseFixture.ConnectionFactory); var query = new TeamListingFilter { Query = _databaseFixture.MatchLocationForClub.AdministrativeArea.ToUpperInvariant() }; var result = await teamDataSource.ReadTeamListings(query).ConfigureAwait(false); var expected = _databaseFixture.TeamListings.Where(x => x.MatchLocations.Any(ml => ml.AdministrativeArea.Contains(query.Query, StringComparison.OrdinalIgnoreCase))); Assert.Equal(expected.Count(), result.Count); foreach (var team in expected) { Assert.NotNull(result.SingleOrDefault(x => x.TeamListingId == team.TeamListingId)); } }
public async Task Read_team_listings_returns_basic_fields_for_teams() { var teamDataSource = new SqlServerTeamListingDataSource(_databaseFixture.ConnectionFactory); var results = await teamDataSource.ReadTeamListings(null).ConfigureAwait(false); foreach (var team in _databaseFixture.Teams.Where(x => x.Club == null)) { var result = results.SingleOrDefault(x => x.TeamListingId == team.TeamId); Assert.NotNull(result); Assert.Equal(team.TeamName, result.ClubOrTeamName); Assert.Equal(team.TeamRoute, result.ClubOrTeamRoute); Assert.Equal(team.TeamType, result.TeamType); Assert.Equal(!team.UntilYear.HasValue, result.Active); Assert.Equal(team.PlayerType, result.PlayerTypes.SingleOrDefault()); } }
public async Task Read_team_listings_supports_filter_by_team_type_for_club_with_no_teams() { var teamDataSource = new SqlServerTeamListingDataSource(_databaseFixture.ConnectionFactory); var query = new TeamListingFilter { TeamTypes = new List <TeamType?> { null } }; var result = await teamDataSource.ReadTeamListings(query).ConfigureAwait(false); var expected = _databaseFixture.Clubs.Where(x => !x.Teams.Any()); Assert.Equal(expected.Count(), result.Count); foreach (var listing in expected) { Assert.NotNull(result.SingleOrDefault(x => x.TeamListingId == listing.ClubId)); } }
public async Task Read_team_listings_sorts_inactive_last() { var teamDataSource = new SqlServerTeamListingDataSource(_databaseFixture.ConnectionFactory); var results = await teamDataSource.ReadTeamListings(null).ConfigureAwait(false); var expectedActiveStatus = true; foreach (var team in results) { // The first time an inactive team is seen, set a flag to say they must all be inactive if (expectedActiveStatus && !team.Active) { expectedActiveStatus = false; } Assert.Equal(expectedActiveStatus, team.Active); } Assert.False(expectedActiveStatus); }
public async Task Read_team_listings_returns_match_locations_for_clubs() { var teamDataSource = new SqlServerTeamListingDataSource(_databaseFixture.ConnectionFactory); var results = await teamDataSource.ReadTeamListings(null).ConfigureAwait(false); var result = results.SingleOrDefault(x => x.TeamListingId == _databaseFixture.ClubWithTeamsAndMatchLocation.ClubId); Assert.NotNull(result); foreach (var matchLocation in _databaseFixture.ClubWithTeamsAndMatchLocation.Teams.SelectMany(x => x.MatchLocations)) { var resultMatchLocation = result.MatchLocations.SingleOrDefault(x => x.MatchLocationId == matchLocation.MatchLocationId); Assert.NotNull(resultMatchLocation); Assert.Equal(matchLocation.SecondaryAddressableObjectName, resultMatchLocation.SecondaryAddressableObjectName); Assert.Equal(matchLocation.PrimaryAddressableObjectName, resultMatchLocation.PrimaryAddressableObjectName); Assert.Equal(matchLocation.Locality, resultMatchLocation.Locality); Assert.Equal(matchLocation.Town, resultMatchLocation.Town); } }
public async Task Read_team_listings_pages_results() { var teamDataSource = new SqlServerTeamListingDataSource(_databaseFixture.ConnectionFactory); const int pageSize = 10; var pageNumber = 1; var remaining = _databaseFixture.TeamListings.Count; while (remaining > 0) { var result = await teamDataSource.ReadTeamListings(new TeamListingFilter { Paging = new Paging { PageNumber = pageNumber, PageSize = pageSize } }).ConfigureAwait(false); var expected = pageSize > remaining ? remaining : pageSize; Assert.Equal(expected, result.Count); pageNumber++; remaining -= pageSize; } }
public async Task Read_team_listings_supports_filter_by_team_type() { var teamDataSource = new SqlServerTeamListingDataSource(_databaseFixture.ConnectionFactory); var query = new TeamListingFilter { TeamTypes = new List <TeamType?> { TeamType.Representative } }; var result = await teamDataSource.ReadTeamListings(query).ConfigureAwait(false); var expected = _databaseFixture.TeamListings .Where(x => _databaseFixture.Teams.Where(t => t.TeamType == TeamType.Representative).Select(t => t.TeamId.Value).Contains(x.TeamListingId.Value) || _databaseFixture.Clubs.Where(c => c.Teams.Any(t => t.TeamType == TeamType.Representative)).Select(c => c.ClubId.Value).Contains(x.TeamListingId.Value)); Assert.Equal(expected.Count(), result.Count); foreach (var team in expected) { Assert.NotNull(result.SingleOrDefault(x => x.TeamListingId == team.TeamListingId)); } }
public async Task Read_team_listings_returns_basic_fields_for_clubs() { var teamDataSource = new SqlServerTeamListingDataSource(_databaseFixture.ConnectionFactory); var results = await teamDataSource.ReadTeamListings(null).ConfigureAwait(false); foreach (var club in _databaseFixture.TeamListings.Where(x => _databaseFixture.Clubs.Select(c => c.ClubId.Value).ToList().Contains(x.TeamListingId.Value))) { var result = results.SingleOrDefault(x => x.TeamListingId == club.TeamListingId); Assert.NotNull(result); Assert.Equal(club.ClubOrTeamName, result.ClubOrTeamName); Assert.Equal(club.ClubOrTeamRoute, result.ClubOrTeamRoute); Assert.Equal(club.Active, result.Active); Assert.Equal(club.PlayerTypes.Count, result.PlayerTypes.Count); foreach (var playerType in club.PlayerTypes) { Assert.Contains(playerType, result.PlayerTypes); } } }