package liquibase.sqlgenerator.core; import liquibase.database.Database; import liquibase.database.core.DB2Database; import liquibase.exception.ValidationErrors; import liquibase.structure.core.Column; import liquibase.structure.core.Schema; import liquibase.structure.core.Table; import liquibase.sql.Sql; import liquibase.sql.UnparsedSql; import liquibase.sqlgenerator.SqlGeneratorChain; import liquibase.statement.core.AddAutoIncrementStatement; public class AddAutoIncrementGeneratorDB2 extends AddAutoIncrementGenerator { @Override public int getPriority() { return PRIORITY_DATABASE; } @Override public boolean supports(AddAutoIncrementStatement statement, Database database) { return database instanceof DB2Database; } @Override public ValidationErrors validate( AddAutoIncrementStatement statement, Database database, SqlGeneratorChain sqlGeneratorChain) { ValidationErrors validationErrors = new ValidationErrors(); validationErrors.checkRequiredField("columnName", statement.getColumnName()); validationErrors.checkRequiredField("tableName", statement.getTableName()); return validationErrors; } @Override public Sql[] generateSql( AddAutoIncrementStatement statement, Database database, SqlGeneratorChain sqlGeneratorChain) { return new Sql[]{ new UnparsedSql( "ALTER TABLE " + database.escapeTableName(statement.getCatalogName(), statement.getSchemaName(), statement.getTableName()) + " ALTER COLUMN " + database.escapeColumnName( statement.getCatalogName(), statement.getSchemaName(), statement.getTableName(), statement.getColumnName()) + " SET " + database.getAutoIncrementClause( statement.getStartWith(), statement.getIncrementBy()), getAffectedColumn(statement)) }; } }