Examples of javax.jdo.Query

javax.jdo.Query
The Query interface allows applications to obtain persistent instances, values, and aggregate data from the data store. The {@link PersistenceManager} is the factory for Query instances. There may be many Query instances associated with a PersistenceManager. Multiple queries might be executed simultaneously by different threads, but the implementation might choose to execute them serially. In either case, the implementation must be thread safe.
There are three required elements in a Query: the class of the results, the candidate collection of instances, and the filter.
There are optional elements: parameter declarations, variable declarations, import statements, ordering and grouping specifications, result and result class, the range of results, and flags indicating whether the query result is unique and whether the query can be modified.
The query namespace is modeled after methods in Java:
- setClass corresponds to the class definition
- declareParameters corresponds to formal parameters of a method
- declareVariables corresponds to local variables of a method
- setFilter and setOrdering correspond to the method body
There are two namespaces in queries. Type names have their own namespace that is separate from the namespace for fields, variables and parameters.
The method setClass introduces the name of the candidate class in the type namespace. The method declareImports introduces the names of the imported class or interface types in the type namespace. Imported type names must be unique. When used (e.g. in a parameter declaration, cast expression, etc.) a type name must be the name of the candidate class, the name of a class or interface imported by method declareImports, or denote a class or interface from the same package as the candidate class.
The method setClass introduces the names of the candidate class fields.
The method declareParameters introduces the names of the parameters. A name introduced by declareParameters hides the name of a candidate class field of the same name. Parameter names must be unique.
The method declareVariables introduces the names of the variables. A name introduced by declareVariables hides the name of a candidate class field if equal. Variable names must be unique and must not conflict with parameter names.
The result of the query by default is a list of result class instances, but might be specified via setResult. The class of the result by default is the candidate class, but might be specified via setResultClass.
A hidden field may be accessed using the 'this' qualifier: this.fieldName.
The Query interface provides methods which execute the query based on the parameters given. They return a single instance or a List of result class instances which the user can iterate to get results. The signature of the execute methods specifies that they return an Object which must be cast to the appropriate result by the user.
Any parameters passed to the execute methods are used only for this execution, and are not remembered for future execution. @version 2.1

    if (tmp != null){
      //subscriptions list in cache
      blogs = (List<Long>) tmp;
    } else {
      //TODO if not in cache : fetch from datastore
      Query qUser = getPM().newQuery(User.class);
      qUser.setFilter("id == email");
      qUser.declareParameters("String email");
      qUser.setRange(0, 1);
      qUser.setUnique(true);


      User user = (User) qUser.execute(email);
      
      if (user != null){
        //fetch subscription
        // select subscriptions
        Query q = getPM().newQuery(Subscription.class);
        q.setFilter("userKey == uk");
        q.declareParameters("com.google.appengine.api.datastore.Key uk");


        List<Subscription> subs = (List<Subscription>) q.execute(user
            .getKey());
        for(Subscription sub : subs){
          long id = sub.getBlogKey().getId();
          if (!blogs.contains(id)){
            blogs.add(id);
          }
        }
        q.closeAll();
        q = null;
      }
      qUser.closeAll();
      qUser = null;

View Full Code Here

    return list;
  }
  
  @SuppressWarnings("unchecked")
  public <T> List<T> findByAttribute(Class<T> clazz, String attribute, Key value) {
    Query q = pm.newQuery(clazz);
    q.setFilter(attribute + " == value");
    q.declareParameters(Key.class.getName() + " value");
    
    List<T> list = (List<T>) q.execute(value);
    
    return list;
  }

