Changeset 15908 for branches/2839_HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3

Timestamp:

04/17/18 13:38:33 (6 years ago)

Author:

jkarder

Message:

#2839: worked on hive project management

• fixed some bugs
• cleaned up

Location:

branches/2839_HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3

Files:

• Daos/HiveStatistics/DimProjectDao.cs (modified) (2 diffs)
• Daos/JobDao.cs (modified) (2 diffs)
• Daos/TaskDao.cs (modified) (1 diff)
• HeuristicLab.Services.Hive.DataAccess-3.3.csproj (modified) (1 diff)
• HiveDataContext.dbml (modified) (4 diffs)
• HiveDataContext.designer.cs (modified) (12 diffs)

branches/2839_HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3/Daos/HiveStatistics/DimProjectDao.cs

@@ -55 +55 @@
         (from dimProject in db.GetTable<DimProject>()
          where dimProject.ProjectId == projectId
-         select dimProject).ToList());
+         select dimProject));
     private static readonly Func<DataContext, Guid, Guid> GetLastValidIdByProjectIdQuery =
       CompiledQuery.Compile((DataContext db, Guid projectId) =>
@@ -67 +67 @@
         (from dimProject in db.GetTable<DimProject>()
          where dimProject.DateExpired == null
-         select dimProject).ToList());
+         select dimProject));
     #endregion
   }

branches/2839_HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3/Daos/JobDao.cs

@@ -60 +60 @@
         (from job in db.GetTable<Job>()
          where job.State == jobState
-         select job).ToList());
+         select job));
     private static readonly Func<DataContext, JobState, IEnumerable<Guid>> GetJobIdsByStateQuery =
       CompiledQuery.Compile((DataContext db, JobState jobState) =>
         (from job in db.GetTable<Job>()
          where job.State == jobState
-         select job.JobId).ToList());
+         select job.JobId));
     private static readonly Func<DataContext, IEnumerable<Job>> GetJobsReadyForDeletionQuery =
       CompiledQuery.Compile((DataContext db) =>
@@ -75 +75 @@
               || task.State == TaskState.Aborted
               || task.State == TaskState.Failed).All(x => x)
-         select job).ToList());
+         select job));
     #endregion
 

branches/2839_HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3/Daos/TaskDao.cs

@@ -65 +65 @@
     /// <returns></returns>
     public IEnumerable<Task> GetParentTasks(IEnumerable<Guid> resourceIds, int count, bool finished) {
-      var query = from t in Table
-                  where t.State == TaskState.Waiting
+    var query = from t in Table
+                where t.State == TaskState.Waiting
                     && t.IsParentTask
-                    && !t.Job.AssignedJobResources.Select(x => x.ResourceId).Except(resourceIds).Any()
+                    && t.Job.AssignedJobResources.All(x => resourceIds.ToList().Contains(x.ResourceId))
                     && t.FinishWhenChildJobsFinished == finished
                     && t.ChildJobs.Any()

branches/2839_HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3/HeuristicLab.Services.Hive.DataAccess-3.3.csproj

@@ -153 +153 @@
     <Compile Include="Properties\AssemblyInfo.cs" />
     <None Include="Properties\AssemblyInfo.cs.frame" />
-    <Compile Include="Settings.cs" />
     <Compile Include="Settings.Designer.cs">
       <AutoGen>True</AutoGen>

branches/2839_HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3/HiveDataContext.dbml

@@ -37 +37 @@
       <Column Name="HbInterval" Type="System.Int32" DbType="Int" CanBeNull="false" />
       <Column Name="OwnerUserId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
-      <Association Name="Resource_AssignedProjectResource" Member="AssignedProjectResources" Storage="_AssignedResources" ThisKey="ResourceId" OtherKey="ResourceId" Type="AssignedProjectResource" />
+      <Association Name="Resource_AssignedProjectResource" Member="AssignedProjectResources" ThisKey="ResourceId" OtherKey="ResourceId" Type="AssignedProjectResource" />
       <Association Name="Resource_Resource" Member="ChildResources" ThisKey="ResourceId" OtherKey="ParentResourceId" Type="Resource" />
       <Association Name="Resource_Downtime" Member="Downtimes" Storage="_UptimeCalendars" ThisKey="ResourceId" OtherKey="ResourceId" Type="Downtime" />
@@ -261 +261 @@
       <Column Name="StartDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
       <Column Name="EndDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
-      <Association Name="Project_AssignedProjectResource" Member="AssignedProjectResources" Storage="_AssignedResources" ThisKey="ProjectId" OtherKey="ProjectId" Type="AssignedProjectResource" />
+      <Association Name="Project_AssignedProjectResource" Member="AssignedProjectResources" ThisKey="ProjectId" OtherKey="ProjectId" Type="AssignedProjectResource" />
       <Association Name="Project_Job" Member="Jobs" ThisKey="ProjectId" OtherKey="ProjectId" Type="Job" />
       <Association Name="Project_Project" Member="ChildProjects" Storage="_Projects" ThisKey="ProjectId" OtherKey="ParentProjectId" Type="Project" />
@@ -284 +284 @@
     </Type>
   </Table>
-  <Table Name="" Member="FactProjectInfos">
+  <Table Name="[statistics].FactProjectInfo" Member="FactProjectInfos">
     <Type Name="FactProjectInfo">
       <Column Name="ProjectId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
@@ -296 +296 @@
     </Type>
   </Table>
-  <Table Name="" Member="DimProjects">
+  <Table Name="[statistics].DimProject" Member="DimProjects">
     <Type Name="DimProject">
       <Column Name="Id" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />

branches/2839_HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3/HiveDataContext.designer.cs

@@ -941 +941 @@
     private System.Nullable<System.Guid> _OwnerUserId;
     
-    private EntitySet<AssignedProjectResource> _AssignedResources;
+    private EntitySet<AssignedProjectResource> _AssignedProjectResources;
     
     private EntitySet<Resource> _ChildResources;
@@ -973 +973 @@
     public Resource()
     {
-      this._AssignedResources = new EntitySet<AssignedProjectResource>(new Action<AssignedProjectResource>(this.attach_AssignedResources), new Action<AssignedProjectResource>(this.detach_AssignedResources));
+      this._AssignedProjectResources = new EntitySet<AssignedProjectResource>(new Action<AssignedProjectResource>(this.attach_AssignedProjectResources), new Action<AssignedProjectResource>(this.detach_AssignedProjectResources));
       this._ChildResources = new EntitySet<Resource>(new Action<Resource>(this.attach_ChildResources), new Action<Resource>(this.detach_ChildResources));
       this._UptimeCalendars = new EntitySet<Downtime>(new Action<Downtime>(this.attach_UptimeCalendars), new Action<Downtime>(this.detach_UptimeCalendars));
@@ -1106 +1106 @@
     }
     
-    [global::System.Data.Linq.Mapping.AssociationAttribute(Name="Resource_AssignedProjectResource", Storage="_AssignedResources", ThisKey="ResourceId", OtherKey="ResourceId")]
+    [global::System.Data.Linq.Mapping.AssociationAttribute(Name="Resource_AssignedProjectResource", Storage="_AssignedProjectResources", ThisKey="ResourceId", OtherKey="ResourceId")]
     public EntitySet<AssignedProjectResource> AssignedProjectResources
     {
       get
       {
-        return this._AssignedResources;
-      }
-      set
-      {
-        this._AssignedResources.Assign(value);
+        return this._AssignedProjectResources;
+      }
+      set
+      {
+        this._AssignedProjectResources.Assign(value);
       }
     }
@@ -1225 +1225 @@
     }
     
