Changeset 38945

Timestamp:

Oct 22, 2015, 6:16:11 PM (11 years ago)

Author:

watersc1

Message:

Attempt at copying forcedobject to forcedgalaxy. I've moved my attempts at ForcedSummaryMeta and ForcedSummaryToImage to the forcedwarpbatch.py code, as they may make more sense there. They've been commented out, so they shouldn't interfere with anything.

Location:

trunk/ippToPsps/jython

Files:

• forcedgalaxybatch.py (added)
• forcedwarpbatch.py (modified) (1 diff)

trunk/ippToPsps/jython/forcedwarpbatch.py

@@ -638 +638 @@
 
 
+#     '''
+#     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?
+
 
     '''