Java Query.asList方法代码示例

import org.mongodb.morphia.query.Query; //导入方法依赖的package包/类
/**
 *
 * @param queryCriteria - key is field and operator and value is RHS value
 * eg: "Location in" => "Delhi"
 * @param sortCriteria - comma separated field names. use - for descending
 * order eg: "location, -status"
 * @param pageInfo - contain limit and offset
 * @return
 */
public List<T> filter(Map<String, Object> queryCriteria, String sortCriteria, PageInfo pageInfo) {
    Query<T> query = datastore.createQuery(genericType);

    for (Map.Entry<String, Object> entry : queryCriteria.entrySet()) {
        query = query.filter(entry.getKey(), entry.getValue());
    }

    if (pageInfo == null) {
        pageInfo = new PageInfo(100000, 0);
    }

    if (sortCriteria == null) {
        sortCriteria = "_id";
    }

    query = query.limit(pageInfo.getLimit()).offset(pageInfo.getOffset());
    query = query.order(sortCriteria);

    return query.asList();
}
 

import org.mongodb.morphia.query.Query; //导入方法依赖的package包/类
public List<EmployeeEntity> findBySalary(final BigDecimal minimum, final BigDecimal maximum) {

    /**
     * Check that the minimum is not negative and that the maximum is not
     * smaller than the minimum.
     */
    if (((minimum != null) && (minimum.compareTo(BigDecimal.ZERO) < 0))
	|| ((minimum != null) && (maximum != null) && (maximum.compareTo(minimum) < 0))) {
      return new ArrayList<>();
    }
    Query<EmployeeEntity> query = mongoDatastore.find(EmployeeEntity.class);
    if (minimum != null) {
      BigDecimal minimumScale = minimum.setScale(2, BigDecimal.ROUND_HALF_UP);
      query.filter("salaryString >=", minimumScale.toPlainString());
    }
    if (maximum != null) {
      BigDecimal maximumScale = maximum.setScale(2, BigDecimal.ROUND_HALF_UP);
      query.filter("salaryString <=", maximumScale.toPlainString());
    }
    return query.asList();
  }
 

import org.mongodb.morphia.query.Query; //导入方法依赖的package包/类
public List<EmployeeEntity> findBySalaryFluent(final BigDecimal minimum,
					 final BigDecimal maximum) {
   if (((minimum != null) && (minimum.compareTo(BigDecimal.ZERO) < 0))
|| ((minimum != null) && (maximum != null) && (maximum.compareTo(minimum) < 0))) {
     return new ArrayList<>();
   }
   Query<EmployeeEntity> query = mongoDatastore.find(EmployeeEntity.class);
   if (minimum != null) {
     BigDecimal minimumScale = minimum.setScale(2, BigDecimal.ROUND_HALF_UP);
     query.field("salary").greaterThanOrEq(minimumScale.toPlainString());
   }
   if (maximum != null) {
     BigDecimal maximumScale = maximum.setScale(2, BigDecimal.ROUND_HALF_UP);
     query.field("salary").lessThanOrEq(maximumScale.toPlainString());
   }
   return query.asList();
 }
 

import org.mongodb.morphia.query.Query; //导入方法依赖的package包/类
public <T extends DbBackedBuild> Iterable<T> getCurrentUserBuilds(final DbBackedProject project, final int i, final Result result) {
    Query<DbBackedBuild> query = getQuery(project)
        .limit(i)
        .order("-number");

    query.or(
        query.criteria("actions.causes.user").equal(Jenkins.getAuthentication().getName()),
        query.criteria("actions.causes.pusher").equal(Jenkins.getAuthentication().getName())
    );

    if (result != null) {
        query = query.filter("result", result.toString());
    }
    final List<DbBackedBuild> builds = query.asList();

    for (final DbBackedBuild build : builds) {
        associateProject(project, build);
    }

    return (Iterable<T>) builds;
}
 

import org.mongodb.morphia.query.Query; //导入方法依赖的package包/类
private Criteria compositeProperty(Class<?> clazz, Object value){
	
	EntityClassProvider ecp = ServiceLocator.getServiceImplementation(EntityClassProvider.class);
	
	String[] properties = propertyName.split("\\.");
	
	Query<?> q = getQuery(ecp.getEntityClass(properties[properties.length - 2]));
	
	switch(compType){
		case GREATER_OR_EQUALS: q.field(properties[properties.length - 1]).greaterThanOrEq(value); break;
		case LESSER_OR_EQUALS: q.field(properties[properties.length - 1]).lessThanOrEq(value); break;
		case GREATER: q.field(properties[properties.length - 1]).greaterThan(value); break;
		case LESSER: q.field(properties[properties.length - 1]).lessThan(value); break;
		case NOT_EQUALS: q.field(properties[properties.length - 1]).notEqual(value); break;
		case EQUALS: q.field(properties[properties.length - 1]).equal(value); break;
		default: q.field(properties[properties.length - 1]).contains((String)value); break;
	}
	
	List<?> results = q.asList();
	
	for(int i = properties.length - 3; i >= 0; i--){
		Query<?> query = getQuery(ecp.getEntityClass(properties[i]));
		query.field(properties[i + 1]).in(results);
		results = query.asList();
	}
	
	return getQuery(clazz).criteria(properties[0]).in(results);
}
 

