Changeset 16334

Timestamp:

Feb 5, 2008, 6:44:48 PM (18 years ago)

Author:

jhoblitt

Message:

add pztool -code

Location:

trunk/ippTools

Files:

• share/pztool_find_completed_exp.sql (modified) (1 diff)
• src/pztool.c (modified) (3 diffs)
• src/pztoolConfig.c (modified) (1 diff)

trunk/ippTools/share/pztool_find_completed_exp.sql

@@ -28 +28 @@
     HAVING
         COUNT(pzDoneImfile.exp_name) = summitExp.imfiles
+        AND SUM(pzDoneImfile.fault) = 0
     ) as Foo

trunk/ippTools/src/pztool.c

@@ -344 +344 @@
     PXOPT_LOOKUP_STR(uri, config->args, "-uri", true, false);
 
+    // default values
+    PXOPT_LOOKUP_S16(code, config->args, "-code", false, false);
+
     // need to know exp_name, camera, telescope, class, class_id (to find the
     // pzPendingImfile entry and the URI for the newImfile entry.
@@ -360 +363 @@
             "       pzPendingImfile.*,"
             "       '%s'" // uri of downloaded file
+            "       '%d'" // fault code
             "   FROM pzPendingImfile"
             "   WHERE"
@@ -368 +372 @@
             "       AND pzPendingImfile.class_id = '%s'";
 
-        if (!p_psDBRunQuery(config->dbh, query, uri, exp_name, camera, telescope, class, class_id)) {
+        if (!p_psDBRunQuery(config->dbh, query, uri, exp_name, camera, telescope, class, class_id, code)) {
             // rollback
             if (!psDBRollback(config->dbh)) {

trunk/ippTools/src/pztoolConfig.c

@@ -122 +122 @@
     psMetadataAddStr(copydoneArgs, PS_LIST_TAIL, "-end_stage",  0,
         "define the end goal processing step", NULL);
+    psMetadataAddS16(copydoneArgs, PS_LIST_TAIL, "-code",  0,
+            "set fault code", 0);
 
     psMetadata *argSets = psMetadataAlloc();