liquibase.statement.core

Class AddUniqueConstraintStatement

java.lang.Object

liquibase.statement.AbstractSqlStatement

liquibase.statement.core.AddUniqueConstraintStatement

All Implemented Interfaces:

SqlStatement

public class AddUniqueConstraintStatement
extends AbstractSqlStatement

Constructor Summary

Constructors

Constructor and Description
AddUniqueConstraintStatement(String catalogName, String schemaName, String tableName, ColumnConfig[] columns, String constraintName)

Method Summary

Modifier and Type	Method and Description
String	getCatalogName()
String	getColumnNames()
ColumnConfig[]	getColumns()
String	getConstraintName()
String	getForIndexCatalogName()
String	getForIndexName()
String	getForIndexSchemaName()
String	getSchemaName()
String	getTableName()
String	getTablespace()
boolean	isClustered()
boolean	isDeferrable()
boolean	isDisabled()
boolean	isInitiallyDeferred()
AddUniqueConstraintStatement	setClustered(boolean clustered)
AddUniqueConstraintStatement	setDeferrable(boolean deferrable)
AddUniqueConstraintStatement	setDisabled(boolean disabled)
void	setForIndexCatalogName(String forIndexCatalogName)
void	setForIndexName(String forIndexName)
void	setForIndexSchemaName(String forIndexSchemaName)
AddUniqueConstraintStatement	setInitiallyDeferred(boolean initiallyDeferred)
AddUniqueConstraintStatement	setShouldValidate(boolean shouldValidate)
AddUniqueConstraintStatement	setTablespace(String tablespace)
boolean	shouldValidate() In Oracle PL/SQL, the VALIDATE keyword defines whether a newly added unique constraint on a column in a table should cause existing rows to be checked to see if they satisfy the uniqueness constraint or not.

Methods inherited from class liquibase.statement.AbstractSqlStatement

continueOnError, setContinueOnError, skipOnUnsupported

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

AddUniqueConstraintStatement

public AddUniqueConstraintStatement(String catalogName,
                                    String schemaName,
                                    String tableName,
                                    ColumnConfig[] columns,
                                    String constraintName)

Method Detail

getCatalogName

public String getCatalogName()

getSchemaName

public String getSchemaName()

getTableName

public String getTableName()

getColumns

public ColumnConfig[] getColumns()

getColumnNames

public String getColumnNames()

getConstraintName

public String getConstraintName()

getTablespace

public String getTablespace()

setTablespace

public AddUniqueConstraintStatement setTablespace(String tablespace)

isDeferrable

public boolean isDeferrable()

setDeferrable

public AddUniqueConstraintStatement setDeferrable(boolean deferrable)

isInitiallyDeferred

public boolean isInitiallyDeferred()

setInitiallyDeferred

public AddUniqueConstraintStatement setInitiallyDeferred(boolean initiallyDeferred)

isDisabled

public boolean isDisabled()

setDisabled

public AddUniqueConstraintStatement setDisabled(boolean disabled)

setClustered

public AddUniqueConstraintStatement setClustered(boolean clustered)

isClustered

public boolean isClustered()

getForIndexName

public String getForIndexName()

setForIndexName

public void setForIndexName(String forIndexName)

getForIndexSchemaName

public String getForIndexSchemaName()

setForIndexSchemaName

public void setForIndexSchemaName(String forIndexSchemaName)

getForIndexCatalogName

public String getForIndexCatalogName()

setForIndexCatalogName

public void setForIndexCatalogName(String forIndexCatalogName)

shouldValidate

public boolean shouldValidate()

In Oracle PL/SQL, the VALIDATE keyword defines whether a newly added unique constraint on a column in a table should cause existing rows to be checked to see if they satisfy the uniqueness constraint or not.

Returns:

true if ENABLE VALIDATE (this is the default), or false if ENABLE NOVALIDATE.

setShouldValidate

public AddUniqueConstraintStatement setShouldValidate(boolean shouldValidate)

Parameters:

shouldValidate - - if shouldValidate is set to FALSE then the constraint will be created with the 'ENABLE NOVALIDATE' mode. This means the constraint would be created, but that no check will be done to ensure old data has valid constraints - only new data would be checked to see if it complies with the constraint logic. The default state for unique constraints is to have 'ENABLE VALIDATE' set.