private static void CheckDataTap1(IEnumerable <DataTap> dataTaps)
{
DataTap dataTap =
dataTaps.Single(
tap =>
tap.PathToSourceComponent ==
@"\[CopyCustomers2]\[DFT Convert customer names]\[RCNT Count customers]"
&&
tap.PathToDestinationComponent ==
@"\[CopyCustomers2]\[DFT Convert customer names]\[DER Convert names to upper string]");
Assert.AreEqual(dataTap.Snapshots.Count, dataTap.SnapshotCount);
Assert.AreEqual(1, dataTap.SnapshotCount);
foreach (DataTapSnapshot snapshot in dataTap.Snapshots)
{
string data = snapshot.LoadData();
Assert.IsFalse(string.IsNullOrEmpty(data));
Assert.AreEqual(6, snapshot.RowCount);
string[] rows = data.Split(new[] { "\r\n" }, StringSplitOptions.RemoveEmptyEntries);
Assert.AreEqual("1;Company A;", rows[0]);
Assert.AreEqual("3;Company B;", rows[1]);
Assert.AreEqual("5;Company C;", rows[2]);
Assert.AreEqual("2;Company D;", rows[3]);
Assert.AreEqual("4;Company E;", rows[4]);
Assert.AreEqual("6;Company F;", rows[5]);
}
}
private static void CheckDataTap4(IEnumerable <DataTap> dataTaps)
{
DataTap dataTap = dataTaps.Single(
tap =>
tap.PathToSourceComponent ==
@"\[CopyCustomers3]\[DFT Convert customer names]\[MLT Customers]"
&&
tap.PathToDestinationComponent ==
@"\[CopyCustomers3]\[DFT Convert customer names]\[ALL Dummy]");
Assert.AreEqual(dataTap.Snapshots.Count, dataTap.SnapshotCount);
Assert.AreEqual(1, dataTap.SnapshotCount);
foreach (DataTapSnapshot snapshot in dataTap.Snapshots)
{
string data = snapshot.LoadData();
Assert.IsFalse(string.IsNullOrEmpty(data));
Assert.AreEqual(4, snapshot.RowCount);
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]);
}
}
private static void CheckDataTap3(IEnumerable <DataTap> dataTaps)
{
DataTap dataTap = dataTaps.Single(
tap =>
tap.PathToSourceComponent ==
@"\[CopyCustomers3]\[DFT Convert customer names]\[FFS Customers]"
&&
tap.PathToDestinationComponent ==
@"\[CopyCustomers3]\[DFT Convert customer names]\[RCNT Count error customers]");
Assert.AreEqual(dataTap.Snapshots.Count, dataTap.SnapshotCount);
Assert.AreEqual(1, dataTap.SnapshotCount);
foreach (DataTapSnapshot snapshot in dataTap.Snapshots)
{
string data = snapshot.LoadData();
Assert.IsFalse(string.IsNullOrEmpty(data));
Assert.AreEqual(2, snapshot.RowCount);
string[] rows = data.Split(new[] { "\r\n" }, StringSplitOptions.RemoveEmptyEntries);
StringAssert.Contains(rows[0], "1908;1;");
StringAssert.Contains(rows[1], "2401;2;");
}
}
private void CheckDataTaps(ActionContext context)
{
ReadOnlyCollection <DataTap> dataTaps = context.DataTaps;
if (dataTaps == null)
{
return;
}
DataTap dataTap =
dataTaps.Single(
tap =>
tap.PathToSourceComponent ==
@"\[CopyCustomers]\[DFT Convert customer names]\[RCNT Count customers]"
&&
tap.PathToDestinationComponent ==
@"\[CopyCustomers]\[DFT Convert customer names]\[DER Convert names to upper string]");
foreach (DataTapSnapshot snapshot in dataTap.Snapshots)
{
string data = snapshot.LoadData();
Assert.AreEqual(3, snapshot.RowCount);
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]);
}
dataTap =
dataTaps.Single(
tap =>
tap.PathToSourceComponent ==
@"\[CopyCustomers]\[DFT Convert customer names]\[DER Convert names to upper string]"
&&
tap.PathToDestinationComponent ==
@"\[CopyCustomers]\[DFT Convert customer names]\[FFD Customers converted]");
foreach (DataTapSnapshot snapshot in dataTap.Snapshots)
{
string data = snapshot.LoadData();
Assert.AreEqual(3, snapshot.RowCount);
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);
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]);
}
}
private void CheckDataTaps(ActionContext context)
{
ReadOnlyCollection <DataTap> dataTaps = context.DataTaps;
if (dataTaps == null)
{
return;
}
if (dataTaps.Count > 0)
{
DataTap dataTap = dataTaps[0];
foreach (DataTapSnapshot snapshot in dataTap.Snapshots)
{
string data = snapshot.LoadData();
}
}
}
private static void CheckDataTap1(IEnumerable <DataTap> dataTaps)
{
DataTap dataTap =
dataTaps.Single(
tap =>
tap.PathToSourceComponent ==
@"\[CopyCustomers4]\[DFT Convert customer names]\[MRGJ Customers Products]"
&&
tap.PathToDestinationComponent ==
@"\[CopyCustomers4]\[DFT Convert customer names]\[RCNT Count Customers]");
Assert.AreEqual(dataTap.Snapshots.Count, dataTap.SnapshotCount);
Assert.AreEqual(1, dataTap.SnapshotCount);
foreach (DataTapSnapshot snapshot in dataTap.Snapshots)
{
string data = snapshot.LoadData();
Assert.IsFalse(string.IsNullOrEmpty(data));
Assert.AreEqual(13, snapshot.RowCount);
string[] rows = data.Split(new[] { "\r\n" }, StringSplitOptions.RemoveEmptyEntries);
int i = 0;
Assert.AreEqual("1;Company1;table;1;", rows[i]);
Assert.AreEqual("1;Company1;chair;4;", rows[++i]);
Assert.AreEqual("1;Company1;glass;5;", rows[++i]);
Assert.AreEqual("2;furniture co;;;", rows[++i]);
Assert.AreEqual("5;Company2;car;2;", rows[++i]);
Assert.AreEqual("5;Company2;motor;6;", rows[++i]);
Assert.AreEqual("5;Company2;radio;9;", rows[++i]);
Assert.AreEqual("5;Company2;navi;10;", rows[++i]);
Assert.AreEqual("7;used cars;;;", rows[++i]);
Assert.AreEqual("11;Company3;laptop;3;", rows[++i]);
Assert.AreEqual("11;Company3;monitor;7;", rows[++i]);
Assert.AreEqual("11;Company3;mouse;8;", rows[++i]);
Assert.AreEqual("18;computers;;;", rows[++i]);
}
}
protected override void Verify(VerificationContext context)
{
Assert.AreEqual(true, context.Package.IsExecutionSuccess);
bool exists =
File.Exists(Constants.CustomersFileDestination);
Assert.AreEqual(true, exists);
exists =
File.Exists(Constants.CustomersFileConverted);
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));
}
DataTap dataTap1 = dataTaps[1];
foreach (DataTapSnapshot snapshot in dataTap1.Snapshots)
{
string data = snapshot.LoadData();
Assert.IsFalse(string.IsNullOrEmpty(data));
}
}
