Changeset 32135 for trunk/ippToPsps

Timestamp:

Aug 19, 2011, 11:41:33 AM (15 years ago)

Author:

rhenders

Message:

New method to get filterId from filter name

File:

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

trunk/ippToPsps/jython/scratchdb.py

@@ -55 +55 @@
 
         return surveyID
+
+    '''
+    Gets filter ID for this filter name
+    '''
+    def getFilterID(self, name):
+     
+        sql = "SELECT filterID FROM Filter WHERE filterType = '" + name + "'"
+        try:
+            rs = self.executeQuery(sql)
+            rs.first()
+            filterID = rs.getInt(1)
+        except:
+            self.logger.errorPair("No filter ID found for filter", name)
+            filterID = -1
+
+        return filterID
 
     '''