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

Timestamp:

May 1, 2014, 1:24:00 PM (12 years ago)

Author:

heather

Message:

found typos in vo tables

File:

• trunk/ippToPsps/jython/gpc1db.py (modified) (2 diffs)

trunk/ippToPsps/jython/gpc1db.py

@@ -398 +398 @@
 
         # print "staring stack stage cmf"
-
+        #self.logger.infoPair("in stackstagecmf - sql is: ", sql) 
         # get single path base for the directory containing all cmf files, one of which is hopefully for our stack_id
         try:
@@ -524 +524 @@
                AND filter = '" + filter + "' \
                AND sky_id = %d" % skyID 
-              
-        try:
-            rs = self.executeQuery(sql)
-            rs.first()
-            return rs.getInt()
-             
+
+#        self.logger.infoPair("sql",sql)
+
+        try:
+            rs = self.executeQuery(sql)
+                         
         except:    
             self.logger.exception("can't query for stackid in DVO")
             self.logger.infoPair("failed sql:", sql)
-            return -999
-
-        return 0
+            return 0
+
+        rs.first()
+        try:
+            stackid = rs.getInt(1)
+            self.logger.infoPair("found stack_ID", stackid)
+        except:
+            stackid = -999
+            self.logger.infoPair("using stack_ID",stackid)
+            
+        return stackid