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

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

95
96
97
98
99
100
101
102
103
104
    }

    @Test
    public void testSetFilterShortBlob() {
        Query query = new Query(kindName, rootKey);
        Filter filter1 = Query.FilterOperator.EQUAL.of("shortBlobData", new ShortBlob("shortBlobData0".getBytes()));
        Filter filter2 = Query.FilterOperator.LESS_THAN_OR_EQUAL.of("shortBlobData", new ShortBlob("shortBlobData1".getBytes()));
        query.setFilter(Query.CompositeFilterOperator.or(filter1, filter2));
        assertEquals(2, service.prepare(query).countEntities(fo));
    }
View Full Code Here
107
108
109
110
111
112
113
114
115
    public void testSetFilterInt() {
        Query query = new Query(kindName, rootKey);
        List<Filter> filterList = new ArrayList<>();
        filterList.add(Query.FilterOperator.EQUAL.of("intData", 20));
        filterList.add(Query.FilterOperator.GREATER_THAN.of("intData", 0));
        Filter filter = Query.CompositeFilterOperator.and(filterList);
        query.setFilter(filter);
        assertEquals(1, service.prepare(query).countEntities(fo));
    }
View Full Code Here
118
119
120
121
122
123
124
125
126
127
    public void testSetFilterRating() {
        Query query = new Query(kindName, rootKey);
        List<Filter> filterList = new ArrayList<>();
        filterList.add(Query.FilterOperator.LESS_THAN.of("ratingData", new Rating(30)));
        filterList.add(Query.FilterOperator.GREATER_THAN.of("ratingData", new Rating(0)));
        Filter filter1 = Query.CompositeFilterOperator.or(filterList);
        Filter filter2 = Query.FilterOperator.EQUAL.of("ratingData", new Rating(20));
        query.setFilter(Query.CompositeFilterOperator.and(filter1, filter2));
        assertEquals(1, service.prepare(query).countEntities(fo));
    }
View Full Code Here
131
132
133
134
135
136
137
138
139
140
        // [0,50,90], [1,51,91], [2,52,92]
        Query query = new Query(kindName, rootKey);
        List<Filter> filterList = new ArrayList<>();
        filterList.add(Query.FilterOperator.LESS_THAN.of("intList", 5));
        filterList.add(Query.FilterOperator.GREATER_THAN.of("intList", 90));
        Filter filter1 = Query.CompositeFilterOperator.OR.of(filterList);
        Filter filter2 = Query.FilterOperator.EQUAL.of("intList", 52);
        query.setFilter(Query.CompositeFilterOperator.AND.of(filter1, filter2));
        assertEquals(1, service.prepare(query).countEntities(fo));
    }
View Full Code Here
141
142
143
144
145
146
147
148
149
150
151
152
153
154
    @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));
        // sql statement
        String sql = "SELECT geoptData FROM " + kindName;
        sql += " WHERE ((intList < 5 or intList > 90) AND intList = 52)";
        sql += " AND __ancestor__ is " + rootKey;
View Full Code Here
177
178
179
180
181
182
183
184
185
186
187
    }

    @Test
    public void testCompositeFilter() {
        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);
View Full Code Here
46
47
48
49
50
51
52
53
54
55
56
    Date date = new Date();
    Calendar cal = Calendar.getInstance();
    cal.setTime(date);
    cal.add(Calendar.MINUTE, -2);
   
    Filter dateFilter = new FilterPredicate("date", Query.FilterOperator.LESS_THAN, cal.getTime());
   
    Query researchDeleteListQuery = new Query("Search").setFilter(dateFilter);
   
    PreparedQuery researchPreparedQuery = datastore.prepare(researchDeleteListQuery);
   
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
    DatastoreService datastore = DatastoreServiceFactory.getDatastoreService();

    FilterPredicate leavingFromFilter = new FilterPredicate("leavingFrom", Query.FilterOperator.EQUAL, leavingFrom);
    FilterPredicate goingToFilter = new FilterPredicate("goingTo", Query.FilterOperator.EQUAL, goingTo);
    FilterPredicate dateFilter = new FilterPredicate("departure", Query.FilterOperator.GREATER_THAN_OR_EQUAL, departure);
    Filter filter = CompositeFilterOperator.and(leavingFromFilter, goingToFilter, dateFilter);
   
    Query volListQuery = new Query("Vol").setFilter(filter)
    .addSort("departure", SortDirection.ASCENDING);
   
    return datastore.prepare(volListQuery);
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
73
    datastore.put(entity);
  }
 
  public static User getByLoginOrEmail(String loginOrEmail) throws NumberFormatException, TooManyResultsException, ParseException {
    DatastoreService datastore = DatastoreSingleton.getInstance();
    Filter loginFilter = new FilterPredicate("login", FilterOperator.EQUAL, loginOrEmail);
    Filter emailFilter = new FilterPredicate("email", FilterOperator.EQUAL, loginOrEmail);
    Query q = new Query("User").setFilter(CompositeFilterOperator.or(loginFilter, emailFilter));
    PreparedQuery pq = datastore.prepare(q);
    Entity e = pq.asSingleEntity();
    if(e == null) {
      return null;
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
    datastore.put(search);
  }
 
  public static PreparedQuery getHistoric(HttpServletRequest request) throws NumberFormatException, ParseException{
    DatastoreService datastore = DatastoreServiceFactory.getDatastoreService();
    Filter userFilter = new FilterPredicate("user", FilterOperator.EQUAL, KeyFactory.keyToString(Authenticate.getConnectedUser(request).getKey()));
    Query researchListQuery = new Query("Search")
    .setFilter(userFilter)
    .addSort("date", SortDirection.ASCENDING);
   
    return datastore.prepare(researchListQuery);
View Full Code Here
TOP

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

  • com.antonytrupe.server.battledisks.API
  • com.antonytrupe.server.ImageServlet
  • com.fms.kccc.server.Datastore
  • com.google.appengine.codelab.Sessao
  • com.google.appengine.codelab.UserStory10Servlet
  • com.google.appengine.codelab.UserStory11Servlet
  • com.google.appengine.codelab.UserStory12Servlet
  • com.google.appengine.codelab.Util
  • com.google.appengine.tck.datastore.QueryTest
  • com.google.appengine.tck.site.endpoints.TestReport
    • 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.