Changeset 28558 for trunk/ippTools/share

Timestamp:

Jun 30, 2010, 10:04:58 AM (16 years ago)

Author:

heather

Message:

detrend reverts - can now revert -all in run state

Location:

trunk/ippTools/share

Files:

• addtool_revertminidvodbprocessed.sql (modified) (1 diff)
• dettool_revertdetrunsummary.sql (modified) (1 diff)
• dettool_revertnormalizedexp.sql (modified) (1 diff)
• dettool_revertnormalizedimfile.sql (modified) (1 diff)
• dettool_revertnormalizedstat.sql (modified) (1 diff)
• dettool_revertprocessedexp.sql (modified) (1 diff)
• dettool_revertprocessedimfile.sql (modified) (1 diff)
• dettool_revertresidexp.sql (modified) (1 diff)
• dettool_revertresidimfile.sql (modified) (1 diff)
• dettool_revertstacked.sql (modified) (1 diff)

trunk/ippTools/share/addtool_revertminidvodbprocessed.sql

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

trunk/ippTools/share/dettool_revertdetrunsummary.sql

@@ -1 +1 @@
 DELETE FROM detRunSummary
+USING detRunSummary, detRun
 WHERE
     fault != 0
+AND
+    state = 'run'
+AND
+    detRunSummary.det_id = detRun.det_id

trunk/ippTools/share/dettool_revertnormalizedexp.sql

@@ -1 +1 @@
 DELETE FROM detNormalizedExp
+USING detNormalizedExp, detRun
 WHERE
     fault != 0
+AND
+    state = 'run'
+AND
+    detNormalizedExp.det_id = detRun.det_id

trunk/ippTools/share/dettool_revertnormalizedimfile.sql

@@ -1 +1 @@
 DELETE FROM detNormalizedImfile
+USING detNormalizedImfile, detRun
 WHERE
     fault != 0
+AND
+    state = 'run'
+AND
+    detNormalizedImfile.det_id = detRun.det_id

trunk/ippTools/share/dettool_revertnormalizedstat.sql

@@ -1 +1 @@
 DELETE FROM detNormalizedStatImfile
+USING detNormalizedStatImfile, detRun
 WHERE
     fault != 0
+AND
+    state = 'run'
+AND
+    detNormalizedStatImfile.det_id = detRun.det_id

trunk/ippTools/share/dettool_revertprocessedexp.sql

@@ -1 +1 @@
 DELETE FROM detProcessedExp
+USING detProcessedExp, detRun
 WHERE
     fault != 0
+AND
+    state = 'run'
+AND
+    detProcessedExp.det_id = detRun.det_id

trunk/ippTools/share/dettool_revertprocessedimfile.sql

@@ -1 +1 @@
 DELETE FROM detProcessedImfile
+USING detProcessedImfile, detRun
 WHERE
     fault != 0
+AND
+    state = 'run'
+AND
+    detProcessedImfile.det_id = detRun.det_id

trunk/ippTools/share/dettool_revertresidexp.sql

@@ -1 +1 @@
 DELETE FROM detResidExp
+USING detResidExp, detRun
 WHERE
     fault != 0
+AND
+    state = 'run'
+AND
+    detResidExp.det_id = detRun.det_id

trunk/ippTools/share/dettool_revertresidimfile.sql

@@ -1 +1 @@
 DELETE FROM detResidImfile
+USING detResidImfile, detRun
 WHERE
     fault != 0
+AND
+    state = 'run'
+AND
+    detResidImfile.det_id = detRun.det_id

trunk/ippTools/share/dettool_revertstacked.sql

@@ -1 +1 @@
 DELETE FROM detStackedImfile
+USING detStackedImfile, detRun
 WHERE
     fault != 0
+AND
+    state = 'run'
+AND
+    detStackedImfile.det_id = detRun.det_id