Changeset 33147 for trunk

Timestamp:

Jan 25, 2012, 1:42:07 PM (14 years ago)

Author:

rhenders

Message:

new method to get DVO region files from SkyTable given an RA/Dec box

File:

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

trunk/ippToPsps/jython/scratchdb.py

@@ -26 +26 @@
             self.dvoDetectionTable = "dvoDetectionFull"
             self.dvoDoneTable = "dvoDone"
+            self.dvoSkyTable = "SkyTable_fits"
         else:
             self.dvoMetaTable = "dvoMeta"
@@ -302 +303 @@
 
 
-
+    '''
+    Gets a list of PSPS image IDs for this stack ID
+    '''
+    def getDvoFilesCoveringThisRegion(self, minRa, maxRa, minDec, maxDec):
+
+        self.logger.debug("Querying DVO SkyTable for FITS files in this region")
+
+        sql = "SELECT name FROM " + self.dvoSkyTable + " \
+               WHERE NOT ((" + str(maxRa) + " <= R_MIN) OR \
+                       (" + str(minRa) + " >= R_MAX) OR \
+                       (" + str(maxDec) + " <= D_MIN) OR \
+                       (" + str(minDec) + " >= D_MAX)) "
+
+        try:
+            rs = self.executeQuery(sql)
+        except:
+            self.logger.exception("Can't query for imageIDs")
+
+        files = []
+        while (rs.next()):
+            files.append(rs.getString(1))
+        rs.close()
+
+        return files
+
+