Revision 47606 trunk/org.gvsig.desktop/org.gvsig.desktop.plugin/org.gvsig.sqlite/org.gvsig.sqlite.provider/src/test/java/org/gvsig/sqlite/dal/operations/usecases/arena2/TestSelectArena2A.java

View differences:

TestSelectArena2A.java
10 10 
import org.gvsig.expressionevaluator.LexicalAnalyzer;
11 11 
import org.gvsig.expressionevaluator.MutableSymbolTable;
12 12 
import org.gvsig.expressionevaluator.SymbolTable;
13 
import org.gvsig.fmap.dal.DALLocator;
14 
import org.gvsig.fmap.dal.DataManager;
15 
import org.gvsig.fmap.dal.feature.FeatureStore;
16 13 
import org.gvsig.fmap.dal.store.jdbc2.AbstractTestUtils;
17 
import org.gvsig.fmap.dal.store.jdbc2.JDBCServerExplorer;
18 14 
import org.gvsig.sqlite.dal.TestUtilsSQLite;
19 15 
import org.gvsig.tools.library.impl.DefaultLibrariesInitializer;
20 16 
import org.slf4j.Logger;
......
110 106 

  		




  111
  107
  
    
    public void testSelectArena2A() throws Exception {


  		




  112
  108
  
    
        try {


  		




  113
  
  
    
            FeatureStore sourceStoreConductores = utils().openCSVStore("usecases/arena2/ARENA2_CONDUCTORES.csv");


  		




  114
  
  
    
            FeatureStore sourceStoreVehiculos = utils().openCSVStore("usecases/arena2/ARENA2_VEHICULOS.csv");


  		




  
  109
  
    
//            FeatureStore sourceStoreConductores = utils().openCSVStore("usecases/arena2/ARENA2_CONDUCTORES.csv");


  		




  
  110
  
    
//            FeatureStore sourceStoreVehiculos = utils().openCSVStore("usecases/arena2/ARENA2_VEHICULOS.csv");


  		




  
  111
  
    
//            


  		




  
  112
  
    
//            JDBCServerExplorer explorer = utils().openServerExplorer("testSelectArena2A");


  		




  
  113
  
    
//


  		




  
  114
  
    
//            utils().info_jdbc(explorer);


  		




  
  115
  
    
//            utils().drop_tables(explorer, sourceStoreConductores.getName());


  		




  
  116
  
    
//            utils().drop_tables(explorer, sourceStoreVehiculos.getName());


  		




  
  117
  
    
//


  		




  
  118
  
    
//            utils().create_table_from(explorer, sourceStoreConductores.getName(), sourceStoreConductores);


  		




  
  119
  
    
//            utils().create_table_from(explorer, sourceStoreVehiculos.getName(), sourceStoreVehiculos);


  		




  
  120
  
    
//            utils().insert_into_from(explorer, sourceStoreConductores.getName(), sourceStoreConductores, FeatureStore.MODE_APPEND);


  		




  
  121
  
    
//            utils().insert_into_from(explorer, sourceStoreVehiculos.getName(), sourceStoreVehiculos, FeatureStore.MODE_APPEND);


  		




  
  122
  
    
//            


  		




  
  123
  
    
//            DataManager dataManager = DALLocator.getDataManager();


  		




  
  124
  
    
//            dataManager.getStoresRepository().add(sourceStoreConductores.getName(), explorer.get(sourceStoreConductores.getName()));


  		




  
  125
  
    
//            dataManager.getStoresRepository().add(sourceStoreVehiculos.getName(), explorer.get(sourceStoreVehiculos.getName()));


  		




  115
  126
  
    
            


  		




  116
  
  
    
            JDBCServerExplorer explorer = utils().openServerExplorer("testSelectArena2A");


  		




  117
  
  
    

  		




  118
  
  
    
            utils().info_jdbc(explorer);


  		




  119
  
  
    
            utils().drop_tables(explorer, sourceStoreConductores.getName());


  		




  120
  
  
    
            utils().drop_tables(explorer, sourceStoreVehiculos.getName());


  		




  121
  
  
    

  		




  122
  
  
    
            utils().create_table_from(explorer, sourceStoreConductores.getName(), sourceStoreConductores);


  		




  123
  
  
    
            utils().create_table_from(explorer, sourceStoreVehiculos.getName(), sourceStoreVehiculos);


  		




  124
  
  
    
            utils().insert_into_from(explorer, sourceStoreConductores.getName(), sourceStoreConductores, FeatureStore.MODE_APPEND);


  		




  125
  
  
    
            utils().insert_into_from(explorer, sourceStoreVehiculos.getName(), sourceStoreVehiculos, FeatureStore.MODE_APPEND);


  		




  126
  
  
    
            


  		




  127
  
  
    
            DataManager dataManager = DALLocator.getDataManager();


  		




  128
  
  
    
            dataManager.getStoresRepository().add(sourceStoreConductores.getName(), explorer.get(sourceStoreConductores.getName()));


  		




  129
  
  
    
            dataManager.getStoresRepository().add(sourceStoreVehiculos.getName(), explorer.get(sourceStoreVehiculos.getName()));


  		




  130
  
  
    
            


  		




  131
  127
  
    
            StringBuilder source = new StringBuilder();


  		




  132
  128
  
    
            source.append("SELECT * FROM ARENA2_CONDUCTORES  WHERE ARENA2_CONDUCTORES.LID_VEHICULO = ARENA2_VEHICULOS.LID_VEHICULO");


  		




  133
  129
  
    

  		












Also available in:  Unified diff