Changeset 34772 for branches/czw_branch/20120906/ippToPsps/jython/scratchdb.py

Timestamp:

Dec 6, 2012, 6:32:19 PM (14 years ago)

Author:

watersc1

Message:

merge from trunk. Preliminary versions of stacktool/warptool updates and regenerate_background.pl script. The warp code is finished and tested, and I still need to get the stack version resolved.

Location:

branches/czw_branch/20120906/ippToPsps

Files:

• . (modified) (1 prop)
• jython/scratchdb.py (modified) (4 diffs)

branches/czw_branch/20120906/ippToPsps/jython/scratchdb.py

@@ -68 +68 @@
                DECLARE t REAL; \
                DECLARE z REAL; \
+               DECLARE s INT; \
+               SET s= SIGN(x); \
                SET x = ABS(x) / 1.4142135623731; \
                SET z=ABS(x); \
@@ -75 +77 @@
                SET ans = 2.0 - ans; \
                END IF; \
+               SET ans = ans * s; \
                RETURN ans; \
                END"
@@ -385 +388 @@
                objID BIGINT, \
                flags INT, \
+               zp REAL, \
+               zpErr REAL, \
+               airMass REAL, \
+               expTime REAL, \
+               ra FLOAT, \
+               dec_ FLOAT, \
+               raErr REAL, \
+               decErr REAL, \
                PRIMARY KEY (imageID, ippDetectID) \
                )"
@@ -391 +402 @@
         except: 
             self.logger.error("Unable to create DVO detection database table")
-
+        self.makeColumnUnique("dvoDetection", "objID") 
 
     '''