de.opitzconsulting.orcas.diff.ExtensionHandlerImpl Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of orcas-domainextension-main-extensionhandler Show documentation
orcas extensionhandler
The newest version!
package de.opitzconsulting.orcas.diff;

import java.net.URL;
import java.sql.CallableStatement;
import java.sql.SQLException;
import java.sql.Struct;
import java.util.List;
import java.util.function.UnaryOperator;
import java.util.stream.Collectors;

import org.apache.commons.logging.Log;

import com.opitzconsulting.orcas.xslt.XsltExtractDirAccessClass;
import de.opitzconsulting.OrcasDslStandaloneSetup;
import de.opitzconsulting.orcas.diff.JdbcConnectionHandler.RunWithCallableStatementProvider;
import de.opitzconsulting.orcas.extensions.AllExtensions;
import de.opitzconsulting.orcas.orig.diff.DiffRepository;
import de.opitzconsulting.orcas.sql.CallableStatementProvider;
import de.opitzconsulting.orcas.sql.WrapperCallableStatement;
import de.opitzconsulting.orcas.syex.load.DataReader;
import de.opitzconsulting.orcas.syex.trans.TransformOrigSyex;
import de.opitzconsulting.orcas.syex.trans.TransformSyexOrig;
import de.opitzconsulting.orcas.syex.xml.XmlExport;
import de.opitzconsulting.orcasDsl.Mview;
import de.opitzconsulting.orcasDsl.OrcasDslPackage;
import de.opitzconsulting.orcasDsl.Sequence;
import de.opitzconsulting.orcasDsl.Table;
import de.opitzconsulting.orcasDsl.impl.ModelImpl;
import de.opitzconsulting.origOrcasDsl.Model;

public class ExtensionHandlerImpl extends BaseExtensionHandlerImpl {
    protected de.opitzconsulting.orcasDsl.Model loadModelFromSqlplusTable() throws Exception {
        final de.opitzconsulting.orcasDsl.Model lOutputModel = new ModelImpl();

        JdbcConnectionHandler.runWithCallableStatementProvider(
            getParameters(),
            getParameters().getOrcasJdbcConnectParameters(),
            new RunWithCallableStatementProvider() {
                public void run(CallableStatementProvider pCallableStatementProvider) throws Exception {
                    String lCallExtensions = ""
                        +
                        //
                        " declare"
                        + " v_model "
                        + getParameters().getOrcasDbUser()
                        + ".ot_syex_model;"
                        + " v_anydata SYS.ANYDATA;"
                        + " begin "
                        +
                        //
                        "   select model into v_anydata from "
                        + getParameters().getOrcasDbUser()
                        + ".orcas_sqlplus_model;"
                        + " if( v_anydata.getObject( v_model ) = DBMS_TYPES.SUCCESS )"
                        + " then "
                        + "    null; "
                        + " end if;"
                        +
                        //
                        " ? := v_model;"
                        +
                        //
                        " end; "
                        +
                        //
                        "";

                    new WrapperCallableStatement(lCallExtensions, pCallableStatementProvider) {
                        @Override
                        protected void useCallableStatement(CallableStatement pCallableStatement) throws SQLException {
                            pCallableStatement.registerOutParameter(
                                1,
                                java.sql.Types.STRUCT,
                                (getParameters().getOrcasDbUser() + ".ot_syex_model").toUpperCase());

                            pCallableStatement.execute();

                            DataReader.setIntNullValue(DiffRepository.getNullIntValue());
                            DataReader.loadIntoModel(lOutputModel, (Struct) pCallableStatement.getObject(1));
                        }
                    }.execute();
                }
            });

        return lOutputModel;
    }

    @Override
    public Model loadModel() {
        return TransformSyexOrig.convertModel(loadSyexModel());
    }

    public de.opitzconsulting.orcasDsl.Model loadSyexModel() {
        de.opitzconsulting.orcasDsl.Model lSyexModel;
        if (getParameters().getModelFile().endsWith("xml")) {
            lSyexModel = createlXtextFileLoader().loadModelXml(getParameters().getModelFile(), OrcasDslPackage.eNS_URI, OrcasDslPackage.eINSTANCE);
        } else {
            if (getParameters().getSqlplustable()) {
                logInfo("loading sqlplus data");
                try {
                    lSyexModel = loadModelFromSqlplusTable();
                } catch (Exception e) {
                    throw new RuntimeException(e);
                }
            } else {
                logInfo("loading files");
                lSyexModel = loadSyexModelFromFiles();
            }

            AllExtensions lAllExtensions = new AllExtensions();
            lAllExtensions.setUseReverseExtension(false);
            if (lAllExtensions.hasExtension()) {
                logInfo("calling java extensions");
                lSyexModel = callJavaExtensions(lSyexModel, lAllExtensions);
            }

            List>
                lAdditionalExtensions =
                getParameters().getAdditionalOrcasExtensionFactory().getAdditionalExtensions(de.opitzconsulting.orcasDsl.Model.class, false);
            if (!lAdditionalExtensions.isEmpty()) {
                logInfo("calling additional extensions");
                for (UnaryOperator lOrcasExtension : lAdditionalExtensions) {
                    lSyexModel = lOrcasExtension.apply(lSyexModel);
                }
            }

            if (PlSqlHandler.isPlSqlEextensionsExistst()) {
                logInfo("calling pl/sql extensions");
                try {
                    lSyexModel = PlSqlHandler.callPlSqlExtensions(lSyexModel, getParameters(), false);
                } catch (Exception e) {
                    throw new RuntimeException(e);
                }
            }
        }

        return lSyexModel;
    }

