Hibernate6根据xml获取ddl sql语句

发布于:2024-04-27 ⋅ 阅读:(26) ⋅ 点赞:(0)
package com.kongjs.dbmo.jdbc;

import org.hibernate.boot.Metadata;
import org.hibernate.boot.MetadataSources;
import org.hibernate.boot.registry.StandardServiceRegistry;
import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
import org.hibernate.engine.config.spi.ConfigurationService;
import org.hibernate.tool.schema.SourceType;
import org.hibernate.tool.schema.TargetType;
import org.hibernate.tool.schema.internal.ExceptionHandlerHaltImpl;
import org.hibernate.tool.schema.spi.*;
import org.springframework.core.io.Resource;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.core.io.support.ResourcePatternResolver;
import org.springframework.util.StringUtils;

import java.io.*;
import java.util.*;

public class Hibernate6DDL {

    public static String getDDLSql(String dialect, File dir) {
        StringBuilder sb = new StringBuilder();
        StandardServiceRegistry serviceRegistry = new StandardServiceRegistryBuilder()
                .applySetting("hibernate.dialect", dialect)
                .applySetting("hibernate.temp.use_jdbc_metadata_defaults", false)
                .build();
        try {
            Metadata metadata = new MetadataSources(serviceRegistry)
                    .addDirectory(dir)
                    .buildMetadata();

            Map<String, Object> config = new HashMap<>(Objects.requireNonNull(serviceRegistry.getService(ConfigurationService.class)).getSettings());
            ExceptionHandler exceptionHandler = ExceptionHandlerHaltImpl.INSTANCE;
            ExecutionOptions executionOptions = SchemaManagementToolCoordinator.buildExecutionOptions(config, exceptionHandler);
            SchemaManagementTool tool = serviceRegistry.getService(SchemaManagementTool.class);

            SourceDescriptor sourceDescriptor = new SourceDescriptor() {
                @Override
                public SourceType getSourceType() {
                    return SourceType.METADATA;
                }

                @Override
                public ScriptSourceInput getScriptSourceInput() {
                    return null;
                }
            };

            TargetDescriptor targetDescriptor = new TargetDescriptor() {
                @Override
                public EnumSet<TargetType> getTargetTypes() {
                    return EnumSet.of(TargetType.SCRIPT);
                }

                @Override
                public ScriptTargetOutput getScriptTargetOutput() {
                    return new ScriptTargetOutput() {
                        @Override
                        public void prepare() {

                        }

                        @Override
                        public void accept(String command) {
                            sb.append(command);
                            sb.append("\n");
                        }

                        @Override
                        public void release() {

                        }
                    };
                }
            };

            Objects.requireNonNull(tool);

            SchemaCreator schemaCreator = tool.getSchemaCreator(config);
            schemaCreator.doCreation(metadata, executionOptions, ContributableMatcher.ALL, sourceDescriptor, targetDescriptor);

            SchemaDropper schemaDropper = tool.getSchemaDropper(config);
            schemaDropper.doDrop(metadata, executionOptions, ContributableMatcher.ALL, sourceDescriptor, targetDescriptor);

        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            StandardServiceRegistryBuilder.destroy(serviceRegistry);
        }
        return sb.toString();
    }

    public static final Map<String, String> dialects = new LinkedHashMap<>();

    public static void initDialect(String classpath) {
        try {
            ResourcePatternResolver resourcePatternResolver = new PathMatchingResourcePatternResolver();
            Resource[] resources = resourcePatternResolver.getResources(classpath);
            for (Resource resource : resources) {
                String filename = resource.getFilename();
                if (filename == null) {
                    continue;
                }
                if (filename.contains("Dialect") && !filename.contains("Abstract")) {
                    int indexOf = filename.indexOf("Dialect");
                    String name = filename.substring(0, indexOf);
                    if (!StringUtils.hasLength(name)) {
                        continue;
                    }
                    if (!filename.contains("community")) {
                        dialects.put(name, "org.hibernate.dialect." + name + "Dialect");
                    } else {
                        dialects.put(name, "org.hibernate.community.dialect." + name + "Dialect");
                    }
                }
            }
        } catch (IOException e) {
            throw new RuntimeException(e);
        }
    }

    static {
        String path1 = "classpath*:/org/hibernate/dialect/**";
        //initDialect(path1);
        String path2 = "classpath*:/org/hibernate/community/dialect/**";
        //initDialect(path2);
    }

    public static void main(String[] args) throws FileNotFoundException {
        //System.out.println(dialects);
        //System.out.println(getCreatorSql("org.hibernate.dialect.PostgreSQLDialect",
                //new FileInputStream("C:\\Users\\Administrator\\IdeaProjects\\dbmo\\dbmo-start\\src\\test\\resources\\Event.hbm.xml")));
    }
}