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

Timestamp:

Oct 25, 2015, 5:57:48 PM (11 years ago)

Author:

bills

Message:

add more tracking IDS
ForcedWarpMeta.ippSkycalID
ForcedWarpMeta.stackMetaID
DiffMeta.ippDiffID

File:

• trunk/ippToPsps/jython/gpc1db.py (modified) (3 diffs)

trunk/ippToPsps/jython/gpc1db.py

@@ -396 +396 @@
                fullForceResult.software_ver, \
                skycell_id, \
-               warpRun.tess_id \
+               warpRun.tess_id, \
+               skycalRun.skycal_id, \
+               skycalRun.stack_id \
                FROM fullForceInput join addRun on \
                (fullForceInput.ff_id = addRun.stage_id and fullForceInput.warp_id = addRun.stage_extra1) \
@@ -406 +408 @@
                JOIN chipRun using (chip_id) \
                JOIN rawExp using (exp_id) \
+               JOIN fullForceRun using(ff_id) \
+               JOIN skycalRun USING(skycal_id) \
                WHERE add_id = " + str(forcedWarpID) + " \
                AND warp_skyfile_id = " +  str(warpSkyfileID)
@@ -422 +426 @@
             meta['skycell_id']   = rs.getString(5)
             meta['tess_id']      = rs.getString(6)
+            meta['skycal_id']    = rs.getString(7)
+            meta['stack_id']     = rs.getString(8)
         except:
             self.logger.errorPair("getForcedWarpStageMeta()", "missing metadata entry")