Changeset 18448 for trunk/ippTools/share

Timestamp:

Jul 9, 2008, 12:38:31 PM (18 years ago)

Author:

eugene

Message:

chiptool now uses new state names: new (for run), full (for stop), and others for the cleanup / update steps

Location:

trunk/ippTools/share

Files:

• difftool_inputskyfile.sql (modified) (2 diffs)
• difftool_todiffskyfile.sql (modified) (1 diff)
• faketool_find_camrun.sql (modified) (1 diff)
• faketool_find_pendingexp.sql (modified) (1 diff)
• warptool_imfile.sql (modified) (1 diff)
• warptool_scmap.sql (modified) (1 diff)
• warptool_tooverlap.sql (modified) (1 diff)
• warptool_towarped.sql (modified) (1 diff)

trunk/ippTools/share/difftool_inputskyfile.sql

@@ -34 +34 @@
         AND fakeRun.state = 'stop'
         AND camRun.state = 'stop'
-        AND chipRun.state = 'stop'
+        AND chipRun.state = 'full'
     UNION
     SELECT 
@@ -70 +70 @@
         AND fakeRun.state = 'stop'
         AND camRun.state = 'stop'
-        AND chipRun.state = 'stop'
+        AND chipRun.state = 'full'
     ) as Foo

trunk/ippTools/share/difftool_todiffskyfile.sql

@@ -29 +29 @@
   AND fakeRun.state = 'stop'
   AND camRun.state = 'stop'
-  AND chipRun.state = 'stop'
+  AND chipRun.state = 'full'
   AND diffSkyfile.diff_id IS NULL

trunk/ippTools/share/faketool_find_camrun.sql

@@ -33 +33 @@
     WHERE
         camRun.state = 'stop'
-        AND chipRun.state = 'stop'
+        AND chipRun.state = 'full'
 ) as Foo

trunk/ippTools/share/faketool_find_pendingexp.sql

@@ -27 +27 @@
         fakeRun.state = 'run'
         AND camRun.state = 'stop'
-        AND chipRun.state = 'stop'
+        AND chipRun.state = 'full'
         AND fakeMask.label IS NULL
         AND fakeProcessedImfile.fake_id IS NULL

trunk/ippTools/share/warptool_imfile.sql

@@ -24 +24 @@
     AND fakeRun.state = 'stop'
     AND camRun.state = 'stop'
-    AND chipRun.state = 'stop'
+    AND chipRun.state = 'full'
 

trunk/ippTools/share/warptool_scmap.sql

@@ -22 +22 @@
     fakeRun.state = 'stop'
     AND camRun.state = 'stop'
-    AND chipRun.state = 'stop'
+    AND chipRun.state = 'full'

trunk/ippTools/share/warptool_tooverlap.sql

@@ -25 +25 @@
     AND fakeRun.state = 'stop'
     AND camRun.state = 'stop'
-    AND chipRun.state = 'stop'
+    AND chipRun.state = 'full'
     AND warpSkyCellMap.warp_id IS NULL
     AND warpMask.label IS NULL

trunk/ippTools/share/warptool_towarped.sql

@@ -30 +30 @@
     AND fakeRun.state = 'stop'
     AND camRun.state = 'stop'
-    AND chipRun.state = 'stop'
+    AND chipRun.state = 'full'
     AND warpSkyfile.warp_id IS NULL
     AND warpSkyfile.skycell_id IS NULL