public void Oracle_Is_Connected_Returns_Up_Status() { var implementationType = OracleTypeLocator.OracleConnection; var sqlConfig = new OracleProviderConnectorOptions(); var sInfo = new OracleServiceInfo("MyId", "oracle://*****:*****@localhost:1521/orclpdb1"); var logrFactory = new LoggerFactory(); var connFactory = new OracleProviderConnectorFactory(sInfo, sqlConfig, implementationType); var h = new RelationalDbHealthContributor((IDbConnection)connFactory.Create(null), logrFactory.CreateLogger <RelationalDbHealthContributor>()); var status = h.Health(); Assert.Equal(HealthStatus.UP, status.Status); }
public void PostgreSql_Is_Connected_Returns_Up_Status() { var implementationType = PostgreSqlTypeLocator.NpgsqlConnection; var sqlConfig = new PostgresProviderConnectorOptions(); var sInfo = new PostgresServiceInfo("MyId", "postgres://*****:*****@localhost:5432/postgres"); var logrFactory = new LoggerFactory(); var connFactory = new PostgresProviderConnectorFactory(sInfo, sqlConfig, implementationType); var h = new RelationalDbHealthContributor((IDbConnection)connFactory.Create(null), logrFactory.CreateLogger <RelationalDbHealthContributor>()); var status = h.Health(); Assert.Equal(HealthStatus.UP, status.Status); }
public void MySql_Is_Connected_Returns_Up_Status() { var implementationType = MySqlTypeLocator.MySqlConnection; var sqlConfig = new MySqlProviderConnectorOptions() { ConnectionTimeout = 1 }; var sInfo = new MySqlServiceInfo("MyId", "mysql://*****:*****@localhost:3306"); var logrFactory = new LoggerFactory(); var connFactory = new MySqlProviderConnectorFactory(sInfo, sqlConfig, implementationType); var h = new RelationalDbHealthContributor((IDbConnection)connFactory.Create(null), logrFactory.CreateLogger <RelationalDbHealthContributor>()); var status = h.Health(); Assert.Equal(HealthStatus.UP, status.Status); }
public void Sql_Is_Connected_Returns_Up_Status() { var implementationType = SqlServerTypeLocator.SqlConnection; var sqlConfig = new SqlServerProviderConnectorOptions() { Timeout = 1, ConnectionString = "Server=(localdb)\\MSSQLLocalDB;Integrated Security=true" }; var sInfo = new SqlServerServiceInfo("MyId", string.Empty); var logrFactory = new LoggerFactory(); var connFactory = new SqlServerProviderConnectorFactory(sInfo, sqlConfig, implementationType); var h = new RelationalDbHealthContributor((IDbConnection)connFactory.Create(null), logrFactory.CreateLogger <RelationalDbHealthContributor>()); var status = h.Health(); Assert.Equal(HealthStatus.UP, status.Status); }
public void Oracle_Not_Connected_Returns_Down_Status() { var implementationType = OracleTypeLocator.OracleConnection; var sqlConfig = new OracleProviderConnectorOptions() { ConnectionTimeout = 1 }; var sInfo = new OracleServiceInfo("MyId", "oracle://*****:*****@localhost:1521/someService"); var logrFactory = new LoggerFactory(); var connFactory = new OracleProviderConnectorFactory(sInfo, sqlConfig, implementationType); var h = new RelationalDbHealthContributor((IDbConnection)connFactory.Create(null), logrFactory.CreateLogger <RelationalDbHealthContributor>()); var status = h.Health(); Assert.Equal(HealthStatus.DOWN, status.Status); Assert.Contains(status.Details.Keys, k => k == "error"); }
public void PostgreSql_Not_Connected_Returns_Down_Status() { var implementationType = PostgreSqlTypeLocator.NpgsqlConnection; var sqlConfig = new PostgresProviderConnectorOptions() { Timeout = 1 }; var sInfo = new PostgresServiceInfo("MyId", "postgres://localhost:5432/cf_b4f8d2fa_a3ea_4e3a_a0e8_2cd040790355"); var logrFactory = new LoggerFactory(); var connFactory = new PostgresProviderConnectorFactory(sInfo, sqlConfig, implementationType); var h = new RelationalDbHealthContributor((IDbConnection)connFactory.Create(null), logrFactory.CreateLogger <RelationalDbHealthContributor>()); var status = h.Health(); Assert.Equal(HealthStatus.DOWN, status.Status); Assert.Contains(status.Details.Keys, k => k == "error"); }
public void MySql_Not_Connected_Returns_Down_Status() { var implementationType = MySqlTypeLocator.MySqlConnection; var sqlConfig = new MySqlProviderConnectorOptions() { ConnectionTimeout = 1 }; var sInfo = new MySqlServiceInfo("MyId", "mysql://localhost:80;databaseName=invalidDatabaseName"); var logrFactory = new LoggerFactory(); var connFactory = new MySqlProviderConnectorFactory(sInfo, sqlConfig, implementationType); var h = new RelationalDbHealthContributor((IDbConnection)connFactory.Create(null), logrFactory.CreateLogger <RelationalDbHealthContributor>()); var status = h.Health(); Assert.Equal(HealthStatus.DOWN, status.Status); Assert.Contains(status.Details.Keys, k => k == "error"); }
public void Sql_Not_Connected_Returns_Down_Status() { var implementationType = SqlServerTypeLocator.SqlConnection; var sqlConfig = new SqlServerProviderConnectorOptions() { Timeout = 1 }; var sInfo = new SqlServerServiceInfo("MyId", "jdbc:sqlserver://localhost:1433/databaseName=invalidDatabaseName", "Dd6O1BPXUHdrmzbP", "7E1LxXnlH2hhlPVt"); var logrFactory = new LoggerFactory(); var connFactory = new SqlServerProviderConnectorFactory(sInfo, sqlConfig, implementationType); var h = new RelationalDbHealthContributor((IDbConnection)connFactory.Create(null), logrFactory.CreateLogger <RelationalDbHealthContributor>()); var status = h.Health(); Assert.Equal(HealthStatus.DOWN, status.Status); Assert.Contains(status.Details.Keys, k => k == "error"); }
public void GetSqlServerContributor_ReturnsContributor() { var appsettings = new Dictionary <string, string>() { ["sqlserver:credentials:timeout"] = "1", ["sqlserver:credentials:uid"] = "username", ["sqlserver:credentials:uri"] = "jdbc:sqlserver://servername:1433;databaseName=de5aa3a747c134b3d8780f8cc80be519e", ["sqlserver:credentials:db"] = "de5aa3a747c134b3d8780f8cc80be519e", ["sqlserver:credentials:pw"] = "password" }; var configurationBuilder = new ConfigurationBuilder(); configurationBuilder.AddInMemoryCollection(appsettings); var config = configurationBuilder.Build(); var contrib = RelationalDbHealthContributor.GetSqlServerContributor(config); Assert.NotNull(contrib); var status = contrib.Health(); Assert.Equal(HealthStatus.DOWN, status.Status); }
public void GetPostgreSqlContributor_ReturnsContributor() { var appsettings = new Dictionary <string, string>() { ["postgres:client:host"] = "localhost", ["postgres:client:port"] = "1234", ["postgres:client:password"] = "******", ["postgres:client:username"] = "******", ["postgres:client:timeout"] = "1" }; var configurationBuilder = new ConfigurationBuilder(); configurationBuilder.AddInMemoryCollection(appsettings); var config = configurationBuilder.Build(); var contrib = RelationalDbHealthContributor.GetPostgreSqlContributor(config); Assert.NotNull(contrib); var status = contrib.Health(); Assert.Equal(HealthStatus.DOWN, status.Status); }
public void GetOracleContributor_ReturnsContributor() { var appsettings = new Dictionary <string, string>() { ["oracle:client:server"] = "localhost", ["oracle:client:port"] = "1234", ["oracle:client:PersistSecurityInfo"] = "true", ["oracle:client:password"] = "******", ["oracle:client:username"] = "******", ["oracle:client:connectiontimeout"] = "1" }; var configurationBuilder = new ConfigurationBuilder(); configurationBuilder.AddInMemoryCollection(appsettings); var config = configurationBuilder.Build(); var contrib = RelationalDbHealthContributor.GetOracleContributor(config); Assert.NotNull(contrib); var status = contrib.Health(); Assert.Equal(HealthStatus.DOWN, status.Status); }