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

Timestamp:

Jul 17, 2012, 4:30:56 PM (14 years ago)

Author:

heather

Message:

fixes for OB: if outside of ra/dec range, drop it...

File:

• trunk/ippToPsps/jython/scratchdb.py (modified) (1 diff)

trunk/ippToPsps/jython/scratchdb.py

@@ -591 +591 @@
         return orderedFilters
 
+
+    def getRaDecRangesFromdvoSkyTable(self, name):
+     
+        sql = "SELECT R_MIN, R_MAX, D_MIN, D_MAX FROM dvoSkyTable WHERE NAME = '" + name + "' limit 1"
+        try:
+            rs = self.executeQuery(sql)
+            rs.first()
+            raMin = rs.getFloat(1)
+            raMax = rs.getFloat(2)
+            decMin = rs.getFloat(3)
+            decMax = rs.getFloat(4)
+           
+        except:
+            self.logger.errorPair("no ra/decs found for", name)
+            raMin = -999
+            raMax = -999
+            decMin = -999
+            decMax = -999
+
+        return raMin, raMax, decMin, decMax
+ 
+    def getFromdvoSkyTable(self, column, name):
+     
+        sql = "SELECT "+column + " FROM dvoSkyTable WHERE NAME = '" + name + "' limit 1"
+        try:
+            rs = self.executeQuery(sql)
+            rs.first()
+            res = rs.getDouble(1)
+                       
+        except:
+            self.logger.errorPair("no ra/decs found for", name)
+            res = -999
+            
+
+        return res