Changeset 31387 for trunk/ippToPsps/jython/mysql.py

Timestamp:

Apr 27, 2011, 9:48:39 AM (15 years ago)

Author:

rhenders

Message:

new method to replace nulls with a sub in a specific table and column

File:

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

trunk/ippToPsps/jython/mysql.py

@@ -92 +92 @@
 
     '''
+    Replaces all NULL values in the provided table and column ith the provided substitute 
+    '''
+    def replaceNullsInThisColumn(self, tableName, column, sub):
+
+      sql = "UPDATE " + tableName + " SET " + column + " = " + sub + " WHERE " + column + " IS NULL"
+      print sql
+      self.stmt.execute(sql)
+
+    '''
     Replaces all NULL values in the provided table with the provided substitute 
     '''