com.arcadedb.query.sql.parser.InCondition Maven / Gradle / Ivy

Go to download
/*
 * Copyright © 2021-present Arcade Data Ltd ([email protected])
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 *
 * SPDX-FileCopyrightText: 2021-present Arcade Data Ltd ([email protected])
 * SPDX-License-Identifier: Apache-2.0
 */
/* Generated By:JJTree: Do not edit this line. OInCondition.java Version 4.3 */
/* JavaCCOptions:MULTI=true,NODE_USES_PARSER=false,VISITOR=true,TRACK_TOKENS=true,NODE_PREFIX=O,NODE_EXTENDS=,NODE_FACTORY=,SUPPORT_USERTYPE_VISIBILITY_PUBLIC=true */
package com.arcadedb.query.sql.parser;

import com.arcadedb.database.Identifiable;
import com.arcadedb.query.sql.executor.BasicCommandContext;
import com.arcadedb.query.sql.executor.CommandContext;
import com.arcadedb.query.sql.executor.IndexSearchInfo;
import com.arcadedb.query.sql.executor.MultiValue;
import com.arcadedb.query.sql.executor.QueryOperatorEquals;
import com.arcadedb.query.sql.executor.Result;
import com.arcadedb.query.sql.executor.ResultSet;
import com.arcadedb.utility.CodeUtils;

import java.util.*;
import java.util.stream.*;

public class InCondition extends BooleanExpression {
  protected Expression            left;
  protected BinaryCompareOperator operator;
  protected SelectStatement       rightStatement;
  protected InputParameter        rightParam;
  protected MathExpression        rightMathExpression;
  protected Object                right;

  private static final Object UNSET           = new Object();
  private final        Object inputFinalValue = UNSET;

  public InCondition(final int id) {
    super(id);
  }

  @Override
  public Boolean evaluate(final Identifiable currentRecord, final CommandContext context) {
    final Object leftVal = evaluateLeft(currentRecord, context);
    final Object rightVal = evaluateRight(currentRecord, context);
    if (rightVal == null)
      return false;

    return evaluateExpression(leftVal, rightVal);
  }

  public Object evaluateRight(final Identifiable currentRecord, final CommandContext context) {
    Object rightVal = null;
    if (rightStatement != null)
      rightVal = executeQuery(rightStatement, context);
    else if (rightParam != null)
      rightVal = rightParam.getValue(context.getInputParameters());
    else if (rightMathExpression != null)
      rightVal = rightMathExpression.execute(currentRecord, context);

    return rightVal;
  }

  public Object evaluateLeft(final Identifiable currentRecord, final CommandContext context) {
    return left.execute(currentRecord, context);
  }

  @Override
  public Boolean evaluate(final Result currentRecord, final CommandContext context) {
    final Object leftVal = evaluateLeft(currentRecord, context);
    final Object rightVal = evaluateRight(currentRecord, context);
    if (rightVal == null)
      return false;

    return evaluateExpression(leftVal, rightVal);
  }

  public Object evaluateRight(final Result currentRecord, final CommandContext context) {
    Object rightVal = null;
    if (rightStatement != null)
      rightVal = executeQuery(rightStatement, context);
    else if (rightParam != null)
      rightVal = rightParam.getValue(context.getInputParameters());
    else if (rightMathExpression != null)
      rightVal = rightMathExpression.execute(currentRecord, context);

    return rightVal;
  }

  public Object evaluateLeft(final Result currentRecord, final CommandContext context) {
    return left.execute(currentRecord, context);
  }

  protected static Object executeQuery(final SelectStatement rightStatement, final CommandContext context) {
    final BasicCommandContext subcontext = new BasicCommandContext();
    subcontext.setParentWithoutOverridingChild(context);
    final ResultSet result = rightStatement.execute(context.getDatabase(), context.getInputParameters());
    return result.stream().collect(Collectors.toSet());
  }

  protected static boolean evaluateExpression(final Object iLeft, final Object iRight) {
    if (MultiValue.isMultiValue(iRight)) {
      if (iRight instanceof Set)
        return ((Set) iRight).contains(iLeft);

      for (final Object o : MultiValue.getMultiValueIterable(iRight, false)) {
        if (QueryOperatorEquals.equals(iLeft, o))
          return true;
        if (MultiValue.isMultiValue(iLeft) && MultiValue.getSize(iLeft) == 1) {

          final Object item = MultiValue.getFirstValue(iLeft);
          if (item instanceof Result && ((Result) item).getPropertyNames().size() == 1) {
            final Object propValue = ((Result) item).getProperty(((Result) item).getPropertyNames().iterator().next());
            if (QueryOperatorEquals.equals(propValue, o))
              return true;
          }
        }

      }
    } else if (iRight.getClass().isArray()) {
      for (final Object o : (Object[]) iRight) {
        if (QueryOperatorEquals.equals(iLeft, o))
          return true;
      }
    } else if (iRight instanceof ResultSet) {
      final ResultSet rsRight = (ResultSet) iRight;
      rsRight.reset();
      while (((ResultSet) iRight).hasNext()) {
        if (QueryOperatorEquals.equals(iLeft, rsRight.next())) {
          return true;
        }
      }
    }

    return CodeUtils.compare(iLeft, iRight);
  }

