public SqlServerTestDataFixture() : base("StoolballStatisticsDataSourceIntegrationTests")
{
// Populate seed data so that there's a consistent baseline for each test run
var oversHelper = new OversHelper();
var bowlingFiguresCalculator = new BowlingFiguresCalculator(oversHelper);
var playerIdentityFinder = new PlayerIdentityFinder();
var playerInMatchStatisticsBuilder = new PlayerInMatchStatisticsBuilder(playerIdentityFinder, oversHelper);
var teamFakerFactory = new TeamFakerFactory();
var matchLocationFakerFactory = new MatchLocationFakerFactory();
var schoolFakerFactory = new SchoolFakerFactory();
var randomSeedDataGenerator = new SeedDataGenerator(oversHelper, bowlingFiguresCalculator, playerIdentityFinder, teamFakerFactory, matchLocationFakerFactory, schoolFakerFactory);
// Use Bogus to generate Schools data
Randomizer.Seed = new Random(85437684);
TestData = randomSeedDataGenerator.GenerateTestData();
using (var connection = ConnectionFactory.CreateDatabaseConnection())
{
connection.Open();
var repo = new SqlServerIntegrationTestsRepository(connection, playerInMatchStatisticsBuilder);
repo.CreateUmbracoBaseRecords();
repo.CreateTestData(TestData);
}
}
public SqlServerStatisticsMaxResultsDataSourceFixture() : base("StoolballStatisticsMaxResultsDataSourceIntegrationTests")
{
// Populate seed data so that there's a consistent baseline for each test run
var oversHelper = new OversHelper();
var bowlingFiguresCalculator = new BowlingFiguresCalculator(oversHelper);
var playerIdentityFinder = new PlayerIdentityFinder();
var playerInMatchStatisticsBuilder = new PlayerInMatchStatisticsBuilder(playerIdentityFinder, oversHelper);
var seedDataGenerator = new SeedDataGenerator(oversHelper, bowlingFiguresCalculator, playerIdentityFinder,
new TeamFakerFactory(), new MatchLocationFakerFactory(), new SchoolFakerFactory());
TestData = seedDataGenerator.GenerateTestData();
PlayerWithFifthAndSixthBowlingFiguresTheSame = ForceFifthAndSixthBowlingFiguresToBeTheSame(TestData);
PlayerWithFifthAndSixthInningsTheSame = ForceFifthAndSixthPlayerInningsToBeTheSame(TestData, bowlingFiguresCalculator);
using (var connection = ConnectionFactory.CreateDatabaseConnection())
{
connection.Open();
var repo = new SqlServerIntegrationTestsRepository(connection, playerInMatchStatisticsBuilder);
repo.CreateUmbracoBaseRecords();
repo.CreateTestData(TestData);
}
}
private void GenerateSeedData()
{
var oversHelper = new OversHelper();
var playerIdentityFinder = new PlayerIdentityFinder();
var playerInMatchStatisticsBuilder = new PlayerInMatchStatisticsBuilder(playerIdentityFinder, oversHelper);
var seedDataGenerator = new SeedDataGenerator(oversHelper, new BowlingFiguresCalculator(oversHelper), playerIdentityFinder,
new TeamFakerFactory(), new MatchLocationFakerFactory(), new SchoolFakerFactory());
using (var connection = ConnectionFactory.CreateDatabaseConnection())
{
connection.Open();
var repo = new SqlServerIntegrationTestsRepository(connection, playerInMatchStatisticsBuilder);
repo.CreateUmbracoBaseRecords();
var members = seedDataGenerator.CreateMembers();
foreach (var member in members)
{
repo.CreateMember(member);
}
ClubWithMinimalDetails = seedDataGenerator.CreateClubWithMinimalDetails();
repo.CreateClub(ClubWithMinimalDetails);
Clubs.Add(ClubWithMinimalDetails);
ClubWithOneTeam = seedDataGenerator.CreateClubWithMinimalDetails();
repo.CreateClub(ClubWithOneTeam);
Clubs.Add(ClubWithOneTeam);
var onlyTeamInClub = seedDataGenerator.CreateTeamWithMinimalDetails("Only team in the club");
ClubWithOneTeam.Teams.Add(onlyTeamInClub);
onlyTeamInClub.Club = ClubWithOneTeam;
repo.CreateTeam(onlyTeamInClub);
Teams.Add(onlyTeamInClub);
ClubWithTeamsAndMatchLocation = seedDataGenerator.CreateClubWithTeams();
MatchLocationForClub = seedDataGenerator.CreateMatchLocationWithMinimalDetails();
MatchLocationForClub.PrimaryAddressableObjectName = "Club PAON";
MatchLocationForClub.SecondaryAddressableObjectName = "Club SAON";
MatchLocationForClub.Locality = "Club locality";
MatchLocationForClub.Town = "Club town";
MatchLocationForClub.AdministrativeArea = "Club area";
var teamWithMatchLocation = ClubWithTeamsAndMatchLocation.Teams.First(x => !x.UntilYear.HasValue);
teamWithMatchLocation.MatchLocations.Add(MatchLocationForClub);
MatchLocationForClub.Teams.Add(teamWithMatchLocation);
repo.CreateClub(ClubWithTeamsAndMatchLocation);
Clubs.Add(ClubWithTeamsAndMatchLocation);
foreach (var team in ClubWithTeamsAndMatchLocation.Teams)
{
repo.CreateTeam(team);
foreach (var matchLocation in team.MatchLocations)
{
repo.CreateMatchLocation(matchLocation);
repo.AddTeamToMatchLocation(team, matchLocation);
MatchLocations.Add(matchLocation);
}
}
Teams.AddRange(ClubWithTeamsAndMatchLocation.Teams);
TeamWithMinimalDetails = seedDataGenerator.CreateTeamWithMinimalDetails("Team minimal");
repo.CreateTeam(TeamWithMinimalDetails);
Teams.Add(TeamWithMinimalDetails);
TeamWithFullDetails = seedDataGenerator.CreateTeamWithFullDetails("Team with full details");
repo.CreateTeam(TeamWithFullDetails);
Teams.Add(TeamWithFullDetails);
foreach (var matchLocation in TeamWithFullDetails.MatchLocations)
{
repo.CreateMatchLocation(matchLocation);
foreach (var team in matchLocation.Teams)
{
if (team.TeamId != TeamWithFullDetails.TeamId)
{
repo.CreateTeam(team);
Teams.Add(team);
}
repo.AddTeamToMatchLocation(team, matchLocation);
}
MatchLocations.Add(matchLocation);
}
repo.CreateCompetition(TeamWithFullDetails.Seasons[0].Season.Competition);
Competitions.Add(TeamWithFullDetails.Seasons[0].Season.Competition);
foreach (var season in TeamWithFullDetails.Seasons)
{
repo.CreateSeason(season.Season, season.Season.Competition.CompetitionId.Value);
repo.AddTeamToSeason(season);
Seasons.Add(season.Season);
}
MatchInThePastWithMinimalDetails = seedDataGenerator.CreateMatchInThePastWithMinimalDetails();
repo.CreateMatch(MatchInThePastWithMinimalDetails);
Matches.Add(MatchInThePastWithMinimalDetails);
MatchListings.Add(MatchInThePastWithMinimalDetails.ToMatchListing());
MatchInTheFutureWithMinimalDetails = seedDataGenerator.CreateMatchInThePastWithMinimalDetails();
MatchInTheFutureWithMinimalDetails.StartTime = TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTimeOffset.UtcNow.AccurateToTheMinute().AddMonths(1), UkTimeZone());
repo.CreateMatch(MatchInTheFutureWithMinimalDetails);
Matches.Add(MatchInTheFutureWithMinimalDetails);
MatchListings.Add(MatchInTheFutureWithMinimalDetails.ToMatchListing());
MatchInThePastWithFullDetails = seedDataGenerator.CreateMatchInThePastWithFullDetails(members);
repo.CreateMatchLocation(MatchInThePastWithFullDetails.MatchLocation);
var playersForMatchInThePastWithFullDetails = playerIdentityFinder.PlayerIdentitiesInMatch(MatchInThePastWithFullDetails);
MatchInThePastWithFullDetails.Teams[0].Team.UntilYear = 2020;
foreach (var team in MatchInThePastWithFullDetails.Teams)
{
repo.CreateTeam(team.Team);
}
foreach (var player in playersForMatchInThePastWithFullDetails)
{
repo.CreatePlayer(player.Player);
repo.CreatePlayerIdentity(player);
}
repo.CreateCompetition(MatchInThePastWithFullDetails.Season.Competition);
repo.CreateSeason(MatchInThePastWithFullDetails.Season, MatchInThePastWithFullDetails.Season.Competition.CompetitionId.Value);
repo.CreateMatch(MatchInThePastWithFullDetails);
Teams.AddRange(MatchInThePastWithFullDetails.Teams.Select(x => x.Team));
Competitions.Add(MatchInThePastWithFullDetails.Season.Competition);
Seasons.Add(MatchInThePastWithFullDetails.Season);
MatchLocations.Add(MatchInThePastWithFullDetails.MatchLocation);
Matches.Add(MatchInThePastWithFullDetails);
MatchListings.Add(MatchInThePastWithFullDetails.ToMatchListing());
PlayerIdentities.AddRange(playerIdentityFinder.PlayerIdentitiesInMatch(MatchInThePastWithFullDetails));
MatchInThePastWithFullDetails.History.AddRange(new[] { new AuditRecord {
Action = AuditAction.Create,
ActorName = nameof(SqlServerDataSourceFixture),
AuditDate = DateTimeOffset.UtcNow.AccurateToTheMinute().AddMonths(-1),
EntityUri = MatchInThePastWithFullDetails.EntityUri
}, new AuditRecord {
Action = AuditAction.Update,
ActorName = nameof(SqlServerDataSourceFixture),
AuditDate = DateTimeOffset.UtcNow.AccurateToTheMinute(),
EntityUri = MatchInThePastWithFullDetails.EntityUri
} });
foreach (var audit in MatchInThePastWithFullDetails.History)
{
repo.CreateAudit(audit);
}
TournamentInThePastWithMinimalDetails = seedDataGenerator.CreateTournamentInThePastWithMinimalDetails();
repo.CreateTournament(TournamentInThePastWithMinimalDetails);
Tournaments.Add(TournamentInThePastWithMinimalDetails);
MatchListings.Add(TournamentInThePastWithMinimalDetails.ToMatchListing());
TournamentInTheFutureWithMinimalDetails = seedDataGenerator.CreateTournamentInThePastWithMinimalDetails();
TournamentInTheFutureWithMinimalDetails.StartTime = TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTimeOffset.UtcNow.AccurateToTheMinute().AddMonths(1), UkTimeZone());
repo.CreateTournament(TournamentInTheFutureWithMinimalDetails);
Tournaments.Add(TournamentInTheFutureWithMinimalDetails);
MatchListings.Add(TournamentInTheFutureWithMinimalDetails.ToMatchListing());
TournamentInThePastWithFullDetails = seedDataGenerator.CreateTournamentInThePastWithFullDetails(members);
Teams.AddRange(TournamentInThePastWithFullDetails.Teams.Select(x => x.Team));
MatchInThePastWithFullDetails.Teams[0].Team.UntilYear = 2020;
foreach (var team in TournamentInThePastWithFullDetails.Teams)
{
repo.CreateTeam(team.Team);
}
MatchLocations.Add(TournamentInThePastWithFullDetails.TournamentLocation);
repo.CreateMatchLocation(TournamentInThePastWithFullDetails.TournamentLocation);
repo.CreateTournament(TournamentInThePastWithFullDetails);
foreach (var team in TournamentInThePastWithFullDetails.Teams)
{
repo.AddTeamToTournament(team, TournamentInThePastWithFullDetails);
}
foreach (var season in TournamentInThePastWithFullDetails.Seasons)
{
repo.CreateCompetition(season.Competition);
Competitions.Add(season.Competition);
repo.CreateSeason(season, season.Competition.CompetitionId.Value);
repo.AddTournamentToSeason(TournamentInThePastWithFullDetails, season);
Seasons.Add(season);
}
Tournaments.Add(TournamentInThePastWithFullDetails);
MatchListings.Add(TournamentInThePastWithFullDetails.ToMatchListing());
for (var i = 0; i < 5; i++)
{
var tournamentMatch = seedDataGenerator.CreateMatchInThePastWithMinimalDetails();
tournamentMatch.Tournament = TournamentInThePastWithFullDetails;
tournamentMatch.StartTime = TournamentInThePastWithFullDetails.StartTime.AddHours(i);
tournamentMatch.OrderInTournament = i + 1;
repo.CreateMatch(tournamentMatch);
Matches.Add(tournamentMatch);
TournamentMatchListings.Add(tournamentMatch.ToMatchListing());
}
TournamentInThePastWithFullDetails.History.AddRange(new[] { new AuditRecord {
Action = AuditAction.Create,
ActorName = nameof(SqlServerDataSourceFixture),
AuditDate = DateTimeOffset.UtcNow.AccurateToTheMinute().AddMonths(-2),
EntityUri = TournamentInThePastWithFullDetails.EntityUri
}, new AuditRecord {
Action = AuditAction.Update,
ActorName = nameof(SqlServerDataSourceFixture),
AuditDate = DateTimeOffset.UtcNow.AccurateToTheMinute().AddDays(-7),
EntityUri = TournamentInThePastWithFullDetails.EntityUri
} });
foreach (var audit in TournamentInThePastWithFullDetails.History)
{
repo.CreateAudit(audit);
}
MatchInThePastWithFullDetailsAndTournament = seedDataGenerator.CreateMatchInThePastWithFullDetails(members);
MatchInThePastWithFullDetailsAndTournament.Tournament = TournamentInThePastWithMinimalDetails;
MatchInThePastWithFullDetailsAndTournament.Season.FromYear = MatchInThePastWithFullDetailsAndTournament.Season.UntilYear = 2018;
repo.CreateMatchLocation(MatchInThePastWithFullDetailsAndTournament.MatchLocation);
foreach (var team in MatchInThePastWithFullDetailsAndTournament.Teams)
{
repo.CreateTeam(team.Team);
}
var playersForMatchInThePastWithFullDetailsAndTournament = playerIdentityFinder.PlayerIdentitiesInMatch(MatchInThePastWithFullDetailsAndTournament);
foreach (var player in playersForMatchInThePastWithFullDetailsAndTournament)
{
repo.CreatePlayer(player.Player);
repo.CreatePlayerIdentity(player);
}
repo.CreateCompetition(MatchInThePastWithFullDetailsAndTournament.Season.Competition);
repo.CreateSeason(MatchInThePastWithFullDetailsAndTournament.Season, MatchInThePastWithFullDetailsAndTournament.Season.Competition.CompetitionId.Value);
repo.CreateMatch(MatchInThePastWithFullDetailsAndTournament);
Teams.AddRange(MatchInThePastWithFullDetailsAndTournament.Teams.Select(x => x.Team));
Competitions.Add(MatchInThePastWithFullDetailsAndTournament.Season.Competition);
MatchLocations.Add(MatchInThePastWithFullDetailsAndTournament.MatchLocation);
Matches.Add(MatchInThePastWithFullDetailsAndTournament);
TournamentMatchListings.Add(MatchInThePastWithFullDetailsAndTournament.ToMatchListing());
Seasons.Add(MatchInThePastWithFullDetailsAndTournament.Season);
PlayerIdentities.AddRange(playerIdentityFinder.PlayerIdentitiesInMatch(MatchInThePastWithFullDetailsAndTournament));
CompetitionWithMinimalDetails = seedDataGenerator.CreateCompetitionWithMinimalDetails();
repo.CreateCompetition(CompetitionWithMinimalDetails);
Competitions.Add(CompetitionWithMinimalDetails);
CompetitionWithFullDetails = seedDataGenerator.CreateCompetitionWithFullDetails();
repo.CreateCompetition(CompetitionWithFullDetails);
foreach (var season in CompetitionWithFullDetails.Seasons)
{
repo.CreateSeason(season, CompetitionWithFullDetails.CompetitionId.Value);
Seasons.Add(season);
}
Competitions.Add(CompetitionWithFullDetails);
var competitionForSeason = seedDataGenerator.CreateCompetitionWithMinimalDetails();
competitionForSeason.UntilYear = 2021;
SeasonWithMinimalDetails = seedDataGenerator.CreateSeasonWithMinimalDetails(competitionForSeason, 2020, 2020);
competitionForSeason.Seasons.Add(SeasonWithMinimalDetails);
repo.CreateCompetition(competitionForSeason);
repo.CreateSeason(SeasonWithMinimalDetails, competitionForSeason.CompetitionId.Value);
Competitions.Add(competitionForSeason);
Seasons.Add(SeasonWithMinimalDetails);
SeasonWithFullDetails = seedDataGenerator.CreateSeasonWithFullDetails(competitionForSeason, 2021, 2021, seedDataGenerator.CreateTeamWithMinimalDetails("Team 1 in season"), seedDataGenerator.CreateTeamWithMinimalDetails("Team 2 in season"));
competitionForSeason.Seasons.Add(SeasonWithFullDetails);
Teams.AddRange(SeasonWithFullDetails.Teams.Select(x => x.Team));
foreach (var team in SeasonWithFullDetails.Teams)
{
repo.CreateTeam(team.Team);
}
repo.CreateSeason(SeasonWithFullDetails, competitionForSeason.CompetitionId.Value);
foreach (var team in SeasonWithFullDetails.Teams)
{
repo.AddTeamToSeason(team);
}
Seasons.Add(SeasonWithFullDetails);
MatchLocationWithMinimalDetails = seedDataGenerator.CreateMatchLocationWithMinimalDetails();
repo.CreateMatchLocation(MatchLocationWithMinimalDetails);
MatchLocations.Add(MatchLocationWithMinimalDetails);
MatchLocationWithFullDetails = seedDataGenerator.CreateMatchLocationWithFullDetails();
repo.CreateMatchLocation(MatchLocationWithFullDetails);
Teams.AddRange(MatchLocationWithFullDetails.Teams);
MatchLocations.Add(MatchLocationWithFullDetails);
foreach (var team in Teams.Where(t => t.Club == null || t.Club.ClubId == ClubWithOneTeam.ClubId))
{
TeamListings.Add(team.ToTeamListing());
}
foreach (var club in Clubs.Where(c => c.Teams.Count == 0 || c.Teams.Count > 1))
{
TeamListings.Add(club.ToTeamListing());
}
for (var i = 0; i < 30; i++)
{
var competition = seedDataGenerator.CreateCompetitionWithMinimalDetails();
repo.CreateCompetition(competition);
Competitions.Add(competition);
var matchLocation = seedDataGenerator.CreateMatchLocationWithMinimalDetails();
repo.CreateMatchLocation(matchLocation);
MatchLocations.Add(matchLocation);
var match = seedDataGenerator.CreateMatchInThePastWithMinimalDetails();
match.MatchLocation = matchLocation;
match.StartTime = TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTimeOffset.UtcNow.AccurateToTheMinute().AddMonths(i - 15), UkTimeZone());
match.MatchType = i % 2 == 0 ? MatchType.FriendlyMatch : MatchType.LeagueMatch;
match.PlayerType = i % 3 == 0 ? PlayerType.Mixed : PlayerType.Ladies;
match.Comments = seedDataGenerator.CreateComments(i, members);
repo.CreateMatch(match);
Matches.Add(match);
MatchListings.Add(match.ToMatchListing());
var tournament = seedDataGenerator.CreateTournamentInThePastWithMinimalDetails();
tournament.TournamentLocation = matchLocation;
tournament.StartTime = TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTimeOffset.UtcNow.AccurateToTheMinute().AddMonths(i - 20).AddDays(5), UkTimeZone());
tournament.Comments = seedDataGenerator.CreateComments(i, members);
repo.CreateTournament(tournament);
Tournaments.Add(tournament);
MatchListings.Add(tournament.ToMatchListing());
}
}
}