Changeset 38879 for trunk/ippToPsps/jython/scratchdb.py

Timestamp:

Oct 17, 2015, 1:23:00 PM (11 years ago)

Author:

bills

Message:

include columns for the recalibration statistics in the dvoImages table
add function updateRecalStats() which is used to copy them to the various tables that need them

File:

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

trunk/ippToPsps/jython/scratchdb.py

@@ -222 +222 @@
 
     '''
+    Updates a table with the recalibration stats grabbed from dvoImages table
+    '''
+    def updateRecalStats(self, table, externID, pltScale):
+
+        sql = "UPDATE "+table+" AS a,"+self.dvoImagesTable+" AS b \
+               SET \
+               a.recalAstroScatX = b.XPIX_SYS_ERR *"+pltScale+", \
+               a.recalAstroScatY = b.YPIX_SYS_ERR *"+pltScale+", \
+               a.recalNAstroStars = b.N_FIT_ASTROM, \
+               a.recalPhotoScat  = b.MAG_SYS_ERR, \
+               a.recalNPhotoStars = b.N_FIT_PHOTOM \
+               WHERE b.EXTERN_ID = "+externID
+        self.execute(sql)
+
+    '''
     Inserts a new sourceID/imageID combo into dvoImages
     '''
@@ -483 +498 @@
                FLAGS INT, \
                PHOTCODE SMALLINT, \
+               XPIX_SYS_ERR FLOAT, \
+               YPIX_SYS_ERR FLOAT, \
+               N_FIT_ASTROM INT, \
+               MAG_SYS_ERR FLOAT, \
+               N_FIT_PHOTOM INT, \
                PRIMARY KEY (IMAGE_ID, EXTERN_ID) \
                )"