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

*

*/

/*

* AUTHORS (In addition to CIT):

* 2009 IVER T.I   {{Task}}

*/

/**

 *

 */

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

import org.gvsig.fmap.dal.DALDbLibrary;

import org.gvsig.fmap.dal.DataStoreParameters;

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

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

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

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

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

import org.gvsig.fmap.dal.index.spatial.jts.JTSIndexLibrary;

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

import org.gvsig.fmap.geom.impl.DefaultGeometryLibrary;

import org.gvsig.tools.ToolsLocator;

import org.gvsig.tools.evaluator.Evaluator;

import org.gvsig.tools.evaluator.EvaluatorData;

import org.gvsig.tools.evaluator.EvaluatorException;

import org.gvsig.tools.evaluator.EvaluatorFieldsInfo;

import org.gvsig.tools.persistence.xmlentity.XMLEntityManager;

/**

 * @author jmvivo

 *

 */

public class TestPostgreSQL extends BaseTestFeatureStore {

        protected void setUp() throws Exception {

                super.setUp();

                ToolsLocator.registerDefaultPersistenceManager(XMLEntityManager.class);

                DefaultGeometryLibrary defGeomLib = new DefaultGeometryLibrary();

                defGeomLib.initialize();

                DALDbLibrary libDb = new DALDbLibrary();

                libDb.initialize();

                JDBCLibrary libJDBC = new JDBCLibrary();

                libJDBC.initialize();

                PostgreSQLLibrary pgLib = new PostgreSQLLibrary();

                pgLib.initialize();

                JTSIndexLibrary jtsIndex = new JTSIndexLibrary();

                jtsIndex.initialize();

                defGeomLib.postInitialize();

                libDb.postInitialize();

                libJDBC.postInitialize();

                pgLib.postInitialize();

                jtsIndex.postInitialize();

        }

        public DataStoreParameters getDefaultDataStoreParameters()

                        throws DataException {

                PostgreSQLStoreParameters pgParameters = null;

                pgParameters = (PostgreSQLStoreParameters) dataManager

                                .createStoreParameters(PostgreSQLStoreProvider.NAME);

                pgParameters.setHost("localhost");

                pgParameters.setUser("postgres");

                pgParameters.setPassword("postgres");

                pgParameters.setDBName("gis");

                pgParameters.setTable("muni10000_peq");

                pgParameters.setPkFields("gid");

                return pgParameters;

        }

        public boolean hasExplorer() {

                // TODO Auto-generated method stub

                return false;

        }

        public void testCloserConnection() {

                try {

                        DataStoreParameters params = this.getDefaultDataStoreParameters();

                        FeatureStore store = null;

                        store = (FeatureStore) dataManager.createStore(params);

                        FeatureQuery query = store.createFeatureQuery();

                        query.getOrder().add("gid", true);

                        query.setFilter(new Evaluator() {

                                public Object evaluate(EvaluatorData data)

                                throws EvaluatorException {

                                        // TODO Auto-generated method stub

                                        return Boolean.TRUE;

                                }

                                public String getCQL() {

                                        return "true = true";

                                }

                                public String getDescription() {

                                        // TODO Auto-generated method stub

                                        return null;

                                }

                                public String getName() {

                                        return "AlwaysTrue";

                                }

                                public EvaluatorFieldsInfo getFieldsInfo() {

                                        // TODO Auto-generated method stub

                                        return null;

                                }

                        });

                        FeatureStoreTransform transform = new StringsToLowerTransform();

                        transform.setFeatureStore(store);

                        store.getTransforms().add(transform);

                        transform = new StringsToLowerTransform();

                        transform.setFeatureStore(store);

                        store.getTransforms().add(transform);

                        transform = new StringsToLowerTransform();

                        transform.setFeatureStore(store);

                        store.getTransforms().add(transform);

                        for (int i = 0; i < 30; i++) {

                                // this.fullStoreIteratorTest(store);

                                 this.testIterationFastAndStandart(store, query);

                        }

                        store.dispose();

                } catch (DataException e) {

                        e.printStackTrace();

                        fail();

                }

        }

}