import org.mongodb.morphia.query.Query; //导入方法依赖的package包/类
public <T extends DbBackedBuild> Iterable<T> getLast(final DbBackedProject project, final int i, final String branch, final Result result) {
    Query<DbBackedBuild> query = getQuery(project).limit(i).order("-number");

    if (branch != null) {
        query = filterExpression(branch, query);
    }
    if (result != null) {
        query = query.filter("result", result.toString());
    }

    final List<DbBackedBuild> builds = query.asList();

    for (final DbBackedBuild build : builds) {
        associateProject(project, build);
    }

    return (Iterable<T>) builds;
}
 

import org.mongodb.morphia.query.Query; //导入方法依赖的package包/类
/**
 * {@inheritDoc}
 */
@Override
public <T extends BaseEntity> List<T> findAll(Class<T> tClass, FindOptions findOptions, Map<String, Object> criteriaMap) {
    Query<T> tQuery = this.datastore.createQuery(tClass);
    if (criteriaMap.size() > 0) {
        criteriaMap.forEach(
            (key, value) -> {
                tQuery.field(key)
                        .equal(value);
            }
        );
    }
    return (Objects.nonNull(findOptions)) ?
            tQuery.asList(findOptions) : tQuery.asList();
}
 

import org.mongodb.morphia.query.Query; //导入方法依赖的package包/类
protected List<JobPo> load(String loadTaskTrackerNodeGroup, int loadSize) {
    // load
    String tableName = JobQueueUtils.getExecutableQueueName(loadTaskTrackerNodeGroup);
    Query<JobPo> query = template.createQuery(tableName, JobPo.class);
    query.field("isRunning").equal(false)
            .filter("triggerTime < ", SystemClock.now())
            .order(" triggerTime, priority , gmtCreated").offset(0).limit(loadSize);
    return query.asList();
}
 

import org.mongodb.morphia.query.Query; //导入方法依赖的package包/类
@Override
public List<JobPo> getDeadJob(String taskTrackerNodeGroup, long deadline) {
    String tableName = JobQueueUtils.getExecutableQueueName(taskTrackerNodeGroup);
    Query<JobPo> query = template.createQuery(tableName, JobPo.class);
    query.field("isRunning").equal(true).
            filter("gmtCreated < ", deadline);
    return query.asList();
}
 

import org.mongodb.morphia.query.Query; //导入方法依赖的package包/类
/**
 * @param ids
 * @param sortCriteria - comma separated field names. use - for descending
 * order eg: "location, -status"
 * @param pageInfo - contain limit and offset
 * @return
 */
public List<T> getMany(List<String> ids, String sortCriteria, PageInfo pageInfo) {
    Query<T> query = datastore.createQuery(genericType);
    query = query.field("_id").in(ids);
    query = query.limit(pageInfo.getLimit()).offset(pageInfo.getOffset());
    query = query.order(sortCriteria);

    return query.asList();
}
 

import org.mongodb.morphia.query.Query; //导入方法依赖的package包/类
/**
 * 查询日志通用接口查询多个对象
 * @param filter	条件字符串组
 * @param value		参数组
 * @throws SQLException
 */
public List<T> queryForList(String[] filter, Object[] value) throws SQLException
{
	if(filter == null || value == null)
		return new ArrayList<T>();
	Query<T> query = getDao().createQuery().disableValidation();
	queryAnalasis(query, filter, value);
	return query.asList();
}
 

import org.mongodb.morphia.query.Query; //导入方法依赖的package包/类
public Iterable<DynamicBuild> getLastBuildsForUser(final String user, final int numberOfBuilds) {

        final Query<DynamicBuild> query = getDynamicBuildsForUser(user, numberOfBuilds);

        final List<DynamicBuild> builds = query.asList();

        final DynamicProjectRepository repo = SetupConfig.get().getDynamicProjectRepository();
        for (final DbBackedBuild build : builds) {
            final DbBackedProject project = repo.getProjectById(build.getProjectId());
            associateProject(project, build);
        }

        return builds;
    }
 

import org.mongodb.morphia.query.Query; //导入方法依赖的package包/类
public List<Association> findAssociationsForUserAccount(UserAccount u) {
    Query<Association> q = getDatastore().createQuery(Association.class);
    q.or(
            q.criteria("one").equal(u),
            q.criteria("other").equal(u)
    );
    return q.asList();
}
 

import org.mongodb.morphia.query.Query; //导入方法依赖的package包/类
public List<? extends Association> getAssociationsOfType(Object object, Class clazz) {
    Query<Association> q = getDatastore().createQuery(Association.class);
    q.and(
            q.criteria("one").equal(object.getId()),
            q.criteria("class").equal(clazz)
    );
    return q.asList();
}
 

import org.mongodb.morphia.query.Query; //导入方法依赖的package包/类
public List<M> getNotVIndexed(int numImages) {
    //Disable validation because className is not a declared field
	Query<M> q = getDatastore().find(clazz).disableValidation().filter("annotations.className nin", LocalDescriptors.class.getName()).limit(numImages);
	List<M> result = q.asList();
	
	return result;
}