Changeset 18697

Timestamp:

Jul 23, 2008, 4:29:30 PM (18 years ago)

Author:

Paul Price

Message:

Need to restrict what's inserted into magicInputSkyfile by the exp_id.

Location:

trunk/ippTools

Files:

• share/magictool_definebyquery_insert.sql (modified) (1 diff)
• src/magictool.c (modified) (1 diff)

trunk/ippTools/share/magictool_definebyquery_insert.sql

@@ -6 +6 @@
     CONCAT(tess_id, '.', skycell_id) AS node
 FROM magicBestDiffs
+WHERE
+    exp_id = '%s'

trunk/ippTools/src/magictool.c

@@ -271 +271 @@
         psFree(idString);
 
-        if (!p_psDBRunQuery(config->dbh, thisInsert, magic_id)) {
+        if (!p_psDBRunQuery(config->dbh, thisInsert, magic_id, exp_id)) {
             psError(PS_ERR_UNKNOWN, false, "database error");
             psFree(thisInsert);