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

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


    // TODO 0.1 need to try to go to memcache for this first somehow
    Step step = MiniProfiler.step("API.getMementos(" + tableId + ","
        + mementoId + ")");
    try {

      Filter tableIdFilter = new FilterPredicate("tableId",
          FilterOperator.EQUAL, tableId);

      Filter mementoIdFilter = new FilterPredicate("mementoId",
          FilterOperator.GREATER_THAN, mementoId);

      Filter tableIdAndMementoIdFilter = new CompositeFilter(
          CompositeFilterOperator.AND, Arrays.asList(tableIdFilter,
              mementoIdFilter));

      Query q = new Query("TableMemento")
          .setFilter(tableIdAndMementoIdFilter);
View Full Code Here


  }

  private String getOpenAndActiveTables(String playerName) {
    Step step = MiniProfiler.step("API.getOpenAndActiveTables");
    try {
      Filter playerFilter = new FilterPredicate("players",
          FilterOperator.EQUAL, playerName);

      Filter activeSegmentFilter = new FilterPredicate("segment",
          FilterOperator.IN, ACTIVE_SEGMENTS);

      Filter openSegmentFilter = new FilterPredicate("segment",
          FilterOperator.IN, OPEN_SEGMENTS);

      Filter segmentFilter = new CompositeFilter(
          CompositeFilterOperator.OR, Arrays.asList(
              activeSegmentFilter, openSegmentFilter));

      Filter segmentAndPlayerFilter = new CompositeFilter(
          CompositeFilterOperator.AND, Arrays.asList(playerFilter,
              segmentFilter));

      Query q = new Query("Table").setFilter(segmentAndPlayerFilter);
      DatastoreService datastore = DatastoreServiceFactory
View Full Code Here

  }

  private String getOpenTables() {
    Step step = MiniProfiler.step("API.getOpenTables");
    try {
      Filter segmentFilter = new FilterPredicate("segment",
          FilterOperator.IN, OPEN_SEGMENTS);

      Query q = new Query("Table").setFilter(segmentFilter);
      DatastoreService datastore = DatastoreServiceFactory
          .getDatastoreService();
View Full Code Here

  static DatastoreService datastore=DatastoreServiceFactory.getDatastoreService();
 
  public static boolean exists(String userId){
   
 
    Filter filter =
                              new FilterPredicate("UserId",
                              FilterOperator.EQUAL,
                              userId);
   
    Query q = new Query("SysUser").setFilter(filter);
View Full Code Here

   
  }
 
  public static Logger getLogger(String userId){
   
    Filter filter =
                      new FilterPredicate("UserId",
                              FilterOperator.EQUAL,
                              userId);
   
   
    Query q1 = new Query("SysUser").setFilter(filter);
   
    PreparedQuery pq1 = datastore.prepare(q1);

    Entity result = pq1.asSingleEntity();
   
    if((boolean)result.getProperty("Active")){
     
      Logger logger=new Logger();
     
      logger.LoggerEmail=(String) result.getProperty("Email");
      logger.LoggerName=(String)result.getProperty("FirstName")+" "+(String)result.getProperty("LastName");
     
     
      Query q2 = new Query("UserRole").setFilter(filter);
     
      PreparedQuery pq2 = datastore.prepare(q1);

      Entity result2 = pq2.asSingleEntity();
     
      String roles=(String) result2.getProperty("Roles");
     
      logger.LoggerRoles=roles.split("-1");
     
     
      String functionString="";
     
      for(int i=0;i<logger.LoggerRoles.length;i++){
       
       
        Filter filterf =
                new FilterPredicate("RoleName",
                        FilterOperator.EQUAL,
                        logger.LoggerRoles[i]);


        Query q3 = new Query("RoleFunction").setFilter(filterf);

        PreparedQuery pq3 = datastore.prepare(q3);

        Entity result3 = pq3.asSingleEntity();
       
       
        functionString += (String)result3.getProperty("Functions");
       
               
      }
   
      String[] functionNames= functionString.split("-1");
     
      for(int j=0;j<functionNames.length;j++){
       
       
        Filter filterF =
                new FilterPredicate("Function",
                        FilterOperator.EQUAL,
                        functionNames[j]);

View Full Code Here

      EdmNavigationProperty enp = eet.findNavigationProperty(propName);
      long id = Long.parseLong(propValue.toString());
      propValue = KeyFactory.createKey(enp.getToRole().getRole(), id);
    }

    Filter filter = new FilterPredicate(propName, op, propValue);
    q.setFilter(filter);
  }
View Full Code Here

    }

    // Check read access by kind
    if (accessType == AccessType.READ) {
      Query q = new Query(KIND_ACCESS_CONTROL_KIND);
      Filter filter = new FilterPredicate("Kind", FilterOperator.EQUAL, e.getKind());
      q.setFilter(filter);
      Entity kac = datastore.prepare(q).asSingleEntity();
      if (kac != null) {
        Long access = (Long) kac.getProperty("Access");
        if (access.equals(UserGroup.USER.groupId)) {
          return;
        }
      }
    }
    // Check write access by entity
    else if (accessType == AccessType.WRITE) {
      Query q = new Query(ENTITY_ACCESS_CONTROL_KIND);
      Filter filter = new FilterPredicate("Entity", FilterOperator.EQUAL, e);
      q.setFilter(filter);
      Entity eac = datastore.prepare(q).asSingleEntity();

      User owner = (User) eac.getProperty("owner");
      if (owner.compareTo(userService.getCurrentUser()) == 0) {
View Full Code Here

     
    try {   
     
      // Get the Datastore Service
      DatastoreService datastore = DatastoreServiceFactory.getDatastoreService();
      Filter nomFilter =  new Query.FilterPredicate("nomusuari", Query.FilterOperator.EQUAL, usuari.getNomusuari() );
      Query q2 = new Query("Usuaris").setFilter(nomFilter);
      PreparedQuery pq = datastore.prepare(q2);
      Entity usEntity = pq.asSingleEntity();
           
      Query query = new Query("Usuaris");
View Full Code Here

    @SuppressWarnings("unchecked")
    public static List<TestReport> findByBuildTypeIdOrderByBuildIdDesc(String buildTypeId, Optional<Integer> limit, Reports reports) {
        final MemcacheService memcacheService = reports.getMemcacheService();
        List<TestReport> results = (List<TestReport>) memcacheService.get(buildTypeId);
        if (results == null) {
            final Filter buildTypeFilter = new Query.FilterPredicate("buildTypeId", FilterOperator.EQUAL, buildTypeId);
            final Query query = new Query(TEST_REPORT).setFilter(buildTypeFilter).addSort("buildId", DESCENDING);

            final DatastoreService datastoreService = reports.getDatastoreService();
            final PreparedQuery preparedQuery = datastoreService.prepare(query);
            final List<Entity> entities = preparedQuery.asList(FetchOptions.Builder.withLimit(limit.or(DEFAULT_FETCH_LIMIT)));
View Full Code Here

    }

    @Test
    public void testSetFilterString() {
        Query query = new Query(kindName, rootKey);
        Filter filter = Query.CompositeFilterOperator.or(
            Query.FilterOperator.GREATER_THAN.of("stringData", "string data2"),
            Query.FilterOperator.LESS_THAN.of("stringData", "string data1"));
        query.setFilter(filter);
        assertEquals(1, service.prepare(query).countEntities(fo));
    }
View Full Code Here

TOP

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

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.