Application: gvSIG desktop

/* gvSIG. Sistema de Informaci?n Geogr?fica de la Generalitat Valenciana

 *

 * Copyright (C) 2006 Prodevelop and Generalitat Valenciana.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 2

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307,USA.

 *

 * For more information, contact:

 *

 *   Generalitat Valenciana

 *   Conselleria d'Infraestructures i Transport

 *   Av. Blasco Ib??ez, 50

 *   46010 VALENCIA

 *   SPAIN

 *

 *   +34 963862235

 *   gvsig@gva.es

 *   www.gvsig.gva.es

 *

 *    or

 *

 *   Prodevelop Integraci?n de Tecnolog?as SL

 *   Conde Salvatierra de ?lava , 34-10

 *   46004 Valencia

 *   Spain

 *

 *   +34 963 510 612

 *   +34 963 510 968

 *   gis@prodevelop.es

 *   http://www.prodevelop.es

 */

package org.gvsig.oracle.extension;

import javax.swing.ImageIcon;

import org.gvsig.andami.PluginServices;

import org.gvsig.andami.plugins.Extension;

import org.gvsig.andami.ui.mdiManager.IWindow;

import org.gvsig.andami.ui.wizard.WizardAndami;

import org.gvsig.app.extension.About;

import org.gvsig.app.project.documents.view.gui.View;

import org.gvsig.fmap.dal.store.oracle.OracleLibrary;

import org.gvsig.fmap.mapcontext.MapContext;

import org.gvsig.fmap.mapcontext.layers.FLayer;

import org.gvsig.fmap.mapcontext.layers.vectorial.FLyrVect;

import org.gvsig.fmap.mapcontrol.MapControl;

import org.gvsig.oracle.gui.NewOracleTableWizard;

import org.gvsig.oracle.gui.RepeatedChooseGeometryTypePanel;

import org.gvsig.oracle.gui.RepeatedFieldDefinitionPanel;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

/**

 * This extension adds the export-to-oracle button.

 * 

 * @author jldominguez, vsanjaime

 * 

 */

public class ExportOracleExtension extends Extension {

        private static Logger logger = LoggerFactory

                        .getLogger(ExportOracleExtension.class);

        public static boolean ORACLE_JAR_PRESENT = false;

        private OracleLibrary oracleSpatialLibrary = null;

        /**

         * initialize

         */

        public void initialize() {

                ORACLE_JAR_PRESENT = isOracleJarPresent();

                if (!ORACLE_JAR_PRESENT) {

                        logger

                                        .info("*-----------------------------------------------------------------------*");

                        logger

                                        .info("* Oracle library not found!                                             *");

                        logger

                                        .info("* You need to place the Oracle JDBC library in gvSIG's main LIB folder. *");

                        logger

                                        .info("* Read the Oracle driver user manual for details.                       *");

                        logger

                                        .info("*-----------------------------------------------------------------------*");

                } else {

                        logger

                                        .info("*-----------------------------------------------------------------------*");

                        logger

                                        .info("* Found the Oracle JDBC library! :)                                     *");

                        logger

                                        .info("*-----------------------------------------------------------------------*");

                }

                // about

                java.net.URL newurl = createResourceUrl("about/jdbc-os-about.html");

                About claseAbout = (About) PluginServices

                                .getExtension(About.class);

                claseAbout.getAboutPanel().addAboutUrl("JDBC Oracle Spatial", newurl);

                oracleSpatialLibrary = new OracleLibrary();

                oracleSpatialLibrary.initialize();

        }

        /**

         * Post initialize extension

         */

        public void postInitialize() {

                // postinitialize library

                oracleSpatialLibrary.postInitialize();

        }

        /**

         * execute extension

         */

