Examples of DataTable

com.chap.links.client.DataTable
The DataTable is a DataConnector which can store a table in native Javascript, containing native JavaScriptObjects @author jos
com.google.gwt.visualization.client.DataTable
e.com/apis/visualization/documentation/reference.html#DataTable"> DataTable API Reference
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.
com.googlecode.g2re.html.DataTable
com.googlecode.gwt.charts.client.DataTable
ogle.com/apis/chart/interactive/docs/reference.html#DataTable">DataTable API Reference
com.senseidb.search.relevance.impl.CompilationHelper.DataTable
cucumber.api.DataTable
dbfit.util.DataTable
Vendor-invariant detached rowset implementation. Because oracle-specific extensions effectively prevent us from using a generic cached result set, this class plays that role instead.
de.intranda.commons.chart.results.DataTable
eas.math.gnuplot2.DataTable
net.thucydides.core.model.DataTable
A table of test data
org.apache.ambari.eventdb.model.DataTable
org.apache.myfaces.wap.component.DataTable
org.apache.wicket.extensions.markup.html.repeater.data.table.DataTable
A data table builds on data grid view to introduce toolbars. Toolbars can be used to display sortable column headers, paging information, filter controls, and other information.
Data table also provides its own markup for an html table so the user does not need to provide it himself. This makes it very simple to add a datatable to the markup, however, some flexibility.
Example
```
 <table wicket:id="datatable"></table> 
```
And the related Java code: ( the first column will be sortable because its sort property is specified, the second column will not )
```
 List<IColumn<T>> columns = new ArrayList<IColumn<T>>(); columns.add(new PropertyColumn(new Model<String>("First Name"), "name.first", "name.first")); columns.add(new PropertyColumn(new Model<String>("Last Name"), "name.last")); DataTable table = new DataTable("datatable", columns, new UserProvider(), 10); table.addBottomToolbar(new NavigationToolbar(table)); table.addTopToolbar(new HeadersToolbar(table, null)); add(table); 
```
@see DefaultDataTable @author Igor Vaynberg (ivaynberg) @param < T> The model object type @param < S> the type of the sorting parameter
org.gwt.mosaic.ui.client.table.DataTable
@author Derived work from GWT Incubator project @author georgopoulos.georgios(at)gmail.com
org.jfree.formula.lvalues.DataTable
A database is a two dimensional collection of data, arranged in a table. Although we do not assume that the whole database is held in memory, we allow random access of the data. Columns may have names, but there is no enforced requirement for that. As a database is not just a collection of raw data, this interface returns LValues instead of plain objects. Columns may be computed values using formulas (the exact semantics of adressing database cells in a formula is beyond the scope of this specification and is implementation specific). @author Thomas Morgner
org.jtester.module.dbfit.db.model.DataTable
vendor-invariant detached rowset implementation. Because oracle-specific extensions effectively prevent us from using a generic cached result set, this class plays that role instead. It is also responsible for efficient data row matching and tracking processed/unprocessed rows.
org.openfaces.component.table.DataTable
The DataTable component is used to display data in a tabular format and effectively manipulate it. It supports the features of the JSF HtmlDataTable component and extends the standard functionality with such advanced features as sorting, row selection (both multiple and single), pagination, filtering, keyboard navigation, and dynamic data loading (using Ajax.) Plus, the DataTable component provides special support for handling large datasets with minimal overhead. @author Dmitry Pikhulya
org.pentaho.reporting.libraries.formula.lvalues.DataTable
A database is a two dimensional collection of data, arranged in a table. Although we do not assume that the whole database is held in memory, we allow random access of the data. Columns may have names, but there is no enforced requirement for that. As a database is not just a collection of raw data, this interface returns LValues instead of plain objects. Columns may be computed values using formulas (the exact semantics of adressing database cells in a formula is beyond the scope of this specification and is implementation specific). @author Thomas Morgner
org.primefaces.component.datatable.DataTable
org.sgx.yuigwt.yui.widget.datatable.DataTable
functionality of this table would require additional modules be use()d, // but the feature APIs are aggregated onto Y.DataTable. // (Snippet is for illustration. Not all features are available today.) var table = new Y.DataTable({ columns: [ { type: 'checkbox', defaultChecked: true }, { key: 'firstName', sortable: true, resizable: true }, { key: 'lastName', sortable: true }, { key: 'role', formatter: toRoleName } ], data: { source: 'http://myserver.com/service/json', type: 'json', schema: { resultListLocator: 'results.users', fields: [ 'username', 'firstName', 'lastName', { key: 'role', type: 'number' } ] } }, recordType: UserModel, pagedData: { location: 'footer', pageSizes: [20, 50, 'all'], rowsPerPage: 20, pageLinks: 5 }, editable: true });
Column Configuration

