Application: gvSIG desktop » gvSIG data provider for PostgreSQL

<?xml version="1.0" encoding="UTF-8"?>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

  <modelVersion>4.0.0</modelVersion>

  <artifactId>org.gvsig.postgresql.app.export</artifactId>

  <packaging>jar</packaging>

  <name>Export: PostgreSQL support</name>

  <description>Export support for PostgreSQL</description>

  <parent>

      <groupId>org.gvsig</groupId>

      <artifactId>org.gvsig.postgresql.app</artifactId>

      <version>2.0.21-SNAPSHOT</version>

  </parent>

  <dependencies>

    <dependency>

        <groupId>org.gvsig</groupId>

        <artifactId>org.gvsig.tools.lib</artifactId>

        <scope>compile</scope>

    </dependency>

    <dependency>

        <groupId>org.gvsig</groupId>

        <artifactId>org.gvsig.andami</artifactId>

        <scope>compile</scope>

    </dependency>

    <dependency>

      <groupId>org.gvsig</groupId>

      <artifactId>org.gvsig.exportto.lib.api</artifactId>

      <scope>compile</scope>

    </dependency>

    <dependency>

      <groupId>org.gvsig</groupId>

      <artifactId>org.gvsig.exportto.swing.api</artifactId>

      <scope>compile</scope>

    </dependency>

    <dependency>

      <groupId>org.gvsig</groupId>

      <artifactId>org.gvsig.exportto.swing.spi</artifactId>

      <scope>compile</scope>

    </dependency>

    <dependency>

      <groupId>org.gvsig</groupId>

      <artifactId>org.gvsig.exportto.swing.prov.jdbc</artifactId>

      <scope>compile</scope>

    </dependency>

    <dependency>

      <groupId>org.gvsig</groupId>

      <artifactId>org.gvsig.geodb.app.mainplugin</artifactId>

      <scope>compile</scope>

    </dependency>

    <dependency>

      <groupId>postgresql</groupId>

      <artifactId>postgresql</artifactId>

      <scope>runtime</scope>

    </dependency>

    <dependency>

      <groupId>commons-dbcp</groupId>

      <artifactId>commons-dbcp</artifactId>

      <scope>runtime</scope>

    </dependency>

    <dependency>

      <groupId>commons-collections</groupId>

      <artifactId>commons-collections</artifactId>

      <scope>runtime</scope>

    </dependency>

    <dependency>

      <groupId>commons-pool</groupId>

      <artifactId>commons-pool</artifactId>

      <scope>runtime</scope>

    </dependency>

  </dependencies>

    <properties>

        <!-- Package info property values -->

        <!-- Default values in org.gvsig.desktop -->

        <gvsig.package.info.state>testing</gvsig.package.info.state>

        <gvsig.package.info.official>true</gvsig.package.info.official>

        <gvsig.package.info.dependencies>required: org.gvsig.app.mainplugin -ge 2.0.1</gvsig.package.info.dependencies>

        <gvsig.package.info.categories>Formats,Vector,Database</gvsig.package.info.categories>

        <gvsig.package.info.poolURL>http://devel.gvsig.org/download/projects/gvsig-postgresql/pool/</gvsig.package.info.poolURL>

    </properties>

</project>

#Tue Oct 08 20:52:46 CEST 2013

buildNumber=2077

org.gvsig.exportto.swing.prov.postgresql.ExporttoV2PostgreSQLProviderLibrary

<assembly>

  <id>gvsig-plugin-package</id>

  <formats>

    <format>zip</format>

  </formats>

  <baseDirectory>${project.artifactId}</baseDirectory>

  <includeBaseDirectory>true</includeBaseDirectory>

  <files>

    <file>

      <source>target/${project.artifactId}-${project.version}.jar</source>

      <outputDirectory>lib</outputDirectory>

    </file>

    <file>

      <source>target/package.info</source>

    </file>

    <file>

      <source>src/main/resources-plugin/config.xml</source>

    </file>

  </files>

  <dependencySets>

    <dependencySet>

      <useProjectArtifact>false</useProjectArtifact>

      <useTransitiveDependencies>false</useTransitiveDependencies>

      <outputDirectory>lib</outputDirectory>

      <includes>

        <include>org.gvsig:org.gvsig.postgresql.provider</include>

      </includes>

    </dependencySet>

    <dependencySet>

      <useProjectArtifact>false</useProjectArtifact>

      <useTransitiveDependencies>false</useTransitiveDependencies>

      <outputDirectory>lib</outputDirectory>

      <includes>

		<include>postgresql:postgresql</include>

		<include>commons-dbcp:commons-dbcp</include>

		<include>commons-collections:commons-collections</include>

		<include>commons-pool:commons-pool</include>

      </includes>

    </dependencySet>

  </dependencySets>

