use of org.sonar.db.dialect.MySql in project sonarqube by SonarSource.
the class DatabaseCheckerTest method fail_if_mysql_less_than_5_6.
@Test
public void fail_if_mysql_less_than_5_6() throws Exception {
expectedException.expect(MessageException.class);
expectedException.expectMessage("Unsupported mysql version: 5.5. Minimal supported version is 5.6.");
Database db = mockDb(new MySql(), 5, 5, "5.6");
new DatabaseChecker(db).start();
}
use of org.sonar.db.dialect.MySql 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.MySql 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)");
}
use of org.sonar.db.dialect.MySql 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)");
}
use of org.sonar.db.dialect.MySql 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)");
}
Aggregations