public async Task AdminScriptsInstalled_True()
{
// Ensure environment state
var serverRepo = new ServerRepository(ConnectionFactorySetup.ConnectionFactory);
var servers = serverRepo.ReadAllActive();
await servers.Select(s => serverRepo.DeleteAsync(s)).WhenAllStreamed(1);
var result = this.sqlServerRepository.AdminScriptsInstalled();
Assert.That(result, Is.True); // This should be true if there are no servers listed in the db
}
public async Task AdminScriptsInstalled_False()
{
// Ensure environment state
var serverRepo = new ServerRepository(ConnectionFactorySetup.ConnectionFactory);
var testServer = await serverRepo.CreateAsync(new Server { CreatedOn = DateTime.UtcNow, ServerType = ServerType.Database });
var result = this.sqlServerRepository.AdminScriptsInstalled();
Assert.That(result, Is.False);
// Teardown
await serverRepo.DeleteAsync(testServer);
}
public async Task Server_ZDeleteAsync()
{
//Arrange
var repo = new ServerRepository(connectionFactory);
//Act
await repo.DeleteAsync(server);
var result = await repo.ReadAsync(server.ServerId);
//Assert
Assert.That(result, Is.Not.Null);
Assert.That(result.DeletedOn, Is.Not.Null);
}
public async Task ClearUnresolvedGapReportData()
{
// Arrange
// Create test server
var serverRepository = new ServerRepository(ConnectionFactorySetup.ConnectionFactory);
var testServer = new Server
{
ServerName = "TestServer",
CreatedOn = DateTime.UtcNow,
ServerType = ServerType.Database
};
var server = await serverRepository.CreateAsync(testServer);
// Create test database
var databaseRepository = new DatabaseRepository(ConnectionFactorySetup.ConnectionFactory);
var testDatabase = new Database
{
Type = DatabaseType.Workspace,
Name = "TestDatabase",
WorkspaceId = 1,
ServerId = server.ServerId
};
var database = await databaseRepository.CreateAsync(testDatabase);
// Create test gap report (unresolved)
var entry = new GapReportEntry
{
DatabaseId = database.Id,
ActivityType = (int)GapActivityType.Backup,
LastActivity = new DateTime(1901, 1, 2, 3, 4, 5),
GapSize = 10002000
};
await this.reportRepository.CreateGapReportData(entry);
// Act - Clear test gap report
await this.reportRepository.ClearUnresolvedGapReportData(server.ServerId, GapActivityType.Backup);
// Assert
Assert.Pass("No results returned");
// Tear down
await serverRepository.DeleteAsync(server);
}
public async Task OneTimeTearDown()
{
var serverRepository = new ServerRepository(ConnectionFactorySetup.ConnectionFactory);
await serverRepository.DeleteAsync(this.server);
}