Shahar Havivi has uploaded a new change for review.

Change subject: Engine: remove timelease from pool type
......................................................................

Engine: remove timelease from pool type

It's not supported for a long time.

Change-Id: I4485501d4cd4a73d889ebb656751d674f55eae87
https://bugzilla.redhat.com/858958
Signed-off-by: Shahar Havivi <shav...@redhat.com>
---
M 
backend/manager/modules/common/src/main/java/org/ovirt/engine/core/common/businessentities/VmPool.java
M 
backend/manager/modules/common/src/main/java/org/ovirt/engine/core/common/businessentities/VmPoolType.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 
frontend/webadmin/modules/uicompat/src/main/java/org/ovirt/engine/ui/uicompat/Enums.java
M 
frontend/webadmin/modules/uicompat/src/main/java/org/ovirt/engine/ui/uicompat/LocalizedEnums.java
M packaging/dbscripts/user_sp.sql
7 files changed, 3 insertions(+), 98 deletions(-)


  git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/42/20242/1

diff --git 
a/backend/manager/modules/common/src/main/java/org/ovirt/engine/core/common/businessentities/VmPool.java
 
b/backend/manager/modules/common/src/main/java/org/ovirt/engine/core/common/businessentities/VmPool.java
index 4f9b2f4..e3b6278 100644
--- 
a/backend/manager/modules/common/src/main/java/org/ovirt/engine/core/common/businessentities/VmPool.java
+++ 
b/backend/manager/modules/common/src/main/java/org/ovirt/engine/core/common/businessentities/VmPool.java
@@ -13,7 +13,6 @@
 import org.ovirt.engine.core.common.validation.group.CreateEntity;
 import org.ovirt.engine.core.common.validation.group.UpdateEntity;
 import org.ovirt.engine.core.compat.Guid;
-import org.ovirt.engine.core.compat.StringFormat;
 import org.ovirt.engine.core.compat.TimeSpan;
 
 public class VmPool extends IVdcQueryable implements Serializable, Nameable, 
Commented {
@@ -114,50 +113,12 @@
                 && maxAssignedVmsPerUser == other.maxAssignedVmsPerUser);
     }
 
