| gvSIG desktop 1

/* 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.

 *

 */

package org.gvsig.exportto.swing.prov.jdbc;

import org.gvsig.exportto.ExporttoService;

import org.gvsig.exportto.ExporttoServiceException;

import org.gvsig.exportto.ExporttoServiceFinishAction;

import org.gvsig.fmap.dal.DALLocator;

import org.gvsig.fmap.dal.DataManager;

import org.gvsig.fmap.dal.DataTypes;

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

import org.gvsig.fmap.dal.feature.EditableFeatureAttributeDescriptor;

import org.gvsig.fmap.dal.feature.EditableFeatureType;

import org.gvsig.fmap.dal.feature.Feature;

import org.gvsig.fmap.dal.feature.FeatureSet;

import org.gvsig.fmap.dal.feature.FeatureStore;

import org.gvsig.fmap.dal.feature.FeatureType;

import org.gvsig.fmap.dal.feature.NewFeatureStoreParameters;

import org.gvsig.fmap.dal.store.db.DBStoreParameters;

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

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

import org.gvsig.tools.dispose.DisposableIterator;

import org.gvsig.tools.service.ServiceException;

import org.gvsig.tools.task.AbstractMonitorableTask;

/**

 * @author gvSIG Team

 * @version $Id$

 * 

 */

public class ExporrtoJDBCService extends AbstractMonitorableTask implements

    ExporttoService {

    private static final DataManager DATA_MANAGER = DALLocator.getDataManager();

    private String dbName = null;

    private String schema = null;

    private String tableName = null;

    private String pkField = null;

    private String userName = null;

    private String password = null;

    private String host = null;

    private int port = -1;

    private String explorerName = null;

    private String storeName = null;

    private NewFeatureStoreParameters newFeatureStoreParameters;

    private JDBCServerExplorer explorer;

    private FeatureStore featureStore;

    private ExporttoServiceFinishAction exporttoServiceFinishAction = null;

    /**

     * @param taskName

     * @throws ServiceException

     */

    protected ExporrtoJDBCService(FeatureStore featureStore, String dbName,

        String schema, String tableName, String pkField, String userName,

        String password, String host, int port, String explorerName,

        String storeName) {

        super("Export to JDBC");

        this.featureStore = featureStore;

        this.dbName = dbName;

        this.schema = schema;

        this.tableName = tableName;

        this.pkField = pkField;

        this.userName = userName;

        this.password = password;

        this.host = host;

        this.port = port;

        this.storeName = storeName;

        this.explorerName = explorerName;

    }

    public void export(FeatureSet featureSet) throws ExporttoServiceException {

        initializeParams(featureSet);

        DisposableIterator it1 = null;

        FeatureStore target = null;

        try {

            EditableFeatureType fType =

                featureStore.getDefaultFeatureType().getEditable();

            if (pkField != null) {

                EditableFeatureAttributeDescriptor pk =

                    fType.add(pkField, DataTypes.LONG);

                pk.setIsPrimaryKey(true);

                pk.setIsAutomatic(true);

            }

            newFeatureStoreParameters.setDefaultFeatureType(fType);

            explorer.add(storeName, newFeatureStoreParameters, true);

            target =

                (FeatureStore) DATA_MANAGER.openStore(storeName,

                    newFeatureStoreParameters);

            FeatureType targetType = target.getDefaultFeatureType();

            target.edit(FeatureStore.MODE_APPEND);

            taskStatus.setRangeOfValues(0, featureSet.getSize());

            int featureCount = 1;

            it1 = featureSet.fastIterator();

            while (it1.hasNext()) {

                Feature feature = (Feature) it1.next();

                target.insert(target.createNewFeature(targetType, feature));

                this.taskStatus.setCurValue(featureCount);

                if (this.taskStatus.isCancellationRequested()) {

                    return;

                }

                featureCount++;

            }

            target.finishEditing();

            if (exporttoServiceFinishAction != null) {

                exporttoServiceFinishAction.finished(

                    newFeatureStoreParameters.getDataStoreName(),

                    newFeatureStoreParameters);

            }

        } catch (Exception e) {

            taskStatus.message(e.getMessage());

            throw new ExporttoServiceException(e);

        } finally {

            if (it1 != null) {

                it1.dispose();

            }

            featureSet.dispose();

            if (target != null) {

                target.dispose();

            }

            this.taskStatus.terminate();

            this.taskStatus.remove();

        }

    }

    private void initializeParams(FeatureSet featureSet)

        throws ExporttoServiceException {

        JDBCServerExplorerParameters explorerParam;

        try {

            explorerParam =

                (JDBCServerExplorerParameters) DATA_MANAGER

                    .createServerExplorerParameters(explorerName);

            explorerParam.setHost(host);

            if (port > -1) {

                explorerParam.setPort(port);

            }

            explorerParam.setDBName(dbName);

            explorerParam.setUser(userName);

            explorerParam.setPassword(password);

            if (schema != null && schema.length() > 0) {

                explorerParam.setSchema(schema);

            }

            explorer =

                (JDBCServerExplorer) DATA_MANAGER.openServerExplorer(

                    explorerName, explorerParam);

            newFeatureStoreParameters =

                (NewFeatureStoreParameters) explorer.getAddParameters();

            ((DBStoreParameters) newFeatureStoreParameters).setTable(tableName);

            ((DBStoreParameters) newFeatureStoreParameters)

                .setDefaultGeometryField(featureSet.getDefaultFeatureType()

                    .getDefaultGeometryAttributeName());

        } catch (InitializeException e) {

            throw new ExporttoServiceException(e);

        } catch (ProviderNotRegisteredException e) {

            throw new ExporttoServiceException(e);

        } catch (ValidateDataParametersException e) {

            throw new ExporttoServiceException(e);

        } catch (DataException e) {

            throw new ExporttoServiceException(e);

        }

    }

    public void setFinishAction(

        ExporttoServiceFinishAction exporttoServiceFinishAction) {

        this.exporttoServiceFinishAction = exporttoServiceFinishAction;

    }

}