The column configurations are set in the form of an array of objects, where each object corresponds to a column. For columns populated directly from the row data, a 'key' property is required to bind the column to that property or attribute in the row data.
Not all columns need to relate to row data, nor do all properties or attributes of the row data need to have a corresponding column. However, only those columns included in the columns configuration attribute will be rendered.
Other column configuration properties are supported by the configured headerView, bodyView, footerView classes as well as any features added by plugins or class extensions. See the description of DataTable.HeaderView, DataTable.BodyView, and other DataTable feature classes to see what column properties they support.
Some examples of column configurations would be:
```
 // Basic var columns = [{ key: 'firstName' }, { key: 'lastName' }, { key: 'age' }]; // For columns without any additional configuration, strings can be used var columns = ['firstName', 'lastName', 'age']; // Multi-row column headers (see DataTable.HeaderView for details) var columns = [ { label: 'Name', children: [ { key: 'firstName' }, { key: 'lastName' } ] }, 'age' // mixing and matching objects and strings is ok ]; // Including columns that are not related 1:1 to row data fields/attributes // (See DataTable.BodyView for details) var columns = [ { label: 'Name', // Needed for the column header formatter: function (o) { // Fill the column cells with data from firstName and lastName if (o.data.age > 55) { o.className += ' senior'; } return o.data.lastName + ', ' + o.data.firstName; } }, 'age' ]; // Columns that include feature configurations (for illustration; not all // features are available today). var columns = [ { type: 'checkbox', defaultChecked: true }, { key: 'firstName', sortable: true, resizable: true, min-width: '300px' }, { key: 'lastName', sortable: true, resizable: true, min-width: '300px' }, { key: 'age', emptyCellValue: 'unknown' } ]; 
```
Row Data Configuration

The data configuration attribute is responsible for housing the data objects that will be rendered as rows. You can provide this information in two ways by default:
An array of simple objects with key:value pairs
A ModelList of Base-based class instances (presumably Model subclass instances)

