dk.eobjects.metamodel.query.Query.where()方法的使用及代码示例

x33g5p2x  于2022-01-28 转载在 其他  
字(4.6k)|赞(0)|评价(0)|浏览(123)

本文整理了Java中dk.eobjects.metamodel.query.Query.where方法的一些代码示例,展示了Query.where的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Query.where方法的具体详情如下:
包路径:dk.eobjects.metamodel.query.Query
类名称:Query
方法名:where

Query.where介绍

暂无

代码示例

代码示例来源:origin: dk.eobjects.datacleaner/DataCleaner-core

  1. private void generateDetailSources(MatrixValue matrixValue,
  2. final Column column, final String value) {
  3. Query query = getBaseQuery();
  4. if (value != null && value.indexOf('\'') != -1) {
  5. // We have to approximate with a LIKE filter and
  6. // then postprocess because the value can't contain
  7. // single quote (#197)
  8. String wildcardValue = value.replace('\'', '%');
  9. query.where(column, OperatorType.LIKE, wildcardValue);
  10. matrixValue.addDetailRowFilter(new IRowFilter() {
  11. public boolean accept(Row row) {
  12. return value.equals(row.getValue(column));
  13. }
  14. });
  15. } else {
  16. query.where(column, OperatorType.EQUALS_TO, value);
  17. }
  18. matrixValue.setDetailSource(query);
  19. }

代码示例来源:origin: dk.eobjects.commons/MetaModel

  1. public Query where(Column column, OperatorType operatorType, Object operand) {
  2. SelectItem selectItem = _selectClause.getSelectItem(column);
  3. if (selectItem == null) {
  4. selectItem = new SelectItem(column);
  5. }
  6. return where(new FilterItem(selectItem, operatorType, operand));
  7. }

代码示例来源:origin: dk.eobjects.datacleaner/DataCleaner-core

  1. if (column.getType() == ColumnType.DATE
  2. || column.getType() == ColumnType.TIMESTAMP) {
  3. q.where(column, OperatorType.HIGHER_THAN,
  4. new LocalDate(year - 1, 12, 31).toDateTimeAtStartOfDay());
  5. q.where(column, OperatorType.LOWER_THAN, new LocalDate(
  6. year + 1, 1, 1).toDateTimeAtStartOfDay());

代码示例来源:origin: dk.eobjects.datacleaner/DataCleaner-core

  1. _column.getTable()).where(
  2. new FilterItem(items.toArray(new FilterItem[items.size()])))
  3. .groupBy(new GroupByItem(selectItem));

代码示例来源:origin: dk.eobjects.datacleaner/DataCleaner-core

  1. @Override
  2. protected List<IMatrix> getResultMatrices() {
  3. ArrayList<IMatrix> result = new ArrayList<IMatrix>();
  4. for (int i = 0; i < _columns.length; i++) {
  5. Column column = _columns[i];
  6. Map<String, Long> valueMap = _repeatedValues.get(column);
  7. MatrixBuilder mb = new MatrixBuilder();
  8. mb.addColumn(column.getName() + " count");
  9. mb.addColumn(column.getName() + " %");
  10. for (Entry<String, Long> entry : valueMap.entrySet()) {
  11. Long repeatCount = entry.getValue();
  12. String value = entry.getKey();
  13. int repeatPercentage = (int) (repeatCount * 100 / _totalCount);
  14. if (repeatPercentage >= _significanceRate) {
  15. MatrixValue[] matrixValues = mb.addRow(value, repeatCount,
  16. repeatPercentage + "%");
  17. matrixValues[0].setDetailSource(new Query().from(
  18. column.getTable()).select(_columns).where(
  19. new FilterItem(new SelectItem(column),
  20. OperatorType.EQUALS_TO, value)));
  21. }
  22. }
  23. if (!mb.isEmpty()) {
  24. mb.sortColumn(0, MatrixBuilder.DESCENDING);
  25. result.add(mb.getMatrix());
  26. }
  27. }
  28. return result;
  29. }

代码示例来源:origin: dk.eobjects.commons/MetaModel

  1. FilterItem orFilterItem = new FilterItem(lowerThanFilter,
  2. nullFilter);
  3. q.where(orFilterItem);
  4. } else if (i + 1 == numSplits) {
  5. q.where(orFilterItem);
  6. } else {
  7. higherThanFilter = new FilterItem(higherThanFilter,
  8. lowerThanFilter = new FilterItem(lowerThanFilter,
  9. equalsFilter);
  10. q.where(higherThanFilter);
  11. q.where(lowerThanFilter);

代码示例来源:origin: dk.eobjects.metamodel/MetaModel-jdbc

  1. FilterItem orFilterItem = new FilterItem(lowerThanFilter,
  2. nullFilter);
  3. q.where(orFilterItem);
  4. } else if (i + 1 == numSplits) {
  5. q.where(orFilterItem);
  6. } else {
  7. higherThanFilter = new FilterItem(higherThanFilter,
  8. lowerThanFilter = new FilterItem(lowerThanFilter,
  9. equalsFilter);
  10. q.where(higherThanFilter);
  11. q.where(lowerThanFilter);

代码示例来源:origin: dk.eobjects.datacleaner/DataCleaner-core

  1. .select(_columns).where(
  2. new FilterItem(new SelectItem(column),
  3. OperatorType.EQUALS_TO, null)));
  4. if (column.getType() == null || column.getType().isLiteral()) {
  5. values[2].setDetailSource(new Query().from(
  6. column.getTable()).select(_columns).where(
  7. new FilterItem(new SelectItem(column),
  8. OperatorType.EQUALS_TO, "")));

代码示例来源:origin: dk.eobjects.datacleaner/DataCleaner-core

  1. .valueToString(s.getVariance()));
  2. matrixValues[0].setDetailSource(getBaseQuery().where(
  3. new FilterItem(new SelectItem(_columns[i]),
  4. OperatorType.EQUALS_TO, highestValue)));
  5. matrixValues[1].setDetailSource(getBaseQuery().where(
  6. new FilterItem(new SelectItem(_columns[i]),
  7. OperatorType.EQUALS_TO, lowestValue)));

代码示例来源:origin: dk.eobjects.commons/MetaModel

  1. @Override
  2. public Query clone() {
  3. Query q = new Query();
  4. q.setMaxRows(_maxRows);
  5. q.getSelectClause().setDistinct(_selectClause.isDistinct());
  6. for (FromItem item : _fromClause.getItems()) {
  7. q.from(item.clone());
  8. }
  9. for (SelectItem item : _selectClause.getItems()) {
  10. q.select(item.clone());
  11. }
  12. for (FilterItem item : _whereClause.getItems()) {
  13. q.where(item.clone());
  14. }
  15. for (GroupByItem item : _groupByClause.getItems()) {
  16. q.groupBy(item.clone());
  17. }
  18. for (FilterItem item : _havingClause.getItems()) {
  19. q.having(item.clone());
  20. }
  21. for (OrderByItem item : _orderByClause.getItems()) {
  22. q.orderBy(item.clone());
  23. }
  24. return q;
  25. }
  26. }

相关文章