@Override public List<VmDiskStatisticsVO> listBy(long accountId) { SearchCriteria<VmDiskStatisticsVO> sc = AccountSearch.create(); sc.setParameters("account", accountId); return search(sc, null); }
@Override public List<VmDiskStatisticsVO> listUpdatedStats() { List<VmDiskStatisticsVO> vmDiskStats = new ArrayList<VmDiskStatisticsVO>(); TransactionLegacy txn = TransactionLegacy.currentTxn(); try { PreparedStatement pstmt = null; pstmt = txn.prepareAutoCloseStatement(UPDATED_VM_NETWORK_STATS_SEARCH); ResultSet rs = pstmt.executeQuery(); while (rs.next()) { vmDiskStats.add(toEntityBean(rs, false)); } } catch (Exception ex) { s_logger.error("error lisitng updated vm disk stats", ex); } return vmDiskStats; }
@Override public VmDiskStatisticsVO lock(long accountId, long dcId, long vmId, long volumeId) { SearchCriteria<VmDiskStatisticsVO> sc = AllFieldsSearch.create(); sc.setParameters("account", accountId); sc.setParameters("dc", dcId); sc.setParameters("volume", volumeId); sc.setParameters("vm", vmId); return lockOneRandomRow(sc, true); }
@Override public VmDiskStatisticsVO findBy(long accountId, long dcId, long vmId, long volumeId) { SearchCriteria<VmDiskStatisticsVO> sc = AllFieldsSearch.create(); sc.setParameters("account", accountId); sc.setParameters("dc", dcId); sc.setParameters("volume", volumeId); sc.setParameters("vm", vmId); return findOneBy(sc); }
public VmDiskStatisticsDaoImpl() { AccountSearch = createSearchBuilder(); AccountSearch.and("account", AccountSearch.entity().getAccountId(), SearchCriteria.Op.EQ); AccountSearch.done(); AllFieldsSearch = createSearchBuilder(); AllFieldsSearch.and("account", AllFieldsSearch.entity().getAccountId(), SearchCriteria.Op.EQ); AllFieldsSearch.and("dc", AllFieldsSearch.entity().getDataCenterId(), SearchCriteria.Op.EQ); AllFieldsSearch.and("volume", AllFieldsSearch.entity().getVolumeId(), SearchCriteria.Op.EQ); AllFieldsSearch.and("vm", AllFieldsSearch.entity().getVmId(), SearchCriteria.Op.EQ); AllFieldsSearch.done(); }
@Override public List<VmDiskStatisticsVO> listActiveAndRecentlyDeleted(Date minRemovedDate, int startIndex, int limit) { List<VmDiskStatisticsVO> vmDiskStats = new ArrayList<VmDiskStatisticsVO>(); if (minRemovedDate == null) return vmDiskStats; TransactionLegacy txn = TransactionLegacy.currentTxn(); try { String sql = ACTIVE_AND_RECENTLY_DELETED_SEARCH + " LIMIT " + startIndex + "," + limit; PreparedStatement pstmt = null; pstmt = txn.prepareAutoCloseStatement(sql); pstmt.setString(1, DateUtil.getDateDisplayString(TimeZone.getTimeZone("GMT"), minRemovedDate)); ResultSet rs = pstmt.executeQuery(); while (rs.next()) { vmDiskStats.add(toEntityBean(rs, false)); } } catch (Exception ex) { s_logger.error("error saving vm disk stats to cloud_usage db", ex); } return vmDiskStats; }