Changeset 27015 for trunk/ippTools/share/magicdstool_torevert_diff.sql

Timestamp:

Feb 19, 2010, 2:29:48 PM (16 years ago)

Author:

bills

Message:

output the bothways status of a run from magicdstool -torevert and
pass the value to magic_destreak_revert.pl

File:

• trunk/ippTools/share/magicdstool_torevert_diff.sql (modified) (2 diffs)

trunk/ippTools/share/magicdstool_torevert_diff.sql

@@ -11 +11 @@
     diffSkyfile.path_base,
     "NULL" AS cam_path_base,
+    CAST(diffRun.bothways AS SIGNED) AS bothways,
     0 AS bytes,
     0 AS md5sum
@@ -17 +18 @@
     JOIN magicDSFile USING(magic_ds_id)
     JOIN diffSkyfile ON (stage_id = diffSkyfile.diff_id AND component = skycell_id)
+    JOIN diffRun ON diffSkyfile.diff_id = diffRun.diff_id
     JOIN rawExp USING(exp_id)
 WHERE magicDSRun.stage = 'diff'