Revision 44678 trunk/org.gvsig.desktop/org.gvsig.desktop.compat.cdc/org.gvsig.fmap.dal/org.gvsig.fmap.dal.db/org.gvsig.fmap.dal.db.h2/src/test/java/org/gvsig/fmap/dal/store/h2/TestUtils.java

View differences:

TestUtils.java
2 2 

  		




  3
  3
  
    
import java.io.File;


  		




  4
  4
  
    
import java.net.URL;


  		




  
  5
  
    
import java.util.ArrayList;


  		




  
  6
  
    
import java.util.List;


  		




  
  7
  
    
import org.apache.commons.io.FileUtils;


  		




  
  8
  
    
import org.apache.commons.lang3.StringUtils;


  		




  5
  9
  
    
import org.gvsig.fmap.dal.DALLocator;


  		




  6
  10
  
    
import org.gvsig.fmap.dal.DataManager;


  		




  7
  11
  
    
import org.gvsig.fmap.dal.DataServerExplorerParameters;


  		




  8
  12
  
    
import org.gvsig.fmap.dal.DataStore;


  		




  9
  13
  
    
import org.gvsig.fmap.dal.DatabaseWorkspaceManager;


  		




  
  14
  
    
import org.gvsig.fmap.dal.feature.Feature;


  		




  10
  15
  
    
import org.gvsig.fmap.dal.feature.FeatureStore;


  		




  
  16
  
    
import org.gvsig.fmap.dal.feature.impl.DefaultFeature;


  		




  
  17
  
    
import org.gvsig.fmap.dal.feature.spi.FeatureProvider;


  		




  11
  18
  
    
import org.gvsig.fmap.dal.store.jdbc2.JDBCServerExplorer;


  		




  12
  19
  
    
import org.slf4j.Logger;


  		




  13
  20
  
    
import org.slf4j.LoggerFactory;


  		




  ......




  26
  33
  
    
                dataManager.createServerExplorerParameters(H2SpatialLibrary.NAME);


  		




  27
  34
  
    

  		




  28
  35
  
    
        File dbfile = TestUtils.getResource(String.format(


  		




  29
  
  
    
                "db/%s-%d-%03d",


  		




  
  36
  
    
                "test-dbs/%s-%d-%03d",


  		




  30
  37
  
    
                dbname,


  		




  31
  38
  
    
                System.currentTimeMillis(), 


  		




  32
  39
  
    
                dbcounter++


  		




  ......




  75
  82
  
    

  		




  76
  83
  
    
    public static FeatureStore openSourceStore1() throws Exception {


  		




  77
  84
  
    
        DataManager dataManager = DALLocator.getDataManager();


  		




  78
  
  
    
        File f = getResourceAsFile("/org/gvsig/fmap/dal/store/testCreateSource1.csv");


  		




  
  85
  
    
        File f = getResourceAsFile("/org/gvsig/fmap/dal/store/h2/testCreateSource1.csv");


  		




  79
  86
  
    
        FeatureStore store = (FeatureStore) dataManager.openStore(


  		




  80
  87
  
    
                DataStore.CSV_PROVIDER_NAME, 


  		




  81
  88
  
    
                "file=",f,


  		




  ......




  84
  91
  
    
        );


  		




  85
  92
  
    
        return store;


  		




  86
  93
  
    
    }


  		




  
  94
  
    
 


  		




  
  95
  
    

  		




  
  96
  
    
    public static List<String> getSQLs(String name) throws Exception {


  		




  
  97
  
    
      File f = getResourceAsFile("/org/gvsig/fmap/dal/store/h2/"+name);


  		




  
  98
  
    
      List<String> SQLs = new ArrayList<>();


  		




  
  99
  
    
      List<String> lines = FileUtils.readLines(f);


  		




  
  100
  
    
      StringBuilder sb = new StringBuilder();


  		




  
  101
  
    
      for (String line : lines) {


  		




  
  102
  
    
        line = StringUtils.stripStart(line, null);


  		




  
  103
  
    
        if( line.startsWith("--") ) {


  		




  
  104
  
    
          continue;


  		




  
  105
  
    
        }


  		




  
  106
  
    
        if( line.endsWith(";") ) {


  		




  
  107
  
    
          sb.append(line.substring(0, line.length()-1));


  		




  
  108
  
    
          SQLs.add(sb.toString());


  		




  
  109
  
    
          sb.setLength(0);


  		




  
  110
  
    
        } else {


  		




  
  111
  
    
          sb.append(line);


  		




  
  112
  
    
        }


  		




  
  113
  
    
      }


  		




  
  114
  
    
      return SQLs;


  		




  
  115
  
    
    }


  		




  87
  116
  
    
    


  		




  
  117
  
    
    public static FeatureProvider getFeatureProvider(Feature feature) {


  		




  
  118
  
    
      return ((DefaultFeature)feature).getData();


  		




  
  119
  
    
    }


  		




  88
  120
  
    
}


  		












Also available in:  Unified diff