Application: gvSIG desktop

/* gvSIG. Geographic Information System of the Valencian Government

*

* Copyright (C) 2007-2008 Infrastructures and Transports Department

* of the Valencian Government (CIT)

*

* 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., 51 Franklin Street, Fifth Floor, Boston,

* MA  02110-1301, USA.

*

*/

/*

* AUTHORS (In addition to CIT):

* 2009 IVER T.I   {{Task}}

*/

/**

 *

 */

package org.gvsig.fmap.dal.store.mysql;

import java.sql.Connection;

import java.sql.SQLException;

import java.sql.Statement;

import org.gvsig.fmap.dal.DataStoreParameters;

import org.gvsig.fmap.dal.NewDataStoreParameters;

import org.gvsig.fmap.dal.exception.DataException;

import org.gvsig.fmap.dal.exception.InitializeException;

import org.gvsig.fmap.dal.exception.ProviderNotRegisteredException;

import org.gvsig.fmap.dal.exception.RemoveException;

import org.gvsig.fmap.dal.spi.DataServerExplorerProviderServices;

import org.gvsig.fmap.dal.store.jdbc.JDBCHelper;

import org.gvsig.fmap.dal.store.jdbc.JDBCServerExplorer;

import org.gvsig.fmap.dal.store.jdbc.JDBCStoreParameters;

import org.gvsig.fmap.dal.store.jdbc.TransactionalAction;

import org.gvsig.fmap.dal.store.jdbc.exception.JDBCExecuteSQLException;

import org.gvsig.fmap.dal.store.jdbc.exception.JDBCSQLException;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

/**

 * @author jmvivo

 *

 */

public class MySQLServerExplorer extends JDBCServerExplorer {

        final static private Logger logger = LoggerFactory

                        .getLogger(MySQLServerExplorer.class);

        public static final String NAME = "MySQLExplorer";

        public MySQLServerExplorer(

                        MySQLServerExplorerParameters parameters,

                        DataServerExplorerProviderServices services)

                        throws InitializeException {

                super(parameters, services);

        }

        private MySQLServerExplorerParameters getMySQLparameters() {

                return (MySQLServerExplorerParameters) super.getParameters();

        }

        protected JDBCHelper createHelper() throws InitializeException {

                return new MySQLHelper(this, getMySQLparameters());

        }

        protected String getStoreName() {

                return MySQLStoreProvider.NAME;

        }

        public String getProviderName() {

                return NAME;

        }

        protected JDBCStoreParameters createStoreParams()

                        throws InitializeException, ProviderNotRegisteredException {

                MySQLStoreParameters orgParams = (MySQLStoreParameters) super

                                .createStoreParams();

                orgParams.setUseSSL(getMySQLparameters().getUseSSL());

                return orgParams;

        }

        // ****************************

        public boolean canAdd() {

                return true;

        }

        protected void checkIsMine(DataStoreParameters dsp) {

                if (!(dsp instanceof MySQLStoreParameters)) {

                        // FIXME Excpetion ???

                        throw new IllegalArgumentException(

                                        "not instance of MySQLStoreParameters");

                }

                super.checkIsMine(dsp);

                MySQLServerExplorerParameters myParameters = getMySQLparameters();

                MySQLStoreParameters myp = (MySQLStoreParameters) dsp;

                if (myp.getUseSSL().booleanValue() != myParameters.getUseSSL()) {

                        throw new IllegalArgumentException("worng explorer: useSSL (mine:"

                                        + myParameters.getUseSSL() + " other:" + myp.getUseSSL()

                                        + ")");

                }

        }

        public void remove(DataStoreParameters dsp) throws RemoveException {

                final MySQLStoreParameters myParams =(MySQLStoreParameters) dsp;

                TransactionalAction action = new TransactionalAction() {

                        public boolean continueTransactionAllowed() {

                                return false;

                        }

                        public Object action(Connection conn) throws DataException {

                                Statement st;

                                try{

                                        st = conn.createStatement();

                                } catch (SQLException e) {

                                        throw new JDBCSQLException(e);

                                }

                                String sqlDrop = "Drop table "

                                        + myParams.tableID();

                                try{

                                        try{

                                                st.execute(sqlDrop);

                                        } catch (SQLException e) {

                                                throw new JDBCExecuteSQLException(sqlDrop, e);

                                        }

                                } finally{

                                        try{ st.close(); } catch (SQLException e) {};

                                }

                                return null;

                        }

                };

                try {

                        this.helper.doConnectionAction(action);

                } catch (Exception e) {

                        throw new RemoveException(this.getProviderName(), e);

                }

        }

        public NewDataStoreParameters getAddParameters() throws DataException {

                MySQLServerExplorerParameters parameters = getMySQLparameters();

                MySQLNewStoreParameters params = new MySQLNewStoreParameters();

                params.setHost(parameters.getHost());

                params.setPort(parameters.getPort());

                params.setDBName(parameters.getDBName());

                params.setUser(parameters.getUser());

                params.setPassword(parameters.getPassword());

                params.setCatalog(parameters.getCatalog());

                params.setSchema(parameters.getSchema());

                params.setJDBCDriverClassName(parameters.getJDBCDriverClassName());

                params.setUrl(parameters.getUrl());

                params.setUseSSL(parameters.getUseSSL());

                params.setDefaultFeatureType(this.getServerExplorerProviderServices()

                                .createNewFeatureType());

                return params;

        }

        // ***********************

        // ***********************

        public boolean hasGeometrySupport() {

                return true;

        }

        protected MySQLHelper getMyHelper() {

                return (MySQLHelper) getHelper();

        }

}