Changeset 31858

Timestamp:

Jul 11, 2011, 2:32:27 PM (15 years ago)

Author:

rhenders

Message:

added 'WHERE state = full' constraint to get-IDs-from-DVO methods

Location:

trunk/ippToPsps/jython

Files:

• gpc1db.py (modified) (2 diffs)
• ipptopspsdb.py (modified) (2 diffs)

trunk/ippToPsps/jython/gpc1db.py

@@ -70 +70 @@
                    FROM addRun \
                    WHERE stage = '" + stage + "' \
-                   AND dvodb = '" + dvoDb + "'"
+                   AND dvodb = '" + dvoDb + "' \
+                   AND state = 'full'"
 
         elif batchType == "ST":       
@@ -79 +80 @@
                    JOIN addRun ON(staticskyInput.sky_id = addRun.stage_id) \
                    WHERE stage = '" + stage + "' \
-                   AND dvodb = '" + dvoDb + "'"
+                   AND dvodb = '" + dvoDb + "' \
+                   AND state = 'full'"
 
         try:

trunk/ippToPsps/jython/ipptopspsdb.py

@@ -68 +68 @@
                    WHERE stage = '" + stage + "' \
                    AND dvodb = '" + dvoDb + "' \
+                   AND state = 'full' \
                    AND stage_id NOT IN "
 
@@ -78 +79 @@
                    WHERE stage = '" + stage + "' \
                    AND dvodb = '" + dvoDb + "' \
+                   AND state = 'full' \
                    AND stack_id NOT IN "