How to use RenderExpected method of NBi.Framework.FailureMessage.Markdown.DataRowsMessageMarkdown class

Best NBi code snippet using NBi.Framework.FailureMessage.Markdown.DataRowsMessageMarkdown.RenderExpected

DataRowsMessageMardownTest.cs

Source:DataRowsMessageMardownTest.cs

...29            return dataTable.Rows.Cast<DataRow>();30        }31        #endregion32        [Test]33        public void RenderExpected_MoreThanMaxRowsCount_ReturnCorrectNumberOfRowsOnTop()34        {35            var dataTable = new DataTable() { TableName = "MyTable" };36            dataTable.Columns.Add(new DataColumn("Id"));37            dataTable.Columns.Add(new DataColumn("Numeric value"));38            dataTable.Columns.Add(new DataColumn("Boolean value"));39            for (int i = 0; i < 20; i++)40                dataTable.LoadDataRow(new object[] { "Alpha", i, true }, false);41            var samplers = new SamplersFactory<DataRow>().Instantiate(FailureReportProfile.Default);42            var msg = new DataRowsMessageMarkdown(EngineStyle.ByIndex, samplers);43            msg.BuildComparaison(dataTable.Rows.Cast<DataRow>(), null, null);44            var value = msg.RenderExpected();45            var lines = value.Replace("\n", string.Empty).Split('\r');46            Assert.That(lines[0], Is.EqualTo("Result-set with 20 rows"));47        }48        [Test]49        public void RenderExpected_OneRow_ReturnCorrectNumberOfRowsOnTopWithoutPlurial()50        {51            var dataTable = new DataTable() { TableName = "MyTable" };52            dataTable.Columns.Add(new DataColumn("Id"));53            dataTable.Columns.Add(new DataColumn("Numeric value"));54            dataTable.Columns.Add(new DataColumn("Boolean value"));55            for (int i = 0; i < 1; i++)56                dataTable.LoadDataRow(new object[] { "Alpha", i, true }, false);57            var samplers = new SamplersFactory<DataRow>().Instantiate(FailureReportProfile.Default);58            var msg = new DataRowsMessageMarkdown(EngineStyle.ByIndex, samplers);59            msg.BuildComparaison(dataTable.Rows.Cast<DataRow>(), null, null);60            var value = msg.RenderExpected();61            var lines = value.Replace("\n", string.Empty).Split('\r');62            Assert.That(lines[0], Is.EqualTo("Result-set with 1 row"));63        }64        [Test]65        public void RenderExpected_MoreThanMaxRowsCount_ReturnSampleRowsCountAndHeadersAndSeparation()66        {67            var dataSet = new DataSet();68            var dataTable = new DataTable() { TableName = "MyTable" };69            dataTable.Columns.Add(new DataColumn("Id"));70            dataTable.Columns.Add(new DataColumn("Numeric value"));71            dataTable.Columns.Add(new DataColumn("Boolean value"));72            dataTable.Columns["Id"].ExtendedProperties.Add("NBi::Role", ColumnRole.Key);73            for (int i = 0; i < 20; i++)74                dataTable.LoadDataRow(new object[] { "Alpha", i, true }, false);75            var samplers = new SamplersFactory<DataRow>().Instantiate(FailureReportProfile.Default);76            var msg = new DataRowsMessageMarkdown(EngineStyle.ByIndex, samplers);77            msg.BuildComparaison(dataTable.Rows.Cast<DataRow>(), null, null);78            var value = msg.RenderExpected();79            var lines = value.Replace("\n", string.Empty).Split('\r');80            Assert.That(lines.Count(l => l.Contains("|")), Is.EqualTo(10 + 3));81        }82        [Test]83        public void RenderExpected_MoreThanMaxRowsCount_ReturnSampleRowsCountAndHeaderAndSeparation()84        {85            var dataSet = new DataSet();86            var dataTable = new DataTable() { TableName = "MyTable" };87            dataTable.Columns.Add(new DataColumn("Id"));88            dataTable.Columns.Add(new DataColumn("Numeric value"));89            dataTable.Columns.Add(new DataColumn("Boolean value"));90            for (int i = 0; i < 20; i++)91                dataTable.LoadDataRow(new object[] { "Alpha", i, true }, false);92            var samplers = new SamplersFactory<DataRow>().Instantiate(FailureReportProfile.Default);93            var msg = new DataRowsMessageMarkdown(EngineStyle.ByIndex, samplers);94            msg.BuildComparaison(dataTable.Rows.Cast<DataRow>(), null, null);95            var value = msg.RenderExpected();96            var lines = value.Replace("\n", string.Empty).Split('\r');97            Assert.That(lines.Count(l => l.Contains("|")), Is.EqualTo(10 + 3 -1)); //-1 because we've no ExtendedProperties98        }99        [Test]100        public void RenderExpected_MoreThanSampleRowsCountButLessThanMaxRowsCount_ReturnEachRowAndHeaderAndSeparation()101        {102            var rowCount = 12;103            var dataSet = new DataSet();104            var dataTable = new DataTable() { TableName = "MyTable" };105            dataTable.Columns.Add(new DataColumn("Id"));106            dataTable.Columns.Add(new DataColumn("Numeric value"));107            dataTable.Columns.Add(new DataColumn("Boolean value"));108            dataTable.Columns["Id"].ExtendedProperties.Add("NBi::Role", ColumnRole.Key);109            for (int i = 0; i < rowCount; i++)110                dataTable.LoadDataRow(new object[] { "Alpha", i, true }, false);111            var samplers = new SamplersFactory<DataRow>().Instantiate(FailureReportProfile.Default);112            var msg = new DataRowsMessageMarkdown(EngineStyle.ByIndex, samplers);113            msg.BuildComparaison(dataTable.Rows.Cast<DataRow>(), null, null);114            var value = msg.RenderExpected();115            var lines = value.Replace("\n", string.Empty).Split('\r');116            117            Assert.That(lines.Count(l => l.Contains("|")), Is.EqualTo(rowCount + 3));118        }119        [Test]120        public void RenderExpected_MoreThanSampleRowsCountButLessThanMaxRowsCountWithSpecificProfile_ReturnEachRowAndHeaderAndSeparation()121        {122            var rowCount = 120;123            var threshold = rowCount - 20;124            var max = threshold / 2;125            var dataSet = new DataSet();126            var dataTable = new DataTable() { TableName = "MyTable" };127            dataTable.Columns.Add(new DataColumn("Id"));128            dataTable.Columns.Add(new DataColumn("Numeric value"));129            dataTable.Columns.Add(new DataColumn("Boolean value"));130            dataTable.Columns["Id"].ExtendedProperties.Add("NBi::Role", ColumnRole.Key);131            for (int i = 0; i < rowCount; i++)132                dataTable.LoadDataRow(new object[] { "Alpha", i, true }, false);133            var profile = Mock.Of<IFailureReportProfile>(p =>134                p.MaxSampleItem == max135                && p.ThresholdSampleItem == threshold136                && p.ExpectedSet == FailureReportSetType.Sample137            );138            var samplers = new SamplersFactory<DataRow>().Instantiate(profile);139            var msg = new DataRowsMessageMarkdown(EngineStyle.ByIndex, samplers);140            msg.BuildComparaison(dataTable.Rows.Cast<DataRow>(), null, null);141            var value = msg.RenderExpected();142            var lines = value.Replace("\n", string.Empty).Split('\r');143            144            Assert.That(lines.Count(l => l.Contains("|")), Is.EqualTo(max + 3));145        }146        [Test]147        public void RenderExpected_MoreThanSampleRowsCountButLessThanMaxRowsCountWithSpecificProfileFull_ReturnEachRowAndHeaderAndSeparation()148        {149            var rowCount = 120;150            var threshold = rowCount - 20;151            var max = threshold / 2;152            var dataSet = new DataSet();153            var dataTable = new DataTable() { TableName = "MyTable" };154            dataTable.Columns.Add(new DataColumn("Id"));155            dataTable.Columns.Add(new DataColumn("Numeric value"));156            dataTable.Columns.Add(new DataColumn("Boolean value"));157            dataTable.Columns["Id"].ExtendedProperties.Add("NBi::Role", ColumnRole.Key);158            for (int i = 0; i < rowCount; i++)159                dataTable.LoadDataRow(new object[] { "Alpha", i, true }, false);160            var profile = Mock.Of<IFailureReportProfile>(p =>161                p.MaxSampleItem == max162                && p.ThresholdSampleItem == threshold163                && p.ExpectedSet == FailureReportSetType.Full164            );165            var samplers = new SamplersFactory<DataRow>().Instantiate(profile);166            var msg = new DataRowsMessageMarkdown(EngineStyle.ByIndex, samplers);167            msg.BuildComparaison(dataTable.Rows.Cast<DataRow>(), null, null);168            var value = msg.RenderExpected();169            var lines = value.Replace("\n", string.Empty).Split('\r');170            171            Assert.That(lines.Count(l => l.Contains("|")), Is.EqualTo(rowCount + 3));172        }173        [Test]174        public void RenderExpected_MoreThanSampleRowsCountButLessThanMaxRowsCountWithSpecificProfileNone_ReturnEachRowAndHeaderAndSeparation()175        {176            var rowCount = 120;177            var threshold = rowCount - 20;178            var max = threshold / 2;179            var dataSet = new DataSet();180            var dataTable = new DataTable() { TableName = "MyTable" };181            dataTable.Columns.Add(new DataColumn("Id"));182            dataTable.Columns.Add(new DataColumn("Numeric value"));183            dataTable.Columns.Add(new DataColumn("Boolean value"));184            for (int i = 0; i < rowCount; i++)185                dataTable.LoadDataRow(new object[] { "Alpha", i, true }, false);186            var profile = Mock.Of<IFailureReportProfile>(p =>187                p.MaxSampleItem == max188                && p.ThresholdSampleItem == threshold189                && p.ExpectedSet == FailureReportSetType.None190            );191            var samplers = new SamplersFactory<DataRow>().Instantiate(profile);192            var msg = new DataRowsMessageMarkdown(EngineStyle.ByIndex, samplers);193            msg.BuildComparaison(dataTable.Rows.Cast<DataRow>(), null, null);194            var value = msg.RenderExpected();195            var lines = value.Replace("\n", string.Empty).Split('\r');196            Assert.That(lines.Count(l => l.Contains("|")), Is.EqualTo(0));197            Assert.That(lines, Has.All.EqualTo("Display skipped."));198        }199        [Test]200        public void RenderExpected_MoreThanMaxRowsCount_ReturnCorrectCountOfSkippedRow()201        {202            var dataTable = new DataTable() { TableName = "MyTable" };203            dataTable.Columns.Add(new DataColumn("Id"));204            dataTable.Columns.Add(new DataColumn("Numeric value"));205            dataTable.Columns.Add(new DataColumn("Boolean value"));206            for (int i = 0; i < 22; i++)207                dataTable.LoadDataRow(new object[] { "Alpha", i, true }, false);208            var samplers = new SamplersFactory<DataRow>().Instantiate(FailureReportProfile.Default);209            var msg = new DataRowsMessageMarkdown(EngineStyle.ByIndex, samplers);210            msg.BuildComparaison(dataTable.Rows.Cast<DataRow>(), null, null);211            var value = msg.RenderExpected();212            var lines = value.Replace("\n", string.Empty).Split('\r');213            //Not exactly the last line but the previous due to paragraph rendering.214            var lastLine = lines.Reverse().ElementAt(1);215            Assert.That(lastLine, Is.EqualTo("12 (of 22) rows have been skipped for display purpose."));216        }217        [Test]218        [TestCase(5)]219        [TestCase(12)]220        public void RenderExpected_LessThanMaxRowsCount_DoesntDisplaySkippedRow(int rowCount)221        {222            var dataTable = new DataTable() { TableName = "MyTable" };223            dataTable.Columns.Add(new DataColumn("Id"));224            dataTable.Columns.Add(new DataColumn("Numeric value"));225            dataTable.Columns.Add(new DataColumn("Boolean value"));226            for (int i = 0; i < rowCount; i++)227                dataTable.LoadDataRow(new object[] { "Alpha", i, true }, false);228            var samplers = new SamplersFactory<DataRow>().Instantiate(FailureReportProfile.Default);229            var msg = new DataRowsMessageMarkdown(EngineStyle.ByIndex, samplers);230            msg.BuildComparaison(dataTable.Rows.Cast<DataRow>(), null, null);231            var value = msg.RenderExpected();232            Assert.That(value, Does.Not.Contain("rows have been skipped for display purpose."));233        }234        [Test]235        [TestCase(0, 5, 5, 5, 5, "Missing rows:")]236        [TestCase(5, 0, 5, 5, 5, "Unexpected rows:")]237        [TestCase(5, 5, 0, 5, 5, "Duplicated rows:")]238        [TestCase(5, 5, 5, 5, 0, "Non matching value rows:")]239        public void RenderCompared_NoSpecialRows_DoesntDisplayTextForThisKindOfRows(240            int missingRowCount241            , int unexpectedRowCount242            , int duplicatedRowCount243            , int keyMatchingRowCount244            , int nonMatchingValueRowCount245            , string unexpectedText)...