-    private void initializeTimeLeasedDefaultData(String parameter) {
-        String[] values = parameter.split("[,]", -1);
-        if (values.length == 3) {
-            try {
-                defaultTimeInDays = Integer.parseInt(values[0]);
-                String[] startTime = values[1].split("[:]", -1);
-                if (startTime.length > 1) {
-
-                    defaultStartTime = new 
TimeSpan(Integer.parseInt(startTime[0]), Integer.parseInt(startTime[1]), 0);
-                }
-                String[] endTime = values[2].split("[:]", -1);
-                if (endTime.length > 1) {
-                    defaultEndTime = new 
TimeSpan(Integer.parseInt(endTime[0]), Integer.parseInt(endTime[1]), 0);
-                }
-            } catch (java.lang.Exception e) {
-            }
-        }
-    }
-
     public String getParameters() {
-        switch (getVmPoolType()) {
-        case TimeLease: {
-            return StringFormat.format("%1$s,%2$s:%3$s,%4$s:%5$s", 
defaultTimeInDays, defaultStartTime.Hours,
-                    defaultStartTime.Minutes, defaultEndTime.Hours, 
defaultEndTime.Minutes);
-        }
-        default: {
-            return parameters;
-        }
-        }
-
+        return parameters;
     }
 
     public void setParameters(String value) {
-        switch (getVmPoolType()) {
-        case TimeLease: {
-            initializeTimeLeasedDefaultData(value);
-            break;
-        }
-        default: {
-            parameters = value;
-            break;
-        }
-        }
-
+        parameters = value;
     }
 
     public int getDefaultTimeInDays() {
diff --git 
a/backend/manager/modules/common/src/main/java/org/ovirt/engine/core/common/businessentities/VmPoolType.java
 
b/backend/manager/modules/common/src/main/java/org/ovirt/engine/core/common/businessentities/VmPoolType.java
index 320158a..7644c55 100644
--- 
a/backend/manager/modules/common/src/main/java/org/ovirt/engine/core/common/businessentities/VmPoolType.java
+++ 
b/backend/manager/modules/common/src/main/java/org/ovirt/engine/core/common/businessentities/VmPoolType.java
@@ -3,8 +3,7 @@
 public enum VmPoolType implements Identifiable {
     // FIXME add ids and remove the ordinal impl of getValue
     Automatic,
-    Manual,
-    TimeLease;
+    Manual;
 
     @Override
     public int getValue() {
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 67c2b63..b73a058 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
@@ -183,7 +183,5 @@
 
     List<TagsVmMap> getTagVmMapByVmIdAndDefaultTag(Guid vmid);
 
-    List<TagsVmMap> getTimeLeasedUserVmsByAdGroupAndVmPoolId(Guid adGroupId, 
Guid vmPoolId);
-
     List<TagsVmPoolMap> getVmPoolTagsByVmPoolIdAndAdElementId(Guid vmPoolId, 
Guid adElementId);
 }
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 dafa2a4..9e5563f 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
@@ -401,28 +401,6 @@
 
     @SuppressWarnings("unchecked")
     @Override
-    public List<TagsVmMap> getTimeLeasedUserVmsByAdGroupAndVmPoolId(Guid 
adGroupId, Guid vmPoolId) {
-        MapSqlParameterSource parameterSource = 
getCustomMapSqlParameterSource().addValue("groupId", adGroupId)
-                .addValue("vm_pool_id", vmPoolId);
-
-        RowMapper<TagsVmMap> mapper = new RowMapper<TagsVmMap>() {
-            @Override
-            public TagsVmMap mapRow(ResultSet rs, int rowNum) throws 
SQLException {
-                TagsVmMap entity = new TagsVmMap();
-                entity.settag_id(getGuidDefaultEmpty(rs, "tag_id"));
-                entity.setvm_id(getGuidDefaultEmpty(rs, "vm_id"));
-                entity.setDefaultDisplayType((Integer) 
rs.getObject("DefaultDisplayType"));
-                return entity;
-            }
-        };
-
-        return getCallsHandler()
-                        .executeReadList(
-                                "GetTimeLeasedUsersVmsByGroupIdAndPoolId", 
mapper, parameterSource);
-    }
-
-    @SuppressWarnings("unchecked")
-    @Override
     public List<TagsVmPoolMap> getVmPoolTagsByVmPoolIdAndAdElementId(Guid 
vmPoolId, Guid adElementId) {
         MapSqlParameterSource parameterSource = 
getCustomMapSqlParameterSource().addValue("ad_id", adElementId)
                 .addValue("vm_pool_id", vmPoolId);
diff --git 
a/frontend/webadmin/modules/uicompat/src/main/java/org/ovirt/engine/ui/uicompat/Enums.java
 
b/frontend/webadmin/modules/uicompat/src/main/java/org/ovirt/engine/ui/uicompat/Enums.java
index edc860f..8e4b89b 100644
--- 
a/frontend/webadmin/modules/uicompat/src/main/java/org/ovirt/engine/ui/uicompat/Enums.java
+++ 
b/frontend/webadmin/modules/uicompat/src/main/java/org/ovirt/engine/ui/uicompat/Enums.java
@@ -238,8 +238,6 @@
 
     String VmPoolType___Manual();
 
-    String VmPoolType___TimeLease();
-
     String AdRefStatus___Inactive();
 
     String AdRefStatus___Active();
diff --git 
a/frontend/webadmin/modules/uicompat/src/main/java/org/ovirt/engine/ui/uicompat/LocalizedEnums.java
 
b/frontend/webadmin/modules/uicompat/src/main/java/org/ovirt/engine/ui/uicompat/LocalizedEnums.java
index 88aa146..a759725 100644
--- 
a/frontend/webadmin/modules/uicompat/src/main/java/org/ovirt/engine/ui/uicompat/LocalizedEnums.java
+++ 
b/frontend/webadmin/modules/uicompat/src/main/java/org/ovirt/engine/ui/uicompat/LocalizedEnums.java
@@ -408,13 +408,9 @@
 
        String VdcActionType___AttachActionToRole();
 
-       String VdcActionType___AttachAdGroupTimeLeasedPool();
-
        String VdcActionType___AttachNetworkToVdsGroup();
 
        String VdcActionType___AttachNetworkToVdsInterface();
-
-       String VdcActionType___AttachUserToTimeLeasedPool();
 
        String VdcActionType___AttachVmPoolToAdGroup();
 
@@ -432,13 +428,9 @@
 
        String VdcActionType___DetachActionFromRole();
 
-       String VdcActionType___DetachAdGroupFromTimeLeasedPool();
-
        String VdcActionType___DetachNetworkFromVdsInterface();
 
        String VdcActionType___DetachNetworkToVdsGroup();
-
-       String VdcActionType___DetachUserFromTimeLeasedPool();
 
        String VdcActionType___DetachUserFromVmFromPool();
 
@@ -508,15 +500,11 @@
 
        String VdcActionType___TryBackToAllSnapshotsOfVm();
 
-       String VdcActionType___UpdateAdGroupTimeLeasedPool();
-
        String VdcActionType___UpdateNetworkToVdsInterface();
 
        String VdcActionType___UpdateNetwork();
 
        String VdcActionType___UpdateRole();
-
-       String VdcActionType___UpdateUserToTimeLeasedPool();
 
        String VdcActionType___UpdateVds();
 
diff --git a/packaging/dbscripts/user_sp.sql b/packaging/dbscripts/user_sp.sql
index 3e0e3c8..7d8a619 100644
--- a/packaging/dbscripts/user_sp.sql
+++ b/packaging/dbscripts/user_sp.sql
@@ -4,23 +4,6 @@
 
 
 
-Create or replace FUNCTION GetTimeLeasedUsersVmsByGroupIdAndPoolId(v_groupId 
UUID,
- v_vm_pool_id UUID) RETURNS SETOF tags_vm_map STABLE
-   AS $procedure$
-BEGIN
-      RETURN QUERY select tags_vm_map.* from tags_vm_map
-      inner join vm_pool_map on vm_pool_map.vm_guid = tags_vm_map.vm_id
-      inner join tags_permissions_map on tags_permissions_map.tag_id = 
tags_vm_map.tag_id
-      inner join permissions on permissions.id = 
tags_permissions_map.permission_id
-      where permissions.ad_element_id
-      in(select users.user_id from users
-         where (users.groups LIKE '%' ||(select ad_groups.name from ad_groups 
where ad_groups.id = v_groupId)
-         || '%'))
-      and
-      vm_pool_map.vm_pool_id = v_vm_pool_id;
-END; $procedure$
-LANGUAGE plpgsql;
-
 ----------------------------------------------------------------
 -- [users] Table
 --


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

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

Reply via email to