Daniel Erez has uploaded a new change for review. Change subject: core: remove obsolete StorageDomainTemplateQuery ......................................................................
core: remove obsolete StorageDomainTemplateQuery Cleanup - removing obsolete query: StorageDomainTemplateQuery Change-Id: I9e090b64dd8b47a9c79dc8ad6a1c3caab62031b6 Signed-off-by: Daniel Erez <de...@redhat.com> --- M backend/manager/dbscripts/disk_images_sp.sql D backend/manager/modules/bll/src/main/java/org/ovirt/engine/core/bll/GetImagesByStorageDomainAndTemplateQuery.java D backend/manager/modules/common/src/main/java/org/ovirt/engine/core/common/queries/StorageDomainTemplateQueryParameters.java M backend/manager/modules/common/src/main/java/org/ovirt/engine/core/common/queries/VdcQueryType.java M backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/DiskImageDAO.java M backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/DiskImageDAODbFacadeImpl.java M backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/DiskImageDAOWrapperImpl.java M backend/manager/modules/dal/src/test/java/org/ovirt/engine/core/dao/DiskImageDAOTest.java 8 files changed, 0 insertions(+), 106 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/20/10320/1 diff --git a/backend/manager/dbscripts/disk_images_sp.sql b/backend/manager/dbscripts/disk_images_sp.sql index 12bbcea..656c207 100644 --- a/backend/manager/dbscripts/disk_images_sp.sql +++ b/backend/manager/dbscripts/disk_images_sp.sql @@ -136,24 +136,6 @@ LANGUAGE plpgsql; -Create or replace FUNCTION GetImageByStorageIdAndTemplateId(v_storage_id UUID, v_template_id UUID) -RETURNS SETOF images_storage_domain_view - AS $procedure$ -BEGIN - IF v_template_id IS NULL then - RETURN QUERY SELECT images_storage_domain_view.* - FROM images_storage_domain_view - WHERE images_storage_domain_view.storage_id = v_storage_id AND images_storage_domain_view.entity_type::text = 'TEMPLATE'::text; - ELSE - RETURN QUERY SELECT images_storage_domain_view.* - FROM images_storage_domain_view - JOIN vm_device ON vm_device.device_id = images_storage_domain_view.disk_id - WHERE images_storage_domain_view.storage_id = v_storage_id - AND vm_device.vm_id = v_template_id - AND images_storage_domain_view.entity_type::text = 'TEMPLATE'::text; - END IF; -END; $procedure$ -LANGUAGE plpgsql; Create or replace FUNCTION GetImagesWhichHaveNoDisk(v_vm_id UUID) diff --git a/backend/manager/modules/bll/src/main/java/org/ovirt/engine/core/bll/GetImagesByStorageDomainAndTemplateQuery.java b/backend/manager/modules/bll/src/main/java/org/ovirt/engine/core/bll/GetImagesByStorageDomainAndTemplateQuery.java deleted file mode 100644 index 8cf02b2..0000000 --- a/backend/manager/modules/bll/src/main/java/org/ovirt/engine/core/bll/GetImagesByStorageDomainAndTemplateQuery.java +++ /dev/null @@ -1,21 +0,0 @@ -package org.ovirt.engine.core.bll; - -import org.ovirt.engine.core.common.queries.StorageDomainTemplateQueryParameters; -import org.ovirt.engine.core.dal.dbbroker.DbFacade; - -public class GetImagesByStorageDomainAndTemplateQuery<P extends StorageDomainTemplateQueryParameters> extends QueriesCommandBase<P> { - - public GetImagesByStorageDomainAndTemplateQuery(P parameters) { - super(parameters); - } - - @Override - protected void executeQueryCommand() { - getQueryReturnValue().setReturnValue(DbFacade.getInstance() - .getDiskImageDao() - .getImagesByStorageIdAndTemplateId(getParameters().getStorageDomainId(), - getParameters().getTemplateId())); - - } - -} diff --git a/backend/manager/modules/common/src/main/java/org/ovirt/engine/core/common/queries/StorageDomainTemplateQueryParameters.java b/backend/manager/modules/common/src/main/java/org/ovirt/engine/core/common/queries/StorageDomainTemplateQueryParameters.java deleted file mode 100644 index 162fad5..0000000 --- a/backend/manager/modules/common/src/main/java/org/ovirt/engine/core/common/queries/StorageDomainTemplateQueryParameters.java +++ /dev/null @@ -1,27 +0,0 @@ -package org.ovirt.engine.core.common.queries; - -import org.ovirt.engine.core.compat.Guid; - -public class StorageDomainTemplateQueryParameters extends StorageDomainQueryParametersBase { - - private static final long serialVersionUID = 3787908881298340953L; - private Guid templateId; - - public StorageDomainTemplateQueryParameters(Guid storageId) { - this(storageId, null); - } - - public StorageDomainTemplateQueryParameters(Guid storageId, Guid templateId) { - super(storageId); - this.templateId = templateId; - } - - public void setTemplateId(Guid templateId) { - this.templateId = templateId; - } - - public Guid getTemplateId() { - return templateId; - } - -} diff --git a/backend/manager/modules/common/src/main/java/org/ovirt/engine/core/common/queries/VdcQueryType.java b/backend/manager/modules/common/src/main/java/org/ovirt/engine/core/common/queries/VdcQueryType.java index 54b5714..be6a423 100644 --- a/backend/manager/modules/common/src/main/java/org/ovirt/engine/core/common/queries/VdcQueryType.java +++ b/backend/manager/modules/common/src/main/java/org/ovirt/engine/core/common/queries/VdcQueryType.java @@ -96,7 +96,6 @@ GetAllDisks, GetImageByImageId, GetDiskByDiskId, - GetImagesByStorageDomainAndTemplate, // Users queries GetUserVmsByUserIdAndGroups(VdcQueryAuthType.User), diff --git a/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/DiskImageDAO.java b/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/DiskImageDAO.java index 3b6bd43..6c35574 100644 --- a/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/DiskImageDAO.java +++ b/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/DiskImageDAO.java @@ -77,6 +77,4 @@ // TODO mapping methods moved out of DbFacade that will be removed when we have Hibernate List<DiskImage> getAllForQuotaId(Guid quotaId); - - List<DiskImage> getImagesByStorageIdAndTemplateId(Guid storageId, Guid templateId); } diff --git a/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/DiskImageDAODbFacadeImpl.java b/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/DiskImageDAODbFacadeImpl.java index 1e985bf..b8a68b5 100644 --- a/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/DiskImageDAODbFacadeImpl.java +++ b/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/DiskImageDAODbFacadeImpl.java @@ -104,17 +104,6 @@ } @Override - public List<DiskImage> getImagesByStorageIdAndTemplateId(Guid storageId, Guid templateId) { - MapSqlParameterSource parameterSource = getCustomMapSqlParameterSource() - .addValue("storage_id", storageId) - .addValue("template_id", templateId); - - return getCallsHandler().executeReadList("GetImageByStorageIdAndTemplateId", - DiskImageRowMapper.instance, - parameterSource); - } - - @Override public List<DiskImage> getImagesWithNoDisk(Guid vmId) { MapSqlParameterSource parameterSource = getCustomMapSqlParameterSource() .addValue("vm_id", vmId); diff --git a/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/DiskImageDAOWrapperImpl.java b/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/DiskImageDAOWrapperImpl.java index 06f681a..763e900 100644 --- a/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/DiskImageDAOWrapperImpl.java +++ b/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/DiskImageDAOWrapperImpl.java @@ -72,12 +72,6 @@ } @Override - public List<DiskImage> getImagesByStorageIdAndTemplateId(Guid storageId, Guid templateId) { - // TODO Auto-generated method stub - return null; - } - - @Override public List<DiskImage> getImagesWithNoDisk(Guid vmId) { throw new NotImplementedException(); } diff --git a/backend/manager/modules/dal/src/test/java/org/ovirt/engine/core/dao/DiskImageDAOTest.java b/backend/manager/modules/dal/src/test/java/org/ovirt/engine/core/dao/DiskImageDAOTest.java index 0e0c5b9..3308d5d 100644 --- a/backend/manager/modules/dal/src/test/java/org/ovirt/engine/core/dao/DiskImageDAOTest.java +++ b/backend/manager/modules/dal/src/test/java/org/ovirt/engine/core/dao/DiskImageDAOTest.java @@ -86,26 +86,6 @@ } @Test - public void testGetImagesByStorageIdAndTempleteNull() { - List<DiskImage> result = - dao.getImagesByStorageIdAndTemplateId(Guid.createGuidFromString("72e3a666-89e1-4005-a7ca-f7548004a9ab"), - null); - - assertNotNull(result); - assertFalse(result.isEmpty()); - } - - @Test - public void testGetImagesByStorageIdAndTempleteId() { - List<DiskImage> result = - dao.getImagesByStorageIdAndTemplateId(Guid.createGuidFromString("72e3a666-89e1-4005-a7ca-f7548004a9ab"), - Guid.createGuidFromString("1b85420c-b84c-4f29-997e-0eb674b40b79")); - - assertNotNull(result); - assertFalse(result.isEmpty()); - } - - @Test public void testGetAllForQuotaId() { List<DiskImage> disks = dao.getAllForQuotaId(FixturesTool.QUOTA_GENERAL); assertEquals("VM should have five disks", 5, disks.size()); -- To view, visit http://gerrit.ovirt.org/10320 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I9e090b64dd8b47a9c79dc8ad6a1c3caab62031b6 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Daniel Erez <de...@redhat.com> _______________________________________________ Engine-patches mailing list Engine-patches@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-patches