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

Example 11 with PostgreSql

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

the class DropTreeColumnsFromSnapshotsTest 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 snapshots DROP COLUMN parent_snapshot_id, DROP COLUMN scope, DROP COLUMN qualifier, DROP COLUMN root_snapshot_id, DROP COLUMN path, DROP COLUMN depth, DROP COLUMN root_component_uuid");
}

Example 12 with PostgreSql

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

the class DropUnusedMeasuresColumnsTest method generate_sql_on_postgresql.

@Test
public void generate_sql_on_postgresql() {
    when(database.getDialect()).thenReturn(new PostgreSql());
    assertThat(underTest.generateSql()).isEqualTo("ALTER TABLE project_measures DROP COLUMN rules_category_id, DROP COLUMN tendency, DROP COLUMN measure_date, DROP COLUMN url, DROP COLUMN rule_priority, DROP COLUMN characteristic_id, DROP COLUMN rule_id");
}

Example 13 with PostgreSql

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

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

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