Hello, I would like to write an extension plugin that automatically generates a method

how to obtain the unique constraint fields of a table in extension plugin about generator HOT 2 CLOSED

jobmission commented on August 17, 2024

how to obtain the unique constraint fields of a table in extension plugin

from generator.

Comments (2)

jeffgbutler commented on August 17, 2024

Any plugin method has access to the plugin context. From the context you can create a database connection and retrieve information you need. In this case, you should call the getCrossReference method in database metadata and interpret the results as you wish. For example something like this:

    @Override
    public boolean clientGenerated(Interface interfaze, IntrospectedTable introspectedTable) {
        try (Connection connection = context.getConnection()) {
            DatabaseMetaData databaseMetaData = connection.getMetaData();
            ResultSet resultSet = databaseMetaData.getCrossReference(...)
            // process the resultSet to find the unique constraints, then generate methods as needed
        } catch (SQLException e) {
            throw new RuntimeException("SqlException in my plugin", e);
        }

        return true;
    }

If you need to do this in more than one plugin method, you could do the instrospection before the individual methods are called like this:

    @Override
    public void initialized(IntrospectedTable introspectedTable) {
        try (Connection connection = context.getConnection()) {
            DatabaseMetaData databaseMetaData = connection.getMetaData();
            ResultSet resultSet = databaseMetaData.getCrossReference(...)
            // process the resultSet to find the unique constraints, then save that information for later use
        } catch (SQLException e) {
            throw new RuntimeException("SqlException in my plugin", e);
        }
    }

    @Override
    public boolean clientGenerated(Interface interfaze, IntrospectedTable introspectedTable) {
        // use the saved data to generate methods as needed

        return true;
    }