Examples with H2 org.sonar.db.dialect.H2 used on opensource projects

Example 1 with H2

use of org.sonar.db.dialect.H2 in project sonarqube by SonarSource.

the class DatabaseCheckerTest method log_warning_if_h2.

@Test
public void log_warning_if_h2() throws Exception {
    Database db = mockDb(new H2(), 13, 4, "13.4");
    DatabaseChecker checker = new DatabaseChecker(db);
    checker.start();
    checker.stop();
// TODO test log
}

Example 2 with H2

use of org.sonar.db.dialect.H2 in project sonarqube by SonarSource.

the class BooleanColumnDefTest method generate_sql_type.

@Test
public void generate_sql_type() throws Exception {
    BooleanColumnDef def = new BooleanColumnDef.Builder().setColumnName("enabled").setIsNullable(true).build();
    assertThat(def.generateSqlType(new H2())).isEqualTo("BOOLEAN");
    assertThat(def.generateSqlType(new PostgreSql())).isEqualTo("BOOLEAN");
    assertThat(def.generateSqlType(new MsSql())).isEqualTo("BIT");
    assertThat(def.generateSqlType(new MySql())).isEqualTo("TINYINT(1)");
    assertThat(def.generateSqlType(new Oracle())).isEqualTo("NUMBER(1)");
}

Example 3 with H2

use of org.sonar.db.dialect.H2 in project sonarqube by SonarSource.

the class DecimalColumnDefTest method generate_sql_type.

@Test
public void generate_sql_type() throws Exception {
    DecimalColumnDef def = new DecimalColumnDef.Builder().setColumnName("issues").setPrecision(30).setScale(20).setIsNullable(true).build();
    assertThat(def.generateSqlType(new H2())).isEqualTo("DOUBLE");
    assertThat(def.generateSqlType(new PostgreSql())).isEqualTo("NUMERIC (30,20)");
    assertThat(def.generateSqlType(new MsSql())).isEqualTo("DECIMAL (30,20)");
    assertThat(def.generateSqlType(new MySql())).isEqualTo("DECIMAL (30,20)");
    assertThat(def.generateSqlType(new Oracle())).isEqualTo("NUMERIC (30,20)");
}

Example 4 with H2

use of org.sonar.db.dialect.H2 in project sonarqube by SonarSource.

the class AddIndexOnComponentUuidOfMeasuresTest method add_index_to_measures.

@Test
public void add_index_to_measures() throws Exception {
    when(db.getDialect()).thenReturn(new H2());
    AddIndexOnComponentUuidOfMeasures underTest = new AddIndexOnComponentUuidOfMeasures(db);
    underTest.execute(context);
    verify(context).execute(asList("CREATE INDEX measures_component_uuid ON project_measures (component_uuid)"));
    verifyNoMoreInteractions(context);
}

Example 5 with H2

use of org.sonar.db.dialect.H2 in project sonarqube by SonarSource.

the class DropIndexBuilderTest method drop_index_in_table.

@Test
public void drop_index_in_table() {
    verifySql(new H2(), "DROP INDEX IF EXISTS issues_key");
    verifySql(new MsSql(), "DROP INDEX issues_key ON issues");
    verifySql(new MySql(), "DROP INDEX issues_key ON issues");
    verifySql(new Oracle(), "DROP INDEX issues_key");
    verifySql(new PostgreSql(), "DROP INDEX IF EXISTS issues_key");
}