Changeset 12883 for trunk/sources/HeuristicLab.Services.Hive.DataAccess

Timestamp:

08/19/15 13:44:42 (9 years ago)

Author:

ascheibe

Message:

#2388 fixed some queries

Location:

trunk/sources/HeuristicLab.Services.Hive.DataAccess/3.3

Files:

• Daos/PluginDao.cs (modified) (1 diff)
• Manager/PersistenceManager.cs (modified) (1 diff)

trunk/sources/HeuristicLab.Services.Hive.DataAccess/3.3/Daos/PluginDao.cs

@@ -57 +57 @@
     #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])
-      );
-    ";
+     DELETE FROM [Plugin] WHERE [PluginId] IN (
+     SELECT [PluginId] FROM [Plugin]
+     EXCEPT
+     SELECT DISTINCT [p].[PluginId] FROM [Plugin] p, [RequiredPlugins] rp
+     WHERE [p].[PluginId] = [rp].[PluginId])";
     #endregion
   }

trunk/sources/HeuristicLab.Services.Hive.DataAccess/3.3/Manager/PersistenceManager.cs

@@ -203 +203 @@
 
     public TableInformation GetTableInformation(string table) {
-      string query = string.Format("sp_spaceused '{0}', @updateusage='true'", table);
+      string query = string.Format("sp_spaceused '{0}'", table);
       var result = dataContext.ExecuteQuery<SqlServerTableInformation>(query).FirstOrDefault();
       if (result == null) return null;