How to use BuildDefaultSettings method of NBi.Core.ResultSet.Equivalence.OrdinalEquivaler class

Best NBi code snippet using NBi.Core.ResultSet.Equivalence.OrdinalEquivaler.BuildDefaultSettings

OrdinalEquivaler.cs

Source:OrdinalEquivaler.cs

...19        protected override void PreliminaryChecks(DataTable x, DataTable y)20        {21            var columnsCount = Math.Max(y.Columns.Count, x.Columns.Count);22            if (Settings == null)23                BuildDefaultSettings(columnsCount);24            else25                Settings.ApplyTo(columnsCount);26            WriteSettingsToDataTableProperties(y, Settings);27            WriteSettingsToDataTableProperties(x, Settings);28            CheckSettingsAndDataTable(y, Settings);29            CheckSettingsAndDataTable(x, Settings);30            CheckSettingsAndFirstRow(y, Settings);31            CheckSettingsAndFirstRow(x, Settings);32        }33        public override EngineStyle Style34        {35            get => EngineStyle.ByIndex;36        }37        protected override DataRowKeysComparer BuildDataRowsKeyComparer(DataTable x)38            => new DataRowKeysComparerByOrdinal(Settings, x.Columns.Count);39        protected override bool CanSkipValueComparison()40            => Settings.KeysDef == SettingsOrdinalResultSet.KeysChoice.All;41        protected override DataRow CompareRows(DataRow rx, DataRow ry)42        {43            var isRowOnError = false;44            for (int i = 0; i < rx.Table.Columns.Count; i++)45            {46                if (Settings.GetColumnRole(i) == ColumnRole.Value)47                {48                    var x = rx.IsNull(i) ? DBNull.Value : rx[i];49                    var y = ry.IsNull(i) ? DBNull.Value : ry[i];50                    var rounding = Settings.IsRounding(i) ? Settings.GetRounding(i) : null;51                    var result = CellComparer.Compare(x, y, Settings.GetColumnType(i), Settings.GetTolerance(i), rounding);52                    if (!result.AreEqual)53                    {54                        ry.SetColumnError(i, result.Message);55                        if (!isRowOnError)56                            isRowOnError = true;57                    }58                }59            }60            if (isRowOnError)61                return ry;62            else63                return null;64        }65        protected void WriteSettingsToDataTableProperties(DataTable dt, SettingsOrdinalResultSet settings)66        {67            foreach (DataColumn column in dt.Columns)68            {69                WriteSettingsToDataTableProperties(70                    column71                    , settings.GetColumnRole(column.Ordinal)72                    , settings.GetColumnType(column.Ordinal)73                    , settings.GetTolerance(column.Ordinal)74                    , settings.GetRounding(column.Ordinal)75                );76            }77        }78        protected void CheckSettingsAndDataTable(DataTable dt, SettingsOrdinalResultSet settings)79        {80            var max = settings.GetMaxColumnOrdinalDefined();81            if (dt.Columns.Count <= max)82            {83                var exception = string.Format("You've defined a column with an index of {0}, meaning that your result set would have at least {1} columns but your result set has only {2} columns."84                    , max85                    , max + 186                    , dt.Columns.Count);87                if (dt.Columns.Count == max && settings.GetMinColumnOrdinalDefined() == 1)88                    exception += " You've no definition for a column with an index of 0. Are you sure you'vent started to index at 1 in place of 0?";89                throw new EquivalerException(exception);90            }91        }92        protected void CheckSettingsAndFirstRow(DataTable dt, SettingsOrdinalResultSet settings)93        {94            if (dt.Rows.Count == 0)95                return;96            var dr = dt.Rows[0];97            for (int i = 0; i < dr.Table.Columns.Count; i++)98            {99                CheckSettingsFirstRowCell(100                        settings.GetColumnRole(i)101                        , settings.GetColumnType(i)102                        , dr.Table.Columns[i]103                        , dr.IsNull(i) ? DBNull.Value : dr[i]104                        , new string[]105                            {106                                "The column with index '{0}' is expecting a numeric value but the first row of your result set contains a value '{1}' not recognized as a valid numeric value or a valid interval."107                                , " Aren't you trying to use a comma (',' ) as a decimal separator? NBi requires that the decimal separator must be a '.'."108                                , "The column with index '{0}' is expecting a 'date & time' value but the first row of your result set contains a value '{1}' not recognized as a valid date & time value."109                            }110                );111            }112        }113        protected virtual void BuildDefaultSettings(int columnsCount)114        {115            base.Settings = new SettingsOrdinalResultSet(116                columnsCount,117                SettingsOrdinalResultSet.KeysChoice.AllExpectLast,118                SettingsOrdinalResultSet.ValuesChoice.Last);119        }120    }121}...

