package liquibase.ext.percona;
import liquibase.change.ChangeMetaData;
import liquibase.change.DatabaseChange;
import liquibase.change.core.DropForeignKeyConstraintChange;
import liquibase.database.Database;
import liquibase.statement.SqlStatement;
/**
* Subclasses the original {@link liquibase.change.core.DropForeignKeyConstraintChange} to
* integrate with pt-online-schema-change.
* @see PTOnlineSchemaChangeStatement
*/
@DatabaseChange(name = PerconaDropForeignKeyConstraintChange.NAME, description = "Drops an existing foreign key",
priority = PerconaDropForeignKeyConstraintChange.PRIORITY, appliesTo = "foreignKey")
public class PerconaDropForeignKeyConstraintChange extends DropForeignKeyConstraintChange implements PerconaChange {
public static final String NAME = "dropForeignKeyConstraint";
public static final int PRIORITY = ChangeMetaData.PRIORITY_DEFAULT + 50;
private Boolean usePercona;
/**
* Generates the statements required for the drop foreign key 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 FOREIGN 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 getBaseTableName();
}
}