Changeset 15499 for trunk/ippTools/share

Timestamp:

Nov 7, 2007, 6:06:07 PM (19 years ago)

Author:

jhoblitt

Message:

add magictool -queue mode

Location:

trunk/ippTools/share

Files:

• Makefile.am (modified) (1 diff)
• magictool_find_complete_diffed_exposures.sql (added)
• magictool_find_complete_warpruns.sql (modified) (1 diff)
• magictool_find_unmagiced.sql (modified) (3 diffs)

trunk/ippTools/share/Makefile.am

@@ -42 +42 @@
         magictool_tomask.sql \
         magictool_toskyfilemask.sql \
+        magictool_find_complete_diffed_exposures.sql \
+        magictool_find_complete_warpruns.sql \
         pztool_find_completed_exp.sql \
         pztool_pendingimfile.sql \

trunk/ippTools/share/magictool_find_complete_warpruns.sql

@@ -1 +1 @@
 -- find stopped warp runsthat have had all of their skycell's warped without
 -- any faults
-SELECT 
-    warp_id
+INSERT INTO warpComplete
+SELECT
+    warp_id,
+    skycell_id,
+    tess_id
 FROM (
     SELECT 

trunk/ippTools/share/magictool_find_unmagiced.sql

@@ -8 +8 @@
         warpSkyfile.fault as f1,
         diffSkyfile.fault as f2,
-        warpSkyCellMap.skycell_id as s1,
+        warpSkyCellMap.skycell_id as wscm_s,
+        warpSkyfile.skycell_id as wsf_s,
         diffInputSkyfile.skycell_id as s2
     FROM warpRun
@@ -26 +27 @@
     LEFT JOIN magicInputSkyfile
         USING(diff_id)
-    LEFT JOIN magicRun
-        USING (magic_id)
     WHERE
         warpRun.state = 'stop'
@@ -42 +41 @@
     --    warpRun.warp_id, warpSkyCellMap.skycell_id, warpSkyCellMap.tess_id
     HAVING
-        COUNT(warpSkyCellMap.skycell_id) = COUNT(diffInputSkyfile.skycell_id)
+        COUNT(warpSkyCellMap.skycell_id) = COUNT(warpSkyfile.skycell_id)
+        AND COUNT(warpSkyCellMap.skycell_id) = COUNT(diffInputSkyfile.skycell_id)
         AND SUM(warpSkyfile.fault) = 0
         AND SUM(diffSkyfile.fault) = 0