</assembly>

/**

 * gvSIG. Desktop Geographic Information System.

 *

 * Copyright (C) 2007-2013 gvSIG Association.

 *

 * 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 3

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

 *

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.postgresql.exportto;

import org.gvsig.tools.library.AbstractLibrary;

import org.gvsig.tools.library.LibraryException;

import org.gvsig.tools.service.spi.ProviderManager;

import org.gvsig.exportto.swing.ExporttoSwingLibrary;

import org.gvsig.exportto.swing.spi.ExporttoSwingProviderLocator;

/**

 * Library to initialize and register the file Exporto provider

 * implementation.

 * 

 * @author gvSIG Team

 * @version $Id$

 */

public class ExporttoPostgreSQLProviderLibrary extends AbstractLibrary {

    @Override

    public void doRegistration() {

        registerAsServiceOf(ExporttoSwingLibrary.class);

    }

    @Override

    protected void doInitialize() throws LibraryException {

        // Nothing to do

    }

    @Override

    protected void doPostInitialize() throws LibraryException {

        ProviderManager providerManager =

            ExporttoSwingProviderLocator.getManager();

        providerManager

            .addProviderFactory(new ExporttoPostgreSQLProviderFactory());

    }

}

/**

 * gvSIG. Desktop Geographic Information System.

 *

 * Copyright (C) 2007-2013 gvSIG Association.

 *

 * 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 3

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

 *

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.postgresql.exportto;

import org.cresques.cts.IProjection;

import org.gvsig.exportto.swing.ExporttoSwingManager;

import org.gvsig.exportto.swing.spi.AbstractExporttoProviderFactory;

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

import org.gvsig.tools.dynobject.DynObject;

import org.gvsig.tools.service.ServiceException;

import org.gvsig.tools.service.spi.Provider;

import org.gvsig.tools.service.spi.ProviderServices;

/**

 * Factory of file {@link ExportoProvider} objects.

 * 

 * @author gvSIG Team

 * @version $Id$

 */

public class ExporttoPostgreSQLProviderFactory extends

    AbstractExporttoProviderFactory {

    private static final String PROVIDER_NAME = "PostgreSQLv2";

    public ExporttoPostgreSQLProviderFactory() {

        super(new int[] {

            ExporttoSwingManager.VECTORIAL_TABLE_WITHOUT_GEOMETRY,

            ExporttoSwingManager.VECTORIAL_TABLE_WITH_GEOMETRY });

    }

    public Provider create(DynObject parameters, ProviderServices services)

        throws ServiceException {

        return new ExporttoPostgreSQLProvider(services,

            (FeatureStore) parameters.getDynValue(PARAMETER_FEATURESTORE),

            (IProjection) parameters.getDynValue(PARAMETER_PROJECTION));

    }

    public String getName() {

        return PROVIDER_NAME;

    }

}

<?xml version="1.0" encoding="UTF-8" ?>

<!--

    gvSIG. Desktop Geographic Information System.

    Copyright (C) 2007-2013 gvSIG Association.

    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 3

    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.

    For any additional information, do not hesitate to contact us

    at info AT gvsig.com, or visit our website www.gvsig.com.

-->

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

<title>org.gvsig.exporto package documentation</title>

</head>

<body>

	<p>Exporto provider which gets Exporto from a file.</p>

</body>

</html>

/*

 * To change this license header, choose License Headers in Project Properties.

 * To change this template file, choose Tools | Templates

 * and open the template in the editor.

 */

package org.gvsig.postgresql.exportto.panel;

import java.util.HashMap;

import java.util.Iterator;

import java.util.Map;

import javax.swing.JComponent;

import javax.swing.JPanel;

import org.gvsig.andami.PluginsLocator;

import org.gvsig.andami.PluginsManager;

import org.gvsig.fmap.dal.serverexplorer.db.DBServerExplorerParameters;

import org.gvsig.tools.swing.api.Component;

import org.gvsig.geodb.ExtDB_Spatial;

/**

 *

 * @author jjdelcerro

 */

public class DefaultConnectionPanel extends JPanel implements Component {

    private String name = null;

    private DBServerExplorerParameters explorerParameters = null;

    private String explorerNameFilter = null;

    public DefaultConnectionPanel() {

    }

    public void setFilterByExplorerName(String explorerNameFilter) {

        this.explorerNameFilter = explorerNameFilter;

    }

    public JComponent asJComponent() {

        return this;

    }

