Java Code Examples for org.hibernate.dialect.Dialect#supportsNotNullUnique()

The following examples show how to use org.hibernate.dialect.Dialect#supportsNotNullUnique() . These examples are extracted from open source projects. You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
public String sqlConstraintString(Dialect dialect, String constraintName, String defaultCatalog,
								  String defaultSchema) {
	StringBuffer buf = new StringBuffer(
			dialect.getAddPrimaryKeyConstraintString( constraintName )
	).append( '(' );
	Iterator iter = getColumnIterator();
	boolean nullable = false;
	while ( iter.hasNext() ) {
		Column column = (Column) iter.next();
		if ( !nullable && column.isNullable() ) nullable = true;
		buf.append( column.getQuotedName( dialect ) );
		if ( iter.hasNext() ) buf.append( ", " );
	}
	return !nullable || dialect.supportsNotNullUnique() ?
			StringHelper.replace( buf.append( ')' ).toString(), "primary key", "unique" ) :
			//TODO: improve this hack!
			null;
}
 
Example 2
public String sqlConstraintString(Dialect dialect) {
	StringBuffer buf = new StringBuffer( "unique (" );
	Iterator iter = getColumnIterator();
	boolean nullable = false;
	while ( iter.hasNext() ) {
		Column column = (Column) iter.next();
		if ( !nullable && column.isNullable() ) nullable = true;
		buf.append( column.getQuotedName( dialect ) );
		if ( iter.hasNext() ) buf.append( ", " );
	}
	//do not add unique constraint on DB not supporting unique and nullable columns
	return !nullable || dialect.supportsNotNullUnique() ?
			buf.append( ')' ).toString() :
			null;
}
 
Example 3
public boolean isGenerated(Dialect dialect) {
	if ( dialect.supportsNotNullUnique() ) return true;
	Iterator iter = getColumnIterator();
	while ( iter.hasNext() ) {
		if ( ( (Column) iter.next() ).isNullable() ) {
			return false;
		}
	}
	return true;
}
 
Example 4
public Iterator sqlAlterStrings(Dialect dialect, Mapping p, TableMetadata tableInfo, String defaultCatalog,
								String defaultSchema)
		throws HibernateException {

	StringBuffer root = new StringBuffer( "alter table " )
			.append( getQualifiedName( dialect, defaultCatalog, defaultSchema ) )
			.append( ' ' )
			.append( dialect.getAddColumnString() );

	Iterator iter = getColumnIterator();
	List results = new ArrayList();
	while ( iter.hasNext() ) {
		Column column = (Column) iter.next();

		ColumnMetadata columnInfo = tableInfo.getColumnMetadata( column.getName() );

		if ( columnInfo == null ) {
			// the column doesnt exist at all.
			StringBuffer alter = new StringBuffer( root.toString() )
					.append( ' ' )
					.append( column.getQuotedName( dialect ) )
					.append( ' ' )
					.append( column.getSqlType( dialect, p ) );

			String defaultValue = column.getDefaultValue();
			if ( defaultValue != null ) {
				alter.append( " default " ).append( defaultValue );
			}

			if ( column.isNullable() ) {
				alter.append( dialect.getNullColumnString() );
			}
			else {
				alter.append( " not null" );
			}

			boolean useUniqueConstraint = column.isUnique() &&
					dialect.supportsUnique() &&
					( !column.isNullable() || dialect.supportsNotNullUnique() );
			if ( useUniqueConstraint ) {
				alter.append( " unique" );
			}

			if ( column.hasCheckConstraint() && dialect.supportsColumnCheck() ) {
				alter.append( " check(" )
						.append( column.getCheckConstraint() )
						.append( ")" );
			}

			String columnComment = column.getComment();
			if ( columnComment != null ) {
				alter.append( dialect.getColumnComment( columnComment ) );
			}

			results.add( alter.toString() );
		}

	}

	return results.iterator();
}
 
