Changeset 38561

Timestamp:

Jul 2, 2015, 9:39:48 AM (11 years ago)

Author:

bills

Message:

revert faults for staticskyRuns that are in state update

File:

• trunk/ippTools/src/staticskytool.c (modified) (3 diffs)

trunk/ippTools/src/staticskytool.c

@@ -754 +754 @@
     }
 
-    // Delete product
     psString delete = pxDataGet("staticskytool_revert.sql");
     if (!delete) {
@@ -760 +759 @@
         return false;
     }
+    psString update = pxDataGet("staticskytool_revert_update.sql");
+    if (!update) {
+        psError(PXTOOLS_ERR_SYS, false, "failed to retreive SQL statement");
+        return false;
+    }
 
     if (psListLength(where->list)) {
         psString whereClause = psDBGenerateWhereConditionSQL(where, NULL);
         psStringAppend(&delete, " AND %s", whereClause);
+        psStringAppend(&update, " AND %s", whereClause);
         psFree(whereClause);
     }
@@ -775 +780 @@
     psFree(delete);
 
-    int numRows = psDBAffectedRows(config->dbh); // Number of row affected
+    int numRows = psDBAffectedRows(config->dbh);
     psLogMsg("staticskytool", PS_LOG_INFO, "Deleted %d rows", numRows);
+
+    if (!p_psDBRunQuery(config->dbh, update)) {
+        psError(PS_ERR_UNKNOWN, false, "database error");
+        psFree(delete);
+        psFree(where);
+        return false;
+    }
+    psFree(update);
+
+    numRows = psDBAffectedRows(config->dbh);
+    psLogMsg("staticskytool", PS_LOG_INFO, "Updated %d rows", numRows);
 
     psFree(where);