Changeset 12761 for branches/HiveStatistics/sources/HeuristicLab.Services.Hive.DataAccess/3.3/Manager

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/Manager/PersistenceManager.cs (modified) (3 diffs)

branches/HiveStatistics/sources/HeuristicLab.Services.Hive.DataAccess/3.3/Manager/PersistenceManager.cs

@@ -22 +22 @@
 using System;
 using System.Data.Linq;
+using System.Linq;
 using System.Transactions;
 using HeuristicLab.Services.Hive.DataAccess.Daos;
 using HeuristicLab.Services.Hive.DataAccess.Daos.HiveStatistics;
+using HeuristicLab.Services.Hive.DataAccess.Data;
 using HeuristicLab.Services.Hive.DataAccess.Interfaces;
 
@@ -200 +202 @@
     #endregion
 
+    // str.Remove(str.IndexOf(','));
+    public TableInformation GetTableInformation(string table) {
+      string query = string.Format("sp_spaceused '{0}', @updateusage='true'", table);
+      var result = dataContext.ExecuteQuery<SqlServerTableInformation>(query).FirstOrDefault();
+      if (result == null) return null;
+      return new TableInformation {
+        Name = result.Name,
+        Rows = int.Parse(result.Rows.Remove(result.Rows.IndexOf(' '))),
+        Reserved = int.Parse(result.Reserved.Remove(result.Reserved.IndexOf(' '))),
+        Data = int.Parse(result.Data.Remove(result.Data.IndexOf(' '))),
+        IndexSize = int.Parse(result.Index_Size.Remove(result.Index_Size.IndexOf(' '))),
+        Unused = int.Parse(result.Unused.Remove(result.Unused.IndexOf(' ')))
+      };
+    }
+
     public void SubmitChanges() {
       if (dataContext != null) {
@@ -211 +228 @@
       //}
     }
+
+    private class SqlServerTableInformation {
+      public string Name { get; set; }
+      public string Rows { get; set; }
+      public string Reserved { get; set; }
+      public string Data { get; set; }
+      public string Index_Size { get; set; } // naming of sp_spaceused...
+      public string Unused { get; set; }
+    }
   }
 }