Changeset 12883


Ignore:
Timestamp:
08/19/15 13:44:42 (4 years ago)
Author:
ascheibe
Message:

#2388 fixed some queries

Location:
trunk/sources
Files:
4 edited

Legend:

Unmodified
Added
Removed
  • trunk/sources/HeuristicLab.Services.Hive.DataAccess/3.3/Daos/PluginDao.cs

    r12761 r12883  
    5757    #region String queries
    5858    private const string DeleteUnusedPluginsStringQuery = @"
    59       DELETE FROM [Plugin]
    60       WHERE  [Plugin].[PluginId] NOT IN (
    61         SELECT DISTINCT rp.[PluginId]
    62         FROM [RequiredPlugins] rp
    63         WHERE EXISTS (SELECT [TaskId]
    64                       FROM [Task] t
    65                       WHERE t.[TaskId] = rp.[TaskId])
    66       );
    67     ";
     59     DELETE FROM [Plugin] WHERE [PluginId] IN (
     60     SELECT [PluginId] FROM [Plugin]
     61     EXCEPT
     62     SELECT DISTINCT [p].[PluginId] FROM [Plugin] p, [RequiredPlugins] rp
     63     WHERE [p].[PluginId] = [rp].[PluginId])";
    6864    #endregion
    6965  }
  • trunk/sources/HeuristicLab.Services.Hive.DataAccess/3.3/Manager/PersistenceManager.cs

    r12853 r12883  
    203203
    204204    public TableInformation GetTableInformation(string table) {
    205       string query = string.Format("sp_spaceused '{0}', @updateusage='true'", table);
     205      string query = string.Format("sp_spaceused '{0}'", table);
    206206      var result = dataContext.ExecuteQuery<SqlServerTableInformation>(query).FirstOrDefault();
    207207      if (result == null) return null;
  • trunk/sources/HeuristicLab.Services.WebApp.Status/3.3/WebApi/DataController.cs

    r12878 r12883  
    9191          AvgWaitingTime = count > 0 ? (long)calculatingTasks.OrderBy(x => x.StartTime).Take(count).Average(x => x.InitialWaitingTime) : 0,
    9292          AvgCalculatingTime = lastCalculatingTimes != null ? lastCalculatingTimes.Avg : 0,
    93           TotalCpuTime = factTasks.Sum(x => x.CalculatingTime),
     93          TotalCpuTime = factTasks.Sum(x => Convert.ToInt64(x.CalculatingTime)),
    9494          StandardDeviationCalculatingTime = (long)StandardDeviation(completedTasks.Select(x => (double)x.CalculatingTime)),
    9595          BeginDate = factTasks.OrderBy(x => x.StartTime).Select(x => x.StartTime).FirstOrDefault()
  • trunk/sources/HeuristicLab.Services.WebApp.Status/3.3/WebApp/status/statusCtrl.js

    r12878 r12883  
    44        ['$scope', '$interval', 'app.status.data.service',
    55        function ($scope, $interval, dataService) {
    6             $scope.interval = 10000; // update interval in ms
     6            $scope.interval = defaultPageUpdateInterval;
    77            $scope.knobOptions = {
    88                'fgColor': "#f7921d",
Note: See TracChangeset for help on using the changeset viewer.