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

Package com.google.visualization.datasource.datatable

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

com.google.visualization.datasource.datatable.DataTable
A table of data, arranged in typed columns. An instance of this class is the result of a request to a data source. A DataTable can be rendered in many ways: JSON, HTML, CSV (see {@link com.google.visualization.datasource.render}), and can be manipulated using queries (see {@link com.google.visualization.datasource.query.Query} and{@link com.google.visualization.datasource.query.engine.QueryEngine}). A table contains any number of typed columns (see (@link ColumnDescription}) each with an id and a label, and any number of rows. Each row must have as many cells as there are columns in the table, and the types of values in the cells must match the types of the columns. Each cell contains, as well as the typed value, a formatted value of type string, used for display purposes. Also, you can use the custom properties mechanism to hold any other data you require. There are custom properties on every cell, row, column, and on the entire table. @author Yoah B.D.

    TableRow row = new TableRow();
    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

    TableRow row = new TableRow();
    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

    TableRow row = new TableRow();
    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

  }


  public static DataTable getRandomDataTable(int tableNum, int numRows,
      long randomSeed) {
    random = new Random(randomSeed);
    DataTable res = new DataTable();
    res.addColumns(dataTables[tableNum].getColumnDescriptions());
    res = res.clone(); // Clones the column descriptions.
    try {
      for (int i = 0; i < numRows; i++) {
        TableRow row = new TableRow();
        for (ColumnDescription colDesc : res.getColumnDescriptions()) {
          Value value = toRandomValue(colDesc.getType());
          row.addCell(new TableCell(value));
        }
        res.addRow(row);
      }
    } catch (TypeMismatchException e) {
        // Should not happen, as we control the types.
    }
    return res;

View Full Code Here

  public void setUp() throws Exception {
    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");

View Full Code Here

    testData = null;
    rows = null;
  }


  public void testEmptyDataTableToJson() {
    DataTable dataTable = new DataTable();
    assertEquals("", JsonRenderer.renderDataTable(dataTable, false, false, true));
    assertEquals("", JsonRenderer.renderDataTable(dataTable, false, true, true));
    assertEquals("", JsonRenderer.renderDataTable(dataTable, true, false, true));
    assertEquals("", JsonRenderer.renderDataTable(dataTable, true, true, true));
  }

View Full Code Here

            columnDescription, new StringBuilder()).toString());
  }




  public void testSimpleDataTableToJson() throws DataSourceException {
    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);

View Full Code Here

            + "{\"c\":[{\"v\":\"d\\u0027dd\"},{\"v\":222.0},{\"v\":false}]}]}",
        JsonRenderer.renderDataTable(testData, true, true, true).toString());
  }
  
  public void testSimpleDataTableWithDatesInJson() throws DataSourceException {
    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);

View Full Code Here

  }


  public void testEntireResponseWithWarnings() throws DataSourceException {
    colIds = Lists.newArrayList();


    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);

View Full Code Here




  public void testCustomPropertiesToJson() throws DataSourceException {
    colIds = Lists.newArrayList();


    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);

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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

AdvancedExampleServlet

AdvancedExampleServlet2

com.google.feedserver.samples.wrappers.gviz.GVizWrapper

com.google.visualization.datasource.DataSourceHelper

com.google.visualization.datasource.DataSourceHelperTest

com.google.visualization.datasource.DataSourceService

com.google.visualization.datasource.DataSourceServiceTest

com.google.visualization.datasource.query.ColumnColumnFilterTest

com.google.visualization.datasource.query.ColumnValueFilterTest

com.google.visualization.datasource.query.CompoundFilterTest

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.