public void DropProcedure()
{
//Arrange
CreateProcedureTask.CreateOrAlter(SqlConnection, "DropProc1", "SELECT 1");
Assert.True(IfExistsTask.IsExisting(SqlConnection, "DropProc1"));
//Act
DropProcedureTask.Drop(SqlConnection, "DropProc1");
//Assert
Assert.False(IfExistsTask.IsExisting(SqlConnection, "DropProc1"));
}
public void Drop(IConnectionManager connection)
{
//Arrange
CreateProcedureTask.CreateOrAlter(connection, "DropProc1", "SELECT 1;");
Assert.True(IfProcedureExistsTask.IsExisting(connection, "DropProc1"));
//Act
DropProcedureTask.Drop(connection, "DropProc1");
//Assert
Assert.False(IfProcedureExistsTask.IsExisting(connection, "DropProc1"));
}
public void NotSupportedWithSQLite()
{
Assert.Throws <ETLBoxNotSupportedException>(
() => DropProcedureTask.Drop(SQLiteConnection, "Test")
);
}
public void NotSupportedWithSQLite()
{
Assert.Throws <ETLBoxNotSupportedException>(
() => DropProcedureTask.Drop(Config.SQLiteConnection.ConnectionManager("ControlFlow"), "Test")
);
}
