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

Example 6 with Oracle

use of org.sonar.db.dialect.Oracle 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 7 with Oracle

use of org.sonar.db.dialect.Oracle 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 8 with Oracle

use of org.sonar.db.dialect.Oracle 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)");
}

Example 9 with Oracle

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

the class VarcharColumnDefTest method generateSqlType_does_not_set_unit_on_oracle_if_legacy_mode.

@Test
public void generateSqlType_does_not_set_unit_on_oracle_if_legacy_mode() throws Exception {
    VarcharColumnDef def = new VarcharColumnDef.Builder().setColumnName("issues").setLimit(10).setIsNullable(true).setIgnoreOracleUnit(true).build();
    assertThat(def.generateSqlType(new Oracle())).isEqualTo("VARCHAR (10)");
}

Example 10 with Oracle

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

the class DatabaseCharsetCheckerTest method throws_ISE_if_handler_fails.

@Test
public void throws_ISE_if_handler_fails() throws Exception {
    Oracle dialect = new Oracle();
    when(underTest.getHandler(dialect)).thenReturn(handler);
    when(db.getDialect()).thenReturn(dialect);
    doThrow(new SQLException("failure")).when(handler).handle(any(Connection.class), any(DatabaseCharsetChecker.State.class));
    expectedException.expect(IllegalStateException.class);
    expectedException.expectMessage("failure");
    underTest.check(DatabaseCharsetChecker.State.UPGRADE);
}