Search in sources :

Example 41 with VarcharColumnDef

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

the class AddUuidToEvents method execute.

@Override
public void execute(Context context) throws SQLException {
    VarcharColumnDef column = newVarcharColumnDefBuilder().setColumnName("uuid").setIsNullable(true).setLimit(40).build();
    context.execute(new AddColumnsBuilder(getDialect(), "events").addColumn(column).build());
}
Also used : VarcharColumnDef(org.sonar.server.platform.db.migration.def.VarcharColumnDef) AddColumnsBuilder(org.sonar.server.platform.db.migration.sql.AddColumnsBuilder)

Example 42 with VarcharColumnDef

use of org.sonar.server.platform.db.migration.def.VarcharColumnDef 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)

Example 43 with VarcharColumnDef

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

the class AddTagsToProjects method execute.

@Override
public void execute(Context context) throws SQLException {
    VarcharColumnDef column = newVarcharColumnDefBuilder().setColumnName("tags").setIsNullable(true).setLimit(500).build();
    context.execute(new AddColumnsBuilder(getDialect(), "projects").addColumn(column).build());
}
Also used : VarcharColumnDef(org.sonar.server.platform.db.migration.def.VarcharColumnDef) AddColumnsBuilder(org.sonar.server.platform.db.migration.sql.AddColumnsBuilder)

Aggregations

VarcharColumnDef (org.sonar.server.platform.db.migration.def.VarcharColumnDef)43 CreateIndexBuilder (org.sonar.server.platform.db.migration.sql.CreateIndexBuilder)11 BigIntegerColumnDef (org.sonar.server.platform.db.migration.def.BigIntegerColumnDef)10 IntegerColumnDef (org.sonar.server.platform.db.migration.def.IntegerColumnDef)9 AddColumnsBuilder (org.sonar.server.platform.db.migration.sql.AddColumnsBuilder)7 AlterColumnsBuilder (org.sonar.server.platform.db.migration.sql.AlterColumnsBuilder)6 CreateTableBuilder (org.sonar.server.platform.db.migration.sql.CreateTableBuilder)5 BigIntegerColumnDef.newBigIntegerColumnDefBuilder (org.sonar.server.platform.db.migration.def.BigIntegerColumnDef.newBigIntegerColumnDefBuilder)1 BlobColumnDef.newBlobColumnDefBuilder (org.sonar.server.platform.db.migration.def.BlobColumnDef.newBlobColumnDefBuilder)1 BooleanColumnDef (org.sonar.server.platform.db.migration.def.BooleanColumnDef)1 BooleanColumnDef.newBooleanColumnDefBuilder (org.sonar.server.platform.db.migration.def.BooleanColumnDef.newBooleanColumnDefBuilder)1 ClobColumnDef.newClobColumnDefBuilder (org.sonar.server.platform.db.migration.def.ClobColumnDef.newClobColumnDefBuilder)1 DecimalColumnDef.newDecimalColumnDefBuilder (org.sonar.server.platform.db.migration.def.DecimalColumnDef.newDecimalColumnDefBuilder)1 IntegerColumnDef.newIntegerColumnDefBuilder (org.sonar.server.platform.db.migration.def.IntegerColumnDef.newIntegerColumnDefBuilder)1 TimestampColumnDef.newTimestampColumnDefBuilder (org.sonar.server.platform.db.migration.def.TimestampColumnDef.newTimestampColumnDefBuilder)1 TinyIntColumnDef (org.sonar.server.platform.db.migration.def.TinyIntColumnDef)1