public async Task Read_tournament_by_route_reads_minimal_tournament_in_the_future()
{
var routeNormaliser = new Mock <IRouteNormaliser>();
routeNormaliser.Setup(x => x.NormaliseRouteToEntity(_databaseFixture.TournamentInTheFutureWithMinimalDetails.TournamentRoute, "tournaments")).Returns(_databaseFixture.TournamentInTheFutureWithMinimalDetails.TournamentRoute);
var tournamentDataSource = new SqlServerTournamentDataSource(_databaseFixture.ConnectionFactory, routeNormaliser.Object);
var result = await tournamentDataSource.ReadTournamentByRoute(_databaseFixture.TournamentInTheFutureWithMinimalDetails.TournamentRoute).ConfigureAwait(false);
Assert.NotNull(result);
}
public async Task Read_tournament_by_route_returns_over_sets()
{
var routeNormaliser = new Mock <IRouteNormaliser>();
routeNormaliser.Setup(x => x.NormaliseRouteToEntity(_databaseFixture.TournamentInThePastWithFullDetails.TournamentRoute, "tournaments")).Returns(_databaseFixture.TournamentInThePastWithFullDetails.TournamentRoute);
var tournamentDataSource = new SqlServerTournamentDataSource(_databaseFixture.ConnectionFactory, routeNormaliser.Object);
var result = await tournamentDataSource.ReadTournamentByRoute(_databaseFixture.TournamentInThePastWithFullDetails.TournamentRoute).ConfigureAwait(false);
for (var set = 0; set < _databaseFixture.TournamentInThePastWithFullDetails.DefaultOverSets.Count; set++)
{
Assert.Equal(_databaseFixture.TournamentInThePastWithFullDetails.DefaultOverSets[set].OverSetId, result.DefaultOverSets[set].OverSetId);
Assert.Equal(_databaseFixture.TournamentInThePastWithFullDetails.DefaultOverSets[set].Overs, result.DefaultOverSets[set].Overs);
Assert.Equal(_databaseFixture.TournamentInThePastWithFullDetails.DefaultOverSets[set].BallsPerOver, result.DefaultOverSets[set].BallsPerOver);
}
}
public async Task Read_tournament_by_route_returns_tournament_location()
{
var routeNormaliser = new Mock <IRouteNormaliser>();
routeNormaliser.Setup(x => x.NormaliseRouteToEntity(_databaseFixture.TournamentInThePastWithFullDetails.TournamentRoute, "tournaments")).Returns(_databaseFixture.TournamentInThePastWithFullDetails.TournamentRoute);
var tournamentDataSource = new SqlServerTournamentDataSource(_databaseFixture.ConnectionFactory, routeNormaliser.Object);
var result = await tournamentDataSource.ReadTournamentByRoute(_databaseFixture.TournamentInThePastWithFullDetails.TournamentRoute).ConfigureAwait(false);
Assert.Equal(_databaseFixture.TournamentInThePastWithFullDetails.TournamentLocation.MatchLocationId, result.TournamentLocation.MatchLocationId);
Assert.Equal(_databaseFixture.TournamentInThePastWithFullDetails.TournamentLocation.MatchLocationRoute, result.TournamentLocation.MatchLocationRoute);
Assert.Equal(_databaseFixture.TournamentInThePastWithFullDetails.TournamentLocation.SecondaryAddressableObjectName, result.TournamentLocation.SecondaryAddressableObjectName);
Assert.Equal(_databaseFixture.TournamentInThePastWithFullDetails.TournamentLocation.PrimaryAddressableObjectName, result.TournamentLocation.PrimaryAddressableObjectName);
Assert.Equal(_databaseFixture.TournamentInThePastWithFullDetails.TournamentLocation.Locality, result.TournamentLocation.Locality);
Assert.Equal(_databaseFixture.TournamentInThePastWithFullDetails.TournamentLocation.Town, result.TournamentLocation.Town);
Assert.Equal(_databaseFixture.TournamentInThePastWithFullDetails.TournamentLocation.Latitude, result.TournamentLocation.Latitude);
Assert.Equal(_databaseFixture.TournamentInThePastWithFullDetails.TournamentLocation.Longitude, result.TournamentLocation.Longitude);
}
public async Task Read_tournament_by_route_returns_season_with_competition()
{
var routeNormaliser = new Mock <IRouteNormaliser>();
routeNormaliser.Setup(x => x.NormaliseRouteToEntity(_databaseFixture.TournamentInThePastWithFullDetails.TournamentRoute, "tournaments")).Returns(_databaseFixture.TournamentInThePastWithFullDetails.TournamentRoute);
var tournamentDataSource = new SqlServerTournamentDataSource(_databaseFixture.ConnectionFactory, routeNormaliser.Object);
var result = await tournamentDataSource.ReadTournamentByRoute(_databaseFixture.TournamentInThePastWithFullDetails.TournamentRoute).ConfigureAwait(false);
foreach (var season in _databaseFixture.TournamentInThePastWithFullDetails.Seasons)
{
var resultSeason = result.Seasons.SingleOrDefault(x => x.SeasonId == season.SeasonId);
Assert.NotNull(resultSeason);
Assert.Equal(season.SeasonRoute, resultSeason.SeasonRoute);
Assert.Equal(season.FromYear, resultSeason.FromYear);
Assert.Equal(season.UntilYear, resultSeason.UntilYear);
Assert.Equal(season.Competition.CompetitionName, resultSeason.Competition.CompetitionName);
}
}
public async Task Read_tournament_by_route_returns_teams_sorted_by_comparable_name()
{
var routeNormaliser = new Mock <IRouteNormaliser>();
routeNormaliser.Setup(x => x.NormaliseRouteToEntity(_databaseFixture.TournamentInThePastWithFullDetails.TournamentRoute, "tournaments")).Returns(_databaseFixture.TournamentInThePastWithFullDetails.TournamentRoute);
var tournamentDataSource = new SqlServerTournamentDataSource(_databaseFixture.ConnectionFactory, routeNormaliser.Object);
var result = await tournamentDataSource.ReadTournamentByRoute(_databaseFixture.TournamentInThePastWithFullDetails.TournamentRoute).ConfigureAwait(false);
var expectedTeams = _databaseFixture.TournamentInThePastWithFullDetails.Teams.OrderBy(x => x.Team.ComparableName()).ToList();
for (var team = 0; team < expectedTeams.Count; team++)
{
Assert.Equal(expectedTeams[team].TournamentTeamId, result.Teams[team].TournamentTeamId);
Assert.Equal(expectedTeams[team].TeamRole, result.Teams[team].TeamRole);
Assert.Equal(expectedTeams[team].Team.TeamId, result.Teams[team].Team.TeamId);
Assert.Equal(expectedTeams[team].Team.TeamName, result.Teams[team].Team.TeamName);
Assert.Equal(expectedTeams[team].Team.TeamRoute, result.Teams[team].Team.TeamRoute);
Assert.Equal(expectedTeams[team].Team.TeamType, result.Teams[team].Team.TeamType);
}
}
public async Task Read_tournament_by_route_returns_basic_tournament_fields()
{
var routeNormaliser = new Mock <IRouteNormaliser>();
routeNormaliser.Setup(x => x.NormaliseRouteToEntity(_databaseFixture.TournamentInThePastWithFullDetails.TournamentRoute, "tournaments")).Returns(_databaseFixture.TournamentInThePastWithFullDetails.TournamentRoute);
var tournamentDataSource = new SqlServerTournamentDataSource(_databaseFixture.ConnectionFactory, routeNormaliser.Object);
var result = await tournamentDataSource.ReadTournamentByRoute(_databaseFixture.TournamentInThePastWithFullDetails.TournamentRoute).ConfigureAwait(false);
Assert.Equal(_databaseFixture.TournamentInThePastWithFullDetails.TournamentId, result.TournamentId);
Assert.Equal(_databaseFixture.TournamentInThePastWithFullDetails.TournamentName, result.TournamentName);
Assert.Equal(_databaseFixture.TournamentInThePastWithFullDetails.PlayerType, result.PlayerType);
Assert.Equal(_databaseFixture.TournamentInThePastWithFullDetails.StartTime, result.StartTime);
Assert.Equal(_databaseFixture.TournamentInThePastWithFullDetails.StartTimeIsKnown, result.StartTimeIsKnown);
Assert.Equal(_databaseFixture.TournamentInThePastWithFullDetails.PlayersPerTeam, result.PlayersPerTeam);
Assert.Equal(_databaseFixture.TournamentInThePastWithFullDetails.QualificationType, result.QualificationType);
Assert.Equal(_databaseFixture.TournamentInThePastWithFullDetails.MaximumTeamsInTournament, result.MaximumTeamsInTournament);
Assert.Equal(_databaseFixture.TournamentInThePastWithFullDetails.SpacesInTournament, result.SpacesInTournament);
Assert.Equal(_databaseFixture.TournamentInThePastWithFullDetails.TournamentNotes, result.TournamentNotes);
Assert.Equal(_databaseFixture.TournamentInThePastWithFullDetails.TournamentRoute, result.TournamentRoute);
Assert.Equal(_databaseFixture.TournamentInThePastWithFullDetails.MemberKey, result.MemberKey);
}
