public async Task Read_team_by_route_with_related_data_returns_basic_fields()
{
var routeNormaliser = new Mock <IRouteNormaliser>();
routeNormaliser.Setup(x => x.NormaliseRouteToEntity(_databaseFixture.TeamWithFullDetails.TeamRoute, It.IsAny <Dictionary <string, string> >())).Returns(_databaseFixture.TeamWithFullDetails.TeamRoute);
var teamDataSource = new SqlServerTeamDataSource(_databaseFixture.ConnectionFactory, routeNormaliser.Object);
var result = await teamDataSource.ReadTeamByRoute(_databaseFixture.TeamWithFullDetails.TeamRoute, true).ConfigureAwait(false);
Assert.Equal(_databaseFixture.TeamWithFullDetails.TeamId, result.TeamId);
Assert.Equal(_databaseFixture.TeamWithFullDetails.TeamName, result.TeamName);
Assert.Equal(_databaseFixture.TeamWithFullDetails.TeamType, result.TeamType);
Assert.Equal(_databaseFixture.TeamWithFullDetails.TeamRoute, result.TeamRoute);
Assert.Equal(_databaseFixture.TeamWithFullDetails.PlayerType, result.PlayerType);
Assert.Equal(_databaseFixture.TeamWithFullDetails.Introduction, result.Introduction);
Assert.Equal(_databaseFixture.TeamWithFullDetails.AgeRangeLower, result.AgeRangeLower);
Assert.Equal(_databaseFixture.TeamWithFullDetails.AgeRangeUpper, result.AgeRangeUpper);
Assert.Equal(_databaseFixture.TeamWithFullDetails.ClubMark, result.ClubMark);
Assert.Equal(_databaseFixture.TeamWithFullDetails.Facebook, result.Facebook);
Assert.Equal(_databaseFixture.TeamWithFullDetails.Twitter, result.Twitter);
Assert.Equal(_databaseFixture.TeamWithFullDetails.Instagram, result.Instagram);
Assert.Equal(_databaseFixture.TeamWithFullDetails.YouTube, result.YouTube);
Assert.Equal(_databaseFixture.TeamWithFullDetails.Website, result.Website);
Assert.Equal(_databaseFixture.TeamWithFullDetails.PlayingTimes, result.PlayingTimes);
Assert.Equal(_databaseFixture.TeamWithFullDetails.Cost, result.Cost);
Assert.Equal(_databaseFixture.TeamWithFullDetails.PublicContactDetails, result.PublicContactDetails);
Assert.Equal(_databaseFixture.TeamWithFullDetails.PrivateContactDetails, result.PrivateContactDetails);
Assert.Equal(_databaseFixture.TeamWithFullDetails.UntilYear, result.UntilYear);
Assert.Equal(_databaseFixture.TeamWithFullDetails.MemberGroupName, result.MemberGroupName);
Assert.Equal(_databaseFixture.TeamWithFullDetails.MemberGroupKey, result.MemberGroupKey);
}
public async Task Read_team_by_route_returns_seasons_with_competitions_and_match_types()
{
var routeNormaliser = new Mock <IRouteNormaliser>();
routeNormaliser.Setup(x => x.NormaliseRouteToEntity(_databaseFixture.TeamWithFullDetails.TeamRoute, It.IsAny <Dictionary <string, string> >())).Returns(_databaseFixture.TeamWithFullDetails.TeamRoute);
var teamDataSource = new SqlServerTeamDataSource(_databaseFixture.ConnectionFactory, routeNormaliser.Object);
var result = await teamDataSource.ReadTeamByRoute(_databaseFixture.TeamWithFullDetails.TeamRoute, true).ConfigureAwait(false);
Assert.Equal(_databaseFixture.TeamWithFullDetails.Seasons.Count, result.Seasons.Count);
foreach (var season in _databaseFixture.TeamWithFullDetails.Seasons)
{
var seasonResult = result.Seasons.SingleOrDefault(x => x.Season.SeasonId == season.Season.SeasonId);
Assert.NotNull(seasonResult);
Assert.Equal(season.Season.FromYear, seasonResult.Season.FromYear);
Assert.Equal(season.Season.UntilYear, seasonResult.Season.UntilYear);
Assert.Equal(season.Season.SeasonRoute, seasonResult.Season.SeasonRoute);
Assert.Equal(season.Season.Competition.CompetitionId, seasonResult.Season.Competition.CompetitionId);
Assert.Equal(season.Season.Competition.CompetitionName, seasonResult.Season.Competition.CompetitionName);
Assert.Equal(season.Season.MatchTypes.Count, seasonResult.Season.MatchTypes.Count);
foreach (var expectedMatchType in season.Season.MatchTypes)
{
Assert.Contains(expectedMatchType, season.Season.MatchTypes);
}
}
}
public async Task Read_team_by_route_returns_club()
{
var teamWithAClub = _databaseFixture.ClubWithTeamsAndMatchLocation.Teams.First();
var routeNormaliser = new Mock <IRouteNormaliser>();
routeNormaliser.Setup(x => x.NormaliseRouteToEntity(teamWithAClub.TeamRoute, It.IsAny <Dictionary <string, string> >())).Returns(teamWithAClub.TeamRoute);
var teamDataSource = new SqlServerTeamDataSource(_databaseFixture.ConnectionFactory, routeNormaliser.Object);
var result = await teamDataSource.ReadTeamByRoute(teamWithAClub.TeamRoute, true).ConfigureAwait(false);
Assert.Equal(_databaseFixture.ClubWithTeamsAndMatchLocation.ClubName, result.Club.ClubName);
Assert.Equal(_databaseFixture.ClubWithTeamsAndMatchLocation.ClubRoute, result.Club.ClubRoute);
}
public async Task Read_minimal_team_by_route_returns_basic_fields()
{
var routeNormaliser = new Mock <IRouteNormaliser>();
routeNormaliser.Setup(x => x.NormaliseRouteToEntity(_databaseFixture.TeamWithMinimalDetails.TeamRoute, It.IsAny <Dictionary <string, string> >())).Returns(_databaseFixture.TeamWithMinimalDetails.TeamRoute);
var teamDataSource = new SqlServerTeamDataSource(_databaseFixture.ConnectionFactory, routeNormaliser.Object);
var result = await teamDataSource.ReadTeamByRoute(_databaseFixture.TeamWithMinimalDetails.TeamRoute, false).ConfigureAwait(false);
Assert.Equal(_databaseFixture.TeamWithMinimalDetails.TeamId, result.TeamId);
Assert.Equal(_databaseFixture.TeamWithMinimalDetails.TeamName, result.TeamName);
Assert.Equal(_databaseFixture.TeamWithMinimalDetails.TeamType, result.TeamType);
Assert.Equal(_databaseFixture.TeamWithMinimalDetails.TeamRoute, result.TeamRoute);
Assert.Equal(_databaseFixture.TeamWithMinimalDetails.UntilYear, result.UntilYear);
Assert.Equal(_databaseFixture.TeamWithMinimalDetails.MemberGroupName, result.MemberGroupName);
}
public async Task Read_team_by_route_returns_match_locations()
{
var routeNormaliser = new Mock <IRouteNormaliser>();
routeNormaliser.Setup(x => x.NormaliseRouteToEntity(_databaseFixture.TeamWithFullDetails.TeamRoute, It.IsAny <Dictionary <string, string> >())).Returns(_databaseFixture.TeamWithFullDetails.TeamRoute);
var teamDataSource = new SqlServerTeamDataSource(_databaseFixture.ConnectionFactory, routeNormaliser.Object);
var result = await teamDataSource.ReadTeamByRoute(_databaseFixture.TeamWithFullDetails.TeamRoute, true).ConfigureAwait(false);
foreach (var matchLocation in _databaseFixture.TeamWithFullDetails.MatchLocations)
{
var matchLocationResult = result.MatchLocations.SingleOrDefault(x => x.MatchLocationId == matchLocation.MatchLocationId);
Assert.NotNull(matchLocationResult);
Assert.Equal(matchLocation.MatchLocationRoute, matchLocation.MatchLocationRoute);
Assert.Equal(matchLocation.SecondaryAddressableObjectName, matchLocation.SecondaryAddressableObjectName);
Assert.Equal(matchLocation.PrimaryAddressableObjectName, matchLocation.PrimaryAddressableObjectName);
Assert.Equal(matchLocation.Locality, matchLocation.Locality);
Assert.Equal(matchLocation.Town, matchLocation.Town);
Assert.Equal(matchLocation.AdministrativeArea, matchLocation.AdministrativeArea);
}
}
