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

Example 6 with CreateIndexBuilder

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

the class CreateTemporaryIndicesFor1211 method execute.

@Override
public void execute(Context context) throws SQLException {
    context.execute(new CreateIndexBuilder(getDialect()).setTable("ce_activity").setName(INDEX_ON_CE_ACTIVITY).addColumn(newIntegerColumnDefBuilder().setColumnName("snapshot_id").build()).build());
    context.execute(new CreateIndexBuilder(getDialect()).setTable("duplications_index").setName(INDEX_ON_DUPLICATIONS_INDEX).addColumn(newIntegerColumnDefBuilder().setColumnName("project_snapshot_id").build()).build());
}

Example 7 with CreateIndexBuilder

use of org.sonar.server.platform.db.migration.sql.CreateIndexBuilder 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 8 with CreateIndexBuilder

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

the class CreateTableWebhookDeliveries method execute.

@Override
public void execute(Context context) throws SQLException {
    VarcharColumnDef componentUuidColumn = newVarcharColumnDefBuilder().setColumnName("component_uuid").setLimit(UUID_SIZE).setIsNullable(false).setIgnoreOracleUnit(true).build();
    VarcharColumnDef ceTaskUuidColumn = newVarcharColumnDefBuilder().setColumnName("ce_task_uuid").setLimit(UUID_SIZE).setIsNullable(false).setIgnoreOracleUnit(true).build();
    context.execute(new CreateTableBuilder(getDialect(), TABLE_NAME).addPkColumn(newVarcharColumnDefBuilder().setColumnName("uuid").setLimit(UUID_SIZE).setIsNullable(false).setIgnoreOracleUnit(true).build()).addColumn(componentUuidColumn).addColumn(ceTaskUuidColumn).addColumn(newVarcharColumnDefBuilder().setColumnName("name").setLimit(100).setIsNullable(false).setIgnoreOracleUnit(true).build()).addColumn(newVarcharColumnDefBuilder().setColumnName("url").setLimit(2000).setIsNullable(false).setIgnoreOracleUnit(true).build()).addColumn(newBooleanColumnDefBuilder().setColumnName("success").setIsNullable(false).build()).addColumn(newIntegerColumnDefBuilder().setColumnName("http_status").setIsNullable(true).build()).addColumn(newIntegerColumnDefBuilder().setColumnName("duration_ms").setIsNullable(true).build()).addColumn(newClobColumnDefBuilder().setColumnName("payload").setIsNullable(false).build()).addColumn(newClobColumnDefBuilder().setColumnName("error_stacktrace").setIsNullable(true).build()).addColumn(newBigIntegerColumnDefBuilder().setColumnName("created_at").setIsNullable(false).build()).build());
    context.execute(new CreateIndexBuilder(getDialect()).setTable(TABLE_NAME).setName("component_uuid").addColumn(componentUuidColumn).build());
    context.execute(new CreateIndexBuilder(getDialect()).setTable(TABLE_NAME).setName("ce_task_uuid").addColumn(ceTaskUuidColumn).build());
}

Example 9 with CreateIndexBuilder

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

the class CreateTableOrganizations method execute.

@Override
public void execute(Context context) throws SQLException {
    VarcharColumnDef keeColumn = newVarcharColumnDefBuilder().setColumnName("kee").setLimit(32).setIsNullable(false).setIgnoreOracleUnit(true).build();
    context.execute(new CreateTableBuilder(getDialect(), TABLE_NAME).addPkColumn(newVarcharColumnDefBuilder().setColumnName("uuid").setLimit(UUID_SIZE).setIsNullable(false).setIgnoreOracleUnit(true).build()).addColumn(keeColumn).addColumn(newVarcharColumnDefBuilder().setColumnName("name").setLimit(64).setIsNullable(false).setIgnoreOracleUnit(true).build()).addColumn(newVarcharColumnDefBuilder().setColumnName("description").setLimit(256).setIsNullable(true).setIgnoreOracleUnit(true).build()).addColumn(newVarcharColumnDefBuilder().setColumnName("url").setLimit(256).setIsNullable(true).setIgnoreOracleUnit(true).build()).addColumn(newVarcharColumnDefBuilder().setColumnName("avatar_url").setLimit(256).setIsNullable(true).setIgnoreOracleUnit(true).build()).addColumn(newBigIntegerColumnDefBuilder().setColumnName("created_at").setIsNullable(false).build()).addColumn(newBigIntegerColumnDefBuilder().setColumnName("updated_at").setIsNullable(false).build()).build());
    context.execute(new CreateIndexBuilder(getDialect()).setTable(TABLE_NAME).setName("organization_key").addColumn(keeColumn).build());
}

Example 10 with CreateIndexBuilder

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

the class RenameTableProperties2ToProperties method execute.

@Override
public void execute(Context context) throws SQLException {
    context.execute(new DropIndexBuilder(getDialect()).setTable("properties2").setName("properties2_key").build());
    context.execute(new RenameTableBuilder(getDialect()).setName("properties2").setNewName("properties").build());
    context.execute(new CreateIndexBuilder(getDialect()).setTable("properties").setName("properties_key").addColumn(newVarcharColumnDefBuilder().setColumnName("prop_key").setLimit(512).setIsNullable(false).setIgnoreOracleUnit(true).build()).build());
}