public void TestLoadCustomers(ActionContext context)
{
Assert.AreEqual(true, context.ActiveExecutable.IsExecutionSuccess);
context.DataAccess.OpenConnection(Constants.DbConnectionString);
var rowCount = (int)context.DataAccess.ExecuteScalar(@"select count(*) from [dbo].[CustomersStaging]");
context.DataAccess.CloseConnection();
// here we expect 0 since we use FakeData
Assert.AreEqual(0, rowCount);
Assert.AreEqual(1, context.FakeDestinations.Count);
FakeDestination fakeDestination = context.FakeDestinations[0];
foreach (FakeDestinationSnapshot snapshot in fakeDestination.Snapshots)
{
string data = snapshot.LoadData();
string[] rows = data.Split(new[] { "\r\n" }, StringSplitOptions.RemoveEmptyEntries);
Assert.AreEqual("1;COMPANY1;", rows[0]);
Assert.AreEqual("5;COMPANY2;", rows[1]);
Assert.AreEqual("11;COMPANY3;", rows[2]);
}
}
protected override void Verify(VerificationContext context)
{
Assert.AreEqual(true, context.Package.IsExecutionSuccess);
bool exists =
File.Exists(Constants.CustomersFileDestination);
Assert.AreEqual(true, exists);
DtsVariable variable = context.Package.GetVariableForPath(@"\[CopyCustomers]\[DFT Convert customer names].[CustomerCount]");
var count = (int)variable.GetValue();
Assert.AreEqual(3, count);
Assert.AreEqual(1, context.FakeDestinations.Count);
FakeDestination fakeDestination = context.FakeDestinations[0];
foreach (FakeDestinationSnapshot snapshot in fakeDestination.Snapshots)
{
string data = snapshot.LoadData();
string[] rows = data.Split(new[] { "\r\n" }, StringSplitOptions.RemoveEmptyEntries);
Assert.AreEqual("1;COMPANY1;", rows[0]);
Assert.AreEqual("5;COMPANY2;", rows[1]);
Assert.AreEqual("11;COMPANY3;", rows[2]);
}
}
protected override void Verify(VerificationContext context)
{
context.Package.ThrowExceptionOnError();
Assert.AreEqual(true, context.Package.IsExecutionSuccess);
bool exists =
File.Exists(Constants.CustomersFileDestination);
Assert.AreEqual(true, exists);
DtsVariable customerCountVariable = context.Package.GetVariableForPath(@"\[CopyCustomers3]\[DFT Convert customer names].[CustomerCount]");
var customersCount = (int)customerCountVariable.GetValue();
Assert.AreEqual(4, customersCount);
DtsVariable sourceCustomersErrorCountVariable = context.Package.GetVariableForPath(@"\[CopyCustomers3]\[DFT Convert customer names].[SourceCustomersErrorCount]");
var errorsCount = (int)sourceCustomersErrorCountVariable.GetValue();
Assert.AreEqual(2, errorsCount);
DtsVariable firstCustomerVariable = context.Package.GetVariableForPath(@"\[CopyCustomers3]\[DFT Convert customer names].[FirstCustomer]");
var customerName = (string)firstCustomerVariable.GetValue();
Assert.AreEqual("pg", customerName);
DtsVariable secondCustomerVariable = context.Package.GetVariableForPath(@"\[CopyCustomers3]\[DFT Convert customer names].[SecondCustomer]");
customerName = (string)secondCustomerVariable.GetValue();
Assert.AreEqual("irg", customerName);
ReadOnlyCollection <DataTap> dataTaps = context.DataTaps;
Assert.AreEqual(7, dataTaps.Count);
CheckDataTap1(dataTaps);
CheckDataTap2(dataTaps);
CheckDataTap3(dataTaps);
CheckDataTap4(dataTaps);
CheckDataTap5(dataTaps);
CheckDataTap6(dataTaps);
CheckDataTap7(dataTaps);
Assert.AreEqual(1, context.FakeDestinations.Count);
FakeDestination fakeDestination = context.FakeDestinations[0];
foreach (FakeDestinationSnapshot snapshot in fakeDestination.Snapshots)
{
string data = snapshot.LoadData();
string[] rows = data.Split(new[] { "\r\n" }, StringSplitOptions.RemoveEmptyEntries);
Assert.AreEqual("911;LG;", rows[0]);
Assert.AreEqual("1908;PG;", rows[1]);
Assert.AreEqual("1924;PIL;", rows[2]);
Assert.AreEqual("2401;IRG;", rows[3]);
}
}
protected override void Verify(VerificationContext context)
{
context.Package.ThrowExceptionOnError();
Assert.AreEqual(true, context.Package.IsExecutionSuccess);
bool exists =
File.Exists(Constants.CustomersFileDestination);
Assert.AreEqual(true, exists);
DtsVariable customerCountVariable = context.Package.GetVariableForPath(@"\[CopyCustomers4]\[DFT Convert customer names].[CustomerCount]");
var customersCount = (int)customerCountVariable.GetValue();
Assert.AreEqual(13, customersCount);
DtsVariable sourceCustomersErrorCountVariable = context.Package.GetVariableForPath(@"\[CopyCustomers4]\[DFT Convert customer names].[SourceCustomersErrorCount]");
var errorsCount = (int)sourceCustomersErrorCountVariable.GetValue();
Assert.AreEqual(0, errorsCount);
ReadOnlyCollection <DataTap> dataTaps = context.DataTaps;
Assert.AreEqual(1, dataTaps.Count);
CheckDataTap1(dataTaps);
Assert.AreEqual(1, context.FakeDestinations.Count);
FakeDestination fakeDestination = context.FakeDestinations[0];
foreach (FakeDestinationSnapshot snapshot in fakeDestination.Snapshots)
{
string data = snapshot.LoadData();
string[] rows = data.Split(new[] { "\r\n" }, StringSplitOptions.RemoveEmptyEntries);
int i = 0;
Assert.AreEqual("1;Company1;table;1;".ToUpper(), rows[i]);
Assert.AreEqual("1;Company1;chair;4;".ToUpper(), rows[++i]);
Assert.AreEqual("1;Company1;glass;5;".ToUpper(), rows[++i]);
Assert.AreEqual("2;furniture co;;;".ToUpper(), rows[++i]);
Assert.AreEqual("5;Company2;car;2;".ToUpper(), rows[++i]);
Assert.AreEqual("5;Company2;motor;6;".ToUpper(), rows[++i]);
Assert.AreEqual("5;Company2;radio;9;".ToUpper(), rows[++i]);
Assert.AreEqual("5;Company2;navi;10;".ToUpper(), rows[++i]);
Assert.AreEqual("7;used cars;;;".ToUpper(), rows[++i]);
Assert.AreEqual("11;Company3;laptop;3;".ToUpper(), rows[++i]);
Assert.AreEqual("11;Company3;monitor;7;".ToUpper(), rows[++i]);
Assert.AreEqual("11;Company3;mouse;8;".ToUpper(), rows[++i]);
Assert.AreEqual("18;computers;;;".ToUpper(), rows[++i]);
}
}
protected override void Verify(VerificationContext context)
{
Assert.AreEqual(true, context.Package.IsExecutionSuccess);
bool exists =
File.Exists(Constants.CustomersFileDestination);
Assert.AreEqual(true, exists);
DtsVariable variable = context.Package.GetVariableForPath(@"\[CopyCustomers]\[DFT Convert customer names].[CustomerCount]");
var count = (int)variable.GetValue();
Assert.AreEqual(3, count);
ReadOnlyCollection <DataTap> dataTaps = context.DataTaps;
DataTap dataTap = dataTaps[0];
foreach (DataTapSnapshot snapshot in dataTap.Snapshots)
{
string data = snapshot.LoadData();
Assert.IsFalse(string.IsNullOrEmpty(data));
string[] rows = data.Split(new[] { "\r\n" }, StringSplitOptions.RemoveEmptyEntries);
Assert.AreEqual("1908;PG;", rows[0]);
Assert.AreEqual("2401;IRG;", rows[1]);
Assert.AreEqual("911;LG;", rows[2]);
}
DtsVariable sourceCustomersErrorCount = context.Package.GetVariableForPath(@"\[CopyCustomers]\[DFT Convert customer names].[SourceCustomersErrorCount]");
var val = (int)sourceCustomersErrorCount.GetValue();
Assert.AreEqual(2, val);
Assert.AreEqual(1, context.FakeDestinations.Count);
FakeDestination fakeDestination = context.FakeDestinations[0];
foreach (FakeDestinationSnapshot snapshot in fakeDestination.Snapshots)
{
string data = snapshot.LoadData();
string[] rows = data.Split(new[] { "\r\n" }, StringSplitOptions.RemoveEmptyEntries);
Assert.AreEqual("1908;PG;", rows[0]);
Assert.AreEqual("2401;IRG;", rows[1]);
Assert.AreEqual("911;LG;", rows[2]);
}
}
protected override void Verify(VerificationContext context)
{
Assert.AreEqual(true, context.Package.IsExecutionSuccess);
Assert.AreEqual(1, context.FakeDestinations.Count);
FakeDestination fakeDestination = context.FakeDestinations[0];
foreach (FakeDestinationSnapshot snapshot in fakeDestination.Snapshots)
{
string data = snapshot.LoadData();
string[] rows = data.Split(new[] { "\r\n" }, StringSplitOptions.RemoveEmptyEntries);
Assert.AreEqual("1;Company1;", rows[0]);
Assert.AreEqual("5;Company2;", rows[1]);
Assert.AreEqual("11;Company3;", rows[2]);
}
// enable this part, if SendRowsToErrorOutput = true
//DtsVariable variable = context.Package.GetVariable("ErrorCustomersCount");
//Assert.AreEqual(4, (int)variable.GetValue());
}