DataRowsMessageMarkdown.cs

Source:DataRowsMessageMarkdown.cs

...98        protected Paragraph BuildRowCount(int rowCount)99        {100            return ($"Result-set with {rowCount} row{(rowCount > 1 ? "s" : string.Empty)}".ToMarkdownParagraph());101        }102        public string RenderExpected()103        {104            if (samplers["expected"] is NoneSampler<DataRow>)105                return "Display skipped.";106            else107                return expected?.ToMarkdown();108        }109        public string RenderActual()110        {111            if (samplers["actual"] is NoneSampler<DataRow>)112                return "Display skipped.";113            else114                return actual.ToMarkdown();115        }116        public string RenderAnalysis()117        {118            if (samplers["analysis"] is NoneSampler<DataRow>)119                return "Display skipped.";120            else121                return analysis.ToMarkdown();122        }123        public string RenderMessage()124        {125            var sb = new StringBuilder();126            sb.AppendLine("Execution of the query doesn't match the expected result");127            sb.AppendLine();128            sb.AppendLine(RenderExpected());129            sb.AppendLine();130            sb.AppendLine(RenderActual());131            sb.AppendLine();132            sb.AppendLine(RenderAnalysis());133            return sb.ToString();134        }135    }136}...

RenderExpected

Using AI Code Generation

