Changeset 25913 for trunk/ippTools/share

Timestamp:

Oct 21, 2009, 3:26:31 PM (17 years ago)

Author:

eugene

Message:

adding feature to control if analysis generates a correction image or not

Location:

trunk/ippTools/share

Files:

• flatcorr_camerarundone.sql (modified) (1 diff)
• flatcorr_chiprundone.sql (modified) (1 diff)
• flatcorr_pendingprocess.sql (modified) (1 diff)
• pxadmin_create_tables.sql (modified) (1 diff)

trunk/ippTools/share/flatcorr_camerarundone.sql

@@ -7 +7 @@
 JOIN camRun
     USING(cam_id)
-LEFT JOIN addRun
-    ON camRun.cam_id = addRun.cam_id
+LEFT JOIN flatcorrAddstarLink
+    using(corr_id, cam_id)
 WHERE
     flatcorrRun.state = 'new'
     AND flatcorrCamLink.include = 1
     AND camRun.state = 'full'
-    AND addRun.cam_id is NULL
+    AND flatcorrAddstarLink.corr_id is NULL

trunk/ippTools/share/flatcorr_chiprundone.sql

@@ -7 +7 @@
 JOIN chipRun
     USING(chip_id)
-LEFT JOIN camRun
-    ON chipRun.chip_id = camRun.chip_id
+LEFT JOIN flatcorrCamLink
+    using(corr_id, chip_id)
 WHERE
     flatcorrRun.state = 'new'
     AND flatcorrChipLink.include = 1
     AND chipRun.state = 'full'
-    AND camRun.cam_id is NULL
+    AND flatcorrCamLink.corr_id is NULL

trunk/ippTools/share/flatcorr_pendingprocess.sql

@@ -6 +6 @@
   filter,
   state,
+  make_corr,
   workdir,
   label,

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1217 +1217 @@
         filter VARCHAR(64),
         state VARCHAR(64),
+        make_corr TINYINT,
         workdir VARCHAR(255),
         label VARCHAR(64),