org.hibernate.dialect.unique.DB2UniqueDelegate Maven / Gradle / Ivy

Show more of this group Show more artifacts with this name
Show all versions of hibernate-core
A module of the Hibernate O/RM project
There is a newer version: 7.0.0.Alpha1
/* 
 * Hibernate, Relational Persistence for Idiomatic Java
 * 
 * JBoss, Home of Professional Open Source
 * Copyright 2012 Red Hat Inc. and/or its affiliates and other contributors
 * as indicated by the @authors tag. All rights reserved.
 * See the copyright.txt in the distribution for a
 * full listing of individual contributors.
 *
 * This copyrighted material is made available to anyone wishing to use,
 * modify, copy, or redistribute it subject to the terms and conditions
 * of the GNU Lesser General Public License, v. 2.1.
 * This program is distributed in the hope that it will be useful, but WITHOUT A
 * WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A
 * PARTICULAR PURPOSE.  See the GNU Lesser General Public License for more details.
 * You should have received a copy of the GNU Lesser General Public License,
 * v.2.1 along with this distribution; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,
 * MA  02110-1301, USA.
 */
package org.hibernate.dialect.unique;

import java.util.Iterator;

import org.hibernate.dialect.Dialect;
import org.hibernate.metamodel.relational.Column;
import org.hibernate.metamodel.relational.Index;
import org.hibernate.metamodel.relational.UniqueKey;

/**
 * DB2 does not allow unique constraints on nullable columns.  Rather than
 * forcing "not null", use unique *indexes* instead.
 * 
 * @author Brett Meyer
 */
public class DB2UniqueDelegate extends DefaultUniqueDelegate {
	
	public DB2UniqueDelegate( Dialect dialect ) {
		super( dialect );
	}
	
	@Override
	public String applyUniquesOnAlter( org.hibernate.mapping.UniqueKey uniqueKey,
			String defaultCatalog, String defaultSchema ) {
		if ( hasNullable( uniqueKey ) ) {
			return org.hibernate.mapping.Index.buildSqlCreateIndexString(
					dialect, uniqueKey.getName(), uniqueKey.getTable(),
					uniqueKey.columnIterator(), true, defaultCatalog,
					defaultSchema );
		} else {
			return super.applyUniquesOnAlter(
					uniqueKey, defaultCatalog, defaultSchema );
		}
	}
	
	@Override
	public String applyUniquesOnAlter( UniqueKey uniqueKey ) {
		if ( hasNullable( uniqueKey ) ) {
			return Index.buildSqlCreateIndexString(
					dialect, uniqueKey.getName(), uniqueKey.getTable(),
					uniqueKey.getColumns(), true );
		} else {
			return super.applyUniquesOnAlter( uniqueKey );
		}
	}
	
	@Override
	public String dropUniquesOnAlter( org.hibernate.mapping.UniqueKey uniqueKey,
			String defaultCatalog, String defaultSchema ) {
		if ( hasNullable( uniqueKey ) ) {
			return org.hibernate.mapping.Index.buildSqlDropIndexString(
					dialect, uniqueKey.getTable(), uniqueKey.getName(),
					defaultCatalog, defaultSchema );
		} else {
			return super.dropUniquesOnAlter(
					uniqueKey, defaultCatalog, defaultSchema );
		}
	}
	
	@Override
	public String dropUniquesOnAlter( UniqueKey uniqueKey ) {
		if ( hasNullable( uniqueKey ) ) {
			return Index.buildSqlDropIndexString(
					dialect, uniqueKey.getTable(), uniqueKey.getName() );
		} else {
			return super.dropUniquesOnAlter( uniqueKey );
		}
	}
	
	private boolean hasNullable( org.hibernate.mapping.UniqueKey uniqueKey ) {
		Iterator iter = uniqueKey.getColumnIterator();
		while ( iter.hasNext() ) {
			if ( ( ( org.hibernate.mapping.Column ) iter.next() ).isNullable() ) {
				return true;
			}
		}
		return false;
	}
	
	private boolean hasNullable( UniqueKey uniqueKey ) {
		Iterator iter = uniqueKey.getColumns().iterator();
		while ( iter.hasNext() ) {
			if ( ( ( Column ) iter.next() ).isNullable() ) {
				return true;
			}
		}
		return false;
	}
}