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.oraclespatial;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.ArrayList;

import java.util.Iterator;

import java.util.List;

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.ReadException;

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

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

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

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 vsanjaime

 *

 */

public class OracleSpatialServerExplorer extends JDBCServerExplorer {

        final static private Logger logger = LoggerFactory

                        .getLogger(OracleSpatialServerExplorer.class);

        public static final String NAME = "OracleSpatialExplorer";

        public OracleSpatialServerExplorer(

                        OracleSpatialServerExplorerParameters parameters,

                        DataServerExplorerProviderServices services)

                        throws InitializeException {

                super(parameters, services);

        }

        private OracleSpatialServerExplorerParameters getOracleSpatialParameters() {

                return (OracleSpatialServerExplorerParameters) getParameters();

        }

        protected JDBCHelper createHelper() throws InitializeException {

                return new OracleSpatialHelper(this, getOracleSpatialParameters());

        }

        protected String getStoreName() {

                return OracleSpatialStoreProvider.NAME;

        }

        public String getName() {

                return NAME;

        }

        protected JDBCStoreParameters createStoreParams()

                        throws InitializeException, ProviderNotRegisteredException {

                OracleSpatialStoreParameters orgParams = (OracleSpatialStoreParameters) super

                                .createStoreParams();

                orgParams.setUseSSL(getOracleSpatialParameters().getUseSSL());

                return orgParams;

        }

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

        public boolean canAdd() {

                return true;

        }

        /**

         *

         */

        protected void checkIsMine(DataStoreParameters dsp) {

                if (!(dsp instanceof OracleSpatialStoreParameters)) {

                        // FIXME Excpetion ???

                        throw new IllegalArgumentException(

                                        "not instance of OracleSpatialStoreParameters");

                }

                super.checkIsMine(dsp);

                OracleSpatialStoreParameters orap = (OracleSpatialStoreParameters) dsp;

                if (orap.getUseSSL().booleanValue() != getOracleSpatialParameters()

                                .getUseSSL()) {

                        throw new IllegalArgumentException("worng explorer: Host");

                }

        }

        /**

         *

         */

        public void remove(DataStoreParameters dsp) throws RemoveException {

                final OracleSpatialStoreParameters osParams = (OracleSpatialStoreParameters) 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 " + osParams.tableID();

                                StringBuilder strb = new StringBuilder();

                                strb

                                                .append("Delete from GEOMETRY_COLUMNS where f_table_schema = ");

                                if (osParams.getSchema() == null

                                                || osParams.getSchema().length() == 0) {

                                        strb.append("current_schema() ");

                                } else {

                                        strb.append('\'');

                                        strb.append(osParams.getSchema());

                                        strb.append("' ");

                                }

                                strb.append("and f_table_name = '");

                                strb.append(osParams.getTable());

                                strb.append('\'');

                                String sqlDeleteFromGeometry_column = strb.toString();

                                try {

                                        try {

                                                st.execute(sqlDrop);

                                        } catch (SQLException e) {

                                                throw new JDBCExecuteSQLException(sqlDrop, e);

                                        }

                                        try {

                                                st.execute(sqlDeleteFromGeometry_column);

                                        } catch (SQLException e) {

                                                throw new JDBCExecuteSQLException(

                                                                sqlDeleteFromGeometry_column, e);

                                        }

                                } finally {

                                        try {

                                                st.close();

                                        } catch (SQLException e) {

                                        }

                                        ;

                                }

                                return null;

                        }

                };

                try {

                        this.helper.doConnectionAction(action);

                } catch (Exception e) {

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

                }

        }

        /**

         *

         */

        public NewDataStoreParameters getAddParameters() throws DataException {

                OracleSpatialServerExplorerParameters parameters = getOracleSpatialParameters();

                OracleSpatialNewStoreParameters params = new OracleSpatialNewStoreParameters();

                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;

        }

        /**

         * Geometry support

         */

        public boolean hasGeometrySupport() {

                return true;

        }

        /**

         * get helper

         *

         * @return

         */

        protected OracleSpatialHelper getOSHelper() {

                return (OracleSpatialHelper) getHelper();

        }

        /**

         * get sql sentence for list available tables

         */

        protected List<String> getSQLForList(int mode,

                        boolean showInformationDBTables) {

                List<String> list = new ArrayList<String>(1);

                list.add("SELECT TABLE_NAME FROM USER_SDO_GEOM_METADATA");

                return list;

        }

        public List list(final int mode, final boolean showInformationDBTables)

        throws DataException {

final JDBCStoreParameters orgParams = createStoreParams();

ConnectionAction action = new ConnectionAction() {

        public Object action(Connection conn) throws DataException {

                ResultSet rs = null;

                Statement st = null;

                List sqls = getSQLForList(mode, showInformationDBTables);

                try {

                        JDBCStoreParameters params;

                        List paramList = new ArrayList();

                        conn = helper.getConnection();

                        st = conn.createStatement();

                        String sql;

                        Iterator sqlIter = sqls.iterator();

                        while (sqlIter.hasNext()){

                                sql = (String) sqlIter.next();

                                rs = st.executeQuery(sql);

                                while (rs.next()) {

                                        params = (JDBCStoreParameters) orgParams

                                                        .getCopy();

                                        params.setTable(rs.getString(1));

                                        // TODO

//                                        if (rs.getBoolean(4)) {

//                                                param.setIsView(param.IS_VIEW);

//                                        } else {

//                                                param.setIsView(param.NOT_IS_VIEW);

//                                        }

                                        paramList.add(params);

                                }

                        }

                        return paramList;

                } catch (SQLException e) {

                        throw new JDBCSQLException(e);

                } finally {

                        try {rs.close();} catch (Exception e) {        };

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

                }

        }

};

try {

        return (List) helper.doConnectionAction(action);

} catch (Exception e) {

        throw new ReadException(this.getName(), e);

}

}

}