Application: gvSIG desktop

package org.gvsig.data.datastores.vectorial.db.jdbc.postgresql;

import java.util.Iterator;

import java.util.NoSuchElementException;

import org.gvsig.data.DataManager;

import org.gvsig.data.datastores.vectorial.db.jdbc.JDBCTest;

import org.gvsig.data.exception.InitializeException;

import org.gvsig.data.exception.ReadException;

import org.gvsig.data.vectorial.IFeatureCollection;

import org.gvsig.data.vectorial.IFeatureStore;

public class postgresqlTest extends JDBCTest {

        private static String SERVER_IP="192.168.0.66";

        private static String SERVER_PORT="5432";

        private static String SERVER_DBNAME="gis";

        private static String SERVER_SCHEMA="ds_test";

        private static String SERVER_USER="testCase";

        private static String SERVER_PASWD="testCase";

        private static String DS_NAME = PostgresqlStore.DATASTORE_NAME;

        public void testSimpleIteration(){

                Register.selfRegister();

                DataManager manager = DataManager.getManager();

                PostgresqlStoreParameters dparam =

                        (PostgresqlStoreParameters)manager.createDataStoreParameters(DS_NAME);

                dparam.setHost(SERVER_IP);

                dparam.setPort(SERVER_PORT);

                dparam.setUser(SERVER_USER);

                dparam.setPassw(SERVER_PASWD);

                dparam.setSchema(SERVER_SCHEMA);

                dparam.setDb(SERVER_DBNAME);

                dparam.setTableName("prueba");

                dparam.setFieldId(new String[] {"gid"});

                dparam.setFields(new String[] {"*"});

                dparam.setDefaultGeometryField("the_geom");

                storeTest(dparam, null, null, false);

        }

        public void testSimpleIteration38K_regs(){

                Register.selfRegister();

                DataManager manager = DataManager.getManager();

                PostgresqlStoreParameters dparam =

                        (PostgresqlStoreParameters)manager.createDataStoreParameters(DS_NAME);

                dparam.setHost(SERVER_IP);

                dparam.setPort(SERVER_PORT);

                dparam.setUser(SERVER_USER);

                dparam.setPassw(SERVER_PASWD);

                dparam.setSchema(null);

                dparam.setDb(SERVER_DBNAME);

                dparam.setTableName("hidropol");

//                dparam.setTableName("ejes");

                dparam.setFieldId(new String[] {"gid"});

                dparam.setFields(new String[] {"*"});

                dparam.setDefaultGeometryField("the_geom");

//                storeTest(dparam, null, null, false);

                IFeatureStore fs=null;

                try {

                        fs = (IFeatureStore) manager.createDataStore(dparam);

                } catch (InitializeException e) {

                        e.printStackTrace();

                        fail();

                }

                IFeatureCollection fc=null;

                try {

                        fc = (IFeatureCollection) fs.getDataCollection();

                } catch (ReadException e) {

                        e.printStackTrace();

                        fail();

                }

                int i=0;

                int count = fc.size();

                Iterator iter = fc.iterator();

                while (true){

                        try{

                                iter.next();

                                i++;

                        } catch (NoSuchElementException e) {

                                break;

                        }

                }

                assertEquals(count, i);

        }

}