Changeset 32062

Timestamp:

Aug 9, 2011, 4:00:03 PM (15 years ago)

Author:

rhenders

Message:

logging improvments

File:

• trunk/ippToPsps/jython/scratchdb.py (modified) (5 diffs)

trunk/ippToPsps/jython/scratchdb.py

@@ -49 +49 @@
             rs = self.executeQuery(sql)
             rs.first()
-            return rs.getInt(1)
-        except:
-            self.logger.exception("No survey ID found for this survey: '" + self.survey + "'")
-            return -1
+            surveyID = rs.getInt(1)
+        except:
+            self.logger.errorPair("No survey ID found for survey", name)
+            surveyID = -1
+
+        return surveyID
 
     ''' 
@@ -67 +69 @@
             imageID = rs.getInt(1) 
         except: 
-            self.logger.exception("Unable to get imageID from dvo meta table using " + sql) 
+            self.logger.errorPair("Unable to get imageID from dvo using", sql) 
               
         return imageID 
@@ -84 +86 @@
             flags = rs.getInt(1)
         except:
-            self.logger.exception("Unable to get flags from dvo table using " + sql)
+            self.logger.errorPair("Unable to get flags from dvo using", sql)
         return flags
 
@@ -100 +102 @@
             photcode = rs.getInt(1)
         except:
-            self.logger.exception("Unable to get photcode from dvo table with: " + sql)
+            self.logger.errorPair("Unable to get photcode from dvo with", sql)
 
         return photcode
@@ -213 +215 @@
        sql = "CREATE TABLE " + self.dvoMetaTable + " LIKE dvoMeta"
        try: self.execute(sql)
-       except: self.logger.error("Unable to create table " + self.dvoMetaTable)
+       except: self.logger.errorPair("Unable to create table", self.dvoMetaTable)
 
        self.logger.infoPair("Creating table", self.dvoDetectionTable)
        sql = "CREATE TABLE " + self.dvoDetectionTable + " LIKE dvoDetection"
        try: self.execute(sql)
-       except: self.logger.error("Unable to create table " + self.dvoDetectionTable)
+       except: self.logger.errorPair("Unable to create table", self.dvoDetectionTable)
 
        self.logger.infoPair("Creating table", self.dvoDoneTable )
        sql = "CREATE TABLE " + self.dvoDoneTable + " (name VARCHAR(100))"
        try: self.execute(sql)
-       except: self.logger.error("Unable to create table " + self.dvoDoneTable)
-
-
-
+       except: self.logger.errorPair("Unable to create table", self.dvoDoneTable)
+
+
+