public static void TestInit(TestContext testContext) { ControlFlow.ClearSettings(); TestHelper.RecreateDatabase(testContext); ControlFlow.CurrentDbConnection = new SqlConnectionManager(new ConnectionString(testContext.Properties["connectionString"].ToString())); CreateLogTablesTask.CreateLog(); }
public static void TestInit(TestContext testContext) { TestHelper.RecreateDatabase(testContext); ControlFlow.CurrentDbConnection = new SqlConnectionManager(new ConnectionString(testContext.Properties["connectionString"].ToString())); CreateSchemaTask.Create("test"); SqlTask.ExecuteNonQuery("Create test table", $@"create table test.Table1 ( key1 int null, key2 int not null)"); SqlTask.ExecuteNonQuery("Create test table", $@"create table test.Table2 ( key1 int null, key2 int not null, value1 datetime null, value2 varchar(100) not null )"); }
public static void TestInit(TestContext testContext) { TestHelper.RecreateDatabase(testContext); ControlFlow.CurrentDbConnection = new SqlConnectionManager(new ConnectionString(testContext.Properties["connectionString"].ToString())); CreateSchemaTask.Create("test"); SqlTask.ExecuteNonQuery("Create test data table", $@" create table test.RC ( value int null ) insert into test.RC select * from (values (1), (2), (3)) AS MyTable(v)"); }
public void TestLogging() { TestHelper.RecreateDatabase(TestContext); CreateLogTablesTask.CreateLog(); ProcessCubeTask.Process("Process cube test"); Assert.AreEqual(2, new SqlTask("Find log entry", "select count(*) from etl.Log where TaskType='PROCESSCUBE' group by TaskHash") { DisableLogging = true }.ExecuteScalar <int>()); }
public static void ClassInit(TestContext testContext) { TestHelper.RecreateDatabase(testContext); TestHelper.RecreateDatabase(testContext.Properties["dbNameDest"].ToString(), testContext.Properties["connectionStringDest"].ToString()); TestHelper.RecreateDatabase(testContext.Properties["dbNameLog"].ToString(), testContext.Properties["connectionStringLog"].ToString()); new CreateSchemaTask("test") { ConnectionManager = new SqlConnectionManager(new ConnectionString(testContext.Properties["connectionString"].ToString())) }.Execute(); new CreateSchemaTask("test") { ConnectionManager = new SqlConnectionManager(new ConnectionString(testContext.Properties["connectionStringDest"].ToString())) }.Execute(); }
public void BeforeTests() { TestHelper.RecreateDatabase(TestContext); CreateLogTablesTask.CreateLog(); Assert.IsFalse(new SqlTask("Check if logging was disabled for table creation", "select count(*) from etl.Log") { DisableLogging = true }.ExecuteScalarAsBool()); Assert.IsTrue(new SqlTask("Check etl.Log table", $"select count(*) from sys.tables where type = 'U' and name = 'Log' and schema_id('etl') = schema_id") { DisableLogging = true }.ExecuteScalarAsBool()); Assert.IsTrue(new SqlTask("Check etl.LoadProcess table", $"select count(*) from sys.tables where type = 'U' and name = 'LoadProcess' and schema_id('etl') = schema_id") { DisableLogging = true }.ExecuteScalarAsBool()); }
public void BeforeTests() { TestHelper.RecreateDatabase(TestContext); CreateLogTablesTask.CreateLog(); Assert.IsTrue(new SqlTask("Check proc StartLoadProcess", $"select count(*) from sys.procedures where type = 'P' and name = 'StartLoadProcess' and schema_id = schema_id('etl')") { DisableLogging = true }.ExecuteScalarAsBool()); Assert.IsTrue(new SqlTask("Check proc EndLoadProcess", $"select count(*) from sys.procedures where type = 'P' and name = 'EndLoadProcess' and schema_id = schema_id('etl')") { DisableLogging = true }.ExecuteScalarAsBool()); Assert.IsTrue(new SqlTask("Check proc AbortLoadProcess", $"select count(*) from sys.procedures where type = 'P' and name = 'AbortLoadProcess' and schema_id = schema_id('etl')") { DisableLogging = true }.ExecuteScalarAsBool()); }
public static void ClassInit(TestContext testContext) { TestHelper.RecreateDatabase(testContext); ControlFlow.CurrentDbConnection = new SqlConnectionManager(new ConnectionString(testContext.Properties["connectionString"].ToString())); CreateSchemaTask.Create("test"); }
public static void TestInit(TestContext testContext) { TestHelper.RecreateDatabase(testContext); }