Package com.google.visualization.datasource.datatable

Examples of com.google.visualization.datasource.datatable.DataTable.addColumn()

303
304
305
306
307
308
309
310
311
312
313
  }
 
  public void testParseQueryErrors() {
    DataTable dataTable = new DataTable();
    dataTable.addColumn(new ColumnDescription("A", ValueType.TEXT, "column1"));
    dataTable.addColumn(new ColumnDescription("B", ValueType.BOOLEAN, "column2"));
    dataTable.addColumn(new ColumnDescription("C", ValueType.NUMBER, "column3"));
    // Wrong column id
    checkQueryError("select D", dataTable, "Column [D] does not exist in table.");
    checkQueryError("where F > 1", dataTable, "Column [F] does not exist in table.");
    // aggregation sum and average only on numeric columns
View Full Code Here
304
305
306
307
308
309
310
311
312
313
314
 
  public void testParseQueryErrors() {
    DataTable dataTable = new DataTable();
    dataTable.addColumn(new ColumnDescription("A", ValueType.TEXT, "column1"));
    dataTable.addColumn(new ColumnDescription("B", ValueType.BOOLEAN, "column2"));
    dataTable.addColumn(new ColumnDescription("C", ValueType.NUMBER, "column3"));
    // Wrong column id
    checkQueryError("select D", dataTable, "Column [D] does not exist in table.");
    checkQueryError("where F > 1", dataTable, "Column [F] does not exist in table.");
    // aggregation sum and average only on numeric columns
    checkQueryError("select avg(A) group by B", dataTable,
View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
  private static DataTable createDataTable(
      List<String> groupByColumnIds, SortedSet<ColumnTitle> columnTitles,
      DataTable original, List<ScalarFunctionColumnTitle> scalarFunctionColumnTitles) {
    DataTable result = new DataTable();
    for (String groupById : groupByColumnIds) {
      result.addColumn(original.getColumnDescription(groupById));
    }
    for (ColumnTitle colTitle : columnTitles) {
      result.addColumn(colTitle.createColumnDescription(original));
    }
View Full Code Here
90
91
92
93
94
95
96
97
98
99
100
    DataTable result = new DataTable();
    for (String groupById : groupByColumnIds) {
      result.addColumn(original.getColumnDescription(groupById));
    }
    for (ColumnTitle colTitle : columnTitles) {
      result.addColumn(colTitle.createColumnDescription(original));
    }

    for (ScalarFunctionColumnTitle scalarFunctionColumnTitle : scalarFunctionColumnTitles) {
      result.addColumn(scalarFunctionColumnTitle.createColumnDescription(original));
    }
View Full Code Here
94
95
96
97
98
99
100
101
102
103
104
    for (ColumnTitle colTitle : columnTitles) {
      result.addColumn(colTitle.createColumnDescription(original));
    }

    for (ScalarFunctionColumnTitle scalarFunctionColumnTitle : scalarFunctionColumnTitles) {
      result.addColumn(scalarFunctionColumnTitle.createColumnDescription(original));
    }
    return result;
  }

  /**
 
View Full Code Here
81
82
83
84
85
86
87
88
89
90
91
  public void testGetValue() {
    ScalarFunction scalarFunction = TimeComponentExtractor.getInstance(
        TimeComponentExtractor.TimeComponent.YEAR);

    DataTable table = new DataTable();
    table.addColumn(new ColumnDescription("dateCol", ValueType.DATE, "dateCol"));
    table.addColumn(new ColumnDescription("numberCol", ValueType.NUMBER, "numberCol"));
    table.addColumn(new ColumnDescription("timeOfDayCol", ValueType.TIMEOFDAY, "timeOfDayCol"));
    table.addColumn(new ColumnDescription("dateTimeCol", ValueType.DATETIME, "dateTimeCol"));

    TableRow row = new TableRow();
View Full Code Here
82
83
84
85
86
87
88
89
90
91
92
    ScalarFunction scalarFunction = TimeComponentExtractor.getInstance(
        TimeComponentExtractor.TimeComponent.YEAR);

    DataTable table = new DataTable();
    table.addColumn(new ColumnDescription("dateCol", ValueType.DATE, "dateCol"));
    table.addColumn(new ColumnDescription("numberCol", ValueType.NUMBER, "numberCol"));
    table.addColumn(new ColumnDescription("timeOfDayCol", ValueType.TIMEOFDAY, "timeOfDayCol"));
    table.addColumn(new ColumnDescription("dateTimeCol", ValueType.DATETIME, "dateTimeCol"));

    TableRow row = new TableRow();
    row.addCell(new TableCell(new DateValue(2008, 5, 3)));
View Full Code Here
83
84
85
86
87
88
89
90
91
92
93
        TimeComponentExtractor.TimeComponent.YEAR);

    DataTable table = new DataTable();
    table.addColumn(new ColumnDescription("dateCol", ValueType.DATE, "dateCol"));
    table.addColumn(new ColumnDescription("numberCol", ValueType.NUMBER, "numberCol"));
    table.addColumn(new ColumnDescription("timeOfDayCol", ValueType.TIMEOFDAY, "timeOfDayCol"));
    table.addColumn(new ColumnDescription("dateTimeCol", ValueType.DATETIME, "dateTimeCol"));

    TableRow row = new TableRow();
    row.addCell(new TableCell(new DateValue(2008, 5, 3)));
    row.addCell(new TableCell(new NumberValue(23)));
View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
    DataTable table = new DataTable();
    table.addColumn(new ColumnDescription("dateCol", ValueType.DATE, "dateCol"));
    table.addColumn(new ColumnDescription("numberCol", ValueType.NUMBER, "numberCol"));
    table.addColumn(new ColumnDescription("timeOfDayCol", ValueType.TIMEOFDAY, "timeOfDayCol"));
    table.addColumn(new ColumnDescription("dateTimeCol", ValueType.DATETIME, "dateTimeCol"));

    TableRow row = new TableRow();
    row.addCell(new TableCell(new DateValue(2008, 5, 3)));
    row.addCell(new TableCell(new NumberValue(23)));
    row.addCell(new TableCell(new TimeOfDayValue(13, 12, 11)));
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
TOP
Copyright © 2018 www.massapi.com. 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.