Package com.google.appengine.api.datastore

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

360
361
362
363
364
365
366
367
368
369
370
            String kind = getKind(type);
            Query query = new Query(kind);
            if (unreadOnly) {
                query.setFilter(new Query.FilterPredicate(TEMP_DATA_READ_PROPERTY, Query.FilterOperator.EQUAL, false));
            } else {
                query.addSort("timestamp", Query.SortDirection.ASCENDING);
            }
            PreparedQuery pq = ds.prepare(query);
            Iterator<Entity> iter = pq.asIterator();
            List<T> result = new ArrayList<>();
            while (iter.hasNext()) {
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
    @Test
    public void testSort() {
        int onePage = 6;
        Query query = new Query(kindName, rootKey);
        query.addSort("name", Query.SortDirection.ASCENDING);
        // fetch first page   aa,aa,aa,aa,aa,aa
        Cursor cursor = checkPage(query, null, null, onePage, onePage, testDat[0], testDat[0]);
        Cursor decodedCursor = Cursor.fromWebSafeString(cursor.toWebSafeString());
        // fetch next page    aa,aa,aa,aa,bb,bb
        checkPage(query, decodedCursor, null, onePage, onePage, testDat[0], testDat[1]);
View Full Code Here
89
90
91
92
93
94
95
96
97
98
99
        checkPage(query, decodedCursor, null, onePage, onePage, testDat[0], testDat[1]);

        // desc
        onePage = total / testDat.length;
        query = new Query(kindName, rootKey);
        query.addSort("name", Query.SortDirection.DESCENDING);
        // fetch first page   jj,jj,........,jj,jj
        String chkChar = testDat[testDat.length - 1];
        cursor = checkPage(query, null, null, onePage, onePage, chkChar, chkChar);
        decodedCursor = Cursor.fromWebSafeString(cursor.toWebSafeString());
        // fetch next page   ii,ii,........,ii,ii
View Full Code Here
114
115
116
117
118
119
120
121
122
123
124
    @Test
    public void testEndCursor() {
        int limit = total / testDat.length;
        Query query = new Query(kindName, rootKey);
        query.addSort("name", Query.SortDirection.ASCENDING);
        // fetch 1st page
        Cursor cursor = checkPage(query, null, null, limit, limit, testDat[0], testDat[0]);
        Cursor decodedCursor = Cursor.fromWebSafeString(cursor.toWebSafeString());
        // fetch 1st page again since using decodedCursor as end cursor
        checkPage(query, null, decodedCursor, limit, limit, testDat[0], testDat[0]);
View Full Code Here
126
127
128
129
130
131
132
133
134
135
136
    @Test
    public void testStartEndCursor() {
        int limit = total / testDat.length;
        Query query = new Query(kindName, rootKey);
        query.addSort("name", Query.SortDirection.ASCENDING);
        FetchOptions fetchOption = FetchOptions.Builder.withLimit(limit);
        // fetch 1st page and get cursor1
        QueryResultList<Entity> nextBatch = service.prepare(query)
            .asQueryResultList(fetchOption);
        Cursor cursor1 = Cursor.fromWebSafeString(nextBatch.getCursor().toWebSafeString());
View Full Code Here
146
147
148
149
150
151
152
153
154
155
156
    }

    @Test
    public void testReverse() {
        Query query = new Query(kindName, rootKey);
        query.addSort(Entity.KEY_RESERVED_PROPERTY);
        QueryResultIterator<Entity> iter = service.prepare(query).asQueryResultIterator();
        Entity e1 = iter.next();
        Entity e2 = iter.next();
        Cursor cursor = iter.getCursor();
        //reverse
View Full Code Here
66
67
68
69
70
71
72
73
74
75
76
    }

    @Test
    public void testKeyOrder() {
        Query query = new Query(kindName, rootKey);
        query.addSort("__key__");
        List<Entity> ascRecs = service.prepare(query).asList(withLimit(5));

        query = new Query(kindName, rootKey);
        query.addSort("__key__", Query.SortDirection.DESCENDING);
        List<Entity> descRecs = service.prepare(query).asList(withLimit(5));
View Full Code Here
70
71
72
73
74
75
76
77
78
79
80
        Query query = new Query(kindName, rootKey);
        query.addSort("__key__");
        List<Entity> ascRecs = service.prepare(query).asList(withLimit(5));

        query = new Query(kindName, rootKey);
        query.addSort("__key__", Query.SortDirection.DESCENDING);
        List<Entity> descRecs = service.prepare(query).asList(withLimit(5));

        int size = ascRecs.size();
        assertEquals(5, size);
        for (int i = 0; i < size; i++) {
View Full Code Here
89
90
91
92
93
94
95
96
97
98
99
        query.setFilter(new FilterPredicate("loc", Query.FilterOperator.EQUAL, "ae"));
        Key key = service.prepare(query).asSingleEntity().getKey();

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

        query = new Query(kindName, rootKey);
        query.setFilter(new FilterPredicate("__key__", Query.FilterOperator.GREATER_THAN, key));
        query.addSort("__key__", Query.SortDirection.DESCENDING);
View Full Code Here
94
95
96
97
98
99
100
101
102
103
104
        query.addSort("__key__");
        List<Entity> ascRecs = service.prepare(query).asList(withLimit(5));

        query = new Query(kindName, rootKey);
        query.setFilter(new FilterPredicate("__key__", Query.FilterOperator.GREATER_THAN, key));
        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
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.