Changeset 10159

Timestamp:

Nov 22, 2006, 4:02:08 PM (20 years ago)

Author:

jhoblitt

Message:

add detRun.mode = 'create' restraint

File:

• trunk/ippTools/src/dettool.c (modified) (21 diffs)

trunk/ippTools/src/dettool.c

@@ -1305 +1305 @@
             " WHERE"
             "   detRun.state = 'run'"
+            "   AND detRun.mode = 'create'"
         );
 
@@ -1386 +1387 @@
             " WHERE"
             "   detRun.state = 'run'"
+            "   AND detRun.mode = 'create'"
             "   AND detProcessedImfile.det_id IS NULL"
             "   AND detProcessedImfile.exp_tag IS NULL"
@@ -1671 +1673 @@
         " WHERE"
         "   detRun.state = 'run'"
+        "   AND detRun.mode = 'create'"
         "   AND detProcessedExp.det_id IS NULL"
         "   AND detProcessedExp.exp_tag IS NULL"
@@ -1828 +1831 @@
         " WHERE"
         "   detRun.state = 'run'"
+        "   AND detRun.mode = 'create'"
         "   AND detProcessedExp.det_id IS NULL"
         "   AND detProcessedExp.exp_tag IS NULL"
@@ -1980 +1984 @@
         " WHERE"
         "   detRun.state = 'run'"
+        "   AND detRun.mode = 'create'"
         "   AND detStackedImfile.det_id IS NULL"
         "   AND detStackedImfile.iteration IS NULL"
@@ -1991 +1996 @@
         );
 
-    // XXX does it make sens to accept any search params?
+    // XXX does it make sense to accept any search params?
 #if 0
     if (config->where) {
@@ -2058 +2063 @@
         " WHERE"
         "   detRun.state = 'run'"
+        "   AND detRun.mode = 'create'"
     );
 
@@ -2269 +2275 @@
         " WHERE"
         "   detRun.state = 'run'"
+        "   AND detRun.mode = 'create'"
     );
 
@@ -2365 +2372 @@
         " WHERE"
         "   detRun.state = 'run'"
+        "   AND detRun.mode = 'create'"
         "   AND detNormalizedStatImfile.det_id IS NULL"
         "   AND detNormalizedStatImfile.iteration IS NULL"
@@ -2886 +2894 @@
         " WHERE"
         "   detRun.state = 'run'"
+        "   AND detRun.mode = 'create'"
         "   AND detNormalizedExp.det_id IS NULL"
         "   AND detNormalizedExp.iteration IS NULL"
@@ -3041 +3050 @@
         " WHERE"
         "   detRun.state = 'run'"
+        "   AND detRun.mode = 'create'"
         "   AND detNormalizedExp.det_id IS NULL"
         "   AND detNormalizedExp.iteration IS NULL"
@@ -3109 +3119 @@
         " WHERE"
         "   detRun.state = 'run'"
+        "   AND detRun.mode = 'create'"
     );
 
@@ -3263 +3274 @@
         " WHERE"
         "   detRun.state = 'run'"
+        "   AND detRun.mode = 'create'"
         "   AND detResidImfile.det_id IS NULL"
         "   AND detResidImfile.iteration IS NULL"
@@ -3332 +3344 @@
         " WHERE"
         "   detRun.state = 'run'"
+        "   AND detRun.mode = 'create'"
     );
 
@@ -3657 +3670 @@
         " WHERE"
         "   detRun.state = 'run'"
+        "   AND detRun.mode = 'create'"
     );
 
@@ -3764 +3778 @@
         "   WHERE"
         "       detRun.state = 'run'"
+        "   AND detRun.mode = 'create'"
         "       AND detResidExp.det_id IS NULL"
         "       AND detResidExp.iteration IS NULL"
@@ -3880 +3895 @@
         "   WHERE"
         "       detRun.state = 'run'"
+        "   AND detRun.mode = 'create'"
         "       AND detResidExp.det_id IS NULL"
         "       AND detResidExp.iteration IS NULL"
@@ -4133 +4149 @@
         " WHERE"
         "   detRun.state = 'run'"
+        "   AND detRun.mode = 'create'"
     );
 
@@ -4224 +4241 @@
         "   WHERE"
         "       detRun.state = 'run'"
+        "   AND detRun.mode = 'create'"
         "   GROUP BY"
         "       detRun.det_id,"
@@ -4487 +4505 @@
         "   WHERE"
         "       detRun.state = 'run'"
+        "   AND detRun.mode = 'create'"
         "   GROUP BY"
         "       detRun.det_id,"
@@ -4730 +4749 @@
         "   AND detInputExp.exp_tag = detResidExp.exp_tag"
         " WHERE"
-        "   detRun.state = 'run'");
+        "   detRun.state = 'run'"
+        "   AND detRun.mode = 'create'"
+    );
 
     // XXX this query was not restricted by det_id, resulting