public void Filter_Distinct_EmptyContent() { var manager = new TestCaseManager(); //Setup content; manager.Content.Columns.Add(new DataColumn("columnName")); manager.Variables.Add("columnName"); manager.Content.AcceptChanges(); //Setup filter manager.FilterDistinct(); Assert.That(manager.Content.Rows, Has.Count.EqualTo(0)); }
public void Filter_EqualWithoutMatch_EmptyContent() { var manager = new TestCaseManager(); //Setup content; manager.Content.Columns.Add(new DataColumn("columnName")); manager.Variables.Add("columnName"); var nonMatchingRow1 = manager.Content.NewRow(); nonMatchingRow1[0] = "abc"; var nonMatchingRow2 = manager.Content.NewRow(); nonMatchingRow2[0] = "xyz"; manager.Content.Rows.Add(nonMatchingRow1); manager.Content.Rows.Add(nonMatchingRow2); manager.Content.AcceptChanges(); //Setup filter manager.Filter("columnName", Operator.Equal, false, "matching"); Assert.That(manager.Content.Rows, Has.Count.EqualTo(0)); }
public void Filter_EqualMultipleValues_CorrectNewContent() { var manager = new TestCaseManager(); //Setup content; manager.Content.Columns.Add(new DataColumn("columnName")); manager.Variables.Add("columnName"); var matchingRow1 = manager.Content.NewRow(); matchingRow1[0] = "matching 1"; var matchingRow2 = manager.Content.NewRow(); matchingRow2[0] = "matching 2"; var nonMatchingRow = manager.Content.NewRow(); nonMatchingRow[0] = "xyz"; manager.Content.Rows.Add(matchingRow1); manager.Content.Rows.Add(matchingRow2); manager.Content.Rows.Add(nonMatchingRow); manager.Content.AcceptChanges(); //Setup filter manager.Filter("columnName", Operator.Equal, false, new [] {"matching 1", "matching 2"}); Assert.That(manager.Content.Rows, Has.Count.EqualTo(2)); Assert.That(manager.Content.Rows[0][0], Is.EqualTo("matching 1")); Assert.That(manager.Content.Rows[1][0], Is.EqualTo("matching 2")); }
public void Filter_Distinct_CorrectNewContent() { var manager = new TestCaseManager(); //Setup content; manager.Content.Columns.Add(new DataColumn("columnName")); manager.Variables.Add("columnName"); var firstRow = manager.Content.NewRow(); firstRow[0] = "alpha"; var secondRow = manager.Content.NewRow(); secondRow[0] = "beta"; var duplicatedRow = manager.Content.NewRow(); duplicatedRow[0] = "alpha"; manager.Content.Rows.Add(firstRow); manager.Content.Rows.Add(secondRow); manager.Content.Rows.Add(duplicatedRow); manager.Content.AcceptChanges(); //Setup filter manager.FilterDistinct(); Assert.That(manager.Content.Rows, Has.Count.EqualTo(2)); Assert.That(manager.Content.Rows[0][0], Is.EqualTo("alpha")); Assert.That(manager.Content.Rows[1][0], Is.EqualTo("beta")); }
public void Filter_NotEqual_CorrectNewContent() { var manager = new TestCaseManager(); //Setup content; manager.Content.Columns.Add(new DataColumn("columnName")); manager.Variables.Add("columnName"); var matchingRow = manager.Content.NewRow(); matchingRow[0] = "matching"; var nonMatchingRow = manager.Content.NewRow(); nonMatchingRow[0] = "xyz"; manager.Content.Rows.Add(matchingRow); manager.Content.Rows.Add(nonMatchingRow); manager.Content.AcceptChanges(); //Setup filter manager.Filter("columnName", Operator.Equal, true, "matching"); Assert.That(manager.Content.Rows, Has.Count.EqualTo(1)); Assert.That(manager.Content.Rows[0][0], Is.Not.EqualTo("matching")); }