Java Query类代码示例

import org.infinispan.query.dsl.Query; //导入依赖的package包/类
public static void main(String[] args) {
   ConfigurationBuilder builder = new ConfigurationBuilder();
   builder.indexing().index(Index.ALL)
      .addProperty("default.directory_provider", "ram")
      .addProperty("lucene_version", "LUCENE_CURRENT");
   // Construct a simple local cache manager with default configuration
   DefaultCacheManager cacheManager = new DefaultCacheManager(builder.build());
   // Obtain the default cache
   Cache<String, Person> cache = cacheManager.getCache();
   // Store some entries
   cache.put("person1", new Person("William", "Shakespeare"));
   cache.put("person2", new Person("William", "Wordsworth"));
   cache.put("person3", new Person("John", "Milton"));
   // Obtain a query factory for the cache
   QueryFactory queryFactory = Search.getQueryFactory(cache);
   // Construct a query
   Query query = queryFactory.from(Person.class).having("name").eq("William").toBuilder().build();
   // Execute the query
   List<Person> matches = query.list();
   // List the results
   matches.forEach(person -> System.out.printf("Match: %s", person));
   // Stop the cache manager and release all resources
   cacheManager.stop();
}
 

import org.infinispan.query.dsl.Query; //导入依赖的package包/类
public Collection<RemoteQuery> split(Query query) {
   TransportFactory transportFactory
         = ((OperationsFactory)cache.getOperationsFactory()).getTransportFactory();
   if (!(query instanceof RemoteQuery))
      throw new CacheException("need an AvroRemoteQuery");
   if (!(transportFactory instanceof  TcpTransportFactory))
      throw new CacheException("need a TcpTransportFactory");
   Collection<SocketAddress> servers = ((TcpTransportFactory)transportFactory).getServers();
   Collection<RemoteQuery> results = new ArrayList<>();
   for (SocketAddress addr: servers) {
      InetSocketAddress address = (InetSocketAddress) addr;
      try {
         RemoteQuery q = (RemoteQuery) ((RemoteQuery) query).clone();
         q.setLocation(address);
         results.add(q);
      } catch (CloneNotSupportedException e) {
         e.printStackTrace();
         // not reachable.
      }
   }
   return results;
}
 

import org.infinispan.query.dsl.Query; //导入依赖的package包/类
@Test
public void testProjections() throws Exception {
   employeeCache.put(1, Utils.createEmployee1());
   employeeCache.put(2, Utils.createEmployee2());

   // get Employee back from remote cache and check its attributes
   Employee fromCache = employeeCache.get(1);
   Utils.assertEmployee(fromCache);

   // get Employee back from remote cache via query and check its attributes
   Query query = employeeQF.from(Employee.class)
         .setProjection("name")
         .having("name").eq("Tom").toBuilder()
         .build();

   List<Employee> list = query.list();
   assertNotNull(list);
   assertEquals(1, list.size());
   assertEquals("Tom", list.get(0).getName());
}
 

import org.infinispan.query.dsl.Query; //导入依赖的package包/类
@Test
public void testAttributeQuery() throws Exception {

   remoteCache0.put(1, createEmployee1());
   remoteCache0.put(2, createEmployee2());

   QueryFactory qf = Search.getQueryFactory(remoteCache1);

   Query query = qf.from(Employee.class)
         .having("ssn").eq("12357").toBuilder()
         .build();
   List<Employee> list = query.list();
   assertNotNull(list);
   assertEquals(1, list.size());

}
 

import org.infinispan.query.dsl.Query; //导入依赖的package包/类
@Override
public ResultSet<Resource> getResources(ResourceFilter filter, long startOffset, int maxResults) {
    QueryBuilder qb = qResource.from(IspnResource.class);
    FilterConditionContextQueryBuilder fccqb = null;
    if (filter.isRootOnly()) {
        fccqb = qb.having("parentId").isNull();
    }
    if (filter.getTypeId() != null) {
        fccqb = (fccqb == null ? qb : fccqb.and()).having("typeId").equal(filter.getTypeId());
    }
    if (filter.getFeedId() != null) {
        fccqb = (fccqb == null ? qb : fccqb.and()).having("feedId").equal(filter.getFeedId());
    }
    Query query = (fccqb == null ? qb : fccqb)
            .maxResults(maxResults)
            .startOffset(startOffset).build();
    List<IspnResource> ispnResources = query.list();
    List<Resource> result = ispnResources
            .stream()
            .map(r -> r.toResource(this::getResourceType))
            .collect(Collectors.toList());
    return new ResultSet<>(result, (long) query.getResultSize(), startOffset);
}
 

