Application: gvSIG desktop

import org.gvsig.fmap.dal.DALLocator;

import org.gvsig.fmap.dal.DataManager;

    public void testSubselect2() throws Exception {

        JDBCHelper helper = TestUtils.createJDBCHelper();

        JDBCSQLBuilderBase sqlbuilder = helper.createSQLBuilder();

        OperationsFactory operations = helper.getOperations();

        DataManager dataManager = DALLocator.getDataManager();

        Expecteds expectedSQLs = utils().getExpecteds("resultSetForSetProvider.sql");

        FeatureStore sourceStore = TestUtils.openSourceStore1();

        dataManager.getStoresRepository().add(sourceStore.getName(), sourceStore);

        FeatureStore countriesStore = TestUtils.openCountriesStore();

        dataManager.getStoresRepository().add(countriesStore.getName(), countriesStore);

        TableReference table = operations.createTableReference(

                "dbtest",

                sqlbuilder.default_schema(),

                "test",

                null

        );

        StringBuilder filter = new StringBuilder();

        filter.append("EXISTS(");

        filter.append(" SELECT \"Long\" FROM countries");

        filter.append("   WHERE ");

        filter.append("     TEST.STRING = countries.CONTINENT AND ");

        filter.append("     countries.LASTCENSUS < 0 ");

        filter.append("   LIMIT 1;, ");

        filter.append(" 'EXISTS62a964cd7bc24f409b97c03b9170408d' ");

        filter.append(")");

        FeatureType featureType = sourceStore.getDefaultFeatureType();

        FeatureQuery query = sourceStore.createFeatureQuery();

        query.addFilter(filter.toString());

        ResultSetForSetProviderOperation resultSetForSetProvider = operations.createResultSetForSetProvider(

                table,

                null,

                null,

                query,

                featureType,

                featureType,

                0,

                0,

                0

        );

        String sql = resultSetForSetProvider.getSQL();

        utils().output_results("testSubselect2", sql, expectedSQLs.get("testSubselect2"));

        assertEquals("ResultSetForSetProvider SQL", expectedSQLs.get("testSubselect2"), sql);

    }