Changeset 38723 for trunk/ippToPsps/jython/objectbatch.py

Timestamp:

Sep 10, 2015, 2:44:01 PM (11 years ago)

Author:

heather

Message:

HAF/EAM/KCC schema changes from IAU

File:

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

trunk/ippToPsps/jython/objectbatch.py

@@ -250 +250 @@
     ## if we have a stackra and dec, use stackra and dec , dec >=0
 
-        sql = "update ObjectThin set objName =  concat('PS1.2 J', \
+        sql = "update ObjectThin set objName =  concat('PSO J', \
         lpad(floor(raStack/15.),2,'0'), \
         lpad((raStack/15.-(floor(raStack/15.)))*60. ,2,'0'), \
@@ -269 +269 @@
     ## if we have a stackra and dec, use stackra and dec, dec < 0
 
-        sql = "update ObjectThin set objName =  concat('PS1.2 J', \
+        sql = "update ObjectThin set objName =  concat('PSO J', \
         lpad(floor(raStack/15.),2,'0'), \
         lpad((raStack/15.-(floor(raStack/15.)))*60. ,2,'0'), \
@@ -286 +286 @@
         self.logger.infoPair("updating objName", "using means")
     ## use mean ra and dec (dec >= 0)
-        sql = "update ObjectThin set objName =  concat('PS1.2 J', \
+        sql = "update ObjectThin set objName =  concat('PSO J', \
         lpad(floor(raMean/15.),2,'0'), \
         lpad((raMean/15.-(floor(raMean/15.)))*60. ,2,'0'), \
@@ -304 +304 @@
     ## use mean ra and dec (dec < 0)
 
-        sql = "update ObjectThin set objName =  concat('PS1.2 J', \
+        sql = "update ObjectThin set objName =  concat('PSO J', \
         lpad(floor(raMean/15.),2,'0'), \
         lpad((raMean/15.-(floor(raMean/15.)))*60. ,2,'0'), \