private String getSqlDropStrings(String tableName, ForeignKey foreignKey, Dialect dialect) { final StringBuilder buf = new StringBuilder( dialect.getAlterTableString( tableName ) ); buf.append( dialect.getDropForeignKeyString() ); if ( dialect.supportsIfExistsBeforeConstraintName() ) { buf.append( "if exists " ); } buf.append( dialect.quote( foreignKey.getName() ) ); if ( dialect.supportsIfExistsAfterConstraintName() ) { buf.append( " if exists" ); } return buf.toString(); }
public String sqlDropString(Dialect dialect, String defaultCatalog, String defaultSchema) { String tableName = getTable().getQualifiedName( dialect, defaultCatalog, defaultSchema ); final StringBuilder buf = new StringBuilder( dialect.getAlterTableString( tableName ) ); buf.append( dialect.getDropForeignKeyString() ); if ( dialect.supportsIfExistsBeforeConstraintName() ) { buf.append( "if exists " ); } buf.append( dialect.quote( getName() ) ); if ( dialect.supportsIfExistsAfterConstraintName() ) { buf.append( " if exists" ); } return buf.toString(); }
@Override public String getAlterTableToDropUniqueKeyCommand(UniqueKey uniqueKey, Metadata metadata) { final JdbcEnvironment jdbcEnvironment = metadata.getDatabase().getJdbcEnvironment(); final String tableName = jdbcEnvironment.getQualifiedObjectNameFormatter().format( uniqueKey.getTable().getQualifiedTableName(), dialect ); final StringBuilder buf = new StringBuilder( dialect.getAlterTableString(tableName) ); buf.append( getDropUnique() ); if ( dialect.supportsIfExistsBeforeConstraintName() ) { buf.append( "if exists " ); } buf.append( dialect.quote( uniqueKey.getName() ) ); if ( dialect.supportsIfExistsAfterConstraintName() ) { buf.append( " if exists" ); } return buf.toString(); }
private boolean checkDropForeignKeyConstraint(String tableName) throws IOException { boolean matches = false; String regex = getDialect().getAlterTableString( tableName ); regex += getDialect().getDropForeignKeyString(); if ( getDialect().supportsIfExistsBeforeConstraintName() ) { regex += "if exists "; } regex += "fk(.)*"; if ( getDialect().supportsIfExistsAfterConstraintName() ) { regex += " if exists"; } return isMatching( matches, regex.toLowerCase() ); }
@Override public boolean supportsIfExistsBeforeConstraintName() { return delegate.supportsIfExistsBeforeConstraintName(); }
@Override public boolean supportsIfExistsBeforeConstraintName() { return delegate.supportsIfExistsBeforeConstraintName(); }
@Override public boolean supportsIfExistsBeforeConstraintName() { return delegate.supportsIfExistsBeforeConstraintName(); }
@Override public boolean supportsIfExistsBeforeConstraintName() { return delegate.supportsIfExistsBeforeConstraintName(); }
@Override public boolean supportsIfExistsBeforeConstraintName() { return delegate.supportsIfExistsBeforeConstraintName(); }
@Override public boolean supportsIfExistsBeforeConstraintName() { return delegate.supportsIfExistsBeforeConstraintName(); }
@Override public boolean supportsIfExistsBeforeConstraintName() { return delegate.supportsIfExistsBeforeConstraintName(); }
@Override public boolean supportsIfExistsBeforeConstraintName() { return delegate.supportsIfExistsBeforeConstraintName(); }
@Override public boolean supportsIfExistsBeforeConstraintName() { return delegate.supportsIfExistsBeforeConstraintName(); }
@Override public boolean supportsIfExistsBeforeConstraintName() { return delegate.supportsIfExistsBeforeConstraintName(); }
private String getSqlDropStrings(String tableName, ForeignKey foreignKey, Dialect dialect) { final StringBuilder buf = new StringBuilder( dialect.getAlterTableString( tableName ) ); buf.append( dialect.getDropForeignKeyString() ); if ( dialect.supportsIfExistsBeforeConstraintName() ) { buf.append( "if exists " ); } buf.append( dialect.quote( foreignKey.getName() ) ); if ( dialect.supportsIfExistsAfterConstraintName() ) { buf.append( " if exists" ); } return buf.toString(); }
/** * All schema management is managed though exporters * * @deprecated no mas */ @Deprecated public String sqlDropString(Dialect dialect, String defaultCatalog, String defaultSchema) { final StringBuilder buf = new StringBuilder( "alter table " ); buf.append( getTable().getQualifiedName( dialect, defaultCatalog, defaultSchema ) ); buf.append( dialect.getDropForeignKeyString() ); if ( dialect.supportsIfExistsBeforeConstraintName() ) { buf.append( "if exists " ); } buf.append( dialect.quote( getName() ) ); if ( dialect.supportsIfExistsAfterConstraintName() ) { buf.append( " if exists" ); } return buf.toString(); } }
@Override public String getAlterTableToDropUniqueKeyCommand(UniqueKey uniqueKey, JdbcServices jdbcServices) { final String tableName = jdbcServices .getJdbcEnvironment() .getQualifiedObjectNameFormatter() .format( ( ( ExportableTable) uniqueKey.getTable() ).getQualifiedTableName(), dialect ); final StringBuilder buf = new StringBuilder( dialect.getAlterTableString( tableName )); buf.append(getDropUnique() ); if ( dialect.supportsIfExistsBeforeConstraintName() ) { buf.append( "if exists " ); } buf.append( uniqueKey.getName().render( dialect ) ); if ( dialect.supportsIfExistsAfterConstraintName() ) { buf.append( " if exists" ); } return buf.toString(); }