Changeset 12761 for branches/HiveStatistics/sources/HeuristicLab.Services.Hive.DataAccess/3.3/Daos/PluginDao.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/PluginDao.cs (modified) (2 diffs)

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

@@ -37 +37 @@
     }
 
+    public int DeleteUnusedPlugins() {
+      return DataContext.ExecuteCommand(DeleteUnusedPluginsStringQuery);
+    }
+
     #region Compiled queries
     private static readonly Func<DataContext, Guid, Plugin> GetByIdQuery =
@@ -50 +54 @@
          select plugin));
     #endregion
+
+    #region String queries
+    private const string DeleteUnusedPluginsStringQuery = @"
+      DELETE FROM [Plugin]
+      WHERE  [Plugin].[PluginId] NOT IN (
+        SELECT DISTINCT rp.[PluginId] 
+        FROM [RequiredPlugins] rp
+        WHERE EXISTS (SELECT [TaskId] 
+                      FROM [Task] t
+                      WHERE t.[TaskId] = rp.[TaskId])
+      );
+    ";
+    #endregion
   }
 }