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

Example 6 with MsSql

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

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

the class BigIntegerColumnDefTest method generate_sql_type.

@Test
public void generate_sql_type() throws Exception {
    BigIntegerColumnDef def = new BigIntegerColumnDef.Builder().setColumnName("issues").setIsNullable(true).build();
    assertThat(def.generateSqlType(new H2())).isEqualTo("BIGINT");
    assertThat(def.generateSqlType(new PostgreSql())).isEqualTo("BIGINT");
    assertThat(def.generateSqlType(new MsSql())).isEqualTo("BIGINT");
    assertThat(def.generateSqlType(new MySql())).isEqualTo("BIGINT");
    assertThat(def.generateSqlType(new Oracle())).isEqualTo("NUMBER (38)");
}