Example 5
public Iterator sqlAlterStrings(Dialect dialect, Mapping p, TableMetadata tableInfo, String defaultCatalog,
								String defaultSchema)
		throws HibernateException {

	StringBuffer root = new StringBuffer( "alter table " )
			.append( getQualifiedName( dialect, defaultCatalog, defaultSchema ) )
			.append( ' ' )
			.append( dialect.getAddColumnString() );

	Iterator iter = getColumnIterator();
	List results = new ArrayList();
	while ( iter.hasNext() ) {
		Column column = (Column) iter.next();

		ColumnMetadata columnInfo = tableInfo.getColumnMetadata( column.getName() );

		if ( columnInfo == null ) {
			// the column doesnt exist at all.
			StringBuffer alter = new StringBuffer( root.toString() )
					.append( ' ' )
					.append( column.getQuotedName( dialect ) )
					.append( ' ' )
					.append( column.getSqlType( dialect, p ) );

			String defaultValue = column.getDefaultValue();
			if ( defaultValue != null ) {
				alter.append( " default " ).append( defaultValue );
			}

			if ( column.isNullable() ) {
				alter.append( dialect.getNullColumnString() );
			}
			else {
				alter.append( " not null" );
			}

			boolean useUniqueConstraint = column.isUnique() &&
					dialect.supportsUnique() &&
					( !column.isNullable() || dialect.supportsNotNullUnique() );
			if ( useUniqueConstraint ) {
				alter.append( " unique" );
			}

			if ( column.hasCheckConstraint() && dialect.supportsColumnCheck() ) {
				alter.append( " check(" )
						.append( column.getCheckConstraint() )
						.append( ")" );
			}

			String columnComment = column.getComment();
			if ( columnComment != null ) {
				alter.append( dialect.getColumnComment( columnComment ) );
			}

			results.add( alter.toString() );
		}

	}

	return results.iterator();
}
 
Example 6
public Iterator sqlAlterStrings(Dialect dialect, Mapping p, TableMetadata tableInfo, String defaultCatalog,
								String defaultSchema)
		throws HibernateException {

	StringBuffer root = new StringBuffer( "alter table " )
			.append( getQualifiedName( dialect, defaultCatalog, defaultSchema ) )
			.append( ' ' )
			.append( dialect.getAddColumnString() );

	Iterator iter = getColumnIterator();
	List results = new ArrayList();
	while ( iter.hasNext() ) {
		Column column = (Column) iter.next();

		ColumnMetadata columnInfo = tableInfo.getColumnMetadata( column.getName() );

		if ( columnInfo == null ) {
			// the column doesnt exist at all.
			StringBuffer alter = new StringBuffer( root.toString() )
					.append( ' ' )
					.append( column.getQuotedName( dialect ) )
					.append( ' ' )
					.append( column.getSqlType( dialect, p ) );

			String defaultValue = column.getDefaultValue();
			if ( defaultValue != null ) {
				alter.append( " default " ).append( defaultValue );
			}

			if ( column.isNullable() ) {
				alter.append( dialect.getNullColumnString() );
			}
			else {
				alter.append( " not null" );
			}

			boolean useUniqueConstraint = column.isUnique() &&
					dialect.supportsUnique() &&
					( !column.isNullable() || dialect.supportsNotNullUnique() );
			if ( useUniqueConstraint ) {
				alter.append( " unique" );
			}

			if ( column.hasCheckConstraint() && dialect.supportsColumnCheck() ) {
				alter.append( " check(" )
						.append( column.getCheckConstraint() )
						.append( ")" );
			}

			String columnComment = column.getComment();
			if ( columnComment != null ) {
				alter.append( dialect.getColumnComment( columnComment ) );
			}

			results.add( alter.toString() );
		}

	}

	return results.iterator();
}
 
Example 7
public Iterator sqlAlterStrings(Dialect dialect, Mapping p, TableMetadata tableInfo, String defaultCatalog,
								String defaultSchema)
		throws HibernateException {

	StringBuffer root = new StringBuffer( "alter table " )
			.append( getQualifiedName( dialect, defaultCatalog, defaultSchema ) )
			.append( ' ' )
			.append( dialect.getAddColumnString() );

	Iterator iter = getColumnIterator();
	List results = new ArrayList();
	while ( iter.hasNext() ) {
		Column column = (Column) iter.next();

		ColumnMetadata columnInfo = tableInfo.getColumnMetadata( column.getName() );

		if ( columnInfo == null ) {
			// the column doesnt exist at all.
			StringBuffer alter = new StringBuffer( root.toString() )
					.append( ' ' )
					.append( column.getQuotedName( dialect ) )
					.append( ' ' )
					.append( column.getSqlType( dialect, p ) );

			String defaultValue = column.getDefaultValue();
			if ( defaultValue != null ) {
				alter.append( " default " ).append( defaultValue );
			}

			if ( column.isNullable() ) {
				alter.append( dialect.getNullColumnString() );
			}
			else {
				alter.append( " not null" );
			}

			boolean useUniqueConstraint = column.isUnique() &&
					dialect.supportsUnique() &&
					( !column.isNullable() || dialect.supportsNotNullUnique() );
			if ( useUniqueConstraint ) {
				alter.append( " unique" );
			}

			if ( column.hasCheckConstraint() && dialect.supportsColumnCheck() ) {
				alter.append( " check(" )
						.append( column.getCheckConstraint() )
						.append( ")" );
			}

			String columnComment = column.getComment();
			if ( columnComment != null ) {
				alter.append( dialect.getColumnComment( columnComment ) );
			}

			results.add( alter.toString() );
		}

	}

	return results.iterator();
}
 
