writeimportdefinition.java

数据仓库工具

/*
LoaderGenerator - tool for generated xml, sql and doml file needed for Octopus.


    Copyright (C) 2003  Together

    This library is free software; you can redistribute it and/or
    modify it under the terms of the GNU Lesser General Public
    License as published by the Free Software Foundation; either
    version 2.1 of the License, or (at your option) any later version.

    This library is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
    Lesser General Public License for more details.

    You should have received a copy of the GNU Lesser General Public
    License along with this library; if not, write to the Free Software
    Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
*/

package org.webdocwf.util.loader.generator;

import org.w3c.dom.Document;
import org.w3c.dom.Element;
import org.webdocwf.util.loader.LoaderException;
import org.webdocwf.util.loader.logging.Logger;
import org.webdocwf.util.loader.logging.StandardLogger;

/**
 *
 * WriteImportDefinition class creates ImportDefinition.xml file.
 * @author Radoslav Dutina
 * @version 1.0
 */
public class WriteImportDefinition {
    private Logger logger;

    /**
     * Construct object WriteImportDefinition with associated parameters.
     * @param document is the org.w3c.dom.Document object, which is created in CreateIncludeFile class.
     * @param root is the root element from document object.
     * @param importDefinitionAttributes is references to ImportDefinitionAttributes object.
     * @param generatorParameters represents the references to InputParameter object.
     * @throws LoaderException
     */

    public WriteImportDefinition(Document document, Element root, ImportDefinitionAttributes importDefinitionAttributes, InputParameters generatorParameters) throws LoaderException {
				setLogger();
				this.logger.write("full", "WriteImportDefinition is started.");
        if (!generatorParameters.getFullMode()) {

            Element childRoot1 = (Element) document.createElement("copyTable");
            root.appendChild(childRoot1);
            childRoot1.setAttribute("name", importDefinitionAttributes.getName());
            childRoot1.setAttribute("sourceTableName", importDefinitionAttributes.getName());
            childRoot1.setAttribute("targetTableName", importDefinitionAttributes.getName());
            //      childRoot1.setAttribute("logMode", importDefinitionAttributes.getLogMode());
            childRoot1.setAttribute("objectIDIncrement", importDefinitionAttributes.getObjectIDIncrementid());
            childRoot1.setAttribute("oidLogic", "false");
            childRoot1.setAttribute("onErrorContinue", "false");

        } else {
            Element childRoot1 = (Element) document.createElement("importDefinition");
            root.appendChild(childRoot1);
            childRoot1.setAttribute("name", importDefinitionAttributes.getName());
            childRoot1.setAttribute("tableName", importDefinitionAttributes.getTableName());
            //childRoot1.setAttribute("objectIDIncrement", importDefinitionAttributes.getObjectIDIncrementid());
            //      childRoot1.setAttribute("logMode", importDefinitionAttributes.getLogMode());

            Element childRoot2 = (Element) document.createElement("valueColumns");
            childRoot1.appendChild(childRoot2);

            for (int i = 0; i < importDefinitionAttributes.getTagSourceColumnName().length; i++) {
                if (generatorParameters.getSourceType().equalsIgnoreCase("csv")) {
                    Element childRoot3 = (Element) document.createElement("valueColumn");
                    childRoot2.appendChild(childRoot3);
                    childRoot3.setAttribute("sourceColumnName", importDefinitionAttributes.getTagSourceColumnName()[i]);
                    childRoot3.setAttribute("targetTableName", importDefinitionAttributes.getTagTargetTableName()[i]);
                    childRoot3.setAttribute("targetColumnName", importDefinitionAttributes.getTagTargetColumnName()[i]);
                    childRoot3.setAttribute("targetTableID", importDefinitionAttributes.getTagTargetTableID()[i]);
                    childRoot3.setAttribute("valueMode", generatorParameters.getValueMode());
                } else {
                    if (!generatorParameters.getValueMode().equalsIgnoreCase("Overwrite")) {
                        if (!importDefinitionAttributes.getTagSourceColumnName()[i].equalsIgnoreCase("oid") && !importDefinitionAttributes.getTagSourceColumnName()[i].equalsIgnoreCase("version")) {
                            boolean fk = true;
                            for (int j = 0; j < RelationshipsAttributes.getForeignVariables().length; j = j + 5) {
                                if (RelationshipsAttributes.getForeignVariables()[j + 2].equalsIgnoreCase(importDefinitionAttributes.getTagSourceColumnName()[i])) {
                                    fk = false;
                                    break;
                                }
                            }
                            if (fk) {
                                Element childRoot3 = (Element) document.createElement("valueColumn");
                                childRoot2.appendChild(childRoot3);
                                childRoot3.setAttribute("sourceColumnName", importDefinitionAttributes.getTagSourceColumnName()[i]);
                                childRoot3.setAttribute("targetTableName", importDefinitionAttributes.getTagTargetTableName()[i]);
                                childRoot3.setAttribute("targetColumnName", importDefinitionAttributes.getTagTargetColumnName()[i]);
                                childRoot3.setAttribute("targetTableID", importDefinitionAttributes.getTagTargetTableID()[i]);
                                childRoot3.setAttribute("valueMode", generatorParameters.getValueMode());

                            }
                        }
                    } else {
//                        if (!importDefinitionAttributes.getTagSourceColumnName()[i].equalsIgnoreCase("version")) {
                            if (!importDefinitionAttributes.getTagColumnType()[i].toLowerCase().endsWith("identity")) {
                                Element childRoot3 = (Element) document.createElement("valueColumn");
                                childRoot2.appendChild(childRoot3);
                                childRoot3.setAttribute("sourceColumnName", importDefinitionAttributes.getTagSourceColumnName()[i]);
                                childRoot3.setAttribute("targetTableName", importDefinitionAttributes.getTagTargetTableName()[i]);
                                childRoot3.setAttribute("targetColumnName", importDefinitionAttributes.getTagTargetColumnName()[i]);
                                childRoot3.setAttribute("targetTableID", importDefinitionAttributes.getTagTargetTableID()[i]);
                                childRoot3.setAttribute("valueMode", generatorParameters.getValueMode());
                            }
//                        } else {
//                            Element childRoot5 = (Element) document.createElement("constantColumns");
//                            childRoot1.appendChild(childRoot5);
//                            Element childRoot3 = (Element) document.createElement("constantColumn");
//                            childRoot5.appendChild(childRoot3);
//                            childRoot3.setAttribute("constantValue", "0");
//                            childRoot3.setAttribute("targetTableName", importDefinitionAttributes.getTagTargetTableName()[i]);
//                            childRoot3.setAttribute("targetColumnName", "version");
//                            childRoot3.setAttribute("targetTableID", "0");