Package com.google.visualization.datasource.datatable

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


    public void testSimpleDataTableToJson() throws DataSourceException {
        DataTable testData;
        List<TableRow> rows;

        testData = new DataTable();
        ColumnDescription c0 = new ColumnDescription("A", ValueType.TEXT, "col0");
        ColumnDescription c1 = new ColumnDescription("B", ValueType.NUMBER, "col1");
        ColumnDescription c2 = new ColumnDescription("C", ValueType.BOOLEAN, "col2");

        testData.addColumn(c0);
        testData.addColumn(c1);
        testData.addColumn(c2);
View Full Code Here


    public void testSimpleDataTableWithDatesInJson() throws DataSourceException {
        DataTable testData;
        List<TableRow> rows;

        testData = new DataTable();
        ColumnDescription c0 = new ColumnDescription("DateA", ValueType.DATE, "col0");
        ColumnDescription c1 = new ColumnDescription("DateTimeA", ValueType.DATETIME, "col1");
        ColumnDescription c2 = new ColumnDescription("ValueA", ValueType.NUMBER, "col2");

        testData.addColumn(c0);
        testData.addColumn(c1);
        testData.addColumn(c2);
View Full Code Here

    public void testEntireResponseWithWarnings() throws DataSourceException {
        DataTable testData;
        List<TableRow> rows;

        testData = new DataTable();
        ColumnDescription c0 = new ColumnDescription("A", ValueType.TEXT, "col0");
        ColumnDescription c1 = new ColumnDescription("B", ValueType.NUMBER, "col1");

        testData.addColumn(c0);
        testData.addColumn(c1);

        rows = Lists.newArrayList();
View Full Code Here

    public void testCustomPropertiesToJson() throws DataSourceException {
        DataTable testData;
        List<TableRow> rows;

        testData = new DataTable();
        ColumnDescription c0 = new ColumnDescription("A", ValueType.TEXT, "col0");
        ColumnDescription c1 = new ColumnDescription("B", ValueType.NUMBER, "col1");
        c1.setCustomProperty("arak", "elit");

        testData.addColumn(c0);
        testData.addColumn(c1);

        rows = Lists.newArrayList();
View Full Code Here

                r.renderDataTable(testData, true, true).toString());
    }

    private DataTable getTestDataTable() throws DataSourceException {
        DataTable dataTable = new DataTable();
        ColumnDescription c0 = new ColumnDescription("A", ValueType.TEXT, "col0");
        ColumnDescription c1 = new ColumnDescription("B", ValueType.NUMBER, "col1");
        ColumnDescription c2 = new ColumnDescription("C", ValueType.BOOLEAN, "col2");

        dataTable.addColumn(c0);
        dataTable.addColumn(c1);
        dataTable.addColumn(c2);
View Full Code Here

    // For each column in the table, create the column description. SQL indexes
    // are 1-based.
    for (int i = 1; i <= numOfCols; i++) {
      String id = (columnIdsList == null) ? metaData.getColumnLabel(i) :
          columnIdsList.get(i - 1);
      ColumnDescription columnDescription =
          new ColumnDescription(id,
              sqlTypeToValueType(metaData.getColumnType(i)),
              metaData.getColumnLabel(i));
      result.addColumn(columnDescription);
    }
    return result;
View Full Code Here

        // Fill the defaults in the tableDescription.
        // This allows easy-to-write table descriptions
        // (or even null table descriptions).
        for (int i = 0; i < line.length; i++) {
          ColumnDescription tempColumnDescription =
              (columnDescriptions.isEmpty() || columnDescriptions.get(i) == null)
              ? null
              : columnDescriptions.get(i);

          String id =
              ((tempColumnDescription == null) || (tempColumnDescription.getId() == null))
              ? "Col" + (i) : tempColumnDescription.getId();
          ValueType type =
              ((tempColumnDescription == null) || (tempColumnDescription.getType() == null))
              ? ValueType.TEXT : tempColumnDescription.getType();
          String label =
              ((tempColumnDescription == null) || (tempColumnDescription.getLabel() == null))
              ? "Column" + i : tempColumnDescription.getLabel();
          String pattern =
              ((tempColumnDescription == null) || (tempColumnDescription.getPattern() == null))
              ? "" : tempColumnDescription.getPattern();

          tempColumnDescription = new ColumnDescription(id, type, label);
          tempColumnDescription.setPattern(pattern);
          tempColumnDescriptions.add(tempColumnDescription);
        }

        // Deal with header rows.
        if (headerRow) {
          for (int i = 0; i < line.length; i++) {
            String string = line[i];
            if (string == null) {
              tempColumnDescriptions.get(i).setLabel("");
            } else {
              tempColumnDescriptions.get(i).setLabel(line[i].trim());
            }
          }
        }

        columnDescriptions = tempColumnDescriptions;
        dataTable = new DataTable();
        dataTable.addColumns(columnDescriptions);
      }
      if (!(firstLine && headerRow)) {
        // Need to parse the first line as a regular row.
        TableRow tableRow = new TableRow();
        for (int i = 0; i < line.length; i++) {
          ColumnDescription columnDescription = columnDescriptions.get(i);
          ValueType valueType = columnDescription.getType();
          String string = line[i];
          if (string != null) {
            string = string.trim();
          }
          String pattern = columnDescription.getPattern();
          ValueFormatter valueFormatter;
          if (pattern == null || pattern.equals("")) {
            valueFormatter = defaultFormatters.get(valueType);
          } else {
            valueFormatter = ValueFormatter.createFromPattern(valueType, pattern, locale);
View Full Code Here

        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

     * @param originalTable The original table, from which the original column description
     *                      of the column under aggregation is taken.
     * @return The ColumnDescription for this column.
     */
    public ColumnDescription createColumnDescription(DataTable originalTable) {
        ColumnDescription colDesc = originalTable.getColumnDescription(
                aggregation.getAggregatedColumn().getId());
        return createAggregationColumnDescription(colDesc);
    }
View Full Code Here

        }
        else {
            label = aggregationLabelPart;
        }

        ColumnDescription result;
        if(canUseSameTypeForAggregation(type, aggregationType)) {
            // Create a new column description and copy original formatters.
            result = new ColumnDescription(columnId, type, label);
        }
        else {
            // Create a new column description if this is a non numeric column and the aggregation
            // type is COUNT.
            result = new ColumnDescription(columnId, ValueType.NUMBER, label);
        }

        return result;
    }
View Full Code Here

TOP

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

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.