Examples of com.google.appengine.api.datastore.Query.addProjection()

Package com.google.appengine.api.datastore

Class com.google.appengine.api.datastore.Query

Examples of com.google.appengine.api.datastore.Query.addProjection()

com.google.appengine.api.datastore.Query.addProjection()
Adds a projection for this query.
Projections are limited in the following ways:
- Un-indexed properties cannot be projected and attempting to do so will result in no entities being returned.
- Projection {@link Projection#getName() names} must be unique.
- Properties that have an equality filter on them cannot be projected. This includes the operators {@link FilterOperator#EQUAL} and {@link FilterOperator#IN}.
@see #getProjections() @param projection the projection to add @return {@code this} (for chaining) @throws IllegalArgumentException if the query already contains a projection with the same name

        query.setDistinct(true);
        assertEquals(7, service.prepare(query).countEntities(fo));
        assertTrue(query.getDistinct());
        // distinct false
        query = new Query(kindName, rootKey);
        query.addProjection(new PropertyProjection("stringData", String.class));
        query.addProjection(new PropertyProjection("floatData", Float.class));
        query.setDistinct(false);
        assertEquals(count, service.prepare(query).countEntities(fo));
        assertFalse(query.getDistinct());
    }

View Full Code Here

        assertEquals(7, service.prepare(query).countEntities(fo));
        assertTrue(query.getDistinct());
        // distinct false
        query = new Query(kindName, rootKey);
        query.addProjection(new PropertyProjection("stringData", String.class));
        query.addProjection(new PropertyProjection("floatData", Float.class));
        query.setDistinct(false);
        assertEquals(count, service.prepare(query).countEntities(fo));
        assertFalse(query.getDistinct());
    }

View Full Code Here

    }


    @Test
    public void testDistinctSort() {
        Query query = new Query(kindName, rootKey);
        query.addProjection(new PropertyProjection("stringData", String.class));
        query.addProjection(new PropertyProjection("floatData", Float.class));
        query.addSort("stringData", Query.SortDirection.DESCENDING);
        query.setDistinct(true);
        assertEquals(7, service.prepare(query).countEntities(fo));
        assertTrue(query.getDistinct());

View Full Code Here


    @Test
    public void testDistinctSort() {
        Query query = new Query(kindName, rootKey);
        query.addProjection(new PropertyProjection("stringData", String.class));
        query.addProjection(new PropertyProjection("floatData", Float.class));
        query.addSort("stringData", Query.SortDirection.DESCENDING);
        query.setDistinct(true);
        assertEquals(7, service.prepare(query).countEntities(fo));
        assertTrue(query.getDistinct());
        query.addSort("floatData", Query.SortDirection.DESCENDING);

View Full Code Here

    }


    @Test
    public void testDistinctFilter() {
        Query query = new Query(kindName, rootKey);
        query.addProjection(new PropertyProjection("stringData", String.class));
        query.addProjection(new PropertyProjection("floatData", Float.class));
        query.setFilter(new FilterPredicate("stringData", Query.FilterOperator.NOT_EQUAL, "string1"));
        query.addSort("stringData", Query.SortDirection.DESCENDING);
        query.setDistinct(true);
        assertEquals(5, service.prepare(query).countEntities(fo));

View Full Code Here


    @Test
    public void testDistinctFilter() {
        Query query = new Query(kindName, rootKey);
        query.addProjection(new PropertyProjection("stringData", String.class));
        query.addProjection(new PropertyProjection("floatData", Float.class));
        query.setFilter(new FilterPredicate("stringData", Query.FilterOperator.NOT_EQUAL, "string1"));
        query.addSort("stringData", Query.SortDirection.DESCENDING);
        query.setDistinct(true);
        assertEquals(5, service.prepare(query).countEntities(fo));
        assertTrue(query.getDistinct());

View Full Code Here

    }


    @Test
    public void testDistinctFilter2() {
        Query query = new Query(kindName, rootKey);
        query.addProjection(new PropertyProjection("stringData", String.class));
        query.addProjection(new PropertyProjection("floatData", Float.class));
        query.setFilter(new FilterPredicate("stringData", Query.FilterOperator.GREATER_THAN,
            "string0"));
        query.addSort("stringData", Query.SortDirection.DESCENDING);
        query.addSort("floatData", Query.SortDirection.DESCENDING);

View Full Code Here


    @Test
    public void testDistinctFilter2() {
        Query query = new Query(kindName, rootKey);
        query.addProjection(new PropertyProjection("stringData", String.class));
        query.addProjection(new PropertyProjection("floatData", Float.class));
        query.setFilter(new FilterPredicate("stringData", Query.FilterOperator.GREATER_THAN,
            "string0"));
        query.addSort("stringData", Query.SortDirection.DESCENDING);
        query.addSort("floatData", Query.SortDirection.DESCENDING);
        query.setDistinct(true);

View Full Code Here

    }


    @Test
    public void testWithPropertyProjection() {
        Query query = new Query(kindName, rootKey);
        query.addProjection(new PropertyProjection("geoptData", GeoPt.class));
        Filter filter1 = Query.CompositeFilterOperator.or(
            Query.FilterOperator.LESS_THAN.of("intList", 5),
            Query.FilterOperator.GREATER_THAN.of("intList", 90));
        Filter filter2 = Query.FilterOperator.EQUAL.of("intList", 52);
        query.setFilter(Query.CompositeFilterOperator.and(filter1, filter2));

View Full Code Here

    @Test
    public void testProjection() {
        Query query = new Query(kindName, rootKey);
        Projection pp = new PropertyProjection("stringData", String.class);
        assertEquals("stringData", pp.getName());
        query.addProjection(pp);
        assertEquals(1, query.getProjections().size());
        pp = new PropertyProjection("intData", Integer.class);
        query.addProjection(pp);
        for (Projection p : query.getProjections()) {
            String pName = p.getName();

View Full Code Here

0 1 2 3

TOP

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.