Examples with VarcharColumnDef org.sonar.server.platform.db.migration.def.VarcharColumnDef used on opensource projects

Example 6 with VarcharColumnDef

use of org.sonar.server.platform.db.migration.def.VarcharColumnDef in project sonarqube by SonarSource.

the class CreateInitialSchema method createUsers.

private void createUsers(Context context) throws SQLException {
    VarcharColumnDef loginCol = newLenientVarcharBuilder("login").setLimit(255).build();
    BigIntegerColumnDef updatedAtCol = newBigIntegerColumnDefBuilder().setColumnName("updated_at").build();
    context.execute(newTableBuilder("users").addPkColumn(newIntegerColumnDefBuilder().setColumnName("id").setIsNullable(false).build(), AUTO_INCREMENT).addColumn(loginCol).addColumn(newLenientVarcharBuilder("name").setLimit(200).build()).addColumn(newLenientVarcharBuilder("email").setLimit(100).build()).addColumn(newLenientVarcharBuilder("crypted_password").setLimit(40).build()).addColumn(newLenientVarcharBuilder("salt").setLimit(40).build()).addColumn(newLenientVarcharBuilder("remember_token").setLimit(500).build()).addColumn(newTimestampColumnDefBuilder().setColumnName("remember_token_expires_at").build()).addColumn(newBooleanColumnDefBuilder().setColumnName("active").setDefaultValue(true).build()).addColumn(newBigIntegerColumnDefBuilder().setColumnName("created_at").build()).addColumn(updatedAtCol).addColumn(newLenientVarcharBuilder("scm_accounts").setLimit(4000).build()).addColumn(newLenientVarcharBuilder("external_identity").setLimit(255).build()).addColumn(newLenientVarcharBuilder("external_identity_provider").setLimit(100).build()).addColumn(newBooleanColumnDefBuilder().setColumnName("user_local").build()).build());
    addIndex(context, "users", "users_login", true, loginCol);
    addIndex(context, "users", "users_updated_at", false, updatedAtCol);
}

Example 7 with VarcharColumnDef

use of org.sonar.server.platform.db.migration.def.VarcharColumnDef in project sonarqube by SonarSource.

the class CreateInitialSchema method createIssues.

private void createIssues(Context context) throws SQLException {
    VarcharColumnDef assigneeCol = newLenientVarcharBuilder("assignee").setLimit(255).build();
    VarcharColumnDef componentUuidCol = newLenientVarcharBuilder("component_uuid").setLimit(50).build();
    BigIntegerColumnDef issueCreationDateCol = newBigIntegerColumnDefBuilder().setColumnName("issue_creation_date").build();
    VarcharColumnDef keeCol = newLenientVarcharBuilder("kee").setLimit(50).setIsNullable(false).build();
    VarcharColumnDef projectUuidCol = newLenientVarcharBuilder("project_uuid").setLimit(50).build();
    VarcharColumnDef resolutionCol = newLenientVarcharBuilder("resolution").setLimit(20).build();
    IntegerColumnDef ruleIdCol = newIntegerColumnDefBuilder().setColumnName("rule_id").build();
    BigIntegerColumnDef updatedAtCol = newBigIntegerColumnDefBuilder().setColumnName("updated_at").build();
    context.execute(newTableBuilder("issues").addPkColumn(newBigIntegerColumnDefBuilder().setColumnName("id").setIsNullable(false).build(), AUTO_INCREMENT).addColumn(keeCol).addColumn(ruleIdCol).addColumn(newLenientVarcharBuilder("severity").setLimit(10).build()).addColumn(newBooleanColumnDefBuilder().setColumnName("manual_severity").setIsNullable(false).build()).addColumn(newLenientVarcharBuilder("message").setIgnoreOracleUnit(false).setLimit(4000).build()).addColumn(newIntegerColumnDefBuilder().setColumnName("line").build()).addColumn(newDecimalColumnDefBuilder().setColumnName("gap").setPrecision(30).setScale(20).build()).addColumn(newLenientVarcharBuilder("status").setLimit(20).build()).addColumn(resolutionCol).addColumn(newLenientVarcharBuilder("checksum").setLimit(1000).build()).addColumn(newLenientVarcharBuilder("reporter").setLimit(255).build()).addColumn(assigneeCol).addColumn(newLenientVarcharBuilder("author_login").setLimit(255).build()).addColumn(newLenientVarcharBuilder("action_plan_key").setLimit(50).build()).addColumn(newLenientVarcharBuilder("issue_attributes").setLimit(4000).build()).addColumn(newIntegerColumnDefBuilder().setColumnName("effort").build()).addColumn(newBigIntegerColumnDefBuilder().setColumnName("created_at").build()).addColumn(updatedAtCol).addColumn(issueCreationDateCol).addColumn(newBigIntegerColumnDefBuilder().setColumnName("issue_update_date").build()).addColumn(newBigIntegerColumnDefBuilder().setColumnName("issue_close_date").build()).addColumn(newLenientVarcharBuilder("tags").setLimit(4000).build()).addColumn(componentUuidCol).addColumn(projectUuidCol).addColumn(newBlobColumnDefBuilder().setColumnName("locations").build()).addColumn(new TinyIntColumnDef.Builder().setColumnName("issue_type").build()).build());
    addIndex(context, "issues", "issues_assignee", false, assigneeCol);
    addIndex(context, "issues", "issues_component_uuid", false, componentUuidCol);
    addIndex(context, "issues", "issues_creation_date", false, issueCreationDateCol);
    addIndex(context, "issues", "issues_kee", true, keeCol);
    addIndex(context, "issues", "issues_project_uuid", false, projectUuidCol);
    addIndex(context, "issues", "issues_resolution", false, resolutionCol);
    addIndex(context, "issues", "issues_rule_id", false, ruleIdCol);
    addIndex(context, "issues", "issues_updated_at", false, updatedAtCol);
}

