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/TestSelectWithLocalVariables.java

View differences:

TestSelectWithLocalVariables.java
8 8 
import org.gvsig.expressionevaluator.LexicalAnalyzer;
9 9 
import org.gvsig.expressionevaluator.MutableSymbolTable;
10 10 
import org.gvsig.expressionevaluator.SymbolTable;
11 
import org.gvsig.fmap.dal.DALLocator;
12 
import org.gvsig.fmap.dal.DataManager;
13 
import org.gvsig.fmap.dal.feature.FeatureStore;
14 11 
import org.gvsig.fmap.dal.store.jdbc2.AbstractTestUtils;
15 
import org.gvsig.fmap.dal.store.jdbc2.JDBCServerExplorer;
16 12 
import org.gvsig.sqlite.dal.TestUtilsSQLite;
17 13 
import org.gvsig.tools.library.impl.DefaultLibrariesInitializer;
18 14 
import org.slf4j.Logger;
......
85 81 

  		




  86
  82
  
    
    public void testSelectWithLocalVariables() throws Exception {


  		




  87
  83
  
    
        try {


  		




  88
  
  
    
            FeatureStore sourceStore = utils().openCountriesStore();


  		




  
  84
  
    
//            FeatureStore sourceStore = utils().openCountriesStore();


  		




  
  85
  
    
//            


  		




  
  86
  
    
//            JDBCServerExplorer explorer = utils().openServerExplorer("testCountXXXXX");


  		




  
  87
  
    
//


  		




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


  		




  
  89
  
    
//            utils().drop_tables(explorer, sourceStore.getName());


  		




  
  90
  
    
//


  		




  
  91
  
    
//            utils().create_table_from(explorer, sourceStore.getName(), sourceStore);


  		




  
  92
  
    
//            utils().insert_into_from(explorer, sourceStore.getName(), sourceStore, FeatureStore.MODE_APPEND);


  		




  
  93
  
    
//            


  		




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


  		




  
  95
  
    
//            dataManager.getStoresRepository().add(sourceStore.getName(), explorer.get(sourceStore.getName()));


  		




  89
  96
  
    
            


  		




  90
  
  
    
            JDBCServerExplorer explorer = utils().openServerExplorer("testCountXXXXX");


  		




  91
  
  
    

  		




  92
  
  
    
            utils().info_jdbc(explorer);


  		




  93
  
  
    
            utils().drop_tables(explorer, sourceStore.getName());


  		




  94
  
  
    

  		




  95
  
  
    
            utils().create_table_from(explorer, sourceStore.getName(), sourceStore);


  		




  96
  
  
    
            utils().insert_into_from(explorer, sourceStore.getName(), sourceStore, FeatureStore.MODE_APPEND);


  		




  97
  
  
    
            


  		




  98
  
  
    
            DataManager dataManager = DALLocator.getDataManager();


  		




  99
  
  
    
            dataManager.getStoresRepository().add(sourceStore.getName(), explorer.get(sourceStore.getName()));


  		




  100
  
  
    
            


  		




  101
  97
  
    
            StringBuilder source = new StringBuilder();


  		




  102
  98
  
    
            source.append("BEGIN ");


  		




  103
  99
  
    
            source.append("CREATE PROCEDURE fn1() AS");


  		












Also available in:  Unified diff