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

Timestamp:

Apr 11, 2017, 3:01:23 PM (9 years ago)

Author:

heather

Message:

changes to make forcedwards correctly (not dropping things)

File:

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

trunk/ippToPsps/jython/scratchdb.py

@@ -186 +186 @@
               
         return imageID 
+
+    ''' 
+    Gets imageID from extern ID and photcoderange (needed for FW, possibly for others)
+    ''' 
+    def getImageIDFromExternIDandPhotcodeRange(self, externID, r1, r2): 
+               
+        imageID = -1 
+               
+        sql1 = "SELECT IMAGE_ID FROM " + self.dvoImagesTable + " WHERE EXTERN_ID = %s" % (externID) 
+        range = " AND PHOTCODE >= " + str(r1) +" AND PHOTCODE <=" + str(r2)
+        sql = sql1 + range
+
+        self.logger.info(sql)
+        try: 
+            rs = self.executeQuery(sql)   
+            rs.first() 
+            imageID = rs.getInt(1) 
+        except: 
+            self.logger.errorPair("Unable to get imageID from dvo using", sql) 
+              
+        return imageID 
+
+
+
+
 
     '''