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

Timestamp:

Apr 3, 2012, 5:22:42 PM (14 years ago)

Author:

rhenders

Message:

method to get the DVO Photcodes 'CODE' for a given filter name

File:

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

trunk/ippToPsps/jython/scratchdb.py

@@ -539 +539 @@
         return region
 
+    '''
+    Gets the 'code' for the provided filter
+    '''
+    def getCodeForThisFilter(self, filter):
+
+        code = -1
+        sql = "SELECT CODE FROM " + self.dvoPhotcodesTable + " WHERE NAME = '" + filter + "'"
+        try:
+            rs = self.executeQuery(sql)
+            rs.first()
+            code = rs.getInt(1)
+            rs.close()
+        except:
+            self.logger.errorPair("Could not get filter code using", sql )
+
+        return code
+