Application: gvSIG desktop

package org.gvsig.fmap.dal.store.csv;

import java.util.List;

import junit.framework.TestCase;

import static junit.framework.TestCase.assertEquals;

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

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

import org.gvsig.tools.library.impl.DefaultLibrariesInitializer;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

public class TestFilter1 extends TestCase {

  private static final Logger LOGGER = LoggerFactory.getLogger(TestFilter1.class);

  public TestFilter1(String testName) {

    super(testName);

  }

  @Override

  protected void setUp() throws Exception {

    super.setUp();

    new DefaultLibrariesInitializer().fullInitialize();

  }

  @Override

  protected void tearDown() throws Exception {

    super.tearDown();

  }

  // TODO add test methods here. The name must begin with 'test'. For example:

  // public void testHello() {}

  public void testSimpleFilter1() throws Exception {

    TestUtils.initialiceRepository();

    FeatureStore countries = TestUtils.openSourceCountries();

    List<Feature> features = countries.getFeatures("LASTCENSUS > 0");

    assertEquals("Filter: LASTCENSUS > 0", features.size(), 209);

  }

  public void testSimpleFilter2() throws Exception {

    TestUtils.initialiceRepository();

    FeatureStore countries = TestUtils.openSourceCountries();

    List<Feature> features = countries.getFeatures("countries.LASTCENSUS > 0");

    assertEquals("Filter: countries.LASTCENSUS > 0", features.size(), 209);

  }

  public void testSubselectFilter1() throws Exception {

    TestUtils.initialiceRepository();

    // Sobre la tabla de continentes, para obtener la lista de continentes 

    // que tienen paises asociados a Gran Breta?a.

    // Filtramos continentes por un campo del pais.

    StringBuilder filter = new StringBuilder();

    filter.append("EXISTS(");

    filter.append(" SELECT * FROM countries");

    filter.append("   WHERE ");

    filter.append("     continents.NAME = countries.CONTINENT AND ");

    filter.append("     countries.SOV_A3 = 'GB1' "); //FR1=4, GB1=6

    filter.append("   LIMIT 1; ");

    filter.append(")");

    FeatureStore continents = TestUtils.openSourceContinents();

    List<Feature> features = continents.getFeatures(filter.toString());

    assertEquals("Filter: subselect GB1", features.size(), 6);

  }

  public void testSubselectFilter2() throws Exception {

    TestUtils.initialiceRepository();

    // Sobre la tabla de continentes, para obtener la lista de continentes 

    // que tienen paises asociados a Francia.

    StringBuilder filter = new StringBuilder();

    filter.append("EXISTS(");

    filter.append(" SELECT 1 FROM countries");

    filter.append("   WHERE ");

    filter.append("     continents.NAME = countries.CONTINENT AND ");

    filter.append("     countries.SOV_A3 = 'FR1' "); //FR1=4, GB1=6

    filter.append("   LIMIT 1; ");

    filter.append(")");

    FeatureStore continents = TestUtils.openSourceContinents();

    List<Feature> features = continents.getFeatures(filter.toString());

    assertEquals("Filter: subselect FR1", features.size(), 4);

  }

}