use of org.sonar.db.dialect.MsSql 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)");
}
use of org.sonar.db.dialect.MsSql 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)");
}
use of org.sonar.db.dialect.MsSql in project sonarqube by SonarSource.
the class DropIndexBuilderTest method drop_index_in_table.
@Test
public void drop_index_in_table() {
verifySql(new H2(), "DROP INDEX IF EXISTS issues_key");
verifySql(new MsSql(), "DROP INDEX issues_key ON issues");
verifySql(new MySql(), "DROP INDEX issues_key ON issues");
verifySql(new Oracle(), "DROP INDEX issues_key");
verifySql(new PostgreSql(), "DROP INDEX IF EXISTS issues_key");
}
use of org.sonar.db.dialect.MsSql 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)");
}
use of org.sonar.db.dialect.MsSql 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)");
}