Unlock 30% off on Manual Testing Annual Plans this Holiday Season.

Copied to Clipboard!

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    }...