If an array of objects is passed, it will be translated into a ModelList filled with instances of the class provided to the recordType attribute. This attribute can also create a custom Model subclass from an array of field names or an object of attribute configurations. If no recordType is provided, one will be created for you from available information (see _initRecordType). Providing either your own ModelList instance for data, or at least Model class for recordType, is the best way to control client-server synchronization when modifying data on the client side.
The ModelList instance that manages the table's data is available in the data property on the DataTable instance.
Rendering
TableShow rendering is a collaborative process between the DataTable and its configured headerView, bodyView, and footerView. The DataTable renders the table and caption elements, but the contents of the table are delegated to instances of the classes provided to the headerView, bodyView, and footerView attributes. If any of these attributes is unset, that portion of the table won't be rendered.
DataTable.Base assigns the default headerView to Y.DataTable.HeaderView and the default bodyView to Y.DataTable.BodyView, though either can be overridden for custom rendering. No default footerView is assigned. See those classes for more details about how they operate. @author sg
org.timepedia.chronoscope.gviz.api.client.DataTable
trader.test.ui.console.DataTable
@author Tobias Mahncke

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

    assertStringArraysEqual(new String[]{"1996", "Youthanasia", "2.0"},
      resultStrings[3]);  
  }
  
  public void testSkippingWithFiltering() throws Exception {
    DataTable res = MockDataSource.getData(1);
    
    // The returned mock data table should consist of 45 rows
    assertEquals(45, res.getNumberOfRows());


    Query q = QueryBuilder.getInstance().parseQuery("SELECT Year, Band, Songs " + 
        "WHERE Fans <= 3000 SKIPPING 10");
    
    q.validate();


    DataTable result = QueryEngine.executeQuery(q, res, ULocale.US);


    // Test column description
    List<ColumnDescription> cols =  result.getColumnDescriptions();


    assertEquals(3, cols.size());
    assertEquals("Year", cols.get(0).getId());
    assertEquals("Band", cols.get(1).getId());
    assertEquals("Songs", cols.get(2).getId());

View Full Code Here

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

  }


  public void testRead() throws IOException, CsvDataSourceException {
    // Null reader.
    Reader reader = null;
    DataTable dataTable = CsvDataSourceHelper.read(reader, null, false);
    assertEquals(0, dataTable.getNumberOfRows());


    // Empty string reader.
    reader = new StringReader("");
    dataTable = CsvDataSourceHelper.read(reader, null, false);
    assertEquals(0, dataTable.getNumberOfRows());


    // Null TableDescription.
    reader = new StringReader("\n\n\n1,2,3\n\n4,5,6\n\n\n\n\n");
    dataTable = CsvDataSourceHelper.read(reader, null, false);
    assertEquals(2, dataTable.getNumberOfRows());
    assertEquals(3, dataTable.getNumberOfColumns());
    assertEquals(new TextValue("1"), dataTable.getRow(0).getCell(0).getValue());
    assertEquals(new TextValue("2"), dataTable.getRow(0).getCell(1).getValue());
    assertEquals(new TextValue("3"), dataTable.getRow(0).getCell(2).getValue());
    assertEquals(new TextValue("4"), dataTable.getRow(1).getCell(0).getValue());
    assertEquals(new TextValue("5"), dataTable.getRow(1).getCell(1).getValue());
    assertEquals(new TextValue("6"), dataTable.getRow(1).getCell(2).getValue());


    // Different column numbers.
    boolean catched = false;
    try {
      reader = new StringReader("1,2\na, b, c");
      dataTable = CsvDataSourceHelper.read(reader, null, false);
    } catch (CsvDataSourceException e) {
      catched = true;
      assertEquals(ReasonType.INTERNAL_ERROR, e.getReasonType());
      assertEquals(
          "Wrong number of columns in the data.",
          e.getMessageToUser());
    }
    assertTrue(catched);


    // Working example with a table description filled only with types.
    reader = new StringReader("1,a,true\n4,x13a,false\n1400,4,true");
    List<ColumnDescription> columnDescriptions = Lists.newArrayList();
    columnDescriptions.add(new ColumnDescription("i1", ValueType.NUMBER, null));
    columnDescriptions.add(new ColumnDescription("i2", ValueType.TEXT, null));
    columnDescriptions.add(new ColumnDescription("i3", ValueType.DATE, null));
    dataTable = CsvDataSourceHelper.read(reader, columnDescriptions, false);
    assertEquals(3, dataTable.getNumberOfRows());
    assertEquals(3, dataTable.getNumberOfColumns());
    assertEquals(new NumberValue(1), dataTable.getRow(0).getCell(0).getValue());
    assertEquals(new TextValue("a"), dataTable.getRow(0).getCell(1).getValue());
    assertEquals(DateValue.getNullValue(), dataTable.getRow(0).getCell(2).getValue());
    assertEquals(new NumberValue(4), dataTable.getRow(1).getCell(0).getValue());
    assertEquals(new TextValue("x13a"), dataTable.getRow(1).getCell(1).getValue());
    assertEquals(DateValue.getNullValue(), dataTable.getRow(1).getCell(2).getValue());
    assertEquals(new NumberValue(1400), dataTable.getRow(2).getCell(0).getValue());
    assertEquals(new TextValue("4"), dataTable.getRow(2).getCell(1).getValue());
    assertEquals(DateValue.getNullValue(), dataTable.getRow(2).getCell(2).getValue());


    // Working example with a table description filled only with types.
    reader = new StringReader("1,a,2004-03-01\n4,x13a,2005-04-02\n1400,4,2006-05-03");
    columnDescriptions = Lists.newArrayList();
    columnDescriptions.add(new ColumnDescription("i1", ValueType.NUMBER, null));
    columnDescriptions.add(new ColumnDescription("i2", ValueType.TEXT, null));
    columnDescriptions.add(new ColumnDescription("i3", ValueType.DATE, null));
    dataTable = CsvDataSourceHelper.read(reader, columnDescriptions, false);
    assertEquals(3, dataTable.getNumberOfRows());
    assertEquals(3, dataTable.getNumberOfColumns());
    assertEquals(new NumberValue(1), dataTable.getRow(0).getCell(0).getValue());
    assertEquals(new TextValue("a"), dataTable.getRow(0).getCell(1).getValue());
    assertEquals(new DateValue(2004, 2, 1), dataTable.getRow(0).getCell(2).getValue());
    assertEquals(new NumberValue(4), dataTable.getRow(1).getCell(0).getValue());
    assertEquals(new TextValue("x13a"), dataTable.getRow(1).getCell(1).getValue());
    assertEquals(new DateValue(2005, 3, 2), dataTable.getRow(1).getCell(2).getValue());
    assertEquals(new NumberValue(1400), dataTable.getRow(2).getCell(0).getValue());
    assertEquals(new TextValue("4"), dataTable.getRow(2).getCell(1).getValue());
    assertEquals(new DateValue(2006, 4, 3), dataTable.getRow(2).getCell(2).getValue());
    assertEquals("i1", dataTable.getColumnDescription(0).getId());
    assertEquals("Column0", dataTable.getColumnDescription(0).getLabel());
    assertEquals("i2", dataTable.getColumnDescription(1).getId());
    assertEquals("Column1", dataTable.getColumnDescription(1).getLabel());
    assertEquals("i3", dataTable.getColumnDescription(2).getId());
    assertEquals("Column2", dataTable.getColumnDescription(2).getLabel());


    // Working example with header rows.
    reader = new StringReader("1,a,2004-03-01\n4,x13a,2005-04-02\n1400,4,2006-05-03");
    columnDescriptions = Lists.newArrayList();
    columnDescriptions.add(new ColumnDescription("i1", ValueType.NUMBER, null));
    columnDescriptions.add(new ColumnDescription("i2", ValueType.TEXT, null));
    columnDescriptions.add(new ColumnDescription("i3", ValueType.DATE, null));
    dataTable = CsvDataSourceHelper.read(reader, columnDescriptions, true);
    assertEquals(2, dataTable.getNumberOfRows());
    assertEquals(3, dataTable.getNumberOfColumns());
    assertEquals(new NumberValue(4), dataTable.getRow(0).getCell(0).getValue());
    assertEquals(new TextValue("x13a"), dataTable.getRow(0).getCell(1).getValue());
    assertEquals(new DateValue(2005, 3, 2), dataTable.getRow(0).getCell(2).getValue());
    assertEquals(new NumberValue(1400), dataTable.getRow(1).getCell(0).getValue());
    assertEquals(new TextValue("4"), dataTable.getRow(1).getCell(1).getValue());
    assertEquals(new DateValue(2006, 4, 3), dataTable.getRow(1).getCell(2).getValue());
    assertEquals("i1", dataTable.getColumnDescription(0).getId());
    assertEquals("1",  dataTable.getColumnDescription(0).getLabel());
    assertEquals("i2", dataTable.getColumnDescription(1).getId());
    assertEquals("a", dataTable.getColumnDescription(1).getLabel());
    assertEquals("i3", dataTable.getColumnDescription(2).getId());
    assertEquals("2004-03-01", dataTable.getColumnDescription(2).getLabel());


    // Bad table description for that data.
    catched = false;
    try {
      reader = new StringReader("true\nfalse\nfalse");
      columnDescriptions = Lists.newArrayList();
      dataTable = CsvDataSourceHelper.read(reader, columnDescriptions, false);
    } catch (CsvDataSourceException e) {
      catched = true;
      assertEquals(ReasonType.INTERNAL_ERROR, e.getReasonType());
      assertEquals(
          "Wrong number of columns in the data.",
          e.getMessageToUser());
    }
    assertTrue(catched);


    // Working example with a null table description.
    reader = new StringReader("true,false\ntrue,false\ntrue,false\nfalse,false");
    columnDescriptions = null;
    dataTable = CsvDataSourceHelper.read(reader, columnDescriptions, false);
    assertEquals(4, dataTable.getNumberOfRows());
    assertEquals(2, dataTable.getNumberOfColumns());
    assertEquals(new TextValue("true"), dataTable.getRow(0).getCell(0).getValue());
    assertEquals(new TextValue("false"), dataTable.getRow(0).getCell(1).getValue());
    assertEquals(new TextValue("true"), dataTable.getRow(1).getCell(0).getValue());
    assertEquals(new TextValue("false"), dataTable.getRow(1).getCell(1).getValue());
    assertEquals(new TextValue("true"), dataTable.getRow(2).getCell(0).getValue());
    assertEquals(new TextValue("false"), dataTable.getRow(2).getCell(1).getValue());
    assertEquals(new TextValue("false"), dataTable.getRow(3).getCell(0).getValue());
    assertEquals(new TextValue("false"), dataTable.getRow(3).getCell(1).getValue());


    // Working example with a table description filled with types.
    reader = new StringReader("true,false\ntrue,false\ntrue,false\nfalse,false");
    columnDescriptions = Lists.newArrayList();
    columnDescriptions.add(new ColumnDescription("1", ValueType.BOOLEAN, "123"));
    columnDescriptions.add(new ColumnDescription("2", ValueType.BOOLEAN, "123"));
    dataTable = CsvDataSourceHelper.read(reader, columnDescriptions, false);
    assertEquals(4, dataTable.getNumberOfRows());
    assertEquals(2, dataTable.getNumberOfColumns());
    assertEquals(BooleanValue.TRUE, dataTable.getRow(0).getCell(0).getValue());
    assertEquals(BooleanValue.FALSE, dataTable.getRow(0).getCell(1).getValue());
    assertEquals(BooleanValue.TRUE, dataTable.getRow(1).getCell(0).getValue());
    assertEquals(BooleanValue.FALSE, dataTable.getRow(1).getCell(1).getValue());
    assertEquals(BooleanValue.TRUE, dataTable.getRow(2).getCell(0).getValue());
    assertEquals(BooleanValue.FALSE, dataTable.getRow(2).getCell(1).getValue());
    assertEquals(BooleanValue.FALSE, dataTable.getRow(3).getCell(0).getValue());
    assertEquals(BooleanValue.FALSE, dataTable.getRow(3).getCell(1).getValue());
  }

