Index: trunk/ippToPsps/jython/mysql.py
===================================================================
--- trunk/ippToPsps/jython/mysql.py	(revision 31843)
+++ trunk/ippToPsps/jython/mysql.py	(revision 31844)
@@ -21,16 +21,16 @@
 
     '''
-    def __init__(self, logger, dbType):
+    def __init__(self, logger, doc, dbType):
 
         # set up logging
         self.logger = logger
+        self.doc = doc
         self.logger.debug("MySql class constructor")
 
         # open config and grab database parameters
-        doc = ElementTree(file="config.xml")
-        self.dbName = doc.find(dbType +"/name").text
-        self.dbHost = doc.find(dbType +"/host").text
-        self.dbUser = doc.find(dbType +"/user").text
-        self.dbPass = doc.find(dbType +"/password").text
+        self.dbName = self.doc.find(dbType +"/name").text
+        self.dbHost = self.doc.find(dbType +"/host").text
+        self.dbUser = self.doc.find(dbType +"/user").text
+        self.dbPass = self.doc.find(dbType +"/password").text
 
         # set up JDBC connection
@@ -209,8 +209,8 @@
         rs.first()
         nBad = rs.getInt(1)
-        self.logger.info("%5d NULL %s values in table %s. Deleting." % (nBad, columnName, tableName))
 
         sql="DELETE from " + tableName + " WHERE " + columnName + " = " + value
         self.execute(sql)
+        self.logger.info("%s '%s' values in %s    %5d deleted" % (columnName, value, tableName, nBad))
 
     '''
@@ -223,8 +223,8 @@
         rs.first()
         nBad = rs.getInt(1)
-        self.logger.info("%5d NULL %s values in table %s. Deleting." % (nBad, columnName, tableName))
 
         sql="DELETE from " + tableName + " WHERE " + columnName + " IS NULL"
         self.execute(sql)
+        self.logger.infoPair("NULLs deleted from %s" % tableName, "%-5d %s" % (nBad, columnName))
 
     '''