Changeset 25199 for trunk/ippTools/share

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'

Location:

trunk/ippTools/share

Files:

• pstamptool_pendingjob.sql (modified) (1 diff)
• pstamptool_pendingreq.sql (modified) (1 diff)
• pstamptool_revertjob.sql (added)
• pstamptool_revertreq.sql (added)
• pstamptool_revertreq_deletejobs.sql (added)

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

trunk/ippTools/share/pstamptool_pendingreq.sql

@@ -7 +7 @@
     USING(ds_id)
  WHERE pstampRequest.state = 'new'
+    AND pstampRequest.fault = 0