org.h2.command.dml.Query.getExpressions()方法的使用及代码示例

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

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

Query.getExpressions介绍

[英]The the list of select expressions. This may include invisible expressions such as order by expressions.
[中]选择表达式的列表。这可能包括不可见的表达式，如按顺序表达式。

代码示例

代码示例来源：origin: com.h2database/h2

  1. private Expression getExpression() {
  2.   if (expression == null) {
  3.     ArrayList<Expression> expressions = query.getExpressions();
  4.     int columnCount = query.getColumnCount();
  5.     if (columnCount == 1) {
  6.       expression = expressions.get(0);
  7.     } else {
  8.       Expression[] list = new Expression[columnCount];
  9.       for (int i = 0; i < columnCount; i++) {
  10.         list[i] = expressions.get(i);
  11.       }
  12.       expression = new ExpressionList(list);
  13.     }
  14.   }
  15.   return expression;
  16. }

代码示例来源：origin: com.h2database/h2

  1. ArrayList<Expression> withExpressions = theQuery.getExpressions();
  2. for (int i = 0; i < withExpressions.size(); ++i) {
  3.   Expression columnExp = withExpressions.get(i);

代码示例来源：origin: com.h2database/h2

  1. @Override
  2. public void init() {
  3.   if (SysProperties.CHECK && checkInit) {
  4.     DbException.throwInternalError();
  5.   }
  6.   checkInit = true;
  7.   left.init();
  8.   right.init();
  9.   int len = left.getColumnCount();
  10.   if (len != right.getColumnCount()) {
  11.     throw DbException.get(ErrorCode.COLUMN_COUNT_DOES_NOT_MATCH);
  12.   }
  13.   ArrayList<Expression> le = left.getExpressions();
  14.   // set the expressions to get the right column count and names,
  15.   // but can't validate at this time
  16.   expressions = New.arrayList();
  17.   for (int i = 0; i < len; i++) {
  18.     Expression l = le.get(i);
  19.     expressions.add(l);
  20.   }
  21. }

代码示例来源：origin: com.h2database/h2

  1. ArrayList<Expression> le = left.getExpressions();
  2. ArrayList<Expression> re = right.getExpressions();
  3. ColumnNamer columnNamer= new ColumnNamer(session);
  4. for (int i = 0; i < len; i++) {

代码示例来源：origin: apache/ignite

  1. /**
  2.  * @param qry Query.
  3.  * @param expCol Expression column.
  4.  * @param validate Query validation flag.
  5.  * @return {@code true} It it is an affinity column.
  6.  */
  7. private static boolean isAffinityColumn(Query qry, ExpressionColumn expCol, boolean validate) {
  8.   if (qry.isUnion()) {
  9.     SelectUnion union = (SelectUnion)qry;
  10.     return isAffinityColumn(union.getLeft(), expCol, validate) && isAffinityColumn(union.getRight(), expCol, validate);
  11.   }
  12.   Expression exp = qry.getExpressions().get(expCol.getColumn().getColumnId()).getNonAliasExpression();
  13.   if (exp instanceof ExpressionColumn) {
  14.     expCol = (ExpressionColumn)exp;
  15.     return isAffinityColumn(expCol.getTableFilter(), expCol, validate);
  16.   }
  17.   return false;
  18. }

代码示例来源：origin: com.h2database/h2

  1. private void generateColumnsFromQuery() {
  2.   int columnCount = asQuery.getColumnCount();
  3.   ArrayList<Expression> expressions = asQuery.getExpressions();
  4.   ColumnNamer columnNamer= new ColumnNamer(session);
  5.   for (int i = 0; i < columnCount; i++) {

代码示例来源：origin: com.h2database/h2

  1. this.querySQL = compiledQuery.getPlanSQL();
  2. tables = new ArrayList<>(compiledQuery.getTables());
  3. ArrayList<Expression> expressions = compiledQuery.getExpressions();
  4. ArrayList<Column> list = New.arrayList();
  5. ColumnNamer columnNamer = new ColumnNamer(session);

代码示例来源：origin: com.h2database/com.springsource.org.h2

  1. private Expression getExpression() {
  2.   return (Expression) query.getExpressions().get(0);
  3. }

代码示例来源：origin: com.eventsourcing/h2

  1. private Expression getExpression() {
  2.   if (expression == null) {
  3.     ArrayList<Expression> expressions = query.getExpressions();
  4.     int columnCount = query.getColumnCount();
  5.     if (columnCount == 1) {
  6.       expression = expressions.get(0);
  7.     } else {
  8.       Expression[] list = new Expression[columnCount];
  9.       for (int i = 0; i < columnCount; i++) {
  10.         list[i] = expressions.get(i);
  11.       }
  12.       expression = new ExpressionList(list);
  13.     }
  14.   }
  15.   return expression;
  16. }

代码示例来源：origin: org.wowtools/h2

  1. private Expression getExpression() {
  2.   if (expression == null) {
  3.     ArrayList<Expression> expressions = query.getExpressions();
  4.     int columnCount = query.getColumnCount();
  5.     if (columnCount == 1) {
  6.       expression = expressions.get(0);
  7.     } else {
  8.       Expression[] list = new Expression[columnCount];
  9.       for (int i = 0; i < columnCount; i++) {
  10.         list[i] = expressions.get(i);
  11.       }
  12.       expression = new ExpressionList(list);
  13.     }
  14.   }
  15.   return expression;
  16. }

代码示例来源：origin: com.h2database/com.springsource.org.h2

  1. public LocalResult queryMeta() throws SQLException {
  2.   ObjectArray expressions = left.getExpressions();
  3.   int columnCount = left.getColumnCount();
  4.   LocalResult result = new LocalResult(session, expressions, columnCount);
  5.   result.done();
  6.   return result;
  7. }

代码示例来源：origin: org.wowtools/h2

  1. @Override
  2. public void init() {
  3.   if (SysProperties.CHECK && checkInit) {
  4.     DbException.throwInternalError();
  5.   }
  6.   checkInit = true;
  7.   left.init();
  8.   right.init();
  9.   int len = left.getColumnCount();
  10.   if (len != right.getColumnCount()) {
  11.     throw DbException.get(ErrorCode.COLUMN_COUNT_DOES_NOT_MATCH);
  12.   }
  13.   ArrayList<Expression> le = left.getExpressions();
  14.   // set the expressions to get the right column count and names,
  15.   // but can't validate at this time
  16.   expressions = New.arrayList();
  17.   for (int i = 0; i < len; i++) {
  18.     Expression l = le.get(i);
  19.     expressions.add(l);
  20.   }
  21. }

代码示例来源：origin: com.eventsourcing/h2

  1. @Override
  2. public void init() {
  3.   if (SysProperties.CHECK && checkInit) {
  4.     DbException.throwInternalError();
  5.   }
  6.   checkInit = true;
  7.   left.init();
  8.   right.init();
  9.   int len = left.getColumnCount();
  10.   if (len != right.getColumnCount()) {
  11.     throw DbException.get(ErrorCode.COLUMN_COUNT_DOES_NOT_MATCH);
  12.   }
  13.   ArrayList<Expression> le = left.getExpressions();
  14.   // set the expressions to get the right column count and names,
  15.   // but can't validate at this time
  16.   expressions = New.arrayList();
  17.   for (int i = 0; i < len; i++) {
  18.     Expression l = le.get(i);
  19.     expressions.add(l);
  20.   }
  21. }

代码示例来源：origin: com.eventsourcing/h2

  1. ArrayList<Expression> le = left.getExpressions();
  2. ArrayList<Expression> re = right.getExpressions();
  3. for (int i = 0; i < len; i++) {
  4.   Expression l = le.get(i);

代码示例来源：origin: org.apache.ignite/ignite-indexing

  1. /**
  2.  * @param qry Query.
  3.  * @param expCol Expression column.
  4.  * @param validate Query validation flag.
  5.  * @return {@code true} It it is an affinity column.
  6.  */
  7. private static boolean isAffinityColumn(Query qry, ExpressionColumn expCol, boolean validate) {
  8.   if (qry.isUnion()) {
  9.     SelectUnion union = (SelectUnion)qry;
  10.     return isAffinityColumn(union.getLeft(), expCol, validate) && isAffinityColumn(union.getRight(), expCol, validate);
  11.   }
  12.   Expression exp = qry.getExpressions().get(expCol.getColumn().getColumnId()).getNonAliasExpression();
  13.   if (exp instanceof ExpressionColumn) {
  14.     expCol = (ExpressionColumn)exp;
  15.     return isAffinityColumn(expCol.getTableFilter(), expCol, validate);
  16.   }
  17.   return false;
  18. }

代码示例来源：origin: org.wowtools/h2

  1. private void generateColumnsFromQuery() {
  2.   int columnCount = asQuery.getColumnCount();
  3.   ArrayList<Expression> expressions = asQuery.getExpressions();
  4.   for (int i = 0; i < columnCount; i++) {
  5.     Expression expr = expressions.get(i);
  6.     int type = expr.getType();
  7.     String name = expr.getAlias();
  8.     long precision = expr.getPrecision();
  9.     int displaySize = expr.getDisplaySize();
  10.     DataType dt = DataType.getDataType(type);
  11.     if (precision > 0 && (dt.defaultPrecision == 0 ||
  12.         (dt.defaultPrecision > precision && dt.defaultPrecision < Byte.MAX_VALUE))) {
  13.       // dont' set precision to MAX_VALUE if this is the default
  14.       precision = dt.defaultPrecision;
  15.     }
  16.     int scale = expr.getScale();
  17.     if (scale > 0 && (dt.defaultScale == 0 ||
  18.         (dt.defaultScale > scale && dt.defaultScale < precision))) {
  19.       scale = dt.defaultScale;
  20.     }
  21.     if (scale > precision) {
  22.       precision = scale;
  23.     }
  24.     Column col = new Column(name, type, precision, scale, displaySize);
  25.     addColumn(col);
  26.   }
  27. }

代码示例来源：origin: com.eventsourcing/h2

  1. private void generateColumnsFromQuery() {
  2.   int columnCount = asQuery.getColumnCount();
  3.   ArrayList<Expression> expressions = asQuery.getExpressions();
  4.   for (int i = 0; i < columnCount; i++) {
  5.     Expression expr = expressions.get(i);
  6.     int type = expr.getType();
  7.     String name = expr.getAlias();
  8.     long precision = expr.getPrecision();
  9.     int displaySize = expr.getDisplaySize();
  10.     DataType dt = DataType.getDataType(type);
  11.     if (precision > 0 && (dt.defaultPrecision == 0 ||
  12.         (dt.defaultPrecision > precision && dt.defaultPrecision < Byte.MAX_VALUE))) {
  13.       // dont' set precision to MAX_VALUE if this is the default
  14.       precision = dt.defaultPrecision;
  15.     }
  16.     int scale = expr.getScale();
  17.     if (scale > 0 && (dt.defaultScale == 0 ||
  18.         (dt.defaultScale > scale && dt.defaultScale < precision))) {
  19.       scale = dt.defaultScale;
  20.     }
  21.     if (scale > precision) {
  22.       precision = scale;
  23.     }
  24.     Column col = new Column(name, type, precision, scale, displaySize);
  25.     addColumn(col);
  26.   }
  27. }

代码示例来源：origin: com.h2database/com.springsource.org.h2

  1. public void init() throws SQLException {
  2.   if (SysProperties.CHECK && checkInit) {
  3.     throw Message.getInternalError();
  4.   }
  5.   checkInit = true;
  6.   left.init();
  7.   right.init();
  8.   int len = left.getColumnCount();
  9.   if (len != right.getColumnCount()) {
  10.     throw Message.getSQLException(ErrorCode.COLUMN_COUNT_DOES_NOT_MATCH);
  11.   }
  12.   ObjectArray le = left.getExpressions();
  13.   // set the expressions to get the right column count and names,
  14.   // but can't validate at this time
  15.   expressions = new ObjectArray();
  16.   for (int i = 0; i < len; i++) {
  17.     Expression l = (Expression) le.get(i);
  18.     expressions.add(l);
  19.   }
  20. }

代码示例来源：origin: com.h2database/com.springsource.org.h2

  1. ObjectArray le = left.getExpressions();
  2. ObjectArray re = right.getExpressions();
  3. for (int i = 0; i < len; i++) {
  4.   Expression l = (Expression) le.get(i);

代码示例来源：origin: com.h2database/com.springsource.org.h2

  1. private void generateColumnFromQuery() throws SQLException {
  2.   int columnCount = asQuery.getColumnCount();
  3.   ObjectArray expressions = asQuery.getExpressions();
  4.   for (int i = 0; i < columnCount; i++) {
  5.     Expression expr = (Expression) expressions.get(i);
  6.     int type = expr.getType();
  7.     String name = expr.getColumnName();
  8.     long precision = expr.getPrecision();
  9.     int displaySize = expr.getDisplaySize();
  10.     DataType dt = DataType.getDataType(type);
  11.     if (precision > 0 && (dt.defaultPrecision == 0 || (dt.defaultPrecision > precision && dt.defaultPrecision < Byte.MAX_VALUE))) {
  12.       // dont' set precision to MAX_VALUE if this is the default
  13.       precision = dt.defaultPrecision;
  14.     }
  15.     int scale = expr.getScale();
  16.     if (scale > 0 && (dt.defaultScale == 0 || dt.defaultScale > scale)) {
  17.       scale = dt.defaultScale;
  18.     }
  19.     Column col = new Column(name, type, precision, scale, displaySize);
  20.     addColumn(col);
  21.   }
  22. }

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

query

相关文章

    查看更多

    热门标签

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

    最新文章

    更多

    Query类方法

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