import org.infinispan.query.dsl.Query; //导入依赖的package包/类
@Override
public void buildMetricsEndpoints() {
    for (Map.Entry<String, String> filter : scrapeConfig.getFilter().entrySet()) {
        int nResults, offSet = 0;
        do {
            Query qb = qResource.from(IspnResource.class)
                    .having("typeId")
                    .equal(filter.getKey())
                    .startOffset(offSet)
                    .maxResults(MAX_RESULTS)
                    .build();
            nResults = qb.getResultSize();
            List<IspnResource> results = qb.list();
            offSet = results.size();
            results.forEach(r -> writeMetricsEndpoint(r.getRawResource()));
        } while (offSet < nResults);
    }
}
 

import org.infinispan.query.dsl.Query; //导入依赖的package包/类
@Override
public List<?> getRules(final String clientIPAddress) {
    try {
        final RemoteCache<String, Rule> ruleCache = cacheManagerForIndexableCaches.getCache(SinkitCacheName.infinispan_rules.toString());
        final ImmutablePair<String, String> startEndAddresses = CIDRUtils.getStartEndAddresses(clientIPAddress);
        final String clientIPAddressPaddedBigInt = startEndAddresses.getLeft();
        log.log(Level.FINE, "Getting key [" + clientIPAddress + "] which actually translates to BigInteger zero padded representation " + "[" + clientIPAddressPaddedBigInt + "]");
        // Let's try to hit it
        Rule rule = ruleCache.withFlags(Flag.SKIP_CACHE_LOAD).get(clientIPAddressPaddedBigInt);
        if (rule != null) {
            return Collections.singletonList(rule);
        }
        QueryFactory qf = Search.getQueryFactory(ruleCache);
        Query query = qf.from(Rule.class)
                .having("startAddress").lte(clientIPAddressPaddedBigInt)
                .and()
                .having("endAddress").gte(clientIPAddressPaddedBigInt)
                .toBuilder().build();
        return query.list();
    } catch (Exception e) {
        log.log(Level.SEVERE, "getRules client address troubles", e);
        // TODO: Proper Error codes.
        return null;
    }
}
 

import org.infinispan.query.dsl.Query; //导入依赖的package包/类
@Override
public List<?> getAllRules() {
    try {
        final RemoteCache<String, Rule> ruleCache = cacheManagerForIndexableCaches.getCache(SinkitCacheName.infinispan_rules.toString());
        log.log(Level.SEVERE, "getAllRules: This is a very expensive operation.");
        final QueryFactory qf = Search.getQueryFactory(ruleCache);
        final Query query = qf.from(Rule.class).build();
        // Hundreds of records...
        List<Rule> results = query.list();
        return results;
    } catch (Exception e) {
        log.log(Level.SEVERE, "getRules client address troubles", e);
        // TODO: Proper Error codes.
        return null;
    }
}
 

import org.infinispan.query.dsl.Query; //导入依赖的package包/类
@Override
public String deleteRulesByCustomer(Integer customerId) {
    int counter = 0;
    //TODO: Shouldn't this be done by a one Infinispan DSL removal call?
    try {
        final RemoteCache<String, Rule> ruleCache = cacheManagerForIndexableCaches.getCache(SinkitCacheName.infinispan_rules.toString());
        final QueryFactory qf = Search.getQueryFactory(ruleCache);
        Query query = qf.from(Rule.class)
                .having("customerId").eq(customerId)
                .toBuilder().build();
        // TODO: Use CloseableIterator
        Iterator iterator = query.list().iterator();
        while (iterator.hasNext()) {
            ruleCache.remove(((Rule) iterator.next()).getStartAddress());
            counter++;
        }
        return counter + " RULES DELETED FOR CUSTOMER ID: " + customerId;
    } catch (Exception e) {
        log.log(Level.SEVERE, "deleteRulesByCustomer", e);
        // TODO: Proper Error codes.
        return null;
    }
}
 

