Changeset 31858 for trunk/ippToPsps/jython/gpc1db.py

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

File:

• trunk/ippToPsps/jython/gpc1db.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: