package liquibase.ext.percona;
import liquibase.change.ChangeMetaData;
import liquibase.change.DatabaseChange;
import liquibase.change.core.DropUniqueConstraintChange;
import liquibase.database.Database;
import liquibase.statement.SqlStatement;
/**
* Subclasses the original {@link liquibase.change.core.DropUniqueConstraintChange} to
* integrate with pt-online-schema-change.
* @see PTOnlineSchemaChangeStatement
*/
@DatabaseChange(name = PerconaDropUniqueConstraintChange.NAME, description = "Drops an existing unique constraint",
priority = PerconaDropUniqueConstraintChange.PRIORITY, appliesTo = "uniqueConstraint")
public class PerconaDropUniqueConstraintChange extends DropUniqueConstraintChange implements PerconaChange {
public static final String NAME = "dropUniqueConstraint";
public static final int PRIORITY = ChangeMetaData.PRIORITY_DEFAULT + 50;
private Boolean usePercona;
/**
* Generates the statements required for the drop unique constraint change.
* In case of a MySQL database, percona toolkit will be used.
* In case of generating the SQL statements for review (updateSQL) the command
* will be added as a comment.
* @param database the database
* @return the list of statements
* @see PTOnlineSchemaChangeStatement
*/
@Override
public SqlStatement[] generateStatements(Database database) {
return PerconaChangeUtil.generateStatements(this,
database,
super.generateStatements(database));
}
@Override
public String generateAlterStatement(Database database) {
StringBuilder alter = new StringBuilder();
alter.append("DROP KEY ");
alter.append(database.escapeConstraintName(getConstraintName()));
return alter.toString();
}
@Override
public Boolean getUsePercona() {
return usePercona;
}
public void setUsePercona(Boolean usePercona) {
this.usePercona = usePercona;
}
@Override
public String getChangeSkipName() {
return NAME;
}
@Override
public String getTargetTableName() {
return getTableName();
}
}