Example 8 with VarcharColumnDef

use of org.sonar.server.platform.db.migration.def.VarcharColumnDef in project sonarqube by SonarSource.

the class CreateInitialSchema method createResourceIndex.

private void createResourceIndex(Context context) throws SQLException {
    VarcharColumnDef keeCol = newLenientVarcharBuilder("kee").setLimit(400).setIsNullable(false).build();
    IntegerColumnDef resourceIdCol = newIntegerColumnDefBuilder().setColumnName("resource_id").setIsNullable(false).build();
    context.execute(newTableBuilder("resource_index").addPkColumn(newIntegerColumnDefBuilder().setColumnName("id").setIsNullable(false).build(), AUTO_INCREMENT).addColumn(keeCol).addColumn(newIntegerColumnDefBuilder().setColumnName("position").setIsNullable(false).build()).addColumn(newIntegerColumnDefBuilder().setColumnName("name_size").setIsNullable(false).build()).addColumn(resourceIdCol).addColumn(newIntegerColumnDefBuilder().setColumnName("root_project_id").setIsNullable(false).build()).addColumn(newLenientVarcharBuilder("qualifier").setLimit(10).setIsNullable(false).build()).build());
    addIndex(context, "resource_index", "resource_index_key", false, keeCol);
    addIndex(context, "resource_index", "resource_index_rid", false, resourceIdCol);
}

Example 9 with VarcharColumnDef

use of org.sonar.server.platform.db.migration.def.VarcharColumnDef in project sonarqube by SonarSource.

the class CreateInitialSchema method createIssueFilterFavourites.

private void createIssueFilterFavourites(Context context) throws SQLException {
    VarcharColumnDef loginCol = newLenientVarcharBuilder("user_login").setLimit(255).setIsNullable(false).build();
    context.execute(newTableBuilder("issue_filter_favourites").addPkColumn(newIntegerColumnDefBuilder().setColumnName("id").setIsNullable(false).build(), AUTO_INCREMENT).addColumn(loginCol).addColumn(newIntegerColumnDefBuilder().setColumnName("issue_filter_id").setIsNullable(false).build()).addColumn(newTimestampColumnDefBuilder().setColumnName("created_at").build()).build());
    addIndex(context, "issue_filter_favourites", "issue_filter_favs_user", false, loginCol);
}

Example 10 with VarcharColumnDef

use of org.sonar.server.platform.db.migration.def.VarcharColumnDef in project sonarqube by SonarSource.

the class CreateInitialSchema method createIssueChanges.

private void createIssueChanges(Context context) throws SQLException {
    VarcharColumnDef issueKeyCol = newLenientVarcharBuilder("issue_key").setLimit(50).setIsNullable(false).build();
    VarcharColumnDef keeCol = newLenientVarcharBuilder("kee").setLimit(50).build();
    context.execute(newTableBuilder("issue_changes").addPkColumn(newBigIntegerColumnDefBuilder().setColumnName("id").setIsNullable(false).build(), AUTO_INCREMENT).addColumn(keeCol).addColumn(issueKeyCol).addColumn(newLenientVarcharBuilder("user_login").setLimit(255).build()).addColumn(newLenientVarcharBuilder("change_type").setLimit(20).build()).addColumn(newClobColumnDefBuilder().setColumnName("change_data").build()).addColumn(newBigIntegerColumnDefBuilder().setColumnName("created_at").build()).addColumn(newBigIntegerColumnDefBuilder().setColumnName("updated_at").build()).addColumn(newBigIntegerColumnDefBuilder().setColumnName("issue_change_creation_date").build()).build());
    addIndex(context, "issue_changes", "issue_changes_issue_key", false, issueKeyCol);
    addIndex(context, "issue_changes", "issue_changes_kee", false, keeCol);
}