SingleRowOrdinalEquivaler.cs

Source:SingleRowOrdinalEquivaler.cs

...39            {40                chrono = DateTime.Now;41                var columnsCount = Math.Max(y.Table.Columns.Count, x.Table.Columns.Count);42                if (Settings == null)43                    BuildDefaultSettings(columnsCount);44                else45                    Settings.ApplyTo(columnsCount);46                PreliminaryChecks(x.Table, y.Table);47                Trace.WriteLineIf(Extensibility.NBiTraceSwitch.TraceInfo, string.Format("Analyzing length and format of result-sets: [{0}]", DateTime.Now.Subtract(chrono).ToString(@"d\d\.hh\h\:mm\m\:ss\s\ \+fff\m\s")));48                // If all of the columns make up the key, then we already know which rows match and which don't.49                //  So there is no need to continue testing50                chrono = DateTime.Now;51                var nonMatchingValueRow = CompareRows(x, y);52                if (nonMatchingValueRow!=null)53                    nonMatchingValueRows.Add(nonMatchingValueRow);54                Trace.WriteLineIf(Extensibility.NBiTraceSwitch.TraceInfo, string.Format("Rows with a matching key but without matching value: {0} [{1}]", nonMatchingValueRows.Count(), DateTime.Now.Subtract(chrono).ToString(@"d\d\.hh\h\:mm\m\:ss\s\ \+fff\m\s")));55            }56            return ResultResultSet.Build(57                missingRows,...

BuildDefaultSettings

Using AI Code Generation

1using System;2using System.Collections.Generic;3using System.Linq;4using System.Text;5using System.Threading.Tasks;6using NBi.Core.ResultSet;7using NBi.Core.ResultSet.Equivalence;8{9    {10        static void Main(string[] args)11        {12            var settings = OrdinalEquivaler.BuildDefaultSettings();13            Console.WriteLine("Default settings are:");14            Console.WriteLine("CaseSensitive: " + settings.CaseSensitive);15            Console.WriteLine("Tolerance: " + settings.Tolerance);16            Console.WriteLine("Rounding: " + settings.Rounding);17            Console.WriteLine("Culture: " + settings.Culture);18            Console.WriteLine("IgnoreWhiteSpaces: " + settings.IgnoreWhiteSpaces);19            Console.WriteLine("IgnoreEmptyString: " + settings.IgnoreEmptyString);20            Console.WriteLine("IgnoreBlankCells: " + settings.IgnoreBlankCells);21            Console.WriteLine("IgnoreZero: " + settings.IgnoreZero);22            Console.WriteLine("IgnoreDiacritics: " + settings.IgnoreDiacritics);23            Console.WriteLine("IgnoreTrailingZeros: " + settings.IgnoreTrailingZeros);24            Console.WriteLine("IgnoreKebabCase: " + settings.IgnoreKebabCase);25            Console.WriteLine("IgnoreUnderscoreCase: " + settings.IgnoreUnderscoreCase);26            Console.WriteLine("IgnoreCamelCase: " + settings.IgnoreCamelCase);27            Console.WriteLine("IgnorePascalCase: " + settings.IgnorePascalCase);28            Console.WriteLine("IgnoreSentenceCase: " + settings.IgnoreSentenceCase);29            Console.WriteLine("IgnoreTitleCase: " + settings.IgnoreTitleCase);30            Console.WriteLine("IgnoreOrdinalCase: " + settings.IgnoreOrdinalCase);31            Console.WriteLine("IgnoreOrdinalNumber: " + settings.IgnoreOrdinalNumber);32            Console.WriteLine("IgnoreOrdinalLetter: " + settings.IgnoreOrdinalLetter);33            Console.WriteLine("IgnoreOrdinalWord: " + settings.IgnoreOrdinalWord);34            Console.WriteLine("IgnoreOrdinal: " + settings.IgnoreOrdinal);35            Console.WriteLine("IgnoreOrdinalAll: " + settings.IgnoreOrdinalAll);36            Console.WriteLine("IgnoreOrdinalAllExceptNumber: " + settings.IgnoreOrdinalAllExceptNumber);37            Console.WriteLine("IgnoreOrdinalAllExceptLetter: " + settings.IgnoreOrdinalAllExceptLetter);38            Console.WriteLine("IgnoreOrdinalAllExceptWord: " + settings.IgnoreOrdinalAllExceptWord);39            Console.WriteLine("IgnoreOrdinalAllExcept: " + settings.IgnoreOrdinalAllExcept);40            Console.WriteLine("IgnoreOrdinalAll

BuildDefaultSettings

Using AI Code Generation

1using System;2using System.Collections.Generic;3using System.Linq;4using System.Text;5using System.Threading.Tasks;6using NBi.Core.ResultSet;7using NBi.Core.ResultSet.Equivalence;8using NBi.Core.ResultSet.Lookup;9{10    {11        static void Main(string[] args)12        {13            var equivaler = new OrdinalEquivaler();14            var settings = equivaler.BuildDefaultSettings();15            settings.ColumnsDefinition.Add(new ColumnDefinition("column1", ColumnType.Numeric));16            settings.ColumnsDefinition.Add(new ColumnDefinition("column2", ColumnType.Numeric));17            settings.ColumnsDefinition.Add(new ColumnDefinition("column3", ColumnType.Numeric));18            settings.ColumnsDefinition.Add(new ColumnDefinition("column4", ColumnType.Numeric));19            settings.ColumnsDefinition.Add(new ColumnDefinition("column5", ColumnType.Numeric));20            settings.ColumnsDefinition.Add(new ColumnDefinition("column6", ColumnType.Numeric));21            settings.ColumnsDefinition.Add(new ColumnDefinition("column7", ColumnType.Numeric));22            settings.ColumnsDefinition.Add(new ColumnDefinition("column8", ColumnType.Numeric));23            settings.ColumnsDefinition.Add(new ColumnDefinition("column9", ColumnType.Numeric));24            settings.ColumnsDefinition.Add(new ColumnDefinition("column10", ColumnType.Numeric));25            settings.ColumnsDefinition.Add(new ColumnDefinition("column11", ColumnType.Numeric));26            settings.ColumnsDefinition.Add(new ColumnDefinition("column12", ColumnType.Numeric));27            settings.ColumnsDefinition.Add(new ColumnDefinition("column13", ColumnType.Numeric));28            settings.ColumnsDefinition.Add(new ColumnDefinition("column14", ColumnType.Numeric));29            settings.ColumnsDefinition.Add(new ColumnDefinition("column15", ColumnType.Numeric));30            settings.ColumnsDefinition.Add(new ColumnDefinition("column16", ColumnType.Numeric));31            settings.ColumnsDefinition.Add(new ColumnDefinition("column17", ColumnType.Numeric));32            settings.ColumnsDefinition.Add(new ColumnDefinition("column18", ColumnType.Numeric));33            settings.ColumnsDefinition.Add(new ColumnDefinition("column19", ColumnType.Numeric));34            settings.ColumnsDefinition.Add(new ColumnDefinition("column20", ColumnType.Numeric));35            settings.ColumnsDefinition.Add(new ColumnDefinition("column21", ColumnType.Numeric));36            settings.ColumnsDefinition.Add(new ColumnDefinition("column22", ColumnType.Numeric));37            settings.ColumnsDefinition.Add(new ColumnDefinition("column23", ColumnType.Numeric));38            settings.ColumnsDefinition.Add(new ColumnDefinition("column24", ColumnType.Numeric));

BuildDefaultSettings

Using AI Code Generation

1using NBi.Core.ResultSet;2using NBi.Core.ResultSet.Equivalence;3using NBi.Core.ResultSet.Lookup;4using NBi.Core.Calculation;5using System;6using System.Collections.Generic;7using System.Data;8using System.Linq;9using System.Text;10using System.Threading.Tasks;11using NBi.Core.Transformation;12using NBi.Core.Transformation.Transformer.Native;13using NBi.Extensibility.Resolving;14using NBi.Core.ResultSet.Resolver;15using NBi.Core.ResultSet.Lookup.Violation;16using NBi.Core.ResultSet.Lookup.Strategy;17{18    {19        static void Main(string[] args)20        {21            DataTable dt1 = new DataTable("dt1");22            dt1.Columns.Add("ID", typeof(int));23            dt1.Columns.Add("Name", typeof(string));24            dt1.Columns.Add("Date", typeof(DateTime));25            dt1.Rows.Add(1, "A", DateTime.Parse("2017-01-01"));26            dt1.Rows.Add(2, "B", DateTime.Parse("2017-01-02"));27            dt1.Rows.Add(3, "C", DateTime.Parse("2017-01-03"));28            dt1.Rows.Add(4, "D", DateTime.Parse("2017-01-04"));29            dt1.Rows.Add(5, "E", DateTime.Parse("2017-01-05"));30            dt1.Rows.Add(6, "F", DateTime.Parse("2017-01-06"));31            dt1.Rows.Add(7, "G", DateTime.Parse("2017-01-07"));32            dt1.Rows.Add(8, "H", DateTime.Parse("2017-01-08"));33            dt1.Rows.Add(9, "I", DateTime.Parse("2017-01-09"));34            dt1.Rows.Add(10, "J", DateTime.Parse("2017-01-10"));35            dt1.Rows.Add(11, "K", DateTime.Parse("2017-01-11"));36            dt1.Rows.Add(12, "L", DateTime.Parse("2017-01-12"));37            dt1.Rows.Add(13, "M", DateTime.Parse("2017-01-13"));38            dt1.Rows.Add(14, "N", DateTime.Parse("2017-01-14"));39            dt1.Rows.Add(15, "O", DateTime.Parse("2017-01

BuildDefaultSettings

Using AI Code Generation

1using NBi.Core.ResultSet.Equivalence;2OrdinalEquivaler equivaler = new OrdinalEquivaler();3EquivalerSettings settings = equivaler.BuildDefaultSettings();4settings.Columns[0].Tolerance = 0.01;5settings.Columns[1].Tolerance = 0.01;6settings.Columns[2].Tolerance = 0.01;7settings.Columns[3].Tolerance = 0.01;8settings.Columns[4].Tolerance = 0.01;9settings.Columns[5].Tolerance = 0.01;10settings.Columns[6].Tolerance = 0.01;11settings.Columns[7].Tolerance = 0.01;12settings.Columns[8].Tolerance = 0.01;13settings.Columns[9].Tolerance = 0.01;14settings.Columns[10].Tolerance = 0.01;15settings.Columns[11].Tolerance = 0.01;16settings.Columns[12].Tolerance = 0.01;17settings.Columns[13].Tolerance = 0.01;18settings.Columns[14].Tolerance = 0.01;19settings.Columns[15].Tolerance = 0.01;20settings.Columns[16].Tolerance = 0.01;21settings.Columns[17].Tolerance = 0.01;22settings.Columns[18].Tolerance = 0.01;23settings.Columns[19].Tolerance = 0.01;24settings.Columns[20].Tolerance = 0.01;25settings.Columns[21].Tolerance = 0.01;26settings.Columns[22].Tolerance = 0.01;27settings.Columns[23].Tolerance = 0.01;28settings.Columns[24].Tolerance = 0.01;29settings.Columns[25].Tolerance = 0.01;30settings.Columns[26].Tolerance = 0.01;31settings.Columns[27].Tolerance = 0.01;32settings.Columns[28].Tolerance = 0.01;33settings.Columns[29].Tolerance = 0.01;34settings.Columns[30].Tolerance = 0.01;35settings.Columns[31].Tolerance = 0.01;36settings.Columns[32].Tolerance = 0.01;37settings.Columns[33].Tolerance = 0.01;38settings.Columns[34].Tolerance = 0.01;

BuildDefaultSettings

Using AI Code Generation

1using System;2using System.Collections.Generic;3using System.Linq;4using System.Text;5using System.Threading.Tasks;6using NBi.Core.ResultSet;7using NBi.Core.ResultSet.Equivalence;8using NBi.Core.ResultSet.Lookup.Violation;9{10    {11        static void Main(string[] args)12        {13            var settings = OrdinalEquivaler.BuildDefaultSettings();14            settings.Rounding = 2;15            settings.RoundingStep = RoundingStep.None;16            settings.RoundingStyle = RoundingStyle.None;17            settings.Tolerance = 0;18            settings.ViolationManager = new AllViolationManager();19            settings.IsCaseSensitive = true;20            settings.IsBlankDistinct = true;21            settings.IsOrdinal = true;22            settings.IsTypeEnforced = true;23            settings.IsIgnoreDuplicate = true;24            settings.IsIgnoreRowOrder = true;25            settings.IsIgnoreWhiteSpaces = true;26            settings.IsIgnorePattern = true;27            settings.IsIgnoreSpecialCharacters = true;28            settings.IsIgnoreNumberSign = true;29            settings.IsIgnoreCurrencySymbol = true;30            settings.IsIgnoreDate = true;31            settings.IsIgnoreTime = true;32            settings.IsIgnoreDateTime = true;33            settings.IsIgnoreMillisecond = true;34            settings.IsIgnoreSecond = true;35            settings.IsIgnoreMinute = true;36            settings.IsIgnoreHour = true;37            settings.IsIgnoreDay = true;38            settings.IsIgnoreMonth = true;39            settings.IsIgnoreYear = true;40            settings.IsIgnoreOrdinal = true;41            settings.IsIgnoreAll = true;42            settings.IsIgnoreDistinct = true;43            var equivaler = new OrdinalEquivaler(settings);44        }45    }46}47using System;48using System.Collections.Generic;49using System.Linq;50using System.Text;51using System.Threading.Tasks;52using NBi.Core.ResultSet;53using NBi.Core.ResultSet.Equivalence;54using NBi.Core.ResultSet.Lookup.Violation;55{56    {57        static void Main(string[] args)58        {59            var settings = OrdinalEquivaler.BuildDefaultSettings();60            settings.Rounding = 2;61            settings.RoundingStep = RoundingStep.None;

BuildDefaultSettings

Using AI Code Generation

1var equivaler = new NBi.Core.ResultSet.Equivalence.OrdinalEquivaler();2var settings = equivaler.BuildDefaultSettings();3settings.Percentage = 0.1;4settings.Tolerance = 0.1;5var equivaler = new NBi.Core.ResultSet.Equivalence.OrdinalEquivaler();6var settings = equivaler.BuildDefaultSettings();7settings.Percentage = 0.1;8settings.Tolerance = 0.1;9var equivaler = new NBi.Core.ResultSet.Equivalence.OrdinalEquivaler();10var settings = equivaler.BuildDefaultSettings();11settings.Percentage = 0.1;12settings.Tolerance = 0.1;13var equivaler = new NBi.Core.ResultSet.Equivalence.OrdinalEquivaler();14var settings = equivaler.BuildDefaultSettings();15settings.Percentage = 0.1;16settings.Tolerance = 0.1;17var equivaler = new NBi.Core.ResultSet.Equivalence.OrdinalEquivaler();18var settings = equivaler.BuildDefaultSettings();19settings.Percentage = 0.1;20settings.Tolerance = 0.1;21var equivaler = new NBi.Core.ResultSet.Equivalence.OrdinalEquivaler();22var settings = equivaler.BuildDefaultSettings();23settings.Percentage = 0.1;24settings.Tolerance = 0.1;25var equivaler = new NBi.Core.ResultSet.Equivalence.OrdinalEquivaler();26var settings = equivaler.BuildDefaultSettings();27settings.Percentage = 0.1;28settings.Tolerance = 0.1;29var equivaler = new NBi.Core.ResultSet.Equivalence.OrdinalEquivaler();30var settings = equivaler.BuildDefaultSettings();31settings.Percentage = 0.1;32settings.Tolerance = 0.1;33var equivaler = new NBi.Core.ResultSet.Equivalence.OrdinalEquivaler();34var settings = equivaler.BuildDefaultSettings();

BuildDefaultSettings

Using AI Code Generation

1var settings = NBi.Core.ResultSet.Equivalence.OrdinalEquivaler.BuildDefaultSettings();2Console.WriteLine(settings.IsCaseSensitive);3Console.WriteLine(settings.IsTrimmingEnabled);4Console.WriteLine(settings.IsNumericToleranceEnabled);5var settings = NBi.Core.ResultSet.Equivalence.OrdinalEquivaler.BuildDefaultSettings();6Console.WriteLine(settings.IsCaseSensitive);7Console.WriteLine(settings.IsTrimmingEnabled);8Console.WriteLine(settings.IsNumericToleranceEnabled);9Console.WriteLine(settings.NumericTolerance);10var settings = NBi.Core.ResultSet.Equivalence.OrdinalEquivaler.BuildDefaultSettings();11Console.WriteLine(settings.IsCaseSensitive);12Console.WriteLine(settings.IsTrimmingEnabled);13Console.WriteLine(settings.IsNumericToleranceEnabled);14Console.WriteLine(settings.NumericTolerance);15Console.WriteLine(settings.NumericToleranceMode);16var settings = NBi.Core.ResultSet.Equivalence.OrdinalEquivaler.BuildDefaultSettings();17Console.WriteLine(settings.IsCaseSensitive);18Console.WriteLine(settings.IsTrimmingEnabled);19Console.WriteLine(settings.IsNumericToleranceEnabled);20Console.WriteLine(settings.NumericTolerance);21Console.WriteLine(settings.NumericToleranceMode);22Console.WriteLine(settings.NumericToleranceType);23var settings = NBi.Core.ResultSet.Equivalence.OrdinalEquivaler.BuildDefaultSettings();24Console.WriteLine(settings.IsCaseSensitive);25Console.WriteLine(settings.IsTrimmingEnabled);26Console.WriteLine(settings.IsNumericToleranceEnabled);27Console.WriteLine(settings.NumericTolerance);28Console.WriteLine(settings.NumericToleranceMode);29Console.WriteLine(settings.NumericToleranceType);

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.