Allon Mureinik has uploaded a new change for review.

Change subject: core: Remove GetTagVdsMapByTagNameQuery
......................................................................

core: Remove GetTagVdsMapByTagNameQuery

GetTagVdsMapByTagNameQuery not used anywhere in the code.
This patch removes it, its parameter class
(GetTagVdsByTagNameParameters), the corresponding
VdcQueryType constant, the DAO method only it used to use, the
corresponding test for the DAO and the corresponding stored procedure.

Change-Id: Ib54ee7c2974cc049e326e04893909fc0862a0ab5
Signed-off-by: Allon Mureinik <amure...@redhat.com>
---
M backend/manager/dbscripts/tags_sp.sql
D 
backend/manager/modules/bll/src/main/java/org/ovirt/engine/core/bll/GetTagVdsMapByTagNameQuery.java
D 
backend/manager/modules/common/src/main/java/org/ovirt/engine/core/common/queries/GetTagVdsMapByTagNameParameters.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/TagDAO.java
M 
backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/TagDAODbFacadeImpl.java
M 
backend/manager/modules/dal/src/test/java/org/ovirt/engine/core/dao/TagDAOTest.java
7 files changed, 0 insertions(+), 74 deletions(-)


  git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/00/12600/1

diff --git a/backend/manager/dbscripts/tags_sp.sql 
b/backend/manager/dbscripts/tags_sp.sql
index cb546ae..16b71b9 100644
--- a/backend/manager/dbscripts/tags_sp.sql
+++ b/backend/manager/dbscripts/tags_sp.sql
@@ -345,18 +345,6 @@
 
 
 
-Create or replace FUNCTION Gettags_vds_mapByTagName(v_tag_name VARCHAR(50)) 
RETURNS SETOF tags_vds_map_view
-   AS $procedure$
-BEGIN
-      RETURN QUERY SELECT tags_vds_map_view.*
-      FROM tags_vds_map_view
-      WHERE tag_name = v_tag_name;
-END; $procedure$
-LANGUAGE plpgsql;
-
-
-
-
 Create or replace FUNCTION GetTagsByVdsId(v_vds_ids VARCHAR(4000)) RETURNS 
SETOF tags_vds_map_view
    AS $procedure$
 BEGIN
diff --git 
a/backend/manager/modules/bll/src/main/java/org/ovirt/engine/core/bll/GetTagVdsMapByTagNameQuery.java
 
b/backend/manager/modules/bll/src/main/java/org/ovirt/engine/core/bll/GetTagVdsMapByTagNameQuery.java
deleted file mode 100644
index 0a8cd8b..0000000
--- 
a/backend/manager/modules/bll/src/main/java/org/ovirt/engine/core/bll/GetTagVdsMapByTagNameQuery.java
+++ /dev/null
@@ -1,17 +0,0 @@
-package org.ovirt.engine.core.bll;
-
-import org.ovirt.engine.core.common.queries.GetTagVdsMapByTagNameParameters;
-import org.ovirt.engine.core.dal.dbbroker.DbFacade;
-
-// NOT IN USE
-public class GetTagVdsMapByTagNameQuery<P extends 
GetTagVdsMapByTagNameParameters> extends QueriesCommandBase<P> {
-    public GetTagVdsMapByTagNameQuery(P parameters) {
-        super(parameters);
-    }
-
-    @Override
-    protected void executeQueryCommand() {
-        getQueryReturnValue().
-                
setReturnValue(DbFacade.getInstance().getTagDao().getTagVdsMapByTagName(getParameters().getTagName()));
-    }
-}
diff --git 
a/backend/manager/modules/common/src/main/java/org/ovirt/engine/core/common/queries/GetTagVdsMapByTagNameParameters.java
 
b/backend/manager/modules/common/src/main/java/org/ovirt/engine/core/common/queries/GetTagVdsMapByTagNameParameters.java
deleted file mode 100644
index 8adaa25..0000000
--- 
a/backend/manager/modules/common/src/main/java/org/ovirt/engine/core/common/queries/GetTagVdsMapByTagNameParameters.java
+++ /dev/null
@@ -1,12 +0,0 @@
-package org.ovirt.engine.core.common.queries;
-
-public class GetTagVdsMapByTagNameParameters extends 
GetTagByTagNameParametersBase {
-    private static final long serialVersionUID = -2896819836634242313L;
-
-    public GetTagVdsMapByTagNameParameters(String tagName) {
-        super(tagName);
-    }
-
-    public GetTagVdsMapByTagNameParameters() {
-    }
-}
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 3fc282a..c95256e 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
@@ -135,7 +135,6 @@
     GetTagsByUserId,
     GetTagsByVmId,
     GetTagsByVdsId,
