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