View Full Code Here

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

    
    ColumnDescription columnDescription = new ColumnDescription("i3", ValueType.DATE, null);
    columnDescription.setPattern("yyyyMMdd");
    columnDescriptions.add(columnDescription);
    
    DataTable dataTable = CsvDataSourceHelper.read(reader, columnDescriptions, true);
    assertEquals(2, dataTable.getNumberOfRows());
    assertEquals(3, dataTable.getNumberOfColumns());
    assertEquals(new NumberValue(4), dataTable.getRow(0).getCell(0).getValue());
    assertEquals(new TextValue("x13a"), dataTable.getRow(0).getCell(1).getValue());
    assertEquals(new DateValue(2005, 3, 2), dataTable.getRow(0).getCell(2).getValue());
    assertEquals(new NumberValue(1400), dataTable.getRow(1).getCell(0).getValue());
    assertEquals(new TextValue("4"), dataTable.getRow(1).getCell(1).getValue());
    assertEquals(new DateValue(2006, 4, 3), dataTable.getRow(1).getCell(2).getValue());
    assertEquals("i1", dataTable.getColumnDescription(0).getId());
    assertEquals("1",  dataTable.getColumnDescription(0).getLabel());
    assertEquals("i2", dataTable.getColumnDescription(1).getId());
    assertEquals("a", dataTable.getColumnDescription(1).getLabel());
    assertEquals("i3", dataTable.getColumnDescription(2).getId());
    assertEquals("20040301", dataTable.getColumnDescription(2).getLabel());
  }

