Project

General

Profile

Feature #20763

Make status (i.e. for SubmissionHistory) a vocab table with ids ordered(New, LaunchFailed, Idle, Running, Held, Failed, Completed, Located)

Added by Marc Mengel almost 2 years ago. Updated over 1 year ago.

Status:
Closed
Priority:
Normal
Assignee:
Target version:
Start date:
10/10/2018
Due date:
% Done:

100%

Estimated time:
(Total: 0.00 h)
Scope:
Internal
Experiment:
-
Stakeholders:
Duration:

Description

... then checking for "is this submission completed" or "is this submission located" becomes a

select max(status) from submission_histories where submission_id = x; 

instead of
select status from submission_histories 
     where submission_id = x and 
           update_time = (select max(update_time) 
                                from submission_hsitories 
                                where submission_id=x);

That is, when we want to check the status of things that oughtn't go backwards (like completed, located, etc.)
we can just take the max(status) by submission_id.

The current string arrangement is not ordered right -- i.e. "New" > "Located , but "Completed" < "Located", etc.


Subtasks

Task #21102: Submissions: Database changesClosedStephen White

Feature #21103: Submissions: Code updateClosedMarc Mengel

History

#1 Updated by Stephen White almost 2 years ago

  • Assignee set to Marc Mengel

#2 Updated by Stephen White almost 2 years ago

  • Due date set to 10/10/2018
  • Start date changed from 09/06/2018 to 10/10/2018

due to changes in a related task: #21102

#3 Updated by Stephen White almost 2 years ago

  • Due date set to 10/10/2018

due to changes in a related task: #21103

#4 Updated by Marc Mengel over 1 year ago

  • Status changed from New to Resolved

#5 Updated by Stephen White over 1 year ago

  • Status changed from Resolved to Closed


Also available in: Atom PDF