    protected Map<String,DBServerExplorerParameters> getUserConections() {

        PluginsManager pluginsManager = PluginsLocator.getManager();

        ExtDB_Spatial geodbExtension = pluginsManager.getExtension(ExtDB_Spatial.class);

        Map<String, DBServerExplorerParameters> connections = geodbExtension.getUserConnections();

        if( this.explorerNameFilter == null ) {

            return connections;

        }

        Map<String,DBServerExplorerParameters> filteredConnections = new HashMap<String,DBServerExplorerParameters>();

        Iterator<Map.Entry<String,DBServerExplorerParameters>> it = connections.entrySet().iterator();

        while( it.hasNext() ) {

            Map.Entry<String,DBServerExplorerParameters> entry = it.next();

            if( this.explorerNameFilter.equalsIgnoreCase(entry.getValue().getExplorerName()) ) {

                filteredConnections.put(entry.getKey(), entry.getValue());

            }

        }

        return filteredConnections;

    }

    protected void initComponents() {

    }

}

/**

 * gvSIG. Desktop Geographic Information System.

 *

 * Copyright (C) 2007-2013 gvSIG Association.

 *

 * 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 3

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

 *

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.postgresql.exportto.panel;

import java.awt.BorderLayout;

import javax.swing.JTextField;

import org.gvsig.exportto.swing.ExporttoSwingLocator;

import org.gvsig.exportto.swing.ExporttoSwingManager;

import org.gvsig.exportto.swing.spi.ExporttoPanelValidationException;

import org.gvsig.exportto.swing.spi.ExporttoSwingProviderPanel;

/**

 * @author gvSIG Team

 * @version $Id$

 * 

 */

public class SelectTableNamePanel extends ExporttoSwingProviderPanel {

    private static final long serialVersionUID = 6269512983586358017L;

    private static final ExporttoSwingManager EXPORTTO_SWING_MANAGER =

        ExporttoSwingLocator.getSwingManager();

    protected JTextField textField = null;

    protected void initializeComponents() {

        this.setLayout(new BorderLayout());

        textField = new JTextField();

        add(textField, BorderLayout.NORTH);

    }

    public String getText() {

        String field = textField.getText();

        if ((field == null) || (field.equals(""))) {

            return null;

        }

        return field;

    }

    public String getPanelTitle() {

        return EXPORTTO_SWING_MANAGER.getTranslation("intro_tablename");

    }

    public boolean isValidPanel() throws ExporttoPanelValidationException {

        if (getText() == null || getText().equals("")) {

            throw new ExporttoPanelValidationException(

                "The table cannot be empty");

        }

        return true;

    }

}

/**

 * gvSIG. Desktop Geographic Information System.

 *

 * Copyright (C) 2007-2013 gvSIG Association.

 *

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

 *

 * For any additional information, do not hesitate to contact us at info AT

 * gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.postgresql.exportto.panel;

import java.awt.BorderLayout;

import javax.swing.JLabel;

import javax.swing.JPanel;

import javax.swing.JTextField;

import org.gvsig.exportto.swing.ExporttoSwingLocator;

import org.gvsig.exportto.swing.ExporttoSwingManager;

import org.gvsig.exportto.swing.spi.ExporttoPanelValidationException;

import org.gvsig.exportto.swing.spi.ExporttoSwingProviderPanel;

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

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

/**

 * @author gvSIG Team

 * @version $Id$

 *

 */

public class SelectPkPanel extends ExporttoSwingProviderPanel {

    private static final long serialVersionUID = 2652404227373508779L;

    private static final ExporttoSwingManager EXPORTTO_SWING_MANAGER

            = ExporttoSwingLocator.getSwingManager();

    private FeatureType featType = null;

    protected JTextField textField = null;

    public SelectPkPanel() {

        super();

    }

    public SelectPkPanel(FeatureType ft) {

        super();

        featType = ft;

    }

    protected void initializeComponents() {

        this.setLayout(new BorderLayout());

        JPanel topPanel = new JPanel(new BorderLayout());

        textField = new JTextField();

        String msg = EXPORTTO_SWING_MANAGER.getTranslation(

                "_Enter_new_field_name_for_primary_key_or_blank_to_not_add_primary_key");

        topPanel.add(new JLabel(msg + ":"), BorderLayout.NORTH);

        topPanel.add(textField, BorderLayout.CENTER);

        // ==============================================

        add(topPanel, BorderLayout.NORTH);

    }

    public String getText() {

        String field = textField.getText();

        if ((field == null) || (field.trim().equals(""))) {

            return null;

        }

        return field;

    }

    @Override

    public String getPanelTitle() {

        return EXPORTTO_SWING_MANAGER.getTranslation("_Primary_key");

    }

    @Override

