Examples with Filter com.cloud.utils.db.Filter used on opensource projects

Example 41 with Filter

use of com.cloud.utils.db.Filter in project cloudstack by apache.

the class SyncQueueItemDaoImpl method getActiveQueueItems.

@Override
public List<SyncQueueItemVO> getActiveQueueItems(Long msid, boolean exclusive) {
    SearchBuilder<SyncQueueItemVO> sb = createSearchBuilder();
    sb.and("lastProcessMsid", sb.entity().getLastProcessMsid(), SearchCriteria.Op.EQ);
    sb.done();
    SearchCriteria<SyncQueueItemVO> sc = sb.create();
    sc.setParameters("lastProcessMsid", msid);
    Filter filter = new Filter(SyncQueueItemVO.class, "created", true, null, null);
    if (exclusive)
        return lockRows(sc, filter, true);
    return listBy(sc, filter);
}

Example 42 with Filter

use of com.cloud.utils.db.Filter in project cloudstack by apache.

the class VmWorkJobDaoImpl method listPendingWorkJobs.

@Override
public List<VmWorkJobVO> listPendingWorkJobs(VirtualMachine.Type type, long instanceId, String jobCmd) {
    SearchCriteria<VmWorkJobVO> sc = PendingWorkJobByCommandSearch.create();
    sc.setParameters("jobStatus", JobInfo.Status.IN_PROGRESS);
    sc.setParameters("vmType", type);
    sc.setParameters("vmInstanceId", instanceId);
    sc.setParameters("cmd", jobCmd);
    Filter filter = new Filter(VmWorkJobVO.class, "created", true, null, null);
    return this.listBy(sc, filter);
}

Example 43 with Filter

use of com.cloud.utils.db.Filter in project cloudstack by apache.

the class AsyncJobDaoImpl method getExpiredUnfinishedJobs.

@Override
public List<AsyncJobVO> getExpiredUnfinishedJobs(Date cutTime, int limit) {
    SearchCriteria<AsyncJobVO> sc = expiringUnfinishedAsyncJobSearch.create();
    sc.setParameters("jobDispatcher", AsyncJobVO.JOB_DISPATCHER_PSEUDO);
    sc.setParameters("created", cutTime);
    sc.setParameters("jobStatus", JobInfo.Status.IN_PROGRESS);
    Filter filter = new Filter(AsyncJobVO.class, "created", true, 0L, (long) limit);
    return listIncludingRemovedBy(sc, filter);
}

Example 44 with Filter

use of com.cloud.utils.db.Filter in project cloudstack by apache.

the class SyncQueueItemDaoImpl method getNextQueueItem.

@Override
public SyncQueueItemVO getNextQueueItem(long queueId) {
    SearchBuilder<SyncQueueItemVO> sb = createSearchBuilder();
    sb.and("queueId", sb.entity().getQueueId(), SearchCriteria.Op.EQ);
    sb.and("lastProcessNumber", sb.entity().getLastProcessNumber(), SearchCriteria.Op.NULL);
    sb.done();
    SearchCriteria<SyncQueueItemVO> sc = sb.create();
    sc.setParameters("queueId", queueId);
    Filter filter = new Filter(SyncQueueItemVO.class, "created", true, 0L, 1L);
    List<SyncQueueItemVO> l = listBy(sc, filter);
    if (l != null && l.size() > 0)
        return l.get(0);
    return null;
}

Example 45 with Filter

use of com.cloud.utils.db.Filter in project cloudstack by apache.

the class AsyncJobDaoImpl method getResetJobs.

@Override
public List<AsyncJobVO> getResetJobs(long msid) {
    SearchCriteria<AsyncJobVO> sc = pendingAsyncJobSearch.create();
    sc.setParameters("status", JobInfo.Status.IN_PROGRESS);
    // construct query: (job_executing_msid=msid OR (job_executing_msid IS NULL AND job_init_msid=msid))
    SearchCriteria<AsyncJobVO> msQuery = createSearchCriteria();
    msQuery.addOr("executingMsid", SearchCriteria.Op.EQ, msid);
    SearchCriteria<AsyncJobVO> initMsQuery = createSearchCriteria();
    initMsQuery.addAnd("executingMsid", SearchCriteria.Op.NULL);
    initMsQuery.addAnd("initMsid", SearchCriteria.Op.EQ, msid);
    msQuery.addOr("initMsid", SearchCriteria.Op.SC, initMsQuery);
    sc.addAnd("executingMsid", SearchCriteria.Op.SC, msQuery);
    Filter filter = new Filter(AsyncJobVO.class, "created", true, null, null);
    return listIncludingRemovedBy(sc, filter);
}