Example 8
public Iterator sqlAlterStrings(Dialect dialect, Mapping p, TableMetadata tableInfo, String defaultCatalog,
								String defaultSchema)
		throws HibernateException {

	StringBuffer root = new StringBuffer( "alter table " )
			.append( getQualifiedName( dialect, defaultCatalog, defaultSchema ) )
			.append( ' ' )
			.append( dialect.getAddColumnString() );

	Iterator iter = getColumnIterator();
	List results = new ArrayList();
	while ( iter.hasNext() ) {
		Column column = (Column) iter.next();

		ColumnMetadata columnInfo = tableInfo.getColumnMetadata( column.getName() );

		if ( columnInfo == null ) {
			// the column doesnt exist at all.
			StringBuffer alter = new StringBuffer( root.toString() )
					.append( ' ' )
					.append( column.getQuotedName( dialect ) )
					.append( ' ' )
					.append( column.getSqlType( dialect, p ) );

			String defaultValue = column.getDefaultValue();
			if ( defaultValue != null ) {
				alter.append( " default " ).append( defaultValue );
			}

			if ( column.isNullable() ) {
				alter.append( dialect.getNullColumnString() );
			}
			else {
				alter.append( " not null" );
			}

			boolean useUniqueConstraint = column.isUnique() &&
					dialect.supportsUnique() &&
					( !column.isNullable() || dialect.supportsNotNullUnique() );
			if ( useUniqueConstraint ) {
				alter.append( " unique" );
			}

			if ( column.hasCheckConstraint() && dialect.supportsColumnCheck() ) {
				alter.append( " check(" )
						.append( column.getCheckConstraint() )
						.append( ")" );
			}

			String columnComment = column.getComment();
			if ( columnComment != null ) {
				alter.append( dialect.getColumnComment( columnComment ) );
			}

			results.add( alter.toString() );
		}

	}

	return results.iterator();
}
 
Example 9
public Iterator sqlAlterStrings(Dialect dialect, Mapping p, TableMetadata tableInfo, String defaultCatalog,
								String defaultSchema)
		throws HibernateException {

	StringBuffer root = new StringBuffer( "alter table " )
			.append( getQualifiedName( dialect, defaultCatalog, defaultSchema ) )
			.append( ' ' )
			.append( dialect.getAddColumnString() );

	Iterator iter = getColumnIterator();
	List results = new ArrayList();
	while ( iter.hasNext() ) {
		Column column = (Column) iter.next();

		ColumnMetadata columnInfo = tableInfo.getColumnMetadata( column.getName() );

		if ( columnInfo == null ) {
			// the column doesnt exist at all.
			StringBuffer alter = new StringBuffer( root.toString() )
					.append( ' ' )
					.append( column.getQuotedName( dialect ) )
					.append( ' ' )
					.append( column.getSqlType( dialect, p ) );

			String defaultValue = column.getDefaultValue();
			if ( defaultValue != null ) {
				alter.append( " default " ).append( defaultValue );

				if ( column.isNullable() ) {
					alter.append( dialect.getNullColumnString() );
				}
				else {
					alter.append( " not null" );
				}

			}

			boolean useUniqueConstraint = column.isUnique() &&
					dialect.supportsUnique() &&
					( !column.isNullable() || dialect.supportsNotNullUnique() );
			if ( useUniqueConstraint ) {
				alter.append( " unique" );
			}

			if ( column.hasCheckConstraint() && dialect.supportsColumnCheck() ) {
				alter.append( " check(" )
						.append( column.getCheckConstraint() )
						.append( ")" );
			}

			String columnComment = column.getComment();
			if ( columnComment != null ) {
				alter.append( dialect.getColumnComment( columnComment ) );
			}

			results.add( alter.toString() );
		}

	}

	return results.iterator();
}