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.


  @Override
  public ListQueryResult getAll(String kind, String sortColumn, honeycrm.client.s.SortDirection sortDirection, int from, int to) {
    final Query q = new Query(kind);
    final SortDirection dir = sortDirection.equals(honeycrm.client.s.SortDirection.Ascending) ? SortDirection.ASCENDING : SortDirection.DESCENDING;
    q.addSort(sortColumn, dir);
    PreparedQuery pq = db.prepare(q);
    return copy.entitiesToDtoArray(kind, pq.countEntities(withDefaults()), pq.asIterable(withLimit(to - from + 1).offset(from)), false);
  }
}

View Full Code Here


    Query q = new Query("BitacoraLN");
    q.addFilter("fecha", FilterOperator.GREATER_THAN_OR_EQUAL, fecini);
    q.addFilter("fecha", FilterOperator.LESS_THAN_OR_EQUAL, fecter);
    q.addFilter("negocio", FilterOperator.EQUAL, negocio);
    q.addSort("fecha", Query.SortDirection.DESCENDING);
    //logger.info("super query : " + q.toString());
    PreparedQuery pq = datastore.prepare(q);


    return pq.asIterable();
  }

View Full Code Here

  public static Iterable<Entity> listNovedadesHome(Date fecini, Date fecter) {


    Query q = new Query("NovedadLN");
    q.addFilter("fecha", FilterOperator.GREATER_THAN_OR_EQUAL, fecini);
    q.addFilter("fecha", FilterOperator.LESS_THAN_OR_EQUAL, fecter);
    q.addSort("fecha", Query.SortDirection.DESCENDING);
    //logger.info("query : " + q.toString());
    PreparedQuery pq = datastore.prepare(q);


    return pq.asIterable();
  }

View Full Code Here

    return pq.asIterable();
  }
  
  public static Iterable<Entity> listTurnoHome() {
    Query q = new Query("TipoLN");
    q.addSort("orden", Query.SortDirection.ASCENDING);
    PreparedQuery pq = datastore.prepare(q);
    //logger.info("query : " + q.toString());
    return pq.asIterable();
  }

View Full Code Here

    for (FilterPredicate fp : filterPredicates) {
      q.addFilter(fp.getPropertyName(), fp.getOperator(), fp.getValue());
      NucleusLogger.PERSISTENCE.debug("  Added filter: " + fp.getPropertyName() + " " + fp.getOperator() + " " + fp.getValue());
    }
    for (SortPredicate sp : sortPredicates) {
      q.addSort(sp.getPropertyName(), sp.getDirection());
      NucleusLogger.PERSISTENCE.debug("  Added sort: " + sp.getPropertyName() + " " + sp.getDirection());
    }


    DatastoreServiceConfig config = storeMgr.getDefaultDatastoreServiceConfigForReads();
    DatastoreService ds = DatastoreServiceFactoryInternal.getDatastoreService(config);

View Full Code Here

    applyFilters(query);
    if (sorts != null)
    {
      for (Sort sort : sorts)
      {
        query.addSort(sort.field, sort.direction);
      }
    }
    if (ancestor != null)
    {
      Key key = datastore.associatedKey(ancestor);

View Full Code Here

                    break;
                  }
                }
              }
              for (SortPredicate sp : sortPredicates) {
                q.addSort(sp.getPropertyName(), sp.getDirection());
              }
            }


            PreparedQuery pq = datastore.prepare(q);
            List<Key> values = new ArrayList<Key>();

View Full Code Here

    Query q = new Query(kindName);


    NucleusLogger.PERSISTENCE.debug("Preparing to query for " + childKeys);
    q.addFilter(Entity.KEY_RESERVED_PROPERTY, Query.FilterOperator.IN, childKeys);
    for (Query.SortPredicate sp : getSortPredicates()) {
      q.addSort(sp.getPropertyName(), sp.getDirection());
    }


    DatastoreServiceConfig config = storeMgr.getDefaultDatastoreServiceConfigForReads();
    DatastoreService ds = DatastoreServiceFactoryInternal.getDatastoreService(config);

View Full Code Here

      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);
      DatastoreServiceConfig config = storeMgr.getDefaultDatastoreServiceConfigForReads();
      DatastoreService service = DatastoreServiceFactoryInternal.getDatastoreService(config);
      int[] indices = new int[keys.size()];
      int index = 0;
      for (Entity e : service.prepare(service.getCurrentTransaction(null), q).asIterable()) {

View Full Code Here

        // Prepare a query.
        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()) {

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.