1var dataRowsMessage = new DataRowsMessageMarkdown();2dataRowsMessage.RenderExpected();3var dataRowsMessage = new DataRowsMessageMarkdown();4dataRowsMessage.RenderExpected();5var dataRowsMessage = new DataRowsMessageMarkdown();6dataRowsMessage.RenderExpected();7var dataRowsMessage = new DataRowsMessageMarkdown();8dataRowsMessage.RenderExpected();9var dataRowsMessage = new DataRowsMessageMarkdown();10dataRowsMessage.RenderExpected();11var dataRowsMessage = new DataRowsMessageMarkdown();12dataRowsMessage.RenderExpected();13var dataRowsMessage = new DataRowsMessageMarkdown();14dataRowsMessage.RenderExpected();15var dataRowsMessage = new DataRowsMessageMarkdown();16dataRowsMessage.RenderExpected();17var dataRowsMessage = new DataRowsMessageMarkdown();18dataRowsMessage.RenderExpected();19var dataRowsMessage = new DataRowsMessageMarkdown();20dataRowsMessage.RenderExpected();21var dataRowsMessage = new DataRowsMessageMarkdown();22dataRowsMessage.RenderExpected();

RenderExpected

Using AI Code Generation

1NBi.Framework.FailureMessage.Markdown.DataRowsMessageMarkdown dataRowsMessageMarkdown = new NBi.Framework.FailureMessage.Markdown.DataRowsMessageMarkdown();2dataRowsMessageMarkdown.RenderExpected(dataRows)3NBi.Framework.FailureMessage.Markdown.DataRowsMessageMarkdown dataRowsMessageMarkdown = new NBi.Framework.FailureMessage.Markdown.DataRowsMessageMarkdown();4dataRowsMessageMarkdown.RenderActual(dataRows)5NBi.Framework.FailureMessage.Markdown.DataRowsMessageMarkdown dataRowsMessageMarkdown = new NBi.Framework.FailureMessage.Markdown.DataRowsMessageMarkdown();6dataRowsMessageMarkdown.RenderExpected(dataRows)7NBi.Framework.FailureMessage.Markdown.DataRowsMessageMarkdown dataRowsMessageMarkdown = new NBi.Framework.FailureMessage.Markdown.DataRowsMessageMarkdown();8dataRowsMessageMarkdown.RenderActual(dataRows)9NBi.Framework.FailureMessage.Markdown.DataRowsMessageMarkdown dataRowsMessageMarkdown = new NBi.Framework.FailureMessage.Markdown.DataRowsMessageMarkdown();10dataRowsMessageMarkdown.RenderExpected(dataRows)11NBi.Framework.FailureMessage.Markdown.DataRowsMessageMarkdown dataRowsMessageMarkdown = new NBi.Framework.FailureMessage.Markdown.DataRowsMessageMarkdown();12dataRowsMessageMarkdown.RenderActual(dataRows)13NBi.Framework.FailureMessage.Markdown.DataRowsMessageMarkdown dataRowsMessageMarkdown = new NBi.Framework.FailureMessage.Markdown.DataRowsMessageMarkdown();14dataRowsMessageMarkdown.RenderExpected(dataRows)15NBi.Framework.FailureMessage.Markdown.DataRowsMessageMarkdown dataRowsMessageMarkdown = new NBi.Framework.FailureMessage.Markdown.DataRowsMessageMarkdown();16dataRowsMessageMarkdown.RenderActual(data

RenderExpected

Using AI Code Generation

1var expected = new DataTable();2expected.Columns.Add("id", typeof(int));3expected.Columns.Add("name", typeof(string));4expected.Rows.Add(1, "John");5expected.Rows.Add(2, "Jane");6expected.Rows.Add(3, "Jack");7var actual = new DataTable();8actual.Columns.Add("id", typeof(int));9actual.Columns.Add("name", typeof(string));10actual.Rows.Add(1, "John");11actual.Rows.Add(2, "Jane");12actual.Rows.Add(3, "Jack");13var message = new NBi.Framework.FailureMessage.Markdown.DataRowsMessageMarkdown();14message.RenderExpected(expected);15message.RenderActual(actual);16var expected = new DataTable();17expected.Columns.Add("id", typeof(int));18expected.Columns.Add("name", typeof(string));19expected.Rows.Add(1, "John");20expected.Rows.Add(2, "Jane");21expected.Rows.Add(3, "Jack");22var actual = new DataTable();23actual.Columns.Add("id", typeof(int));24actual.Columns.Add("name", typeof(string));25actual.Rows.Add(1, "John");26actual.Rows.Add(2, "Jane");27actual.Rows.Add(3, "Jack");28var message = new NBi.Framework.FailureMessage.Markdown.DataRowsMessageMarkdown();29message.RenderExpected(expected);30message.RenderActual(actual);31var expected = new DataTable();32expected.Columns.Add("id", typeof(int));33expected.Columns.Add("name", typeof(string));34expected.Rows.Add(1, "John");35expected.Rows.Add(2, "Jane");36expected.Rows.Add(3, "Jack");37var actual = new DataTable();38actual.Columns.Add("id", typeof(int));39actual.Columns.Add("name", typeof(string));40actual.Rows.Add(1, "John");41actual.Rows.Add(2, "Jane");42actual.Rows.Add(3, "Jack");43var message = new NBi.Framework.FailureMessage.Markdown.DataRowsMessageMarkdown();44message.RenderExpected(expected);45message.RenderActual(actual);46var expected = new DataTable();47expected.Columns.Add("id", typeof(int));48expected.Columns.Add("name", typeof(string));49expected.Rows.Add(1,

RenderExpected

Using AI Code Generation

1using System;2using System.Data;3using System.Collections.Generic;4using NBi.Core.ResultSet;5using NBi.Core.ResultSet.Resolver;6using NBi.Core.ResultSet.Alteration.Projection;7using NBi.Core.ResultSet.Alteration.Duplication;8using NBi.Core.ResultSet.Alteration.Duplication.Strategy;9using NBi.Core.ResultSet.Alteration.Renaming;10using NBi.Core.ResultSet.Alteration.Renaming.Strategy;11using NBi.Core.ResultSet.Alteration.Extension;12using NBi.Core.ResultSet.Alteration.Extension.Strategy;13using NBi.Core.ResultSet.Alteration.Extension.Conjunction;14using NBi.Core.ResultSet.Alteration.Extension.Conjunction.Strategy;15using NBi.Core.ResultSet.Alteration.Extension.Conjunction.Naming;16using NBi.Core.ResultSet.Alteration.Extension.Conjunction.Naming.Strategy;17using NBi.Core.ResultSet.Alteration.Extension.Conjunction.Naming.Format;18using NBi.Core.ResultSet.Alteration.Extension.Conjunction.Naming.Format.Strategy;19using NBi.Core.ResultSet.Alteration.Extension.Conjunction.Naming.Format.Casing;20using NBi.Core.ResultSet.Alteration.Extension.Conjunction.Naming.Format.Casing.Strategy;21using NBi.Core.ResultSet.Alteration.Extension.Conjunction.Naming.Format.Casing.Culture;22using NBi.Core.ResultSet.Alteration.Extension.Conjunction.Naming.Format.Casing.Culture.Strategy;23using NBi.Core.ResultSet.Alteration.Extension.Conjunction.Naming.Format.Casing.Culture.Strategy;24using NBi.Core.ResultSet.Alteration.Extension.Conjunction.Naming.Format.Casing.Culture.Strategy;25using NBi.Core.ResultSet.Alteration.Extension.Conjunction.Naming.Format.Casing.Culture.Strategy;26using NBi.Core.ResultSet.Alteration.Extension.Conjunction.Naming.Format.Casing.Culture.Strategy;27using NBi.Core.ResultSet.Alteration.Extension.Conjunction.Naming.Format.Casing.Culture.Strategy;28using NBi.Core.ResultSet.Alteration.Extension.Conjunction.Naming.Format.Casing.Culture.Strategy;29using NBi.Core.ResultSet.Alteration.Extension.Conjunction.Naming.Format.Casing.Culture.Strategy;30using NBi.Core.ResultSet.Alteration.Extension.Conjunction.Naming.Format.Casing.Culture.Strategy;31using NBi.Core.ResultSet.Alteration.Extension.Conjunction.Naming.Format.Casing.Culture.Strategy;32using NBi.Core.ResultSet.Alteration.Extension.Conjunction.Naming.Format.Casing.Culture.Strategy;33using NBi.Core.ResultSet.Alteration.Extension.Conjunction.Naming.Format.Casing.Culture.Strategy;34using NBi.Core.ResultSet.Alteration.Extension.Conjunction.Naming.Format.Casing.Culture.Strategy;

RenderExpected

Using AI Code Generation

1var expected = new DataTable();2expected.Columns.Add("id", typeof(int));3expected.Columns.Add("name", typeof(string));4expected.Rows.Add(1, "ABC");5expected.Rows.Add(2, "DEF");6var failure = new NBi.NUnit.Runtime.Failure.DataRowsMessage(expected, null);7var markdown = new NBi.Framework.FailureMessage.Markdown.DataRowsMessageMarkdown(failure);8Console.WriteLine(markdown.RenderExpected());9var actual = new DataTable();10actual.Columns.Add("id", typeof(int));11actual.Columns.Add("name", typeof(string));12actual.Rows.Add(1, "ABC");13actual.Rows.Add(2, "GHI");14var failure = new NBi.NUnit.Runtime.Failure.DataRowsMessage(null, actual);15var markdown = new NBi.Framework.FailureMessage.Markdown.DataRowsMessageMarkdown(failure);16Console.WriteLine(markdown.RenderActual());17var expected = new DataTable();18expected.Columns.Add("id", typeof(int));19expected.Columns.Add("name", typeof(string));20expected.Rows.Add(1, "ABC");21expected.Rows.Add(2, "DEF");22var actual = new DataTable();23actual.Columns.Add("id", typeof(int));24actual.Columns.Add("name", typeof(string));25actual.Rows.Add(1, "ABC");26actual.Rows.Add(2, "GHI");27var failure = new NBi.NUnit.Runtime.Failure.DataRowsMessage(expected, actual);28var markdown = new NBi.Framework.FailureMessage.Markdown.DataRowsMessageMarkdown(failure);29Console.WriteLine(markdown.RenderExpected());30Console.WriteLine(markdown.RenderActual());

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.