@Override public void limitDataSetRows(int offset, int rows) { int offsetBase = lookupBase.getRowOffset(); int rowsBase = lookupBase.getNumberOfRows(); lookupCurrent.setRowOffset(offsetBase + offset); // base 0 to all, 0 to 20 => offset=0, rows=20 // base 0 to 1, 0 to 20 => offset=0, rows=1 // base 50 to 51, 0 to 20 => offset=50, rows=20 // base 10 to 31, 20 to 10 => offset=30, rows=10 // base 10 to 31, 0 to 50 => offset=10, rows=31 if (rowsBase < 1 || rowsBase > rows) { lookupCurrent.setNumberOfRows(rows); } }
@Override public void limitDataSetRows(int offset, int rows) { int offsetBase = lookupBase.getRowOffset(); int rowsBase = lookupBase.getNumberOfRows(); lookupCurrent.setRowOffset(offsetBase + offset); // base 0 to all, 0 to 20 => offset=0, rows=20 // base 0 to 1, 0 to 20 => offset=0, rows=1 // base 50 to 51, 0 to 20 => offset=50, rows=20 // base 10 to 31, 20 to 10 => offset=30, rows=10 // base 10 to 31, 0 to 50 => offset=10, rows=31 if (rowsBase < 1 || rowsBase > rows) { lookupCurrent.setNumberOfRows(rows); } }
public DataSet lookupDataSet(String uuid, DataSetLookup lookup) { if (StringUtils.isEmpty(uuid)) return null; // Get the target data set DataSetIndex dataSetIndex = dataSetOpEngine.getIndexRegistry().get(uuid); if (dataSetIndex == null) return null; DataSet dataSet = dataSetIndex.getDataSet(); if (lookup == null) return dataSet; // Apply the list of operations specified (if any). if (!lookup.getOperationList().isEmpty()) { dataSet = dataSetOpEngine.execute(uuid, lookup.getOperationList()); } // Trim the data set as requested. dataSet = dataSet.trim(lookup.getRowOffset(), lookup.getNumberOfRows()); return dataSet; }
public JsonObject toJson(DataSetLookup dataSetLookup) throws JsonException { JsonObject json = Json.createObject(); if ( dataSetLookup != null ) { String uuid = dataSetLookup.getDataSetUUID(); if (uuid != null && !uuid.trim().isEmpty()) json.put(UUID, uuid); json.put(ROWCOUNT, Integer.toString(dataSetLookup.getNumberOfRows())); json.put(ROWOFFSET, Integer.toString(dataSetLookup.getRowOffset())); List<DataSetFilter> filterOps = dataSetLookup.getOperationList(DataSetFilter.class); if (!filterOps.isEmpty()) { json.set(FILTEROPS, formatFilterOperations(filterOps)); } List<DataSetGroup> groupOps = dataSetLookup.getOperationList(DataSetGroup.class); if (!groupOps.isEmpty()) { json.set(GROUPOPS, formatGroupOperations(groupOps)); } List<DataSetSort> sortOps = dataSetLookup.getOperationList(DataSetSort.class); if (!sortOps.isEmpty()) { json.set(SORTOPS, formatSortOperations(sortOps)); } } return json; }
public JsonObject toJson(DataSetLookup dataSetLookup) throws JsonException { JsonObject json = Json.createObject(); if ( dataSetLookup != null ) { String uuid = dataSetLookup.getDataSetUUID(); if (uuid != null && !uuid.trim().isEmpty()) json.put(UUID, uuid); json.put(ROWCOUNT, Integer.toString(dataSetLookup.getNumberOfRows())); json.put(ROWOFFSET, Integer.toString(dataSetLookup.getRowOffset())); List<DataSetFilter> filterOps = dataSetLookup.getOperationList(DataSetFilter.class); if (!filterOps.isEmpty()) { json.set(FILTEROPS, formatFilterOperations(filterOps)); } List<DataSetGroup> groupOps = dataSetLookup.getOperationList(DataSetGroup.class); if (!groupOps.isEmpty()) { json.set(GROUPOPS, formatGroupOperations(groupOps)); } List<DataSetSort> sortOps = dataSetLookup.getOperationList(DataSetSort.class); if (!sortOps.isEmpty()) { json.set(SORTOPS, formatSortOperations(sortOps)); } } return json; }
public static DataSetLookup fromInstance(DataSetLookup orig, String serverTemplateId) { ConsoleDataSetLookup clone = new ConsoleDataSetLookup(); clone.setDataSetUUID(orig.getDataSetUUID()); clone.setRowOffset(orig.getRowOffset()); clone.setNumberOfRows(orig.getNumberOfRows()); for (DataSetOp dataSetOp : orig.getOperationList()) { clone.getOperationList().add(dataSetOp.cloneInstance()); } clone.setServerTemplateId(serverTemplateId); return clone; }
public static DataSetLookup fromInstance(DataSetLookup orig, String serverTemplateId) { ConsoleDataSetLookup clone = new ConsoleDataSetLookup(); clone.setDataSetUUID(orig.getDataSetUUID()); clone.setRowOffset(orig.getRowOffset()); clone.setNumberOfRows(orig.getNumberOfRows()); for (DataSetOp dataSetOp : orig.getOperationList()) { clone.getOperationList().add(dataSetOp.cloneInstance()); } clone.setServerTemplateId(serverTemplateId); return clone; }
public static DataSetLookup fromInstance(DataSetLookup orig, String serverTemplateId) { ConsoleDataSetLookup clone = new ConsoleDataSetLookup(); clone.setDataSetUUID(orig.getDataSetUUID()); clone.setRowOffset(orig.getRowOffset()); clone.setNumberOfRows(orig.getNumberOfRows()); for (DataSetOp dataSetOp : orig.getOperationList()) { clone.getOperationList().add(dataSetOp.cloneInstance()); } clone.setServerTemplateId(serverTemplateId); return clone; }
dataSet = dataSet.trim(lookup.getRowOffset(), lookup.getNumberOfRows()); dataSet.setUUID(def.getUUID()); dataSet.setDefinition(def);
dataSet = dataSet.trim(lookup.getRowOffset(), lookup.getNumberOfRows()); dataSet.setUUID(def.getUUID()); dataSet.setDefinition(def);
@Override public DataSet lookupDataSet(DataSetLookup lookup) { String uuid = lookup.getDataSetUUID(); if (StringUtils.isEmpty(uuid)) { return null; } // Get the target data set DataSetIndex dataSetIndex = dataSetOpEngine.getIndexRegistry().get(uuid); if (dataSetIndex == null) { return null; } List<DataSetPreprocessor> dataSetDefPreProcessors = getDataSetPreprocessors(uuid); if (dataSetDefPreProcessors != null) { for(DataSetPreprocessor p : dataSetDefPreProcessors){ p.preprocess(lookup); } } DataSet dataSet = dataSetIndex.getDataSet(); // Apply the list of operations specified (if any). if (!lookup.getOperationList().isEmpty()) { dataSet = dataSetOpEngine.execute(uuid, lookup.getOperationList()); } // Trim the data set as requested. dataSet = dataSet.trim(lookup.getRowOffset(), lookup.getNumberOfRows()); return dataSet; }
@Override public DataSet lookupDataSet(DataSetLookup lookup) { String uuid = lookup.getDataSetUUID(); if (StringUtils.isEmpty(uuid)) { return null; } // Get the target data set DataSetIndex dataSetIndex = dataSetOpEngine.getIndexRegistry().get(uuid); if (dataSetIndex == null) { return null; } List<DataSetPreprocessor> dataSetDefPreProcessors = getDataSetPreprocessors(uuid); if (dataSetDefPreProcessors != null) { for(DataSetPreprocessor p : dataSetDefPreProcessors){ p.preprocess(lookup); } } DataSet dataSet = dataSetIndex.getDataSet(); // Apply the list of operations specified (if any). if (!lookup.getOperationList().isEmpty()) { dataSet = dataSetOpEngine.execute(uuid, lookup.getOperationList()); } // Trim the data set as requested. dataSet = dataSet.trim(lookup.getRowOffset(), lookup.getNumberOfRows()); return dataSet; }
metadata = _getDataSetMetadata(def, conn, skipCache); int totalRows = metadata.getNumberOfRows(); boolean trim = (lookup != null && (lookup.getNumberOfRows() > 0 || lookup.getRowOffset() > 0)); _query.limit(lookup.getNumberOfRows()).offset(lookup.getRowOffset()); _query.limit(lookup.getNumberOfRows()).offset(lookup.getRowOffset());
metadata = _getDataSetMetadata(def, conn, skipCache); int totalRows = metadata.getNumberOfRows(); boolean trim = (lookup != null && (lookup.getNumberOfRows() > 0 || lookup.getRowOffset() > 0)); _query.limit(lookup.getNumberOfRows()).offset(lookup.getRowOffset()); _query.limit(lookup.getNumberOfRows()).offset(lookup.getRowOffset());
dataSetLookup.getNumberOfRows()); assertEquals(0, dataSetLookup.getRowOffset()); assertNotNull(dataSetLookup.getFirstFilterOp()); final DataSetFilter firstFilterOp = dataSetLookup.getFirstFilterOp();