- Timestamp:
- Aug 12, 2014, 3:38:38 PM (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/eam_branches/ipp-20140717/ippToPsps/jython/stackbatch.py
r37238 r37241 329 329 sqlLine.group("a."+filter+"infoFlag2", "(b.flags << 13)") 330 330 sql = sqlLine.makeEquals("WHERE a.objID = b.objID AND b.imageID = " + str(imageID)) 331 self.logger.infoPair('sql', sql)332 331 333 332 try: self.scratchDb.execute(sql) … … 351 350 352 351 sql = sqlLine.makeEquals("WHERE a." + filter + "ippDetectID=b.IPP_IDET") 353 self.logger.infoPair('sql', sql)354 352 355 353 # index the (f)ippDetectIDs for the next steps? … … 428 426 sql = sqlLine.makeEquals("WHERE a." + filter + "ippDetectID = b.IPP_IDET") 429 427 430 self.logger.infoPair('sql', sql)431 428 try: 432 429 self.scratchDb.execute(sql) … … 445 442 sql = sqlLine.makeEquals("WHERE a.objID = b.objID AND a." + filter + "ippDetectID = b.ippDetectID") 446 443 447 self.logger.infoPair('sql', sql)448 444 try: 449 445 self.scratchDb.execute(sql) … … 558 554 sql = sqlLine.makeEquals("WHERE a.objID = b.objID AND a." + filter + "ippDetectID = b.ippDetectID") 559 555 560 self.logger.infoPair('sql', sql)561 556 try: 562 557 self.scratchDb.execute(sql) … … 597 592 sql = sqlLine.makeEquals("WHERE a.objID = b.objID AND a.objID = c.objID") 598 593 599 self.logger.infoPair('sql', sql)600 594 try: 601 595 self.scratchDb.execute(sql) … … 817 811 818 812 sql = sqlLine.makeEquals("WHERE a." + filter + "ippDetectID = b.IPP_IDET AND " + psfCondition) 819 self.logger.infoPair("sql",sql) 813 820 814 self.scratchDb.execute(sql) 821 815 … … 840 834 sqlLine.group(field + "Std", field + "Std" + " * POW(10, 3.56 - 0.4* b.zp)") 841 835 sql = sqlLine.makeEquals("WHERE a.objID = b.objID AND a." + filter + "ippDetectID = b.ippDetectID") 842 self.logger.infoPair("sql",sql)843 836 self.scratchDb.execute(sql) 844 837
Note:
See TracChangeset
for help on using the changeset viewer.