View Full Code Here

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

    List<ColumnDescription> columnDescriptions = Lists.newArrayList();
    columnDescriptions.add(new ColumnDescription("i1", ValueType.NUMBER, null));
    columnDescriptions.add(new ColumnDescription("i2", ValueType.NUMBER, null));
    columnDescriptions.add(new ColumnDescription("i3", ValueType.NUMBER, null));
       
    DataTable dataTable = CsvDataSourceHelper.read(reader, columnDescriptions, true);
    assertEquals(1, dataTable.getNumberOfRows());
    assertEquals(3, dataTable.getNumberOfColumns());
    assertEquals(new NumberValue(4), dataTable.getRow(0).getCell(0).getValue());
    assertEquals(new NumberValue(5), dataTable.getRow(0).getCell(1).getValue());
    assertEquals(new NumberValue(6), dataTable.getRow(0).getCell(2).getValue());
    assertEquals("i1", dataTable.getColumnDescription(0).getId());
    assertEquals("1",  dataTable.getColumnDescription(0).getLabel());
    assertEquals("i2", dataTable.getColumnDescription(1).getId());
    assertEquals("2", dataTable.getColumnDescription(1).getLabel());
    assertEquals("i3", dataTable.getColumnDescription(2).getId());
    assertEquals("3", dataTable.getColumnDescription(2).getLabel());
  }

View Full Code Here

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

    columnDescriptions.add(new ColumnDescription("i1", ValueType.NUMBER, null));
    columnDescriptions.add(new ColumnDescription("i2", ValueType.NUMBER, null));
    columnDescriptions.add(new ColumnDescription("i3", ValueType.NUMBER, null));
    columnDescriptions.add(new ColumnDescription("i4", ValueType.NUMBER, null));
       
    DataTable dataTable = CsvDataSourceHelper.read(reader, columnDescriptions, true);
    assertEquals(2, dataTable.getNumberOfRows());
    assertEquals(4, dataTable.getNumberOfColumns());
    assertEquals(new NumberValue(4), dataTable.getRow(0).getCell(0).getValue());
    assertEquals(new NumberValue(5), dataTable.getRow(0).getCell(1).getValue());
    assertEquals(new NumberValue(6), dataTable.getRow(0).getCell(2).getValue());
    assertEquals(NumberValue.getNullValue(), dataTable.getRow(0).getCell(3).getValue());
    assertEquals(new NumberValue(7), dataTable.getRow(1).getCell(0).getValue());
    assertEquals(NumberValue.getNullValue(), dataTable.getRow(1).getCell(1).getValue());
    assertEquals(NumberValue.getNullValue(), dataTable.getRow(1).getCell(2).getValue());
    assertEquals(new NumberValue(10), dataTable.getRow(1).getCell(3).getValue());
    assertEquals("i1", dataTable.getColumnDescription(0).getId());
    assertEquals("1",  dataTable.getColumnDescription(0).getLabel());
    assertEquals("i2", dataTable.getColumnDescription(1).getId());
    assertEquals("", dataTable.getColumnDescription(1).getLabel());
    assertEquals("i3", dataTable.getColumnDescription(2).getId());
    assertEquals("2", dataTable.getColumnDescription(2).getLabel());
    assertEquals("i4", dataTable.getColumnDescription(3).getId());
    assertEquals("3", dataTable.getColumnDescription(3).getLabel());
  }

View Full Code Here

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

    columnDescriptions.add(new ColumnDescription("A", ValueType.NUMBER, "A"));
    columnDescriptions.add(new ColumnDescription("B", ValueType.TIMEOFDAY, "B"));
    TimeOfDayValue hindiTimeOfDayValue = new TimeOfDayValue(1, 12, 1);
    String hindiTimeOfDayString =  "\u0966\u0967\u003a\u0967\u0968\u003a\u0966\u0967";
    Reader reader = new StringReader("1," + hindiTimeOfDayString);
    DataTable dataTable = CsvDataSourceHelper.read(reader, columnDescriptions, false,
        new ULocale("hi_IN"));
    assertEquals(1, dataTable.getNumberOfRows());
    assertEquals(2, dataTable.getNumberOfColumns());
    assertEquals(new NumberValue(1), dataTable.getRow(0).getCell(0).getValue());
    assertEquals(hindiTimeOfDayValue, dataTable.getRow(0).getCell(1).getValue());
  }

