Changeset 9272 for trunk/ippTools/src/camtool.c

Timestamp:

Oct 4, 2006, 4:03:21 PM (20 years ago)

Author:

jhoblitt

Message:

implement -pendingexp

File:

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

trunk/ippTools/src/camtool.c

@@ -58 +58 @@
     // and have no associated imfiles left in newImfile
 
-    char *query =
-        "SELECT newExp.*"
-        " FROM newExp"
-        " LEFT JOIN newImfile USING(exp_tag)"
-        " LEFT JOIN rawScienceExp USING(exp_tag)"
-        " LEFT JOIN rawDetrendExp USING(exp_tag)"
-        " WHERE"
-        "   newExp.exp_tag IS NOT NULL"
-        "   AND newImfile.exp_tag IS NULL"
-        "   AND rawScienceExp.exp_tag IS NULL"
-        "   AND newExp.imfiles ="
-        "   (SELECT COUNT(exp_tag) FROM rawImfile"
-        "       WHERE rawImfile.exp_tag = newExp.exp_tag)"
-        ;
+    psString query = psStringCopy("SELECT * FROM p3PendingExp");
+
+    if (config->where) {
+        psString whereClause = psDBGenerateWhereSQL(config->where, NULL);
+        psStringAppend(&query, " %s", whereClause);
+        psFree(whereClause);
+    }
 
     if (!p_psDBRunQuery(config->dbh, query)) {
         psError(PS_ERR_UNKNOWN, false, "database error");
+        psFree(query);
         return false;
     }
+    psFree(query);
 
     psArray *output = p_psDBFetchResult(config->dbh);
@@ -85 +80 @@
     if (!psArrayLength(output)) {
         // XXX check psError here
-        psError(PS_ERR_UNKNOWN, false, "no pending newExp rows found");
+        psError(PS_ERR_UNKNOWN, false, "no p3PendingExp rows found");
         psFree(output);
         return true;
@@ -101 +96 @@
 
     // negate simple so the default is true
-    if (!ippdbPrintMetadatas(stdout, output, "newImfile", !simple)) {
+    if (!ippdbPrintMetadatas(stdout, output, "p3PendingExp", !simple)) {
         psError(PS_ERR_UNKNOWN, false, "failed to print array");
         psFree(output);