Liron Ar has uploaded a new change for review. Change subject: core: Add sp for getting vms/templates with attached disks on domain ......................................................................
core: Add sp for getting vms/templates with attached disks on domain Change-Id: I918c540924961bf0ab99111a6d835c5a8211d20b TODO: include sql file here Signed-off-by: Liron Aravot <lara...@redhat.com> --- M backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/StorageDomainDAO.java M backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/StorageDomainDAODbFacadeImpl.java 2 files changed, 13 insertions(+), 0 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/65/23465/1 diff --git a/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/StorageDomainDAO.java b/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/StorageDomainDAO.java index 50765a7..f30b148 100644 --- a/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/StorageDomainDAO.java +++ b/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/StorageDomainDAO.java @@ -181,4 +181,9 @@ * @return the list of storage domains (empty if no storage matches the criteria) */ List<StorageDomain> getPermittedStorageDomainsByStoragePool(Guid userId, ActionGroup actionGroup, Guid storagePoolId); + + /** + * Retrieves all ids of vms and templates that has image disks on the given domain + */ + List<Guid> getVmAndTemplatesIdsByStorageDomainId(Guid storageDomainId); } diff --git a/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/StorageDomainDAODbFacadeImpl.java b/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/StorageDomainDAODbFacadeImpl.java index 0805cd1a..2ec3868 100644 --- a/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/StorageDomainDAODbFacadeImpl.java +++ b/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/StorageDomainDAODbFacadeImpl.java @@ -188,6 +188,14 @@ .addValue("storage_pool_id", storagePoolId)); } + @Override + public List<Guid> getVmAndTemplatesIdsByStorageDomainId(Guid storageDomainId) { + return getCallsHandler().executeReadList("GetVmAndTemplatesIdsByStorageDomainId", + createGuidMapper(), + getCustomMapSqlParameterSource() + .addValue("storage_domain_id", storageDomainId)); + } + /** * Gets the storage domain id of the given type for the given storage pool * -- To view, visit http://gerrit.ovirt.org/23465 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I918c540924961bf0ab99111a6d835c5a8211d20b Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Liron Ar <lara...@redhat.com> _______________________________________________ Engine-patches mailing list Engine-patches@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-patches