/* Copyright (c) 2001-2019, The HSQL Development Group
* All rights reserved.
*
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions are met:
*
* Redistributions of source code must retain the above copyright notice, this
* list of conditions and the following disclaimer.
*
* Redistributions in binary form must reproduce the above copyright notice,
* this list of conditions and the following disclaimer in the documentation
* and/or other materials provided with the distribution.
*
* Neither the name of the HSQL Development Group nor the names of its
* contributors may be used to endorse or promote products derived from this
* software without specific prior written permission.
*
* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
* AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
* IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
* ARE DISCLAIMED. IN NO EVENT SHALL HSQL DEVELOPMENT GROUP, HSQLDB.ORG,
* 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 org.hsqldb.types;
import org.hsqldb.Constraint;
import org.hsqldb.Expression;
import org.hsqldb.HsqlNameManager.HsqlName;
import org.hsqldb.SchemaObject;
import org.hsqldb.Session;
import org.hsqldb.Tokens;
import org.hsqldb.lib.ArrayUtil;
import org.hsqldb.lib.OrderedHashSet;
import org.hsqldb.rights.Grantee;
Class for DOMAIN and DISTINCT objects.
Author: Fred Toussi (fredt@users dot sourceforge.net) Version: 2.5.0 Since: 1.9.0
/**
* Class for DOMAIN and DISTINCT objects.<p>
*
* @author Fred Toussi (fredt@users dot sourceforge.net)
* @version 2.5.0
* @since 1.9.0
*/
public class UserTypeModifier {
final HsqlName name;
final int schemaObjectType;
final Type dataType;
Constraint[] constraints = Constraint.emptyArray;
Expression defaultExpression;
boolean isNullable = true;
public UserTypeModifier(HsqlName name, int type, Type dataType) {
this.name = name;
this.schemaObjectType = type;
this.dataType = dataType;
}
public int schemaObjectType() {
return schemaObjectType;
}
public void addConstraint(Constraint c) {
int position = constraints.length;
constraints = (Constraint[]) ArrayUtil.resizeArray(constraints,
position + 1);
constraints[position] = c;
setNotNull();
}
public void removeConstraint(String name) {
for (int i = 0; i < constraints.length; i++) {
if (constraints[i].getName().name.equals(name)) {
constraints =
(Constraint[]) ArrayUtil.toAdjustedArray(constraints,
null, i, -1);
break;
}
}
setNotNull();
}
public Constraint getConstraint(String name) {
for (int i = 0; i < constraints.length; i++) {
if (constraints[i].getName().name.equals(name)) {
return constraints[i];
}
}
return null;
}
public Constraint[] getConstraints() {
return constraints;
}
public boolean isNullable() {
return isNullable;
}
public Expression getDefaultClause() {
return defaultExpression;
}
public void setDefaultClause(Expression defaultExpression) {
this.defaultExpression = defaultExpression;
}
public void removeDefaultClause() {
defaultExpression = null;
}
private void setNotNull() {
isNullable = true;
for (int i = 0; i < constraints.length; i++) {
if (constraints[i].isNotNull()) {
isNullable = false;
}
}
}
// interface specific methods
public int getType() {
return schemaObjectType;
}
public HsqlName getName() {
return name;
}
public HsqlName getSchemaName() {
return name.schema;
}
public Grantee getOwner() {
return name.schema.owner;
}
public OrderedHashSet getReferences() {
OrderedHashSet set = new OrderedHashSet();
for (int i = 0; i < constraints.length; i++) {
OrderedHashSet subSet = constraints[i].getReferences();
if (subSet != null) {
set.addAll(subSet);
}
}
Collation collation = dataType.getCollation();
if (collation != null && collation.isObjectCollation()) {
set.add(collation.getName());
}
return set;
}
public final OrderedHashSet getComponents() {
if (constraints == null) {
return null;
}
OrderedHashSet set = new OrderedHashSet();
set.addAll(constraints);
return set;
}
public void compile(Session session) {
for (int i = 0; i < constraints.length; i++) {
constraints[i].compile(session, null);
}
}
public String getSQL() {
StringBuilder sb = new StringBuilder();
if (schemaObjectType == SchemaObject.TYPE) {
sb.append(Tokens.T_CREATE).append(' ').append(
Tokens.T_TYPE).append(' ');
sb.append(name.getSchemaQualifiedStatementName());
sb.append(' ').append(Tokens.T_AS).append(' ');
sb.append(dataType.getDefinition());
if (dataType.isCharacterType()) {
Collation collation = dataType.getCollation();
if (collation.isObjectCollation()) {
sb.append(' ').append(collation.getCollateSQL());
}
}
} else {
sb.append(Tokens.T_CREATE).append(' ').append(
Tokens.T_DOMAIN).append(' ');
sb.append(name.getSchemaQualifiedStatementName());
sb.append(' ').append(Tokens.T_AS).append(' ');
sb.append(dataType.getDefinition());
if (dataType.isCharacterType()) {
Collation collation = dataType.getCollation();
if (collation.isObjectCollation()) {
sb.append(' ').append(collation.getCollateSQL());
}
}
if (defaultExpression != null) {
sb.append(' ').append(Tokens.T_DEFAULT).append(' ');
sb.append(defaultExpression.getSQL());
}
for (int i = 0; i < constraints.length; i++) {
sb.append(' ').append(Tokens.T_CONSTRAINT).append(' ');
sb.append(constraints[i].getName().statementName).append(' ');
sb.append(Tokens.T_CHECK).append('(').append(
constraints[i].getCheckSQL()).append(')');
}
}
return sb.toString();
}
}