Changeset 12761 for branches/HiveStatistics/sources/HeuristicLab.Services.Hive.DataAccess/3.3/Daos/HiveStatistics/DimTimeDao.cs

Timestamp:

07/14/15 15:56:26 (9 years ago)

Author:

dglaser

Message:

#2429: Worked on the maintenance WebApp plugin:

• Space Usage Page: Displays the number of rows and allocated disk space for every database table
• Plugin Page: Shows unused plugins and provides functionality to delete all and specific plugins
• FactTask Page: Allows to aggregate all Job Tasks to a single task for a given job or jobs within an selected time period
• FactClientInfo Page: Allows to aggregate consecutive FactClientInfo entries with the same state and isallowedtocalculate flag

File:

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

branches/HiveStatistics/sources/HeuristicLab.Services.Hive.DataAccess/3.3/Daos/HiveStatistics/DimTimeDao.cs

@@ -31 +31 @@
       return GetByIdQuery(DataContext, id);
     }
+
     public DimTime GetLastEntry() {
       return GetLastEntryQuery(DataContext);
+    }
+
+    public int DeleteUnusedTimes() {
+      return DataContext.ExecuteCommand(DeleteUnusedTimeEntriesStringQuery);
     }
 
@@ -48 +53 @@
          select dimTime).FirstOrDefault());
     #endregion
+
+    #region String queries
+    private const string DeleteUnusedTimeEntriesStringQuery = @"
+      DELETE FROM [statistics].[DimTime]
+      WHERE NOT EXISTS (SELECT [Time] FROM [statistics].[FactClientInfo] fci
+                        WHERE fci.[Time] = [statistics].[DimTime].[Time]);    
+    ";
+    #endregion
   }
 }