Join the 1-day Testing & QA Summit featuring 15+ Expert Speakers.Register for FREE! Join TestMu Conference

How to use SingleRowOrdinalEquivaler class of NBi.Core.ResultSet.Equivalence package

Best NBi code snippet using NBi.Core.ResultSet.Equivalence.SingleRowOrdinalEquivaler

SingleRowOrdinalEquivalerTest.cs

Source:SingleRowOrdinalEquivalerTest.cs

...9#endregion10namespace NBi.Testing.Core.ResultSet.Equivalence11{12    [TestFixture]13    public class SingleRowOrdinalEquivalerTest14    {15       16        #region SetUp & TearDown17        //Called only at instance creation18        [OneTimeSetUp]19        public void SetupMethods()20        {21        }22        //Called only at instance destruction23        [OneTimeTearDown]24        public void TearDownMethods()25        {26        }27        //Called before each test28        [SetUp]29        public void SetupTest()30        {31        }32        //Called after each test33        [TearDown]34        public void TearDownTest()35        {36        }37        #endregion38        [Test]39        public void Compare_SameRows_ReturnEqual()40        {41            //Buiding object used during test42            var comparer = new SingleRowOrdinalEquivaler(new SettingsSingleRowOrdinalResultSet (ColumnType.Numeric, null, null));43            var reference = BuildDataTable<double>(new double[] { 0, 1 });44            var actual = BuildDataTable<double>(new double[] { 0, 1 });45            //Call the method to test46            var res = comparer.Compare(reference, actual);47            //Assertion48            Assert.That(res, Is.EqualTo(ResultResultSet.Matching));49        }50        [Test]51        public void Compare_SameRowsString_ReturnEqual()52        {53            //Buiding object used during test54            var comparer = new SingleRowOrdinalEquivaler(new SettingsSingleRowOrdinalResultSet (ColumnType.Text, null, null));55            var reference = BuildDataTable<string>(new string[] { "alpha", "beta" });56            var actual = BuildDataTable<string>(new string[] { "alpha", "beta" });57            //Call the method to test58            var res = comparer.Compare(reference, actual);59            //Assertion60            Assert.That(res, Is.EqualTo(ResultResultSet.Matching));61        }62        [Test]63        public void Compare_SameRowsDateTime_ReturnEqual()64        {65            //Buiding object used during test66            var comparer = new SingleRowOrdinalEquivaler(new SettingsSingleRowOrdinalResultSet (ColumnType.DateTime, null, null));67            var reference = BuildDataTable<string>(new string[] { "2015-01-17", "2015-01-18" });68            var actual = BuildDataTable<DateTime>(new DateTime[] { new DateTime(2015, 01, 17), new DateTime(2015, 01, 18) });69            //Call the method to test70            var res = comparer.Compare(reference, actual);71            //Assertion72            Assert.That(res, Is.EqualTo(ResultResultSet.Matching));73        }74        [Test]75        public void Compare_SameRowsBoolean_ReturnEqual()76        {77            //Buiding object used during test78            var comparer = new SingleRowOrdinalEquivaler(new SettingsSingleRowOrdinalResultSet (ColumnType.Boolean, null, null));79            var reference = BuildDataTable<string>(new string[] { "yes", "no" });80            var actual = BuildDataTable<bool>(new bool[] { true, false });81            //Call the method to test82            var res = comparer.Compare(reference, actual);83            //Assertion84            Assert.That(res, Is.EqualTo(ResultResultSet.Matching));85        }86        [Test]87        public void Compare_DifferentRows_ReturnNotEqual()88        {89            //Buiding object used during test90            var comparer = new SingleRowOrdinalEquivaler(new SettingsSingleRowOrdinalResultSet (ColumnType.Text, null, null));91            var reference = BuildDataTable<string>(new string[] { "Value0", "Value1" });92            var actual = BuildDataTable<string>(new string[] { "ValueX", "ValueY" });93            //Call the method to test94            var res = comparer.Compare(reference, actual);95            //Assertion96            Assert.That(res, Is.EqualTo(ResultResultSet.NotMatching));97        }98        [Test]99        public void Compare_DifferentRowsSingleNotMatching_ReturnNotEqual()100        {101            //Buiding object used during test102            var comparer = new SingleRowOrdinalEquivaler(new SettingsSingleRowOrdinalResultSet (ColumnType.Text, null, null));103            var reference = BuildDataTable<string>(new string[] { "Value0", "Value1" });104            var actual = BuildDataTable<string>(new string[] { "Value0", "ValueY" });105            //Call the method to test106            var res = comparer.Compare(reference, actual);107            //Assertion108            Assert.That(res, Is.EqualTo(ResultResultSet.NotMatching));109        }110        [Test]111        public void Compare_DifferentRowsNumeric_ReturnNotEqual()112        {113            //Buiding object used during test114            var comparer = new SingleRowOrdinalEquivaler(new SettingsSingleRowOrdinalResultSet (ColumnType.Numeric, null, null));115            var reference = BuildDataTable<string>(new string[] { "100", "12.750" });116            var actual = BuildDataTable<decimal>(new decimal[] { new decimal(999), new decimal(12.75) });117            //Call the method to test118            var res = comparer.Compare(reference, actual);119            //Assertion120            Assert.That(res, Is.EqualTo(ResultResultSet.NotMatching));121        }122        [Test]123        public void Compare_UnexpectedRow_ReturnNotEqual()124        {125            //Buiding object used during test126            var comparer = new SingleRowOrdinalEquivaler(new SettingsSingleRowOrdinalResultSet (ColumnType.Text, null, null));127            var reference = BuildDataEmptyTable<string>(3);128            var actual = BuildDataTable<string>(new string[] { "Value0", "Value1", "Value2" });129            //Call the method to test130            var res = comparer.Compare(actual, reference);131            //Assertion132            Assert.That(res, Is.EqualTo(ResultResultSet.NotMatching));133            Assert.That(res.Unexpected, Has.Count.EqualTo(1));134        }135        [Test]136        public void Compare_MissingRow_ReturnNotEqual()137        {138            //Buiding object used during test139            var comparer = new SingleRowOrdinalEquivaler(new SettingsSingleRowOrdinalResultSet (ColumnType.Text, null, null));140            var reference = BuildDataTable<string>(new string[] { "Value0", "Value1", "Value2" });141            var actual = BuildDataEmptyTable<string>(3); 142            //Call the method to test143            var res = comparer.Compare(actual, reference);144            //Assertion145            Assert.That(res, Is.EqualTo(ResultResultSet.NotMatching));146            Assert.That(res.Missing, Has.Count.EqualTo(1));147        }148        [Test]149        public void Compare_ObjectsVersusSameTypedButWithPrecision_ReturnEqual()150        {151            //Buiding object used during test152            var comparer = new SingleRowOrdinalEquivaler(new SettingsSingleRowOrdinalResultSet (ColumnType.Numeric, null, BuildColumnsStringDecimal()));153            var reference = BuildDataTable<string>(new string[] { "Value0", "100.50" });154            var actual = BuildDataTable<object>(new object[] { "Value0", 100.5 });155            //Call the method to test156            var res = comparer.Compare(reference, actual);157            //Assertion158            Assert.That(res, Is.EqualTo(ResultResultSet.Matching));159        }160        protected DataTable BuildDataTable<T>(T[] values)161        {162            return BuildDataTable<T>(values, null);163        }164        165        protected DataTable BuildDataTable<T>(T[] values, string[] useless)166        {...

