Package com.google.appengine.api.datastore

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

40
41
42
43
44
45
46
47
48
49
50
        Query q = new Query("Book");
        q.addFilter("copyrightYear",
                    Query.FilterOperator.LESS_THAN_OR_EQUAL,
                    1939);
        q.addSort("copyrightYear");
        q.addSort("title");

        // Perform the query.
        PreparedQuery pq = ds.prepare(q);
        for (Entity result : pq.asIterable()) {
            String title = (String) result.getProperty("title");
View Full Code Here
782
783
784
785
786
787
788
789
790
791
792
              }
            }
          }
        }
        if (orderBy != null && orderBy.length() > 0) {
          query.addSort(orderBy, ascending ? SortDirection.ASCENDING
              : SortDirection.DESCENDING);
        }
        long l0 = System.currentTimeMillis();

        PreparedQuery prepare = null;
View Full Code Here
32
33
34
35
36
37
38
39
40
41
42
        if(tag != null)
        {
            query.addFilter(tag + "Tag", Query.FilterOperator.EQUAL, true);
        }
       
        query.addSort("rating", SortDirection.DESCENDING);
        DatastoreService ds = DatastoreServiceFactory.getDatastoreService();
        PreparedQuery pq = ds.prepare(query);
        List<Entity> results = pq.asList(FetchOptions.Builder.withLimit(number).offset(offset));
        List<ImageItem> ret = new ArrayList<ImageItem>();
        for(Entity e: results)
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
    int numRandomItems = numItems / 2;
    int numNewItems = numItems - numRandomItems;

    DatastoreService ds = DatastoreServiceFactory.getDatastoreService();
    Query q = new Query("ImageItem");
    q.addSort("num_duels", SortDirection.ASCENDING);
    PreparedQuery pq = ds.prepare(q);
    List<Entity> duelingList = pq.asList(FetchOptions.Builder.withLimit(numNewItems));
   
   
    q = new Query("__Stat_Kind__");
View Full Code Here
16
17
18
19
20
21
22
23
24
25
26
public class UserHelper {
    public static List<User> getLadder(int offset, int number)
    {
        Query query = new Query("User");
       
        query.addSort("rating", SortDirection.DESCENDING);
        DatastoreService ds = DatastoreServiceFactory.getDatastoreService();
        PreparedQuery pq = ds.prepare(query);
        List<Entity> results = pq.asList(FetchOptions.Builder.withLimit(number).offset(offset));
        List<User> ret = new ArrayList<User>();
        for(Entity e: results)
View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
      q.addFilter(fp.getPropertyName(), fp.getOperator(), fp.getValue());
      logger.debug(
          "  Added filter: " + fp.getPropertyName() + " " + fp.getOperator() + " " + fp.getValue());
    }
    for (SortPredicate sp : sortPredicates) {
      q.addSort(sp.getPropertyName(), sp.getDirection());
      logger.debug("  Added sort: " + sp.getPropertyName() + " " + sp.getDirection());
    }
    DatastoreService ds = DatastoreServiceFactoryInternal.getDatastoreService();
    return ds.prepare(q);
  }
View Full Code Here
115
116
117
118
119
120
121
122
123
124
125
    q.setAncestor(keys.get(0).getParent());
    q.addFilter(
        Entity.KEY_RESERVED_PROPERTY, Query.FilterOperator.GREATER_THAN_OR_EQUAL, keys.get(0));
    q.addFilter(
        Entity.KEY_RESERVED_PROPERTY, Query.FilterOperator.LESS_THAN_OR_EQUAL, keys.get(keys.size() - 1));
    q.addSort(Entity.KEY_RESERVED_PROPERTY, Query.SortDirection.DESCENDING);
    DatastoreService service = DatastoreServiceFactoryInternal.getDatastoreService();
    int[] indices = new int[keys.size()];
    int index = 0;
    for (Entity e : service.prepare(service.getCurrentTransaction(null), q).asIterable()) {
      if (keySet.contains(e.getKey())) {
View Full Code Here
36
37
38
39
40
41
42
43
44
45
46
    Filter nameFilter = new FilterPredicate("filename",
        FilterOperator.EQUAL, fileName);

    final Query query = new Query("__BlobInfo__").setFilter(nameFilter);

    query.addSort("creation", SortDirection.DESCENDING);

    final DatastoreService datastore = DatastoreServiceFactory
        .getDatastoreService();
    final PreparedQuery pq = datastore.prepare(query);
    final List<Entity> entList = pq.asList(FetchOptions.Builder
View Full Code Here
124
125
126
127
128
129
130
131
132
133
134
    // The Query interface assembles a query
    Query q = new Query(Page.PAGEHISTORY);
    q.setFilter(new FilterPredicate(Page.NAME, Query.FilterOperator.EQUAL,
        name));

    q.addSort(Page.DATE, SortDirection.DESCENDING);

    // PreparedQuery contains the methods for fetching query results
    // from the datastore
    PreparedQuery pq = datastore.prepare(q);
View Full Code Here
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
  private List<Entity> getLeaderboard() {
    Step step = MiniProfiler.step("API.getLeaderboard");
    try {
      final Query query = new Query("Player");

      query.addSort("rating", SortDirection.DESCENDING);

      final DatastoreService datastore = DatastoreServiceFactory
          .getDatastoreService();
      final PreparedQuery pq = datastore.prepare(query);
      final List<Entity> entList = pq.asList(FetchOptions.Builder
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.