Package com.google.visualization.datasource.datatable

Examples of com.google.visualization.datasource.datatable.ColumnDescription

452
453
454
455
456
457
458
459
460
461
462
    // Add to the table description the scalar function columns included in the
    // group and pivot. The groups of rows are defined according to the
    // values of those columns, and so it is necessary to add them before the
    // calculations of the groups, pivots and aggregations.
    for (ScalarFunctionColumn column : groupAndPivotScalarFunctionColumns) {
      newColumnDescriptions.add(new ColumnDescription(column.getId(),
          column.getValueType(table),
          ScalarFunctionColumnTitle.getColumnDescriptionLabel(table, column)));
    }

    DataTable tempTable = new DataTable();
View Full Code Here
649
650
651
652
653
654
655
656
657
658
659
660
      if (indices.size() == 1) {
        columnDescriptions.get(indices.get(0)).setLabel(label);
      } else {
        String columnId = column.getId(); // Without pivot values.
        for (int i : indices) {
          ColumnDescription colDesc = columnDescriptions.get(i);
          String colDescId = colDesc.getId(); // Includes pivot values.
          String specificLabel =
              colDescId.substring(0, colDescId.length() - columnId.length()) + label;
          columnDescriptions.get(i).setLabel(specificLabel);
        }
View Full Code Here
688
689
690
691
692
693
694
695
696
697
698
699
    for (AbstractColumn col : queryFormat.getColumns()) {
      String pattern = queryFormat.getPattern(col);
      List<Integer> indices = columnIndices.getColumnIndices(col);
      boolean allSucceeded = true;
      for (int i : indices) {
        ColumnDescription colDesc = columnDescriptions.get(i);
        ValueFormatter f = ValueFormatter.createFromPattern(colDesc.getType(), pattern, locale);
        if (f == null) {
          allSucceeded = false;
        } else {
          indexToFormatter.put(i, f);
          table.getColumnDescription(i).setPattern(pattern); // May override datasource pattern.
View Full Code Here
173
174
175
176
177
178
179
180
181
182
183
  public void testGetValueType() {
    ScalarFunction scalarFunction = TimeComponentExtractor.getInstance(
        TimeComponentExtractor.TimeComponent.YEAR);
    DataTable table = new DataTable();
    table.addColumn(new ColumnDescription("dateCol", ValueType.DATE, "dateCol"));
     List<AbstractColumn> columns =
        Lists.newArrayList((AbstractColumn) new SimpleColumn("dateCol"));
     ScalarFunctionColumn sfc = new ScalarFunctionColumn(columns, scalarFunction);
    ValueType valueType = sfc.getValueType(table);
    assertEquals(ValueType.NUMBER, valueType);
View Full Code Here
34
35
36
37
38
39
40
41
42
43
44
45
46
    row.addCell(new TableCell("a"));
    row.addCell(new TableCell(123));
    row.addCell(new TableCell("a"));

    DataTable table = new DataTable();
    table.addColumn(new ColumnDescription("c1", ValueType.TEXT, "c1"));
    table.addColumn(new ColumnDescription("c2", ValueType.TEXT, "c2"));
    table.addColumn(new ColumnDescription("c3", ValueType.TEXT, "c3"));

    ColumnColumnFilter filter = new ColumnColumnFilter(new SimpleColumn("c1"),
        new SimpleColumn("c3"), ComparisonFilter.Operator.LE);
    assertTrue(filter.isMatch(table, row));
  }
View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
61
62
    row.addCell(new TableCell("a"));
    row.addCell(new TableCell(123));
    row.addCell(new TableCell("a"));

    DataTable table = new DataTable();
    table.addColumn(new ColumnDescription("c1", ValueType.TEXT, "c1"));
    table.addColumn(new ColumnDescription("c2", ValueType.TEXT, "c2"));
    table.addColumn(new ColumnDescription("c3", ValueType.TEXT, "c3"));

    ColumnColumnFilter filter = new ColumnColumnFilter(new SimpleColumn("c3"),
        new SimpleColumn("c1"), ComparisonFilter.Operator.NE);
    assertFalse(filter.isMatch(table, row));
  }
View Full Code Here
38
39
40
41
42
43
44
45
46
47
48
49
50
    row.addCell(new TableCell("a"));
    row.addCell(new TableCell(123));
    row.addCell(new TableCell("a"));

    DataTable table = new DataTable();
    table.addColumn(new ColumnDescription("c1", ValueType.TEXT, "c1"));
    table.addColumn(new ColumnDescription("c2", ValueType.TEXT, "c2"));
    table.addColumn(new ColumnDescription("c3", ValueType.TEXT, "c3"));

    ColumnValueFilter filter = new ColumnValueFilter(new SimpleColumn("c2"),
        new NumberValue(100), ComparisonFilter.Operator.GE);
    assertTrue(filter.isMatch(table, row));
    filter = new ColumnValueFilter(new SimpleColumn("c2"),
View Full Code Here
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
  /**
   * Tests the createAggregationColumnDescription.
   */
  public void testCreateAggregationColumnDescription() {
    ColumnDescription columnDescription = new ColumnDescription("id",
        ValueType.TEXT, "label");


    ColumnTitle columnTitleCount = new ColumnTitle(Lists.<Value>newArrayList(),
        new AggregationColumn(new SimpleColumn("id"),
            AggregationType.COUNT), false);

    ColumnTitle columnTitleMin = new ColumnTitle(Lists.<Value>newArrayList(),
        new AggregationColumn(new SimpleColumn("id"),
            AggregationType.MIN), true);

    ColumnTitle columnTitleCountWithPivot =
        new ColumnTitle(Lists.newArrayList(new NumberValue(3.14),
            BooleanValue.TRUE), new AggregationColumn(new SimpleColumn("id"),
            AggregationType.COUNT), false);

    ColumnTitle columnTitleMinWithPivot =
        new ColumnTitle(Lists.newArrayList(new NumberValue(3.14),
            BooleanValue.TRUE), new AggregationColumn(new SimpleColumn("id"),
            AggregationType.MIN), true);


    ColumnDescription resultColumnDescriptionCount =
        columnTitleCount.createAggregationColumnDescription(columnDescription);

    ColumnDescription resultColumnDescriptionMin =
        columnTitleMin.createAggregationColumnDescription(columnDescription);

    ColumnDescription resultColumnDescriptionCountWithPivot =
        columnTitleCountWithPivot.createAggregationColumnDescription(columnDescription);

    ColumnDescription resultColumnDescriptionMinWithPivot =
        columnTitleMinWithPivot.createAggregationColumnDescription(columnDescription);

    // Check the creation of result column description with aggregation
    // type count.
    assertEquals("count-id", resultColumnDescriptionCount.getId());
    assertEquals("count label", resultColumnDescriptionCount.getLabel());
    assertEquals(ValueType.NUMBER, resultColumnDescriptionCount.getType());

    // Check the creation of result column description with aggregation
    // type min.
    assertEquals("min-id", resultColumnDescriptionMin.getId());
    assertEquals("min label", resultColumnDescriptionMin.getLabel());
    assertEquals(ValueType.TEXT, resultColumnDescriptionMin.getType());

    // Check the creation of result column description with aggregation
    // type count with pivot and single aggregation.
    assertEquals("3.14,true count-id", resultColumnDescriptionCountWithPivot.getId());
    assertEquals("3.14,true", resultColumnDescriptionCountWithPivot.getLabel());
    assertEquals(ValueType.NUMBER, resultColumnDescriptionCountWithPivot.getType());

    // Check the creation of result column description with aggregation
    // type min with pivot, multi-aggregation.
    assertEquals("3.14,true min-id",
        resultColumnDescriptionMinWithPivot.getId());
    assertEquals("3.14,true min label",
        resultColumnDescriptionMinWithPivot.getLabel());
    assertEquals(ValueType.TEXT, resultColumnDescriptionMinWithPivot.getType());
  }
View Full Code Here
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
    super.setUp();

    colIds = Lists.newArrayList();

    testData = new DataTable();
    ColumnDescription c0 = new ColumnDescription("col0", ValueType.TEXT, "label0");
    ColumnDescription c1 = new ColumnDescription("col1", ValueType.NUMBER, "label1");
    ColumnDescription c2 = new ColumnDescription("col2", ValueType.BOOLEAN, "label2");
    ColumnDescription c3 = new ColumnDescription("col3", ValueType.DATE, "label3");
    ColumnDescription c4 = new ColumnDescription("col4", ValueType.TIMEOFDAY, "label4");
    ColumnDescription c5 = new ColumnDescription("col5", ValueType.DATETIME, "label5");

    testData.addColumn(c0);
    testData.addColumn(c1);
    testData.addColumn(c2);
    testData.addColumn(c3);
View Full Code Here
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
        JsonRenderer.appendCellJson(nullCell, new StringBuilder(),
            true, true, true).toString());
  }

  public void testAppendColumnDescriptionJson() {
    ColumnDescription columnDescription = new ColumnDescription("ID", ValueType.BOOLEAN, "LABEL");
    assertEquals("{\"id\":\"ID\",\"label\":\"LABEL\",\"type\":\"boolean\",\"pattern\":\"\"}",
        JsonRenderer.appendColumnDescriptionJson(
            columnDescription, new StringBuilder()).toString());

    columnDescription.setPattern("%%%.@@");

    assertEquals("{\"id\":\"ID\",\"label\":\"LABEL\",\"type\":\"boolean\",\"pattern\":\"%%%.@@\"}",
        JsonRenderer.appendColumnDescriptionJson(
            columnDescription, new StringBuilder()).toString());
  }
View Full Code Here
TOP

Related Classes of com.google.visualization.datasource.datatable.ColumnDescription

  • com.google.feedserver.samples.wrappers.gviz.GVizWrapper
  • com.google.visualization.datasource.DataSourceHelperTest
  • com.google.visualization.datasource.DataSourceServiceTest
  • com.google.visualization.datasource.query.ColumnColumnFilterTest
  • com.google.visualization.datasource.query.ColumnValueFilterTest
  • com.google.visualization.datasource.query.CompoundFilterTest
  • com.google.visualization.datasource.query.engine.ColumnTitle
  • com.google.visualization.datasource.query.engine.ColumnTitleTest
  • com.google.visualization.datasource.query.engine.QueryEngine
  • com.google.visualization.datasource.query.engine.QueryEngineTest
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.