Changeset 25793 for trunk/ippTools/share/pstamptool_pendingjob.sql

Timestamp:

Oct 7, 2009, 1:05:22 PM (17 years ago)

Author:

bills

Message:

Add new table pstampDependent. An entry gets created by the postage stamp request parser
when the source run has been cleaned. The pstampJob is blocked from running until
the system detects that the run has been updated and magicked. (This code is yet
to be developed.)

File:

• trunk/ippTools/share/pstamptool_pendingjob.sql (modified) (1 diff)

trunk/ippTools/share/pstamptool_pendingjob.sql

@@ -1 +1 @@
 SELECT pstampJob.*
 FROM pstampJob
-    JOIN pstampRequest using(req_id)
+    JOIN pstampRequest USING(req_id)
+    LEFT JOIN pstampDependent USING(dep_id)
 WHERE pstampRequest.state = 'run'
     AND pstampRequest.fault = 0
     AND pstampJob.state = 'run'
     AND pstampJob.fault = 0
+    AND (dep_id = 0 OR pstampDependent.state = 'full')