Changeset 15497 for branches/HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess

Timestamp:

12/06/17 16:16:01 (7 years ago)

Author:

jzenisek

Message:

#2839 worked on permission check at AddTask

Location:

branches/HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3

Files:

• Daos/ResourceDao.cs (modified) (3 diffs)
• Daos/ResourcePermissionDao.cs (modified) (1 diff)
• Daos/TaskDao.cs (modified) (1 diff)
• Interfaces/IPersistenceManager.cs (modified) (1 diff)
• Manager/PersistenceManager.cs (modified) (2 diffs)

branches/HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3/Daos/ResourceDao.cs

@@ -21 +21 @@
 
 using System;
+using System.Collections.Generic;
 using System.Data.Linq;
 using System.Linq;
@@ -40 +41 @@
     }
 
+    public IEnumerable<Guid> GetResourceIdsByParentId(Guid id) {
+      return DataContext.ExecuteQuery<Guid>(GetResourceIdsByParentIdQuery, id);
+    }
+
+    public IEnumerable<Resource> GetResourcesByParentId(Guid id) {
+      return DataContext.ExecuteQuery<Resource>(GetResourcesByParentIdQuery, id);
+    }
+
     #region Compiled queries
     private static readonly Func<DataContext, Guid, Resource> GetByIdQuery =
@@ -53 +62 @@
         select resource).FirstOrDefault());
     #endregion
+
+    #region String queries
+    private const string GetResourcesByParentIdQuery = @"
+      WITH rtree AS
+      (
+        SELECT ResourceId, ParentResourceId
+        FROM [Resource]
+        UNION ALL
+        SELECT rt.ResourceId, r.ParentResourceId
+        FROM [Resource] r
+        JOIN rtree rt ON rt.ParentResourceId = r.ResourceId AND r.ParentResourceId <> r.ResourceId AND rt.ParentResourceId <> rt.ResourceId
+      )
+      SELECT DISTINCT rtree.ResourceId
+      FROM rtree
+      WHERE rtree.ParentResourceId = ({0})
+    ";
+    private const string GetResourceIdsByParentIdQuery = @"
+      WITH rtree AS
+      (
+        SELECT ResourceId, ParentResourceId
+        FROM [Resource]
+        UNION ALL
+        SELECT rt.ResourceId, r.ParentResourceId
+        FROM [Resource] r
+        JOIN rtree rt ON rt.ParentResourceId = r.ResourceId AND r.ParentResourceId <> r.ResourceId AND rt.ParentResourceId <> rt.ResourceId
+      )
+      SELECT DISTINCT res.*
+      FROM rtree, [Resource] res
+      WHERE rtree.ParentResourceId = ({0})
+      AND rtree.ResourceId = res.ResourceId
+    ";
+    #endregion
   }
 }

branches/HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3/Daos/ResourcePermissionDao.cs

@@ -56 +56 @@
       (
         SELECT ResourceId, ParentResourceId
-        FROM [dbo].Resource
+        FROM [Resource]
         UNION ALL
         SELECT rt.ResourceId, r.ParentResourceId
-        FROM [dbo].Resource r
+        FROM [Resource] r
         JOIN rtree rt ON rt.ParentResourceId = r.ResourceId AND r.ParentResourceId <> r.ResourceId AND rt.ParentResourceId <> rt.ResourceId
       )
-      SELECT DISTINCT rtree.ResourceId FROM rtree, ResourcePermission rp
-      WHERE rtree.ParentResourceId = rp.ResourceId
-      AND rp.GrantedUserId IN ({0})
+      SELECT DISTINCT rtree.ResourceId
+      FROM rtree, [ResourcePermission] rp
+      WHERE rtree.ParentResourceId = rp.ResourceId AND rp.GrantedUserId IN ({0})
       UNION ALL
       SELECT rp.ResourceId
-      FROM ResourcePermission rp
+      FROM [ResourcePermission] rp
       WHERE rp.GrantedUserId IN ({0})
       ;";

branches/HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3/Daos/TaskDao.cs

@@ -106 +106 @@
       )
       SELECT DISTINCT t.TaskId, t.JobId, t.Priority
-      FROM pr JOIN AssignedTaskResources ar ON ar.ResourceId = pr.ResourceId
+      FROM pr JOIN AssignedTaskResource ar ON ar.ResourceId = pr.ResourceId
           JOIN Task t ON t.TaskId = ar.TaskId
       WHERE NOT (t.IsParentTask = 1 AND t.FinishWhenChildJobsFinished = 1)

branches/HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3/Interfaces/IPersistenceManager.cs

@@ -43 +43 @@
     RequiredPluginDao RequiredPluginDao { get; }
     ResourceDao ResourceDao { get; }
+    ResourcePermissionDao ResourcePermissionDao { get; }
     SlaveDao SlaveDao { get; }
     SlaveGroupDao SlaveGroupDao { get; }

branches/HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3/Manager/PersistenceManager.cs

@@ -83 +83 @@
     }
 
-    private ProjectPermissionDao resourcePermissionDao;
+    private ProjectPermissionDao projectPermissionDao;
     public ProjectPermissionDao ProjectPermissionDao {
-      get { return resourcePermissionDao ?? (resourcePermissionDao = new ProjectPermissionDao(dataContext)); }
+      get { return projectPermissionDao ?? (projectPermissionDao = new ProjectPermissionDao(dataContext)); }
     }
 
@@ -96 +96 @@
     public ResourceDao ResourceDao {
       get { return resourceDao ?? (resourceDao = new ResourceDao(dataContext)); }
+    }
+
+    private ResourcePermissionDao resourcePermissionDao;
+    public ResourcePermissionDao ResourcePermissionDao {
+      get { return resourcePermissionDao ?? (resourcePermissionDao = new ResourcePermissionDao(dataContext)); }
     }