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

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

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

com.google.appengine.api.datastore.Query.FilterPredicate

    
  public static Iterable<Entity> getTransacoesByLocalidadeBetweenValores(String localidade_id,
      Float iniValue, Float finValue) {
    DatastoreService ds = Util.getDatastoreServiceInstance();
    Query query = new Query("Transacao");
    Filter f1 = new FilterPredicate("trans_price", FilterOperator.GREATER_THAN_OR_EQUAL,
        iniValue);
    Filter f2 = new FilterPredicate("trans_price", FilterOperator.LESS_THAN_OR_EQUAL,
        finValue);
    Filter f3 = new FilterPredicate("localidade_id", FilterOperator.EQUAL, localidade_id);
    Filter fc = CompositeFilterOperator.and(f1, f2, f3);
    query.setFilter(fc);
    return ds.prepare(query).asIterable();
  }

View Full Code Here

    query.setFilter(filter);
    return ds.prepare(query);
  }
  
  public static PreparedQuery getFraudeByTransId(String trans_id) {
    Filter filter = new FilterPredicate("trans_id", FilterOperator.EQUAL, trans_id);
    return getByFilter("Fraude", filter);
  }

View Full Code Here

    return sb.toString();
  }
  
  public static String getTotalFraudesBySisNav(String sis_nome, String sis_versao,
      String nav_nome, String nav_versao, String data_ini, String data_fin) {
    Filter f1 = new FilterPredicate("sis_nome", FilterOperator.EQUAL, sis_nome);
    Filter f2;
    Filter fc;
    if (sis_versao != "") {
      f2 = new FilterPredicate("sis_versao", FilterOperator.EQUAL, sis_versao);
      fc = CompositeFilterOperator.and(f1, f2);
    } else {
      fc = f1;
    }
    Entity sis = new SistemaOperacional().get(fc).asSingleEntity();
    long sis_id = sis.getKey().getId();
    sis_nome = sis.getProperty("sis_nome").toString();
    sis_versao = sis.getProperty("sis_versao").toString();
    String sis_movel = sis.getProperty("sis_movel").toString();
    
    f1 = new FilterPredicate("nav_nome", FilterOperator.EQUAL, nav_nome);
    if (nav_versao != "") {
      f2 = new FilterPredicate("nav_versao", FilterOperator.EQUAL, nav_versao);
      fc = CompositeFilterOperator.and(f1, f2);
    } else {
      fc = f1;
    }
    Entity nav = new Navegador().get(fc).asSingleEntity();

View Full Code Here

    sb.append("]}");
    return sb.toString();
  }
  
  public static PreparedQuery getTransacaoBySesId(long ses_id) {
    Filter filter = new FilterPredicate("ses_id", FilterOperator.EQUAL, ses_id);
    return getByFilter("Transacao", filter);
  }

View Full Code Here

    return getTotalFraudesBySistemaOperacional(
        new SistemaOperacional().getAll().asIterable(), data_ini, data_fin);
  }
  
  public static String writeTotalFraudesByAdroid41(String data_ini, String data_fin) {
    Filter f1 = new FilterPredicate("sis_nome", FilterOperator.EQUAL, "Android");
    Filter f2 = new FilterPredicate("sis_versao", FilterOperator.EQUAL, "4.1");
    Filter fc = CompositeFilterOperator.and(f1, f2);
    return getTotalFraudesBySistemaOperacional(
        new SistemaOperacional().get(fc).asIterable(), data_ini, data_fin);
  }

View Full Code Here

