Changeset 21308 for trunk/ippTools/share/chiptool_processedimfile.sql

Timestamp:

Feb 5, 2009, 9:35:41 AM (17 years ago)

Author:

bills

Message:

Changed the way image ids are handled. For chip and warp new tables are
added the sole purpose of which are to create the image ids before
the images are created. For diff the id is added to diffInputSkyfile

File:

• trunk/ippTools/share/chiptool_processedimfile.sql (modified) (2 diffs)

trunk/ippTools/share/chiptool_processedimfile.sql

@@ -1 +1 @@
 SELECT DISTINCT
+    chipProcessedImfile.chip_id,
+    chipImfile.chip_imfile_id,
     chipProcessedImfile.class_id,
     chipProcessedImfile.uri,
@@ -14 +16 @@
     rawExp.filelevel
 FROM chipRun
+JOIN chipImfile
+    USING(chip_id)
 JOIN chipProcessedImfile
     USING(chip_id)
 JOIN rawExp
     ON chipProcessedImfile.exp_id = rawExp.exp_id
-WHERE
--- bogus test; just here so there there is a 'WHERE' stmt to append conditionals too
-    chipProcessedImfile.exp_id is NOT NULL
-