View Full Code Here

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


    List<String> columnIdsList = Lists.newArrayList("id", "fname", "lname",
        "gender", "salary", "ismarried", "startdate", "timestamp", "time");


    // Get the table description using the mock result set.
    DataTable dataTable = SqlDataSourceHelper.buildColumns(rs, columnIdsList);
    assertNotNull(dataTable);


    // Make sure the number of columns in the table description is correct.
    assertEquals(NUM_OF_COLS, dataTable.getNumberOfColumns());


    // Get the columns description list.
    List <ColumnDescription> columnsDescriptionList = dataTable.getColumnDescriptions();


    // Make sure the type of each column is correct.
    assertEquals(ValueType.NUMBER, columnsDescriptionList.get(0).getType());
    assertEquals(ValueType.TEXT, columnsDescriptionList.get(1).getType());
    assertEquals(ValueType.TEXT, columnsDescriptionList.get(2).getType());
    assertEquals(ValueType.TEXT, columnsDescriptionList.get(3).getType());
    assertEquals(ValueType.NUMBER, columnsDescriptionList.get(4).getType());
    assertEquals(ValueType.BOOLEAN, columnsDescriptionList.get(5).getType());
    assertEquals(ValueType.DATE, columnsDescriptionList.get(6).getType());
    assertEquals(ValueType.DATETIME, columnsDescriptionList.get(7).getType());
    assertEquals(ValueType.TIMEOFDAY, columnsDescriptionList.get(8).getType());


    // Make sure the label of each column is correct.
    assertEquals("ID", columnsDescriptionList.get(0).getLabel());
    assertEquals("Fname", columnsDescriptionList.get(1).getLabel());
    assertEquals("Lname", columnsDescriptionList.get(2).getLabel());
    assertEquals("Gender", columnsDescriptionList.get(3).getLabel());
    assertEquals("Salary", columnsDescriptionList.get(4).getLabel());
    assertEquals("IsMarried", columnsDescriptionList.get(5).getLabel());
    assertEquals("StartDate", columnsDescriptionList.get(6).getLabel());
    assertEquals("TimeStamp", columnsDescriptionList.get(7).getLabel());
    assertEquals("Time", columnsDescriptionList.get(8).getLabel());


    // Build the table rows.
    SqlDataSourceHelper.buildRows(dataTable, rs);


    assertNotNull(dataTable);


    // Make sure the number of rows int the table is correct.
    assertEquals(3, dataTable.getNumberOfRows());


    // Make sure the type of the data table cells is correct.
    for (int i = 0; i < dataTable.getNumberOfRows(); i++) {
      assertEquals(ValueType.NUMBER,
          dataTable.getRow(i).getCell(0).getValue().getType());
      assertEquals(ValueType.TEXT,
          dataTable.getRow(i).getCell(1).getValue().getType());
      assertEquals(ValueType.TEXT,
          dataTable.getRow(i).getCell(2).getValue().getType());
      assertEquals(ValueType.TEXT,
          dataTable.getRow(i).getCell(3).getValue().getType());
      assertEquals(ValueType.NUMBER,
          dataTable.getRow(i).getCell(4).getValue().getType());
      assertEquals(ValueType.BOOLEAN,
          dataTable.getRow(i).getCell(5).getValue().getType());
      assertEquals(ValueType.DATE,
          dataTable.getRow(i).getCell(6).getValue().getType());
      assertEquals(ValueType.DATETIME,
          dataTable.getRow(i).getCell(7).getValue().getType());
      assertEquals(ValueType.TIMEOFDAY,
          dataTable.getRow(i).getCell(8).getValue().getType());
    }


    // Make sure the value of the data table cells is correct. For cells with
    // null value, check that the value equals to the null value format of the
    // specific type value.
    assertEquals(new NumberValue(100.0),
        dataTable.getRow(0).getCell(0).getValue());
    assertEquals("Yaron", dataTable.getRow(0).getCell(1).getValue().toString());
    assertEquals(new TextValue(""), dataTable.getRow(0).getCell(2).getValue());
    assertEquals("Bar", dataTable.getRow(1).getCell(2).getValue().toString());
    assertEquals("F", dataTable.getRow(1).getCell(3).getValue().toString());
    assertEquals(BooleanValue.getNullValue(),
        dataTable.getRow(1).getCell(5).getValue());
    assertEquals(NumberValue.getNullValue(),
        dataTable.getRow(2).getCell(4).getValue());
    assertEquals("true", dataTable.getRow(2).getCell(5).getValue().toString());
    assertEquals(dataTable.getRow(0).getCell(6).getValue().toString(),
        new DateValue(gc), dataTable.getRow(0).getCell(6).getValue());
    assertEquals(new DateTimeValue(gc),
        dataTable.getRow(0).getCell(7).getValue());
    assertEquals(new TimeOfDayValue(gc),
        dataTable.getRow(0).getCell(8).getValue());
    assertEquals(DateValue.getNullValue(),
        dataTable.getRow(1).getCell(6).getValue());
    assertEquals(DateTimeValue.getNullValue(),
        dataTable.getRow(2).getCell(7).getValue());
    assertEquals(TimeOfDayValue.getNullValue(),
        dataTable.getRow(2).getCell(8).getValue());
  }