    public boolean isValidPanel() throws ExporttoPanelValidationException {

        String txt = this.getText();

        if (isFieldName(txt, featType)) {

            throw new ExporttoPanelValidationException(

                    EXPORTTO_SWING_MANAGER.getTranslation(

                            "_Field_name_already_exists"));

        }

        return true;

    }

    private boolean isFieldName(String txt, FeatureType ft) {

        if (ft == null || txt == null) {

            return false;

        }

        FeatureAttributeDescriptor[] atts = ft.getAttributeDescriptors();

        for (int i = 0; i < atts.length; i++) {

            if (atts[i].getName().equals(txt)) {

                return true;

            }

        }

        return false;

    }

}

/**

 * gvSIG. Desktop Geographic Information System.

 *

 * Copyright (C) 2007-2013 gvSIG Association.

 *

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

 *

 * For any additional information, do not hesitate to contact us at info AT

 * gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.postgresql.exportto;

import org.cresques.cts.IProjection;

import org.gvsig.exportto.ExporttoService;

import org.gvsig.exportto.swing.prov.jdbc.ExporrtoJDBCService;

import org.gvsig.exportto.swing.prov.jdbc.panel.JDBCConnectionPanel;

import org.gvsig.exportto.swing.spi.ExporttoSwingProvider;

import org.gvsig.exportto.swing.spi.ExporttoSwingProviderPanel;

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

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

import org.gvsig.tools.service.spi.AbstractProvider;

import org.gvsig.tools.service.spi.ProviderServices;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

import org.gvsig.postgresql.exportto.panel.SelectPkPanel;

import org.gvsig.postgresql.exportto.panel.SelectTableNamePanel;

/**

 * Exporto provider which gets Exporto from a file.

 *

 * @author gvSIG Team

 * @version $Id$

 */

public class ExporttoPostgreSQLProvider extends AbstractProvider

        implements ExporttoSwingProvider {

    private static Logger logger = LoggerFactory.getLogger(

            ExporttoPostgreSQLProvider.class);

    protected SelectTableNamePanel selectTableNamePanel = null;

    protected SelectPkPanel selectPkPanel = null;

    protected JDBCConnectionPanel jdbcConnectionPanel = null;

    protected FeatureStore featureStore;

    protected IProjection projection;

    /**

     * Constructor.

     *

     * @param providerServices the services for the provider

     * @param file to get the Exporto from

     */

    public ExporttoPostgreSQLProvider(ProviderServices providerServices,

            FeatureStore featureStore, IProjection projection) {

        super(providerServices);

        this.featureStore = featureStore;

        this.projection = projection;

        selectTableNamePanel = new SelectTableNamePanel();

        FeatureType ftype = null;

        try {

            ftype = featureStore.getDefaultFeatureType();

        } catch (Exception exc) {

            logger.error("While getting feature type.", exc);

        }

        selectPkPanel = new SelectPkPanel(ftype);

        jdbcConnectionPanel = new JDBCConnectionPanel();

    }

    public String getStoreName() {

        return "PostgreSQL";

    }

    public String getExplorerName() {

        return "PostgreSQLExplorer";

    }

    public int getPanelCount() {

        return 3;

    }

    public ExporttoSwingProviderPanel getPanelAt(int index) {

        switch (index) {

            case 0:

                return selectTableNamePanel;

            case 1:

                return selectPkPanel;

            case 2:

                return jdbcConnectionPanel;

        }

        return null;

    }

    public ExporttoService createExporttoService() {

        ConnectionSettings connectionSettings

                = jdbcConnectionPanel.getConnectionSettings();

        int port = -1;

        if (connectionSettings.getPort() != null

                && connectionSettings.getPort().length() > 0) {

            port = Integer.valueOf(connectionSettings.getPort());

        }

        String schema = null;

        if (connectionSettings.getSchema() != null

                && connectionSettings.getSchema().length() > 0) {

            schema = connectionSettings.getSchema();

        }

        return new ExporrtoJDBCService(featureStore,

                connectionSettings.getDb(), schema, selectTableNamePanel.getText(),

                selectPkPanel.getText(), connectionSettings.getUser(),

                connectionSettings.getPassw(), connectionSettings.getHost(), port,

                getExplorerName(), getStoreName(), this.projection);

    }

}

<?xml version="1.0" encoding="ISO-8859-1"?>

<plugin-config>

  <libraries library-dir="lib/"/>

  <depends plugin-name="org.gvsig.app.mainplugin"/>

  <resourceBundle name="text"/>

  <extensions>

     <extension class-name="org.gvsig.andami.LibraryExtension" active="false"/>

  </extensions>    

</plugin-config>