View Full Code Here

    @SuppressWarnings("unchecked")
    public List<Photo> queryPhotos() {
        PersistenceManager pm = PMF.get().getPersistenceManager();
        try {
            String queryStr = String.format("select from %s where user_email==currentUser order by modification desc", Photo.class.getName());
            Query query = pm.newQuery(queryStr);
            query.declareParameters("String currentUser");
            List<Photo> photos = (List<Photo>) query.execute(getUserEmail());
            if (photos.size() == 0) {
                photos.size();
            }
            return photos;
        } finally {

View Full Code Here

        if (action.equalsIgnoreCase("flushTokens")) {
          PersistenceManager pm = PMF.get().getPersistenceManager();
          try {
            Calendar cal = Calendar.getInstance();
            cal.add(Calendar.HOUR, -6);
            Query query = pm.newQuery(AuthenticationToken.class);
            query.setFilter("activity < activityParam");
            query.setRange(0, 1000);
            query.declareImports("import java.util.Date");
            query.declareParameters("Date activityParam");
            List<AuthenticationToken> objs = (List<AuthenticationToken>) query.execute(cal.getTime());
              long c = objs.size();
              for (AuthenticationToken obj : objs) {
              pm.deletePersistent(obj);
              }
              String msg = user + " - Flushed " + c + " tokens.";
              log.log(Level.INFO, msg);
              resp.getWriter().write(msg);
          } finally {
            pm.close();
          }
        } else if (action.equalsIgnoreCase("countTokens")) {
          PersistenceManager pm = PMF.get().getPersistenceManager();
          try {
            Query query = pm.newQuery(AuthenticationToken.class);
              List<AuthenticationToken> objs = (List<AuthenticationToken>) query.execute();
              int c = objs.size();
              String msg = user + " - There are " + c + " tokens.";
              log.log(Level.INFO, msg);
              resp.getWriter().write(msg);
          } finally {
            pm.close();
          }
        } else if (action.equalsIgnoreCase("countFlushTokens")) {
          PersistenceManager pm = PMF.get().getPersistenceManager();
          try {
            Calendar cal = Calendar.getInstance();
            cal.add(Calendar.HOUR, -6);
            Query query = pm.newQuery(AuthenticationToken.class);
            query.setFilter("activity < activityParam");
            query.declareImports("import java.util.Date");
            query.declareParameters("Date activityParam");
            List<AuthenticationToken> objs = (List<AuthenticationToken>) query.execute(cal.getTime());
            int c = objs.size();
            String msg = user + " - There are " + c + " tokens to flush.";
          log.log(Level.INFO, msg);
            resp.getWriter().write(msg);
          } finally {

View Full Code Here


        
          
          for (String user  : listIdUsers) {
          /// query
        Query query = pm.newQuery(DaoCommunityAccount2.class);
          query.setFilter("idUser == nameParam");
          query.setOrdering("name desc");
          query.setOrdering("dateCommunityAccount desc");
          query.setRange(0, range); //only 6 results 
          //query.setOrdering("hireDate desc");
          query.declareParameters("String nameParam");
          List<DaoCommunityAccount2> resultsTmp = (List<DaoCommunityAccount2>) query.execute(user);
          
          if(resultsTmp.size() != 0 )
          {
            DaoCommunityAccount2 daoComAcc = resultsTmp.get(0);
            CommunityAccount comAcc=  TransformDtoObject.TransformDaoCommunityAccountToCommunityAccount(daoComAcc);
            String previousDate = "";
            for (DaoCommunityAccount2 myDaoCommunityAccount : resultsTmp ) {
              //si 2 dates identiques se suivent on ne prend la deuxiÃ¨me
              String dateCurrent = "";
              if (myDaoCommunityAccount.getDateCommunityAccount() != null) { 
                dateCurrent = sdf.format(myDaoCommunityAccount.getDateCommunityAccount());
                if (!dateCurrent.equalsIgnoreCase(previousDate)) {
                  comAcc.listDates.add(dateCurrent);
                  comAcc.listbattles.add(myDaoCommunityAccount.getData().getStats().getBattles());
                  
                  comAcc.listBattlesWins.add(myDaoCommunityAccount.getData().getStats().getBattle_wins());
                  CommunityAccount comA=  TransformDtoObject.TransformDaoCommunityAccountToCommunityAccount(myDaoCommunityAccount);
                  
                  comAcc.listDataPlayerInfos.add(comA.getData());
                }
              }
              previousDate = dateCurrent;
            }
            resultsFinal.add(comAcc);
          }
          query.closeAll();
        
          }
    } catch (Exception e) {
      
      log.severe(e.getLocalizedMessage());

View Full Code Here


        
          try {
            for (String user  : listIdUsers) {
            /// query
          Query query = pm.newQuery(DaoCommunityAccount2.class);
            query.setFilter("idUser == nameParam");
            query.setOrdering("name desc");
            query.setOrdering("dateCommunityAccount desc");
            query.setRange(0, range); //only 6 results 
            //query.setOrdering("hireDate desc");
            query.declareParameters("String nameParam");
            List<DaoCommunityAccount2> resultsTmp = (List<DaoCommunityAccount2>) query.execute(user);
            
            if(resultsTmp.size() != 0 )
            {
              DaoCommunityAccount2 daoComAcc = resultsTmp.get(0);
              CommunityAccount comAcc=  TransformDtoObject.TransformDaoCommunityAccountToCommunityAccount(daoComAcc);
              String previousDate = "";
              for (DaoCommunityAccount2 myDaoCommunityAccount : resultsTmp ) {
                //si 2 dates identiques se suivent on ne prend la deuxiÃ¨me
                String dateCurrent = "";
                if (myDaoCommunityAccount.getDateCommunityAccount() != null) { 
                  dateCurrent = sdf.format(myDaoCommunityAccount.getDateCommunityAccount());
                  if (!dateCurrent.equalsIgnoreCase(previousDate)) {
                    comAcc.listDates.add(dateCurrent);
                    comAcc.listbattles.add(myDaoCommunityAccount.getData().getStats().getBattles());
                    
                    comAcc.listBattlesWins.add(myDaoCommunityAccount.getData().getStats().getBattle_wins());
                  }
                }
                previousDate = dateCurrent;
              }
              resultsFinal.put(user, comAcc);
            }
            query.closeAll();
          
            }
          
          
          }

View Full Code Here


        
          try {
            for (String user  : listIdUsers) {
            /// query
          Query query = pm.newQuery(DaoCommunityAccount2.class);
            query.setFilter("idUser == nameParam");
            query.setOrdering("name desc");
            query.setOrdering("dateCommunityAccount desc");
            query.setRange(0, 6); //only 6 results 
            //query.setOrdering("hireDate desc");
            query.declareParameters("String nameParam");
            List<DaoCommunityAccount2> resultsTmp = (List<DaoCommunityAccount2>) query.execute(user);
            
            if(resultsTmp.size() != 0 )
            {
              DaoCommunityAccount2 daoComAcc = resultsTmp.get(0);
              CommunityAccount comAcc=  TransformDtoObject.TransformDaoCommunityAccountToCommunityAccount(daoComAcc);
              String previousDate = "";
              for (DaoCommunityAccount2 myDaoCommunityAccount : resultsTmp ) {
                //si 2 dates identiques se suivent on ne prend la deuxiÃ¨me
                String dateCurrent = "";
                if (myDaoCommunityAccount.getDateCommunityAccount() != null) { 
                  dateCurrent = sdf.format(myDaoCommunityAccount.getDateCommunityAccount());
                  if (!dateCurrent.equalsIgnoreCase(previousDate)) {
                    CommunityAccount comAccForList=  TransformDtoObject.TransformDaoCommunityAccountToCommunityAccount(myDaoCommunityAccount);
                    comAcc.listDates.add(dateCurrent);
                    //comAcc.listBattlesTanks.add(comAccForList.g);  //bug now !!!!
                    
                    //comAcc.listBattlesTanksWins.add(myDaoCommunityAccount.getData().getStatsVehicules().getBattle_wins());
                  }
                }
                previousDate = dateCurrent;
              }
              resultsFinal.add(comAcc);
            }
            query.closeAll();
          
            }
          
          
          }

View Full Code Here

    //on requête le dernier <DaoCommunityClan2> et on le compare avec le courant (pas encore sauvé) 
    //pour constituer une liste des joueurs added et une autre deleted que l'on sauve dans DaoCommunityClan2 courant
    PersistenceManager pm = null;
    pm = PMF.get().getPersistenceManager();
        try {
      Query query = pm.newQuery(DaoCommunityClan2.class);
        query.setFilter("idClan == nameParam");
        //query.setOrdering("name desc");
        query.setOrdering("dateCommunityClan desc"); //recup de la  derniere compo du CLAN  (J-1) 
        query.setRange(0, 1); //only 1 results 
        //query.setOrdering("hireDate desc");
        query.declareParameters("String nameParam");
        List<DaoCommunityClan2> resultsTmp = (List<DaoCommunityClan2>) query.execute(idClan);
  
        Map<String, String>  mapPrevDaoMembers = new HashMap<String, String>();; 
        Map<String, String>  mapCurrentDaoMembers = new HashMap<String, String>(); 


      //recup des membres du j-1

View Full Code Here

class NoticiaDAOImpl extends BaseDAO<Noticia> implements INoticiaDAO{


  @Override
  public Noticia pesquisarIndice(Integer indice) {
    
    Query query = getPersistenceManager().newQuery(Noticia.class);
    
    query.setRange(indice, indice+1);
    
    query.setUnique(true);
    
    return (Noticia) query.execute();
  }

View Full Code Here

   */
  @SuppressWarnings("unchecked")
  public List<Card> list(PersistenceManager pm) {
    
    List<Card> results = null;
    Query q = pm.newQuery(Card.class);
    q.setOrdering("id desc");
    
    try {
      
      results = (List<Card>) q.execute();
      
    } finally {
      
      q.closeAll();
    }
    
    return results;
  }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of javax.jdo.Query

br.com.colegio.dao.storage.Storage

cl.loso.melon.server.model.BusquedaML

cl.loso.melon.server.persistencia.BitacoraLNDAO

cl.loso.melon.server.persistencia.EquipoLNDAO

cl.loso.melon.server.persistencia.FueraServicioLNDAO

cl.loso.melon.server.persistencia.NovedadLNDAO

cl.loso.melon.server.persistencia.UsuarioLNDAO

com.appspot.gaeforum309.db.DBComment

com.appspot.gaeforum309.db.DBConversation

com.bestfit.server.RpcImpl

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.