org.hibernate.dialect.MySQL57Dialect Java Examples

The following examples show how to use org.hibernate.dialect.MySQL57Dialect. You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.

Example #1

Source File: DatabaseSchemaUpdateTest.java From jpa2ddl with Apache License 2.0

6 votes

@Test
public void shouldGenerateSchemaUpdate() throws Exception {
	// given
	File outputPath = tempFolder.newFolder();

	Files.copy(Paths.get(getClass().getClassLoader().getResource("sample_migration/v1__jpa2ddl_init.sql").toURI()),
			outputPath.toPath().resolve("v1__jpa2ddl_init.sql"));

	Properties jpaProperties = new Properties();
	jpaProperties.setProperty("hibernate.dialect", MySQL57Dialect.class.getCanonicalName());
	jpaProperties.setProperty("hibernate.default_schema", "prod");

	SchemaGenerator schemaGenerator = new SchemaGenerator();

	// when
	schemaGenerator.generate(new GeneratorSettings(GenerationMode.DATABASE, outputPath,
			Arrays.asList("com.devskiller.jpa2ddl.sample"), Action.UPDATE, jpaProperties, true, ";", false));

	// then
	String sql = new String(Files.readAllBytes(outputPath.toPath().resolve("v2__jpa2ddl.sql")));
	assertThat(sql).containsIgnoringCase("alter table prod.User");
	assertThat(sql).containsIgnoringCase("add column email varchar(255);");
	assertThat(sql).containsIgnoringCase("create table prod.hibernate_sequence");
	assertThat(sql).containsIgnoringCase("insert into prod.hibernate_sequence values");
	assertThat(sql).doesNotContain("create table prod.User");
}

Example #2

Source File: DatabaseSchemaUpdateTest.java From jpa2ddl with Apache License 2.0

6 votes

@Test
public void shouldGenerateDefaultSchemaUpdate() throws Exception {
	// given
	File outputPath = tempFolder.newFolder();

	Files.copy(Paths.get(getClass().getClassLoader().getResource("sample_default_migration/v1__jpa2ddl_init.sql").toURI()),
			outputPath.toPath().resolve("v1__jpa2ddl_init.sql"));

	Properties jpaProperties = new Properties();
	jpaProperties.setProperty("hibernate.dialect", MySQL57Dialect.class.getCanonicalName());

	SchemaGenerator schemaGenerator = new SchemaGenerator();

	// when
	schemaGenerator.generate(new GeneratorSettings(GenerationMode.DATABASE, outputPath,
			Arrays.asList("com.devskiller.jpa2ddl.sample"), Action.UPDATE, jpaProperties, true, ";", true));

	// then
	String sql = new String(Files.readAllBytes(outputPath.toPath().resolve("v2__jpa2ddl.sql")));
	assertThat(sql).containsIgnoringCase("alter table User");
	assertThat(sql).containsIgnoringCase("add column email");
	assertThat(sql).doesNotContain("create table User");
	assertThat(sql).doesNotContain("create table hibernate_sequence");
	assertThat(sql).doesNotContain("insert into hibernate_sequence values");
}

Example #3

Source File: DatabaseSchemaUpdateTest.java From jpa2ddl with Apache License 2.0

6 votes

@Test
public void shouldSkipGenerationIfNoChanges() throws Exception {
	// given
	File outputPath = tempFolder.newFolder();

	Files.copy(Paths.get(getClass().getClassLoader().getResource("sample_empty_migration/v1__jpa2ddl_init.sql").toURI()),
			outputPath.toPath().resolve("v1__jpa2ddl_init.sql"));

	Properties jpaProperties = new Properties();
	jpaProperties.setProperty("hibernate.dialect", MySQL57Dialect.class.getCanonicalName());

	SchemaGenerator schemaGenerator = new SchemaGenerator();

	// when
	schemaGenerator.generate(new GeneratorSettings(GenerationMode.DATABASE, outputPath,
			Arrays.asList("com.devskiller.jpa2ddl.sample"), Action.UPDATE, jpaProperties, true, ";", true));

	// then
	File migrationFile = outputPath.toPath().resolve("v2__jpa2ddl.sql").toFile();
	assertThat(migrationFile).doesNotExist();
}

Example #4

Source File: StrategySelectorBuilder.java From lams with GNU General Public License v2.0

4 votes

private void addDialects(StrategySelectorImpl strategySelector) {
	addDialect( strategySelector, Cache71Dialect.class );
	addDialect( strategySelector, CUBRIDDialect.class );
	addDialect( strategySelector, DB2Dialect.class );
	addDialect( strategySelector, DB2390Dialect.class );
	addDialect( strategySelector, DB2390V8Dialect.class );
	addDialect( strategySelector, DB2400Dialect.class );
	addDialect( strategySelector, DerbyTenFiveDialect.class );
	addDialect( strategySelector, DerbyTenSixDialect.class );
	addDialect( strategySelector, DerbyTenSevenDialect.class );
	addDialect( strategySelector, FirebirdDialect.class );
	addDialect( strategySelector, FrontBaseDialect.class );
	addDialect( strategySelector, H2Dialect.class );
	addDialect( strategySelector, HANAColumnStoreDialect.class );
	addDialect( strategySelector, HANARowStoreDialect.class );
	addDialect( strategySelector, HSQLDialect.class );
	addDialect( strategySelector, InformixDialect.class );
	addDialect( strategySelector, IngresDialect.class );
	addDialect( strategySelector, Ingres9Dialect.class );
	addDialect( strategySelector, Ingres10Dialect.class );
	addDialect( strategySelector, InterbaseDialect.class );
	addDialect( strategySelector, JDataStoreDialect.class );
	addDialect( strategySelector, MckoiDialect.class );
	addDialect( strategySelector, MimerSQLDialect.class );
	addDialect( strategySelector, MySQL5Dialect.class );
	addDialect( strategySelector, MySQL5InnoDBDialect.class );
	addDialect( strategySelector, MySQL57InnoDBDialect.class );
	addDialect( strategySelector, MySQL57Dialect.class );
	addDialect( strategySelector, Oracle8iDialect.class );
	addDialect( strategySelector, Oracle9iDialect.class );
	addDialect( strategySelector, Oracle10gDialect.class );
	addDialect( strategySelector, PointbaseDialect.class );
	addDialect( strategySelector, PostgresPlusDialect.class );
	addDialect( strategySelector, PostgreSQL81Dialect.class );
	addDialect( strategySelector, PostgreSQL82Dialect.class );
	addDialect( strategySelector, PostgreSQL9Dialect.class );
	addDialect( strategySelector, ProgressDialect.class );
	addDialect( strategySelector, SAPDBDialect.class );
	addDialect( strategySelector, SQLServerDialect.class );
	addDialect( strategySelector, SQLServer2005Dialect.class );
	addDialect( strategySelector, SQLServer2008Dialect.class );
	addDialect( strategySelector, Sybase11Dialect.class );
	addDialect( strategySelector, SybaseAnywhereDialect.class );
	addDialect( strategySelector, SybaseASE15Dialect.class );
	addDialect( strategySelector, SybaseASE157Dialect.class );
	addDialect( strategySelector, TeradataDialect.class );
	addDialect( strategySelector, TimesTenDialect.class );
}