public ISqlExecutor CreateSut(ISqlClassProvider sqlClassProvider = null)
{
var optionsMock = Substitute.For <IOptions <SnoozleSqlServerOptions> >();
optionsMock.Value.Returns(new SnoozleSqlServerOptions());
return(new SqlExecutor(optionsMock, sqlClassProvider ?? Substitute.For <ISqlClassProvider>()));
}
public void CreateSqlConnection_NullConnectionStringParameter_ThrowsArgumentNullException()
{
// Arrange
ISqlClassProvider sut = CreateSut();
TestDelegate result = () => sut.CreateSqlConnection(null);
// Act
// Assert
Assert.Throws <ArgumentNullException>(result);
}
public void CreateSqlCommand_NullSqlParameter_ThrowsArgumentNullException()
{
// Arrange
ISqlClassProvider sut = CreateSut();
TestDelegate result = () => sut.CreateSqlCommand(null, Substitute.For <IDatabaseConnection>());
// Act
// Assert
Assert.Throws <ArgumentNullException>(result);
}
public void CreateSqlCommand_NullSqlConnectionParameter_ThrowsArgumentNullException()
{
// Arrange
ISqlClassProvider sut = CreateSut();
string sql = "SELECT * FROM TABLE";
TestDelegate result = () => sut.CreateSqlCommand(sql, null);
// Act
// Assert
Assert.Throws <ArgumentNullException>(result);
}
public void CreateSqlConnection_CorrectParameters_ReturnsIDatabaseConnectionInstance()
{
// Arrange
ISqlClassProvider sut = CreateSut();
string connectionString = string.Empty;
// Act
var result = sut.CreateSqlConnection(connectionString);
// Assert
Assert.IsInstanceOf <IDatabaseConnection>(result);
}
public void CreateSqlCommand_CorrectParameters_ReturnsIDatabaseCommandInstance()
{
// Arrange
ISqlClassProvider sut = CreateSut();
string sql = "SELECT * FROM TABLE";
// Act
var result = sut.CreateSqlCommand(sql, Substitute.For <IDatabaseConnection>());
// Assert
Assert.IsInstanceOf <IDatabaseCommand>(result);
}
public void CreateDatabaseCommandParameter_CreateDatabaseCommandParameter_ReturnsIDatabaseCommandParameterInstance()
{
// Arrange
ISqlClassProvider sut = CreateSut();
string paramName = string.Empty;
object value = null;
SqlDbType sqlDbType = SqlDbType.Int;
bool isNullable = false;
// Act
var result = sut.CreateDatabaseCommandParameter(paramName, value, sqlDbType, isNullable);
// Assert
Assert.IsInstanceOf <IDatabaseCommandParameter>(result);
}
public SqlExecutor(IOptions <SnoozleSqlServerOptions> options, ISqlClassProvider sqlClassProvider)
{
_connectionString = options.Value.ConnectionString;
_sqlClassProvider = sqlClassProvider;
}
public SqlExpressionBuilder(ISqlParamaterProvider sqlParamaterProvider, ISqlClassProvider sqlClassProvider)
{
_sqlParamaterProvider = sqlParamaterProvider;
_sqlClassProvider = sqlClassProvider;
}
