Search in sources :

Example 6 with AlterColumnsBuilder

use of org.sonar.server.platform.db.migration.sql.AlterColumnsBuilder in project sonarqube by SonarSource.

the class MakeUuidNotNullOnEvents method execute.

@Override
public void execute(Context context) throws SQLException {
    VarcharColumnDef uuidColumn = newVarcharColumnDefBuilder().setColumnName("uuid").setLimit(UUID_SIZE).setIsNullable(false).build();
    context.execute(new AlterColumnsBuilder(getDatabase().getDialect(), TABLE).updateColumn(uuidColumn).build());
    context.execute(new CreateIndexBuilder(getDialect()).setTable(TABLE).setName("events_uuid").setUnique(true).addColumn(uuidColumn).build());
}
Also used : VarcharColumnDef(org.sonar.server.platform.db.migration.def.VarcharColumnDef) AlterColumnsBuilder(org.sonar.server.platform.db.migration.sql.AlterColumnsBuilder) CreateIndexBuilder(org.sonar.server.platform.db.migration.sql.CreateIndexBuilder)

Aggregations

VarcharColumnDef (org.sonar.server.platform.db.migration.def.VarcharColumnDef)6 AlterColumnsBuilder (org.sonar.server.platform.db.migration.sql.AlterColumnsBuilder)6 CreateIndexBuilder (org.sonar.server.platform.db.migration.sql.CreateIndexBuilder)6