Examples of org.geotools.data.Join

org.geotools.data.Join
Represents the joining of two feature types within a {@link Query}.
The Join class is similar to Query in that it allows one to specify a FeatureType name, a set of properties, and a filter. A Join must specify:
1. A type name that references the feature type to join to, see {@link #getTypeName()}
2. A join filter that describes how to join, see {@link #getJoinFilter()}
Optionally a Join may also specify:
- A set of property names constraining the attributes of joined features, see {@link #getProperties()}
- A secondary filter used to constrained features from the joined feature type, see {@link #getFilter()}
- An alias for the joined feature type, which can be used in the join filter to disambiguate attributes of the feature types being joined, see {@link #getAlias()}
- A join type specifying what type of join (inner, outer, etc...) should be performed, see {@link #getType()}
@author Justin Deoliveira, OpenGeo @since 8.0

        dataStore.setExposePrimaryKeyColumns(exposePrimaryKeys);
        FilterFactory ff = dataStore.getFilterFactory();


        Filter j = ff.equal(ff.property(aname("stringProperty")), ff.property(aname("name")), true); 
        Query q = new Query(tname("ft1"));
        q.getJoins().add(new Join(tname("ftjoin"), j));
        q.setSortBy(new SortBy[]{ff.sort(aname("intProperty"), SortOrder.DESCENDING)});


        SimpleFeatureCollection features = dataStore.getFeatureSource(tname("ft1")).getFeatures(q);
        SimpleFeatureIterator it = features.features();
        try {

View Full Code Here

        dataStore.setExposePrimaryKeyColumns(exposePrimaryKeys);
        FilterFactory ff = dataStore.getFilterFactory();
        
        Filter j = ff.equal(ff.property(aname("stringProperty")), ff.property(aname("name")), true); 
        Query q = new Query(tname("ft1"));
        q.getJoins().add(new Join(tname("ftjoin"), j));
        q.setFilter(ff.greater(ff.property(aname("intProperty")), ff.literal(0)));
        q.setStartIndex(1);
        q.setSortBy(new SortBy[]{ff.sort(aname("intProperty"), SortOrder.ASCENDING)});
        
        SimpleFeatureCollection features = dataStore.getFeatureSource(tname("ft1")).getFeatures(q);

View Full Code Here

    
    public void doTestSelfJoin(boolean exposePrimaryKeys) throws Exception {
        dataStore.setExposePrimaryKeyColumns(exposePrimaryKeys);
        FilterFactory ff = dataStore.getFilterFactory();
        Query q = new Query(tname("ft1"));
        q.getJoins().add(new Join(tname("ft1"), 
            ff.equal(ff.property(aname("intProperty")), ff.property(aname("foo.intProperty")), true)).alias(aname("foo")));
        q.setFilter(ff.equal(ff.property(aname("stringProperty")), ff.literal("two"), true));


        SimpleFeatureCollection features = dataStore.getFeatureSource(tname("ft1")).getFeatures(q);
        assertEquals(1, features.size());

View Full Code Here

        dataStore.setExposePrimaryKeyColumns(exposePrimaryKeys);
        FilterFactory2 ff = (FilterFactory2) dataStore.getFilterFactory();
        Query q = new Query(tname("ft1"));
        q.setPropertyNames(Arrays.asList(aname("geometry"), aname("intProperty")));
        q.setSortBy(new SortBy[]{ff.sort(aname("intProperty"), SortOrder.ASCENDING)});
        q.getJoins().add(new Join(tname("ftjoin"),
            ff.contains(ff.property(aname("geom")), ff.property(aname("geometry")))));


        SimpleFeatureCollection features = dataStore.getFeatureSource(tname("ft1")).getFeatures(q);
        assertEquals(6, features.size());

View Full Code Here

    
    void doTestOuterJoin(boolean exposePrimaryKeys) throws Exception {
        dataStore.setExposePrimaryKeyColumns(exposePrimaryKeys);
        FilterFactory ff = dataStore.getFilterFactory();
        Query q = new Query(tname("ftjoin"));
        q.getJoins().add(new Join(tname("ft1"), 
            ff.equal(ff.property(aname("name")), ff.property(aname("stringProperty")), true)).type(Type.OUTER));


        SimpleFeatureCollection features = dataStore.getFeatureSource(tname("ftjoin")).getFeatures(q);
        assertEquals(dataStore.getFeatureSource(tname("ftjoin")).getFeatures(q).size(), features.size());

View Full Code Here

    
    void doJoinMoreThanTwo(boolean exposePrimaryKeys) throws Exception {
        dataStore.setExposePrimaryKeyColumns(exposePrimaryKeys);
        FilterFactory ff = dataStore.getFilterFactory();
        Query q = new Query(tname("ftjoin"));
        q.getJoins().add(new Join(tname("ft1"), 
            ff.equal(ff.property(aname("name")), ff.property(aname("stringProperty")), true)));


        q.getJoins().add(new Join(tname("ftjoin2"), 
                ff.equal(ff.property(aname("join2intProperty")), ff.property(aname("join1intProperty")), true)));


        SimpleFeatureCollection features = dataStore.getFeatureSource(tname("ftjoin")).getFeatures(q);
        assertEquals(3, features.size());

View Full Code Here

                                        "join filters were found", metas.size(), extractor.getJoins().size()));
                            }


                            //validate the filter for each join
                            for (int j = 1; j < metas.size(); j++) {
                                Join join = joins.get(j-1);
                                if (join.getFilter() != null) {
                                    validateFilter(join.getFilter(), query, metas.get(j), request);
                                }
                            }


                            filter = extractor.getPrimaryFilter();
                            if (filter != null) {

View Full Code Here

        //do same for other secondary filters
        List<Filter> otherFilters = rewriteAndSort(unroll(this.filters), false);
        
        for (int i = 0; i < featureTypes.size(); i++) {
            String nativeName = featureTypes.get(i).getNativeName();
            Join join = new Join(nativeName, joinFilters.get(i+1));
            if (aliases != null) {
                join.setAlias(aliases.get(i));
            }
            if (otherFilters.get(i+1) != null) {
                join.setFilter(otherFilters.get(i+1));
            }
            joins.add(join);
        }


        return joins;

View Full Code Here

        Filter primary = visitor.getPrimaryFilter();
        assertNull(primary);


        List<Join> joins = visitor.getJoins();
        assertEquals(1, joins.size());
        Join join = joins.get(0);
        assertEquals("Forests", join.getTypeName());
        assertEquals("b", join.getAlias());
        assertEquals(ff.equals(ff.property("a.FID"), ff.property("b.FID")), join.getJoinFilter());
    }

View Full Code Here

        assertNull(primary);


        List<Join> joins = visitor.getJoins();
        assertEquals(2, joins.size());


        Join j1 = joins.get(0);
        assertEquals("Lakes", j1.getTypeName());
        assertEquals("a", j1.getAlias());
        assertEquals(ff.equals(ff.property("a.FID"), ff.property("b.FID")), j1.getJoinFilter());


        Join j2 = joins.get(1);
        assertEquals("Buildings", j2.getTypeName());
        assertEquals("c", j2.getAlias());
        assertEquals(ff.equals(ff.property("b.FID"), ff.property("c.FID")), j2.getJoinFilter());
    }

View Full Code Here

0 1 2

TOP

Related Classes of org.geotools.data.Join

org.geoserver.wfs.GetFeature

org.geoserver.wfs.JoinExtractingVisitor

org.geoserver.wfs.JoinExtractingVisitorTest

org.geotools.jdbc.JDBCJoinTest

org.geotools.jdbc.JDBCTemporalFilterTest

org.geotools.jdbc.JoinInfo

java.util.ArrayList

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.