View Full Code Here

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

    ResultSet rs = new MockResultSet(rows, NUM_OF_COLS, labels, types);


    List<String> columnIdsList = null;


    // Get the table description using the mock result set.
    DataTable dataTable = SqlDataSourceHelper.buildColumns(rs, columnIdsList);


    assertNotNull(dataTable);


    // Build the table rows.
    SqlDataSourceHelper.buildRows(dataTable, rs);


    // Make sure there aren't any rows in the data table.
    assertEquals(0, dataTable.getNumberOfRows());
    assertEquals(0, dataTable.getRows().size());
  }

View Full Code Here

Examples of com.googlecode.g2re.html.DataTable

        queryA.getParameters().add(new JdbcParameter(2, DataType.INTEGER, maxParam));
        report.getDataQueries().add(queryA);
        
        
        /* create data table, set the data query */
        DataTable table = new DataTable();
        table.setCellPadding(1);
        table.setDataQuery(queryA);


        /* create table header rows */
        GridRow tableHeader = new GridRow();
        tableHeader.addCell(new com.googlecode.g2re.html.GridCell(new RawHTML("Name")));
        tableHeader.addCell(new com.googlecode.g2re.html.GridCell(new RawHTML("Description")));
        tableHeader.addCell(new com.googlecode.g2re.html.GridCell(new RawHTML("City")));
        tableHeader.addCell(new com.googlecode.g2re.html.GridCell(new RawHTML("State")));
        tableHeader.addCell(new com.googlecode.g2re.html.GridCell(new RawHTML("Zip")));
        tableHeader.addCell(new com.googlecode.g2re.html.GridCell(new RawHTML("Price")));
        tableHeader.addCell(new com.googlecode.g2re.html.GridCell(new RawHTML("Image")));
        table.getHeaderRows().add(tableHeader);


        /* create table body rows */
        GridRow tableBody = new GridRow();
        tableBody.addCell(new com.googlecode.g2re.html.GridCell(new DataElement(col1, 0)));
        tableBody.addCell(new com.googlecode.g2re.html.GridCell(new DataElement(col2, 1)));
        tableBody.addCell(new com.googlecode.g2re.html.GridCell(new DataElement(col6, 2)));
        tableBody.addCell(new com.googlecode.g2re.html.GridCell(new DataElement(col7, 3)));
        tableBody.addCell(new com.googlecode.g2re.html.GridCell(new DataElement(col8, 4)));
        tableBody.addCell(new com.googlecode.g2re.html.GridCell(new DataElement("\"<img src='\" + row[4].toString() + \"' />\"",6)));
        
        /* add formatted price column */
        DataElement priceCellElement = new DataElement(col4, 5);
        priceCellElement.setNumberFormat("$###,###,###,##0.00");
        tableBody.addCell(new com.googlecode.g2re.html.GridCell(priceCellElement));
        
        /* add rows to table */
        table.getBodyRows().add(tableBody);


        /* add the table to the report */
        report.getWebPage().addChildElement(table);
        
        /* create and add a map */

View Full Code Here

Examples of com.googlecode.gwt.charts.client.DataTable

    for (CommunityAccount commAcc: listAccount) {
      listStats.add(commAcc.getName());
      
    }
    // Prepare the data
    DataTable dataTable = DataTable.create();
    dataTable.addColumn(ColumnType.STRING, "dates");
    
//    for (int i = 0; i < countries.length; i++) {
//      dataTable.addColumn(ColumnType.NUMBER, countries[i]);
//    }
    //
    for (String nameStat: listStats) {
      dataTable.addColumn(ColumnType.NUMBER, nameStat);
    }
    
    //dataTable.addRows(years.length);
    //
    CommunityAccount commAccount = listAccount.get(0);
    //String  tabDates[] = new String [100] ;
    //init tabDates
    int i = 0;
//    for(String date :commAccount.listDates) {
//      tabDates[i] = date;
//      i++;
//    }
    
    
//    //wn8 directe 
//    Double [] tabWn8= new Double [100];
//    i = 0;
//    for(DataPlayerInfos data :commAccount.listDataPlayerInfos) {
//      tabWn8[i] = data.getStatistics().getAllStatistics().getWn8();
//      i++;
//    }
    //
    //wn8 directe 
//    Double [] tabWr= new Double [100];
//    i = 0;
//    for(DataPlayerInfos data :commAccount.listDataPlayerInfos) {
//      tabWr[i] = data.getStatistics().getAllStatistics().getBattle_avg_performanceCalc()*100;
//      i++;
//    }
    
    
//    Integer [] tabBattlesWins = new Integer [100];
//    i = 0;
//    for(Integer wn :commAccount.listBattlesWins) {
//      tabBattlesWins[i] = wn;
//      i++;
//    }
    
//    Integer [] tabBattles = new Integer [100];
//    i = 0;
//    for(Integer wn :commAccount.listbattles) {
//      tabBattles[i] = wn;
//      i++;
//    }
    
    //
    dataTable.addRows(commAccount.listDates.size());
    
//    for (int i = 0; i < years.length; i++) {
//      dataTable.setValue(i, 0, String.valueOf(years[i]));
//    }
    //
    //on set la légende des abscisses ligne 0 
