Changeset 35387

Timestamp:

Apr 10, 2013, 10:34:17 AM (13 years ago)

Author:

bills

Message:

show postage stamp submit time status listing

File:

• tags/ipp-20130307/pstamp/scripts/psstatus (modified) (7 diffs)

tags/ipp-20130307/pstamp/scripts/psstatus

@@ -68 +68 @@
     IFNULL(depcount, 0) AS 'Image updates'
     , timestamp AS 'last state change (UTC)'
+    , registered AS 'Submit time (UTC)'
 FROM (
     SELECT
@@ -77 +78 @@
         pstampRequest.fault,
         timestamp,
+        registered,
         IFNULL(priority,10000) AS priority
 FROM pstampRequest
 LEFT JOIN Label USING(label)
     WHERE pstampRequest.state = 'run' or pstampRequest.state ='new' 
-        OR pstampRequest.state = 'preview'
+        OR pstampRequest.state = 'parsed'
    --     OR pstampRequest.state = 'run.wait'
 ) as unfinishedReq
@@ -91 +93 @@
     WHERE (pstampRequest.state = 'run' or pstampRequest.state = 'new' 
         OR pstampRequest.state = 'run.wait'
-        OR pstampRequest.state = 'preview')
+        OR pstampRequest.state = 'parsed')
     GROUP BY req_id
 ) as rowCounts
@@ -103 +105 @@
     JOIN pstampDependent USING(dep_id) 
     WHERE (pstampRequest.state = 'run' or pstampRequest.state = 'new' 
-            OR pstampRequest.state = 'preview'
+            OR pstampRequest.state = 'parsed'
             OR pstampRequest.state = 'run.wait')
         AND dep_id > 0
@@ -157 +159 @@
     pstampRequest.fault,
     count(job_id) as 'Finished jobs',
-    timestamp as 'last state change'
+    timestamp as 'last update'
 FROM pstampRequest
     JOIN pstampJob USING(req_id)
@@ -181 +183 @@
     IFNULL(faulted,0) AS 'Faulted Jobs',
     IFNULL(depcount, 0) AS 'Image updates completed',
-    timestamp AS 'Completion Time (UTC)'
+    timestamp AS 'Completion Time (UTC)',
+    registered AS 'Submit Time (UTC)'
 FROM (
     SELECT
@@ -190 +193 @@
 --    pstampRequest.state,
 --    pstampRequest.fault,
-    timestamp
+    timestamp,
+    registered
 FROM pstampRequest
     WHERE pstampRequest.state = 'stop'