public void TestRemoveLogTablesTask() { RemoveLogTablesTask.Remove(); CreateLogTablesTask.CreateLog(); RemoveLogTablesTask.Remove(); Assert.IsTrue(SqlTask.ExecuteScalarAsBool("Check if tables are deleted", "select case when object_id('etl.LoadProcess') is null then 1 else 0 end")); Assert.IsTrue(SqlTask.ExecuteScalarAsBool("Check if tables are deleted", "select case when object_id('etl.Log') is null then 1 else 0 end")); }
public void TestLogging() { RemoveLogTablesTask.Remove(); CreateLogTablesTask.CreateLog(); SqlTask.ExecuteNonQuery("Test select", $"select 1 as test"); Assert.AreEqual(2, new SqlTask("Find log entry", "select count(*) from etl.Log where TaskType='SQL' group by TaskHash") { DisableLogging = true }.ExecuteScalar <int>()); }
public void RemoveLogTables() { //Arrange RemoveLogTablesTask.Remove(Connection); CreateLogTablesTask.CreateLog(Connection); //Act RemoveLogTablesTask.Remove(Connection); //Assert Assert.True(SqlTask.ExecuteScalarAsBool(Connection, "Check if tables are deleted", "SELECT CASE WHEN object_id('etl.LoadProcess') IS NULL THEN 1 ELSE 0 END")); Assert.True(SqlTask.ExecuteScalarAsBool(Connection, "Check if tables are deleted", "SELECT CASE WHEN object_id('etl.Log') IS NULL THEN 1 ELSE 0 END")); }
public void Dispose() { RemoveLogTablesTask.Remove(Connection); ControlFlow.ClearSettings(); DataFlow.ClearSettings(); }
public void Dispose() { RemoveLogTablesTask.Remove(Connection); }