Changeset 39029 for trunk/ippToPsps/jython/forcedwarpbatch.py

Timestamp:

Nov 2, 2015, 4:32:17 PM (11 years ago)

Author:

watersc1

Message:

As per discussion, drop ForcedSummaryToImage and ForcedSummaryMeta tables, as they duplicate information better accesed via the ForcedWarp/Stack tables. Changed XforcedSummaryID to XstackImageID to the link back to stack information, and to match the IMAGE_ID populated from DVO. Change forcedgalaxybatch.py to know this column name change, and cut commented code that was to implement the dropped tables from forcedwarpbatch.py.

File:

• trunk/ippToPsps/jython/forcedwarpbatch.py (modified) (1 diff)

trunk/ippToPsps/jython/forcedwarpbatch.py

@@ -646 +646 @@
 
 
-#     '''
-#     Populate the ForcedSummaryMeta table, which should be fairly easy as it contains very little.
-#     '''
-#     def populateForcedSummaryMeta(self,num):
-#         forcedSummaryID = self.number[num]
-#         self.logger.infoPair("Processing table", "ForcedSummaryMeta_"+forcedSummaryID)
-
-#         sql = "CREATE TABLE ForcedSummaryMeta_"+forcedSummaryID+" LIKE ForcedSummaryMeta"
-#         try: self.scratchDb.execute(sql)
-#         except: pass
-
-#         header = self.header[num]
-#         self.logger.infoPair("found header", "ok")
-
-#         sqlLine = sqlUtility("INSERT INTO ForcedSummaryMeta_"+forcedSummaryID+" (")
-        
-#         sqlLine.group("forcedSummaryID", forcedSummaryID)
-#         sqlLine.group("batchID",         str(self.batchID))
-#         sqlLine.group("surveyID",        str(self.surveyID))
-#         sqlLine.group("filterID",        str(self.filterID))
-#         sqlLine.group("stackMetaID", self.stackID[num])
-#         sqlLine.group("processingVersion", str(self.skychunk.processingVersion))
-
-
-#         sql = sqlLine.make(") VALUES ( ", ")")
-
-#         try: self.scratchDb.execute(sql)
-#         except:
-#             self.logger.errorPair('failed sql: ', sql)
-#             raise
-        
-#     # End populateForcedSummaryMeta?
-
-#     '''
-#     Populate the ForcedSummaryToImage table, which has even less.
-#     '''
-#     def populateForcedSummaryToImage(self,num):
-#         forcedSummaryID = self.number[num]
-#         self.logger.infoPair("Processing table", "ForcedSummaryToImage_"+str(forcedSummaryID))
-
-#         sql = "CREATE TABLE ForcedSummaryToImage_"+str(forcedSummaryID)+" LIKE ForcedSummaryToImage"
-#         try: self.scratchDb.execute(sql)
-#         except: pass
-
-#         if forcedSummaryID > 0:
-#             imageIDs = self.gpc1Db.getImageIDsForThisForcedSummaryID(forcedSummaryID)
-#             for imageID in imageIDs:
-#                 sql = "INSERT INTO ForcedWarpSummaryToImage_"+str(forcedSummaryID)+" (forcedSummaryId, imageID) VALUES (" + str(forcedSummaryID) + ", " + str(imageID) + ")"
-#                 try: self.scratchDb.execute(sql)
-#                 except:
-#                     self.logger.infoPair("can't execute sql", sql)
-#                     raise
-
-#     # End populateForcedSummaryToImage?
-
 
     '''