private DataSet createDataSet(Column column, List<String> noMatchesList) { SelectItem[] selectItems = new SelectItem[] { new SelectItem(column) }; List<Object[]> data = new ArrayList<Object[]>(noMatchesList.size()); for (String string : noMatchesList) { data.add(new Object[] { string }); } return new DataSet(selectItems, data); }
public DataSet executeQueries(List<Query> splitQueries) { return new DataSet(new SplitQueriesDataSetStrategy(_dataContext, splitQueries)); } }
/** * Retrieves details about the MatrixValue * * @param dataContext * the dataContext to use for retrieving the details * @return a DataSet containing the details, typically some profiled rows * that explain the value/measure */ public DataSet getDetails(DataContext dataContext) { DataSet dataSet = null; if (_detailSelectItems != null && _detailRows != null) { dataSet = new DataSet(_detailSelectItems, _detailRows); } if (_detailQuery != null && dataContext != null) { dataSet = dataContext.executeQuery(_detailQuery); } if (dataSet != null && _filters != null) { dataSet = new DataSet(new RowFilterDataSetStrategyWrapper(dataSet, _filters.toArray(new IRowFilter[_filters.size()]))); } return dataSet; }
public DataSet executeQueries(List<Query> splitQueries) { return new DataSet(new SplitQueriesDataSetStrategy(_dataContext, splitQueries)); } }
return new DataSet(selectItems, resultData);
return new DataSet(selectItems, resultData);
@Override public DataSet materializeMainSchemaTable(Table table, Column[] columns, int maxRows) { try { com.healthmarketscience.jackcess.Table mdbTable = getDatabase() .getTable(table.getName()); SelectItem[] selectItems = new SelectItem[columns.length]; for (int i = 0; i < columns.length; i++) { selectItems[i] = new SelectItem(columns[i]); } int rowNum = 0; List<Object[]> data = new LinkedList<Object[]>(); Iterator<Map<String, Object>> it = mdbTable.iterator(); while (it.hasNext() && (maxRows < 0 || rowNum < maxRows)) { rowNum++; Map<String, Object> valueMap = it.next(); Object[] values = new Object[columns.length]; for (int j = 0; j < columns.length; j++) { values[j] = valueMap.get(columns[j].getName()); } data.add(values); } return new DataSet(selectItems, data); } catch (Exception e) { throw new MetaModelException(e); } }
DataSet dataSet = new DataSet(selectItems, statement, resultSet); return dataSet;
public static DataSet getFiltered(DataSet dataSet, FilterItem... filterItems) { List<Object[]> data = new ArrayList<Object[]>(); while (dataSet.next()) { Row row = dataSet.getRow(); boolean valid = true; for (FilterItem havingItem : filterItems) { if (!havingItem.evaluate(row)) { valid = false; break; } } if (valid) { data.add(row.getValues()); } } dataSet.close(); return new DataSet(dataSet.getSelectItems(), data); }
DataSet dataSet = new DataSet(selectItems, statement, resultSet); return dataSet;
protected DataSet materializeTable(Table table, Column[] columns, int maxRows) { if (table != null) { Schema schema = table.getSchema(); if (INFORMATION_SCHEMA_NAME.equals(schema.getName())) { return materializeInformationSchemaTable(table, columns, maxRows); } else { DataSet tableDataSet = materializeMainSchemaTable(table, columns, maxRows); if (_columnTypeTransformers.isEmpty()) { return tableDataSet; } else { DataSet transformedDataSet = new DataSet( new ColumnTypeTransformerDataSetStrategy( tableDataSet, _columnTypeTransformers)); return transformedDataSet; } } } return null; }
MatrixValue[] matrixValues = mb.addRow(UNIQUE_VALUES_LABEL, uniqueCount, otherPercentage + "%"); matrixValues[0].setDetailSource(new DataSet( new SelectItem[] { new SelectItem(UNIQUE_VALUES_LABEL, null) }, uniqueValues));
dataSet = new DataSet(dataSet.getSelectItems(), data);
public static DataSet getSelection(SelectItem[] selectItems, DataSet dataSet) { SelectItem[] dataSetSelectItems = dataSet.getSelectItems(); if (!ArrayUtils.isEquals(dataSetSelectItems, selectItems)) { List<Object[]> resultData = new ArrayList<Object[]>(); while (dataSet.next()) { Row row = dataSet.getRow(); Object[] resultRow = new Object[selectItems.length]; for (int i = 0; i < selectItems.length; i++) { SelectItem selectItem = selectItems[i]; if (selectItem.getSubQuerySelectItem() != null) { resultRow[i] = row.getValue(selectItem .getSubQuerySelectItem()); } else { resultRow[i] = row.getValue(selectItem); } } resultData.add(resultRow); } dataSet.close(); dataSet = new DataSet(selectItems, resultData); } return dataSet; }
selectItems[i] = new SelectItem(columns[i]); return new DataSet(selectItems, rowValues);
selectItems[i] = new SelectItem(column); DataSet result = new DataSet(selectItems, resultData); return result; } catch (Exception e) {
selectItems[i] = new SelectItem(column); DataSet result = new DataSet(selectItems, resultData); return result;