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

Example 6 with H2

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

the class RenameTableBuilderTest method throw_IAE_if_name_is_not_valid.

@Test
public void throw_IAE_if_name_is_not_valid() {
    expectedException.expect(IllegalArgumentException.class);
    expectedException.expectMessage("Table name must be lower case and contain only alphanumeric chars or '_', got '(not valid)'");
    new RenameTableBuilder(new H2()).setName("(not valid)").build();
}

Example 7 with H2

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

the class GlobalActionTest method init.

private void init(org.sonar.api.web.page.Page[] pages, ResourceTypeTree[] resourceTypeTrees) {
    when(dbClient.getDatabase().getDialect()).thenReturn(new H2());
    when(server.getVersion()).thenReturn("6.42");
    PluginRepository pluginRepository = mock(PluginRepository.class);
    when(pluginRepository.hasPlugin(anyString())).thenReturn(true);
    PageRepository pageRepository = new PageRepository(pluginRepository, new PageDefinition[] { context -> {
        for (Page page : pages) {
            context.addPage(page);
        }
    } });
    pageRepository.start();
    ws = new WsActionTester(new GlobalAction(pageRepository, settings, new ResourceTypes(resourceTypeTrees), server, dbClient, organizationFlags));
}

Example 8 with H2

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

the class TimestampColumnDefTest method generate_sql_type.

@Test
public void generate_sql_type() throws Exception {
    TimestampColumnDef def = newTimestampColumnDefBuilder().setColumnName("created_at").build();
    assertThat(def.generateSqlType(new H2())).isEqualTo("TIMESTAMP");
    assertThat(def.generateSqlType(new PostgreSql())).isEqualTo("TIMESTAMP");
    assertThat(def.generateSqlType(new MsSql())).isEqualTo("DATETIME");
    assertThat(def.generateSqlType(new MySql())).isEqualTo("DATETIME");
    assertThat(def.generateSqlType(new Oracle())).isEqualTo("TIMESTAMP (6)");
}

Example 9 with H2

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

the class TinyIntColumnDefTest method generate_sql_type.

@Test
public void generate_sql_type() throws Exception {
    TinyIntColumnDef def = new TinyIntColumnDef.Builder().setColumnName("foo").setIsNullable(true).build();
    assertThat(def.generateSqlType(new H2())).isEqualTo("TINYINT");
    assertThat(def.generateSqlType(new PostgreSql())).isEqualTo("SMALLINT");
    assertThat(def.generateSqlType(new MsSql())).isEqualTo("TINYINT");
    assertThat(def.generateSqlType(new MySql())).isEqualTo("TINYINT(2)");
    assertThat(def.generateSqlType(new Oracle())).isEqualTo("NUMBER(3)");
}

Example 10 with H2

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

the class VarcharColumnDefTest method generate_sql_type.

@Test
public void generate_sql_type() throws Exception {
    VarcharColumnDef def = new VarcharColumnDef.Builder().setColumnName("issues").setLimit(10).setIsNullable(true).build();
    assertThat(def.generateSqlType(new H2())).isEqualTo("VARCHAR (10)");
    assertThat(def.generateSqlType(new PostgreSql())).isEqualTo("VARCHAR (10)");
    assertThat(def.generateSqlType(new MySql())).isEqualTo("VARCHAR (10)");
    assertThat(def.generateSqlType(new MsSql())).isEqualTo("NVARCHAR (10)");
    assertThat(def.generateSqlType(new Oracle())).isEqualTo("VARCHAR (10 CHAR)");
}