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

Timestamp:

Dec 17, 2014, 11:57:47 AM (12 years ago)

Author:

heather

Message:

diff batch nearly ready - this should fill in the remaining columns (that I can fill)

File:

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

trunk/ippToPsps/jython/gpc1db.py

@@ -268 +268 @@
                skycell_id, \
                diffRun.software_ver, \
-               exp_time \
+               exp_time, \
+               (to_days(dateobs)-678941 + time_to_sec(dateobs)/86400.) \
                FROM diffRun join diffInputSkyfile using (diff_id) \
                JOIN warpRun on (warp1=warp_id) \
@@ -276 +277 @@
                JOIN rawExp using (exp_id) \
                WHERE diff_skyfile_id = %d" % diffSkyfileID
-               
+        #this is a crappy way to get the mjd from the diff but we don't save it anywhere       
         try:
             rs = self.executeQuery(sql)