Changeset 34241 for branches/eam_branches/ipp-20120627/ippToPsps/jython/scratchdb.py

Timestamp:

Jul 31, 2012, 11:38:18 AM (14 years ago)

Author:

eugene

Message:

merge changes from trunk

Location:

branches/eam_branches/ipp-20120627/ippToPsps

Files:

• . (modified) (1 prop)
• jython/scratchdb.py (modified) (1 diff)

branches/eam_branches/ipp-20120627/ippToPsps/jython/scratchdb.py

@@ -593 +593 @@
         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