Package com.google.visualization.datasource.datatable

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


        assertTrue(compoundFilter.isMatch(table, trueRow));
        assertFalse(compoundFilter.isMatch(table, falseRow));
    }

    public void testOrFilter() {
        TableRow falseRow = new TableRow();
        falseRow.addCell(new TableCell("a"));
        falseRow.addCell(new TableCell(123));
        falseRow.addCell(new TableCell("a"));
        TableRow trueRow = new TableRow();
        trueRow.addCell(new TableCell("a"));
        trueRow.addCell(new TableCell(123));
        trueRow.addCell(new TableCell("b"));

        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"));
View Full Code Here


        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)));
        row.addCell(new TableCell(new DateTimeValue(2007, 3, 4, 2, 6, 23, 120)));

        // Check date value.
        List<AbstractColumn> columns =
                Lists.newArrayList((AbstractColumn) new SimpleColumn("dateCol"));
        ScalarFunctionColumn sfc =
View Full Code Here

        testData.addColumn(c1);
        testData.addColumn(c2);

        rows = Lists.newArrayList();

        TableRow row = new TableRow();
        row.addCell(new TableCell("aaa"));
        row.addCell(new TableCell(new NumberValue(222), "222"));
        row.addCell(new TableCell(false));
        rows.add(row);

        row = new TableRow();
        row.addCell(new TableCell(""));
        row.addCell(new TableCell(NumberValue.getNullValue()));
        row.addCell(new TableCell(true));
        rows.add(row);

        row = new TableRow();
        row.addCell(new TableCell(new TextValue("bbb"), "bb@@b"));
        row.addCell(new TableCell(333));
        row.addCell(new TableCell(true));
        rows.add(row);

        row = new TableRow();
        row.addCell(new TableCell("ddd"));
        row.addCell(new TableCell(222));
        row.addCell(new TableCell(false));
        rows.add(row);

        testData.addRows(rows);

        TsvRenderer r = new TsvRenderer();
View Full Code Here

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

        rows = Lists.newArrayList();

        TableRow row = new TableRow();
        row.addCell(new TableCell("aaa"));
        row.addCell(new TableCell(new NumberValue(222), "2a2b2"));
        rows.add(row);

        row = new TableRow();
        row.addCell(new TableCell(""));
        row.addCell(new TableCell(NumberValue.getNullValue()));
        rows.add(row);
        row.setCustomProperty("sensi", "puff");

        testData.addRows(rows);

        testData.getRow(0).getCell(0).setCustomProperty("a", "b");
View Full Code Here

        }

        // Build the data table rows, and in each row create the table cells with
        // the information in the result set.
        while(rs.next()) {
            TableRow tableRow = new TableRow();
            for(int c = 0; c < numOfCols; c++) {
                tableRow.addCell(buildTableCell(rs, columnsTypeArray[c], c));
            }
            try {
                dataTable.addRow(tableRow);
            }
            catch(TypeMismatchException e) {
View Full Code Here

                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);
                    }
                    Value value = valueFormatter.parse(string);

                    tableRow.addCell(value);
                }
                try {
                    dataTable.addRow(tableRow);
                }
                catch(TypeMismatchException e) {
View Full Code Here

    }

    public void testGetRowPath() {
        TableAggregator aggregator = newTableAggregator(1);
        DataTable table = MockDataSource.getData(1);
        TableRow row = table.getRow(0);
        List<Value> path = aggregator.getRowPath(row, table, 0).getValues();
        assertEquals(1, path.size());
        assertEquals("1994", path.get(0).toString());

        row = table.getRow(6);
View Full Code Here

         * populate the data, filling in blank spots. The full list of interval DateTimes is used to create every row in the
         * query range. Then the iterator
         */
        for (final DateTime rowTime : reportTimes) {
            // create the row
            final TableRow row = new TableRow();

            // add the date to the first cell
            final Value dateTimeValue;
            switch (dateTimeColumnType) {
                case DATE: {
                    dateTimeValue = new DateValue(rowTime.getYear(), rowTime.getMonthOfYear()-1, rowTime.getDayOfMonth());
                    break;
                }
                case TIMEOFDAY: {
                    dateTimeValue = new TimeOfDayValue(rowTime.getHourOfDay(), rowTime.getMinuteOfHour(), 0);
                    break;
                }
                default: {
                    dateTimeValue = new DateTimeValue(rowTime.getYear(), rowTime.getMonthOfYear()-1, rowTime.getDayOfMonth(), rowTime.getHourOfDay(), rowTime.getMinuteOfHour(), 0, 0);
                    break;
                }
            }
            row.addCell(new TableCell(dateTimeValue));

            for (final PeekingIterator<T> groupedAggregationIteratorEntry : groupedAggregationIterators.values()) {
                List<Value> values = null;

                if (groupedAggregationIteratorEntry.hasNext()) {
                    final T aggr = groupedAggregationIteratorEntry.peek();
                    if (rowTime.equals(aggr.getDateTime())) {
                        //Data is for the correct time slot, advance the iterator
                        groupedAggregationIteratorEntry.next();
                       
                        values = createRowValues(aggr, form);
                    }
                }
               
                //Gap in the data, fill it in using a null aggregation
                if (values == null) {
                    values = createRowValues(null, form);
                }
               
                //Add the values to the row
                for (final Value value : values) {
                    row.addCell(value);
                }
            }
           
            table.addRow(row);
        }
View Full Code Here

        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);
          }
          Value value = valueFormatter.parse(string);
         
          tableRow.addCell(value);
        }
        try {
          dataTable.addRow(tableRow);
        } catch (TypeMismatchException e) {
          // Should not happen as we always use the correct types (null if we cannot parse),
View Full Code Here

      TableCell cell;
      ColumnDescription columnDescription;

      List<TableRow> rows = dataTable.getRows();
      for (int rowId = 0; rowId < rows.size(); rowId++) {
        TableRow tableRow = rows.get(rowId);
        cells = tableRow.getCells();
        sb.append("{c:[");
        for (int cellId = 0; cellId < cells.size(); cellId++) {
          cell = cells.get(cellId);
          if (cellId < (cells.size() - 1)) {
            appendCellJson(cell, sb, includeFormatting, false);
            sb.append(",");
          } else {
            // Last column in the row.
            appendCellJson(cell, sb, includeFormatting, true);
          }
        }
        sb.append("]");

        // Row properties.
        String customPropertiesString = getPropertiesMapString(tableRow.getCustomProperties());
        if (customPropertiesString != null) {
          sb.append(",p:").append(customPropertiesString);
        }

        sb.append("}"); // cells.
View Full Code Here

TOP

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

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.