@Override public List<SecurityGroupRulesVO> listSecurityGroupRules() { Filter searchFilter = new Filter(SecurityGroupRulesVO.class, "id", true, null, null); return listAll(searchFilter); }
Filter searchFilter = new Filter(TemplateJoinVO.class, "sortKey", isAscending, null, null); searchFilter.addOrderBy(TemplateJoinVO.class, "tempZonePair", isAscending); List<TemplateJoinVO> uvList = new ArrayList<TemplateJoinVO>();
@DB() protected void addFilter(final StringBuilder sql, final Filter filter) { if (filter != null) { if (filter.getOrderBy() != null) { sql.append(filter.getOrderBy()); } if (filter.getOffset() != null) { sql.append(" LIMIT "); sql.append(filter.getOffset()); if (filter.getLimit() != null) { sql.append(", ").append(filter.getLimit()); } } } }
@Override public Pair<List<? extends UsageVO>, Integer> doInTransaction(final TransactionStatus status) { Pair<List<UsageVO>, Integer> usageRecords = new Pair<List<UsageVO>, Integer>(new ArrayList<UsageVO>(), 0); Filter usageFilter = new Filter(UsageVO.class, "startDate", true, 0L, Long.MAX_VALUE); QueryBuilder<UsageVO> qb = QueryBuilder.create(UsageVO.class); if (accountId != -1) { qb.and(qb.entity().getAccountId(), SearchCriteria.Op.EQ, accountId); } if (domainId != -1) { qb.and(qb.entity().getDomainId(), SearchCriteria.Op.EQ, domainId); } qb.and(qb.entity().getQuotaCalculated(), SearchCriteria.Op.NEQ, 1); qb.and(qb.entity().getRawUsage(), SearchCriteria.Op.GT, 0); if (s_logger.isDebugEnabled()) { s_logger.debug("Getting usage records" + usageFilter.getOrderBy()); } usageRecords = searchAndCountAllRecords(qb.create(), usageFilter); return new Pair<List<? extends UsageVO>, Integer>(usageRecords.first(), usageRecords.second()); } });
/** * @param clazz the VO object type * @param field name of the field * @param offset * @param limit */ public Filter(Class<?> clazz, String field, boolean ascending, Long offset, Long limit) { _offset = offset; _limit = limit; addOrderBy(clazz, field, ascending); }
/** * @param clazz the VO object type * @param field name of the field * @param offset * @param limit */ public Filter(final Class<?> clazz, final String field, final boolean ascending, final Long offset, final Long limit) { _offset = offset; _limit = limit; addOrderBy(clazz, field, ascending); }
@Override public List<UsageEventVO> getLatestEvent() { Filter filter = new Filter(UsageEventVO.class, "id", Boolean.FALSE, Long.valueOf(0), Long.valueOf(1)); return listAll(filter); }
Filter filter = new Filter(IPAddressVO.class, "forSystemVms", ascOrder, 0l, 1l); if (SystemVmPublicIpReservationModeStrictness.value()) { sc.setParameters("forSystemVms", forSystemVms); filter.addOrderBy(IPAddressVO.class,"vlanId", true);
@DB() protected void addFilter(final StringBuilder sql, final Filter filter) { if (filter != null) { if (filter.getOrderBy() != null) { sql.append(filter.getOrderBy()); } if (filter.getOffset() != null) { sql.append(" LIMIT "); sql.append(filter.getOffset()); if (filter.getLimit() != null) { sql.append(", ").append(filter.getLimit()); } } } }
@DB() protected T findOneIncludingRemovedBy(final SearchCriteria<T> sc) { Filter filter = new Filter(1); List<T> results = searchIncludingRemoved(sc, filter, null, false); assert results.size() <= 1 : "Didn't the limiting worked?"; return results.size() == 0 ? null : results.get(0); }
Filter searchFilter = new Filter(TemplateJoinVO.class, "sortKey", isAscending, startIndex, pageSize); searchFilter.addOrderBy(TemplateJoinVO.class, "tempZonePair", isAscending);
@Override @DB() public T lockOneRandomRow(final SearchCriteria<T> sc, final boolean exclusive) { final Filter filter = new Filter(1); final List<T> beans = search(sc, filter, exclusive, true); return beans.isEmpty() ? null : beans.get(0); }
@Override public UsageJobVO getLastJob() { Filter filter = new Filter(UsageJobVO.class, "id", false, Long.valueOf(0), Long.valueOf(1)); SearchCriteria<UsageJobVO> sc = createSearchCriteria(); sc.addAnd("endMillis", SearchCriteria.Op.EQ, Long.valueOf(0)); List<UsageJobVO> jobs = search(sc, filter); if ((jobs == null) || jobs.isEmpty()) { return null; } return jobs.get(0); }
@Override public Date getLastHeartbeat() { Filter filter = new Filter(UsageJobVO.class, "heartbeat", false, Long.valueOf(0), Long.valueOf(1)); SearchCriteria<UsageJobVO> sc = createSearchCriteria(); List<UsageJobVO> jobs = search(sc, filter); if ((jobs == null) || jobs.isEmpty()) { return null; } return jobs.get(0).getHeartbeat(); } }
private UsageJobVO getNextRecurringJob() { Filter filter = new Filter(UsageJobVO.class, "id", false, Long.valueOf(0), Long.valueOf(1)); SearchCriteria<UsageJobVO> sc = createSearchCriteria(); sc.addAnd("endMillis", SearchCriteria.Op.EQ, Long.valueOf(0)); sc.addAnd("jobType", SearchCriteria.Op.EQ, Integer.valueOf(UsageJobVO.JOB_TYPE_RECURRING)); List<UsageJobVO> jobs = search(sc, filter); if ((jobs == null) || jobs.isEmpty()) { return null; } return jobs.get(0); }
@Override public UsageJobVO getNextImmediateJob() { Filter filter = new Filter(UsageJobVO.class, "id", false, Long.valueOf(0), Long.valueOf(1)); SearchCriteria<UsageJobVO> sc = createSearchCriteria(); sc.addAnd("endMillis", SearchCriteria.Op.EQ, Long.valueOf(0)); sc.addAnd("jobType", SearchCriteria.Op.EQ, Integer.valueOf(UsageJobVO.JOB_TYPE_SINGLE)); sc.addAnd("scheduled", SearchCriteria.Op.EQ, Integer.valueOf(0)); List<UsageJobVO> jobs = search(sc, filter); if ((jobs == null) || jobs.isEmpty()) { return null; } return jobs.get(0); }
@Override public QuotaTariffVO doInTransaction(final TransactionStatus status) { List<QuotaTariffVO> result = new ArrayList<>(); final Filter filter = new Filter(QuotaTariffVO.class, "updatedOn", false, 0L, 1L); final SearchCriteria<QuotaTariffVO> sc = listAllIncludedUsageType.create(); sc.setParameters("onorbefore", effectiveDate); sc.setParameters("quotatype", quotaType); result = search(sc, filter); if (result != null && !result.isEmpty()) { return result.get(0); } else { if (s_logger.isDebugEnabled()) { s_logger.debug("QuotaTariffDaoImpl::findTariffPlanByUsageType: Missing quota type " + quotaType); } return null; } } });
@Override public List<RolePermissionVO> findAllByRoleIdSorted(final Long roleId) { final SearchCriteria<RolePermissionVO> sc = RolePermissionsSearch.create(); if (roleId != null && roleId > 0L) { sc.setParameters("roleId", roleId); } final Filter searchBySorted = new Filter(RolePermissionVO.class, "sortOrder", true, null, null); final List<RolePermissionVO> rolePermissionList = listBy(sc, searchBySorted); if (rolePermissionList == null) { return Collections.emptyList(); } return rolePermissionList; } }
@Override public AlertVO getLastAlert(short type, long dataCenterId, Long podId) { Filter searchFilter = new Filter(AlertVO.class, "createdDate", Boolean.FALSE, Long.valueOf(0), Long.valueOf(1)); SearchCriteria<AlertVO> sc = createSearchCriteria(); sc.addAnd("type", SearchCriteria.Op.EQ, Short.valueOf(type)); sc.addAnd("dataCenterId", SearchCriteria.Op.EQ, Long.valueOf(dataCenterId)); sc.addAnd("archived", SearchCriteria.Op.EQ, false); if (podId != null) { sc.addAnd("podId", SearchCriteria.Op.EQ, podId); } List<AlertVO> alerts = listBy(sc, searchFilter); if ((alerts != null) && !alerts.isEmpty()) { return alerts.get(0); } return null; }
@Override public List<SecurityGroupRulesVO> listSecurityGroupRules(long accountId) { Filter searchFilter = new Filter(SecurityGroupRulesVO.class, "id", true, null, null); SearchCriteria<SecurityGroupRulesVO> sc = AccountSearch.create(); sc.setParameters("accountId", accountId); return listBy(sc, searchFilter); }