import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import junit.framework.TestCase;

import com.hardcode.gdbms.engine.data.driver.DriverException;
import com.hardcode.gdbms.engine.values.NumericValue;
import com.iver.cit.gvsig.fmap.drivers.DBLayerDefinition;
import com.iver.cit.gvsig.fmap.drivers.jdbc.postgis.PostGisDriver;

public class testPostGIS extends TestCase {

	PostGisDriver driver = new PostGisDriver();
	ResultSet rsGood = null;

	protected void setUp() throws Exception {
		super.setUp();
		try {
			String dburl = "jdbc:postgresql://localhost/latin1";
			String dbuser = "postgres";
			String dbpass = "aquilina";
	
			// String dburl = "jdbc:postgresql://192.168.0.217/postgis";
			// String dbuser = "gvsig";
			// String dbpass = "";
	
			// String dbtable = "carreteras_lin_5k_t10";
			String dbtable = "provin"; // OJO CON LAS MAYUSCULAS!!!!!!!
	
			Connection conn = null;
			System.out.println("Creating JDBC connection...");
			Class.forName("org.postgresql.Driver");
			conn = DriverManager.getConnection(dburl, dbuser, dbpass);
	
			conn.setAutoCommit(false);
			
			DBLayerDefinition lyrDef = new DBLayerDefinition();                
			lyrDef.setName(dbtable);
			lyrDef.setTableName(dbtable);
			lyrDef.setWhereClause("");
			String[] fields = {"nom_provin", "gid"};
			lyrDef.setFieldNames(fields);
			lyrDef.setFieldGeometry("the_geom");
			lyrDef.setFieldID("gid");
	
			Statement st = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
			rsGood = st.executeQuery("SELECT NOM_PROVIN, GID FROM " + dbtable + " ORDER BY GID");
			driver.setData(conn, lyrDef);
		}
		catch (Exception e){
			e.printStackTrace();
		}
	}

	protected void tearDown() throws Exception {
		super.tearDown();
		driver.close();
	}

	/*
	 * Test method for
	 * 'com.iver.cit.gvsig.fmap.drivers.jdbc.postgis.PostGisDriver.getFieldValue(long,
	 * int)'
	 */
	public void testGetFieldValue() {
		int pos1 = 1;
		int pos2 = 30;
		int pos3 = 15;
		
		try {
			for (int i=0; i < 40; i++)
			{
				rsGood.absolute(i+1);
				System.out.println("GOOD:" + rsGood.getInt(2) + " " + rsGood.getString(1));
				
				String aux = driver.getFieldValue(i, 0).toString();
				int id = ((NumericValue) driver.getFieldValue(i, 1)).intValue();
				System.out.println(id + " " + aux);				
			}
			rsGood.absolute(pos1);
			String str2 = driver.getFieldValue(pos1-1, 0).toString();
			String str1 = rsGood.getString(1);
			
			System.out.println(str1 + " - " + str2);
		
			assertEquals(str1, str2);
			
			
			rsGood.absolute(pos2);
			str2 = driver.getFieldValue(pos2-1, 0).toString();
			str1 = rsGood.getString(1);
			
			
			int id1 = rsGood.getInt(2);
			int id2 = ((NumericValue) driver.getFieldValue(pos2-1, 1)).intValue();
			System.out.println(id1 + " " + str1 + " - " + id2 + " " + str2);
			assertEquals(id1, id2);

			
			rsGood.absolute(pos3);
			str2 = driver.getFieldValue(pos3-1, 0).toString();
			str1 = rsGood.getString(1);
			
			System.out.println(str1 + " - " + str2);
		
			assertEquals(str1, str2);

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (DriverException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
			
	}

}