Changeset 37239

Timestamp:

Aug 12, 2014, 3:27:57 PM (12 years ago)

Author:

eugene

Message:

remove test pritns

Location:

branches/eam_branches/ipp-20140717/ippToPsps/jython

Files:

• dvo.py (modified) (3 diffs)
• gpc1db.py (modified) (1 diff)
• ipptopsps.py (modified) (4 diffs)
• ipptopspsdb.py (modified) (7 diffs)
• scratchdb.py (modified) (2 diffs)

branches/eam_branches/ipp-20140717/ippToPsps/jython/dvo.py

@@ -63 +63 @@
         # this scratch Db either has no DVO info ingested, or a different DVO ingested. Prompt user
         if not self.correctDvo:
-            print "*******************************************************************************"
             self.logger.warning("switching to a new dvo: '" + self.skychunk.dvoLocation + "'")
             # response = raw_input("(y/n) ")
@@ -105 +104 @@
 
         if (self.skychunk.dvoLocation == 'none'):
-            print "do not load Photcodes for place-holder DVO " + self.skychunk.dvoLocation
+            # print "do not load Photcodes for place-holder DVO " + self.skychunk.dvoLocation
             return False
 
@@ -160 +159 @@
 
         if (self.skychunk.dvoLocation == 'none'):
-            print "do not load SkyTable for place-holder DVO " + self.skychunk.dvoLocation
+            # print "do not load SkyTable for place-holder DVO " + self.skychunk.dvoLocation
             return False
 

branches/eam_branches/ipp-20140717/ippToPsps/jython/gpc1db.py

@@ -117 +117 @@
             stage = "forcedwarp"
             sql = "SELECT differentStuff from Stufftable"
-
-        self.logger.infoPair("sql for pending:", sql)
 
         try:

branches/eam_branches/ipp-20140717/ippToPsps/jython/ipptopsps.py

@@ -55 +55 @@
             raise
 
-        print "check client status"
         self.checkClientStatus()
 
@@ -143 +142 @@
     def checkClientStatus(self):
 
-        print "updateClient (add this process to client table)"
         self.ippToPspsDb.updateClient(self.config.programName, self.HOST, self.PID)
 
-        print "check if isKilled (has someone killed me?)"
         if self.ippToPspsDb.isKilled(self.HOST, self.PID): 
             self.exitProgram("killed via Db")
@@ -152 +149 @@
         # this loop pauses the process if we have no skychunk or we have set it to pause
         firstTimeIn = True
-        print "refreshSkychunk"
         while not self.refreshSkychunk() or self.ippToPspsDb.isPaused(self.HOST, self.PID):
-
-            print "looping in ipptopsps"
-
             self.ippToPspsDb.updateClient(self.config.programName, self.HOST, self.PID)
             if self.ippToPspsDb.isKilled(self.HOST, self.PID): 
@@ -163 +156 @@
             firstTimeIn = False
             time.sleep(self.PAUSEPERIOD)
-
-        print "DONE looping in ipptopsps"
 
     '''

branches/eam_branches/ipp-20140717/ippToPsps/jython/ipptopspsdb.py

@@ -1259 +1259 @@
                 AND batch_type = '" + batchType + "'")
 
-        print "deleted old items"
-
         for id in ids:
             sql = "INSERT IGNORE INTO pending \
@@ -1267 +1265 @@
                (" + str(box_id) + ", '" + batchType + "', " + str(id) + ")"
 
-            print "sql: ", sql
-
             try: self.execute(sql)
             except:
                 print "failed to insert into pending"
+                print "sql: " + sql
                 raise
 
@@ -1296 +1293 @@
                GROUP BY ra_center LIMIT 1"
 
-        # XXX print "sql: ", sql               
-
         try: rs = self.executeQuery(sql)
         except:
@@ -1303 +1298 @@
             print "SQL: " + sql
 
-        print "SQL: " + sql
         if not rs.next():
             self.logger.errorPair("No outstanding boxes", "nothing to do here")
@@ -1384 +1378 @@
             print "SQL: " + sql
 
-        print "SQL: " + sql
         if not rs.next():
             self.logger.infoPair("No outstanding boxes", "nothing to do here")
@@ -1620 +1613 @@
                        VALUES ( '" + dvo_db + "', '" + batchType + "'," + str(row[0]) + "," + str(row[1]) + " \
                        , " + str(row[2]) + ", '"+uniq+"' ) " 
-                print "sql 1: ", sql
+                # print "sql 1: ", sql
                 self.execute(sql)
             except: continue
@@ -1641 +1634 @@
                AND dec_bore BETWEEN " + str(minDEC) + " AND " + str(maxDEC)
 
-        print "items: ", sql
-
         try:
             rs = self.executeQuery(sql)
             while (rs.next()): 
                 ids.append(rs.getInt(1))
-                print "stage_id: " + str(rs.getInt(1))
         except:
             self.logger.errorPair("Can't get items in this box", sql)

branches/eam_branches/ipp-20140717/ippToPsps/jython/scratchdb.py

@@ -482 +482 @@
         try: self.execute(sql)
         except: 
-            print "problem dropping DVO " + dvoDetectionTable
+            self.logger.errorPair("problem dropping DVO table", dvoDetectionTable)
             pass
 
@@ -561 +561 @@
 
        # we need a big enough memory table for the incoming detections
-       print "requested memory in gigs: ", self.memoryTableSize
+       # print "requested memory in gigs: ", self.memoryTableSize
        tableSize = int(self.memoryTableSize) * 1024 * 1024 * 1024
+       self.logger.infoPair("setting max heap size: ", tableSize)
+
        sql = "set @@max_heap_table_size = " + str(tableSize)
-       print "setting max heap size: ", sql
        try: self.execute(sql)
        except: