public void RunDataCompareCommandSetTest() { var ts = new SsisTestSuite(); var connRef = new ConnectionRef("TestConn", "Data Source=localhost;Initial Catalog=ssisUnitTestDb;Integrated Security=SSPI", ConnectionRef.ConnectionTypeEnum.AdoNet, "System.Data.SqlClient"); ts.ConnectionList.Add(connRef.ReferenceName, connRef); var dataset = new Dataset( ts, "Test", connRef, false, @"SELECT CAST(1 AS INT) AS ColInt, CAST('Test' AS VARCHAR(50)) AS ColVarChar, CAST(N'Test' AS NVARCHAR(50)) AS ColNVarChar, CAST('1900-01-01' AS DATETIME) AS ColDateTime"); var target = new DataCompareCommand(ts, "Test", dataset, dataset); var actual = (DataCompareCommandResults)target.Execute(); Assert.AreEqual(true, actual.IsDatasetsSame); }
public void RunDataCompareCommandSetWithOtherTestTest() { var ts = new SsisTestSuite(); var connRef = new ConnectionRef("TestConn", "Data Source=localhost;Initial Catalog=AdventureWorks2012;Integrated Security=SSPI", ConnectionRef.ConnectionTypeEnum.AdoNet, "System.Data.SqlClient"); var pkgRef = new PackageRef("pkg", _dtsxFilePath, PackageStorageType.FileSystem); ts.ConnectionList.Add(connRef.ReferenceName, connRef); ts.PackageList.Add(pkgRef.Name, pkgRef); var dataset = new Dataset( ts, "Test", connRef, false, @"SELECT CAST(1 AS INT) AS ColInt, CAST('Test' AS VARCHAR(50)) AS ColVarChar, CAST(N'Test' AS NVARCHAR(50)) AS ColNVarChar, CAST('1900-01-01' AS DATETIME) AS ColDateTime"); ts.Datasets.Add(dataset.Name, dataset); var target = new DataCompareCommand(ts, "Test", dataset, dataset); var test = new Test(ts, "TestCase1", "pkg", null, "\\Package"); var assert = new SsisAssert(ts, test, "Assert1", true, false); assert.Command = target; test.Asserts.Add("Assert1", assert); ts.Tests.Add("TestCase1", test); var test2 = new Test(ts, "TestCase2", "pkg", null, "\\Package"); var assert2 = new SsisAssert(ts, test2, "Assert2", false, false); assert2.Command = new FileCommand(ts, "Exists", @"C:\Test\Test.pkg", string.Empty); test2.Asserts.Add("Assert2", assert2); ts.Tests.Add("TestCase2", test2); var actual = ts.Execute(); Assert.AreEqual(4, ts.Statistics.GetStatistic(StatisticEnum.AssertPassedCount)); }
public void DataCompareCommandConstructorTest() { var target = new DataCompareCommand(new SsisTestSuite()); Assert.IsNotNull(target); }