Changeset 27304 for trunk/ippTools/share

Timestamp:

Mar 16, 2010, 6:28:29 PM (16 years ago)

Author:

watersc1

Message:

IPP->OTIS image quality statistic publishing tool, with all the recent updates to make it work correctly and produce useful tables.

Location:

trunk/ippTools/share

Files:

• dqstatstool_definebyquery.sql (modified) (2 diffs)
• dqstatstool_get_run.sql (modified) (1 diff)

trunk/ippTools/share/dqstatstool_definebyquery.sql

@@ -1 +1 @@
 -- query to identify unique data to bundle
 
-SELECT exp_id,chip_id,cam_id,warp_id,invalid from rawExp 
+SELECT DISTINCT exp_id,chip_id,cam_id,warp_id,invalid from rawExp 
         JOIN chipRun USING(exp_id) 
         JOIN camRun USING(chip_id) 
@@ -7 +7 @@
         LEFT OUTER JOIN warpRun USING(fake_id)
         LEFT OUTER JOIN dqstatsContent USING (exp_id,chip_id,cam_id,warp_id)
-WHERE (invalid IS NULL OR invalid = 1)
+WHERE camRun.state = 'full'

trunk/ippTools/share/dqstatstool_get_run.sql

@@ -1 @@
-SELECT * from dqstatsRun
-        WHERE state = 'new' AND (fault = 0)
+SELECT DISTINCT dqstatsRun.*,rawExp.camera from dqstatsRun
+       JOIN dqstatsContent USING(dqstats_id)
+       JOIN rawExp USING(exp_id)
+        WHERE dqstatsRun.state = 'new' AND (dqstatsRun.fault = 0)