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

Timestamp:

Aug 25, 2009, 3:30:28 PM (17 years ago)

Author:

bills

Message:

Modernize reverting of errors.
If pstampRequest.state = 'new' previous try at parsing was incomplete so delete any existing jobs
Only revert requests if the state is not 'stop'.
Only revert jobs if request and job state is 'run'

File:

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

trunk/ippTools/share/pstamptool_pendingjob.sql

@@ -1 @@
-SELECT *
- FROM pstampJob
- WHERE state = 'run'
-    AND fault = 0
+SELECT pstampJob.*
+FROM pstampJob
+    JOIN pstampRequest using(req_id)
+WHERE pstampRequest.state = 'run'
+    AND pstampRequest.fault = 0
+    AND pstampJob.state = 'run'
+    AND pstampJob.fault = 0