Changeset 29364

Timestamp:

Oct 8, 2010, 12:14:49 PM (16 years ago)

Author:

bills

Message:

From trunk don't queue magicRun if none of the diffSkyfiles have good quality (quality = 0)

File:

• tags/ipp-20100823/ippTools/share/magictool_definebyquery_select.sql (modified) (2 diffs, 1 prop)

tags/ipp-20100823/ippTools/share/magictool_definebyquery_select.sql

@@ -15 +15 @@
     FROM diffRun
     JOIN diffInputSkyfile USING(diff_id)
+    JOIN diffSkyfile USING(diff_id, skycell_id)
     WHERE diffInputSkyfile.warp1 IS NOT NULL
         AND diffRun.exposure = 1
         AND diffRun.magicked = 0
+        AND diffSkyfile.quality = 0
     -- diff WHERE hook %s
     UNION
@@ -28 +30 @@
     FROM diffRun
     JOIN diffInputSkyfile USING(diff_id)
+    JOIN diffSkyfile USING(diff_id, skycell_id)
     WHERE diffInputSkyfile.warp2 IS NOT NULL
         AND diffRun.exposure = 1
         AND diffRun.bothways = 1
         AND diffRun.magicked = 0
+        AND diffSkyfile.quality = 0
     -- diff WHERE hook %s
     ) AS diffWarps