loadergenerator.java

数据仓库工具

        generatorParameters.setTargetDataBase(targetDataBase);
        generatorParameters.setValueMode(valueMode);
        generatorParameters.setGeneratorOutput(generatorOutput);
        generatorParameters.setSourceUser(sourceUser);
        generatorParameters.setSourcePassword(sourcePassword);
        generatorParameters.setTargetUser(targetUser);
        generatorParameters.setTargetPassword(targetPassword);

        if (generateDropTableStmt != null)
            generatorParameters.setSqlStmtDropTable(generateDropTableStmt);
        if (generateDropIntegrityStmt != null)
            generatorParameters.setSqlStmtDropIntegrity(generateDropIntegrityStmt);
        if (generateCreateTableStmt != null)
            generatorParameters.setSqlStmtCreateTable(generateCreateTableStmt);
        if (generateCreatePKStmt != null)
            generatorParameters.setSqlStmtCreatePK(generateCreatePKStmt);
        if (generateCreateFKStmt != null)
            generatorParameters.setSqlStmtCreateFK(generateCreateFKStmt);
        if (generateCreateIndexStmt != null)
            generatorParameters.setSqlStmtCreateIndex(generateCreateIndexStmt);
        if (generateSqlForAllVendors != null)
            generatorParameters.setAllVendors(generateSqlForAllVendors);

        generatorParameters.setDomlPath(domlPath);
        if (generateXml != null)
            generatorParameters.setGenerateXml(generateXml);
        if (generateDoml != null)
            generatorParameters.setGenerateDoml(generateDoml);
        generatorParameters.setPackageName(packageName);
        if (fullMode != null)
            generatorParameters.setFullMode(fullMode);
        if (restoreMode != null)
            generatorParameters.setRestoreMode(restoreMode);
        if (includeTableList != null)
            generatorParameters.setIncludeTableList(includeTableList);

        generatorParameters.setSourceDriverProperties();
        generatorParameters.setTargetDriverProperties();
        generatorParameters.setOidAndVersionColumnName();
        generatorParameters.setHasSize();
        generatorParameters.setIsDecimal();
        //setLogger();

    }

    /**
    	 * 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
    	 * @param logMode defines logging level
    	 * @param logDirName defines logging directory
    	 * @param logFileName defines logging file name
    	 * 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, String logMode, String logDirName, 
												    String logFileName) 
												    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);
        generatorParameters.setTargetDataBase(targetDataBase);
        generatorParameters.setValueMode(valueMode);
        generatorParameters.setGeneratorOutput(generatorOutput);
        generatorParameters.setSourceUser(sourceUser);
        generatorParameters.setSourcePassword(sourcePassword);
        generatorParameters.setTargetUser(targetUser);
        generatorParameters.setTargetPassword(targetPassword);

        if (generateDropTableStmt != null)
            generatorParameters.setSqlStmtDropTable(generateDropTableStmt);
        if (generateDropIntegrityStmt != null)
            generatorParameters.setSqlStmtDropIntegrity(generateDropIntegrityStmt);
        if (generateCreateTableStmt != null)
            generatorParameters.setSqlStmtCreateTable(generateCreateTableStmt);
        if (generateCreatePKStmt != null)
            generatorParameters.setSqlStmtCreatePK(generateCreatePKStmt);
        if (generateCreateFKStmt != null)
            generatorParameters.setSqlStmtCreateFK(generateCreateFKStmt);
        if (generateCreateIndexStmt != null)
            generatorParameters.setSqlStmtCreateIndex(generateCreateIndexStmt);
        if (generateSqlForAllVendors != null)
            generatorParameters.setAllVendors(generateSqlForAllVendors);

        generatorParameters.setDomlPath(domlPath);
        if (generateXml != null)
            generatorParameters.setGenerateXml(generateXml);
        if (generateDoml != null)
            generatorParameters.setGenerateDoml(generateDoml);
        generatorParameters.setPackageName(packageName);
        if (fullMode != null)
            generatorParameters.setFullMode(fullMode);
        if (restoreMode != null)
            generatorParameters.setRestoreMode(restoreMode);
        if (includeTableList != null)
            generatorParameters.setIncludeTableList(includeTableList);
        if (logMode != null) {
            this.logMode = logMode;
        }
        if (logDirName != null) {
            this.strLogDirName = logDirName;
        }
        if (logFileName != null) {
            this.strLogFileName = logFileName;
        }
        generatorParameters.setSourceDriverProperties();
        generatorParameters.setTargetDriverProperties();
        generatorParameters.setOidAndVersionColumnName();
        generatorParameters.setHasSize();
        generatorParameters.setIsDecimal();

    }

    /**
     * Public constructor of LoaderGenerator class. Constructor set value for sourceDataBase and
     * targetDataBase attribute. Class set all other attributes to the default values.
     * @param sourceDataBase defines the place where you're put the database tables.
     * @param targetDataBase defines the place where the target database tables are.
     * @param sourceType defines the type of the source database.
     * @param targetType defines the type of the target database.
     * @throws LoaderException
     */
    public LoaderGenerator(String sourceDataBase, String targetDataBase, String sourceType, 
    												String targetType) throws LoaderException {

        this(sourceDataBase, targetDataBase, sourceType, targetType, null);

    }

    /**
    * Public constructor of LoaderGenerator class. Constructor set value for sourceDataBase and
    * targetDataBase attribute. Class set all other attributes to the default values.
    * @param sourceDataBase defines the place where you're put the database tables.
    * @param targetDataBase defines the place where the target database tables are.
    * @param sourceType defines the type of the source database.
    * @param targetType defines the type of the target database.
    * @throws LoaderException
    */
    public LoaderGenerator(String sourceDataBase, String targetDataBase, String sourceType, 
    											String targetType, String confJarStructure) throws LoaderException {

        generatorParameters = new InputParameters("");
        generatorParameters.setConfJarStructure(confJarStructure);
        generatorParameters.setSourceDataBase(sourceDataBase);

        generatorParameters.setTargetDataBase(targetDataBase);
        generatorParameters.setSourceType(sourceType);
        generatorParameters.setTargetType(targetType);
        generatorParameters.setSourceDriverProperties();
        generatorParameters.setTargetDriverProperties();
        generatorParameters.setOidAndVersionColumnName();
        generatorParameters.setHasSize();
        generatorParameters.setIsDecimal();
        //setLogger();
    }

    /**
     * Main method controls parameters, it they are OK starts load method, but if they aren't makes alert.
     * @param args represents the input parameters
     *
     * Usage: java org.webdocwf.util.loader.generator.Generator [options]
     * Options:
     * -st sourceType, defines the type of the source database.
     * -tt targetType, defines the type of the target database.
     * -sdn sourceDriverName, defines the driver of defined source database.
     * -tdn targetDriverName, defines the driver of defined  target database.
     * -sdb sourceDataBase, defines the place where you're put the source database tables.
     * -tdb targetDataBase, defines the place where you're put the target database tables.
     * -m valueMode, defines the difference from overwrite and update attribute. If the valueMode
     * has value 'copy', attribute has value 'Overwrite', or if the valueMode has value 'sync', attribute
     * has value 'Update'. Default value of valueMode is 'copy'.
     * -o generatorOutput, is optional. That represent the directory, where the Octopus place created files.
     * If this argument don't exists, Octopus place created files in to current directory!
     * -su sourceUser, defines the user of the source database.
     * -sp sourcePassword, defines the user password for the source database.
     * -tu targetUser, defines the user of the target database.
     * -tp targetPassword, defines the user password for the target database.
     * -doml domlUrl, defines the place where the doml file is placed.
     * -pack packageName, defines the package name for the generated doml file.
     * -xml -xml generateXml, defines if you want to generate xml files as output files
     * -gdoml generateDoml, defines if you want to generate doml file as output file.
     * -sqlCT generateCreateTables defines if you want to generate only Sql statement for CREATE TABLE.
     * -sqlDT generateDropTableStmt defines if you want to generate only Sql statement for DROP TABLE.
     * -sqlCPK generateCreatePrimaryKeys defines if you want to generate only Sql statement for ALTER TABLE ADD CONSTRAINT (PRIMARY KEY).
     * -sqlCFK generateCreateForeigKeys defines if you want to generate only Sql statement for ALTER TABLE ADD CONSTRAINT (FOREIGN KEY).
     * -sqlCI generateCreateIndex defines if you want to generate only Sql statement for CREATE INDEX.
     * -sqlAll generateSqlForAllVendors defines if you want to generate sql statements for all named database vendors.
     * -fm fullMode defines the mode of output xml files. Possible values are true and false.
     * -lm logMode defines logging level
     * -l logDirName defines logging directory
     * -f logFileName defines logging file name
     **/

    public static void main(String args[]) {

        String generatorOutput = null;
        String valueMode = null;
        String domlUrl = null;
        String packageName = null;

        String sourceType = null;
        String sourceDataBase = null;
        String sourceDriverName = null;
        String sourceUser = null;
        String sourcePassword = null;

        String targetType = null;
        String targetDataBase = null;
        String targetDriverName = null;
        String targetUser = null;
        String targetPassword = null;

        //logging
        String logDirName = null;
        String logFileName = null;