SingleRowOrdinalEquivaler.cs

Source:SingleRowOrdinalEquivaler.cs

...5using System.Linq;6using NBi.Core.ResultSet.Analyzer;7namespace NBi.Core.ResultSet.Equivalence8{9    public class SingleRowOrdinalEquivaler : OrdinalEquivaler10    {11        private new SettingsSingleRowOrdinalResultSet  Settings12        {13            get { return base.Settings as SettingsSingleRowOrdinalResultSet ; }14        }15        16        public SingleRowOrdinalEquivaler(SettingsSingleRowOrdinalResultSet  settings)17            : base(AnalyzersFactory.EqualTo(), settings)18        {}19        protected override ResultResultSet doCompare(DataTable x, DataTable y)20        {21            if (x.Rows.Count > 1)22                throw new ArgumentException(string.Format("The query in the assertion returns {0} rows. It was expected to return zero or one row.", x.Rows.Count));23            if (y.Rows.Count > 1)24                throw new ArgumentException(string.Format("The query in the system-under-test returns {0} rows. It was expected to return zero or one row.", y.Rows.Count));25            return doCompare(x.Rows.Count == 1 ? x.Rows[0] : null, y.Rows.Count == 1 ? y.Rows[0] : null);26        }27        protected ResultResultSet doCompare(DataRow x, DataRow y)28        {29            var chrono = DateTime.Now;30            var missingRows = new List<DataRow>();...

EquivalerFactory.cs

Source:EquivalerFactory.cs

...20        public IEquivaler InstantiateSingleRow(ISettingsSingleRowResultSet settings)21        {22            switch (settings)23            {24                case SettingsSingleRowOrdinalResultSet x: return new SingleRowOrdinalEquivaler(x);25                case SettingsSingleRowNameResultSet x: return new SingleRowNameEquivaler(x);26                default: throw new ArgumentException();27            }28        }29        public IEquivaler InstantiateMultipleRows(ISettingsResultSet settings, EquivalenceKind kind)30        {31            var factory = new AnalyzersFactory();32            var analyzers = factory.Instantiate(kind);33            switch (settings)34            {35                case SettingsOrdinalResultSet x: return new OrdinalEquivaler(analyzers, x);36                case SettingsNameResultSet x: return new NameEquivaler(analyzers, x);37                default: throw new ArgumentException();38            }...

Automation Testing Tutorials

Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.