/**
* @see net.sourceforge.squirrel_sql.fw.dialects.CommonHibernateDialect#getAddForeignKeyConstraintSQL(java.lang.String,
* java.lang.String, java.lang.String, java.lang.Boolean, java.lang.Boolean, java.lang.Boolean,
* boolean, java.lang.String, java.util.Collection, java.lang.String, java.lang.String,
* net.sourceforge.squirrel_sql.fw.dialects.DatabaseObjectQualifier,
* net.sourceforge.squirrel_sql.fw.dialects.SqlGenerationPreferences)
*/
@Override public String[] getAddForeignKeyConstraintSQL( final String localTableName, final String refTableName, final String constraintName, final Boolean deferrable, final Boolean initiallyDeferred, final Boolean matchFull, final boolean autoFKIndex, final String fkIndexName, final Collection<String[]> localRefColumns, final String onUpdateAction, final String onDeleteAction, final DatabaseObjectQualifier qualifier, final SqlGenerationPreferences prefs) {
final Boolean deferrableNotSupported = null;
final Boolean initiallyDeferredNotSupported = null;
final Boolean matchFullNotSupported = null;
return DialectUtils.getAddForeignKeyConstraintSQL(localTableName, refTableName, constraintName, deferrableNotSupported, initiallyDeferredNotSupported, matchFullNotSupported, autoFKIndex, fkIndexName, localRefColumns, onUpdateAction, onDeleteAction, qualifier, prefs, this );
}
/**
* @see net.sourceforge.squirrel_sql.fw.dialects.CommonHibernateDialect#getAddUniqueConstraintSQL(java.lang.String,
* java.lang.String, net.sourceforge.squirrel_sql.fw.sql.TableColumnInfo[],
* net.sourceforge.squirrel_sql.fw.dialects.DatabaseObjectQualifier,
* net.sourceforge.squirrel_sql.fw.dialects.SqlGenerationPreferences)
*/
@Override public String[] getAddUniqueConstraintSQL( final String tableName, final String constraintName, final TableColumnInfo[] columns, final DatabaseObjectQualifier qualifier, final SqlGenerationPreferences prefs) {
// alter table FKTESTCHILDTABLE add CONSTRAINT foo_const UNIQUE (MYID)
// "ALTER TABLE $tableName$ " +
// "ADD CONSTRAINT $constraintName$ UNIQUE ($columnName; separator=\",\"$)";
final String templateStr = ST_ADD_UNIQUE_CONSTRAINT_STYLE_TWO;
final StringTemplate st = new StringTemplate(templateStr);
final HashMap<String, String> valuesMap = DialectUtils.getValuesMap(ST_TABLE_NAME_KEY, tableName, ST_CONSTRAINT_NAME_KEY, constraintName);
return new String[] {
DialectUtils.getAddUniqueConstraintSQL(st, valuesMap, columns, qualifier, prefs, this )
};
}
/**
* @see net.sourceforge.squirrel_sql.fw.dialects.CommonHibernateDialect#getAlterSequenceSQL(java.lang.String,
* java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String, boolean,
* net.sourceforge.squirrel_sql.fw.dialects.DatabaseObjectQualifier,
* net.sourceforge.squirrel_sql.fw.dialects.SqlGenerationPreferences)
*/
@Override public String[] getAlterSequenceSQL( final String sequenceName, final String increment, final String minimum, final String maximum, final String restart, final String cache, final boolean cycle, final DatabaseObjectQualifier qualifier, final SqlGenerationPreferences prefs) {
return DialectUtils.getSimulatedAlterSequenceSQL(sequenceName, increment, minimum, maximum, minimum, cache, cycle, qualifier, prefs, this );
}
|