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

Timestamp:

Jul 1, 2011, 8:46:12 AM (15 years ago)

Author:

rhenders

Message:

now grabbing software_ver, bg and bg_stdev from rawExp table; now getting software_ver from stackRun

File:

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

trunk/ippToPsps/jython/gpc1db.py

@@ -123 +123 @@
         sql = "SELECT \
                stackRun.stack_id,\
-               stackRun.skycell_id \
+               stackRun.skycell_id, \
+               stackRun.software_ver \
                FROM \
                staticskyInput, staticskyRun, stackRun, staticskyResult \
@@ -138 +139 @@
             meta.append(rs.getInt(1))
             meta.append(rs.getString(2))
+            meta.append(rs.getString(3))
         except:
             self.logger.exception("Can't query for stack meta")
@@ -151 +153 @@
 
         meta = []
-        sql = "SELECT exp_id, exp_name, camRun.dist_group \
+        sql = "SELECT exp_id, exp_name, camRun.dist_group, camRun.software_ver, rawExp.bg, rawExp.bg_stdev \
                FROM camRun \
                JOIN chipRun USING(chip_id) \
@@ -162 +164 @@
             meta.append(rs.getString(2))
             meta.append(rs.getString(3))
+            meta.append(rs.getString(4))
+            meta.append(rs.getString(5))
+            meta.append(rs.getString(6))
         except:
             self.logger.exception("Can't query for camera meta")