Changeset 29286

Timestamp:

Sep 30, 2010, 3:25:05 PM (16 years ago)

Author:

bills

Message:

add fault_count so that we don't revert forever

Location:

trunk/ippTools/share

Files:

• pstamptool_revertdependent.sql (modified) (1 diff)
• pstamptool_revertjob.sql (modified) (1 diff)

trunk/ippTools/share/pstamptool_revertdependent.sql

@@ -3 +3 @@
     JOIN pstampRequest USING(req_id)
 SET pstampDependent.fault = 0
+-- fault count hook %s
 WHERE pstampDependent.state = 'new'
     AND (pstampDependent.fault > 0)

trunk/ippTools/share/pstamptool_revertjob.sql

@@ -2 +2 @@
     JOIN pstampRequest USING(req_id)
 SET pstampJob.fault = 0
+ -- clear fault count clause goes here %s
 WHERE  pstampRequest.state = 'run'
     AND pstampJob.state = 'run'