public SqlServerClientTests()
{
dbConnectionParams = new DbConnectionParams()
{
Database = "Test", Source = "test", Login = "******", Password = "******", Timeout = 1, ConnectRetryCount = 0, ConnectRetryInterval = 1
};
}
public void Create_ConnectionParamsIsNull_ReturnThrow(DbConnectionParams parameter)
{
var client = new SqlServerClient();
Action action = () => client.Create(parameter).Should().BeFalse();
action.Should()
.Throw <System.Exception>()
.WithMessage("Connection failed: Object reference not set to an instance of an object.");
}
public SqlServerStepTests()
{
dbConnectionParams = new DbConnectionParams()
{
Database = "Test", Source = "test", Login = "******", Password = "******", Timeout = 1, ConnectRetryCount = 0, ConnectRetryInterval = 1
};
databaseController = new DatabaseController();
variableController = new VariableController();
step = new SqlServerSteps(databaseController, variableController);
}
public void ConnectToDB_SqlServer_DbParamsIsNull_ReturnThrow()
{
dbConnectionParams = new DbConnectionParams()
{
Database = "", Source = "", Login = "", Password = "", Timeout = 0
};
Action action = () => step.ConnectToDB_SqlServer(dbConnectionString, dbConnectionParams);
action.Should()
.Throw <Xunit.Sdk.XunitException>();
}
public static string CreateMessage(DbConnectionParams connectionParams)
{
var message = string.Empty;
message = $"{Environment.NewLine}Data Source={connectionParams.Source}{Environment.NewLine}" +
$"Initial Catalog={connectionParams.Database}{Environment.NewLine}" +
$"User ID={connectionParams.Login}{Environment.NewLine}" +
$"Password={connectionParams.Password}{Environment.NewLine}" +
$"Connect Timeout={connectionParams.Timeout}{Environment.NewLine}" +
$"Load Balance Timeout={connectionParams.Timeout} failed.{Environment.NewLine}";
return(message);
}
public void ConnectToDB_SqlServer(string connectionName, DbConnectionParams connectionParams)
{
var(isValid, results) = Validate.ValidateModel(connectionParams);
isValid.Should().BeTrue(Message.CreateMessage(results));
databaseController.Connections.Should().NotContainKey(connectionName, $"Connection \"{connectionName}\" already exists");
var connection = new SqlServerClient();
connection.Create(connectionParams).Should().BeTrue();
connection.IsConnectAlive().Should().BeTrue();
databaseController.Connections.TryAdd(connectionName, (connection, connectionParams.Timeout));
}
