Package com.google.appengine.api.datastore.Query

Examples of com.google.appengine.api.datastore.Query.FilterPredicate

174
175
176
177
178
179
180
181
182
183
184
    @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);
        assertEquals(2, service.prepare(query).countEntities(fo));
View Full Code Here
58
59
60
61
62
63
64
65
66
67
        storeTestEntityWithSingleProperty(parentKey, Arrays.asList(1, 2));
        assertSet(
            queryReturnsNothing(),
            whenFilteringWith(and(
                new FilterPredicate(SINGLE_PROPERTY_NAME, GREATER_THAN, 1),
                new FilterPredicate(SINGLE_PROPERTY_NAME, LESS_THAN, 2)),
                parentKey)
        );
    }
View Full Code Here
77
78
79
80
81
82
83
84
85
86

        assertSet(
            queryReturns(entity),
            whenFilteringWith(and(
                new FilterPredicate(SINGLE_PROPERTY_NAME, EQUAL, 1),
                new FilterPredicate(SINGLE_PROPERTY_NAME, EQUAL, 2)),
                parentKey)
        );
    }
View Full Code Here
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
        Entity entity123 = storeTestEntityWithSingleProperty(parentKey, Arrays.asList(1, 2, 3));

        // The NOT_EQUAL operator works as a "value is other than" test.
        assertSet(
            queryReturns(entity12, entity123),
            whenFilteringWith(new FilterPredicate(SINGLE_PROPERTY_NAME, NOT_EQUAL, 1), parentKey));

        assertSet(
            queryReturns(entity123),
            whenFilteringWith(and(
                new FilterPredicate(SINGLE_PROPERTY_NAME, NOT_EQUAL, 1),
                new FilterPredicate(SINGLE_PROPERTY_NAME, NOT_EQUAL, 2)),
                parentKey)
        );    // NOTE: should only match entity123, but not entity12

    }
View Full Code Here
67
68
69
70
71
72
73
74
75
76
77
    @Test
    public void testFilter() {
        int onePage = 5;
        String filterData = "ff";
        Query query = new Query(kindName, rootKey);
        query.setFilter(new FilterPredicate("name", Query.FilterOperator.EQUAL, filterData));
        // fetch first page
        Cursor cursor = checkPage(query, null, null, onePage, onePage, filterData, filterData);
        Cursor decodedCursor = Cursor.fromWebSafeString(cursor.toWebSafeString());
        // fetch next page
        checkPage(query, decodedCursor, null, onePage, onePage, filterData, filterData);
View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
    }

    @Test
    public void testWithIneqi() {
        Query query = new Query(kindName, rootKey);
        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);
        List<Entity> descRecs = service.prepare(query).asList(withLimit(5));

        int size = ascRecs.size();
        for (int i = 0; i < size; i++) {
View Full Code Here
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
    }

    @Test
    public void testWithIneqiAndFilter() {
        Query query = new Query(kindName, rootKey);
        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.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"));
        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++) {
View Full Code Here
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
        }
        // query in same namespace
        for (int i = 0; i < namespaceDat.length; i++) {
            NamespaceManager.set(namespaceDat[i]);
            Query q = new Query(kindTest);
            q.setFilter(new FilterPredicate("__key__", Query.FilterOperator.EQUAL, kList.get(i)));
            if (namespaceDat[i].equals("")) {
                assertEquals(service.prepare(q).asSingleEntity().getProperty("jobType"),
                    "google");
            } else {
                assertEquals(service.prepare(q).asSingleEntity().getProperty("jobType"),
                    namespaceDat[i]);
            }
        }
        // query in different namespace
        NamespaceManager.set(namespaceDat[1]);
        Query q = new Query(kindTest);
        q.setFilter(new FilterPredicate("__key__", Query.FilterOperator.EQUAL, kList.get(2)));

        service.prepare(q).asSingleEntity();
    }
View Full Code Here
164
165
166
167
168
169
170
171
172
173
174
    }

    @Test
    public void testFilterPredicate() {
        Query query = new Query(kindName, rootKey);
        query.setFilter(new FilterPredicate("intData", Query.FilterOperator.EQUAL, 20));
        Entity e = service.prepare(query).asSingleEntity();
        assertEquals("check query kind", kindName, query.getKind());
        assertEquals("check query ancesor", rootKey, query.getAncestor());
        Query.FilterPredicate fp = (Query.FilterPredicate) query.getFilter();
        assertEquals("check FilterPredicate name", "intData", fp.getPropertyName());
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
        newRec.setProperty("age", 9);
        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.
        }
View Full Code Here
TOP

Related Classes of com.google.appengine.api.datastore.Query.FilterPredicate

  • com.antonytrupe.server.battledisks.API
  • com.antonytrupe.server.ImageServlet
  • com.antonytrupe.server.PageServiceImpl
  • com.fms.kccc.server.Datastore
  • com.google.appengine.codelab.Datastore
  • com.google.appengine.codelab.Fraude
  • com.google.appengine.codelab.Sessao
  • com.google.appengine.codelab.UserStory08Servlet
  • com.google.appengine.codelab.UserStory10Servlet
  • com.google.appengine.codelab.UserStory11Servlet
    • Copyright © 2018 www.massapicom. 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.