Changeset 28266 for trunk/ippTools/share

Timestamp:

Jun 9, 2010, 10:06:18 AM (16 years ago)

Author:

Paul Price

Message:

Don't change the state of an addRun when reverting.

Location:

trunk/ippTools/share

Files:

• Makefile.am (modified) (1 diff)
• addtool_reset_faulted_minidvodbruns.sql (deleted)
• addtool_reset_faulted_runs.sql (deleted)
• addtool_revertminidvodbprocessed.sql (modified) (1 diff)
• addtool_revertprocessedexp.sql (modified) (1 diff)

trunk/ippTools/share/Makefile.am

@@ -16 +16 @@
      addtool_queue_cam_id.sql \
      addtool_queue_minidvodbrun.sql \
-     addtool_reset_faulted_minidvodbruns.sql \
-     addtool_reset_faulted_runs.sql \
      addtool_revertminidvodbprocessed.sql \
      addtool_revertprocessedexp.sql \

trunk/ippTools/share/addtool_revertminidvodbprocessed.sql

@@ -5 +5 @@
     AND addRun.minidvodb_name = minidvodbRun.minidvodb_name
     AND minidvodbProcessed.fault != 0
+    AND minidvodbRun.state = 'new'

trunk/ippTools/share/addtool_revertprocessedexp.sql

@@ -7 +7 @@
     AND chipRun.exp_id = rawExp.exp_id
     AND addProcessedExp.fault != 0
+    AND addRun.state = 'new'