Changeset 24885

Timestamp:

Jul 21, 2009, 3:07:43 PM (17 years ago)

Author:

bills

Message:

disable this mode it sin't ready yet

Location:

trunk/ippTools

Files:

• share/magictool_censor_raw.sql (modified) (1 diff)
• src/magictool.c (modified) (4 diffs)

trunk/ippTools/share/magictool_censor_raw.sql

@@ -1 +1 @@
 UPDATE magicRun
     JOIN magicDSRun USING(magic_id)
+    JOIN magicDSFile USING(magic_ds_id) 
     JOIN rawExp ON rawExp.magicked = magic_ds_id
-    JOIN rawImfile USING(exp_id) 
-    JOIN magicDSFile USING(magic_ds_id) 
-    JOIN magicRun USING(magic_id, exp_id)
+    JOIN rawImfile ON rawExp.exp_id = rawImfile.exp_id
 SET rawImfile.magicked = 0, 
     rawExp.magicked = 0, 

trunk/ippTools/src/magictool.c

@@ -1373 +1373 @@
 {
     psString queryFile = NULL;
-    psStringAppend(&queryFile, "magicdstool_censor_%s.sql", stage);
+    psStringAppend(&queryFile, "magictool_censor_%s.sql", stage);
     psString query = pxDataGet(queryFile);
     if (!query) {
@@ -1385 +1385 @@
     psFree(queryFile);
 
-    psStringAppend(&query, whereClause);
+    psStringAppend(&query, " WHERE %s",  whereClause);
 
     if (!p_psDBRunQuery(config->dbh, query)) {
@@ -1404 +1404 @@
     PS_ASSERT_PTR_NON_NULL(config, false);
 
+    psError(PS_ERR_PROGRAMMING, true, "-censorrun mode not ready yet");
+    return false;
+
     psMetadata *where = psMetadataAlloc();
 
@@ -1435 +1438 @@
     psFree(query);
 
+    psS32 numUpdated = psDBAffectedRows(config->dbh);
+    if (numUpdated == 0) {
+        psError(PS_ERR_UNKNOWN, false, "failed to censor magicRun");
+        psFree(whereClause);
+        return false;
+    }
+
     // Now queue any destreaked files to be re-verted