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") ); }