Changeset 15062

Timestamp:

Sep 27, 2007, 3:54:37 PM (19 years ago)

Author:

jhoblitt

Message:

add dateobs to pztool -pendingimfile output

Location:

trunk/ippTools

Files:

• share/Makefile.am (modified) (1 diff)
• share/pztool_pendingimfile.sql (added)
• src/pztool.c (modified) (2 diffs)

trunk/ippTools/share/Makefile.am

@@ -39 +39 @@
         difftool_revertdiffskyfile.sql \
         pztool_find_completed_exp.sql \
+        pztool_pendingimfile.sql \
         regtool_pendingexp.sql \
         regtool_pendingimfile.sql \

trunk/ippTools/src/pztool.c

@@ -28 +28 @@
 
 #include "pxtools.h"
+#include "pxdata.h"
 #include "pztool.h"
 
@@ -217 +218 @@
     }
 
-    psString query = psStringCopy(
-            "SELECT"
-            "   summitImfile.*"
-            " FROM pzPendingImfile"
-            " JOIN summitImfile"
-            "   USING(exp_name, camera, telescope, class, class_id)"
-        );
+    psString query = pxDataGet("pztool_pendingimfile.sql");
+    if (!query) {
+        psError(PXTOOLS_ERR_DATA, false, "failed to retreive SQL statement");
+        return false;
+    }
 
     if (config->where) {