public void Configure_Without_ServiceInfo_Returns_Config()
{
var configurer = new SqlServerProviderConfigurer();
var opts = configurer.Configure(null, config);
Assert.Contains("Data Source=localhost,1433", opts);
Assert.Contains("User Id=username;", opts);
Assert.Contains("Password=password;", opts);
Assert.Contains("Initial Catalog=database;", opts);
}
public void Update_With_ServiceInfo_CredsInUrl_Updates_Config()
{
var configurer = new SqlServerProviderConfigurer();
var si = new SqlServerServiceInfo("MyId", "sqlserver://*****:*****@updatedserver:1433;databaseName=updateddb");
configurer.UpdateConfiguration(si, config);
Assert.Equal("updatedserver", config.Server);
Assert.Equal("updateddb", config.Database);
Assert.Equal("updateduser", config.Username);
Assert.Equal("updatedpassword", config.Password);
}
public void UpdateConfiguration_WithNullSqlServerServiceInfo_ReturnsExpected()
{
var configurer = new SqlServerProviderConfigurer();
configurer.UpdateConfiguration(null, config);
Assert.Equal("localhost", config.Server);
Assert.Equal("username", config.Username);
Assert.Equal("password", config.Password);
Assert.Equal("database", config.Database);
Assert.Null(config.ConnectionString);
}
public void Update_With_ServiceInfo_Updates_Config()
{
SqlServerProviderConfigurer configurer = new SqlServerProviderConfigurer();
SqlServerServiceInfo si = new SqlServerServiceInfo("MyId", "jdbc:sqlserver://updatedserver:1433/databaseName=updateddb", "updateduser", "updatedpassword");
configurer.UpdateConfiguration(si, config);
Assert.Equal("updatedserver", config.Server);
Assert.Equal("updateddb", config.Database);
Assert.Equal("updateduser", config.Username);
Assert.Equal("updatedpassword", config.Password);
}
public void Configure_With_ServiceInfo_NamedInstance_Overrides_Config()
{
var configurer = new SqlServerProviderConfigurer();
// override provided by environment
var si = new SqlServerServiceInfo("MyId", "jdbc:sqlserver://servername/databaseName=de5aa3a747c134b3d8780f8cc80be519e;instanceName=someInstance;integratedSecurity=true");
// apply override
var opts = configurer.Configure(si, config);
// resulting options should contain values parsed from environment
Assert.Contains("Data Source=servername\\someInstance", opts);
Assert.Contains("Initial Catalog=de5aa3a747c134b3d8780f8cc80be519e;", opts);
Assert.Contains("integratedSecurity=true;", opts);
}
public void Configure_With_ServiceInfo_CredsInUrl_Overrides_Config()
{
var configurer = new SqlServerProviderConfigurer();
// override provided by environment
var si = new SqlServerServiceInfo("MyId", "jdbc:sqlserver://*****:*****@servername:1433/databaseName=de5aa3a747c134b3d8780f8cc80be519e");
// apply override
var opts = configurer.Configure(si, config);
// resulting options should contain values parsed from environment
Assert.Contains("Data Source=servername,1433", opts);
Assert.Contains("Initial Catalog=de5aa3a747c134b3d8780f8cc80be519e;", opts);
Assert.Contains("User Id=Dd6O1BPXUHdrmzbP;", opts);
Assert.Contains("Password=7E1LxXnlH2hhlPVt;", opts);
}