public LookupViolationInformation Register(NBiRs.KeyCollection key, LookupMatchesViolationComposite composite)
{
if (ContainsKey(key))
{
var info = this[key] as LookupMatchesViolationInformation;
if (info.State != RowViolationState.Mismatch)
{
throw new ArgumentException("Can't change the state of lookup violation");
}
info.CandidateRows.Add(composite);
return(info);
}
else
{
var info = new LookupMatchesViolationInformation(RowViolationState.Mismatch);
info.CandidateRows.Add(composite);
Add(key, info);
return(info);
}
}
public void RenderMessage_FullSamples_Correct()
{
var referenceTable = new DataTable()
{
TableName = "MyTable"
};
referenceTable.Columns.Add(new DataColumn("ForeignKey"));
referenceTable.Columns.Add(new DataColumn("Numeric value"));
referenceTable.LoadDataRow(new object[] { "Alpha", 15 }, false);
referenceTable.LoadDataRow(new object[] { "Beta", 20 }, false);
referenceTable.LoadDataRow(new object[] { "Delta", 30 }, false);
var candidateTable = new DataTable()
{
TableName = "MyTable"
};
candidateTable.Columns.Add(new DataColumn("ForeignKey"));
candidateTable.Columns.Add(new DataColumn("Numeric value"));
candidateTable.Columns.Add(new DataColumn("Boolean value"));
candidateTable.LoadDataRow(new object[] { "Alpha", 10, true }, false);
candidateTable.LoadDataRow(new object[] { "Beta", 20, false }, false);
var foreignKeyDefinition = new ColumnMetadata()
{
Identifier = new ColumnIdentifierFactory().Instantiate("ForeignKey"), Role = ColumnRole.Key
};
var numericDefinition = new ColumnMetadata()
{
Identifier = new ColumnIdentifierFactory().Instantiate("Numeric value"), Role = ColumnRole.Value
};
var keyMappings = new ColumnMappingCollection()
{
new ColumnMapping(foreignKeyDefinition.Identifier, ColumnType.Text)
};
var valueMappings = new ColumnMappingCollection()
{
new ColumnMapping(numericDefinition.Identifier, ColumnType.Numeric)
};
var information = new LookupMatchesViolationInformation(RowViolationState.Mismatch);
information.AddCandidateRow(candidateTable.Rows[0]);
information.CandidateRows.ElementAt(0).Records.Add(new LookupMatchesViolationRecord()
{
{ candidateTable.Columns[1], new LookupMatchesViolationData(false, 15) },
});
var violations = new LookupMatchesViolationCollection(keyMappings, valueMappings)
{
{ new KeyCollection(new[] { "Alpha" }), information }
};
var samplers = new Dictionary <string, ISampler <DataRow> >()
{
{ "candidate", new FullSampler <DataRow>() },
{ "reference", new FullSampler <DataRow>() },
{ "analysis", new FullSampler <DataRow>() },
};
var message = new LookupMatchesViolationMessageJson(samplers);
message.Generate(referenceTable.Rows.Cast <DataRow>(), candidateTable.Rows.Cast <DataRow>(), violations, keyMappings, valueMappings);
var text = message.RenderMessage();
Console.WriteLine(text);
Assert.That(text, Does.Contain("\"expected\":{\"total-rows\":3,\"table\""));
Assert.That(text, Does.Contain("\"actual\":{\"total-rows\":2,\"table\""));
Assert.That(text, Does.Contain("\"analysis\":{\"non-matching\":{\"total-rows\":1,"));
Assert.That(text, Does.Contain(",{\"value\":\"10\",\"expectation\":\"15\"},"));
}
