Changeset 21443

Timestamp:

Feb 11, 2009, 3:08:59 PM (17 years ago)

Author:

bills

Message:

in -processedexp mode order results by cam_id so the postage stamp request
parser can easily find the 'latest' astrometry for an exposure.

Location:

trunk/ippTools

Files:

• share/camtool_find_processedexp.sql (modified) (1 diff)
• src/camtool.c (modified) (2 diffs)

trunk/ippTools/share/camtool_find_processedexp.sql

@@ -15 +15 @@
 JOIN rawExp
     ON chipProcessedImfile.exp_id = rawExp.exp_id
-WHERE -- bogus condition so there is a pre-existing where to append to
-    camProcessedExp.cam_id IS NOT NULL

trunk/ippTools/src/camtool.c

@@ -655 +655 @@
     }
 
-    // use psDBGenerateWhereConditionalSQL with AND ... because the SQL ends in a WHERE
     if (psListLength(where->list)) {
         psString whereClause = psDBGenerateWhereConditionSQL(where, NULL);
-        psStringAppend(&query, " AND %s", whereClause);
+        psStringAppend(&query, " WHERE %s", whereClause);
         psFree(whereClause);
     }
@@ -677 +676 @@
         psFree(limitString);
     }
+
+    // order by cam_id so that the postage stamp parser can easliy find the 'latest' astrometry
+    psStringAppend(&query, "\nORDER BY cam_id");
 
     if (!p_psDBRunQuery(config->dbh, query)) {