loadergenerator.java

数据仓库工具

        this.generatorParameters.setIncludeTableList(includeTableList);
    }

    /**
     * This method return includeTableList
     * @return String which is list with included tables
     * @throws LoaderException
     */
    public String getIncludeTableList() throws LoaderException {
        Vector tmpIncludeTableList = this.generatorParameters.getIncludeTableList();
        return tmpIncludeTableList.toString();
    }

    /**
     * This method set confJarStructure
     * @param confJarStructure
     * @throws LoaderException
     */
    public void setConfJarStructure(String confJarStructure) throws LoaderException {
        this.generatorParameters.setConfJarStructure(confJarStructure);
    }

    /**
     * This method get confJarStructure
     * @return ConfJarStructure
     * @throws LoaderException
     */
    public String getConfJarStructure() throws LoaderException {
        return this.generatorParameters.getConfJarStructure();
    }

    /**
     * This method set restoreMode
     * @param restoreMode
     * @throws LoaderException
     */
    public void setRestoreMode(String restoreMode) throws LoaderException {
        this.generatorParameters.setRestoreMode(restoreMode);
    }

    /**
     * This method return restoreMode
     * @return restoreMode
     * @throws LoaderException
     */
    public String getRestoreMode() throws LoaderException {
        return this.generatorParameters.getRestoreMode();
    }

    
	/**
		* This method return logMode
		* @return logMode
		*/
	   public String getLogMode() {
		   return logMode;
	   }

	   /**
		* This method return strLogDirName
		* @return strLogDirName
		*/
	   public String getStrLogDirName() {
		   return strLogDirName;
	   }

	   /**
		* This method return strLogFileName
		* @return strLogFileName
		*/
	   public String getStrLogFileName() {
		   return strLogFileName;
	   }

	   /**
		* This method set logMode
		* @param logMode
		*/
	   public void setLogMode(String logMode) {
		   this.logMode = logMode;
	   }

	   /**
		* This method set strLogDirName
		* @param strLogDirName
		*/
	   public void setStrLogDirName(String strLogDirName) {
		   this.strLogDirName = strLogDirName;
	   }

	   /**
		* This method set strLogFileName
		* @param strLogFileName
		*/
	   public void setStrLogFileName(String strLogFileName) {
		   this.strLogFileName = strLogFileName;
	   }
   
    /**
     * This method write values for all input parameters to System out
     * @throws LoaderException
     */
    public String inputToString() throws LoaderException {
        String resString = "";
        try {

            resString ="Source type="+ getSourceType()+ "\n" 
                		+ "Source driver=" + getSourceDriverName()+ "\n"
                		+ "Source URL=" + getSourceDataBase()+ "\n"
                    + "Source user="+ getSourceUser()+ "\n"
                    + "Source password="+ getSourcePassword()+ "\n"
                    + "Target type=" + getTargetType()+ "\n"
                    + "Target driver=" + getTargetDriverName() + "\n"
                    + "Target URL=" + getTargetDataBase() + "\n"
                    + "Target user=" + getTargetUser() + "\n"
                    + "Target password=" + getTargetPassword() + "\n"
                    + "Conf file in jar=" + getConfJarStructure() + "\n"
                    + "Doml path=" + getDomlPath()+ "\n"
                    + "Ouput directory=" + getGeneratorOutput() + "\n"
                    + "Include table list=" + getIncludeTableList() + "\n"
                    + "Restore mode=" + getRestoreMode()+ "\n"
                    + "Value mode="+ getValueMode()+ "\n"
                    + "Generate create foreign keys ="+ getGenerateCreateFKStmt()+ "\n"
                    + "Generate create indexes ="+ getGenerateCreateIndexStmt()+ "\n"
                    + "Generate create primary keys ="+ getGenerateCreatePKStmt()+ "\n"
                    + "Generate create tables ="+ getGenerateCreateTableStmt()+ "\n"
                    + "Generate drop foreign keys ="+ getGenerateDropIntegrityStmt()+ "\n"
                    + "Generate drop tables ="+ getGenerateDropTableStmt()+ "\n"
                    + "Generate sql for all vendors ="+ getGenerateSqlForAllVendors()+ "\n"
                    + "Generate doml ="+ getGenerateDoml()+ "\n"
                    + "Package name="+ getPackageName()+ "\n"
                    + "Generate xml ="+ getGenerateXml()+ "\n"
                    + "Full mode=" + getFullMode() + "\n"
										+ "Log mode=" + getLogMode() + "\n"
										+ "Log directory name=" + getStrLogDirName() + "\n"
										+ "Log file name=" + getStrLogFileName() + "\n";

            return resString;
        } catch (Exception e) {
            throw new LoaderException("Exception:" + e.getMessage(), e);
        }
    }

    /**
     * Construct object LoaderGenerator with associated parameters.
     * @param sourceType defines the type of the source data.
     * @param targetType defines the type of the target data.
     * @param sourceDriverName is driver of defined source database.
     * @param targetDriverName is driver of defined  target database.
     * @param sourceDataBase defines the place where you're put the database tables.
     * @param targetDataBase defines the place where the target database tables are.
     * @param valueMode defines the difference from overwrite and update attribute.
     * Default valueMode is Overwrite.
     * @param generatorOutput is optional. That represents the directory, where the
     * Octopus place created files. If this argument don't exists, Octopus place
     * created files in to current directory!
     * @param sourceUser defines the user of the source database.
     * @param sourcePassword defines user password for the source database.
     * @param targetUser defines the user of the target database.
     * @param targetPassword defines user password for the target database.
     * @param domlPath defines if the doml file exists. Default value is false
     * all, application generates xml, sql and doml files as ouput files. If the generateDoc has value
     * doml, application generates only the doml file, and if generateDoc has the value wdoml, application
     * generates xml and sql files.
     * @param packageName defines the package name for the generated doml file.
     * @param generateDropTableStmt defines if you want to generate only Sql statement for DROP TABLE
     * @param generateCreateTableStmt defines if you want to generate only Sql statement for CREATE TABLE
     * @param generateCreatePKStmt defines if you want to generate only Sql statement for ALTER TABLE
     * @param generateCreateFKStmt defines if you want to generate only Sql statement for ALTER TABLE
     * @param generateCreateIndexStmt defines if you want to generate only Sql statement for ALTER TABLE
     * @param generateSqlForAllVendors defines if you want to generate Sql statements for all named
     * database vendors
     * @param generateXml defines if you want to generate xml file as output files
     * @param generateDoml defines if you want to generate doml file as output file
     * @param fullMode defines in which mode you want to generate xml files.
     * @param includeTableList defines the list of tables which you want to include into
     * Generator process
     * @param confJarStructure defines the structure of jar file in which are conf
     * files placed
     * @throws LoaderException
     */

    public LoaderGenerator(String sourceType, String sourceDataBase, 
												    String valueMode, String generatorOutput, String sourceDriverName, 
												    String targetDriverName, String targetDataBase, String targetType, 
												    String sourceUser, String sourcePassword, String targetUser, 
												    String targetPassword, String domlPath, String packageName, String generateDropTableStmt, 
												    String generateDropIntegrityStmt, String generateCreateTableStmt, String generateCreatePKStmt, 
												    String generateCreateFKStmt, String generateCreateIndexStmt, String generateSqlForAllVendors, 
												    String generateXml, String generateDoml, String fullMode, String includeTableList, 
												    String confJarStructure) 
												    throws LoaderException {

        this(sourceType, sourceDataBase, valueMode, generatorOutput, 
        sourceDriverName, targetDriverName, targetDataBase, targetType, 
        sourceUser, sourcePassword, targetUser, targetPassword, domlPath, 
        packageName, generateDropTableStmt, generateDropIntegrityStmt, 
        generateCreateTableStmt, generateCreatePKStmt, generateCreateFKStmt, 
        generateCreateIndexStmt, generateSqlForAllVendors, generateXml, generateDoml, 
        fullMode, "false", includeTableList, confJarStructure);

    }

    /**
     * Construct object LoaderGenerator with associated parameters.
     * @param sourceType defines the type of the source data.
     * @param targetType defines the type of the target data.
     * @param sourceDriverName is driver of defined source database.
     * @param targetDriverName is driver of defined  target database.
     * @param sourceDataBase defines the place where you're put the database tables.
     * @param targetDataBase defines the place where the target database tables are.
     * @param valueMode defines the difference from overwrite and update attribute.
     * Default valueMode is Overwrite.
     * @param generatorOutput is optional. That represents the directory, where the
     * Octopus place created files. If this argument don't exists, Octopus place
     * created files in to current directory!
     * @param sourceUser defines the user of the source database.
     * @param sourcePassword defines user password for the source database.
     * @param targetUser defines the user of the target database.
     * @param targetPassword defines user password for the target database.
     * @param domlPath defines if the doml file exists. Default value is false
     * all, application generates xml, sql and doml files as ouput files. If the generateDoc has value
     * doml, application generates only the doml file, and if generateDoc has the value wdoml, application
     * generates xml and sql files.
     * @param packageName defines the package name for the generated doml file.
     * @param generateDropTableStmt defines if you want to generate only Sql statement for DROP TABLE
     * @param generateCreateTableStmt defines if you want to generate only Sql statement for CREATE TABLE
     * @param generateCreatePKStmt defines if you want to generate only Sql statement for ALTER TABLE
     * @param generateCreateFKStmt defines if you want to generate only Sql statement for ALTER TABLE
     * @param generateCreateIndexStmt defines if you want to generate only Sql statement for ALTER TABLE
     * @param generateSqlForAllVendors defines if you want to generate Sql statements for all named
     * database vendors
     * @param generateXml defines if you want to generate xml file as output files
     * @param generateDoml defines if you want to generate doml file as output file
     * @param fullMode defines in which mode you want to generate xml files.
     * @param restoreMode defines if we use application for restoring the database
     * @param includeTableList defines the list of tables which you want to include into
     * Generator process
     * @param confJarStructure defines the structure of jar file in which are conf files
     * placed.
     * @throws LoaderException
     */

    public LoaderGenerator(String sourceType, String sourceDataBase, String valueMode, 
												    String generatorOutput, String sourceDriverName, String targetDriverName, 
												    String targetDataBase, String targetType, String sourceUser, String sourcePassword, 
												    String targetUser, String targetPassword, String domlPath, String packageName, 
												    String generateDropTableStmt, String generateDropIntegrityStmt, String generateCreateTableStmt, 
												    String generateCreatePKStmt, String generateCreateFKStmt, String generateCreateIndexStmt, 
												    String generateSqlForAllVendors, String generateXml, String generateDoml, String fullMode, 
												    String restoreMode, String includeTableList, String confJarStructure) 
												    throws LoaderException {

        generatorParameters = new InputParameters(confJarStructure);
        generatorParameters.setConfJarStructure(confJarStructure);

        generatorParameters.setSourceType(sourceType);
        //target and source driver name must goes frist, because alterTablePrimaryKey...
        generatorParameters.setTargetDriverName(targetDriverName);
        generatorParameters.setSourceDriverName(sourceDriverName);
        generatorParameters.setTargetType(targetType);
        generatorParameters.setSourceDataBase(sourceDataBase);