public static String buildSqlCreateIndexString( Dialect dialect, String name, String tableName, Iterator<Column> columns, java.util.Map<Column, String> columnOrderMap, boolean unique) { StringBuilder buf = new StringBuilder( "create" ) .append( unique ? " unique" : "" ) .append( " index " ) .append( dialect.qualifyIndexName() ? name : StringHelper.unqualify( name ) ) .append( " on " ) .append( tableName ) .append( " (" ); while ( columns.hasNext() ) { Column column = columns.next(); buf.append( column.getQuotedName( dialect ) ); if ( columnOrderMap.containsKey( column ) ) { buf.append( " " ).append( columnOrderMap.get( column ) ); } if ( columns.hasNext() ) { buf.append( ", " ); } } buf.append( ")" ); return buf.toString(); }
if ( dialect.qualifyIndexName() ) { indexNameForCreation = jdbcEnvironment.getQualifiedObjectNameFormatter().format( new QualifiedNameImpl(
if ( getDialect().qualifyIndexName() ) { indexNameForCreation = jdbcEnvironment.getQualifiedObjectNameFormatter().format( new QualifiedNameImpl(
@Override public String[] getSqlDropStrings(Index index, Metadata metadata) { if ( !dialect.dropConstraints() ) { return NO_COMMANDS; } final JdbcEnvironment jdbcEnvironment = metadata.getDatabase().getJdbcEnvironment(); final String tableName = jdbcEnvironment.getQualifiedObjectNameFormatter().format( index.getTable().getQualifiedTableName(), dialect ); final String indexNameForCreation; if ( dialect.qualifyIndexName() ) { indexNameForCreation = StringHelper.qualify( tableName, index.getName() ); } else { indexNameForCreation = index.getName(); } return new String[] { "drop index " + indexNameForCreation }; } }
@Override public boolean qualifyIndexName() { return delegate.qualifyIndexName(); }
@Override public boolean qualifyIndexName() { return delegate.qualifyIndexName(); }
@Override public boolean qualifyIndexName() { return delegate.qualifyIndexName(); }
@Override public boolean qualifyIndexName() { return delegate.qualifyIndexName(); }
@Override public boolean qualifyIndexName() { return delegate.qualifyIndexName(); }
@Override public boolean qualifyIndexName() { return delegate.qualifyIndexName(); }
@Override public boolean qualifyIndexName() { return delegate.qualifyIndexName(); }
@Override public boolean qualifyIndexName() { return delegate.qualifyIndexName(); }
@Override public boolean qualifyIndexName() { return delegate.qualifyIndexName(); }
@Override public boolean qualifyIndexName() { return delegate.qualifyIndexName(); }
@Override public boolean qualifyIndexName() { return delegate.qualifyIndexName(); }
public static String buildSqlCreateIndexString(Dialect dialect, String name, Table table, Iterator columns, boolean unique, String defaultCatalog, String defaultSchema) { StringBuffer buf = new StringBuffer("create") .append( unique ? " unique " : "") .append(" index ") .append( dialect.qualifyIndexName() ? name : StringHelper.unqualify(name) ) .append(" on ") .append( table.getQualifiedName(dialect, defaultCatalog, defaultSchema) ) .append(" ("); Iterator iter = columns; while ( iter.hasNext() ) { buf.append( ( (Column) iter.next() ).getQuotedName(dialect) ); if ( iter.hasNext() ) buf.append(", "); } buf.append(")"); return buf.toString(); }
public static String buildSqlCreateIndexString( Dialect dialect, String name, Table table, Iterator columns, boolean unique, String defaultCatalog, String defaultSchema ) { //TODO handle supportsNotNullUnique=false, but such a case does not exist in the wild so far StringBuffer buf = new StringBuffer( "create" ) .append( unique ? " unique" : "" ) .append( " index " ) .append( dialect.qualifyIndexName() ? name : StringHelper.unqualify( name ) ) .append( " on " ) .append( table.getQualifiedName( dialect, defaultCatalog, defaultSchema ) ) .append( " (" ); Iterator iter = columns; while ( iter.hasNext() ) { buf.append( ( (Column) iter.next() ).getQuotedName( dialect ) ); if ( iter.hasNext() ) buf.append( ", " ); } buf.append( ")" ); return buf.toString(); }
public static String buildSqlCreateIndexString( Dialect dialect, String name, Table table, Iterator columns, boolean unique, String defaultCatalog, String defaultSchema ) { //TODO handle supportsNotNullUnique=false, but such a case does not exist in the wild so far StringBuffer buf = new StringBuffer( "create" ) .append( unique ? " unique" : "" ) .append( " index " ) .append( dialect.qualifyIndexName() ? name : StringHelper.unqualify( name ) ) .append( " on " ) .append( table.getQualifiedName( dialect, defaultCatalog, defaultSchema ) ) .append( " (" ); Iterator iter = columns; while ( iter.hasNext() ) { buf.append( ( (Column) iter.next() ).getQuotedName( dialect ) ); if ( iter.hasNext() ) buf.append( ", " ); } buf.append( ")" ); return buf.toString(); }
public static String buildSqlCreateIndexString( Dialect dialect, String name, Table table, Iterator columns, boolean unique, String defaultCatalog, String defaultSchema ) { //TODO handle supportsNotNullUnique=false, but such a case does not exist in the wild so far StringBuffer buf = new StringBuffer( "create" ) .append( unique ? " unique" : "" ) .append( " index " ) .append( dialect.qualifyIndexName() ? name : StringHelper.unqualify( name ) ) .append( " on " ) .append( table.getQualifiedName( dialect, defaultCatalog, defaultSchema ) ) .append( " (" ); Iterator iter = columns; while ( iter.hasNext() ) { buf.append( ( (Column) iter.next() ).getQuotedName( dialect ) ); if ( iter.hasNext() ) buf.append( ", " ); } buf.append( ")" ); return buf.toString(); }
@Override public String[] getSqlDropStrings(Index index, JdbcServices jdbcServices) { if ( !dialect.dropConstraints() ) { return NO_COMMANDS; } final JdbcEnvironment jdbcEnvironment = jdbcServices.getJdbcEnvironment(); final String tableName = jdbcEnvironment.getQualifiedObjectNameFormatter().format( index.getTable().getQualifiedTableName(), dialect ); final String indexNameForCreation; if ( dialect.qualifyIndexName() ) { indexNameForCreation = StringHelper.qualify( tableName, index.getName().render( dialect ) ); } else { indexNameForCreation = index.getName().render( dialect ); } return new String[] { "drop index " + indexNameForCreation }; } }