Changeset 39764 for trunk/ippToPsps/jython/gpc1db.py

Timestamp:

Oct 15, 2016, 10:01:32 AM (10 years ago)

Author:

heather

Message:

various changes over the past few weeks to fix bugs etc

File:

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

trunk/ippToPsps/jython/gpc1db.py

@@ -659 +659 @@
 
 
+    '''
+    Gets the exp_id from teh exp_name
+    ''' 
+    def getExpIdFromExpName(self, expName):
+       sql = "SELECT exp_id from rawExp where exp_name = '"+expName+"'"
+       try:
+           rs = self.executeQuery(sql)
+       except:
+           self.logger.infoPair("failed sql:",sql)
+           self.logger.exception("Can't query for imageIDs")
+            
+
+       expIDs = []
+       while (rs.next()):
+           expIDs.append(rs.getString(1))
+       rs.close()
+       expID = expIDs[0]
+       return expID
+
+    
+
+
 
     '''