How to use org.dashbuilder.dataset

private int getGroupColumn(DataSetMetadata metatada) {
  for (int i=0; i<metatada.getNumberOfColumns(); i++) {
    ColumnType type = metatada.getColumnType(i);
    if (type.equals(ColumnType.LABEL)) return i;
  }
  for (int i=0; i<metatada.getNumberOfColumns(); i++) {
    ColumnType type = metatada.getColumnType(i);
    if (type.equals(ColumnType.DATE)) return i;
  }
  return -1;
}

@Override
public DataSet createDataSet(String uuid) {
  DataSet dataSet = DataSetFactory.newEmptyDataSet();
  dataSet.setUUID(uuid);
  return dataSet;
}

  public String getValue( Integer row ) {
    Object value = dataSet.getValueAt(row, columnNumber);
    return TableDisplayer.this.format(value, column.getId());
  }
};

private ValidationError checkTypes(DataSet dataSet, ColumnType[] types) {
  for (int i = 0; i < dataSet.getColumns().size(); i++) {
    ColumnType columnType = dataSet.getColumnByIndex(i).getColumnType();
    if (i < types.length && !columnType.equals(types[i])) {
      return createValidationError(ERROR_COLUMN_TYPE, i, types[i], columnType);
    }
  }
  return null;
}

public DataSet lookupGroupByMonthDynamic(boolean emptyIntervals) throws Exception {
  return dataSetManager.lookupDataSet(
      DataSetLookupFactory.newDataSetLookupBuilder()
          .dataset(EXPENSE_REPORTS)
          .group(COLUMN_DATE).dynamic(99, MONTH, emptyIntervals)
          .column(COLUMN_DATE, "Period")
          .column(COLUMN_EMPLOYEE, "Employee")
          .column(COUNT, "Occurrences")
          .column(COLUMN_AMOUNT, SUM, "totalAmount")
          .buildLookup());
}

private DataSet _filterDataSet(DataSet dataSet, List<Integer> rows) {
  DataSet result = DataSetFactory.newEmptyDataSet();
  for (DataColumn column : dataSet.getColumns()) {
    DataColumn sortedColumn = column.cloneEmpty();
    SortedList sortedValues = new SortedList(column.getValues(), rows);
    sortedColumn.setValues(sortedValues);
    result.addColumn(sortedColumn);
  }
  return result;
}

public DataSet toDataSet() throws ParseException {
  DataSet dataSet = DataSetFactory.newEmptyDataSet();
  for (int i = 0; i < columnIds.length; i++) {
    dataSet.addColumn(columnIds[i], getColumnType(types[i]));
    for (int j = 0; j < data.length; j++) {
      String[] row = data[j];
      Object value = parseValue(row[i], types[i]);
      dataSet.setValueAt(j, i, value);
    }
  }
  return dataSet;
}

@Override
public DataSet lookupDataSet(DataSetDef def, DataSetLookup lookup) throws Exception {
  return DataSetFactory.newDataSetBuilder()
      .label("name")
      .row("david")
      .row("maciejs")
      .buildDataSet();
}

/**
 * Check if some data set rows match a given result.
 * @param dataSet The data set to validate.
 * @param expected The expected row values.
 * @param index The starting data set row index where the comparison starts.
 */
public static void assertDataSetValues(DataSet dataSet, String[][] expected, int index) {
  assertDataSetValues(dataSet, new DataSetFormatter(), expected, index);
}

@Before
public void setUp() throws Exception {
  DataSet dataSet = ExpenseReportsData.INSTANCE.toDataSet();
  dataSet.setUUID(EXPENSE_REPORTS);
  dataSetManager.registerDataSet(dataSet);
}

/**
 * Check if some data set rows match a given result.
 * @param dataSet The data set to validate.
 * @param x The x position of the cell to check (starting at 0).
 * @param y The y position of the cell to check (starting at 0).
 * @param expected The expected value in the given cell.
 */
public static void assertDataSetValue(DataSet dataSet, int x, int y, String expected) {
  assertDataSetValue(dataSet, new DataSetFormatter(), x, y, expected);
}

private ValidationError checkTypes(DataSet dataSet, ColumnType[] types) {
  for (int i = 0; i < dataSet.getColumns().size(); i++) {
    ColumnType columnType = dataSet.getColumnByIndex(i).getColumnType();
    if (i < types.length && !columnType.equals(types[i])) {
      return createValidationError(ERROR_COLUMN_TYPE, i, types[i], columnType);
    }
  }
  return null;
}

  public String getValue( Integer row ) {
    Object value = dataSet.getValueAt(row, columnNumber);
    return TableDisplayer.this.format(value, column.getId());
  }
};

private int getGroupColumn(DataSetMetadata metatada) {
  for (int i=0; i<metatada.getNumberOfColumns(); i++) {
    ColumnType type = metatada.getColumnType(i);
    if (type.equals(ColumnType.LABEL)) return i;
  }
  for (int i=0; i<metatada.getNumberOfColumns(); i++) {
    ColumnType type = metatada.getColumnType(i);
    if (type.equals(ColumnType.DATE)) return i;
  }
  return -1;
}

public DataSet createDataSet(String uuid) {
  DataSet dataSet = DataSetFactory.newEmptyDataSet();
  dataSet.setUUID(uuid);
  return dataSet;
}

public DataSet toDataSet() throws ParseException {
  DataSet dataSet = DataSetFactory.newEmptyDataSet();
  for (int i = 0; i < columnIds.length; i++) {
    dataSet.addColumn(columnIds[i], getColumnType(types[i]));
    for (int j = 0; j < data.length; j++) {
      String[] row = data[j];
      Object value = parseValue(row[i], types[i]);
      dataSet.setValueAt(j, i, value);
    }
  }
  return dataSet;
}

@Override
public DataSet lookupDataSet(DataSetDef def, DataSetLookup lookup) throws Exception {
  return DataSetFactory.newDataSetBuilder()
      .label("name")
      .row("david")
      .row("maciejs")
      .buildDataSet();
}

/**
 * Check if some data set rows match a given result.
 * @param dataSet The data set to validate.
 * @param expected The expected row values.
 * @param index The starting data set row index where the comparison starts.
 */
public static void assertDataSetValues(DataSet dataSet, String[][] expected, int index) {
  assertDataSetValues(dataSet, new DataSetFormatter(), expected, index);
}

/**
 * Check if some data set rows match a given result.
 * @param dataSet The data set to validate.
 * @param x The x position of the cell to check (starting at 0).
 * @param y The y position of the cell to check (starting at 0).
 * @param expected The expected value in the given cell.
 */
public static void assertDataSetValue(DataSet dataSet, int x, int y, String expected) {
  assertDataSetValue(dataSet, new DataSetFormatter(), x, y, expected);
}

@Override
public DataSet createDataSet(String uuid) {
  DataSet dataSet = DataSetFactory.newEmptyDataSet();
  dataSet.setUUID(uuid);
  return dataSet;
}