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

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

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

Query.from介绍

暂无

代码示例

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

  1. @Override
  2. public DataSet materializeMainSchemaTable(Table table,
  3.     Column[] columns, int maxRows) {
  4.   DataContext dc = getDataContext(table);
  5.   Query q = new Query().select(columns).from(table);
  6.   if (maxRows >= 0) {
  7.     q.setMaxRows(maxRows);
  8.   }
  9.   return dc.executeQuery(q);
  10. }

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

  1. /**
  2.  * Convenience method to create a base query for matrix values based on the
  3.  * configured columns (where the other columns are of interest).
  4.  */
  5. protected Query getBaseQuery() {
  6.   if (_columns.length > 0) {
  7.     Table table = _columns[0].getTable();
  8.     Query q = new Query().select(table.getColumns()).from(table);
  9.     return q;
  10.   }
  11.   return null;
  12. }

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

  1. Query q = new Query().select(selectItem).selectCount().from(
  2.     _column.getTable()).where(
  3.     new FilterItem(items.toArray(new FilterItem[items.size()])))

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

  1. /**
  2.  * Convenience method to create a base query for matrix values based on a
  3.  * specific column (where only the columns content is of interest).
  4.  */
  5. protected Query getBaseQuery(Column column) {
  6.   return new Query().from(column.getTable()).select(
  7.       new SelectItem(column)).selectCount().groupBy(column);
  8. }

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

  1. private List<Query> splitQueryBasedOnSubQueries(int fromItemIndex) {
  2.   Query subQuery = _query.getFromClause().getItem(fromItemIndex)
  3.       .getSubQuery();
  4.   QuerySplitter subQuerySplitter = new QuerySplitter(_dataContext,
  5.       subQuery);
  6.   subQuerySplitter.setMaxRows(_maxRows);
  7.   List<Query> splitQueries = subQuerySplitter.splitQuery();
  8.   List<Query> result = new ArrayList<Query>(splitQueries.size());
  9.   for (Query splitQuery : splitQueries) {
  10.     Query newQuery = _query.clone();
  11.     FromClause fromClause = newQuery.getFromClause();
  12.     String alias = fromClause.getItem(fromItemIndex).getAlias();
  13.     fromClause.removeItem(fromItemIndex);
  14.     newQuery.from(new FromItem(splitQuery).setAlias(alias));
  15.     result.add(newQuery);
  16.   }
  17.   return result;
  18. }

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

  1. private List<Query> splitQueryBasedOnSubQueries(int fromItemIndex) {
  2.   Query subQuery = _query.getFromClause().getItem(fromItemIndex)
  3.       .getSubQuery();
  4.   QuerySplitter subQuerySplitter = new QuerySplitter(_dataContext,
  5.       subQuery);
  6.   subQuerySplitter.setMaxRows(_maxRows);
  7.   List<Query> splitQueries = subQuerySplitter.splitQuery();
  8.   List<Query> result = new ArrayList<Query>(splitQueries.size());
  9.   for (Query splitQuery : splitQueries) {
  10.     Query newQuery = _query.clone();
  11.     FromClause fromClause = newQuery.getFromClause();
  12.     String alias = fromClause.getItem(fromItemIndex).getAlias();
  13.     fromClause.removeItem(fromItemIndex);
  14.     newQuery.from(new FromItem(splitQuery).setAlias(alias));
  15.     result.add(newQuery);
  16.   }
  17.   return result;
  18. }

代码示例来源：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.datacleaner/DataCleaner-core

  1. q.from(new FromItem(table).setAlias("t"));
  2. q.select(columnsToQuery);
  3. SelectItem countAllItem = SelectItem.getCountAllItem();

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

  1. q.select(primaryColumns.toArray(new Column[primaryColumns.size()]));
  2. q.select(foreignColumns.toArray(new Column[foreignColumns.size()]));
  3. q.from(new FromItem(JoinType.LEFT, relationship));
  4. if (_log.isDebugEnabled()) {
  5.   _log.debug("Setting table data for '" + primaryTable.getName()

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

  1. q.select(primaryColumns.toArray(new Column[primaryColumns.size()]));
  2. q.select(foreignColumns.toArray(new Column[foreignColumns.size()]));
  3. q.from(new FromItem(JoinType.LEFT, relationship));
  4. if (_log.isDebugEnabled()) {
  5.   _log.debug("Setting table data for '" + primaryTableName

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

  1. private long getRowCount(Query q) {
  2.   q = q.clone();
  3.   SelectItem countAllItem = SelectItem.getCountAllItem();
  4.   if (q.getGroupByClause().getItemCount() > 0) {
  5.     q = new Query().from(new FromItem(q).setAlias("sq")).select(
  6.         countAllItem);
  7.   } else {
  8.     q.getSelectClause().removeItems();
  9.     q.select(countAllItem);
  10.   }
  11.   Row row = MetaModelHelper.executeSingleRowQuery(_dataContext, q);
  12.   Number count = (Number) row.getValue(countAllItem);
  13.   return count.longValue();
  14. }

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

  1. private long getRowCount(Query q) {
  2.   q = q.clone();
  3.   SelectItem countAllItem = SelectItem.getCountAllItem();
  4.   if (q.getGroupByClause().getItemCount() > 0) {
  5.     q = new Query().from(new FromItem(q).setAlias("sq")).select(
  6.         countAllItem);
  7.   } else {
  8.     q.getSelectClause().removeItems();
  9.     q.select(countAllItem);
  10.   }
  11.   Row row = MetaModelHelper.executeSingleRowQuery(_dataContext, q);
  12.   Number count = (Number) row.getValue(countAllItem);
  13.   return count.longValue();
  14. }

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

  1. ColumnType.VARCHAR);
  2. DataSet dataSet = executeQuery(new Query().select(columnsToQuery)
  3.     .from(table));

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

  1. SelectItem countAllItem = SelectItem.getCountAllItem();
  2. Query q = new Query().select(foreignColumns).select(
  3.     countAllItem).from(table).groupBy(foreignColumns);
  4. DataSet data = executeQuery(q);
  5. Comparable<Object> comparable = NumberComparator

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

  1. countAllItem).from(table).groupBy(
  2.     foreignColumns);
  3. DataSet data = executeQuery(q);

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

  1. values[1].setDetailSource(new Query().from(column.getTable())
  2.     .select(_columns).where(
  3.         new FilterItem(new SelectItem(column),
  4.   values[2].setDetailSource(new Query().from(
  5.       column.getTable()).select(_columns).where(
  6.       new FilterItem(new SelectItem(column),

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

  1. private List<Query> splitQueryBasedOnColumn(Column column) {
  2.   SelectItem maxItem = new SelectItem(FunctionType.MAX, column);
  3.   SelectItem minItem = new SelectItem(FunctionType.MIN, column);
  4.   Query q = new Query().from(column.getTable()).select(maxItem, minItem);
  5.   Row row = MetaModelHelper.executeSingleRowQuery(_dataContext, q);
  6.   long max = ceil((Number) row.getValue(maxItem));

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

  1. private List<Query> splitQueryBasedOnColumn(Column column) {
  2.   SelectItem maxItem = new SelectItem(FunctionType.MAX, column);
  3.   SelectItem minItem = new SelectItem(FunctionType.MIN, column);
  4.   Query q = new Query().from(column.getTable()).select(maxItem, minItem);
  5.   Row row = MetaModelHelper.executeSingleRowQuery(_dataContext, q);
  6.   long max = ceil((Number) row.getValue(maxItem));

代码示例来源：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. }

内容来源于网络，如有侵权，请联系作者删除！

query

相关文章

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com