use of org.sonar.server.platform.db.migration.sql.CreateTableBuilder in project sonarqube by SonarSource.
the class CreateTableProperties2 method execute.
@Override
public void execute(Context context) throws SQLException {
VarcharColumnDef propKey = newVarcharColumnDefBuilder().setColumnName("prop_key").setLimit(512).setIsNullable(false).setIgnoreOracleUnit(true).build();
List<String> stmts = new CreateTableBuilder(getDialect(), TABLE_NAME).addPkColumn(newIntegerColumnDefBuilder().setColumnName("id").setIsNullable(false).build(), AUTO_INCREMENT).addColumn(propKey).addColumn(newBigIntegerColumnDefBuilder().setColumnName("resource_id").setIsNullable(true).build()).addColumn(newBigIntegerColumnDefBuilder().setColumnName("user_id").setIsNullable(true).build()).addColumn(newBooleanColumnDefBuilder().setColumnName("is_empty").setIsNullable(false).build()).addColumn(newVarcharColumnDefBuilder().setColumnName("text_value").setLimit(MAX_SIZE).setIgnoreOracleUnit(true).build()).addColumn(newClobColumnDefBuilder().setColumnName("clob_value").setIsNullable(true).build()).addColumn(newBigIntegerColumnDefBuilder().setColumnName("created_at").setIsNullable(false).build()).withPkConstraintName("pk_properties").build();
context.execute(stmts);
context.execute(new CreateIndexBuilder(getDialect()).setTable(TABLE_NAME).setName("properties2_key").addColumn(propKey).build());
}
use of org.sonar.server.platform.db.migration.sql.CreateTableBuilder in project sonarqube by SonarSource.
the class CreateTableRuleRepositories method execute.
@Override
public void execute(Context context) throws SQLException {
List<String> stmts = new CreateTableBuilder(getDialect(), "rule_repositories").addPkColumn(newVarcharColumnDefBuilder().setColumnName("kee").setLimit(200).setIsNullable(false).setIgnoreOracleUnit(true).build()).addColumn(newVarcharColumnDefBuilder().setColumnName("language").setLimit(20).setIsNullable(false).setIgnoreOracleUnit(true).build()).addColumn(newVarcharColumnDefBuilder().setColumnName("name").setLimit(4000).setIsNullable(false).setIgnoreOracleUnit(true).build()).addColumn(newBigIntegerColumnDefBuilder().setColumnName("created_at").setIsNullable(false).build()).build();
context.execute(stmts);
}
use of org.sonar.server.platform.db.migration.sql.CreateTableBuilder in project sonarqube by SonarSource.
the class CreatePermTemplatesCharacteristics method execute.
@Override
public void execute(Context context) throws SQLException {
IntegerColumnDef templateIdColumn = newIntegerColumnDefBuilder().setColumnName("template_id").setIsNullable(false).build();
VarcharColumnDef permissionKeyColumn = newVarcharColumnDefBuilder().setColumnName("permission_key").setLimit(64).setIsNullable(false).setIgnoreOracleUnit(true).build();
context.execute(new CreateTableBuilder(getDialect(), TABLE_NAME).addPkColumn(newIntegerColumnDefBuilder().setColumnName("id").setIsNullable(false).build(), AUTO_INCREMENT).addColumn(templateIdColumn).addColumn(permissionKeyColumn).addColumn(newBooleanColumnDefBuilder().setColumnName("with_project_creator").setIsNullable(false).setDefaultValue(false).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("uniq_perm_tpl_charac").setUnique(true).addColumn(templateIdColumn).addColumn(permissionKeyColumn).build());
}
use of org.sonar.server.platform.db.migration.sql.CreateTableBuilder 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());
}
use of org.sonar.server.platform.db.migration.sql.CreateTableBuilder 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());
}
Aggregations