public void When_VerifyDatabaseServer_With_valid_database_Should_return_Ok()
{
// Arrange
var di = DependencyInjectionFactory.ConfigureDependencyInjection();
var clientConfig = di.GetService <IClientConfig>();
if (!clientConfig.IsAssigned())
{
throw new Exception("clientconfig not returned by dependency injection");
}
clientConfig.DefaultDatabase = "TestClassGenerator";
var connection = clientConfig.GetConfigConnection();
if (!connection.IsAssigned())
{
throw new Exception("connection not returned by configuration");
}
var config = ConnectionManagement.SetDatabaseSecurityInMemory(connection.UserName, connection.Password, connection.ConnectionName);
var databaseProviderFactory = new DatabaseProviderFactory(config.GetSection);
var database = databaseProviderFactory.Create("TestClassGenerator");
// Act
var result = SqlServerCheck.VerifyDatabaseServer(database, 1000);
// Assert
result.Should().BeTrue();
}
public void BuildStructureWithDifferentConnectionNameTest()
{
// arrange
var di = DependencyInjectionFactory.ConfigureDependencyInjection();
var clientConfig = di.GetService <IClientConfig>();
if (!clientConfig.IsAssigned())
{
throw new Exception("clientconfig not returned by dependency injection");
}
clientConfig.DefaultDatabase = "SchemaDatabaseDevelopment";
var client = new SqlClient(new SqlClientRepository(clientConfig));
IDatabaseStructure target = new DatabaseStructure(client);
// act
target.BuildStructure();
// assert
target.Tables.Should().HaveCount(8); // TestClassGenerator heeft nu 6 tabellen
target.Tables.First(x => x.Name == "Test6").PrimaryKey.Should().Be("Test6Id");
}
public void When_TableExists_is_executed_and_table_does_notexists_Should_return_false()
{
// arrange
var di = DependencyInjectionFactory.ConfigureDependencyInjection();
var clientConfig = di.GetService <IClientConfig>();
if (!clientConfig.IsAssigned())
{
throw new Exception("clientconfig not returned by dependency injection");
}
clientConfig.DefaultDatabase = "TestClassGenerator";
var client = new SqlClient(new SqlClientRepository(clientConfig));
IDatabaseStructure target = new DatabaseStructure(client);
target.BuildStructure();
// act
var tableExists = client.TableExists("Test666");
// assert
tableExists.Should().BeFalse();
}
public void When_GetTypedCommaFields_executed_on_table_Should_return_a_string_with_all_ColumnNames_concatenated()
{
// arrange
var di = DependencyInjectionFactory.ConfigureDependencyInjection();
var clientConfig = di.GetService <IClientConfig>();
if (!clientConfig.IsAssigned())
{
throw new Exception("clientconfig not returned by dependency injection");
}
clientConfig.DefaultDatabase = "SchemaDatabaseDevelopment";
var client = new SqlClient(new SqlClientRepository(clientConfig));
IDatabaseStructure target = new DatabaseStructure(client);
target.BuildStructure();
var table = target.Tables.First(x => x.Name == "Test5");
var columnNameList = new List <string> {
"naam", "Omschrijving"
};
// act
var columnString = table.ColumnDataItems.GetFieldNamesAsParameters(columnNameList);
// assert
columnString.Should().Be("string naam, string omschrijving");
}
public void When_VerifyDatabaseServer_With_invalid_database_Should_return_DoesNotExist()
{
// Arrange
var di = DependencyInjectionFactory.ConfigureDependencyInjection();
var clientConfig = di.GetService <IClientConfig>();
if (!clientConfig.IsAssigned())
{
throw new Exception("clientconfig not returned by dependency injection");
}
clientConfig.DefaultDatabase = "TestDatabase";
var connection = clientConfig.GetConfigConnection();
if (!connection.IsAssigned())
{
throw new Exception("connection not returned by configuration");
}
var config = ConnectionManagement.SetDatabaseSecurityInMemory(connection.UserName, connection.Password, connection.ConnectionName);
var databaseProviderFactory = new DatabaseProviderFactory(config.GetSection);
var database = databaseProviderFactory.Create("TestDatabase");
// Act
Action action = () => SqlServerCheck.VerifyDatabaseServer(database, 1000);
// Assert
action.Should().Throw <SqlClientException>().WithMessage("Database TestDatabase does not exist");
}
public void When_DependecyInjection_is_used_With_DbMenu_Should_return_DatabaseStructure_of_DbMenu(string param, string delim, string value)
{
// arrange
var dependencyProvider = DependencyInjectionFactory.ConfigureDependencyInjection($"{param}{delim}{value}");
// act
var target = dependencyProvider.GetService <IDatabaseStructure>();
// assert
target.Should().NotBeNull();
target.Should().BeOfType <DatabaseStructure>();
}
public void When_DependecyInjection_is_used_should_return_DatabaseStructure_Of_defaultDb()
{
// arrange
var dependencyProvider = DependencyInjectionFactory.ConfigureDependencyInjection();
// act
var target = dependencyProvider.GetService <IDatabaseStructure>();
// assert
target.Should().NotBeNull();
target.Should().BeOfType <DatabaseStructure>();
}
public void When_DependecyInjection_is_used_should_have_UseEnvironmentSetting_set_to_true()
{
// arrange
var dependencyProvider = DependencyInjectionFactory.ConfigureDependencyInjection();
// act
var target = dependencyProvider.GetService <IClientConfig>();
// assert
target.Should().NotBeNull();
target.Should().BeOfType <ClientConfig>();
target?.UseEnvironmentSetting.Should().BeTrue();
}
public void When_DependecyInjection_is_used_should_return_commandlinearguments()
{
// arrange
var dependencyProvider = DependencyInjectionFactory.ConfigureDependencyInjection(@"--ConfigFileFolder=some\location\");
// act
var target = dependencyProvider.GetService <IClientConfig>();
// assert
target.Should().NotBeNull();
target.Should().BeOfType <ClientConfig>();
target?.ConfigFileFolder.Should().Be(@"some\location\");
}
public void When_ConfigureSettings_read_with_multiple_connections_Should_set_them_all_in_ClientConfig()
{
// arrange
var di = DependencyInjectionFactory.ConfigureDependencyInjection();
// act
var clientConfig = di.GetService <IClientConfig>();
// assert
if (!clientConfig.IsAssigned())
{
throw new Exception("mayor fail");
}
clientConfig.Connections.Should().HaveCountGreaterThan(1);
clientConfig.Connections.Where(x => !x.Password.IsAssigned()).Should().HaveCount(0);
}
public void BuildStructureTest()
{
// arrange
var di = DependencyInjectionFactory.ConfigureDependencyInjection();
var clientConfig = di.GetService <IClientConfig>();
if (!clientConfig.IsAssigned())
{
throw new Exception("clientconfig not returned by dependency injection");
}
clientConfig.DefaultDatabase = "TestClassGenerator";
var client = new SqlClient(new SqlClientRepository(clientConfig));
IDatabaseStructure target = new DatabaseStructure(client);
// act
target.BuildStructure();
// assert
target.Tables.Should().HaveCount(8); // TestClassGenerator has 7 tables
}
public void When_BuildStructure_of_hMailServer_Should_generate_structure()
{
// arrange
var di = DependencyInjectionFactory.ConfigureDependencyInjection();
var clientConfig = di.GetService <IClientConfig>();
if (!clientConfig.IsAssigned())
{
throw new Exception("clientconfig not returned by dependency injection");
}
clientConfig.DefaultDatabase = "hMailServer";
var client = new SqlClient(new SqlClientRepository(clientConfig));
IDatabaseStructure target = new DatabaseStructure(client);
// act
target.BuildStructure();
// assert
target.Tables.Should().HaveCount(34); // hmailserver contains 34 tables
}
public void BuildStructureWithDBMenuConnectionName()
{
// arrange
var di = DependencyInjectionFactory.ConfigureDependencyInjection();
var clientConfig = di.GetService <IClientConfig>();
if (!clientConfig.IsAssigned())
{
throw new Exception("clientconfig not returned by dependency injection");
}
clientConfig.DefaultDatabase = "TestClassGenerator";
var client = new SqlClient(new SqlClientRepository(clientConfig));
IDatabaseStructure target = new DatabaseStructure(client);
// act
target.BuildStructure();
// assert
target.Tables.First(x => x.Name == "TestInt").HasGuidId.Should().BeTrue();
}
public void BuildStructureWithBlockedHackersConnectionName()
{
// arrange
var di = DependencyInjectionFactory.ConfigureDependencyInjection();
var clientConfig = di.GetService <IClientConfig>();
if (!clientConfig.IsAssigned())
{
throw new Exception("clientconfig not returned by dependency injection");
}
clientConfig.DefaultDatabase = "BlockedHackers";
var client = new SqlClient(new SqlClientRepository(clientConfig));
IDatabaseStructure target = new DatabaseStructure(client);
// act
target.BuildStructure();
// assert
target.Tables.First(x => x.Name == "Blocked").PrimaryKey.Should().Be("BlockedId");
}
static Dl()
{
_serviceProvider = DependencyInjectionFactory.ConfigureDependencyInjection("--DefaultDatabase=TestClassGenerator");
}
