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"); }