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

Package com.google.appengine.api.datastore

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

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

com.google.appengine.api.datastore.Query.addSort()
google.com/appengine/docs/java/datastore"> datastore documentation. @return {@code this} (for chaining) @throws NullPointerException If any argument is null.

        Key key = service.prepare(query).asSingleEntity().getKey();


        query = new Query(kindName, rootKey);
        query.setFilter(new FilterPredicate("__key__", Query.FilterOperator.LESS_THAN, key));
        query.setFilter(new FilterPredicate("loc", Query.FilterOperator.EQUAL, "ac"));
        query.addSort("__key__");
        List<Entity> ascRecs = service.prepare(query).asList(withLimit(5));


        query = new Query(kindName, rootKey);
        query.setFilter(new FilterPredicate("__key__", Query.FilterOperator.LESS_THAN, key));
        query.setFilter(new FilterPredicate("loc", Query.FilterOperator.EQUAL, "ac"));

View Full Code Here

        List<Entity> ascRecs = service.prepare(query).asList(withLimit(5));


        query = new Query(kindName, rootKey);
        query.setFilter(new FilterPredicate("__key__", Query.FilterOperator.LESS_THAN, key));
        query.setFilter(new FilterPredicate("loc", Query.FilterOperator.EQUAL, "ac"));
        query.addSort("__key__", Query.SortDirection.DESCENDING);
        List<Entity> descRecs = service.prepare(query).asList(withLimit(5));


        int size = ascRecs.size();
        for (int i = 0; i < size; i++) {
            assertEquals(ascRecs.get(i).getProperty("pop").toString(),

View Full Code Here

        Query query = new Query(kindName, rootKey);
        Filter filter = Query.CompositeFilterOperator.and(
            Query.FilterOperator.LESS_THAN_OR_EQUAL.of("intData", 40),
            Query.FilterOperator.GREATER_THAN.of("intData", 0));
        query.setFilter(filter);
        query.addSort("intData", Query.SortDirection.DESCENDING);
        List<Entity> es = service.prepare(query).asList(fo);
        assertEquals("check return count", 2, es.size());
        assertEquals("check query filter", filter, query.getFilter());
        assertEquals("check query key only", false, query.isKeysOnly());

View Full Code Here

    }


    @Test
    public void testSortPredicates() {
        Query query = new Query(kindName, rootKey);
        query.addSort("intData", Query.SortDirection.DESCENDING);
        List<Entity> es = service.prepare(query).asList(fo);
        assertEquals((long) 40, es.get(0).getProperty("intData"));
        List<Query.SortPredicate> qsp = query.getSortPredicates();
        assertEquals("check SortPredicate name", "intData", qsp.get(0).getPropertyName());
        assertEquals("check SortPredicate direction", Query.SortDirection.DESCENDING, qsp.get(0).getDirection());

View Full Code Here

    }


    @Test
    public void testReverse() throws Exception {
        final Query query = new Query(kindName, rootKey);
        query.addSort(Entity.KEY_RESERVED_PROPERTY);
        query.addSort("intData");


        List<Entity> list1 = service.prepare(query).asList(FetchOptions.Builder.withDefaults());
        List<Entity> list2 = service.prepare(query.reverse()).asList(FetchOptions.Builder.withDefaults());

View Full Code Here


    @Test
    public void testReverse() throws Exception {
        final Query query = new Query(kindName, rootKey);
        query.addSort(Entity.KEY_RESERVED_PROPERTY);
        query.addSort("intData");


        List<Entity> list1 = service.prepare(query).asList(FetchOptions.Builder.withDefaults());
        List<Entity> list2 = service.prepare(query.reverse()).asList(FetchOptions.Builder.withDefaults());


        int size = list1.size();

View Full Code Here

        newRec.setProperty("timestamp", new Date());
        service.put(newRec);


        query = new Query("indextest2");
        query.setFilter(new FilterPredicate("stringData", Query.FilterOperator.LESS_THAN, "bdefgh"));
        query.addSort("stringData", Query.SortDirection.DESCENDING);
        query.addSort("age");
        for (Entity readRec : service.prepare(query).asIterable()) {
            // fetch entities for index creation.
        }
        service.prepare(query).asIterable();

View Full Code Here

        service.put(newRec);


        query = new Query("indextest2");
        query.setFilter(new FilterPredicate("stringData", Query.FilterOperator.LESS_THAN, "bdefgh"));
        query.addSort("stringData", Query.SortDirection.DESCENDING);
        query.addSort("age");
        for (Entity readRec : service.prepare(query).asIterable()) {
            // fetch entities for index creation.
        }
        service.prepare(query).asIterable();
    }

View Full Code Here


    @Test
    public void testQueryOrder() {
        Query query = new Query(kindName, rootKey);
        query.addProjection(new PropertyProjection("intData", Integer.class));
        query.addSort("stringData", Query.SortDirection.DESCENDING);
        List<Entity> results = service.prepare(query).asList(fetchOption);
        assertEquals(count, results.size());
        int first = new Integer(results.get(0).getProperty("intData").toString());
        int last = new Integer(results.get(count - 1).getProperty("intData").toString());
        assertTrue(first > last);

View Full Code Here

    @Test
    public void testQueryFilter() {
        Query query = new Query(kindName, rootKey);
        query.addProjection(new PropertyProjection("stringData", String.class));
        query.setFilter(new FilterPredicate("intData", FilterOperator.NOT_EQUAL, 50));
        query.addSort("intData");
        List<Entity> results = service.prepare(query).asList(fetchOption);
        assertEquals(count - 1, results.size());
        for (Entity e : results) {
            assertTrue(e.getProperty("stringData").toString().contains("5") == false);
        }

View Full Code Here

0 1 2 3 4 5 6 7 8

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.