  public void toString(final Map params, final StringBuilder builder) {
    left.toString(params, builder);
    builder.append(" IN ");
    if (rightStatement != null) {
      builder.append("(");
      rightStatement.toString(params, builder);
      builder.append(")");
    } else if (right != null) {
      builder.append(convertToString(right));
    } else if (rightParam != null) {
      rightParam.toString(params, builder);
    } else if (rightMathExpression != null) {
      rightMathExpression.toString(params, builder);
    }
  }

  private String convertToString(final Object o) {
    if (o instanceof String)
      return "\"" + ((String) o).replaceAll("\"", "\\\"") + "\"";

    return o.toString();
  }

  @Override
  public InCondition copy() {
    final InCondition result = new InCondition(-1);
    result.operator = operator == null ? null : operator.copy();
    result.left = left == null ? null : left.copy();
    result.rightMathExpression = rightMathExpression == null ? null : rightMathExpression.copy();
    result.rightStatement = rightStatement == null ? null : rightStatement.copy();
    result.rightParam = rightParam == null ? null : rightParam.copy();
    result.right = right;
    return result;
  }

  @Override
  public void extractSubQueries(final SubQueryCollector collector) {
    if (left != null)
      left.extractSubQueries(collector);

    if (rightMathExpression != null)
      rightMathExpression.extractSubQueries(collector);

    if (rightStatement != null) {
      final Identifier alias = collector.addStatement(rightStatement);
      rightMathExpression = new BaseExpression(alias);
      rightStatement = null;
    }
  }

  @Override
  protected Object[] getIdentityElements() {
    return new Object[] { left, operator, rightStatement, rightParam, rightMathExpression, right, inputFinalValue };
  }

  @Override
  public List getMatchPatternInvolvedAliases() {
    final List leftX = left == null ? null : left.getMatchPatternInvolvedAliases();
    final List conditionX = rightMathExpression == null ? null : rightMathExpression.getMatchPatternInvolvedAliases();

    final List result = new ArrayList<>();
    if (leftX != null)
      result.addAll(leftX);

    if (conditionX != null)
      result.addAll(conditionX);

    return result.isEmpty() ? null : result;
  }

  @Override
  protected SimpleNode[] getCacheableElements() {
    return new SimpleNode[] { left, rightStatement, rightMathExpression };
  }

  public Expression getLeft() {
    return left;
  }

  public void setLeft(final Expression left) {
    this.left = left;
  }

  public SelectStatement getRightStatement() {
    return rightStatement;
  }

  public InputParameter getRightParam() {
    return rightParam;
  }

  public MathExpression getRightMathExpression() {
    return rightMathExpression;
  }

  public void setRightParam(final InputParameter rightParam) {
    this.rightParam = rightParam;
  }

  public void setRightMathExpression(final MathExpression rightMathExpression) {
    this.rightMathExpression = rightMathExpression;
  }

  public boolean isIndexAware(final IndexSearchInfo info) {
    if (left.isBaseIdentifier()) {
      if (info.getField().equals(left.getDefaultAlias().getStringValue())) {
        if (rightMathExpression != null) {
          return rightMathExpression.isEarlyCalculated(info.getContext());
        } else
          return rightParam != null;
      }
    }
    return false;
  }

  @Override
  public Expression resolveKeyFrom(final BinaryCondition additional) {
    Expression item = new Expression(-1);
    if (getRightMathExpression() != null) {
      item.setMathExpression(getRightMathExpression());
      return item;
    } else if (getRightParam() != null) {
      BaseExpression e = new BaseExpression(-1);
      e.setInputParam(getRightParam().copy());
      item.setMathExpression(e);
      return item;
    } else {
      throw new UnsupportedOperationException("Cannot execute index query with " + this);
    }
  }

  @Override
  public Expression resolveKeyTo(final BinaryCondition additional) {
    Expression item = new Expression(-1);
    if (getRightMathExpression() != null) {
      item.setMathExpression(getRightMathExpression());
      return item;
    } else if (getRightParam() != null) {
      BaseExpression e = new BaseExpression(-1);
      e.setInputParam(getRightParam().copy());
      item.setMathExpression(e);
      return item;
    } else {
      throw new UnsupportedOperationException("Cannot execute index query with " + this);
    }
  }
}
/* JavaCC - OriginalChecksum=00df7cb1877c0a12d24205c1700653c7 (do not edit this line) */