• Home
• com.rapiddweller
• rd-lib-jdbacl
• 1.1.11-jdk-11
• source code
• DBCheckConstraint.java

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

com.rapiddweller.jdbacl.model.DBCheckConstraint Maven / Gradle / Ivy

/*
 * (c) Copyright 2011 by Volker Bergmann. All rights reserved.
 *
 * Redistribution and use in source and binary forms, with or without
 * modification, is permitted under the terms of the
 * GNU General Public License (GPL).
 *
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
 * WITHOUT A WARRANTY OF ANY KIND. ALL EXPRESS OR IMPLIED CONDITIONS,
 * REPRESENTATIONS AND WARRANTIES, INCLUDING ANY IMPLIED WARRANTY OF
 * MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE OR NON-INFRINGEMENT, ARE
 * HEREBY EXCLUDED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE
 * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
 * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
 * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
 * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
 * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
 * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
 * POSSIBILITY OF SUCH DAMAGE.
 */

package com.rapiddweller.jdbacl.model;

import com.rapiddweller.common.CollectionUtil;
import com.rapiddweller.common.StringUtil;
import com.rapiddweller.jdbacl.sql.ColumnExpression;
import com.rapiddweller.jdbacl.sql.SQLParserUtil;
import com.rapiddweller.jdbacl.sql.parser.ANTLRNoCaseStringStream;
import com.rapiddweller.script.Expression;
import com.rapiddweller.script.expression.WrapperExpression;

import java.util.HashSet;
import java.util.Set;

/**
 * Represents a database check constraint.


 * Created: 01.06.2011 12:40:30
 *
 * @author Volker Bergmann
 * @since 0.6.8
 */
public class DBCheckConstraint extends DBConstraint {

  private static final long serialVersionUID = 3766067048212751458L;

  private final String tableName;
  private final String conditionText;
  private final Expression condition;
  private final String[] columnNames;

  /**
   * Instantiates a new Db check constraint.
   *
   * @param name              the name
   * @param nameDeterministic the name deterministic
   * @param owner             the owner
   * @param conditionText     the condition text
   */
  public DBCheckConstraint(String name, boolean nameDeterministic, DBTable owner, String conditionText) {
    this(name, nameDeterministic, owner.getName(), conditionText);
    owner.addCheckConstraint(this);
  }

  /**
   * Instantiates a new Db check constraint.
   *
   * @param name              the name
   * @param nameDeterministic the name deterministic
   * @param tableName         the table name
   * @param conditionText     the condition text
   */
  public DBCheckConstraint(String name, boolean nameDeterministic, String tableName, String conditionText) {
    super(name, nameDeterministic, "check constraint", null);
    this.tableName = tableName;
    this.conditionText = conditionText;
    this.condition = SQLParserUtil.parseExpression(new ANTLRNoCaseStringStream(conditionText));
    this.columnNames = getColumnNames(condition);
  }

  /**
   * Gets table name.
   *
   * @return the table name
   */
  public String getTableName() {
    return tableName;
  }

  @Override
  public boolean isIdentical(DBObject other) {
    if (this == other) {
      return true;
    }
    if (other == null || !(other instanceof DBCheckConstraint)) {
      return false;
    }
    DBCheckConstraint that = (DBCheckConstraint) other;
    return this.name.equals(that.getName())
        && this.conditionText.equals(that.getConditionText());
  }

  /**
   * Is equivalent boolean.
   *
   * @param that the that
   * @return the boolean
   */
  public boolean isEquivalent(DBCheckConstraint that) {
    return this.tableName.equals(that.tableName)
        && StringUtil.normalizeSpace(this.conditionText).equals(StringUtil.normalizeSpace(that.getConditionText()));
  }

  /**
   * Gets condition text.
   *
   * @return the condition text
   */
  public String getConditionText() {
    return conditionText;
  }

  @Override
  public String[] getColumnNames() {
    return columnNames;
  }

  @Override
  public String toString() {
    return (name != null ? "CONSTRAINT " + name : "") + "CHECK " + conditionText;
  }

  private String[] getColumnNames(Expression condition) {
    return CollectionUtil.toArray(scanForColumns(condition, new HashSet<>()), String.class);
  }

  private Set scanForColumns(Expression expression, Set result) {
    if (expression instanceof ColumnExpression) {
      result.add(((ColumnExpression) expression).getColumnName());
    } else if (expression instanceof WrapperExpression) {
      for (Expression sourceExpression : ((WrapperExpression) expression).getSourceExpressions()) {
        scanForColumns(sourceExpression, result);
      }
    }
    return result;
  }

}