public void MatchingFieldsTest()
{
var dtMaster = TestHelper.BobTableV1();
var dtReplica = dtMaster.Copy();
var dtc = new DataTableComparer(dtMaster,dtReplica);
var result = dtc.CompareSchema().Value;
Assert.IsTrue(result.IsCompatible);
Assert.IsFalse(result.HasDiffs);
}
public void ExtraFieldsTest()
{
var dtMaster = TestHelper.BobTableV1();
var dtReplica =TestHelper.BobTableAddField();
var dtc = new DataTableComparer(dtMaster, dtReplica);
var result = dtc.CompareSchema().Value;
Assert.IsTrue(result.IsCompatible);
Assert.IsTrue(result.HasDiffs);
Assert.AreEqual(DiffType.Extra, result.ColumnDiffs[0].DiffType);
Assert.AreEqual("field5", result.ColumnDiffs[0].Column.ColumnName);
}
public void FieldTypeChangeTest()
{
var dtMaster = TestHelper.BobTableV1();
var dtReplica = TestHelper.BobTableChangeDT();
var dtc = new DataTableComparer(dtMaster, dtReplica);
var result = dtc.CompareSchema().Value;
Assert.IsFalse(result.IsCompatible);
Assert.IsTrue(result.HasDiffs);
Assert.AreEqual(1, result.ColumnDiffs.Count());
Assert.AreEqual(DiffType.TypeMismatch, result.ColumnDiffs[0].DiffType);
Assert.AreEqual("field1", result.ColumnDiffs[0].Column.ColumnName);
}
public void MissingFieldsTest()
{
var dtMaster = TestHelper.BobTableV1();
var dtReplica =TestHelper.BobTableRemoveField();
var dtc = new DataTableComparer(dtMaster, dtReplica);
var result = dtc.CompareSchema().Value;
Assert.IsFalse(result.IsCompatible);
Assert.IsTrue(result.HasDiffs);
Assert.AreEqual(1, result.ColumnDiffs.Count());
Assert.AreEqual(DiffType.Missing, result.ColumnDiffs[0].DiffType);
Assert.AreEqual("field3", result.ColumnDiffs[0].Column.ColumnName);
}
public void FieldAddAndRemoveTest()
{
var dtMaster = TestHelper.BobTableV1();
var dtReplica = TestHelper.BobTableAddAndRemove();
var dtc = new DataTableComparer(dtMaster, dtReplica); ;
var result = dtc.CompareSchema().Value;
Assert.IsFalse(result.IsCompatible);
Assert.IsTrue(result.HasDiffs);
Assert.AreEqual(2, result.ColumnDiffs.Count());
var extraCol = result.ColumnDiffs.First(cd => cd.DiffType == DiffType.Extra).Column;
var missingCol = result.ColumnDiffs.First(cd => cd.DiffType == DiffType.Missing).Column;
Assert.AreEqual("field3", missingCol.ColumnName);
Assert.AreEqual("field5",extraCol.ColumnName);
}