Changeset 18644

Timestamp:

Jul 21, 2008, 2:14:39 PM (18 years ago)

Author:

eugene

Message:

change from old state names (run, stop) to new ones (new, full, goto_cleaned, etc)

Location:

branches/eam_branch_20080719/ippTools/share

Files:

• camtool_find_pendingexp.sql (modified) (1 diff)
• camtool_reset_faulted_runs.sql (modified) (1 diff)
• difftool_inputskyfile.sql (modified) (2 diffs)
• difftool_queue.sql (modified) (1 diff)
• difftool_skyfile.sql (modified) (1 diff)
• difftool_todiffskyfile.sql (modified) (1 diff)
• faketool_completely_processed_exp.sql (modified) (1 diff)
• faketool_find_camrun.sql (modified) (1 diff)
• faketool_find_pendingexp.sql (modified) (1 diff)
• faketool_queue_cam_id.sql (modified) (1 diff)
• stacktool_definebyquery_part1.sql (modified) (1 diff)
• stacktool_definebyquery_test.sql (modified) (1 diff)
• stacktool_find_complete_warps.sql (modified) (1 diff)
• stacktool_inputskyfile.sql (modified) (1 diff)
• stacktool_sumskyfile.sql (modified) (1 diff)
• stacktool_tosum.sql (modified) (1 diff)
• warptool_exp.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)
• warptool_warped.sql (modified) (1 diff)

branches/eam_branch_20080719/ippTools/share/camtool_find_pendingexp.sql

@@ -25 +25 @@
     WHERE
         chipRun.state = 'full'
-        AND camRun.state = 'run'
+        AND camRun.state = 'new'
         AND camMask.label IS NULL
         AND camProcessedExp.cam_id IS NULL

branches/eam_branch_20080719/ippTools/share/camtool_reset_faulted_runs.sql

@@ -1 +1 @@
 UPDATE camRun, camProcessedExp, chipRun, rawExp
-SET camRun.state = 'run'
+SET camRun.state = 'new'
 WHERE
     camRun.cam_id = camProcessedExp.cam_id

branches/eam_branch_20080719/ippTools/share/difftool_inputskyfile.sql

@@ -30 +30 @@
         ON chipRun.exp_id = rawExp.exp_id
     WHERE
-        diffRun.state = 'run'
-        AND warpRun.state = 'stop'
-        AND fakeRun.state = 'stop'
-        AND camRun.state = 'stop'
+        diffRun.state = 'new'
+        AND warpRun.state = 'full'
+        AND fakeRun.state = 'full'
+        AND camRun.state = 'full'
         AND chipRun.state = 'full'
     UNION
@@ -66 +66 @@
         ON chipRun.exp_id = rawExp.exp_id
     WHERE
-        diffRun.state = 'run'
-        AND warpRun.state = 'stop'
-        AND fakeRun.state = 'stop'
-        AND camRun.state = 'stop'
+        diffRun.state = 'new'
+        AND warpRun.state = 'full'
+        AND fakeRun.state = 'full'
+        AND camRun.state = 'full'
         AND chipRun.state = 'full'
     ) as Foo

branches/eam_branch_20080719/ippTools/share/difftool_queue.sql

@@ -18 +18 @@
         stackSumSkyfile.fault = 0
         AND warpSkyfile.fault = 0
-        AND stackRun.state = 'stop'
+        AND stackRun.state = 'full'
         AND diffInputSkyfile.stack_id IS NULL
         AND diffInputSkyfile.warp_id IS NULL

branches/eam_branch_20080719/ippTools/share/difftool_skyfile.sql

@@ -7 +7 @@
     USING(diff_id)
 WHERE
-    diffRun.state = 'run'
+    diffRun.state = 'new'
 

branches/eam_branch_20080719/ippTools/share/difftool_todiffskyfile.sql

@@ -25 +25 @@
     ON diffInputSkyfile.diff_id = diffSkyfile.diff_id
 WHERE
-  diffRun.state = 'run'
-  AND warpRun.state = 'stop'
-  AND fakeRun.state = 'stop'
-  AND camRun.state = 'stop'
+  diffRun.state = 'new'
+  AND warpRun.state = 'full'
+  AND fakeRun.state = 'full'
+  AND camRun.state = 'full'
   AND chipRun.state = 'full'
   AND diffSkyfile.diff_id IS NULL

branches/eam_branch_20080719/ippTools/share/faketool_completely_processed_exp.sql

@@ -31 +31 @@
         AND rawImfile.class_id = fakeProcessedImfile.class_id
     WHERE
-        fakeRun.state = 'run'
+        fakeRun.state = 'new'
     GROUP BY
         fakeRun.fake_id,

branches/eam_branch_20080719/ippTools/share/faketool_find_camrun.sql

@@ -32 +32 @@
         using(exp_id)
     WHERE
-        camRun.state = 'stop'
+        camRun.state = 'full'
         AND chipRun.state = 'full'
 ) as Foo

