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

Timestamp:

Oct 6, 2015, 3:38:02 PM (11 years ago)

Author:

watersc1

Message:

Fix psfModelID type issue in ForcedWarpMeta/StackMeta, and implement psfModelID for ImageMeta. Added getFitModelID function to do the conversion of string to int.

File:

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

trunk/ippToPsps/jython/scratchdb.py

@@ -130 +130 @@
 
         return filterID
+
+    '''
+    Get the fitModelID from FitModel table based on model name
+    '''
+    def getFitModelID(self, name):
+        
+        sql = "SELECT fitModelID FROM FitModel WHERE name = '" + name + "'"
+        try:
+            rs = self.executeQuery(sql)
+            rs.first()
+            fitModelID = rs.getInt(1)
+        except:
+            self.logger.errorPair("No fitModelID found for model name", name)
+            fitModelID = -1
+
+        return fitModelID
 
     '''