Revision 13792 trunk/extensions/extSDE/src-test/com/iver/cit/gvsig/sde/SDETest.java

View differences:

SDETest.java
4 4 

  		




  5
  5
  
    
import junit.framework.TestCase;


  		




  6
  6
  
    

  		




  7
  
  
    
import com.hardcode.gdbms.engine.data.driver.DriverException;


  		




  8
  
  
    
import com.hardcode.gdbms.engine.values.NumericValue;


  		




  
  7
  
    
import com.esri.sde.sdk.client.SeException;


  		




  
  8
  
    
import com.iver.cit.gvsig.fmap.drivers.ConnectionFactory;


  		




  9
  9
  
    
import com.iver.cit.gvsig.fmap.drivers.DBLayerDefinition;


  		




  
  10
  
    
import com.iver.cit.gvsig.fmap.drivers.IConnection;


  		




  10
  11
  
    
import com.iver.cit.gvsig.fmap.drivers.sde.ArcSdeDriver;


  		




  
  12
  
    
import com.iver.cit.gvsig.fmap.drivers.sde.ConnectionSDE;


  		




  
  13
  
    
import com.iver.utiles.extensionPoints.ExtensionPoints;


  		




  
  14
  
    
import com.iver.utiles.extensionPoints.ExtensionPointsSingleton;


  		




  11
  15
  
    

  		




  
  16
  
    
/**


  		




  
  17
  
    
 * Unit test of ArcSDE.


  		




  
  18
  
    
 *


  		




  
  19
  
    
 * @author Vicente Caballero Navarro


  		




  
  20
  
    
 *


  		




  
  21
  
    
 */


  		




  12
  22
  
    
public class SDETest extends TestCase {


  		




  13
  23
  
    
	ArcSdeDriver driver = new ArcSdeDriver();


  		




  14
  24
  
    
	ResultSet rsGood = null;


  		




  
  25
  
    
	DBLayerDefinition lyrDef = new DBLayerDefinition();


  		




  15
  26
  
    

  		




  
  27
  
    
	public SDETest() {


  		




  
  28
  
    
		super("ArcSDE unit tests");


  		




  
  29
  
    
	}


  		




  16
  30
  
    
	protected void setUp() throws Exception {


  		




  17
  31
  
    
		super.setUp();


  		




  18
  
  
    
		try {


  		




  19
  
  
    
			DBLayerDefinition lyrDef = new DBLayerDefinition();


  		




  20
  32
  
    
			lyrDef.setUser("sde");


  		




  21
  33
  
    
			lyrDef.setPassword("iver");


  		




  22
  34
  
    
			lyrDef.setHost("192.168.0.114");


  		




  23
  35
  
    
			lyrDef.setPort(5151);


  		




  24
  
  
    
			lyrDef.setName("EJES");


  		




  25
  
  
    
			lyrDef.setTableName("EJES");


  		




  26
  
  
    
			lyrDef.setDataBase("ProvinciasPruebas");


  		




  
  36
  
    
			lyrDef.setName("MUNICIPIOSDEF");


  		




  
  37
  
    
			lyrDef.setTableName("MUNICIPIOSDEF");


  		




  
  38
  
    
			lyrDef.setDataBase("sde");


  		




  27
  39
  
    
			lyrDef.setFieldGeometry("SHAPE");


  		




  28
  40
  
    
			lyrDef.setFieldID("OBJECTID");


  		




  29
  41
  
    
			lyrDef.setWhereClause("");


  		




  30
  
  
    
			lyrDef.setFieldNames(new String[] {"OBJECTID","ID","REFERINE","CALLE_ID","DESDEPAR","HASTAPAR","DESDEIMPAR","HASTAIMPAR"});


  		




  
  42
  
    
			lyrDef.setFieldNames(new String[] {"OBJECTID","COD_INE","COD_MUN"});


  		




  31
  43
  
    
			lyrDef.setSRID_EPSG("23030");


  		




  32
  44
  
    
	        lyrDef.setConnectionName("NOMBRE CONEXI?N");


  		




  33
  
  
    
			driver.setData(null, lyrDef);


  		




  
  45
  
    
	        assertNotNull("driver null ", driver);


  		




  
  46
  
    
	        ExtensionPoints extensionPoints = ExtensionPointsSingleton.getInstance();


  		




  
  47
  
    
	    	extensionPoints.add("databaseconnections",ConnectionSDE.class.toString(),ConnectionSDE.class);


  		




  
  48
  
    
	    	String connectionStr=driver.getConnectionString(lyrDef.getHost(),String.valueOf(lyrDef.getPort()), lyrDef.getDataBase(),lyrDef.getUser(), lyrDef.getPassword());


  		




  
  49
  
    
			IConnection conn = ConnectionFactory.createConnection(connectionStr, lyrDef.getUser(),lyrDef.getPassword());


  		




  
  50
  
    
		    driver.setData(conn, lyrDef);


  		




  34
  51
  
    

  		




  35
  
  
    
		}


  		




  36
  
  
    
		catch (Exception e){


  		




  37
  
  
    
			e.printStackTrace();


  		




  38
  
  
    
		}


  		




  39
  52
  
    
	}


  		




  40
  53
  
    

  		




  41
  54
  
    
	protected void tearDown() throws Exception {


  		




  42
  55
  
    
		super.tearDown();


  		




  43
  56
  
    
		driver.close();


  		




  44
  57
  
    
	}


  		




  
  58
  
    
	public void testConnection(){


  		




  45
  59
  
    

  		




  
  60
  
    
		assertTrue(driver.getConnection() instanceof ConnectionSDE);


  		




  
  61
  
    
	}


  		




  
  62
  
    
	public void testExtent() {


  		




  
  63
  
    
		assertNotNull("FullExtent",driver.getFullExtent());


  		




  
  64
  
    
	}


  		




  46
  65
  
    
	public void testGetFieldValue() {


  		




  47
  
  
    
		for (int i=0; i < 15; i++){


  		




  
  66
  
    
		for (int i=0; i < 3; i++){


  		




  48
  67
  
    
			//String aux = driver.getFieldValue(i, 0).toString();


  		




  49
  
  
    
			int id = ((NumericValue) driver.getFieldValue(i, 0)).intValue();


  		




  
  68
  
    
			Object id =  driver.getFieldValue(i, 0);


  		




  50
  69
  
    
			System.out.println(id);


  		




  51
  
  
    
			assertEquals(id,i+1);


  		




  
  70
  
    
			assertNotNull(id);


  		




  52
  71
  
    
		}


  		




  53
  72
  
    
	}


  		




  
  73
  
    
	public void testLayers() throws SeException {


  		




  
  74
  
    
		assertTrue(((ConnectionSDE)driver.getConnection()).getConnection().getLayers().capacity()>0);


  		




  
  75
  
    
	}


  		




  
  76
  
    

  		




  54
  77
  
    
}


  		












Also available in:  Unified diff