Changeset 29407

Timestamp:

Oct 14, 2010, 11:31:20 AM (16 years ago)

Author:

heather

Message:

now checks for quality > 0 to prevent camRuns with no smf files from being queued.

Location:

trunk/ippTools/share

Files:

• addtool_find_cam_id.sql (modified) (3 diffs)
• addtool_find_cam_id_dvo.sql (modified) (1 diff)

trunk/ippTools/share/addtool_find_cam_id.sql

@@ -2 +2 @@
     camRun.*
 FROM camRun
+JOIN camProcessedExp
+    USING(cam_id)
 JOIN chipRun
     USING(chip_id)
@@ -10 +12 @@
            FROM addRun
            JOIN camRun USING(cam_id)
-           JOIN chipRun USING(chip_id)
+           JOIN chipRun USING(chip_id)
           ) as foo
      ON exp_id = added_exp_id
@@ -17 +19 @@
 WHERE
     camRun.state = 'full'
+    AND camProcessedExp.quality = 0
     AND added_exp_id IS NULL
     -- addtool adds checks on exposure being added to the dvodb previously

trunk/ippTools/share/addtool_find_cam_id_dvo.sql

@@ -1 +1 @@
 SELECT camRun.* FROM camRun
+JOIN camProcessedExp USING(cam_id)
 JOIN chipRun USING(chip_id)
 JOIN rawExp USING(exp_id)
-WHERE camRun.state = 'full'
+WHERE camRun.state = 'full' and camProcessedExp.quality = 0
     AND exp_id NOT IN (SELECT exp_id
        FROM addRun