Changeset 32293

Timestamp:

Sep 2, 2011, 11:41:41 AM (15 years ago)

Author:

rhenders

Message:

trivial improvements to log messages and SQL

File:

• trunk/ippToPsps/jython/mysql.py (modified) (2 diffs)

trunk/ippToPsps/jython/mysql.py

@@ -215 +215 @@
         nBad = rs.getInt(1)
 
-        sql="DELETE from " + tableName + " WHERE " + columnName + " = " + value
-        self.execute(sql)
-        self.logger.info("%s '%s' values in %s    %5d deleted" % (columnName, value, tableName, nBad))
+        sql="DELETE FROM " + tableName + " WHERE " + columnName + " = " + value
+        self.execute(sql)
+        self.logger.debugPair("%s rows with %s" % (columnName, value), "%d deleted" % nBad)
+
+        return nBad
 
     '''
@@ -229 +231 @@
         nBad = rs.getInt(1)
 
-        sql="DELETE from " + tableName + " WHERE " + columnName + " IS NULL"
+        sql="DELETE FROM " + tableName + " WHERE " + columnName + " IS NULL"
         self.execute(sql)
         self.logger.debugPair("NULL %s values" % columnName, "%d deleted" % nBad)