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

Example 1 with PostgreSql

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

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

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

the class DropIsGlobalFromDashboardsTest method verify_generated_sql_on_postgresql.

@Test
public void verify_generated_sql_on_postgresql() throws SQLException {
    when(database.getDialect()).thenReturn(new PostgreSql());
    DdlChange.Context context = mock(DdlChange.Context.class);
    underTest.execute(context);
    verify(context).execute("ALTER TABLE dashboards DROP COLUMN is_global");
}

Example 4 with PostgreSql

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

the class DropIdColumnsFromProjectsTest method verify_generated_sql_on_postgresql.

@Test
public void verify_generated_sql_on_postgresql() throws SQLException {
    when(database.getDialect()).thenReturn(new PostgreSql());
    DdlChange.Context context = mock(DdlChange.Context.class);
    underTest.execute(context);
    verify(context).execute("ALTER TABLE projects DROP COLUMN root_id, DROP COLUMN copy_resource_id, DROP COLUMN person_id");
}

Example 5 with PostgreSql

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

the class DropIdColumnsFromResourceIndexTest method verify_generated_sql_on_postgresql.

@Test
public void verify_generated_sql_on_postgresql() throws SQLException {
    when(database.getDialect()).thenReturn(new PostgreSql());
    DdlChange.Context context = mock(DdlChange.Context.class);
    underTest.execute(context);
    verify(context).execute("ALTER TABLE resource_index DROP COLUMN resource_id, DROP COLUMN root_project_id");
}