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

Timestamp:

Jun 28, 2012, 9:47:11 AM (14 years ago)

Author:

eugene

Message:

add function to get filterCount from Photcode table; add example Photcode table fits file in doc directory

File:

• branches/eam_branches/ipp-20120627/ippToPsps/jython/scratchdb.py (modified) (1 diff)

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

@@ -544 +544 @@
 
     '''
+    Gets a count of average filters (secfilt) in the DVO Photcodes table
+    '''
+    def getCountOfFiltersFromPhotcodesTable(self):
+
+        # 2 is hardwired -- convert to an enum (should probably read Ohana/src/libdvo/include/dvo.h defines
+        sql = "SELECT count(TYPE) FROM " + self.dvoPhotcodesTable + " WHERE TYPE = 2"
+
+        filterCount = 0
+        try:
+            rs = self.executeQuery(sql)
+            row = 1
+            while (rs.next()):
+                filterCount = rs.getString(1)
+            rs.close()
+        except:
+            self.logger.errorPair("Could not get filter count", sql )
+
+        return filterCount
+
+    '''
     Gets a list of filters ordered as thy are in the DVO Photcodes table, as this reflects the order they apper in the cps file
     '''
     def getOrderedListOfFiltersFromPhotcodesTable(self, interestedFilters):
+
+        sql = "SELECT count(TYPE) FROM " + self.dvoPhotcodesTable + " WHERE TYPE = 'sec'"
 
         sql = "SELECT NAME FROM " + self.dvoPhotcodesTable + " WHERE "