Changeset 38763 for trunk/ippToPsps/jython/stackbatch.py
- Timestamp:
- Sep 21, 2015, 11:54:38 AM (11 years ago)
- File:
-
- 1 edited
-
trunk/ippToPsps/jython/stackbatch.py (modified) (7 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/ippToPsps/jython/stackbatch.py
r38602 r38763 252 252 sqlLine.group("skyCellID", str(self.skycellID)) 253 253 sqlLine.group("photoCalID", photoCalID) 254 sqlLine.group("analysisVer", str(self.analysisVer)) 254 sqlLine.group("analysisVer", str(self.analysisVer)) 255 sqlLine.group("completMag", self.getKeyFloat(header, "%.8f", 'FLIMIT')) 255 256 sqlLine.group("expTime", self.getKeyFloat(header, "%.5f", 'EXPTIME')) 256 257 sqlLine.group("psfModelID", psfmodel) … … 270 271 sqlLine.group("pc002001", self.getKeyFloat(header, "%.8e", 'PC002001')) 271 272 sqlLine.group("pc002002", self.getKeyFloat(header, "%.8e", 'PC002002')) 272 sqlLine.group(" dataRelease", str(self.skychunk.dataRelease))273 sqlLine.group("processingVersion", str(self.skychunk.processingVersion)) 273 274 274 275 sql = sqlLine.make(") VALUES ( ", ")") … … 288 289 self.logger.infoPair("Procesing table", "StackObjectThin") 289 290 290 # insert the per-object data (IDs, random stack ID, dataRelease, etc)291 # insert the per-object data (IDs, random stack ID, processingVersion, etc) 291 292 self.selectDvoObjIDs() 292 293 … … 363 364 # sqlLine.group("a."+filter+"skyErr", "b.SKY_SIGMA / " + str(exptime)) 364 365 sqlLine.group("a."+filter+"infoFlag", "b.FLAGS") 365 sqlLine.group("a."+filter+"infoFlag2", "b.FLAGS2 | a."+filter+"infoFlag2")366 sqlLine.group("a."+filter+"infoFlag2", "b.FLAGS2") 366 367 sqlLine.group("a."+filter+"nFrames", "b.N_FRAMES") 367 368 … … 1066 1067 ''' 1067 1068 select objID (psps object ID) from dvo restricted to this set of imageIDs. also insert 1068 ippObjID and several constants (for a skycell): surveyID, skyCellId, dataRelease1069 ippObjID and several constants (for a skycell): surveyID, skyCellId, processingVersion 1069 1070 ''' 1070 1071 def selectDvoObjIDs(self): … … 1085 1086 # sqlLine.group("projectionID", "'" + str(self.projectionID) + "'") 1086 1087 # sqlLine.group("skyCellID", "'" + str(self.skycellID) + "'") 1087 # sqlLine.group(" dataRelease", "'" + str(self.skychunk.dataRelease) + "'")1088 # sqlLine.group("processingVersion", "'" + str(self.skychunk.processingVersion) + "'") 1088 1089 # sqlLine.group("randomStackObjID", "FLOOR(RAND()*9223372036854775807)") 1089 1090 … … 1122 1123 , projectionID = '" + str(self.projectionID) + "'\ 1123 1124 , skycellID = '" + str(self.skycellID) + "'\ 1124 , dataRelease = '" + str(self.skychunk.dataRelease) +"'"1125 , processingVersion = '" + str(self.skychunk.processingVersion) +"'" 1125 1126 1126 1127 try: self.scratchDb.execute(sql)
Note:
See TracChangeset
for help on using the changeset viewer.
