public String getAddForeignKeyConstraintString( String constraintName, String foreignKeyDefinition) { return new StringBuilder( 30 ) .append( " add constraint " ) .append( quote( constraintName ) ) .append( " " ) .append( foreignKeyDefinition ) .toString(); }
.append( quote( constraintName ) ) .append( " foreign key (" ) .append( String.join( ", ", foreignKey ) )
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 protected AST quotedIdentifier(AST ident) { /* * Semantic action used during recognition of quoted identifiers (quoted column names) */ final String columnName = context.getDialect().quote( '`' + ident.getText() + '`' ); columnReferences.add( columnName ); final String marker = '{' + columnName + '}'; return getASTFactory().create( OrderByTemplateTokenTypes.IDENT, marker ); }
public String toDatabaseIdentifierText(String identifierText) { return database().getDialect().quote( normalizeIdentifierQuotingAsString( identifierText ) ); }
@Override protected AST quotedString(AST ident) { /* * Semantic action used during recognition of quoted strings (string literals) */ return getASTFactory().create( OrderByTemplateTokenTypes.IDENT, context.getDialect().quote( ident.getText() ) ); }
public String sqlDropString(Dialect dialect, String defaultCatalog, String defaultSchema) { if ( isGenerated( dialect ) ) { final String tableName = getTable().getQualifiedName( dialect, defaultCatalog, defaultSchema ); return String.format( Locale.ROOT, "%s evictData constraint %s", dialect.getAlterTableString( tableName ), dialect.quote( getName() ) ); } else { return null; } }
@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(); }
result.append(placeholder) .append('.') .append( dialect.quote(token) );
@Override public String getAlterTableToAddUniqueKeyCommand(UniqueKey uniqueKey, Metadata metadata) { final JdbcEnvironment jdbcEnvironment = metadata.getDatabase().getJdbcEnvironment(); final String tableName = jdbcEnvironment.getQualifiedObjectNameFormatter().format( uniqueKey.getTable().getQualifiedTableName(), dialect ); final String constraintName = dialect.quote( uniqueKey.getName() ); return dialect.getAlterTableString( tableName ) + " add constraint " + constraintName + " " + uniqueConstraintSql( uniqueKey ); }
@Override public String getAlterTableToAddUniqueKeyCommand(UniqueKey uniqueKey, Metadata metadata) { // Do this here, rather than allowing UniqueKey/Constraint to do it. // We need full, simplified control over whether or not it happens. final String tableName = metadata.getDatabase().getJdbcEnvironment().getQualifiedObjectNameFormatter().format( uniqueKey.getTable().getQualifiedTableName(), metadata.getDatabase().getJdbcEnvironment().getDialect() ); final String constraintName = dialect.quote( uniqueKey.getName() ); return dialect.getAlterTableString( tableName ) + " add constraint " + uniqueConstraintSql( uniqueKey ) + " constraint " + constraintName; }
public String getAddForeignKeyConstraintString( String constraintName, String foreignKeyDefinition) { return new StringBuilder( 30 ) .append( " add constraint " ) .append( quote( constraintName ) ) .append( " " ) .append( foreignKeyDefinition ) .toString(); }
public String sqlDropString(Dialect dialect, String defaultCatalog, String defaultSchema) { if ( isGenerated( dialect ) ) { return new StringBuffer() .append( "alter table " ) .append( getTable().getQualifiedName( dialect, defaultCatalog, defaultSchema ) ) .append( " drop constraint " ) .append( dialect.quote( getName() ) ) .toString(); } else { return null; } }
public String sqlDropString(Dialect dialect, String defaultCatalog, String defaultSchema) { if ( isGenerated( dialect ) ) { return new StringBuffer() .append( "alter table " ) .append( getTable().getQualifiedName( dialect, defaultCatalog, defaultSchema ) ) .append( " drop constraint " ) .append( dialect.quote( getName() ) ) .toString(); } else { return null; } }
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(); }
/** * {@inheritDoc} */ @Override protected AST quotedString(AST ident) { return getASTFactory().create( OrderByTemplateTokenTypes.IDENT, context.getDialect().quote( ident.getText() ) ); }
/** * {@inheritDoc} */ @Override protected AST quotedIdentifier(AST ident) { return getASTFactory().create( OrderByTemplateTokenTypes.IDENT, Template.TEMPLATE + "." + context.getDialect().quote( '`' + ident.getText() + '`' ) ); }
/** * {@inheritDoc} */ @Override protected AST quotedIdentifier(AST ident) { return getASTFactory().create( OrderByTemplateTokenTypes.IDENT, Template.TEMPLATE + "." + context.getDialect().quote( '`' + ident.getText() + '`' ) ); }
/** * {@inheritDoc} */ @Override protected AST quotedString(AST ident) { return getASTFactory().create( OrderByTemplateTokenTypes.IDENT, context.getDialect().quote( ident.getText() ) ); }