Changeset 14112

Timestamp:

Jul 10, 2007, 2:34:45 PM (19 years ago)

Author:

jhoblitt

Message:

add stacktool -revertsumskyfile

Location:

trunk/ippTools

Files:

• share/Makefile.am (modified) (1 diff)
• share/stacktool_revertsumskyfile.sql (added)
• src/stacktool.c (modified) (3 diffs)
• src/stacktool.h (modified) (1 diff)
• src/stacktoolConfig.c (modified) (4 diffs)

trunk/ippTools/share/Makefile.am

@@ -37 +37 @@
         stacktool_sumskyfile.sql \
         stacktool_tosum.sql \
+        stacktool_revertsumskyfile.sql \
         warptool_exp.sql \
         warptool_imfile.sql \

trunk/ippTools/src/stacktool.c

@@ -38 +38 @@
 static bool addsumskyfileMode(pxConfig *config);
 static bool sumskyfileMode(pxConfig *config);
+static bool revertsumskyfileMode(pxConfig *config);
 
 static bool setstackRunState(pxConfig *config, const char *stack_id, const char *state);
@@ -66 +67 @@
         MODECASE(STACKTOOL_MODE_ADDSUMSKYFILE,      addsumskyfileMode);
         MODECASE(STACKTOOL_MODE_SUMSKYFILE,         sumskyfileMode);
+        MODECASE(STACKTOOL_MODE_REVERTSUMSKYFILE,   revertsumskyfileMode);
         default:
             psAbort("invalid option (this should not happen)");
@@ -666 +668 @@
 
 
+static bool revertsumskyfileMode(pxConfig *config)
+{
+    PS_ASSERT_PTR_NON_NULL(config, false);
+    
+    psString query = pxDataGet("stacktool_revertsumskyfile.sql");
+    if (!query) {
+        psError(PXTOOLS_ERR_DATA, false, "failed to retreive SQL statement");
+        return false;
+    }
+
+    if (config->where) {
+        psString whereClause = psDBGenerateWhereConditionSQL(config->where, "stackSumSkyfile");
+        psStringAppend(&query, " AND %s", whereClause);
+        psFree(whereClause);
+    }
+
+    if (!p_psDBRunQuery(config->dbh, query)) {
+        psError(PS_ERR_UNKNOWN, false, "database error");
+        psFree(query);
+        return false;
+    }
+    psFree(query);
+
+    if (psDBAffectedRows(config->dbh) < 1) {
+        psError(PS_ERR_UNKNOWN, false, "should have affected atleast 1 row");
+        return false;
+    }
+
+    return true;
+}
+
+
 static bool setstackRunState(pxConfig *config, const char *stack_id, const char *state)
 {

trunk/ippTools/src/stacktool.h

@@ -32 +32 @@
     STACKTOOL_MODE_ADDSUMSKYFILE,
     STACKTOOL_MODE_SUMSKYFILE,
+    STACKTOOL_MODE_REVERTSUMSKYFILE,
 } stacktoolMode;
 

trunk/ippTools/src/stacktoolConfig.c

@@ -121 +121 @@
             "set fault code", 0);
 
-
     // -sumskyfile
     psMetadata *sumskyfileArgs= psMetadataAlloc();
@@ -133 +132 @@
             "use the simple output format", false);
 
+    // -revertsumskyfile
+    psMetadata *revertsumskyfileArgs= psMetadataAlloc();
+    psMetadataAddStr(revertsumskyfileArgs, PS_LIST_TAIL, "-stack_id", 0,
+            "search by stack ID (required)", NULL);
+    psMetadataAddS16(revertsumskyfileArgs, PS_LIST_TAIL, "-code",  0,
+            "search by fault code", 0);
+
     psFree(now);
 
@@ -145 +151 @@
     PXTOOL_ADD_MODE("-addsumskyfile",   "", STACKTOOL_MODE_ADDSUMSKYFILE,   addsumskyfileArgs);
     PXTOOL_ADD_MODE("-sumskyfile",      "", STACKTOOL_MODE_SUMSKYFILE,      sumskyfileArgs);
+    PXTOOL_ADD_MODE("-revertsumskyfile","", STACKTOOL_MODE_REVERTSUMSKYFILE,      revertsumskyfileArgs);
 
     if (!pxGetOptions(stderr, argc, argv, config, modes, argSets)) {
@@ -199 +206 @@
     }
 }
+
+{
+    psString str = NULL;
+    bool status = false;
+    if ((str = psMetadataLookupStr(&status, config->args, "-stack_id"))) {
+        if (!psMetadataAddS64(config->where, PS_LIST_TAIL, "stack_id", 0, "==", (psS64)atoll(str))) {
+            psError(PS_ERR_UNKNOWN, false, "failed to add item stack_id");
+            psFree(config);
+            return NULL;
+        }
+    }
+}
+
     addWhereStr(skycell_id);
     addWhereStr(tess_id);
-    addWhereStr(exp_id);
+
+    // convert '-code' to 'fault'
+    {
+        psS16 fault = 0;
+        bool status = false;
+        if ((fault = psMetadataLookupS16(&status, config->args, "-code"))) {
+            if (!psMetadataAddS16(config->where, PS_LIST_TAIL, "fault", 0, "==", fault)) {
+                psError(PS_ERR_UNKNOWN, false, "failed to add item fault");
+                psFree(config);
+                return NULL;
+            }
+        }
+    }
 
     if (config->where->list->n < 1) {