        public void execute(String actionCommand) {

                if (actionCommand.compareToIgnoreCase("EXPORT_TO_ORACLE_SPATIAL") == 0) {

                        FLyrVect lyrv = null;

                        MapContext mx = null;

                        try {

                                IWindow w = PluginServices.getMDIManager().getActiveWindow();

                                if (w instanceof View) {

                                        View v = (View) w;

                                        MapControl mc = v.getMapControl();

                                        mx = mc.getMapContext();

                                        FLayer[] lyrs = mx.getLayers().getActives();

                                        if (lyrs.length == 1) {

                                                FLayer lyr = lyrs[0];

                                                if (lyr instanceof FLyrVect) {

                                                        lyrv = (FLyrVect) lyr;

                                                        ExportToOracle export = new ExportToOracle();

                                                        export.toOracle(mx, lyrv);

                                                }

                                        }

                                }

                        } catch (Exception ex) {

                                logger

                                                .error("Unexpected error while getting active vect layer: "

                                                                + ex.getMessage());

                                logger.error("Nothing done.");

                        }

                }

                if (actionCommand.compareToIgnoreCase("NEW_ORACLE_SPATIAL") == 0) {

                        IWindow w = PluginServices.getMDIManager().getActiveWindow();

                        if (w instanceof View) {

                                try {

                                        String _file = createResourceUrl(

                                                        "images/new_geodb_table.png").getFile();

                                        ImageIcon iicon = new ImageIcon(_file);

                                        WizardAndami wizard = new WizardAndami(iicon);

                                        RepeatedChooseGeometryTypePanel panelChoose = new RepeatedChooseGeometryTypePanel(

                                                        wizard.getWizardComponents());

                                        RepeatedFieldDefinitionPanel panelFields = new RepeatedFieldDefinitionPanel(

                                                        wizard.getWizardComponents());

                                        NewOracleTableWizard connPanel = new NewOracleTableWizard(

                                                        wizard.getWizardComponents());

                                        wizard.getWizardComponents().addWizardPanel(panelChoose);

                                        wizard.getWizardComponents().addWizardPanel(panelFields);

                                        wizard.getWizardComponents().addWizardPanel(connPanel);

                                        View theView = (View) w;

                                        MapContext mc = theView.getMapControl().getMapContext();

                                        NewOracleTableFinishAction action = new NewOracleTableFinishAction(

                                                        wizard.getWizardComponents(), wizard, connPanel, mc);

                                        wizard.getWizardComponents().setFinishAction(action);

                                        wizard.getWizardComponents().getFinishButton().setEnabled(

                                                        false);

                                        wizard.getWindowInfo().setWidth(640);

                                        wizard.getWindowInfo().setHeight(350);

                                        wizard.getWindowInfo().setTitle(

                                                        PluginServices.getText(this, "new_layer"));

                                        PluginServices.getMDIManager().addWindow(wizard);

                                } catch (Exception ex) {

                                        logger

                                                        .error("While showing new oracle spatial table wizard: "

                                                                        + ex.getMessage());

                                }

                        }

                }

        }

        /**

         * 

         */

        public boolean isEnabled() {

                return isVisible();

        }

        /**

         * Is visible when there is one vector layer selected

         */

        public boolean isVisible() {

                if (!ORACLE_JAR_PRESENT) {

                        return false;

                }

                try {

                        IWindow w = PluginServices.getMDIManager().getActiveWindow();

                        if (w instanceof View) {

                                View v = (View) w;

                                MapControl mc = v.getMapControl();

                                MapContext mx = mc.getMapContext();

                                FLayer[] lyrs = mx.getLayers().getActives();

                                if (lyrs.length == 1) {

                                        FLayer lyr = lyrs[0];

                                        if ((lyr instanceof FLyrVect) && (true)) {

                                                return true;

                                        }

                                }

                        }

                } catch (Exception ex) {

                        return false;

                }

                return false;

        }

        /**

         * Create resource url

         * 

         * @param path

         * @return

         */

        private java.net.URL createResourceUrl(String path) {

                return getClass().getClassLoader().getResource(path);

        }

        /**

         * Is there a Oracle jar present

         * 

         * @return

         */

        private boolean isOracleJarPresent() {

                try {

                        Class rowid_class = Class.forName("oracle.sql.ROWID");

                } catch (Exception ex) {

                        logger.error("Unable to instantiate ROWID (oracle jar missing?) : "

                                        + ex.getMessage());

                        return false;

                }

                return true;

        }

}