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

Timestamp:

Apr 25, 2011, 3:21:40 PM (15 years ago)

Author:

rhenders

Message:

new method to find and delete rows that have a field with the provided value

File:

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

trunk/ippToPsps/jython/mysql.py

@@ -106 +106 @@
 
     '''
+    Reports the number of rows with this columns set as this numeric value and then deletes them 
+    '''
+    def reportAndDeleteRowsWithThisValue(self, tableName, columnName, value):
+
+        sql = "SELECT COUNT(*) FROM " + tableName + " WHERE " + columnName + " = " + value
+        rs = self.stmt.executeQuery(sql)
+        rs.first()
+        nBadFlux = rs.getInt(1)
+        self.logger.info("%d NULL %s values in table %s. Deleting." % (nBadFlux, columnName, tableName))
+
+        sql="DELETE from " + tableName + " WHERE " + columnName + " = " + value
+        self.stmt.execute(sql)
+
+    '''
     Reports the number of rows with this column NULL and then deletes them 
     '''