org.plasma.provisioning.cli.RDBReader Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of plasma-sdo Show documentation
The Plasma SDO Module
There is a newer version: 1.3.3
package org.plasma.provisioning.cli;

import java.io.InputStream;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.modeldriven.fuml.Fuml;
import org.modeldriven.fuml.io.ResourceArtifact;
import org.plasma.config.NamespaceProvisioning;
import org.plasma.config.PlasmaConfig;
import org.plasma.metamodel.Model;
import org.plasma.provisioning.ProvisioningException;
import org.plasma.provisioning.SchemaConverter;
import org.plasma.provisioning.rdb.MySql55Converter;
import org.plasma.provisioning.rdb.MySqlVersion;
import org.plasma.provisioning.rdb.MySqlVersionFinder;
import org.plasma.provisioning.rdb.Oracle11GConverter;
import org.plasma.provisioning.rdb.OracleVersion;
import org.plasma.provisioning.rdb.OracleVersionFinder;
import org.plasma.provisioning.rdb.RDBConstants;
import org.plasma.sdo.repository.fuml.FumlRepository;

public class RDBReader implements RDBConstants {
    private static Log log =LogFactory.getLog(
			   RDBReader.class); 

	public Model read(RDBDialect dialect, String[] schemaNames, String[] namespaces) {
		
    	FumlRepository.getInstance(); // just force an init    	
       	
        // convert the schemas
        Model model = null;
    	switch (dialect) {
    	case oracle: 
    		loadDynamicArtifact(RDBConstants.ARTIFACT_RESOURCE_ORACLE);
    		loadDynamicNamespace(ARTIFACT_NAMESPACE_ORACLE_ANY_SYS,
    			org.plasma.provisioning.rdb.oracle.any.sys.Version.class.getPackage(),
    			RDBConstants.ARTIFACT_RESOURCE_ORACLE);
    		OracleVersionFinder versionFinder = new OracleVersionFinder();
    		OracleVersion version = versionFinder.findVersion();
    		log.info("detected version '" + version + "'");
    		SchemaConverter converter = null;
    		switch (version) {
    		case _9i:
    		case _10g:
    		case _11g:
        		loadDynamicNamespace(ARTIFACT_NAMESPACE_ORACLE_11G_SYS,
        			org.plasma.provisioning.rdb.oracle.g11.sys.Version.class.getPackage(),
        			RDBConstants.ARTIFACT_RESOURCE_ORACLE);
        		converter = new Oracle11GConverter(
        			schemaNames, namespaces);
        		break;
    		case _unknown:
    		default:
    			log.warn("unknown Oracle version - using 11g metamodel");
        		loadDynamicNamespace(ARTIFACT_NAMESPACE_ORACLE_11G_SYS,
        			org.plasma.provisioning.rdb.oracle.g11.sys.Version.class.getPackage(),
        			RDBConstants.ARTIFACT_RESOURCE_ORACLE);
        		converter = new Oracle11GConverter(
            			schemaNames, namespaces);
        		break;
    		}
    		
    		model = converter.buildModel(); 
    	    break;
    	case mysql:  
    		loadDynamicArtifact(RDBConstants.ARTIFACT_RESOURCE_MYSQL);
    		loadDynamicNamespace(ARTIFACT_NAMESPACE_MYSQL_ANY,
    			org.plasma.provisioning.rdb.mysql.any.GlobalVariable.class.getPackage(),
    			RDBConstants.ARTIFACT_RESOURCE_MYSQL);
    		MySqlVersionFinder mysqlVersionFinder = new MySqlVersionFinder();
    		MySqlVersion mysqlVersion = mysqlVersionFinder.findVersion();
    		log.info("detected version '" + mysqlVersion + "'");
    		converter = null;
    		switch (mysqlVersion) {
    		case _5_5:
        		loadDynamicNamespace(ARTIFACT_NAMESPACE_MYSQL_5_5,
        			org.plasma.provisioning.rdb.mysql.v5_5.GlobalVariable.class.getPackage(),
        			RDBConstants.ARTIFACT_RESOURCE_MYSQL);
        		converter = new MySql55Converter(
        	 	    schemaNames, namespaces);
        		break;
    		case _unknown:
    		default:
    			log.warn("unknown MySql version - using 5.5 metamodel");
        		loadDynamicNamespace(ARTIFACT_NAMESPACE_MYSQL_5_5,
        			org.plasma.provisioning.rdb.mysql.v5_5.GlobalVariable.class.getPackage(),
        			RDBConstants.ARTIFACT_RESOURCE_MYSQL);
        		converter = new MySql55Converter(
            			schemaNames, namespaces);
        		break;
    		}
    		
    		model = converter.buildModel(); 
    	    break;
    	default:
    		throw new ProvisioningException("unknown dialect, '"
    				+ dialect.name() + "'");
    	}
	    
	    return model;
	}

    /**
     * Dynamically loads the vendor metamodel for the given
     * namespace and provisioning package adding
     * a dynamic SDO namespace.
     * @param namespace the SDO namespace URI
     * @param pkg the provisioning package
     */
    private static void loadDynamicNamespace(String namespace, 
    		java.lang.Package pkg, String artifactResourceName) {
    		
    	NamespaceProvisioning provisioning = new NamespaceProvisioning();
    	provisioning.setPackageName(pkg.getName());
    	
        PlasmaConfig.getInstance().addDynamicSDONamespace(
        		namespace, 
        		artifactResourceName,
        		provisioning);
    }
    
    private static void loadDynamicArtifact(String artifactResourceName) {
    	InputStream stream = UMLTool.class.getClassLoader().getResourceAsStream(
    			artifactResourceName);
    	
	    if (log.isDebugEnabled())
	    	log.info("loading UML/XMI model");
        Fuml.load(new ResourceArtifact(
        	artifactResourceName, 
        	artifactResourceName, 
        	stream));              	        		    	
    }

}