-    private void attach_AssignedResources(AssignedProjectResource entity)
+    private void attach_AssignedProjectResources(AssignedProjectResource entity)
     {
       this.SendPropertyChanging();
@@ -1231 +1231 @@
     }
     
-    private void detach_AssignedResources(AssignedProjectResource entity)
+    private void detach_AssignedProjectResources(AssignedProjectResource entity)
     {
       this.SendPropertyChanging();
@@ -5651 +5651 @@
     private System.Nullable<System.DateTime> _EndDate;
     
-    private EntitySet<AssignedProjectResource> _AssignedResources;
+    private EntitySet<AssignedProjectResource> _AssignedProjectResources;
     
     private EntitySet<Job> _Jobs;
@@ -5685 +5685 @@
     public Project()
     {
-      this._AssignedResources = new EntitySet<AssignedProjectResource>(new Action<AssignedProjectResource>(this.attach_AssignedResources), new Action<AssignedProjectResource>(this.detach_AssignedResources));
+      this._AssignedProjectResources = new EntitySet<AssignedProjectResource>(new Action<AssignedProjectResource>(this.attach_AssignedProjectResources), new Action<AssignedProjectResource>(this.detach_AssignedProjectResources));
       this._Jobs = new EntitySet<Job>(new Action<Job>(this.attach_Jobs), new Action<Job>(this.detach_Jobs));
       this._Projects = new EntitySet<Project>(new Action<Project>(this.attach_Projects), new Action<Project>(this.detach_Projects));
@@ -5857 +5857 @@
     }
     
-    [global::System.Data.Linq.Mapping.AssociationAttribute(Name="Project_AssignedProjectResource", Storage="_AssignedResources", ThisKey="ProjectId", OtherKey="ProjectId")]
+    [global::System.Data.Linq.Mapping.AssociationAttribute(Name="Project_AssignedProjectResource", Storage="_AssignedProjectResources", ThisKey="ProjectId", OtherKey="ProjectId")]
     public EntitySet<AssignedProjectResource> AssignedProjectResources
     {
       get
       {
-        return this._AssignedResources;
-      }
-      set
-      {
-        this._AssignedResources.Assign(value);
+        return this._AssignedProjectResources;
+      }
+      set
+      {
+        this._AssignedProjectResources.Assign(value);
       }
     }
@@ -5963 +5963 @@
     }
     
-    private void attach_AssignedResources(AssignedProjectResource entity)
+    private void attach_AssignedProjectResources(AssignedProjectResource entity)
     {
       this.SendPropertyChanging();
@@ -5969 +5969 @@
     }
     
-    private void detach_AssignedResources(AssignedProjectResource entity)
+    private void detach_AssignedProjectResources(AssignedProjectResource entity)
     {
       this.SendPropertyChanging();
@@ -6331 +6331 @@
   }
   
-  [global::System.Data.Linq.Mapping.TableAttribute(Name="")]
+  [global::System.Data.Linq.Mapping.TableAttribute(Name="[statistics].FactProjectInfo")]
   public partial class FactProjectInfo : INotifyPropertyChanging, INotifyPropertyChanged
   {
@@ -6595 +6595 @@
   }
   
-  [global::System.Data.Linq.Mapping.TableAttribute(Name="")]
+  [global::System.Data.Linq.Mapping.TableAttribute(Name="[statistics].DimProject")]
   public partial class DimProject : INotifyPropertyChanging, INotifyPropertyChanged
   {