net.sf.jsqlparser.statement.select.Join.getOnExpression()方法的使用及代码示例

x33g5p2x  于2022-01-21 转载在 其他  
字(6.8k)|赞(0)|评价(0)|浏览(1128)

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

Join.getOnExpression介绍

[英]Returns the "ON" expression (if any)
[中]返回“ON”表达式(如果有)

代码示例

代码示例来源:origin: baomidou/mybatis-plus

/**
 * 如果SQL用了 left Join,验证是否有or、not等等,并且验证是否使用了索引
 *
 * @param joins ignore
 * @param table ignore
 * @param connection ignore
 */
private static void validJoins(List<Join> joins, Table table, Connection connection) {
  //允许执行join,验证jion是否使用索引等等
  if (joins != null) {
    for (Join join : joins) {
      Table rightTable = (Table) join.getRightItem();
      Expression expression = join.getOnExpression();
      validWhere(expression, table, rightTable, connection);
    }
  }
}

代码示例来源:origin: alibaba/mdrill

if (join.getOnExpression() != null) {
  buffer.append(" ON ");
  join.getOnExpression().accept(expressionVisitor);

代码示例来源:origin: JSQLParser/JSqlParser

buffer.append(join.getJoinWindow().toString());
if (join.getOnExpression() != null) {
  buffer.append(" ON ");
  join.getOnExpression().accept(expressionVisitor);

代码示例来源:origin: baomidou/mybatis-plus

/**
 * 处理联接语句
 */
protected void processJoin(Join join) {
  if (join.getRightItem() instanceof Table) {
    Table fromTable = (Table) join.getRightItem();
    if (this.tenantHandler.doTableFilter(fromTable.getName())) {
      // 过滤退出执行
      return;
    }
    join.setOnExpression(builderExpression(join.getOnExpression(), fromTable));
  }
}

代码示例来源:origin: diennea/herddb

private void visitJoin(Join j) {
  if (j.getOnExpression() != null) {
    j.getOnExpression().accept(this);
  };
  if (j.getRightItem() != null) {
    j.getRightItem().accept(this);
  }
}

代码示例来源:origin: com.baomidou/mybatis-plus-extension

/**
 * 如果SQL用了 left Join,验证是否有or、not等等,并且验证是否使用了索引
 *
 * @param joins
 * @param table
 * @param connection
 */
private static void validJoins(List<Join> joins, Table table, Connection connection) {
  //允许执行join,验证jion是否使用索引等等
  if (joins != null) {
    for (Join join : joins) {
      Table rightTable = (Table) join.getRightItem();
      Expression expression = join.getOnExpression();
      validWhere(expression, table, rightTable, connection);
    }
  }
}

代码示例来源:origin: org.opencadc/cadc-jsqlparser-compat

if (join.getOnExpression() != null) {
  buffer.append(" ON ");
  join.getOnExpression().accept(expressionVisitor);

代码示例来源:origin: org.opencadc/cadc-adql

if (join.getOnExpression() != null) {
  buffer.append(" ON ");
  join.getOnExpression().accept(expressionVisitor);

代码示例来源:origin: com.github.jsqlparser/jsqlparser

buffer.append(join.getJoinWindow().toString());
if (join.getOnExpression() != null) {
  buffer.append(" ON ");
  join.getOnExpression().accept(expressionVisitor);

代码示例来源:origin: org.opencadc/cadc-adql

@SuppressWarnings("unchecked")
protected void navigateJoins()
{
  PlainSelect ps = this.plainSelect;
  List<Join> joins = ps.getJoins();
  if (joins != null)
  {
    for (Join join : joins)
    {
      FromItem fromItem = join.getRightItem();
      if (fromItem instanceof Table)
      {
        Table rightTable = (Table) join.getRightItem();
        rightTable.accept(this.fromItemNavigator);
        if (join.getOnExpression() != null) join.getOnExpression().accept(this.expressionNavigator);
        List<Column> columns = join.getUsingColumns();
        if (columns != null) for (Column column : columns)
          column.accept(this.expressionNavigator);
      }
      else if (fromItem instanceof SubSelect)
        throw new UnsupportedOperationException("sub-select not supported in FROM clause.");
    }
  }
}

代码示例来源:origin: com.eas.platypus/platypus-js-sql-parser

if (join.getOnExpression() != null) {
  buffer.append(join.getCommentOn() != null ? " " + join.getCommentOn() + ExpressionDeParser.LINE_SEPARATOR : "").append(" on ");
  join.getOnExpression().accept(expressionVisitor);

代码示例来源:origin: com.baomidou/mybatis-plus-extension

/**
 * 处理联接语句
 */
protected void processJoin(Join join) {
  if (join.getRightItem() instanceof Table) {
    Table fromTable = (Table) join.getRightItem();
    if (this.tenantHandler.doTableFilter(fromTable.getName())) {
      // 过滤退出执行
      return;
    }
    join.setOnExpression(builderExpression(join.getOnExpression(), fromTable));
  }
}

代码示例来源:origin: Mearalu/mybatis-multi-tenancy

/**
 * 处理联接语句
 *
 * @param join
 */
public void processJoin(Join join) {
  if (join.getRightItem() instanceof Table) {
    Table fromTable = (Table) join.getRightItem();
    if (doTableFilter(fromTable.getName())) {
      join.setOnExpression(builderExpression(join.getOnExpression(), fromTable));
    }
  }
}

代码示例来源:origin: org.opencadc/cadc-adql

Expression e = join.getOnExpression();
Expression implExpression = convertToImplementation(e);
log.debug("PlainSelect/JOIN: replacing " + e + " with " + implExpression);

代码示例来源:origin: ddf-project/DDF

().getName());
if (join.getOnExpression() != null) {
  join.getOnExpression().accept(this);

代码示例来源:origin: it.unibz.inf.ontop/ontop-mapping-sql-core

if (join.getOnExpression() != null || join.getUsingColumns() != null)
  throw new InvalidSelectQueryRuntimeException("CROSS JOIN cannot have USING/ON conditions", join);
if (join.getOnExpression() != null || join.getUsingColumns() != null)
  throw new InvalidSelectQueryRuntimeException("NATURAL JOIN cannot have USING/ON conditions", join);
if (join.getOnExpression() != null) {
  if (join.getUsingColumns() !=null)
    throw new InvalidSelectQueryRuntimeException("JOIN cannot have both USING and ON", join);
          .parseBooleanExpression(join.getOnExpression())));

代码示例来源:origin: ontop/ontop

if (join.getOnExpression() != null || join.getUsingColumns() != null)
  throw new InvalidSelectQueryRuntimeException("CROSS JOIN cannot have USING/ON conditions", join);
if (join.getOnExpression() != null || join.getUsingColumns() != null)
  throw new InvalidSelectQueryRuntimeException("NATURAL JOIN cannot have USING/ON conditions", join);
if (join.getOnExpression() != null) {
  if (join.getUsingColumns() !=null)
    throw new InvalidSelectQueryRuntimeException("JOIN cannot have both USING and ON", join);
          .parseBooleanExpression(join.getOnExpression())), termFactory);

代码示例来源:origin: it.unibz.inf.ontop/ontop-mapping-sql-core

if (join.getOnExpression() != null || join.getUsingColumns() != null)
  throw new InvalidSelectQueryRuntimeException("CROSS JOIN cannot have USING/ON conditions", join);
if (join.getOnExpression() != null || join.getUsingColumns() != null)
  throw new InvalidSelectQueryRuntimeException("NATURAL JOIN cannot have USING/ON conditions", join);
if (join.getOnExpression() != null) {
  if (join.getUsingColumns() !=null)
    throw new InvalidSelectQueryRuntimeException("JOIN cannot have both USING and ON", join);

代码示例来源:origin: ontop/ontop

if (join.getOnExpression() != null || join.getUsingColumns() != null)
  throw new InvalidSelectQueryRuntimeException("CROSS JOIN cannot have USING/ON conditions", join);
if (join.getOnExpression() != null || join.getUsingColumns() != null)
  throw new InvalidSelectQueryRuntimeException("NATURAL JOIN cannot have USING/ON conditions", join);
if (join.getOnExpression() != null) {
  if (join.getUsingColumns() !=null)
    throw new InvalidSelectQueryRuntimeException("JOIN cannot have both USING and ON", join);

代码示例来源:origin: it.unibz.inf.ontop/ontop-obdalib-core

Expression expr = join.getOnExpression();

相关文章