public void TestFilterFilledTable() { var rawTable = TestTableHelper.CreateReactiveTable(); AddRow(rawTable, 1, "Blah1", 123.123m); Assert.AreEqual(1, rawTable.RowCount); AddRow(rawTable, 2, "Blah2", 123.123m); Assert.AreEqual(2, rawTable.RowCount); var filteredTable = rawTable.Filter(new TestPredicate(new List <string> { TestTableColumns.IdColumn }, false)); var updateHandler = new RowUpdateHandler(); filteredTable.Subscribe(updateHandler); Assert.AreEqual(0, filteredTable.RowCount); Assert.AreEqual(0, updateHandler.CurrentRowCount); var filteredTable2 = rawTable.Filter(new TestPredicate(new List <string> { TestTableColumns.IdColumn }, true)); var updateHandler2 = new RowUpdateHandler(); filteredTable2.Subscribe(updateHandler2); Assert.AreEqual(2, filteredTable2.RowCount); // No updates will be fired as existing rows are processed in the constructor Assert.AreEqual(0, updateHandler2.CurrentRowCount); }
public void TestGroupByOnExistingValues() { // Create group by var baseTable = TestTableHelper.CreateReactiveTable(); // Add values var row1 = baseTable.AddRow(); baseTable.SetValue(TestTableColumns.StringColumn, row1, "Value1"); var row2 = baseTable.AddRow(); baseTable.SetValue(TestTableColumns.StringColumn, row2, "Value2"); var row3 = baseTable.AddRow(); baseTable.SetValue(TestTableColumns.StringColumn, row3, "Value1"); // Modify grouped columns baseTable.SetValue(TestTableColumns.StringColumn, row2, "Value1"); baseTable.SetValue(TestTableColumns.StringColumn, row3, "Value3"); // Now group it var groupedTable = new AggregatedTable(baseTable); groupedTable.GroupBy <string>(TestTableColumns.StringColumn); var countCol = "CountCol"; groupedTable.AddAggregate((IReactiveColumn <string>)baseTable.GetColumnByName(TestTableColumns.StringColumn), countCol, () => new Count <string>()); var rowUpdates = new RowUpdateHandler(); groupedTable.Subscribe(rowUpdates); var colUpdates = new ColumnUpdateHandler(); groupedTable.Subscribe(colUpdates.OnColumnUpdate); groupedTable.FinishInitialisation(); Assert.AreEqual(2, groupedTable.RowCount); Assert.AreEqual(2, rowUpdates.CurrentRowCount); Assert.AreEqual("Value1", groupedTable.GetValue <string>(TestTableColumns.StringColumn, 0)); Assert.AreEqual("Value3", groupedTable.GetValue <string>(TestTableColumns.StringColumn, 1)); Assert.AreEqual(2, groupedTable.GetValue <int>(countCol, 0)); Assert.AreEqual(1, groupedTable.GetValue <int>(countCol, 1)); // Remove rows baseTable.DeleteRow(row1); Assert.AreEqual(2, groupedTable.RowCount); Assert.AreEqual(2, rowUpdates.CurrentRowCount); baseTable.DeleteRow(row2); Assert.AreEqual(1, groupedTable.RowCount); Assert.AreEqual(1, rowUpdates.CurrentRowCount); baseTable.DeleteRow(row3); Assert.AreEqual(0, groupedTable.RowCount); Assert.AreEqual(0, rowUpdates.CurrentRowCount); }
public void TestWithCalculatedColumns() { var baseTable = TestTableHelper.CreateReactiveTable(); var groupedTable = new AggregatedTable(baseTable); var column = groupedTable.GroupBy <string>(TestTableColumns.StringColumn); var rowUpdates = new RowUpdateHandler(); groupedTable.Subscribe(rowUpdates); var colUpdates = new ColumnUpdateHandler(); groupedTable.Subscribe(colUpdates.OnColumnUpdate); var groupedColumn = (IReactiveColumn <string>)column; const string groupedCalc1 = "Grouped.Calc1"; groupedTable.AddColumn(new ReactiveCalculatedColumn1 <string, string>(groupedCalc1, groupedColumn, s => s + "Calc")); var row1 = baseTable.AddRow(); baseTable.SetValue(TestTableColumns.StringColumn, row1, "Value1"); Assert.AreEqual(1, groupedTable.RowCount); Assert.AreEqual(1, rowUpdates.CurrentRowCount); Assert.AreEqual("Value1", groupedTable.GetValue <string>(TestTableColumns.StringColumn, colUpdates.LastRowUpdated)); Assert.AreEqual("Value1Calc", groupedTable.GetValue <string>(groupedCalc1, colUpdates.LastRowUpdated)); var row2 = baseTable.AddRow(); baseTable.SetValue(TestTableColumns.StringColumn, row2, "Value3"); Assert.AreEqual(2, groupedTable.RowCount); Assert.AreEqual(2, rowUpdates.CurrentRowCount); Assert.AreEqual("Value3", groupedTable.GetValue <string>(TestTableColumns.StringColumn, colUpdates.LastRowUpdated)); Assert.AreEqual("Value3Calc", groupedTable.GetValue <string>(groupedCalc1, colUpdates.LastRowUpdated)); var row3 = baseTable.AddRow(); baseTable.SetValue(TestTableColumns.StringColumn, row3, "Value3"); Assert.AreEqual(2, groupedTable.RowCount); Assert.AreEqual(2, rowUpdates.CurrentRowCount); Assert.AreEqual("Value3", groupedTable.GetValue <string>(TestTableColumns.StringColumn, colUpdates.LastRowUpdated)); Assert.AreEqual("Value3Calc", groupedTable.GetValue <string>(groupedCalc1, colUpdates.LastRowUpdated)); baseTable.SetValue(TestTableColumns.StringColumn, row1, "Value2"); Assert.AreEqual(2, groupedTable.RowCount); Assert.AreEqual(2, rowUpdates.CurrentRowCount); Assert.AreEqual("Value2", groupedTable.GetValue <string>(TestTableColumns.StringColumn, colUpdates.LastRowUpdated)); Assert.AreEqual("Value2Calc", groupedTable.GetValue <string>(groupedCalc1, colUpdates.LastRowUpdated)); }
public void TestRowUpdates() { // Create group by var baseTable = TestTableHelper.CreateReactiveTable(); var groupedTable = new AggregatedTable(baseTable); var rowUpdates = new RowUpdateHandler(); groupedTable.Subscribe(rowUpdates); var colUpdates = new ColumnUpdateHandler(); groupedTable.Subscribe(colUpdates.OnColumnUpdate); groupedTable.GroupBy <string>(TestTableColumns.StringColumn); var countColumn = "Aggregate.Count"; groupedTable.AddAggregate((IReactiveColumn <string>)baseTable.GetColumnByName(TestTableColumns.StringColumn), countColumn, () => new Count <string>()); var row1 = baseTable.AddRow(); baseTable.SetValue(TestTableColumns.StringColumn, row1, "Value1"); Assert.AreEqual(1, groupedTable.RowCount); Assert.AreEqual(1, groupedTable.GetValue <int>(countColumn, 0)); var row2 = baseTable.AddRow(); baseTable.SetValue(TestTableColumns.StringColumn, row2, "Value1"); Assert.AreEqual(1, groupedTable.RowCount); Assert.AreEqual(2, groupedTable.GetValue <int>(countColumn, 0)); var row3 = baseTable.AddRow(); baseTable.SetValue(TestTableColumns.StringColumn, row3, "Value2"); Assert.AreEqual(2, groupedTable.RowCount); Assert.AreEqual(2, groupedTable.GetValue <int>(countColumn, 0)); Assert.AreEqual(1, groupedTable.GetValue <int>(countColumn, 1)); baseTable.SetValue(TestTableColumns.StringColumn, row2, "Value2"); Assert.AreEqual(2, groupedTable.RowCount); Assert.AreEqual(1, groupedTable.GetValue <int>(countColumn, 0)); Assert.AreEqual(2, groupedTable.GetValue <int>(countColumn, 1)); Assert.AreEqual(2, rowUpdates.CurrentRowCount); CheckRowUpdate(rowUpdates, 0, 0, TableUpdateAction.Add); CheckRowUpdate(rowUpdates, 1, 1, TableUpdateAction.Add); CheckRowUpdate(rowUpdates, 1, 2, TableUpdateAction.Delete); CheckRowUpdate(rowUpdates, 1, 3, TableUpdateAction.Add); }
public void TestGroupByWithCount() { // Create group by var baseTable = TestTableHelper.CreateReactiveTable(); var groupedTable = new AggregatedTable(baseTable); var rowUpdates = new RowUpdateHandler(); groupedTable.Subscribe(rowUpdates); var colUpdates = new ColumnUpdateHandler(); groupedTable.Subscribe(colUpdates.OnColumnUpdate); groupedTable.GroupBy <string>(TestTableColumns.StringColumn); var countColumn = "Aggregate.Count"; groupedTable.AddAggregate((IReactiveColumn <string>)baseTable.GetColumnByName(TestTableColumns.StringColumn), countColumn, () => new Count <string>()); var row1 = baseTable.AddRow(); baseTable.SetValue(TestTableColumns.StringColumn, row1, "Value1"); Assert.AreEqual(1, groupedTable.RowCount); Assert.AreEqual(1, groupedTable.GetValue <int>(countColumn, 0)); var row2 = baseTable.AddRow(); baseTable.SetValue(TestTableColumns.StringColumn, row2, "Value1"); Assert.AreEqual(1, groupedTable.RowCount); Assert.AreEqual(2, groupedTable.GetValue <int>(countColumn, 0)); var row3 = baseTable.AddRow(); baseTable.SetValue(TestTableColumns.StringColumn, row3, "Value2"); Assert.AreEqual(2, groupedTable.RowCount); Assert.AreEqual(2, groupedTable.GetValue <int>(countColumn, 0)); Assert.AreEqual(1, groupedTable.GetValue <int>(countColumn, 1)); baseTable.SetValue(TestTableColumns.StringColumn, row2, "Value2"); Assert.AreEqual(2, groupedTable.RowCount); Assert.AreEqual(1, groupedTable.GetValue <int>(countColumn, 0)); Assert.AreEqual(2, groupedTable.GetValue <int>(countColumn, 1)); // Change it to the same value again and check that nothing changes baseTable.SetValue(TestTableColumns.StringColumn, row2, "Value2"); Assert.AreEqual(2, groupedTable.RowCount); Assert.AreEqual(1, groupedTable.GetValue <int>(countColumn, 0)); Assert.AreEqual(2, groupedTable.GetValue <int>(countColumn, 1)); }
public void TestChangingFilterFilledTable() { var rawTable = TestTableHelper.CreateReactiveTable(); bool[] visible = { true }; var filteredTable = (FilteredTable)rawTable.Filter( new DelegatePredicate1 <string>(TestTableColumns.StringColumn, s => visible[0])); var updateHandler = new RowUpdateHandler(); filteredTable.Subscribe(updateHandler); AddRow(rawTable, 1, "Blah1", 123.123m); Assert.AreEqual(1, rawTable.RowCount); Assert.AreEqual(1, filteredTable.RowCount); Assert.AreEqual(1, updateHandler.CurrentRowCount); Assert.AreEqual("Blah1", filteredTable.GetValue <string>(TestTableColumns.StringColumn, updateHandler.LastRowUpdated)); AddRow(rawTable, 2, "Blah2", 123.123m); Assert.AreEqual(2, rawTable.RowCount); Assert.AreEqual(2, filteredTable.RowCount); Assert.AreEqual(2, updateHandler.CurrentRowCount); Assert.AreEqual("Blah2", filteredTable.GetValue <string>(TestTableColumns.StringColumn, updateHandler.LastRowUpdated)); visible[0] = false; filteredTable.PredicateChanged(); Assert.AreEqual(2, rawTable.RowCount); Assert.AreEqual(0, filteredTable.RowCount); Assert.AreEqual(0, updateHandler.CurrentRowCount); visible[0] = true; filteredTable.PredicateChanged(); Assert.AreEqual(2, rawTable.RowCount); Assert.AreEqual(2, filteredTable.RowCount); Assert.AreEqual(2, updateHandler.CurrentRowCount); visible[0] = false; filteredTable.PredicateChanged(); Assert.AreEqual(2, rawTable.RowCount); Assert.AreEqual(0, filteredTable.RowCount); Assert.AreEqual(0, updateHandler.CurrentRowCount); }
public void TestExistingRowsBug() { var rawTable = TestTableHelper.CreateReactiveTable(); AddRow(rawTable, 1, "Foo1", 1); AddRow(rawTable, 2, "Foo2", 2); AddRow(rawTable, 3, "Foo3", 3); decimal[] filter = { 0 }; var filteredTable = (FilteredTable)rawTable.Filter(new DelegatePredicate1 <decimal>( TestTableColumns.DecimalColumn, s => s > filter[0])); var updateHandler = new RowUpdateHandler(); filteredTable.Subscribe(updateHandler); AddRow(rawTable, 4, "Foo4", 4); AddRow(rawTable, 5, "Foo5", 5); Assert.AreEqual(5, filteredTable.RowCount); filter[0] = 50; filteredTable.PredicateChanged(); Assert.AreEqual(0, filteredTable.RowCount); AddRow(rawTable, 6, "Foo6", 6); filter[0] = 3; filteredTable.PredicateChanged(); Assert.AreEqual(3, filteredTable.RowCount); AddRow(rawTable, 7, "Foo7", 7); Assert.AreEqual(4, filteredTable.RowCount); filter[0] = 50; filteredTable.PredicateChanged(); Assert.AreEqual(0, filteredTable.RowCount); filter[0] = 2; filteredTable.PredicateChanged(); Assert.AreEqual(5, filteredTable.RowCount); }
public void TestExclusionFilter() { var rawTable = TestTableHelper.CreateReactiveTable(); var filteredTable = rawTable.Filter(new TestPredicate(new List <string> { TestTableColumns.IdColumn }, false)); var updateHandler = new RowUpdateHandler(); filteredTable.Subscribe(updateHandler); AddRow(rawTable, 1, "Blah1", 123.123m); Assert.AreEqual(1, rawTable.RowCount); Assert.AreEqual(0, filteredTable.RowCount); Assert.AreEqual(0, updateHandler.CurrentRowCount); AddRow(rawTable, 2, "Blah2", 123.123m); Assert.AreEqual(2, rawTable.RowCount); Assert.AreEqual(0, filteredTable.RowCount); Assert.AreEqual(0, updateHandler.CurrentRowCount); }
public void TestOneColumnFilter() { var rawTable = TestTableHelper.CreateReactiveTable(); var filteredTable = rawTable.Filter( new DelegatePredicate1 <string>(TestTableColumns.StringColumn, s => !string.IsNullOrEmpty(s) && s.EndsWith("2"))); var updateHandler = new RowUpdateHandler(); filteredTable.Subscribe(updateHandler); AddRow(rawTable, 1, "Blah1", 123.123m); Assert.AreEqual(1, rawTable.RowCount); Assert.AreEqual(0, filteredTable.RowCount); Assert.AreEqual(0, updateHandler.CurrentRowCount); AddRow(rawTable, 2, "Blah2", 123.123m); Assert.AreEqual(2, rawTable.RowCount); Assert.AreEqual(1, filteredTable.RowCount); Assert.AreEqual(1, updateHandler.CurrentRowCount); Assert.AreEqual("Blah2", filteredTable.GetValue <string>(TestTableColumns.StringColumn, updateHandler.LastRowUpdated)); }
public void TestNullFilter() { var rawTable = TestTableHelper.CreateReactiveTable(); var filteredTable = rawTable.Filter(new TestPredicate(new List <string> { TestTableColumns.IdColumn }, true)); var updateHandler = new RowUpdateHandler(); filteredTable.Subscribe(updateHandler); AddRow(rawTable, 1, "Blah1", 123.123m); Assert.AreEqual(1, rawTable.RowCount); Assert.AreEqual(1, filteredTable.RowCount); Assert.AreEqual(1, updateHandler.CurrentRowCount); Assert.AreEqual("Blah1", filteredTable.GetValue <string>(TestTableColumns.StringColumn, updateHandler.LastRowUpdated)); AddRow(rawTable, 2, "Blah2", 123.123m); Assert.AreEqual(2, rawTable.RowCount); Assert.AreEqual(2, filteredTable.RowCount); Assert.AreEqual(2, updateHandler.CurrentRowCount); Assert.AreEqual("Blah2", filteredTable.GetValue <string>(TestTableColumns.StringColumn, updateHandler.LastRowUpdated)); }
public void TestGroupByMultipleColumns() { // Create group by var baseTable = TestTableHelper.CreateReactiveTable(); var groupedTable = new AggregatedTable(baseTable); groupedTable.GroupBy <string>(TestTableColumns.StringColumn); groupedTable.GroupBy <int>(TestTableColumns.IdColumn); var rowUpdates = new RowUpdateHandler(); groupedTable.Subscribe(rowUpdates); var colUpdates = new ColumnUpdateHandler(); groupedTable.Subscribe(colUpdates.OnColumnUpdate); // Add values var row1 = baseTable.AddRow(); baseTable.SetValue(TestTableColumns.StringColumn, row1, "Value1"); Assert.AreEqual(1, groupedTable.RowCount); Assert.AreEqual(1, rowUpdates.CurrentRowCount); Assert.AreEqual("Value1", groupedTable.GetValue <string>(TestTableColumns.StringColumn, colUpdates.LastRowUpdated)); baseTable.SetValue(TestTableColumns.IdColumn, row1, 42); Assert.AreEqual(1, groupedTable.RowCount); Assert.AreEqual(1, rowUpdates.CurrentRowCount); Assert.AreEqual(42L, groupedTable.GetValue <int>(TestTableColumns.IdColumn, colUpdates.LastRowUpdated)); baseTable.SetValue(TestTableColumns.StringColumn, row1, "Value2"); Assert.AreEqual("Value2", groupedTable.GetValue <string>(TestTableColumns.StringColumn, colUpdates.LastRowUpdated)); baseTable.SetValue(TestTableColumns.IdColumn, row1, 43); Assert.AreEqual(43, groupedTable.GetValue <int>(TestTableColumns.IdColumn, colUpdates.LastRowUpdated)); }
private static void CheckRowUpdate(RowUpdateHandler rowUpdates, int rowIndex, int updateIndex, TableUpdateAction updateType) { Assert.AreEqual(rowIndex, rowUpdates.RowUpdates[updateIndex].RowIndex); Assert.AreEqual(updateType, rowUpdates.RowUpdates[updateIndex].Action); }
public void TestGroupByWithAverage() { // Create group by var baseTable = TestTableHelper.CreateReactiveTable(); var groupedTable = new AggregatedTable(baseTable); var rowUpdates = new RowUpdateHandler(); groupedTable.Subscribe(rowUpdates); var colUpdates = new ColumnUpdateHandler(); groupedTable.Subscribe(colUpdates.OnColumnUpdate); groupedTable.GroupBy <string>(TestTableColumns.StringColumn); var avgColumn = "Aggregate.Sum"; groupedTable.AddAggregate((IReactiveColumn <int>)baseTable.GetColumnByName(TestTableColumns.IdColumn), avgColumn, () => new Average <int>()); var avgColumn2 = "Aggregate.DecimalSum"; groupedTable.AddAggregate((IReactiveColumn <decimal>)baseTable.GetColumnByName(TestTableColumns.DecimalColumn), avgColumn2, () => new Average <decimal>()); var row1 = baseTable.AddRow(); baseTable.SetValue(TestTableColumns.StringColumn, row1, "Value1"); baseTable.SetValue(TestTableColumns.IdColumn, row1, 10); baseTable.SetValue(TestTableColumns.DecimalColumn, row1, 2.5m); Assert.AreEqual(1, groupedTable.RowCount); Assert.AreEqual(10.0, groupedTable.GetValue <double>(avgColumn, 0)); Assert.AreEqual(2.5, groupedTable.GetValue <double>(avgColumn2, 0)); var row2 = baseTable.AddRow(); baseTable.SetValue(TestTableColumns.StringColumn, row2, "Value1"); baseTable.SetValue(TestTableColumns.IdColumn, row2, 20); baseTable.SetValue(TestTableColumns.DecimalColumn, row2, 4.5m); Assert.AreEqual(1, groupedTable.RowCount); Assert.AreEqual(15.0, groupedTable.GetValue <double>(avgColumn, 0)); Assert.AreEqual(3.5, groupedTable.GetValue <double>(avgColumn2, 0)); var row3 = baseTable.AddRow(); baseTable.SetValue(TestTableColumns.StringColumn, row3, "Value2"); baseTable.SetValue(TestTableColumns.IdColumn, row3, 15); baseTable.SetValue(TestTableColumns.DecimalColumn, row3, 1.5m); Assert.AreEqual(2, groupedTable.RowCount); Assert.AreEqual(15.0, groupedTable.GetValue <double>(avgColumn, 0)); Assert.AreEqual(15.0, groupedTable.GetValue <double>(avgColumn, 1)); Assert.AreEqual(3.5, groupedTable.GetValue <double>(avgColumn2, 0)); Assert.AreEqual(1.5, groupedTable.GetValue <double>(avgColumn2, 1)); baseTable.SetValue(TestTableColumns.IdColumn, row2, 25); baseTable.SetValue(TestTableColumns.DecimalColumn, row2, 5.5m); Assert.AreEqual(2, groupedTable.RowCount); Assert.AreEqual(17.5, groupedTable.GetValue <double>(avgColumn, 0)); Assert.AreEqual(4.0, groupedTable.GetValue <double>(avgColumn2, 0)); // Now change the membership in the groups baseTable.SetValue(TestTableColumns.StringColumn, row2, "Value2"); Assert.AreEqual(10, groupedTable.GetValue <double>(avgColumn, 0)); Assert.AreEqual(20, groupedTable.GetValue <double>(avgColumn, 1)); Assert.AreEqual(2.5, groupedTable.GetValue <double>(avgColumn2, 0)); Assert.AreEqual(3.5, groupedTable.GetValue <double>(avgColumn2, 1)); }
public void TestGroupByOneColumn() { // Create group by var baseTable = TestTableHelper.CreateReactiveTable(); var groupedTable = new AggregatedTable(baseTable); groupedTable.GroupBy <string>(TestTableColumns.StringColumn); var rowUpdates = new RowUpdateHandler(); groupedTable.Subscribe(rowUpdates); var colUpdates = new ColumnUpdateHandler(); groupedTable.Subscribe(colUpdates.OnColumnUpdate); // Add values var row1 = baseTable.AddRow(); baseTable.SetValue(TestTableColumns.StringColumn, row1, "Value1"); Assert.AreEqual(1, groupedTable.RowCount); Assert.AreEqual(1, rowUpdates.CurrentRowCount); Assert.AreEqual("Value1", groupedTable.GetValue <string>(TestTableColumns.StringColumn, colUpdates.LastRowUpdated)); var row2 = baseTable.AddRow(); baseTable.SetValue(TestTableColumns.StringColumn, row2, "Value2"); Assert.AreEqual(2, groupedTable.RowCount); Assert.AreEqual(2, rowUpdates.CurrentRowCount); Assert.AreEqual("Value2", groupedTable.GetValue <string>(TestTableColumns.StringColumn, colUpdates.LastRowUpdated)); var row3 = baseTable.AddRow(); baseTable.SetValue(TestTableColumns.StringColumn, row3, "Value1"); Assert.AreEqual(2, groupedTable.RowCount); Assert.AreEqual(2, rowUpdates.CurrentRowCount); Assert.AreEqual("Value1", groupedTable.GetValue <string>(TestTableColumns.StringColumn, colUpdates.LastRowUpdated)); // Modify grouped columns baseTable.SetValue(TestTableColumns.StringColumn, row2, "Value1"); Assert.AreEqual(1, groupedTable.RowCount); Assert.AreEqual(1, rowUpdates.CurrentRowCount); Assert.AreEqual("Value1", groupedTable.GetValue <string>(TestTableColumns.StringColumn, colUpdates.LastRowUpdated)); baseTable.SetValue(TestTableColumns.StringColumn, row3, "Value3"); Assert.AreEqual(2, groupedTable.RowCount); Assert.AreEqual(2, rowUpdates.CurrentRowCount); Assert.AreEqual("Value3", groupedTable.GetValue <string>(TestTableColumns.StringColumn, colUpdates.LastRowUpdated)); // Remove rows baseTable.DeleteRow(row1); Assert.AreEqual(2, groupedTable.RowCount); Assert.AreEqual(2, rowUpdates.CurrentRowCount); baseTable.DeleteRow(row2); Assert.AreEqual(1, groupedTable.RowCount); Assert.AreEqual(1, rowUpdates.CurrentRowCount); baseTable.DeleteRow(row3); Assert.AreEqual(0, groupedTable.RowCount); Assert.AreEqual(0, rowUpdates.CurrentRowCount); }
public void TestFilterJoinedTable() { IWritableReactiveTable table1, table2; var rawTable = TestTableHelper.CreateJoinedReactiveTable(out table1, out table2); bool[] visible = { true }; var filteredTable = (FilteredTable)rawTable.Filter( new DelegatePredicate1 <string>(TestTableColumns.StringColumn, s => visible[0])); var updateHandler = new RowUpdateHandler(); filteredTable.Subscribe(updateHandler); AddRow(table1, 1, "Blah1", 123.123m); Assert.AreEqual(1, rawTable.RowCount); Assert.AreEqual(1, filteredTable.RowCount); Assert.AreEqual(1, updateHandler.CurrentRowCount); Assert.AreEqual("Blah1", filteredTable.GetValue <string>(TestTableColumns.StringColumn, updateHandler.LastRowUpdated)); AddRow2(table2, 11, 1, "Other1", 321.21m); Assert.AreEqual(1, rawTable.RowCount); Assert.AreEqual(1, filteredTable.RowCount); Assert.AreEqual(1, updateHandler.CurrentRowCount); Assert.AreEqual("Other1", filteredTable.GetValue <string>(TestTableColumns.StringColumn2, updateHandler.LastRowUpdated)); AddRow(table1, 2, "Blah2", 123.123m); Assert.AreEqual(2, rawTable.RowCount); Assert.AreEqual(2, filteredTable.RowCount); Assert.AreEqual(2, updateHandler.CurrentRowCount); Assert.AreEqual("Blah2", filteredTable.GetValue <string>(TestTableColumns.StringColumn, updateHandler.LastRowUpdated)); AddRow2(table2, 12, 2, "Other2", 321.21m); Assert.AreEqual(2, rawTable.RowCount); Assert.AreEqual(2, filteredTable.RowCount); Assert.AreEqual(2, updateHandler.CurrentRowCount); Assert.AreEqual("Other2", filteredTable.GetValue <string>(TestTableColumns.StringColumn2, updateHandler.LastRowUpdated)); visible[0] = false; filteredTable.PredicateChanged(); AddRow2(table2, 13, 3, "Other3", 321.21m); Assert.AreEqual(3, rawTable.RowCount); Assert.AreEqual(0, filteredTable.RowCount); Assert.AreEqual(0, updateHandler.CurrentRowCount); Assert.AreEqual(3, rawTable.RowCount); Assert.AreEqual(0, filteredTable.RowCount); Assert.AreEqual(0, updateHandler.CurrentRowCount); AddRow(table1, 3, "Blah3", 123.123m); Assert.AreEqual(3, rawTable.RowCount); Assert.AreEqual(0, filteredTable.RowCount); Assert.AreEqual(0, updateHandler.CurrentRowCount); visible[0] = true; filteredTable.PredicateChanged(); Assert.AreEqual(3, rawTable.RowCount); Assert.AreEqual(3, filteredTable.RowCount); Assert.AreEqual(3, updateHandler.CurrentRowCount); Assert.AreEqual("Blah3", filteredTable.GetValue <string>(TestTableColumns.StringColumn, updateHandler.LastRowUpdated)); Assert.AreEqual("Other3", filteredTable.GetValue <string>(TestTableColumns.StringColumn2, updateHandler.LastRowUpdated)); AddRow(table1, 4, "Blah4", 123.123m); Assert.AreEqual(4, rawTable.RowCount); Assert.AreEqual(4, filteredTable.RowCount); Assert.AreEqual(4, updateHandler.CurrentRowCount); Assert.AreEqual("Blah4", filteredTable.GetValue <string>(TestTableColumns.StringColumn, updateHandler.LastRowUpdated)); visible[0] = false; filteredTable.PredicateChanged(); AddRow2(table2, 14, 4, "Other4", 321.21m); Assert.AreEqual(4, rawTable.RowCount); Assert.AreEqual(0, filteredTable.RowCount); Assert.AreEqual(0, updateHandler.CurrentRowCount); AddRow2(table2, 15, 5, "Other5", 321.21m); Assert.AreEqual(5, rawTable.RowCount); Assert.AreEqual(0, filteredTable.RowCount); Assert.AreEqual(0, updateHandler.CurrentRowCount); AddRow(table1, 5, "Blah5", 123.123m); Assert.AreEqual(5, rawTable.RowCount); Assert.AreEqual(0, filteredTable.RowCount); Assert.AreEqual(0, updateHandler.CurrentRowCount); visible[0] = true; filteredTable.PredicateChanged(); Assert.AreEqual(5, rawTable.RowCount); Assert.AreEqual(5, filteredTable.RowCount); Assert.AreEqual(5, updateHandler.CurrentRowCount); Assert.AreEqual("Blah5", filteredTable.GetValue <string>(TestTableColumns.StringColumn, updateHandler.LastRowUpdated)); Assert.AreEqual("Other5", filteredTable.GetValue <string>(TestTableColumns.StringColumn2, updateHandler.LastRowUpdated)); AddRow(table1, 6, "Blah6", 123.123m); Assert.AreEqual(6, rawTable.RowCount); Assert.AreEqual(6, filteredTable.RowCount); Assert.AreEqual(6, updateHandler.CurrentRowCount); Assert.AreEqual("Blah6", filteredTable.GetValue <string>(TestTableColumns.StringColumn, updateHandler.LastRowUpdated)); }