-    GetTagVdsMapByTagName,
     GetTagIdsAndChildrenIdsByRegExp,
     GetTagIdAndChildrenIds,
 
diff --git 
a/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/TagDAO.java
 
b/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/TagDAO.java
index d9224e9..bc861e5 100644
--- 
a/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/TagDAO.java
+++ 
b/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/TagDAO.java
@@ -174,8 +174,6 @@
 
     void detachVdsFromTag(Guid tagId, Guid vdsId);
 
-    List<TagsVdsMap> getTagVdsMapByTagName(String tagName);
-
     TagsVmMap getTagVmByTagIdAndByVmId(Guid tagId, Guid vmId);
 
     void attachVmToTag(TagsVmMap tagVmMap);
diff --git 
a/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/TagDAODbFacadeImpl.java
 
b/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/TagDAODbFacadeImpl.java
index d2515f4..467dc48 100644
--- 
a/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/TagDAODbFacadeImpl.java
+++ 
b/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/TagDAODbFacadeImpl.java
@@ -332,25 +332,6 @@
                 .executeModification("Deletetags_vds_map", parameterSource);
     }
 
-    @SuppressWarnings("unchecked")
-    @Override
-    public List<TagsVdsMap> getTagVdsMapByTagName(String tagName) {
-        MapSqlParameterSource parameterSource = 
getCustomMapSqlParameterSource().addValue("tag_name", tagName);
-
-        ParameterizedRowMapper<TagsVdsMap> mapper = new 
ParameterizedRowMapper<TagsVdsMap>() {
-            @Override
-            public TagsVdsMap mapRow(ResultSet rs, int rowNum) throws 
SQLException {
-                TagsVdsMap entity = new TagsVdsMap();
-                
entity.settag_id(Guid.createGuidFromString(rs.getString("tag_id")));
-                
entity.setvds_id(Guid.createGuidFromString(rs.getString("vds_id")));
-                return entity;
-            }
-        };
-
-        return getCallsHandler()
-                .executeReadList("Gettags_vds_mapByTagName", mapper, 
parameterSource);
-    }
-
     @Override
     public TagsVmMap getTagVmByTagIdAndByVmId(Guid tagId, Guid vmId) {
         MapSqlParameterSource parameterSource = 
getCustomMapSqlParameterSource().addValue("tag_id", tagId).addValue(
diff --git 
a/backend/manager/modules/dal/src/test/java/org/ovirt/engine/core/dao/TagDAOTest.java
 
b/backend/manager/modules/dal/src/test/java/org/ovirt/engine/core/dao/TagDAOTest.java
index e041a14..8ce7099 100644
--- 
a/backend/manager/modules/dal/src/test/java/org/ovirt/engine/core/dao/TagDAOTest.java
+++ 
b/backend/manager/modules/dal/src/test/java/org/ovirt/engine/core/dao/TagDAOTest.java
@@ -414,17 +414,6 @@
     }
 
     @Test
-    public void testGetTagVdsMapByTagName() {
-        List<TagsVdsMap> result = 
dao.getTagVdsMapByTagName(existingTag.gettag_name());
-
-        assertNotNull(result);
-        assertFalse(result.isEmpty());
-        for (TagsVdsMap mapping : result) {
-            assertEquals(existingTag.gettag_id(), mapping.gettag_id());
-        }
-    }
-
-    @Test
     public void testGetTagVmMapByTag() {
         TagsVmMap result = 
dao.getTagVmByTagIdAndByVmId(existingVmTag.gettag_id(), 
existingVmTag.getvm_id());
 


--
To view, visit http://gerrit.ovirt.org/12600
To unsubscribe, visit http://gerrit.ovirt.org/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ib54ee7c2974cc049e326e04893909fc0862a0ab5
Gerrit-PatchSet: 1
Gerrit-Project: ovirt-engine
Gerrit-Branch: master
Gerrit-Owner: Allon Mureinik <amure...@redhat.com>
_______________________________________________
Engine-patches mailing list
Engine-patches@ovirt.org
http://lists.ovirt.org/mailman/listinfo/engine-patches

Reply via email to