public void CheckDropSchemaTask()
{
//Arrange
//Act & Assert
Assert.Throws <ETLBoxException>(() =>
{
DropSchemaTask.DropIfExists("test");
});
}
public void Drop(IConnectionManager connection)
{
if (connection.GetType() != typeof(MySqlConnectionManager))
{
//Arrange
CreateSchemaTask.Create(connection, "testcreateschema");
Assert.True(IfSchemaExistsTask.IsExisting(connection, "testcreateschema"));
//Act
DropSchemaTask.Drop(connection, "testcreateschema");
//Assert
Assert.False(IfSchemaExistsTask.IsExisting(connection, "testcreateschema"));
}
}
public void DropIfExists(IConnectionManager connection)
{
if (connection.GetType() == typeof(MySqlConnectionManager) ||
connection.GetType() == typeof(MariaDbConnectionManager) ||
connection.GetType() == typeof(OracleConnectionManager)
)
{
return;
}
//Arrange
DropSchemaTask.DropIfExists(connection, "testcreateschema2");
CreateSchemaTask.Create(connection, "testcreateschema2");
Assert.True(IfSchemaExistsTask.IsExisting(connection, "testcreateschema2"));
//Act
DropSchemaTask.DropIfExists(connection, "testcreateschema2");
//Assert
Assert.False(IfSchemaExistsTask.IsExisting(connection, "testcreateschema2"));
}
public void NotSupportedWithOracle()
{
Assert.Throws <ETLBoxNotSupportedException>(
() => DropSchemaTask.Drop(Config.OracleConnection.ConnectionManager("ControlFlow"), "Test")
);
}