Examples with AlterColumnsBuilder org.sonar.server.platform.db.migration.sql.AlterColumnsBuilder used on opensource projects

Example 1 with AlterColumnsBuilder

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

the class MakeUuidColumnsNotNullOnProjects method execute.

@Override
public void execute(Context context) throws SQLException {
    VarcharColumnDef rootUuid = newVarcharColumnDefBuilder().setColumnName("root_uuid").setLimit(UUID_VARCHAR_SIZE).setIsNullable(false).build();
    context.execute(new AlterColumnsBuilder(getDialect(), TABLE_PROJECTS).updateColumn(newVarcharColumnDefBuilder().setColumnName("uuid").setLimit(UUID_VARCHAR_SIZE).setIsNullable(false).setIgnoreOracleUnit(true).build()).updateColumn(rootUuid).build());
    context.execute(new CreateIndexBuilder(getDialect()).setTable(TABLE_PROJECTS).setName("projects_root_uuid").addColumn(rootUuid).build());
}

Example 2 with AlterColumnsBuilder

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

the class MakeUuidColumnsNotNullOnResourceIndex method execute.

@Override
public void execute(Context context) throws SQLException {
    VarcharColumnDef componentUuid = newUuidColumn("component_uuid");
    context.execute(new AlterColumnsBuilder(getDialect(), TABLE_RESOURCE_INDEX).updateColumn(componentUuid).updateColumn(newUuidColumn("root_component_uuid")).build());
    context.execute(new CreateIndexBuilder(getDialect()).setTable(TABLE_RESOURCE_INDEX).setName("resource_index_component").addColumn(componentUuid).build());
}

Example 3 with AlterColumnsBuilder

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

the class MakeAnalysisUuidNotNullOnEvents method execute.

@Override
public void execute(Context context) throws SQLException {
    VarcharColumnDef analysisUuidColumn = newVarcharColumnDefBuilder().setColumnName("analysis_uuid").setLimit(UUID_VARCHAR_SIZE).setIsNullable(false).setIgnoreOracleUnit(true).build();
    context.execute(new AlterColumnsBuilder(getDatabase().getDialect(), TABLE_EVENTS).updateColumn(analysisUuidColumn).build());
    context.execute(new CreateIndexBuilder(getDialect()).setTable(TABLE_EVENTS).setName("events_analysis").addColumn(analysisUuidColumn).build());
}

Example 4 with AlterColumnsBuilder

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

the class MakeComponentUuidColumnsNotNullOnSnapshots method execute.

@Override
public void execute(Context context) throws SQLException {
    VarcharColumnDef componentUuid = newUuidColumn("component_uuid");
    VarcharColumnDef rootComponentUuid = newUuidColumn("root_component_uuid");
    context.execute(new AlterColumnsBuilder(getDatabase().getDialect(), TABLE_SNAPSHOTS).updateColumn(componentUuid).updateColumn(rootComponentUuid).build());
    context.execute(new CreateIndexBuilder(getDialect()).setTable(TABLE_SNAPSHOTS).setName("snapshot_component").addColumn(componentUuid).build());
    context.execute(new CreateIndexBuilder(getDialect()).setTable(TABLE_SNAPSHOTS).setName("snapshot_root_component").addColumn(rootComponentUuid).build());
}

Example 5 with AlterColumnsBuilder

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

the class MakeComponentUuidAndAnalysisUuidNotNullOnDuplicationsIndex method execute.

@Override
public void execute(Context context) throws SQLException {
    VarcharColumnDef analysisUuid = newUuidColumn("analysis_uuid");
    VarcharColumnDef componentUuid = newUuidColumn("component_uuid");
    context.execute(new AlterColumnsBuilder(getDatabase().getDialect(), TABLE_DUPLICATIONS_INDEX).updateColumn(componentUuid).updateColumn(analysisUuid).build());
    context.execute(new CreateIndexBuilder(getDialect()).setTable(TABLE_DUPLICATIONS_INDEX).setName("duplication_analysis_component").addColumn(analysisUuid).addColumn(componentUuid).build());
}