    @Override
    protected XtextFileLoader createlXtextFileLoader() {
        return new XtextFileLoader() {

            @Override
            protected List getTableNames(de.opitzconsulting.orcasDsl.Model pModel) {
                return pModel.getModel_elements()
                             .stream()
                             .filter(p -> p instanceof Table)
                             .map(p -> (Table) p)
                             .map(Table::getName)
                             .map(String::toUpperCase)
                             .collect(Collectors.toList());
            }

            @Override
            protected List getSequenceNames(de.opitzconsulting.orcasDsl.Model pModel) {
                return pModel.getModel_elements()
                             .stream()
                             .filter(p -> p instanceof Sequence)
                             .map(p -> (Sequence) p)
                             .map(Sequence::getSequence_name)
                             .map(String::toUpperCase)
                             .collect(Collectors.toList());
            }

            @Override
            protected List getMviewNames(de.opitzconsulting.orcasDsl.Model pModel) {
                return pModel.getModel_elements()
                             .stream()
                             .filter(p -> p instanceof Mview)
                             .map(p -> (Mview) p)
                             .map(Mview::getMview_name)
                             .map(String::toUpperCase)
                             .collect(Collectors.toList());
            }

            @Override
            protected void combinModelResults(
                de.opitzconsulting.orcasDsl.Model pCombinedModel,
                de.opitzconsulting.orcasDsl.Model pModelPartFromSingleFile) {
                pCombinedModel.getModel_elements().addAll(pModelPartFromSingleFile.getModel_elements());
            }

            @Override
            protected de.opitzconsulting.orcasDsl.Model createModelInstance() {
                return new ModelImpl();
            }

            @Override
            protected String getXtextExpectedFileEnding() {
                return "orcasdsl";
            }
        };
    }

    @Override
    public String convertModelToXMLString(Model lOrigModel) {
        de.opitzconsulting.orcasDsl.Model lSyexModel = TransformOrigSyex.convertModel(lOrigModel);

        if (getParameters().getModelFiles() != null || !getParameters().getModelFile().equals("")) {
            logInfo("loading additional model files");
            lSyexModel.getModel_elements().addAll(loadSyexModelFromFiles().getModel_elements());
        }

        if (PlSqlHandler.isPlSqlEextensionsExistst() && getParameters().isLoadExtractWithReverseExtensions()) {
            logInfo("calling pl/sql reverse-extensions");
            try {
                lSyexModel = PlSqlHandler.callPlSqlExtensions(lSyexModel, getParameters(), true);
            } catch (Exception e) {
                throw new RuntimeException(e);
            }
        }

        AllExtensions lAllExtensions = new AllExtensions();
        lAllExtensions.setUseReverseExtension(true);
        if (lAllExtensions.hasExtension()) {
            logInfo("calling java reverse-extensions");
            lSyexModel = callJavaExtensions(lSyexModel, lAllExtensions);
        }

        List>
            lAdditionalReverseExtensions =
            getParameters().getAdditionalOrcasExtensionFactory().getAdditionalExtensions(de.opitzconsulting.orcasDsl.Model.class, true);
        if (!lAdditionalReverseExtensions.isEmpty()) {
            logInfo("calling additional reverse-extensions");
            for (UnaryOperator lOrcasExtension : lAdditionalReverseExtensions) {
                lSyexModel = lOrcasExtension.apply(lSyexModel);
            }
        }

        return new XmlExport().getModel(lSyexModel, true);
    }

    protected de.opitzconsulting.orcasDsl.Model callJavaExtensions(de.opitzconsulting.orcasDsl.Model pSyexModel, AllExtensions pAllExtensions) {
        if (getParameters().getExtensionParameter().length() != 0) {
            pAllExtensions.setParameter(getParameters().getExtensionParameter());
        }
        pSyexModel = pAllExtensions.transformModel(pSyexModel);

        return pSyexModel;
    }

    @Override
    public void handleTargetplsql(CallableStatementProvider pCallableStatementProvider) {
        logInfo("executing " + getParameters().getTargetplsql());
        PlSqlHandler.callTargetPlSql(loadSyexModelFromFiles(), getParameters(), pCallableStatementProvider);
    }

    protected de.opitzconsulting.orcasDsl.Model loadSyexModelFromFiles() {
        return loadSyexModelFromFiles(new OrcasDslStandaloneSetup().createInjectorAndDoEMFRegistration());
    }

    @Override
    public void initOrcasDbIfNeeded(Log pLog) {
        new OrcasInitializeOrcasDbImpl(getParameters()).initOrcasDb(pLog);
    }

    @Override
    public URL getXsltExtractFileURL() {
        return XsltExtractDirAccessClass.getXsltExtractFileURL();
    }

    @Override
    public URL getUriResolverURLForImport(String pHref) {
        return XsltExtractDirAccessClass.getUriResolverURLForImport(pHref);
    }
}