Index: packages/charted/test.disabled/charts/transformers/aggregation_transformer_test.dart |
diff --git a/packages/charted/test.disabled/charts/transformers/aggregation_transformer_test.dart b/packages/charted/test.disabled/charts/transformers/aggregation_transformer_test.dart |
new file mode 100644 |
index 0000000000000000000000000000000000000000..7616c196cc79de674533f3164938d35a2dbc4304 |
--- /dev/null |
+++ b/packages/charted/test.disabled/charts/transformers/aggregation_transformer_test.dart |
@@ -0,0 +1,381 @@ |
+/* |
+ * Copyright 2014 Google Inc. All rights reserved. |
+ * |
+ * Use of this source code is governed by a BSD-style |
+ * license that can be found in the LICENSE file or at |
+ * https://developers.google.com/open-source/licenses/bsd |
+ */ |
+library charted.test.aggregationtransformer; |
+ |
+import 'package:charted/charts/charts.dart'; |
+import 'package:charted/core/utils.dart'; |
+import 'package:unittest/unittest.dart'; |
+import 'package:observe/observe.dart'; |
+ |
+main() { |
+ List COLUMNS = [ |
+ new ChartColumnSpec(label:'Continent', type:ChartColumnSpec.TYPE_STRING), |
+ new ChartColumnSpec(label:'Country', type:ChartColumnSpec.TYPE_STRING), |
+ new ChartColumnSpec(label:'City', type:ChartColumnSpec.TYPE_STRING), |
+ new ChartColumnSpec(label:'Stats1'), |
+ new ChartColumnSpec(label:'Stats2'), |
+ new ChartColumnSpec(label:'Stats3') |
+ ]; |
+ |
+ const List DATA = const [ |
+ const['America', 'USA', 'LA', 4.51, 7, 1000], |
+ const['America', 'USA', 'SF', 9.50, 50, 2000], |
+ const['Asia', 'Japan', 'Tokyo', 1.50, 99, 2000], |
+ const['Asia', 'Japan', 'Kyoto', 5.10, 66, 4000], |
+ const['Asia', 'Taiwan', 'Taipei', 3.50, 127, 1337], |
+ const['Asia', 'Japan', 'Osaka', 4.50, 19, 2000], |
+ const['Asia', 'Taiwan', 'Tainan', 1.50, 10, 100], |
+ const['Europe', 'France', 'Nice', 2.50, 29, 6000], |
+ const['Europe', 'France', 'Paris', 6.50, 129, 3000], |
+ const['Europe', 'Germany', 'Berlin', 10.99, 999, 10000], |
+ const['Europe', 'England', 'London', 2.50, 10, 3000], |
+ const['America', 'USA', 'NY', 3.50, 17, 4000], |
+ const['America', 'Brazil', 'Brasilia', 1.50, 27, 6000], |
+ const['America', 'Argentina', 'Buenos Aires', 5.50, 37, 2000], |
+ const['America', 'Brazil', 'Rio de Janeiro', 2.50, 52, 3000], |
+ ]; |
+ |
+ ChartData inputData = new ChartData(COLUMNS, DATA); |
+ |
+ test('Sum aggregation all dimension collapsed', () { |
+ AggregationTransformer transformer = new AggregationTransformer([0, 1, 2], |
+ [3, 4, 5]); |
+ ChartData result = transformer.transform(inputData); |
+ // Expected data: |
+ // [America, , , 27.0, 190.0, 18000.0] |
+ // [Asia, , , 16.1, 321.0, 9437.0] |
+ // [Europe, , , 22.49, 1167.0, 22000.0] |
+ |
+ // America |
+ expect(result.rows.elementAt(0).elementAt(3), closeTo(27.01, EPSILON)); |
+ expect(result.rows.elementAt(0).elementAt(4), equals(190)); |
+ expect(result.rows.elementAt(0).elementAt(5), equals(18000)); |
+ |
+ // Asia |
+ expect(result.rows.elementAt(1).elementAt(3), closeTo(16.1, EPSILON)); |
+ expect(result.rows.elementAt(1).elementAt(4), equals(321)); |
+ expect(result.rows.elementAt(1).elementAt(5), equals(9437)); |
+ |
+ // Europe |
+ expect(result.rows.elementAt(2).elementAt(3), closeTo(22.49, EPSILON)); |
+ expect(result.rows.elementAt(2).elementAt(4), equals(1167)); |
+ expect(result.rows.elementAt(2).elementAt(5), equals(22000)); |
+ }); |
+ |
+ test('Sum aggregation expanding America in continent dimension', () { |
+ AggregationTransformer transformer = new AggregationTransformer([0, 1, 2], |
+ [3, 4, 5]); |
+ transformer.expand(['America']); |
+ ChartData result = transformer.transform(inputData); |
+ |
+ // Expected data: |
+ // [America, Argentina, , 5.5, 37.0, 2000.0] |
+ // [America, Brazil, , 4.0, 79.0, 9000.0] |
+ // [America, USA, , 17.51, 74.0, 7000.0] |
+ // [Asia, , , 16.1, 321.0, 9437.0] |
+ // [Europe, , , 22.49, 1167.0, 22000.0] |
+ |
+ // America |
+ expect(result.rows.elementAt(0).elementAt(3), closeTo(5.5, EPSILON)); |
+ expect(result.rows.elementAt(0).elementAt(4), equals(37)); |
+ expect(result.rows.elementAt(0).elementAt(5), equals(2000)); |
+ expect(result.rows.elementAt(1).elementAt(3), closeTo(4, EPSILON)); |
+ expect(result.rows.elementAt(1).elementAt(4), equals(79)); |
+ expect(result.rows.elementAt(1).elementAt(5), equals(9000)); |
+ expect(result.rows.elementAt(2).elementAt(3), closeTo(17.51, EPSILON)); |
+ expect(result.rows.elementAt(2).elementAt(4), equals(74)); |
+ expect(result.rows.elementAt(2).elementAt(5), equals(7000)); |
+ |
+ // Asia |
+ expect(result.rows.elementAt(3).elementAt(3), closeTo(16.1, EPSILON)); |
+ expect(result.rows.elementAt(3).elementAt(4), equals(321)); |
+ expect(result.rows.elementAt(3).elementAt(5), equals(9437)); |
+ |
+ // Europe |
+ expect(result.rows.elementAt(4).elementAt(3), closeTo(22.49, EPSILON)); |
+ expect(result.rows.elementAt(4).elementAt(4), equals(1167)); |
+ expect(result.rows.elementAt(4).elementAt(5), equals(22000)); |
+ }); |
+ |
+ test('Sum aggregation expanding [America, Brazil] in continent/country '+ |
+ 'dimension', () { |
+ AggregationTransformer transformer = new AggregationTransformer([0, 1, 2], |
+ [3, 4, 5]); |
+ transformer.expand(['America']); |
+ transformer.expand(['America', 'Brazil']); |
+ ChartData result = transformer.transform(inputData); |
+ |
+ // Expected data: |
+ // [America, Argentina, , 5.5, 37.0, 2000.0] |
+ // [America, Brazil, 'Brasilia, 1.50, 27, 6000] |
+ // [America, Brazil, 'Rio de Janeiro, 2.50, 52, 3000] |
+ // [America, USA, , 17.51, 74.0, 7000.0] |
+ // [Asia, , , 16.1, 321.0, 9437.0] |
+ // [Europe, , , 22.49, 1167.0, 22000.0] |
+ |
+ // America Argentina |
+ expect(result.rows.elementAt(0).elementAt(3), closeTo(5.5, EPSILON)); |
+ expect(result.rows.elementAt(0).elementAt(4), equals(37)); |
+ expect(result.rows.elementAt(0).elementAt(5), equals(2000)); |
+ |
+ // America Brazil Brasilia |
+ expect(result.rows.elementAt(1).elementAt(3), closeTo(1.5, EPSILON)); |
+ expect(result.rows.elementAt(1).elementAt(4), equals(27)); |
+ expect(result.rows.elementAt(1).elementAt(5), equals(6000)); |
+ |
+ // America Brazil Rio de Janeiro |
+ expect(result.rows.elementAt(2).elementAt(3), closeTo(2.5, EPSILON)); |
+ expect(result.rows.elementAt(2).elementAt(4), equals(52)); |
+ expect(result.rows.elementAt(2).elementAt(5), equals(3000)); |
+ |
+ // America USA |
+ expect(result.rows.elementAt(3).elementAt(3), closeTo(17.51, EPSILON)); |
+ expect(result.rows.elementAt(3).elementAt(4), equals(74)); |
+ expect(result.rows.elementAt(3).elementAt(5), equals(7000)); |
+ |
+ // Asia |
+ expect(result.rows.elementAt(4).elementAt(3), closeTo(16.1, EPSILON)); |
+ expect(result.rows.elementAt(4).elementAt(4), equals(321)); |
+ expect(result.rows.elementAt(4).elementAt(5), equals(9437)); |
+ |
+ // Europe |
+ expect(result.rows.elementAt(5).elementAt(3), closeTo(22.49, EPSILON)); |
+ expect(result.rows.elementAt(5).elementAt(4), equals(1167)); |
+ expect(result.rows.elementAt(5).elementAt(5), equals(22000)); |
+ }); |
+ |
+ test('Collapsing parent of expanded dimension should collapse dimension', () { |
+ AggregationTransformer transformer = new AggregationTransformer([0, 1, 2], |
+ [3, 4, 5]); |
+ transformer.expand(['America']); |
+ transformer.expand(['America', 'Brazil']); |
+ transformer.collapse(['America']); |
+ ChartData result = transformer.transform(inputData); |
+ |
+ // Expected data: |
+ // [America, , , 27.0, 190.0, 18000.0] |
+ // [Asia, , , 16.1, 321.0, 9437.0] -- not tested in this case |
+ // [Europe, , , 22.49, 1167.0, 22000.0] -- not tested in this case |
+ |
+ // America |
+ expect(result.rows.elementAt(0).elementAt(3), closeTo(27.01, EPSILON)); |
+ expect(result.rows.elementAt(0).elementAt(4), equals(190)); |
+ expect(result.rows.elementAt(0).elementAt(5), equals(18000)); |
+ }); |
+ |
+ test('Expanding the lowest dimension should be ignored', () { |
+ AggregationTransformer transformer = new AggregationTransformer([0, 1, 2], |
+ [3, 4, 5]); |
+ transformer.expand(['America']); |
+ transformer.expand(['America', 'Brazil']); |
+ transformer.expand(['America', 'Brazil', 'Brasilia']); |
+ ChartData result = transformer.transform(inputData); |
+ |
+ // Expected data: |
+ // [America, Argentina, , 5.5, 37.0, 2000.0] |
+ // [America, Brazil, 'Brasilia, 1.50, 27, 6000] |
+ // [America, Brazil, 'Rio de Janeiro, 2.50, 52, 3000] |
+ // [America, USA, , 17.51, 74.0, 7000.0] |
+ // [Asia, , , 16.1, 321.0, 9437.0] -- not tested in this case |
+ // [Europe, , , 22.49, 1167.0, 22000.0] -- not tested in this case |
+ |
+ // America Argentina |
+ expect(result.rows.elementAt(0).elementAt(3), closeTo(5.5, EPSILON)); |
+ expect(result.rows.elementAt(0).elementAt(4), equals(37)); |
+ expect(result.rows.elementAt(0).elementAt(5), equals(2000)); |
+ |
+ // America Brazil Brasilia |
+ expect(result.rows.elementAt(1).elementAt(3), closeTo(1.5, EPSILON)); |
+ expect(result.rows.elementAt(1).elementAt(4), equals(27)); |
+ expect(result.rows.elementAt(1).elementAt(5), equals(6000)); |
+ |
+ // America Brazil Rio de Janeiro |
+ expect(result.rows.elementAt(2).elementAt(3), closeTo(2.5, EPSILON)); |
+ expect(result.rows.elementAt(2).elementAt(4), equals(52)); |
+ expect(result.rows.elementAt(2).elementAt(5), equals(3000)); |
+ |
+ // America USA |
+ expect(result.rows.elementAt(3).elementAt(3), closeTo(17.51, EPSILON)); |
+ expect(result.rows.elementAt(3).elementAt(4), equals(74)); |
+ expect(result.rows.elementAt(3).elementAt(5), equals(7000)); |
+ }); |
+ |
+ test('Expanding the multiple dimension at different level', () { |
+ AggregationTransformer transformer = new AggregationTransformer([0, 1, 2], |
+ [3, 4, 5]); |
+ transformer.expand(['Asia']); |
+ transformer.expand(['Asia', 'Taiwan']); |
+ transformer.expand(['Asia', 'Japan', 'Osaka']); |
+ transformer.expand(['Europe']); |
+ transformer.collapse(['Asia', 'Japan']); |
+ ChartData result = transformer.transform(inputData); |
+ |
+ |
+ // Expected data: |
+ // [America, , , 27.0, 190.0, 18000.0] |
+ // [Asia, Japan, , 10.10, 184.0, 8000.0] |
+ // [Asia, Taiwan, Tainan, 1.50, 10.0, 100.0] |
+ // [Asia, Taiwan, Taipei, 3.50, 127.0, 1337.0] |
+ // [Europe, England, , 2.50, 10.0, 3000.0] |
+ // [Europe, France, , 9.00, 158.0, 9000.0] |
+ // [Europe, Germany, , 10.99, 999.0, 10000.0] |
+ |
+ // America |
+ expect(result.rows.elementAt(0).elementAt(3), closeTo(27.01, EPSILON)); |
+ expect(result.rows.elementAt(0).elementAt(4), equals(190)); |
+ expect(result.rows.elementAt(0).elementAt(5), equals(18000)); |
+ |
+ // Asia Japan |
+ expect(result.rows.elementAt(1).elementAt(3), closeTo(11.1, EPSILON)); |
+ expect(result.rows.elementAt(1).elementAt(4), equals(184)); |
+ expect(result.rows.elementAt(1).elementAt(5), equals(8000)); |
+ |
+ // Asia Taiwan Tainan |
+ expect(result.rows.elementAt(2).elementAt(3), closeTo(1.5, EPSILON)); |
+ expect(result.rows.elementAt(2).elementAt(4), equals(10)); |
+ expect(result.rows.elementAt(2).elementAt(5), equals(100)); |
+ |
+ // Asia Taiwan Taipei |
+ expect(result.rows.elementAt(3).elementAt(3), closeTo(3.5, EPSILON)); |
+ expect(result.rows.elementAt(3).elementAt(4), equals(127)); |
+ expect(result.rows.elementAt(3).elementAt(5), equals(1337)); |
+ |
+ // Europe England |
+ expect(result.rows.elementAt(4).elementAt(3), closeTo(2.5, EPSILON)); |
+ expect(result.rows.elementAt(4).elementAt(4), equals(10)); |
+ expect(result.rows.elementAt(4).elementAt(5), equals(3000)); |
+ |
+ // Europe France |
+ expect(result.rows.elementAt(5).elementAt(3), closeTo(9, EPSILON)); |
+ expect(result.rows.elementAt(5).elementAt(4), equals(158)); |
+ expect(result.rows.elementAt(5).elementAt(5), equals(9000)); |
+ |
+ // Europe Germany |
+ expect(result.rows.elementAt(6).elementAt(3), closeTo(10.99, EPSILON)); |
+ expect(result.rows.elementAt(6).elementAt(4), equals(999)); |
+ expect(result.rows.elementAt(6).elementAt(5), equals(10000)); |
+ }); |
+ |
+ test('Expanding the multiple dimension at different level', () { |
+ AggregationTransformer transformer = new AggregationTransformer([0, 1, 2], |
+ [3, 4, 5]); |
+ transformer.expand(['Asia']); |
+ transformer.expand(['Asia', 'Taiwan']); |
+ transformer.expand(['Asia', 'Japan', 'Osaka']); |
+ transformer.expand(['Europe']); |
+ transformer.collapse(['Asia', 'Japan']); |
+ |
+ ChartData result = transformer.transform(inputData); |
+ |
+ |
+ // Expected data: |
+ // [America, , , 27.0, 190.0, 18000.0] |
+ // [Asia, Japan, , 10.10, 184.0, 8000.0] |
+ // [Asia, Taiwan, Tainan, 1.50, 10.0, 100.0] |
+ // [Asia, Taiwan, Taipei, 3.50, 127.0, 1337.0] |
+ // [Europe, England, , 2.50, 10.0, 3000.0] |
+ // [Europe, France, , 9.00, 158.0, 9000.0] |
+ // [Europe, Germany, , 10.99, 999.0, 10000.0] |
+ |
+ transformer.expandAll(); |
+ |
+ // America |
+ expect(result.rows.elementAt(0).elementAt(3), closeTo(27.01, EPSILON)); |
+ expect(result.rows.elementAt(0).elementAt(4), equals(190)); |
+ expect(result.rows.elementAt(0).elementAt(5), equals(18000)); |
+ |
+ // Asia Japan |
+ expect(result.rows.elementAt(1).elementAt(3), closeTo(11.1, EPSILON)); |
+ expect(result.rows.elementAt(1).elementAt(4), equals(184)); |
+ expect(result.rows.elementAt(1).elementAt(5), equals(8000)); |
+ |
+ // Asia Taiwan Tainan |
+ expect(result.rows.elementAt(2).elementAt(3), closeTo(1.5, EPSILON)); |
+ expect(result.rows.elementAt(2).elementAt(4), equals(10)); |
+ expect(result.rows.elementAt(2).elementAt(5), equals(100)); |
+ |
+ // Asia Taiwan Taipei |
+ expect(result.rows.elementAt(3).elementAt(3), closeTo(3.5, EPSILON)); |
+ expect(result.rows.elementAt(3).elementAt(4), equals(127)); |
+ expect(result.rows.elementAt(3).elementAt(5), equals(1337)); |
+ |
+ // Europe England |
+ expect(result.rows.elementAt(4).elementAt(3), closeTo(2.5, EPSILON)); |
+ expect(result.rows.elementAt(4).elementAt(4), equals(10)); |
+ expect(result.rows.elementAt(4).elementAt(5), equals(3000)); |
+ |
+ // Europe France |
+ expect(result.rows.elementAt(5).elementAt(3), closeTo(9, EPSILON)); |
+ expect(result.rows.elementAt(5).elementAt(4), equals(158)); |
+ expect(result.rows.elementAt(5).elementAt(5), equals(9000)); |
+ |
+ // Europe Germany |
+ expect(result.rows.elementAt(6).elementAt(3), closeTo(10.99, EPSILON)); |
+ expect(result.rows.elementAt(6).elementAt(4), equals(999)); |
+ expect(result.rows.elementAt(6).elementAt(5), equals(10000)); |
+ }); |
+ |
+ test('Grouping by country-continent-city with less fact columns', () { |
+ AggregationTransformer transformer = new AggregationTransformer([1, 2, 0], |
+ [5, 3]); |
+ |
+ ChartData result = transformer.transform(inputData); |
+ |
+ // Expected data: |
+ // [Argentina, , , 2000.0, 5.50] |
+ // [Brazil, , , 9000.0, 4.00] |
+ // [England, , , 3000.0, 2.50] |
+ // [France, , , 9000.0, 9.00] |
+ // more entries not listed/tested.. |
+ // Argentian |
+ expect(result.rows.elementAt(0).elementAt(3), equals(2000)); |
+ expect(result.rows.elementAt(0).elementAt(4), closeTo(5.5, EPSILON)); |
+ |
+ // Brazil |
+ expect(result.rows.elementAt(1).elementAt(3), equals(9000)); |
+ expect(result.rows.elementAt(1).elementAt(4), closeTo(4, EPSILON)); |
+ |
+ // England |
+ expect(result.rows.elementAt(2).elementAt(3), equals(3000)); |
+ expect(result.rows.elementAt(2).elementAt(4), closeTo(2.5, EPSILON)); |
+ |
+ // France |
+ expect(result.rows.elementAt(3).elementAt(3), equals(9000)); |
+ expect(result.rows.elementAt(3).elementAt(4), closeTo(9, EPSILON)); |
+ }); |
+ |
+ |
+ test('Modifying data row when it is an ObeservableList should cause ' + |
+ 'transform to be called', () { |
+ ObservableList observableRows = new ObservableList.from(DATA); |
+ ChartData observableData = new ChartData(COLUMNS, observableRows); |
+ AggregationTransformer aggrTransformer = new AggregationTransformer( |
+ [1, 2, 0], [5, 3]); |
+ |
+ ChartData result = aggrTransformer.transform(observableData); |
+ // Result at this point: |
+ // [Argentina, , , 2000.0, 5.50] |
+ // [Brazil, , , 9000.0, 4.00] |
+ // [England, , , 3000.0, 2.50] |
+ // [France, , , 9000.0, 9.00] |
+ // ... |
+ |
+ // Remove Brazil, Rio de Janeiro from the original data, causing aggregation |
+ // of stats1 for Brazil to drop from 4 to 1.5 and stats3 from 9000 to 6000. |
+ observableRows.remove(observableRows.last); |
+ observableRows.deliverListChanges(); |
+ (observableData as Observable).deliverChanges(); |
+ |
+ // [Argentina, , , 2000.0, 5.50] |
+ // [Brazil, , , 6000.0, 2.50] |
+ expect(result.rows.elementAt(0).elementAt(3), equals(2000)); |
+ expect(result.rows.elementAt(0).elementAt(4), closeTo(5.5, EPSILON)); |
+ expect(result.rows.elementAt(1).elementAt(3), equals(6000)); |
+ expect(result.rows.elementAt(1).elementAt(4), closeTo(1.5, EPSILON)); |
+ }); |
+} |