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

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

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

Query.getFromClause介绍

暂无

代码示例

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

  1. /**
  2.  * Examines a query and extracts an array of FromItem's that refer
  3.  * (directly) to tables (hence Joined FromItems and SubQuery FromItems are
  4.  * traversed but not included).
  5.  * 
  6.  * @param q
  7.  *            the query to examine
  8.  * @return
  9.  */
  10. public static FromItem[] getTableFromItems(Query q) {
  11.   List<FromItem> result = new ArrayList<FromItem>();
  12.   List<FromItem> items = q.getFromClause().getItems();
  13.   for (FromItem item : items) {
  14.     result.addAll(getTableFromItems(item));
  15.   }
  16.   return result.toArray(new FromItem[result.size()]);
  17. }

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

  1. private Integer getSubQueryFromItemIndex() {
  2.   List<FromItem> fromItems = _query.getFromClause().getItems();
  3.   for (int i = 0; i < fromItems.size(); i++) {
  4.     Query subQuery = fromItems.get(i).getSubQuery();
  5.     if (subQuery != null) {
  6.       if (isSplittable(subQuery)) {
  7.         return i;
  8.       }
  9.     }
  10.   }
  11.   return null;
  12. }

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

  1. private Integer getSubQueryFromItemIndex() {
  2.   List<FromItem> fromItems = _query.getFromClause().getItems();
  3.   for (int i = 0; i < fromItems.size(); i++) {
  4.     Query subQuery = fromItems.get(i).getSubQuery();
  5.     if (subQuery != null) {
  6.       if (isSplittable(subQuery)) {
  7.         return i;
  8.       }
  9.     }
  10.   }
  11.   return null;
  12. }

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

  1. @Override
  2. public boolean equals(Object obj) {
  3.   if (obj == this) {
  4.     return true;
  5.   }
  6.   if (obj instanceof Query) {
  7.     Query that = (Query) obj;
  8.     EqualsBuilder eb = new EqualsBuilder();
  9.     eb.append(this.getMaxRows(), that.getMaxRows());
  10.     eb.append(this.getSelectClause(), that.getSelectClause());
  11.     eb.append(this.getFromClause(), that.getFromClause());
  12.     eb.append(this.getWhereClause(), that.getWhereClause());
  13.     eb.append(this.getGroupByClause(), that.getGroupByClause());
  14.     eb.append(this.getHavingClause(), that.getHavingClause());
  15.     eb.append(this.getOrderByClause(), that.getOrderByClause());
  16.     return eb.isEquals();
  17.   }
  18.   return false;
  19. }

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

  1. public StringBuilder toStringNoAlias() {
  2.   StringBuilder sb = new StringBuilder();
  3.   if (_column != null) {
  4.     Table table = _column.getTable();
  5.     if (table != null && _query != null) {
  6.       String alias = _query.getFromClause().getAlias(table);
  7.       if (alias == null) {
  8.         alias = table.getQuotedName();
  9.       }
  10.       sb.append(alias);
  11.       sb.append(".");
  12.     }
  13.     sb.append(_column.getQuotedName());
  14.   }
  15.   if (_expression != null) {
  16.     sb.append(_expression);
  17.   }
  18.   if (_subQueryFromItem != null && _subQuerySelectItem != null) {
  19.     if (_subQueryFromItem.getAlias() != null) {
  20.       sb.append(_subQueryFromItem.getAlias() + '.');
  21.     }
  22.     sb.append(_subQuerySelectItem.getSuperQueryAlias());
  23.   }
  24.   if (_function != null) {
  25.     sb.insert(0, _function + "(");
  26.     sb.append(")");
  27.   }
  28.   return sb;
  29. }

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

  1. Table table = _column.getTable();
  2. if (table != null && _query != null) {
  3.   String alias = _query.getFromClause().getAlias(table);
  4.   if (alias == null) {
  5.     alias = table.getQuotedName();

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

  1. public String rewriteQuery(JdbcDataContextStrategy strategy, Query query) {
  2.   query = beforeRewrite(strategy, query);
  3.   StringBuilder sb = new StringBuilder();
  4.   sb
  5.       .append(rewriteSelectClause(strategy, query, query
  6.           .getSelectClause()));
  7.   sb.append(rewriteFromClause(strategy, query, query.getFromClause()));
  8.   sb.append(rewriteWhereClause(strategy, query, query.getWhereClause()));
  9.   sb.append(rewriteGroupByClause(strategy, query, query
  10.       .getGroupByClause()));
  11.   sb
  12.       .append(rewriteHavingClause(strategy, query, query
  13.           .getHavingClause()));
  14.   sb.append(rewriteOrderByClause(strategy, query, query
  15.       .getOrderByClause()));
  16.   return sb.toString();
  17. }

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

  1. public String rewriteQuery(JdbcDataContextStrategy strategy, Query query) {
  2.   query = beforeRewrite(strategy, query);
  3.   StringBuilder sb = new StringBuilder();
  4.   sb
  5.       .append(rewriteSelectClause(strategy, query, query
  6.           .getSelectClause()));
  7.   sb.append(rewriteFromClause(strategy, query, query.getFromClause()));
  8.   sb.append(rewriteWhereClause(strategy, query, query.getWhereClause()));
  9.   sb.append(rewriteGroupByClause(strategy, query, query
  10.       .getGroupByClause()));
  11.   sb
  12.       .append(rewriteHavingClause(strategy, query, query
  13.           .getHavingClause()));
  14.   sb.append(rewriteOrderByClause(strategy, query, query
  15.       .getOrderByClause()));
  16.   return sb.toString();
  17. }

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

  1. public DataSet executeQuery(Query query) throws MetaModelException {
  2.   Set<DataContext> dataContexts = new HashSet<DataContext>();
  3.   List<FromItem> items = query.getFromClause().getItems();
  4.   for (FromItem item : items) {
  5.     List<FromItem> tableFromItems = MetaModelHelper

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

  1. public DataSet executeQuery(Query query) {
  2.   List<SelectItem> selectItems = query.getSelectClause().getItems();
  3.   List<FromItem> fromItems = query.getFromClause().getItems();
  4.   List<FilterItem> whereItems = query.getWhereClause().getItems();
  5.   List<SelectItem> whereSelectItems = query.getWhereClause()

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

  1. public DataSet executeQuery(Query query) {
  2.   List<SelectItem> selectItems = query.getSelectClause().getItems();
  3.   List<FromItem> fromItems = query.getFromClause().getItems();
  4.   List<FilterItem> whereItems = query.getWhereClause().getItems();
  5.   List<SelectItem> whereSelectItems = query.getWhereClause()

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

  1. @Override
  2. protected Query beforeRewrite(JdbcDataContextStrategy strategy, Query query) {
  3.   query = query.clone();
  4.   if (strategy != null) {
  5.     String identifierQuoteString = strategy.getIdentifierQuoteString();
  6.     if (identifierQuoteString != null) {
  7.       List<SelectItem> selectItems = query.getSelectClause()
  8.           .getItems();
  9.       for (SelectItem item : selectItems) {
  10.         String alias = item.getAlias();
  11.         if (needsQuoting(alias, identifierQuoteString)) {
  12.           item.setAlias(identifierQuoteString + alias
  13.               + identifierQuoteString);
  14.         }
  15.       }
  16.       List<FromItem> fromItems = query.getFromClause().getItems();
  17.       for (FromItem item : fromItems) {
  18.         String alias = item.getAlias();
  19.         if (needsQuoting(alias, identifierQuoteString)) {
  20.           item.setAlias(identifierQuoteString + alias
  21.               + identifierQuoteString);
  22.         }
  23.       }
  24.     }
  25.   }
  26.   return query;
  27. }

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

  1. List<FromItem> fromItems = _query.getFromClause().getItems();
  2. for (FromItem fromItem : fromItems) {
  3.   if (fromItem.getTable() != null) {

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

  1. @Override
  2. protected Query beforeRewrite(JdbcDataContextStrategy strategy, Query query) {
  3.   query = query.clone();
  4.   if (strategy != null) {
  5.     String identifierQuoteString = strategy.getIdentifierQuoteString();
  6.     if (identifierQuoteString != null) {
  7.       List<SelectItem> selectItems = query.getSelectClause()
  8.           .getItems();
  9.       for (SelectItem item : selectItems) {
  10.         String alias = item.getAlias();
  11.         if (needsQuoting(alias, identifierQuoteString)) {
  12.           item.setAlias(identifierQuoteString + alias
  13.               + identifierQuoteString);
  14.         }
  15.       }
  16.       List<FromItem> fromItems = query.getFromClause().getItems();
  17.       for (FromItem item : fromItems) {
  18.         String alias = item.getAlias();
  19.         if (needsQuoting(alias, identifierQuoteString)) {
  20.           item.setAlias(identifierQuoteString + alias
  21.               + identifierQuoteString);
  22.         }
  23.       }
  24.     }
  25.   }
  26.   return query;
  27. }

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

  1. List<FromItem> fromItems = _query.getFromClause().getItems();
  2. for (FromItem fromItem : fromItems) {
  3.   if (fromItem.getTable() != null) {

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

query

相关文章

    查看更多

    热门标签

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

    最新文章

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