branches/eam_branch_20080719/ippTools/share/faketool_find_pendingexp.sql

@@ -25 +25 @@
         ON fakeRun.label = fakeMask.label
     WHERE
-        fakeRun.state = 'run'
-        AND camRun.state = 'stop'
+        fakeRun.state = 'new'
+        AND camRun.state = 'full'
         AND chipRun.state = 'full'
         AND fakeMask.label IS NULL

branches/eam_branch_20080719/ippTools/share/faketool_queue_cam_id.sql

@@ -14 +14 @@
     FROM camRun
     WHERE
-        camRun.state = 'stop'
+        camRun.state = 'full'
         AND camRun.cam_id = %lld

branches/eam_branch_20080719/ippTools/share/stacktool_definebyquery_part1.sql

@@ -23 +23 @@
         JOIN rawExp USING(exp_id, tess_id)
     WHERE
-        warpRun.state = 'stop'
+        warpRun.state = 'full'
     AND warpSkyfile.ignored = 0
     AND warpSkyfile.fault = 0

branches/eam_branch_20080719/ippTools/share/stacktool_definebyquery_test.sql

@@ -30 +30 @@
         JOIN rawExp USING(exp_id, tess_id)
     WHERE
-        warpRun.state = 'stop'
+        warpRun.state = 'full'
     AND warpSkyfile.ignored = 0
     AND warpSkyfile.fault = 0

branches/eam_branch_20080719/ippTools/share/stacktool_find_complete_warps.sql

@@ -23 +23 @@
     AND stackRun.stack_id = stackInputSkyfile.stack_id
 WHERE
-    warpRun.state = 'stop'
+    warpRun.state = 'full'
     AND warpSkyfile.ignored = 0
 GROUP BY

branches/eam_branch_20080719/ippTools/share/stacktool_inputskyfile.sql

@@ -22 +22 @@
     ON chipProcessedImfile.exp_id = rawExp.exp_id
 WHERE
-    stackRun.state = 'run'
+    stackRun.state = 'new'

branches/eam_branch_20080719/ippTools/share/stacktool_sumskyfile.sql

@@ -5 +5 @@
     USING(stack_id)
 WHERE
-    stackRun.state = 'run'
+    stackRun.state = 'new'

branches/eam_branch_20080719/ippTools/share/stacktool_tosum.sql

@@ -25 +25 @@
     USING(stack_id)
 WHERE
-    stackRun.state = 'run'
+    stackRun.state = 'new'
     AND stackSumSkyfile.stack_id IS NULL

branches/eam_branch_20080719/ippTools/share/warptool_exp.sql

@@ -5 +5 @@
     USING(fake_id)
 WHERE
-    warpRun.state = 'run'
-    AND fakeRun.state = 'stop'
+    warpRun.state = 'new'
+    AND fakeRun.state = 'full'

branches/eam_branch_20080719/ippTools/share/warptool_imfile.sql

@@ -21 +21 @@
     AND chipProcessedImfile.class_id = rawImfile.class_id 
 WHERE
-    warpRun.state = 'run'
-    AND fakeRun.state = 'stop'
-    AND camRun.state = 'stop'
+    warpRun.state = 'new'
+    AND fakeRun.state = 'full'
+    AND camRun.state = 'full'
     AND chipRun.state = 'full'
 

branches/eam_branch_20080719/ippTools/share/warptool_scmap.sql

@@ -19 +19 @@
     AND warpSkyCellMap.class_id = chipProcessedImfile.class_id
 WHERE
---    warpRun.state = 'run'
-    fakeRun.state = 'stop'
-    AND camRun.state = 'stop'
+--    warpRun.state = 'new'
+    fakeRun.state = 'full'
+    AND camRun.state = 'full'
     AND chipRun.state = 'full'

branches/eam_branch_20080719/ippTools/share/warptool_tooverlap.sql

@@ -22 +22 @@
     ON warpRun.label = warpMask.label
 WHERE
-    warpRun.state = 'run'
-    AND fakeRun.state = 'stop'
-    AND camRun.state = 'stop'
+    warpRun.state = 'new'
+    AND fakeRun.state = 'full'
+    AND camRun.state = 'full'
     AND chipRun.state = 'full'
     AND warpSkyCellMap.warp_id IS NULL

branches/eam_branch_20080719/ippTools/share/warptool_towarped.sql

@@ -27 +27 @@
     ON warpRun.label = warpMask.label
 WHERE
-    warpRun.state = 'run'
-    AND fakeRun.state = 'stop'
-    AND camRun.state = 'stop'
+    warpRun.state = 'new'
+    AND fakeRun.state = 'full'
+    AND camRun.state = 'full'
     AND chipRun.state = 'full'
     AND warpSkyfile.warp_id IS NULL

branches/eam_branch_20080719/ippTools/share/warptool_warped.sql

@@ -5 +5 @@
     USING(warp_id)
 WHERE
-    warpRun.state = 'run'
+    warpRun.state = 'new'