Changeset 15666 for branches/HiveProjectManagement/HeuristicLab.Services.Hive

Timestamp:

01/29/18 17:38:50 (7 years ago)

Author:

jzenisek

Message:

#2839 implemented project facts-logging in HiveStatisticsGenerator

File:

• branches/HiveProjectManagement/HeuristicLab.Services.Hive/3.3/HiveStatisticsGenerator.cs (modified) (3 diffs)

branches/HiveProjectManagement/HeuristicLab.Services.Hive/3.3/HiveStatisticsGenerator.cs

@@ -59 +59 @@
           pm.UseTransaction(() => {
             UpdateFactClientInfoTable(time, pm);
-            UpdateFactProjectInfoTable(time, pm); // in progress
+            UpdateFactProjectInfoTable(time, pm);
             pm.SubmitChanges();
           });
@@ -118 +118 @@
     }
 
+    // add new projects
+    // delete expired projects
+    // update information of existing projects
     private void UpdateDimProjectTable(PersistenceManager pm) {
       var projectDao = pm.ProjectDao;
@@ -353 +356 @@
 
     private void UpdateFactProjectInfoTable(DimTime newTime, PersistenceManager pm) {
-      // TODO
+      var factProjectInfoDao = pm.FactProjectInfoDao;
+      var dimProjectDao = pm.DimProjectDao;
+      var projectDao = pm.ProjectDao;
+
+      var projectAvailabilityStats = projectDao.GetAvailabilityStatsPerProject();
+      var projectUsageStats = projectDao.GetUsageStatsPerProject();
+      var dimProjects = dimProjectDao.GetAllOnlineProjects().ToList();
+
+      factProjectInfoDao.Save(
+        from dimp in dimProjects
+        let aStats = projectAvailabilityStats.Where(x => x.ProjectId == dimp.ProjectId).SingleOrDefault()
+        let uStats = projectUsageStats.Where(x => x.ProjectId == dimp.ProjectId).SingleOrDefault()
+        select new FactProjectInfo {
+            ProjectId = dimp.ProjectId,
+            DimTime = newTime,
+            NumTotalCores = aStats != null ? aStats.Cores : 0,
+            TotalMemory = aStats != null ? aStats.Memory : 0,
+            NumUsedCores = uStats != null ? uStats.Cores : 0,
+            UsedMemory = uStats != null ? uStats.Memory : 0
+          }
+        );
     }