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

Automation Advisor
NBi
NBi.Core.ResultSet
SettingsSingleRowOrdinalResultSet

How to use SettingsSingleRowOrdinalResultSet class of NBi.Core.ResultSet package

Best NBi code snippet using NBi.Core.ResultSet.SettingsSingleRowOrdinalResultSet

SingleRowOrdinalEquivalerTest.cs

Source:SingleRowOrdinalEquivalerTest.cs

...38        [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

...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>();...

SettingsSingleRowOrdinalResultSet .cs

Source:SettingsSingleRowOrdinalResultSet .cs

...4using System.Xml.Serialization;5using NBi.Core.Scalar.Comparer;6namespace NBi.Core.ResultSet7{8	public class SettingsSingleRowOrdinalResultSet : SettingsOrdinalResultSet, ISettingsSingleRowResultSet9    {10        11		public SettingsSingleRowOrdinalResultSet (ColumnType valuesDefaultType, Tolerance defaultTolerance, IReadOnlyCollection<IColumnDefinition> columnsDef)12            : base(valuesDefaultType, defaultTolerance, columnsDef)13		{14		}15        public SettingsSingleRowOrdinalResultSet ()16            : this(ColumnType.Numeric, null, null)17        {18        }19        protected override bool IsKey(int index)20        {21            return false;22        }23        protected override bool IsValue(int index)24        {25            if (ColumnsDef.Any(c => (c.Identifier as ColumnOrdinalIdentifier)?.Ordinal == index && c.Role == ColumnRole.Ignore))26                return false;27            return true;28        }29    }...