Changeset 39255 for trunk/ippToPsps/jython/objectbatch.py
- Timestamp:
- Dec 11, 2015, 5:03:38 PM (11 years ago)
- File:
-
- 1 edited
-
trunk/ippToPsps/jython/objectbatch.py (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/ippToPsps/jython/objectbatch.py
r39099 r39255 247 247 ''' 248 248 def updateObjName(self): 249 ##this is a 4 part update: 250 self.logger.infoPair("updating objName", "using stacks") 251 252 ## if we have a stackra and dec, use stackra and dec , dec >=0 253 254 sql = "update ObjectThin set objName = concat('PSO J', \ 255 lpad(floor(raStack/15.),2,'0'), \ 256 lpad(format((raStack/15. - (floor(raStack/15.)))*60.,0), 2, '0'), \ 257 lpad(format(((raStack/15. - (floor(raStack/15.)))*60. - floor((raStack/15.-(floor(raStack/15.)))*60.))*60.,2),5,'0'), \ 258 '+', \ 259 lpad(floor(abs(decStack)),2,'0'), \ 260 lpad(format((abs(decStack)-(floor(abs(decStack))))*60.,0), 2, '0'), \ 261 lpad(format(((abs(decStack)-(floor(abs(decStack))))*60.-floor((abs(decStack)-(floor(abs(decStack))))*60.))*60.,2),5,'0') \ 262 ) where raStack > -999 and decStack > -999 and decStack >= 0" 263 try: 264 self.scratchDb.execute(sql) 265 except: 266 self.logger.errorPair("failed sql", sql) 267 raise 268 return False 269 270 ## if we have a stackra and dec, use stackra and dec, dec < 0 271 272 sql = "update ObjectThin set objName = concat('PSO J', \ 273 lpad(floor(raStack/15.),2,'0'), \ 274 lpad(format((raStack/15. - (floor(raStack/15.)))*60.,0), 2, '0'), \ 275 lpad(format(((raStack/15. - (floor(raStack/15.)))*60. - floor((raStack/15.-(floor(raStack/15.)))*60.))*60.,2),5,'0'), \ 276 '-', \ 277 lpad(floor(abs(decStack)),2,'0'), \ 278 lpad(format((abs(decStack)-(floor(abs(decStack))))*60.,0), 2, '0'), \ 279 lpad(format(((abs(decStack)-(floor(abs(decStack))))*60.-floor((abs(decStack)-(floor(abs(decStack))))*60.))*60.,2),5,'0') \ 280 ) where raStack > -999 and decStack > -999 and decStack < 0" 281 try: 282 self.scratchDb.execute(sql) 283 except: 284 self.logger.errorPair("failed sql", sql) 285 raise 286 return False 287 288 self.logger.infoPair("updating objName", "using means") 289 290 291 ## use mean ra and dec (dec >= 0) 292 sql = "update ObjectThin set objName = concat('PSO J', \ 293 lpad(floor(raMean/15.),2,'0'), \ 294 lpad(format((raMean/15. - (floor(raMean/15.)))*60.,0), 2, '0'), \ 295 lpad(format(((raMean/15. - (floor(raMean/15.)))*60. - floor((raMean/15.-(floor(raMean/15.)))*60.))*60.,2),5,'0'), \ 296 '+', \ 297 lpad(floor(abs(decMean)),2,'0'), \ 298 lpad(format((abs(decMean)-(floor(abs(decMean))))*60.,0), 2, '0'), \ 299 lpad(format(((abs(decMean)-(floor(abs(decMean))))*60.-floor((abs(decMean)-(floor(abs(decMean))))*60.))*60.,2),5,'0') \ 300 ) where raMean > -999 and decMean > -999 and decMean >= 0 AND objName IS NULL" 301 302 try: 303 self.scratchDb.execute(sql) 304 except: 305 self.logger.errorPair("failed sql", sql) 306 raise 307 return False 308 309 ## use mean ra and dec (dec < 0) 310 311 sql = "update ObjectThin set objName = concat('PSO J', \ 312 lpad(floor(raMean/15.),2,'0'), \ 313 lpad(format((raMean/15. - (floor(raMean/15.)))*60.,0), 2, '0'), \ 314 lpad(format(((raMean/15. - (floor(raMean/15.)))*60. - floor((raMean/15.-(floor(raMean/15.)))*60.))*60.,2),5,'0'), \ 315 '-', \ 316 lpad(floor(abs(decMean)),2,'0'), \ 317 lpad(format((abs(decMean)-(floor(abs(decMean))))*60.,0), 2, '0'), \ 318 lpad(format(((abs(decMean)-(floor(abs(decMean))))*60.-floor((abs(decMean)-(floor(abs(decMean))))*60.))*60.,2),5,'0') \ 319 ) where raMean > -999 and decMean > -999 and decMean < 0 AND objName IS NULL" 320 try: 321 self.scratchDb.execute(sql) 322 except: 323 self.logger.errorPair("failed sql", sql) 324 raise 325 return False 326 327 328 # update altname 329 self.logger.infoPair("updating objAltName1", "using stacks") 330 331 sql = "update ObjectThin SET objAltName1 = concat('PSO J', \ 332 format(raStack,4),'+',format(decStack,4)) where raStack > -999 AND decStack > -999 AND decStack >= 0 " 333 try: 334 self.scratchDb.execute(sql) 335 except: 336 self.logger.errorPair("failed sql", sql) 337 raise 338 return False 339 340 sql = "update ObjectThin SET objAltName1 = concat('PSO J', \ 341 format(raStack,4),format(decStack,4)) where raStack > -999 AND decStack > -999 AND decStack < 0 " 342 try: 343 self.scratchDb.execute(sql) 344 except: 345 self.logger.errorPair("failed sql", sql) 346 raise 347 return False 348 349 self.logger.infoPair("updating objAltName1", "using means") 350 351 sql = "update ObjectThin SET objAltName1 = concat('PSO J', \ 352 format(raMean,4),'+',format(decMean,4)) where raMean > -999 AND decMean > -999 AND decMean >= 0 AND objAltName1 IS NULL" 353 try: 354 self.scratchDb.execute(sql) 355 except: 356 self.logger.errorPair("failed sql", sql) 357 raise 358 return False 359 360 sql = "update ObjectThin SET objAltName1 = concat('PSO J', \ 361 format(raMean,4),format(decMean,4)) where raMean > -999 AND decMean > -999 AND decMean < 0 AND objAltName1 IS NULL" 362 try: 363 self.scratchDb.execute(sql) 364 except: 365 self.logger.errorPair("failed sql", sql) 366 raise 367 return False 368 369 370 371 249 self.logger.info("Names are now populated with the populateObjectThinTable call") 250 251 return True 372 252 ''' 373 253 Populates the Object table … … 428 308 sqlLine.group("raMean", "RA_MEAN") 429 309 sqlLine.group("decMean", "DEC_MEAN") 310 sqlLine.group("objName", "IAU_NAME") 311 sqlLine.group("objPSOName", "PSO_NAME") 430 312 sqlLine.group("epochMean", "EPOCH_MEAN") 431 313 sqlLine.group("raMeanErr", "RA_ERR")
Note:
See TracChangeset
for help on using the changeset viewer.
