Changeset 17928 for branches/3026_IntegrationIntoSymSpace/HeuristicLab.Services.Hive.DataAccess/3.3/Daos/StateLogDao.cs
- Timestamp:
- 04/06/21 13:13:32 (3 years ago)
- Location:
- branches/3026_IntegrationIntoSymSpace
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/3026_IntegrationIntoSymSpace
- Property svn:mergeinfo changed
-
branches/3026_IntegrationIntoSymSpace/HeuristicLab.Services.Hive.DataAccess
- Property svn:mergeinfo changed
/trunk/HeuristicLab.Services.Hive.DataAccess (added) merged: 17574
- Property svn:mergeinfo changed
-
branches/3026_IntegrationIntoSymSpace/HeuristicLab.Services.Hive.DataAccess/3.3/Daos/StateLogDao.cs
r17180 r17928 40 40 } 41 41 42 public int DeleteObsolete(int batchSize) { 43 return DataContext.ExecuteCommand(DeleteObsoleteQueryString, batchSize); 44 } 45 42 46 #region Compiled queries 43 47 private static readonly Func<DataContext, Guid, StateLog> GetByIdQuery = … … 54 58 select stateLog).First(x => x.SlaveId != null)); 55 59 #endregion 60 61 #region String queries 62 private const string DeleteObsoleteQueryString = @" 63 delete top ({0}) s 64 from statelog s 65 join task t on t.taskid = s.taskid 66 join job j on j.jobid = t.jobid 67 where j.jobstate = 'deletionpending' 68 "; 69 #endregion 56 70 } 57 71 }
Note: See TracChangeset
for help on using the changeset viewer.