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

Timestamp:

Oct 31, 2012, 11:54:39 AM (14 years ago)

Author:

bills

Message:

Changes to PSPS table definitions for SA 10.
Detection tables contain all fluxes
Object table contains all magnitudes
Populate DetectionCalib and StackDetectinCalib

File:

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

trunk/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) \
                )"