Esempio n. 1
0
        public SimpleGroupTestViewModel()
        {
            _table1 = new ReactiveTable();
            var groupColumn = new ReactiveColumn <string>(GroupColumnId);

            _table1.AddColumn(groupColumn);
            var valueColumn = new ReactiveColumn <int>(ValueColumnId);

            _table1.AddColumn(valueColumn);
//            ReactiveTable table2 = new ReactiveTable();
//            table2.AddColumn(new ReactiveColumn<string>("GroupColumn2"));
//            table2.AddColumn(new ReactiveColumn<int>("ValueColumn2"));

            _groupedTable = new AggregatedTable(_table1);
            _groupedTable.GroupBy <string>(groupColumn.ColumnId);
            _groupedTable.AddAggregate(groupColumn, CountColumnId, () => new Count <string>());
            _groupedTable.AddAggregate(valueColumn, SumColumnId, () => new Sum <int>());
            _groupedTable.AddAggregate(valueColumn, AverageColumnId, () => new Average <int>());
            _groupedTable.AddAggregate(valueColumn, MinColumnId, () => new Min <int>());
            _groupedTable.AddAggregate(valueColumn, MaxColumnId, () => new Max <int>());

            LoadDataCommand = new DelegateCommand(LoadData);
            Items           = new ObservableCollection <SimpleGroupItem>();

            _groupedTable.RowUpdates().Subscribe(OnRowUpdate);
        }
Esempio n. 2
0
        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 GroupTestViewModel(IAccountBalanceDataService service)
        {
            var accountsTable = service.Accounts;

            _groupedAccounts = new AggregatedTable(accountsTable);
            _groupedAccounts.GroupBy <int>(AccountColumns.PersonId);
            var balanceColumn = (IReactiveColumn <decimal>)accountsTable.GetColumnByName(AccountColumns.AccountBalance);

            _groupedAccounts.AddAggregate(balanceColumn, SumColumnId, () => new Sum <decimal>());
            _groupedAccounts.AddAggregate(balanceColumn, CountColumnId, () => new Count <decimal>());
            _groupedAccounts.FinishInitialisation();

            var groups = new IndexedObservableCollection <BalanceGroup, int>(g => g.RowIndex);

            _groupedAccounts.ReplayAndSubscribe(
                update =>
            {
                if (update.Action == TableUpdateAction.Add)
                {
                    groups.Add(new BalanceGroup(_groupedAccounts, update.RowIndex));
                }
                else if (update.Action == TableUpdateAction.Delete)
                {
                    groups.RemoveAt(groups.GetIndexForKey(update.RowIndex));
                }
            });

            var accounts = new IndexedObservableCollection <AccountViewModel, int>(a => a.RowIndex);

            accountsTable.ReplayAndSubscribe(
                update =>
            {
                if (update.Action == TableUpdateAction.Add)
                {
                    var accountViewModel = new AccountViewModel(accountsTable, update.RowIndex);
                    accounts.Add(accountViewModel);
                    Debug.WriteLine("{1},Adding,,{0},", update.RowIndex, DateTime.Now.ToLongTimeString());
                }
                else if (update.Action == TableUpdateAction.Delete)
                {
                    var indexForKey      = accounts.GetIndexForKey(update.RowIndex);
                    var accountViewModel = accounts[indexForKey];
                    accounts.RemoveAt(indexForKey);
                    Debug.WriteLine("{1},Removing,{0}", accountViewModel.PersonId, DateTime.Now.ToLongTimeString());
                }
                else
                {
                    var indexForKey      = accounts.GetIndexForKey(update.RowIndex);
                    var accountViewModel = accounts[indexForKey];
                    Debug.WriteLine("{1},Modifying,{0},{2},{3}",
                                    accountViewModel.PersonId, DateTime.Now.ToLongTimeString(), update.RowIndex, update.Column.ColumnId);
                }
            });
            Groups   = groups;
            Accounts = accounts;
        }
Esempio n. 4
0
        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 GroupTestViewModelSyncfusion(IAccountBalanceDataService service)
        {
            var accountsTable   = service.Accounts;
            var groupedAccounts = new AggregatedTable(accountsTable);

            groupedAccounts.GroupBy <int>(AccountColumns.PersonId);
            var balanceColumn = (IReactiveColumn <decimal>)accountsTable.GetColumnByName(AccountColumns.AccountBalance);

            groupedAccounts.AddAggregate(balanceColumn, GroupTestViewModel.SumColumnId, () => new Sum <decimal>());
            groupedAccounts.AddAggregate(balanceColumn, GroupTestViewModel.CountColumnId, () => new Count <decimal>());
            groupedAccounts.FinishInitialisation();
            SetTable(groupedAccounts);
        }