//Metodo Adicionado por Anderson - US2 
  public static Iterable<Entity> listEntitiesFraudulentas(String kind, String searchBy, String trans_data_init, String trans_data_end) {
      logger.log(Level.INFO, "Search entities based on search criteria");
      Query query = new Query(kind);
      if (trans_data_init != null && !"".equals(trans_data_init)) {        
       Filter f1 = new FilterPredicate(searchBy,
          FilterOperator.GREATER_THAN_OR_EQUAL, trans_data_init);
      Filter f2 = new FilterPredicate(searchBy,
          FilterOperator.LESS_THAN_OR_EQUAL, trans_data_end);
      Filter fc = CompositeFilterOperator.and(f1, f2);
      query.setFilter(fc);
        //query.addFilter(searchBy, FilterOperator.GREATER_THAN, trans_data_init);

View Full Code Here

    }
//Metodo Adicionado por Anderson - US13
  public static Iterable<Entity> listEntitiesFraudePeriodoTipo(String trans_data_init,String trans_data_end, String fraude_type) {
      logger.log(Level.INFO, "Search entities based on search criteria");
      Query query = new Query("Fraude");
      Filter f1 = new FilterPredicate("fraude_data_deteccao",  FilterOperator.NOT_EQUAL, "");
      Filter f2 = new FilterPredicate("fraude_data_deteccao",  FilterOperator.NOT_EQUAL, "");
      Filter f3 = new FilterPredicate("fraude_type",  FilterOperator.NOT_EQUAL, "");
      Filter fc = new FilterPredicate("",  FilterOperator.NOT_EQUAL, "");
      if (trans_data_init != null && !"".equals(trans_data_init)) {        
        f1 = new FilterPredicate("fraude_data_deteccao",
          FilterOperator.GREATER_THAN_OR_EQUAL, trans_data_init);
      }
      if (trans_data_end != null && !"".equals(trans_data_end)) {        
         f2 = new FilterPredicate("fraude_data_deteccao",
            FilterOperator.LESS_THAN_OR_EQUAL, trans_data_end);
    }
      if (fraude_type != null && !"".equals(fraude_type)) {        
         f3 = new FilterPredicate("fraude_type",
            FilterOperator.EQUAL, fraude_type);
         fc = CompositeFilterOperator.and(f1, f2, f3);
    }
      else
      {

View Full Code Here

  public static Iterable<Entity> listEntitiesTransacaoPeriodoTipo(String trans_data_init,String trans_data_end, String trans_type) {
      logger.log(Level.INFO, "Search entities based on search criteria");
      Query query = new Query("Transacao");
      List<Filter> filter = new ArrayList<Filter>();
      if (trans_data_init != null && !"".equals(trans_data_init)) {        
        filter.add(new FilterPredicate("trans_data", FilterOperator.GREATER_THAN_OR_EQUAL,
            trans_data_init));
      }
      if (trans_data_end != null && !"".equals(trans_data_end)) {        
         filter.add(new FilterPredicate("trans_data", FilterOperator.LESS_THAN_OR_EQUAL,
             trans_data_end));
    }
      if (trans_type != null && !"".equals(trans_type)) {        
         filter.add(new FilterPredicate("trans_type", FilterOperator.EQUAL,
             trans_type));
    }
      if (filter.size() > 0) {
      query.setFilter(filter.size() == 1 ? filter.get(0)
          : CompositeFilterOperator.and(filter));

View Full Code Here

      logger.log(Level.INFO, "Search entities based on search criteria");
      Query query = new Query("Localidade");


      List<Filter> filter = new ArrayList<Filter>();
      if (localidade_country != null && !"".equals(localidade_country)) {        
        filter.add(new FilterPredicate("localidade_country", FilterOperator.EQUAL,
            localidade_country));
      }
      if (localidade_state != null && !"".equals(localidade_state)) {        
          filter.add(new FilterPredicate("localidade_state", FilterOperator.EQUAL,
              localidade_state));
    }
      if (localidade_city != null && !"".equals(localidade_city)) {        
         filter.add(new FilterPredicate("localidade_city", FilterOperator.EQUAL,
             localidade_city));
    }
      if (filter.size() > 0) {
      query.setFilter(filter.size() == 1 ? filter.get(0)
          : CompositeFilterOperator.and(filter));

View Full Code Here

  }
  
  public static PreparedQuery get(String kind, String propertyName, Object value) {
    Query query = new Query(kind);
    if ((value != null) && (!"".equals(value))) {
      query.setFilter(new FilterPredicate(propertyName, FilterOperator.EQUAL, value));
    }
    return Util.getDatastoreServiceInstance().prepare(query);
  }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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

com.antonytrupe.server.battledisks.API

com.antonytrupe.server.ImageServlet

com.antonytrupe.server.PageServiceImpl

com.fms.kccc.server.Datastore

com.google.appengine.codelab.Datastore

com.google.appengine.codelab.Fraude

com.google.appengine.codelab.Sessao

com.google.appengine.codelab.UserStory08Servlet

com.google.appengine.codelab.UserStory10Servlet

com.google.appengine.codelab.UserStory11Servlet

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.