Changeset 27840 for branches/simtest_nebulous_branches/ippTools/share/difftool_inputskyfile.sql

Timestamp:

May 3, 2010, 8:50:52 AM (16 years ago)

Author:

eugene

Message:

updates from trunk

Location:

branches/simtest_nebulous_branches

Files:

• . (modified) (1 prop)
• ippTools/share/difftool_inputskyfile.sql (modified) (4 diffs)

branches/simtest_nebulous_branches/ippTools/share/difftool_inputskyfile.sql

@@ -27 +27 @@
     JOIN chipRun
         USING(chip_id)
-    JOIN chipProcessedImfile
-        USING(chip_id)
     JOIN rawExp
-        ON chipRun.exp_id = rawExp.exp_id
-    WHERE
-        -- diffRun.state = 'new' AND 
-        warpRun.state = 'full'
-        AND warpRun.state = 'full'
-        AND fakeRun.state = 'full'
-        AND camRun.state = 'full'
-        AND chipRun.state = 'full'
+        USING(exp_id)
         -- where hook %s
     UNION
@@ -67 +58 @@
     JOIN chipRun
         USING(chip_id)
-    JOIN chipProcessedImfile
-        USING(chip_id)
     JOIN rawExp
-        ON chipRun.exp_id = rawExp.exp_id
-    WHERE
-        -- diffRun.state = 'new' AND 
-        warpRun.state = 'full'
-        AND fakeRun.state = 'full'
-        AND camRun.state = 'full'
-        AND chipRun.state = 'full'
+        USING(exp_id)
         -- where hook %s
     UNION
@@ -107 +90 @@
         USING(chip_id)
     JOIN rawExp
-        ON chipRun.exp_id = rawExp.exp_id
-    WHERE
-        (diffRun.state = 'new' or diffRun.state = 'full')
+        USING(exp_id)
         -- where hook %s
     UNION
@@ -140 +121 @@
         USING(chip_id)
     JOIN rawExp
-        ON chipRun.exp_id = rawExp.exp_id
-    WHERE
-        (diffRun.state = 'new' or diffRun.state = 'full')
+        USING(exp_id)
         -- where hook %s
     ) as Foo
+-- template where hook %s