domldesignreader.java

数据仓库工具

                            listColumnLenght.add(size);
                        }
                      }
                    }
                  }
                }else {
                  NodeList typeList=((ElementImpl)columnList.item(j)).getElementsByTagName("type");
                  if(typeList.getLength()!=0){
                    for(int k=0;k<typeList.getLength();k++){
                      size=((ElementImpl)typeList.item(k)).getAttribute("size");
                      canBeNull=((ElementImpl)typeList.item(k)).getAttribute("canBeNull");
                      dbType=((ElementImpl)typeList.item(k)).getAttribute("dbType");

                      if(canBeNull.equalsIgnoreCase("true")){
                        listAllowNulls.add("");
                      }else{
                        listAllowNulls.add(" NOT NULL ");
                      }
                      //Mapp the type of the parameter
                      mappingTypeData=new MappingTypeData(dbType, generatorParameters);
                      listColumnType.add(mappingTypeData.getSQLType());
//ZK change this 6.5.2004
//                      if((size.equalsIgnoreCase("")||size==null)&&
//                         (mappingTypeData.getSQLType().equalsIgnoreCase("varchar")||
//                         mappingTypeData.getSQLType().equalsIgnoreCase("nvarchar")||
//                         mappingTypeData.getSQLType().equalsIgnoreCase("longvarchar"))){
//                      listColumnLenght.add("32");
					  if((size.equalsIgnoreCase("")||size==null) &&
					  	(generatorParameters.getHasSize(mappingTypeData.getSQLType()).equalsIgnoreCase("true"))){
						 listColumnLenght.add("32");
					  }else if (!size.equalsIgnoreCase("")){
                         listColumnLenght.add(" ("+size+") ");
                      }else{
                        listColumnLenght.add(size);
                      }
                    }
                  }
                }
              }
            }
            //add column names for columns oid and version
            if(addOid==true&&countOid<tableList.getLength()){
              listColumnNames.add(generatorParameters.getOidColumnName());
              listTargetTableNames.add(tableName);
              listTargetTableID.add("0");
              listAllowNulls.add(" NOT NULL ");
              listColumnLenght.add(" (" + oidDbSize + ") ");
              listColumnType.add(oidDbType);

              listColumnNames.add(generatorParameters.getVersionColumnName());
              listTargetTableNames.add(tableName);
              listTargetTableID.add("0");
              listAllowNulls.add(" NOT NULL ");
              listColumnLenght.add("");
              listColumnType.add(generatorParameters.getVersionColumnType());

              String primaryKeyNameOid=tableName+"_"+generatorParameters.getOidColumnName();
              if( maxConstraintInt>0 && primaryKeyNameOid.length()>maxConstraintInt ){
                String newPrimaryName=primaryKeyNameOid.substring(0,maxConstraintInt-String.valueOf(counterConstraint).length());
                primaryKeyNameOid=newPrimaryName+String.valueOf(counterConstraint);
                counterConstraint++;
              }
              listPrimaryKeys.add(primaryKeyNameOid);
              listPrimaryKeys.add(generatorParameters.getOidColumnName());
            }

            importDefinitionAttributes.setTagSourceColumnName(getColumnNames());
            importDefinitionAttributes.setTagTargetColumnName(getColumnNames());
            importDefinitionAttributes.setTagTargetTableName(getTargetTableNames());
            importDefinitionAttributes.setTagTargetTableID(getTargetTableID());
            importDefinitionAttributes.setTagColumnType(getColumnType());
            importDefinitionAttributes.setTagAllowNulls(getAllowNulls());
            importDefinitionAttributes.setTagColumnLenght(getColumnLenght());

            relationshipsAttributes.setTableName(tableName);
            relationshipsAttributes.setPrimaryKeys(getPrimaryKeys());
            relationshipsAttributes.setIndexVariables(getIndexVariables());
            relationshipsAttributes.setForeignVariables(getForeignVariables());

            WriteSqlFiles writeSql= new WriteSqlFiles(tableName, countOid,
                getImportDefinition(), getRelationshipsAttributes(), generatorParameters);

            WriteImportDefinition writeImportDefinition=new WriteImportDefinition(document,root,
                getImportDefinition(), generatorParameters);
            countOid++;
          }
          //System.out.println("\ndone....");
          //BufferOctopusClass.getInstance().writeToBuffer("\ndone....");
		  		this.logger.write("normal", "\ndone....");
	}
      }else{
        String msg = "Your file don't have database tag!";
        LoaderException le=new LoaderException("Exception:",(Throwable) new Exception(msg));
				this.logger.write("full", "Exception in class DomlDesignReader:"+le.getStackTraceAsString());
        throw le;
      }
    } catch( Exception e ) {
      String msg="Exception in class DomlDesignReader: Error has occurred when trying to set parameters!"+"\n";

      LoaderException le=new LoaderException(msg+e.getMessage(), (Throwable)e);
	  	this.logger.write("full", "Exception in class DomlDesignReader: Error has occurred when trying to set parameters!"+"\n"+ le.getStackTraceAsString());
      throw le;
    }
	this.logger.write("normal", "DomlDesignReader is finished.");
  }

  /**
   * This method read value of importDefinitionAttributes parameters.
   * @return references to ImportDefinitionAttributes objects.
   */
  public ImportDefinitionAttributes getImportDefinition(){
    return importDefinitionAttributes;
  }

  /**
   * This method read value of relationshipsAttributes parameters.
   * @return references to RelationshipsAttributes objects.
   */
  public RelationshipsAttributes getRelationshipsAttributes(){
    return relationshipsAttributes;
  }

  /**
   * This method sets value of listColumnNames parameters.
   * @param list_ColumnNames is value of parameters.
   */
  public static void setColumnNames(String[] list_ColumnNames){
    listColumnNames=Arrays.asList(list_ColumnNames);
  }

  /**
   * This method read value of listColumnNames parameters.
   * @return value of parameters.
   */
  public static String[] getColumnNames(){
    String[] ret=new String[listColumnNames.size()];
    listColumnNames.toArray(ret);
    return ret;
  }

  /**
   * This method sets value of listTargetTableNames parameters.
   * @param list_TargetTableNames is value of parameters.
   */
  public static void setTargetTableNames(String[] list_TargetTableNames){
    listTargetTableNames=Arrays.asList(list_TargetTableNames);
  }

  /**
   * This method read value of listTargetTableNames parameters.
   * @return value of parameters.
   */
  public static String[] getTargetTableNames(){
    String[] ret=new String[listTargetTableNames.size()];
    listTargetTableNames.toArray(ret);
    return ret;
  }

  /**
   * This method sets value of listTargetTableID parameters.
   * @param list_TargetTableID is value of parameter.
   */
  public static void setTargetTableID(String[] list_TargetTableID){
    listTargetTableID=Arrays.asList(list_TargetTableID);
  }

  /**
   * This method read value of listTargetTableID parameters.
   * @return value of parameters.
   */
  public static String[] getTargetTableID(){
    String[] ret=new String[listTargetTableID.size()];
    listTargetTableID.toArray(ret);
    return ret;
  }

  /**
   * This method sets value of listColumnType parameters.
   * @param list_ColumnType is value of parameters.
   */
  public static void setColumnType(String[] list_ColumnType){
    listColumnType=Arrays.asList(list_ColumnType);
  }

  /**
   * This method read value of listColumnType parameters.
   * @return value of parameters.
   */
  public static String[] getColumnType(){
    String[] ret=new String[listColumnType.size()];
    listColumnType.toArray(ret);
    return ret;
  }

  /**
   * This method sets value of listColumnLenght parameters.
   * @param list_ColumnLenght is value of parameter.
   */
  public static void setColumnLenght(String[] list_ColumnLenght){
    listColumnLenght=Arrays.asList(list_ColumnLenght);
  }

  /**
   * This method read value of listColumnLenght parameters.
   * @return value of parameters.
   */
  public static String[] getColumnLenght(){
    String[] ret=new String[listColumnLenght.size()];
    listColumnLenght.toArray(ret);
    return ret;
  }

  /**
   * This method sets value of listAllowNulls parameters.
   * @param list_AllowNulls is value of parameters.
   */
  public static void setAllowNulls(String[] list_AllowNulls){
    listAllowNulls=Arrays.asList(list_AllowNulls);
  }

  /**
   * This method read value of listAllowNulls parameters.
   * @return value of parameters.
   */
  public static String[] getAllowNulls(){
    String[] ret=new String[listAllowNulls.size()];
    listAllowNulls.toArray(ret);
    return ret;
  }


  /**
   * This method sets the value of listPrimaryKeys parameters.
   * @param primary_Keys is value of parameter.
   */
  public static void setPrimaryKeys(String[] primary_Keys){
    listPrimaryKeys=Arrays.asList(primary_Keys);
  }

  /**
   * This method read the value of listPrimaryKeys parameters.
   * @return value of parameter.
   */
  public static String[] getPrimaryKeys(){
    String[] ret=new String[listPrimaryKeys.size()];
    listPrimaryKeys.toArray(ret);
    return ret;
  }

  /**
   * This method sets the value of listIndexVariables parameters.
   * @param index_Variables is value of parameter.
   */
  public static void setIndexVariables(String[] index_Variables){
    listIndexVariables=Arrays.asList(index_Variables);
  }

  /**
   * This method read the value of listIndexVariables parameters.
   * @return value of parameter.
   */
  public static String[] getIndexVariables(){
    String[] ret=new String[listIndexVariables.size()];
    listIndexVariables.toArray(ret);
    return ret;
  }

  /**
   * This method sets the value of listForeignVariables parameters.
   * @param foreign_Variables is the value of parameter.
   */
  public static void setForeignVariables(String[] foreign_Variables){
    listForeignVariables=Arrays.asList(foreign_Variables);
  }

  /**
   * This method read the value of listForeignVariables parameters.
   * @return value of parameter.
   */
  public static String[] getForeignVariables(){
    String[] ret=new String[listForeignVariables.size()];
    listForeignVariables.toArray(ret);
    return ret;
  }
  /**
	   * This method will set logger object
	   * @param logger
	   */
	  private void setLogger() {
		  this.logger = StandardLogger.getCentralLogger();
	  }

}