Package com.google.appengine.api.datastore

Examples of com.google.appengine.api.datastore.PreparedQuery



    JGNameValuePairs jn = null;
       Query q = new Query(table);
                ArrayList<Key> keys = new ArrayList<Key>();
        PreparedQuery pq = datastore.prepare(q) ;
    int ezt = pq.countEntities();

    if (ezt > fLimit)
      throw JGException.get("result_too_large"," Result too LARGE. Try narrowing query by adding more filters: " + ezt);

                Iterator it = (pq.asIterator());
//new ArrayList
        Entity entity = null;
        Vector<JGNameValuePairs> ez = new Vector<JGNameValuePairs>();
        //int ct = 0;
View Full Code Here


  {
    checkThread();
    Query q = new Query(table);
    q = q.addFilter(field,qf,value);
     DatastoreService datastore = DatastoreServiceFactory.getDatastoreService();
        PreparedQuery pq = datastore.prepare(q) ;
    //EZArrayList ez = new EZArrayList();
    //ez.addEnumeration(pq.asIterator());
   
    Iterator lst = pq.asIterator();
    Entity entity = null;
        ArrayList<Key> keys = new ArrayList<Key>();
    int ct = 0;
    while (lst.hasNext())
    {
View Full Code Here


    Query q = new Query(table);
    q = q.addFilter(field,qf,convert(value));
     DatastoreService datastore = DatastoreServiceFactory.getDatastoreService();
        PreparedQuery pq = datastore.prepare(q) ;
    int ezt = pq.countEntities();
    if (ezt > fLimit)
      throw JGException.get("result_too_large",table + " Result too LARGE. Try narrowing query by adding more filters: " + ezt + ":" + qf + ":" + field + ":" + value + ":" + value.getClass().getName());

    Iterator lst = pq.asIterator();
         //if (lst == null || !lst.hasNext())
         //  break;


    Entity entity = null;
View Full Code Here

      DatastoreService ds = DatastoreServiceFactory.getDatastoreService();

      Query q = new Query("Boleto");

      Map<String, Entity> mB = new HashMap<String, Entity>();
      PreparedQuery pq = ds.prepare(q);
      Iterable<Entity> it = pq.asIterable();
      for (Entity e : it)
        mB.put((String)e.getProperty("codigo"), e);

      System.out.println("RES : " + mB.size());

      installer.uninstall();

      installer2.install(options2);
      DatastoreService dsDestino = DatastoreServiceFactory.getDatastoreService();
//      dsDestino.put(it);

      Map<String, Entity> mB2 = new HashMap<String, Entity>();
      PreparedQuery pq2 = dsDestino.prepare(q);
      Iterable<Entity> it2 = pq2.asIterable();
      for (Entity e : it2)
        mB2.put((String)e.getProperty("codigo"), e);
      System.out.println("RES : " + mB2.size());
      installer2.uninstall();
    }
View Full Code Here

                Query q = new Query(AC_BASE);
                q.setKeysOnly();

                q.addFilter(PROPERTY_EXPIRES,
                        FilterOperator.LESS_THAN_OR_EQUAL, expire);
                PreparedQuery pq = ds.prepare(q);
                List<Entity> entities = pq.asList(Builder
                        .withLimit(CLEANUP_LIMIT));
                if (entities != null) {
                    log.info("Vaadin cleanup deleting " + entities.size()
                            + " expired Vaadin sessions.");
                    List<Key> keys = new ArrayList<Key>();
                    for (Entity e : entities) {
                        keys.add(e.getKey());
                    }
                    ds.delete(keys);
                }
            }
            // Also cleanup GAE sessions
            {
                Query q = new Query(APPENGINE_SESSION_KIND);
                q.setKeysOnly();
                q.addFilter(PROPERTY_APPENGINE_EXPIRES,
                        FilterOperator.LESS_THAN_OR_EQUAL, expire);
                PreparedQuery pq = ds.prepare(q);
                List<Entity> entities = pq.asList(Builder
                        .withLimit(CLEANUP_LIMIT));
                if (entities != null) {
                    log.info("Vaadin cleanup deleting " + entities.size()
                            + " expired appengine sessions.");
                    List<Key> keys = new ArrayList<Key>();
View Full Code Here

    // Build a query, serching on Comment entities
    Query query = new Query("Comment").setAncestor(entry.getKey());

    // Submit the query
    PreparedQuery pq = datastore.prepare(query);

    ArrayList<Comment> comments = new ArrayList<Comment>();

    // Iterate over the results from the query
    for (Entity result : pq.asIterable()) {
      User author = RightsManagementController.getInstance().getUser(result.getProperty("Author").toString());
      Comment comment = new Comment(result.getProperty("Text").toString(),
                    (Date) result.getProperty("Timestamp"),
                    author, result.getProperty("Title").toString());
      comments.add(comment);
View Full Code Here

    query.setKeysOnly();
   
    // Get an instance of the data store controller
    DatastoreService datastore = DatastoreServiceFactory.getDatastoreService();
    // Submit the previously prepared query
    PreparedQuery pq = datastore.prepare(query);
   
    ArrayList<Key> dataEntryKeys = new ArrayList<Key>();
    for (Entity result : pq.asIterable()) {
      Key dataEntry_key = result.getParent().getParent();
      dataEntryKeys.add(dataEntry_key);
     }
    return dataEntryKeys;
  }
View Full Code Here

      for(String field: fields) {
        Query query = new Query("Patient");
        query.addFilter(field, Query.FilterOperator.EQUAL, keyword);
        query.setKeysOnly();
        // Submit the query
        PreparedQuery pq = datastore.prepare(query);
        for (Entity result : pq.asIterable()) {
          Key patients_key = result.getKey();
          Query data_query = new Query("DataEntry", patients_key);
          PreparedQuery dq = datastore.prepare(data_query);
          for (Entity de : dq.asIterable()) {
            dataEntryKeys.add(de.getKey());
          }
         }
      }
    }
View Full Code Here

    if(gender != null) {
      query.addFilter("Gender", Query.FilterOperator.EQUAL, gender.toString());
    }
   
    ArrayList<Key> dataEntryKeys = new ArrayList<Key>();
    PreparedQuery pq = datastore.prepare(query);
    for (Entity result : pq.asIterable()) {
      Key patients_key = result.getKey();
      Query data_query = new Query("DataEntry", patients_key);
      PreparedQuery dq = datastore.prepare(data_query);
      for (Entity de : dq.asIterable()) {
        dataEntryKeys.add(de.getKey());
      }
    }
    return dataEntryKeys;
  }
View Full Code Here

    String report =  "";
   
    Query query = new Query("Patient");
    query.setKeysOnly();
    DatastoreService datastore = DatastoreServiceFactory.getDatastoreService();
    PreparedQuery pq = datastore.prepare(query);
    report+= "Patients in system: " + pq.countEntities(Builder.withDefaults());
   
    Query de_query = new Query("DataEntry");
    query.setKeysOnly();
    PreparedQuery de_q = datastore.prepare(de_query);
    report+= "<br>Studies in system: " + de_q.countEntities(Builder.withDefaults());
   
    Query u_query = new Query("User");
    query.setKeysOnly();
    PreparedQuery u_q = datastore.prepare(u_query);
    report+= "<br>Users in system: " + u_q.countEntities(Builder.withDefaults());
    return report;
  }
View Full Code Here

TOP

Related Classes of com.google.appengine.api.datastore.PreparedQuery

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.