writeimportdefinition.java

数据仓库工具

//                            childRoot3.setAttribute("valueMode", generatorParameters.getValueMode());
//                        }
                    }
                }
            }

            if (!generatorParameters.getSourceType().equalsIgnoreCase("csv")) {
                int j = 0;
                if (generatorParameters.getValueMode().equalsIgnoreCase("Overwrite")) {
                    //
                } else {
                    //valueMode=Overwrite
                    if (RelationshipsAttributes.getForeignVariables().length != 0) {
                        Element childRoot100 = (Element) document.createElement("relationColumns");
                        childRoot1.appendChild(childRoot100);
                        for (int i = 0; i < RelationshipsAttributes.getForeignVariables().length; i = i + 5) {
                            Element childRoot101 = (Element) document.createElement("relationColumn");
                            childRoot100.appendChild(childRoot101);
                            childRoot101.setAttribute("relationSourceTableName", RelationshipsAttributes.getForeignVariables()[i + 3]);
                            childRoot101.setAttribute("relationTargetTableName", importDefinitionAttributes.getTableName());
                            childRoot101.setAttribute("relationTargetColumnName", RelationshipsAttributes.getForeignVariables()[i + 2]);

                            if (i > 5 && RelationshipsAttributes.getForeignVariables()[i + 3].equalsIgnoreCase(RelationshipsAttributes.getForeignVariables()[(i + 3) - 5])) {
                                j = j + 1;
                            } else {
                                j = 0;
                            }
                            childRoot101.setAttribute("relationSourceTableID", "" + j);
                            childRoot101.setAttribute("relationTargetTableID", "0");
                            childRoot101.setAttribute("relationMode", generatorParameters.getValueMode());
                        }
                    }
                }

                int k = 0;
                int l = 0;
                if (RelationshipsAttributes.getForeignVariables().length != 0) {
                    Element childRoot200 = (Element) document.createElement("tables");
                    childRoot1.appendChild(childRoot200);
                    for (int i = 0; i < RelationshipsAttributes.getForeignVariables().length; i = i + 5) {
                        TableAttributes tableAttributes = new TableAttributes(importDefinitionAttributes.getTableName(), generatorParameters.getValueMode());
                        if (l == 0) {
                            //in the first loop
                            Element childRoot201 = (Element) document.createElement("table");
                            childRoot200.appendChild(childRoot201);
                            childRoot201.setAttribute("tableName", tableAttributes.getTableName());
                            childRoot201.setAttribute("tableID", "" + k);
                            childRoot201.setAttribute("insert", tableAttributes.getInsert());
                            childRoot201.setAttribute("tableMode", tableAttributes.getTableMode());
                            childRoot201.setAttribute("oidLogic", tableAttributes.getOidLogic());
                            l++;
                            k++;
                        }
                        if (generatorParameters.getValueMode().equalsIgnoreCase("Overwrite")) {
                            //
                        } else {
                            //valueMode=Overwrite
                            if (RelationshipsAttributes.getForeignVariables()[i + 3].equalsIgnoreCase(importDefinitionAttributes.getTableName())) {
                                //k=k+1
                                Element childRoot202 = (Element) document.createElement("table");
                                childRoot200.appendChild(childRoot202);
                                childRoot202.setAttribute("tableName", tableAttributes.getTableName());
                                childRoot202.setAttribute("tableID", "" + k);
                                childRoot202.setAttribute("insert", "false");
                                childRoot202.setAttribute("tableMode", tableAttributes.getTableMode());
                                childRoot202.setAttribute("oidLogic", tableAttributes.getOidLogic());
                                k++; //
                            } else {
                                k = 0;
                                if (i > 5 && RelationshipsAttributes.getForeignVariables()[i + 3].equalsIgnoreCase(RelationshipsAttributes.getForeignVariables()[(i + 3) - 5])) {
                                    k = k + 1;
                                } else {
                                    k = 0;
                                }
                                Element childRoot205 = (Element) document.createElement("table");
                                childRoot200.appendChild(childRoot205);
                                childRoot205.setAttribute("tableName", RelationshipsAttributes.getForeignVariables()[i + 3]);
                                childRoot205.setAttribute("tableID", "" + k);
                                childRoot205.setAttribute("insert", "false");
                                childRoot205.setAttribute("tableMode", tableAttributes.getTableMode());
                                childRoot205.setAttribute("oidLogic", tableAttributes.getOidLogic());
                            }
                        }
                    }
                } else {
                    //RelationshipsAttributes.getForeignVariables().length==0
                    Element childRoot200 = (Element) document.createElement("tables");
                    childRoot1.appendChild(childRoot200);
                    Element childRoot203 = (Element) document.createElement("table");
                    childRoot200.appendChild(childRoot203);
                    TableAttributes tableAttributes = new TableAttributes(importDefinitionAttributes.getTableName(), generatorParameters.getValueMode());
                    childRoot203.setAttribute("tableName", tableAttributes.getTableName());
                    childRoot203.setAttribute("tableID", "" + k);
                    childRoot203.setAttribute("insert", tableAttributes.getInsert());
                    childRoot203.setAttribute("tableMode", tableAttributes.getTableMode());
                    childRoot203.setAttribute("oidLogic", tableAttributes.getOidLogic());
                }
            } else {
                //for csv tables
                Element childRoot200 = (Element) document.createElement("tables");
                childRoot1.appendChild(childRoot200);
                Element childRoot201 = (Element) document.createElement("table");
                childRoot200.appendChild(childRoot201);
                TableAttributes tableAttributes = new TableAttributes(importDefinitionAttributes.getTableName(), generatorParameters.getValueMode());
                childRoot201.setAttribute("tableName", tableAttributes.getTableName());
                childRoot201.setAttribute("tableID", tableAttributes.getTableID());
                childRoot201.setAttribute("insert", tableAttributes.getInsert());
                childRoot201.setAttribute("tableMode", tableAttributes.getTableMode());
                childRoot201.setAttribute("oidLogic", tableAttributes.getOidLogic());

            }
        }
		this.logger.write("full", "WriteImportDefinition is finished.");
    }
    /**
    				* This method will set logger object
    				* @param logger
    				  */
    private void setLogger() {
        this.logger = StandardLogger.getCentralLogger();
    }
}