Changeset 37750 for trunk/ippToPsps/jython/gpc1db.py

Timestamp:

Dec 16, 2014, 5:30:25 PM (12 years ago)

Author:

heather

Message:

diffbatch is very close - need to add rest of dvo stuffs and then cull the nulls and we are good to go!

File:

• trunk/ippToPsps/jython/gpc1db.py (modified) (1 diff)

trunk/ippToPsps/jython/gpc1db.py

@@ -354 +354 @@
                FROM warpSkyCellMap \
                JOIN warpRun USING(warp_id) \
-               JOIN diffInputSkyfile on warp1 = warp_id \ 
-               WHERE diffInputSkyfile.diff_skyfile_id = " + str(diffID) + " AS a"
-
-        try:
-            rs = self.executeQuery(sql)
-        except:
+               JOIN diffInputSkyfile on warp1 = warp_id  \
+               JOIN fakeRun using (fake_id) \
+               JOIN camRun using (cam_id) \
+               JOIN chipRun using (chip_id) \
+               WHERE diffInputSkyfile.diff_skyfile_id = " + str(diffID) + ") AS a"
+
+        try:
+            rs = self.executeQuery(sql)
+        except:
+            self.logger.infoPair("failed sql:",sql)
             self.logger.exception("Can't query for imageIDs")
+            
 
         imageIDs = []