/
SchemaTest.java
79 lines (68 loc) · 3.54 KB
/
SchemaTest.java
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
/*
* Copyright (c) 2010-2017 Evolveum
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package com.evolveum.midpoint.repo.sql;
import com.evolveum.midpoint.repo.sql.util.*;
import com.evolveum.midpoint.util.ClassPathUtil;
import org.hibernate.boot.MetadataSources;
import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
import org.hibernate.dialect.H2Dialect;
import org.hibernate.dialect.Oracle12cDialect;
import org.hibernate.tool.hbm2ddl.SchemaExport;
import org.hibernate.tool.schema.TargetType;
import org.testng.annotations.Test;
import java.util.EnumSet;
import java.util.Set;
/**
* Created by Viliam Repan (lazyman).
*/
public class SchemaTest {
@Test
public void generateSchemas() throws Exception {
createSQLSchema("./target/h2-schema.sql", H2Dialect.class.getName());
createSQLSchema("./target/sqlserver-schema.sql", UnicodeSQLServer2008Dialect.class.getName());
createSQLSchema("./target/mysql-schema.sql", MidPointMySQLDialect.class.getName());
createSQLSchema("./target/oracle-schema.sql", Oracle12cDialect.class.getName());
createSQLSchema("./target/postgresql-schema.sql", MidPointPostgreSQLDialect.class.getName());
}
private void createSQLSchema(String fileName, String dialect) throws Exception {
MetadataSources metadata = new MetadataSources(
new StandardServiceRegistryBuilder()
.applySetting("hibernate.implicit_naming_strategy", new MidPointImplicitNamingStrategy())
.applySetting("hibernate.physical_naming_strategy", new MidPointPhysicalNamingStrategy())
.applySetting("hibernate.dialect", dialect)
.build());
addAnnotatedClasses("com.evolveum.midpoint.repo.sql.data.common", metadata);
addAnnotatedClasses("com.evolveum.midpoint.repo.sql.data.common.container", metadata);
addAnnotatedClasses("com.evolveum.midpoint.repo.sql.data.common.any", metadata);
addAnnotatedClasses("com.evolveum.midpoint.repo.sql.data.common.embedded", metadata);
addAnnotatedClasses("com.evolveum.midpoint.repo.sql.data.common.enums", metadata);
addAnnotatedClasses("com.evolveum.midpoint.repo.sql.data.common.id", metadata);
addAnnotatedClasses("com.evolveum.midpoint.repo.sql.data.common.other", metadata);
addAnnotatedClasses("com.evolveum.midpoint.repo.sql.data.common.type", metadata);
addAnnotatedClasses("com.evolveum.midpoint.repo.sql.data.audit", metadata);
metadata.addPackage("com.evolveum.midpoint.repo.sql.type");
SchemaExport export = new SchemaExport();
export.setOutputFile(fileName);
export.setDelimiter(";");
export.execute(EnumSet.of(TargetType.SCRIPT), SchemaExport.Action.CREATE, metadata.buildMetadata());
}
private void addAnnotatedClasses(String packageName, MetadataSources metadata) {
Set<Class> classes = ClassPathUtil.listClasses(packageName);
for (Class clazz : classes) {
metadata.addAnnotatedClass(clazz);
}
}
}