How to use LookupExistsViolationCollection class of NBi.Core.ResultSet.Lookup.Violation package

Best NBi code snippet using NBi.Core.ResultSet.Lookup.Violation.LookupExistsViolationCollection

LookupReverseExistsViolationMessageJsonTest.cs

Source:LookupReverseExistsViolationMessageJsonTest.cs

...51            var foreignKeyDefinition = new ColumnMetadata() { Identifier = new ColumnIdentifierFactory().Instantiate("ForeignKey"), Role = ColumnRole.Key };52            var numericDefinition = new ColumnMetadata() { Identifier = new ColumnIdentifierFactory().Instantiate("Numeric value"), Role = ColumnRole.Value };53            var keyMappings = new ColumnMappingCollection() { new ColumnMapping(foreignKeyDefinition.Identifier, ColumnType.Text) };54            var valueMappings = new ColumnMappingCollection() { new ColumnMapping(numericDefinition.Identifier, ColumnType.Numeric) };55            var violations = new LookupExistsViolationCollection(keyMappings);56            violations.Register(new KeyCollection(new[] { "Gamma" }), candidateTable.Rows[1]);57            var samplers = new Dictionary<string, ISampler<DataRow>>()58            {59                { "candidate", new FullSampler<DataRow>() },60                { "reference", new FullSampler<DataRow>() },61                { "analysis", new FullSampler<DataRow>() },62            };63            var message = new LookupReverseExistsViolationMessageJson(samplers);64            message.Generate(referenceTable.Rows.Cast<DataRow>(), candidateTable.Rows.Cast<DataRow>(), violations, keyMappings, valueMappings);65            var text = message.RenderMessage();66            Assert.That(text, Does.Contain("\"expected\":{\"total-rows\":4,\"table\""));67            Assert.That(text, Does.Contain("\"actual\":{\"total-rows\":2,\"table\""));68            Assert.That(text, Does.Contain("\"analysis\":{\"missing\":{\"total-rows\":1,"));69            Assert.That(text, Does.Contain("[[\"Gamma\",\"20\",\"False\"]]"));70        }71        [Test]72        public void RenderMessage_NoneSamples_Correct()73        {74            var referenceTable = new DataTable() { TableName = "MyTable" };75            referenceTable.Columns.Add(new DataColumn("ForeignKey"));76            referenceTable.Columns.Add(new DataColumn("Numeric value"));77            referenceTable.LoadDataRow(new object[] { "Alpha", 15 }, false);78            referenceTable.LoadDataRow(new object[] { "Beta", 20 }, false);79            referenceTable.LoadDataRow(new object[] { "Delta", 30 }, false);80            referenceTable.LoadDataRow(new object[] { "Epsilon", 40 }, false);81            var candidateTable = new DataTable() { TableName = "MyTable" };82            candidateTable.Columns.Add(new DataColumn("ForeignKey"));83            candidateTable.Columns.Add(new DataColumn("Numeric value"));84            candidateTable.Columns.Add(new DataColumn("Boolean value"));85            candidateTable.LoadDataRow(new object[] { "Alpha", 10, true }, false);86            candidateTable.LoadDataRow(new object[] { "Gamma", 20, false }, false);87            var foreignKeyDefinition = new ColumnMetadata() { Identifier = new ColumnIdentifierFactory().Instantiate("ForeignKey"), Role = ColumnRole.Key };88            var numericDefinition = new ColumnMetadata() { Identifier = new ColumnIdentifierFactory().Instantiate("Numeric value"), Role = ColumnRole.Value };89            var keyMappings = new ColumnMappingCollection() { new ColumnMapping(foreignKeyDefinition.Identifier, ColumnType.Text) };90            var violations = new LookupExistsViolationCollection(keyMappings);91            violations.Register(new KeyCollection(new[] { "Gamma" }), candidateTable.Rows[1]);92            var samplers = new Dictionary<string, ISampler<DataRow>>()93            {94                { "candidate", new NoneSampler<DataRow>() },95                { "reference", new NoneSampler<DataRow>() },96                { "analysis", new NoneSampler<DataRow>() },97            };98            var message = new LookupReverseExistsViolationMessageJson(samplers);99            message.Generate(referenceTable.Rows.Cast<DataRow>(), candidateTable.Rows.Cast<DataRow>(), violations, keyMappings, null);100            var text = message.RenderMessage();101            Assert.That(text, Does.Contain("\"expected\":{\"total-rows\":4}"));102            Assert.That(text, Does.Contain("\"actual\":{\"total-rows\":2}"));103            Assert.That(text, Does.Contain("\"analysis\":{\"missing\":{\"total-rows\":1}"));104        }...

LookupViolationCollection.cs

Source:LookupViolationCollection.cs

...55                foreach (var row in violation.Value.Rows)56                    yield return row;57        }58    }59    public class LookupExistsViolationCollection : LookupViolationCollection60    {61        public LookupExistsViolationCollection(ColumnMappingCollection keyMappings)62        : base(keyMappings, null) { }63        public LookupViolationInformation Register(NBiRs.KeyCollection key, DataRow candidateRow)64            => Register(RowViolationState.Unexpected, key, candidateRow);65    }66    public class LookupMatchesViolationCollection : LookupViolationCollection67    {68        public LookupMatchesViolationCollection(ColumnMappingCollection keyMappings, ColumnMappingCollection valueMappings)69        : base(keyMappings, valueMappings) { }70        public LookupViolationInformation Register(NBiRs.KeyCollection key, DataRow candidateRow)71            => Register(RowViolationState.Unexpected, key, candidateRow);72        public LookupViolationInformation Register(NBiRs.KeyCollection key, LookupMatchesViolationComposite composite)73        {74            if (ContainsKey(key))75            {76                var info = this[key] as LookupMatchesViolationInformation;77                if (info.State != RowViolationState.Mismatch)78                    throw new ArgumentException("Can't change the state of lookup violation");79                info.CandidateRows.Add(composite);80                return info;81            }82            else83            {84                var info = new LookupMatchesViolationInformation(RowViolationState.Mismatch);85                info.CandidateRows.Add(composite);86                Add(key, info);87                return info;88            }89        }90    }91    public class ReverseLookupExistsViolationCollection : LookupViolationCollection92    {93        public ReverseLookupExistsViolationCollection(ColumnMappingCollection keyMappings)94        : base(keyMappings, null) { }95        public LookupViolationInformation Register(NBiRs.KeyCollection key, DataRow candidateRow)96            => Register(RowViolationState.Missing, key, candidateRow);97    }98}...

LookupExistsConstraintTest.cs

Source:LookupExistsConstraintTest.cs

...64                new ColumnMapping(new ColumnOrdinalIdentifier(1), ColumnType.Text),65            };66            var lookupExists = new LookupExistsConstraint(assertService);67            var analyzer = new Mock<LookupExistsAnalyzer>(mappings);68            analyzer.Setup(x => x.Execute(It.IsAny<ResultSet>(), It.IsAny<ResultSet>())).Returns(new LookupExistsViolationCollection(null));69            lookupExists.Engine = analyzer.Object;70            //Method under test71            lookupExists.Matches(sutService);72            //Test conclusion            73            analyzer.Verify(x => x.Execute(sut, assert), Times.Once());74        }75    }76}...