Esempio n. 6
0
        public void TestGrouping()
        {
            var table1        = new ReactiveTable();
            var GroupColumnId = "GroupCol";
            var groupColumn   = new ReactiveColumn <string>(GroupColumnId);

            table1.AddColumn(groupColumn);
            var ValueColumnId  = "ValueCol";
            var reactiveColumn = new ReactiveColumn <int>(ValueColumnId);
            var valueColumn    = reactiveColumn;

            table1.AddColumn(valueColumn);
            //            ReactiveTable table2 = new ReactiveTable();
            //            table2.AddColumn(new ReactiveColumn<string>("GroupColumn2"));
            //            table2.AddColumn(new ReactiveColumn<int>("ValueColumn2"));

            var groupedTable = new AggregatedTable(table1);

            groupedTable.GroupBy <string>(groupColumn.ColumnId);
            var CountColumnId = "Count";

            groupedTable.AddAggregate(groupColumn, CountColumnId, () => new Count <string>());
            var SumColumnId = "Sum";

            groupedTable.AddAggregate(valueColumn, SumColumnId, () => new Sum <int>());
            var AverageColumnId = "Average";

            groupedTable.AddAggregate(valueColumn, AverageColumnId, () => new Average <int>());
            var MinColumnId = "Min";

            groupedTable.AddAggregate(valueColumn, MinColumnId, () => new Min <int>());
            var MaxColumnId = "Max";

            groupedTable.AddAggregate(valueColumn, MaxColumnId, () => new Max <int>());

            RunTest(
                count =>
            {
                for (var i = 0; i < count; i++)
                {
                    var name1 = "Mendel" + i;
                    var name2 = "Marie" + i;
                    AddRow(name1, 42, table1, GroupColumnId, ValueColumnId);
                    AddRow(name2, 43, table1, GroupColumnId, ValueColumnId);
                    AddRow(name1, 44, table1, GroupColumnId, ValueColumnId);
                    AddRow(name2, 45, table1, GroupColumnId, ValueColumnId);
                    AddRow(name1, 46, table1, GroupColumnId, ValueColumnId);
                    AddRow(name2, 45, table1, GroupColumnId, ValueColumnId);
                }
            }, 10000);
        }
Esempio n. 7
0
        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);
        }
Esempio n. 8
0
        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));
        }
Esempio n. 9
0
        public void TestColumnsAdded()
        {
            var baseTable    = TestTableHelper.CreateReactiveTable();
            var groupedTable = new AggregatedTable(baseTable);

            groupedTable.GroupBy <string>(TestTableColumns.StringColumn);
            groupedTable.AddAggregate((IReactiveColumn <string>)groupedTable.GetColumnByName(TestTableColumns.StringColumn),
                                      "Test",
                                      () => new Count <string>());

            Assert.AreEqual(2, groupedTable.Columns.Count);
            Assert.AreEqual(TestTableColumns.StringColumn, groupedTable.Columns.First().ColumnId);
            Assert.AreEqual("Test", groupedTable.Columns.Skip(1).First().ColumnId);
        }
Esempio n. 10
0
        public GroupedTableTest(int?drainTableLimit = null)
        {
            _drainTableLimit = drainTableLimit;
            _table1          = new ReactiveTable();
            var groupColumn = new ReactiveColumn <string>(GroupColumnId);

            _table1.AddColumn(groupColumn);
            var valueColumn = new ReactiveColumn <int>(ValueColumnId);

            _table1.AddColumn(valueColumn);

            var groupedTable = new AggregatedTable(_table1);

            groupedTable.GroupBy <string>(groupColumn.ColumnId);
            groupedTable.AddAggregate(groupColumn, CountColumnId, () => new Count <string>());
            groupedTable.AddAggregate(valueColumn, SumColumnId, () => new Sum <int>());
            groupedTable.AddAggregate(valueColumn, AverageColumnId, () => new Average <int>());
            groupedTable.AddAggregate(valueColumn, MinColumnId, () => new Min <int>());
            groupedTable.AddAggregate(valueColumn, MaxColumnId, () => new Max <int>());
        }
Esempio n. 11
0
        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));
        }
Esempio n. 12
0
        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));
        }
Esempio n. 13
0
        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);
        }