Changeset 9546 for branches/HiveStatistics/sources/HeuristicLab.Services.Hive/3.3/HiveStatisticsGenerator.cs

Timestamp:

05/28/13 10:30:43 (11 years ago)

Author:

pfleck

Message:

#2063:
As suggested by gkronber, added user to primary key again in ClientFact table and added a 'NULL'-user in the DimUser table instead.

File:

• branches/HiveStatistics/sources/HeuristicLab.Services.Hive/3.3/HiveStatisticsGenerator.cs (modified) (2 diffs)

branches/HiveStatistics/sources/HeuristicLab.Services.Hive/3.3/HiveStatisticsGenerator.cs

@@ -92 +92 @@
 
       db.DimUsers.InsertAllOnSubmit(newDimUsers);
+
+      // insert NULL-User
+      if (!db.DimUsers.Any(x => x.UserId == Guid.Empty)) {
+        db.DimUsers.InsertOnSubmit(new DimUser { UserId = Guid.Empty, Name = "NULL" });
+      }
     }
 
@@ -168 +173 @@
           DimClient = s.Client,
           DimTime = newTime,
-          UserId = s.Slave.OwnerUserId,
+          UserId = s.Slave.OwnerUserId ?? Guid.Empty,
           NumUsedCores =
             s.Slave.Cores != null && s.Slave.FreeCores != null