@Override public String getExportIdentifier() { StringBuilder sb = new StringBuilder( getTable().getLoggableValueQualifier() ); sb.append( ".UK" ); for ( Column column : getColumns() ) { sb.append( '_' ).append( column.getColumnName().getName() ); } return sb.toString(); }
@Override public String getExportIdentifier() { StringBuilder sb = new StringBuilder( getTable().getLoggableValueQualifier() ); sb.append( ".UK" ); for ( Column column : getColumns() ) { sb.append( '_' ).append( column.getColumnName().getName() ); } return sb.toString(); }
@Override public boolean isCreationVetoed(Dialect dialect) { if ( dialect.supportsNotNullUnique() ) { return false; } for ( Column column : getColumns() ) { if ( column.isNullable() ) { return true; } } return false; }
@Override public boolean isCreationVetoed(Dialect dialect) { if ( dialect.supportsNotNullUnique() ) { return false; } for ( Column column : getColumns() ) { if ( column.isNullable() ) { return true; } } return false; }
public String sqlConstraintStringInCreateTable(Dialect dialect) { StringBuffer buf = new StringBuffer( "unique (" ); boolean hadNullableColumn = false; boolean first = true; for ( Column column : getColumns() ) { if ( first ) { first = false; } else { buf.append( ", " ); } if ( !hadNullableColumn && column.isNullable() ) { hadNullableColumn = true; } buf.append( column.getColumnName().encloseInQuotesIfQuoted( dialect ) ); } //do not add unique constraint on DB not supporting unique and nullable columns return !hadNullableColumn || dialect.supportsNotNullUnique() ? buf.append( ')' ).toString() : null; }
public String sqlConstraintStringInCreateTable(Dialect dialect) { StringBuffer buf = new StringBuffer( "unique (" ); boolean hadNullableColumn = false; boolean first = true; for ( Column column : getColumns() ) { if ( first ) { first = false; } else { buf.append( ", " ); } if ( !hadNullableColumn && column.isNullable() ) { hadNullableColumn = true; } buf.append( column.getColumnName().encloseInQuotesIfQuoted( dialect ) ); } //do not add unique constraint on DB not supporting unique and nullable columns return !hadNullableColumn || dialect.supportsNotNullUnique() ? buf.append( ')' ).toString() : null; }
@Override public String sqlConstraintStringInAlterTable(Dialect dialect) { StringBuffer buf = new StringBuffer( dialect.getAddUniqueConstraintString( getName() ) ).append( '(' ); boolean nullable = false; boolean first = true; for ( Column column : getColumns() ) { if ( first ) { first = false; } else { buf.append( ", " ); } if ( !nullable && column.isNullable() ) { nullable = true; } buf.append( column.getColumnName().encloseInQuotesIfQuoted( dialect ) ); } return !nullable || dialect.supportsNotNullUnique() ? buf.append( ')' ).toString() : null; } }
@Override public String sqlConstraintStringInAlterTable(Dialect dialect) { StringBuffer buf = new StringBuffer( dialect.getAddUniqueConstraintString( getName() ) ).append( '(' ); boolean nullable = false; boolean first = true; for ( Column column : getColumns() ) { if ( first ) { first = false; } else { buf.append( ", " ); } if ( !nullable && column.isNullable() ) { nullable = true; } buf.append( column.getColumnName().encloseInQuotesIfQuoted( dialect ) ); } return !nullable || dialect.supportsNotNullUnique() ? buf.append( ')' ).toString() : null; } }