import org.infinispan.query.dsl.Query; //导入依赖的package包/类
@Override
public Object performKeySearch(String cacheName, String columnNameInSource, Object value, ObjectConnection conn) throws TranslatorException {
    
	
	@SuppressWarnings("rawtypes")
	QueryBuilder qb = getQueryBuilder(cacheName, conn);
    
	value = escapeReservedChars(value);
	
    FilterConditionContext fcc = qb.having(columnNameInSource).eq(value);
	
	Query query = fcc.toBuilder().build();
	List<Object> results = query.list();
	if (results.size() == 1) {
		return results.get(0);
	} else if (results.size() > 1) {
		throw new TranslatorException(InfinispanPlugin.Util.gs(InfinispanPlugin.Event.TEIID25053, value.toString()));
	}
	
	return null;
}
 

import org.infinispan.query.dsl.Query; //导入依赖的package包/类
@Override
protected void initialize(me.snowdrop.data.core.spi.Query<T> query) {
    queryBuilder = queryFactory.from(query.getEntityClass());

    String[] fields = toFields(getProjections(query));
    if (fields != null) {
        Expression[] projection = new Expression[fields.length];
        for (int i = 0; i < fields.length; i++) {
            projection[i] = Expression.property(fields[i]);
        }
        queryBuilder = queryBuilder.select(projection);
    }

    super.initialize(query);
}
 

import org.infinispan.query.dsl.Query; //导入依赖的package包/类
@Override
protected void applyQuery(me.snowdrop.data.core.spi.Query<T> query) {
    // we need to sort before creating query
    Sort sort = query.getSort();
    if (sort == null || sort.isUnsorted()) {
        Pageable pageable = query.getPageable();
        if (pageable != null && pageable.isPaged()) {
            sort = pageable.getSort();
        }
    }
    if (sort != null && sort.isSorted()) {
        queryHelper.convert(sort);
    }
}
 

import org.infinispan.query.dsl.Query; //导入依赖的package包/类
@Override
void execute(InfinispanConfiguration configuration, BasicCache<Object, Object> cache, Message message) {
    Query query = getQuery(configuration, cache, message);
    if (query == null) {
        return;
    }
    setResult(query.list(), message);
}
 

import org.infinispan.query.dsl.Query; //导入依赖的package包/类
Query getQuery(InfinispanConfiguration configuration, BasicCache<Object, Object> cache, Message message) {
    if (InfinispanUtil.isRemote(cache)) {
        return InfinispanRemoteOperation.buildQuery(configuration, cache, message);
    } else {
        return null;
    }

}
 

import org.infinispan.query.dsl.Query; //导入依赖的package包/类
@Override
protected void doStart() throws Exception {
    super.doStart();
    manager.start();

    cache = manager.getCache();
    if (configuration.hasQueryBuilder()) {
        if (InfinispanUtil.isRemote(cache)) {
            RemoteCache<Object, Object> remoteCache = InfinispanUtil.asRemote(cache);
            Query query = InfinispanRemoteOperation.buildQuery(configuration.getQueryBuilder(), remoteCache);

            continuousQuery = Search.getContinuousQuery(remoteCache);
            continuousQuery.addContinuousQueryListener(query, new ContinuousQueryEventListener(cache.getName()));
        } else {
            throw new IllegalArgumentException(
                "Can't run continuous queries against embedded cache (" + cache.getName() + ")");
        }
    } else {
        if (manager.isCacheContainerEmbedded()) {
            consumerHandler = InfinispanConsumerEmbeddedHandler.INSTANCE;
        } else if (manager.isCacheContainerRemote()) {
            consumerHandler = InfinispanConsumerRemoteHandler.INSTANCE;
        } else {
            throw new UnsupportedOperationException(
                "Unsupported CacheContainer type " + manager.getCacheContainer().getClass().getName());
        }

        listener = consumerHandler.start(this);
    }
}