Changeset 15091 for trunk/ippTools/src/pzgetexp.c

Timestamp:

Sep 28, 2007, 2:52:00 PM (19 years ago)

Author:

jhoblitt

Message:

fetch the last_fileset by camera/telescope instead of universally

File:

• trunk/ippTools/src/pzgetexp.c (modified) (2 diffs)

trunk/ippTools/src/pzgetexp.c

@@ -68 +68 @@
 {
     PS_ASSERT_PTR_NON_NULL(config, NULL);
+
+    bool status = false;
+    psString camera = psMetadataLookupStr(&status, config->args, "-inst");
+    if (!status) {
+        psError(PS_ERR_UNKNOWN, false, "failed to lookup value for -inst");
+        return false;
+    }
+    if (!camera) {
+        psError(PS_ERR_UNKNOWN, true, "-inst is required");
+        return false;
+    }
+
+    psString telescope = psMetadataLookupStr(&status, config->args, "-telescope");
+    if (!status) {
+        psError(PS_ERR_UNKNOWN, false, "failed to lookup value for -telescope");
+        return false;
+    }
+    if (!telescope) {
+        psError(PS_ERR_UNKNOWN, true, "-telescope is required");
+        return false;
+    }
+
     // find last fileset/exp_name (if we have one)
     bool haveLastFileSet = false;
     psString lastFileSet = NULL;
     {
-        char *query = "SELECT * from summitExp ORDER BY dateobs DESC LIMIT 1";
-        if (!p_psDBRunQuery(config->dbh, query)) {
+        char *query = "SELECT * from summitExp WHERE camera = \"%s\" and TELESCOPE = \"%s\" ORDER BY dateobs DESC LIMIT 1";
+        if (!p_psDBRunQuery(config->dbh, query, camera, telescope)) {
             psError(PS_ERR_UNKNOWN, false, "database error");
             return false;
@@ -97 +119 @@
     // invoke dsproductls
     // dsproductls --uri <> --last_fileset <>
-    bool status = false;
     psString uri = psMetadataLookupStr(&status, config->args, "-uri");
     psString cmd = NULL;