//    i = 0;
//    for (String date: commAccount.listDates ) {
//      //String partdate= date.substring(0, 8);
//      dataTable.setValue(i, 0, String.valueOf(i));
//      i++;
//    }
    for (int row = 0; row < commAccount.listDates.size(); row++) {
      int index = commAccount.listDates.size() -1 ;
      index = index - row;
      String partdate = commAccount.listDates.get(index);
      //dd-Mm-AAAA
      partdate = partdate.substring(0, 5);
      dataTable.setValue(row, 0, String.valueOf(partdate));
      
      
    }
    //
//    for (int col = 0; col < values.length; col++) {
//      for (int row = 0; row < values[col].length; row++) {
    
    
//        dataTable.setValue(row, col + 1, values[col][row]);
//      }
//    }
    //
//    for (int col = 0; col < listStats.size() ; col++) {
//      for (int row = 0; row < commAccount.listDates.size(); row++) {
//        int bw = tabBattlesWins[col] ;
//        int b = tabBattles[col] ;
//        double db =  (double)bw/(double)b ;
//        int intdb = (int) (db * 100);
//        db = (double) intdb / (double)100 ;
//        dataTable.setValue(row, col + 1, db);
//      }
//    }
//    
    int col = 0 ;
    double avg = 0.0;
    int previousNbBattle = 0;
    for (CommunityAccount commAcc: listAccount) {
      avg = 0.0;
      previousNbBattle = 0;
      for (int row = 0; row < commAccount.listDates.size(); row++) {
        int index = commAccount.listDates.size() -1 ;
        index = index - row;
         DataPlayerInfos dataPlayerInfos = commAcc.listDataPlayerInfos.get(index);
         if (stat.equalsIgnoreCase("WN8")) {
           double tmp = dataPlayerInfos.getStatistics().getAllStatistics().getWn8();
           
           if (dataPlayerInfos.getStatistics().getAllStatistics().getWn8()!=0 && !Double.isNaN(dataPlayerInfos.getStatistics().getAllStatistics().getWn8())){
             avg = dataPlayerInfos.getStatistics().getAllStatistics().getWn8();
           }
           if (avg != 0.0) {
             int nb = (int) (avg * 100);
             avg = (double)nb/100;
             dataTable.setValue(row, col + 1, avg);
           }
         }
         
         if (stat.equalsIgnoreCase("WR")) {
           if (dataPlayerInfos.getStatistics().getAllStatistics().getBattle_avg_performanceCalc() ==null) {
             if (dataPlayerInfos.getStatistics().getAllStatistics().getWins() !=0 && dataPlayerInfos.getStatistics().getAllStatistics().getBattles() != 0) {
               avg = (double)dataPlayerInfos.getStatistics().getAllStatistics().getWins()/ (double)dataPlayerInfos.getStatistics().getAllStatistics().getBattles();
               avg = avg *100 ;
             } 
             if (avg != 0.0)
               dataTable.setValue(row, col + 1, avg);
           } else {
             avg = dataPlayerInfos.getStatistics().getAllStatistics().getBattle_avg_performanceCalc() *  100 ;
             if (avg != 0.0) {
               int nb = (int) (avg * 100);
               avg = (double)nb/100;
               dataTable.setValue(row, col + 1, avg);
             }
           }
         }
         
         if (stat.equalsIgnoreCase("BATTLE")) {
//           if (dataPlayerInfos.getStatistics().getAllStatistics().getBattle_avg_performanceCalc() == null) {
//             if (dataPlayerInfos.getStatistics().getAllStatistics().getWins() !=0 && dataPlayerInfos.getStatistics().getAllStatistics().getBattles() != 0) {
//               avg = (double)dataPlayerInfos.getStatistics().getAllStatistics().getWins()/ (double)dataPlayerInfos.getStatistics().getAllStatistics().getBattles();
//               avg = avg *100 ;
//             } 
//             if (avg != 0.0)
//               dataTable.setValue(row, col + 1, avg);
//           } else {
//             avg = dataPlayerInfos.getStatistics().getAllStatistics().getBattle_avg_performanceCalc() *  100 ;
//             if (avg != 0.0) {
//               int nb = (int) (avg * 100);
//               avg = (double)nb/100;
//               dataTable.setValue(row, col + 1, avg);
//             }
//           }
           if (dataPlayerInfos.getStatistics().getAllStatistics()!= null) {
             int nbBattle = dataPlayerInfos.getStatistics().getAllStatistics().getBattles();
             avg = nbBattle;
             if (previousNbBattle == 0 )
               dataTable.setValue(row, col + 1, previousNbBattle);
             else {
               //diff par rapoort au précédent
               dataTable.setValue(row, col + 1, nbBattle - previousNbBattle);
             }
             previousNbBattle = nbBattle;
               
           }else {
             dataTable.setValue(row, col + 1, avg);
           }
         }
      }
      
      col++;

View Full Code Here

0 1 2 3 4 5 6

TOP

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.

Examples of DataTable

Column Configuration

Row Data Configuration

Rendering

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

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

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

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

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

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

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

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

Examples of com.googlecode.g2re.html.DataTable

Examples of com.googlecode.gwt.charts.client.DataTable