Java Code Examples for org.hibernate.dialect.MySQL57Dialect

The following examples show how to use org.hibernate.dialect.MySQL57Dialect. These examples are extracted from open source projects. 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 Project: jpa2ddl   Source File: DatabaseSchemaUpdateTest.java    License: Apache License 2.0 6 votes vote down vote up
@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 Project: jpa2ddl   Source File: DatabaseSchemaUpdateTest.java    License: Apache License 2.0 6 votes vote down vote up
@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 Project: jpa2ddl   Source File: DatabaseSchemaUpdateTest.java    License: Apache License 2.0 6 votes vote down vote up
@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 Project: lams   Source File: StrategySelectorBuilder.java    License: GNU General Public License v2.0 4 votes vote down vote up
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 );
}