Application: gvSIG desktop » gvSIG data provider for PostgreSQL

/* 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):

* 2008 IVER T.I. S.A.   {{Task}}

*/

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

import org.gvsig.fmap.dal.DALLibrary;

import org.gvsig.fmap.dal.DALLocator;

import org.gvsig.fmap.dal.resource.spi.ResourceManagerProviderServices;

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

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

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

import org.gvsig.metadata.exceptions.MetadataException;

import org.gvsig.tools.library.AbstractLibrary;

import org.gvsig.tools.library.LibraryException;

public class PostgreSQLLibrary extends AbstractLibrary {

    static String DEFAULT_JDCB_DRIVER_NAME = "org.postgresql.Driver";

    public static final String NAME = "PostgreSQL";

    @Override

    public void doRegistration() {

        registerAsServiceOf(DALLibrary.class);

        require(JDBCLibrary.class);

    }

        public static String getJdbcUrl(String host, Integer port, String db) {

                String url = null;

                if(host != null){

                    String sport = "";

                    if (port != null) {

                        sport = ":" + port;

                    }

                    url = "jdbc:postgresql://" + host + sport + "/" + db;

                }

                return url;

        }

        @Override

        protected void doInitialize() throws LibraryException {

        }

        @Override

        protected void doPostInitialize() throws LibraryException {

                LibraryException ex=null;

                new JDBCLibrary().postInitialize();

                 DBHelper.registerParametersDefinition(

                                 PostgreSQLStoreParameters.PARAMETERS_DEFINITION_NAME,

                                 PostgreSQLStoreParameters.class,

                                 "PostgreSQLParameters.xml"

                );

                DBHelper.registerParametersDefinition(

                                PostgreSQLNewStoreParameters.PARAMETERS_DEFINITION_NAME,

                                PostgreSQLNewStoreParameters.class,

                                "PostgreSQLParameters.xml"

                );

                DBHelper.registerParametersDefinition(

                                PostgreSQLServerExplorerParameters.PARAMETERS_DEFINITION_NAME, 

                                PostgreSQLServerExplorerParameters.class, 

                                "PostgreSQLParameters.xml"

                );

                DBHelper.registerParametersDefinition(

                                PostgreSQLResourceParameters.PARAMETERS_DEFINITION_NAME, 

                                PostgreSQLResourceParameters.class, 

                                "PostgreSQLParameters.xml"

                );

                try {

                        DBHelper.registerMetadataDefinition(

                                        PostgreSQLStoreProvider.METADATA_DEFINITION_NAME, 

                                        PostgreSQLStoreProvider.class, 

                                        "PostgreSQLMetadata.xml"

                        );

                } catch (MetadataException e) {

                        ex = new LibraryException(this.getClass(),e);

                }

                ResourceManagerProviderServices resman = (ResourceManagerProviderServices) DALLocator

                .getResourceManager();

                if (!resman.getResourceProviders().contains(PostgreSQLResource.NAME)) {

                        resman.register(PostgreSQLResource.NAME,

                                        PostgreSQLResource.DESCRIPTION, PostgreSQLResource.class,

                                        PostgreSQLResourceParameters.class);

                }

                DataManagerProviderServices dataman = (DataManagerProviderServices) DALLocator

                                .getDataManager();

                if (!dataman.getStoreProviders().contains(PostgreSQLStoreProvider.NAME)) {

                        dataman.registerStoreProviderFactory(

                                new PostgreSQLStoreProviderFactory()

                        );

                }

                if (!dataman.getExplorerProviders().contains(

                                PostgreSQLStoreProvider.NAME)) {

                        dataman.registerServerExplorerFactory(

                                new PostgreSQLServerExplorerFactory()

                        );

                }

                if( ex!=null ) {

                        throw ex;

                }

        }

}