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(); } }