Changeset 27526
- Timestamp:
- Mar 30, 2010, 9:40:04 AM (16 years ago)
- Location:
- branches/eam_branches/20100225
- Files:
-
- 16 edited
-
. (modified) (1 prop)
-
Ohana (modified) (1 prop)
-
Ohana/src/relphot/src/StarOps.c (modified) (3 diffs)
-
ippScripts/scripts/automate_stacks.pl (modified) (13 diffs)
-
ippTasks/detrend.cleanup.pro (modified) (26 diffs)
-
ippTasks/nightly_stacks.pro (modified) (1 diff)
-
ippToPsps/scripts/pspsSchema2xml.pl (modified) (3 diffs)
-
ippTools/share/magicdstool_getskycells.sql (modified) (4 diffs)
-
ippTools/src/magicdstool.c (modified) (2 diffs)
-
ippconfig/recipes/nightly_science.config (modified) (1 diff)
-
ippconfig/recipes/psphot.config (modified) (2 diffs)
-
ppViz (modified) (1 prop)
-
ppViz/src/ppVizPattern (modified) (1 prop)
-
pstamp/scripts/pstampparse.pl (modified) (2 diffs)
-
tools/neb-ds9.pl (modified) (2 diffs)
-
tools/wiki_nightly_stacks_table.pl (modified) (6 diffs)
Legend:
- Unmodified
- Added
- Removed
-
branches/eam_branches/20100225
- Property svn:mergeinfo changed
/trunk merged: 27513-27516,27518-27522,27524-27525
- Property svn:mergeinfo changed
-
branches/eam_branches/20100225/Ohana
- Property svn:mergeinfo changed
/trunk/Ohana merged: 27521
- Property svn:mergeinfo changed
-
branches/eam_branches/20100225/Ohana/src/relphot/src/StarOps.c
r27517 r27526 194 194 Nsecfilt = catalog[0].Nsecfilt; 195 195 196 # define PSFQUALSTATS 1 196 197 for (i = 0; i < Ncatalog; i++) { 197 198 for (j = 0; j < catalog[i].Naverage; j++) { … … 213 214 214 215 // XXX only apply this filter for psphot data from GPC1 for now... 215 if ( 0&& (catalog[i].measure[m].photcode > 10000) && (catalog[i].measure[m].photcode < 10500)) {216 if (PSFQUALSTATS && (catalog[i].measure[m].photcode > 10000) && (catalog[i].measure[m].photcode < 10500)) { 216 217 if (catalog[i].measure[m].psfQual < 0.85) continue; 217 218 } … … 235 236 // update average flags based on the detection stats. 236 237 // XXX we need to clean this up -- this is a serious set of hacks... 237 if ( 0) {238 if (PSFQUALSTATS) { 238 239 int Galaxy2MASS, GalaxySDSS, goodPS1, nEXT, nPSF, good2MASS; 239 240 -
branches/eam_branches/20100225/ippScripts/scripts/automate_stacks.pl
r27517 r27526 55 55 56 56 # Grab options 57 my ( $date, $camera, $dbname, $logfile, $verbose );57 my ( $date, $camera, $dbname, $logfile, $verbose, $manual); 58 58 my ( $help, $isburning, $force_stack_count, $test_mode, $this_target_only, $this_filter_only); 59 59 my ( $check_registration, $define_burntool, $queue_burntool, $check_chips, $queue_chips); … … 125 125 my %comment_list= (); 126 126 my %stackable_list = (); 127 my %reduction_class = (); 127 128 my $retention_time = 9000; 128 129 … … 168 169 $stackable_list{$this_target} = ${ $tentry }{value}; 169 170 } 171 elsif (${ $tentry }{name} eq 'REDUCTION') { 172 $reduction_class{$this_target} = ${ $tentry }{value}; 173 } 170 174 } 171 175 } … … 307 311 $Nsummit_exps++; 308 312 if ($summit_fault) { 309 print STDERR "check_summit_copy: $date $exp_name has summit_fault $summit_fault";313 print STDERR "check_summit_copy: $date $exp_name has summit_fault $summit_fault"; 310 314 if ($exp_type ne 'OBJECT') { 311 315 print STDERR " (but I don't care).\n"; … … 450 454 my $target = shift; 451 455 452 my ($label,$workdir,$obs_mode,$object,$comment,$tess_id,$dist_group,$data_group ) = get_tool_parameters($date,$target);456 my ($label,$workdir,$obs_mode,$object,$comment,$tess_id,$dist_group,$data_group,$reduction) = get_tool_parameters($date,$target); 453 457 454 458 my $select = "-dateobs_begin ${date}T00:00:00 -dateobs_end ${date}T23:59:59 "; … … 469 473 $cmd .= " -comment '$comment' "; 470 474 } 475 if (defined($reduction)) { 476 $cmd .= " -set_reduction $reduction "; 477 } 471 478 $cmd .= " $select "; 472 479 if ($debug == 1) { … … 484 491 my $db = init_gpc_db(); 485 492 $date =~ s/-//g; 486 my ($label,$workdir,$obs_mode,$object,$comment,$tess_id,$dist_group,$data_group ) = get_tool_parameters($date,$target);493 my ($label,$workdir,$obs_mode,$object,$comment,$tess_id,$dist_group,$data_group,$reduction) = get_tool_parameters($date,$target); 487 494 488 495 my $sth = "SELECT exp_id from chipRun where data_group = '$data_group' AND exp_id = $exp_id"; … … 543 550 my ($Nexposures,$Nimfiles,$Nburntooled,$Nalready) = pre_chip_queue($date,$target); 544 551 if ($Nexposures == 0) { 545 print STDERR "execute_chips: Target $target on $date had no exposures.\n"; 552 print STDERR "execute_chips: Target $target on $date had no exposures.\n"; 553 next; 554 } 555 if ($Nalready != 0) { 556 print STDERR "execute_chips: Not queueing $target on $date due to already existing exposures.\n"; 546 557 next; 547 558 } 548 if ($Nalready != 0) {549 print STDERR "execute_chips: Not queueing $target on $date due to already existing exposures.\n";550 next;551 }552 559 if ($Nimfiles != $Nburntooled) { 553 print STDERR "execute_chips: Target $target on $date is not fully burntooled.\n";560 print STDERR "execute_chips: Target $target on $date is not fully burntooled.\n"; 554 561 $metadata_out{nsState} = 'NEEDSBURNING'; 555 562 next; … … 574 581 my $filter = shift; 575 582 576 my ($label,$workdir,$obs_mode,$object,$comment,$tess_id,$dist_group,$data_group ) = get_tool_parameters($date,$target);583 my ($label,$workdir,$obs_mode,$object,$comment,$tess_id,$dist_group,$data_group,$reduction) = get_tool_parameters($date,$target); 577 584 578 585 my $select = "-select_dateobs_begin ${date}T00:00:00 -select_dateobs_end ${date}T23:59:59 "; … … 603 610 my $db = init_gpc_db(); 604 611 $date =~ s/-//g; 605 my ($label,$workdir,$obs_mode,$object,$comment,$tess_id,$dist_group,$data_group ) = get_tool_parameters($date,$target);612 my ($label,$workdir,$obs_mode,$object,$comment,$tess_id,$dist_group,$data_group,$reduction) = get_tool_parameters($date,$target); 606 613 607 614 my $sth = "SELECT skycell_id from stackRun where data_group = '$data_group' AND skycell_id = '$skycell' AND filter = '$filter'"; … … 616 623 my $filter = shift; 617 624 618 my ($label,$workdir,$obs_mode,$object,$comment,$tess_id,$dist_group,$data_group ) = get_tool_parameters($date,$target);625 my ($label,$workdir,$obs_mode,$object,$comment,$tess_id,$dist_group,$data_group,$reduction) = get_tool_parameters($date,$target); 619 626 # check warp stage == chip stage 620 627 my $db = init_gpc_db(); … … 716 723 my $cleaning_date = $dt->ymd; 717 724 718 my ($label,$workdir,$obs_mode,$object,$comment,$tess_id,$dist_group,$data_group ) = get_tool_parameters($cleaning_date,$target);725 my ($label,$workdir,$obs_mode,$object,$comment,$tess_id,$dist_group,$data_group,$reduction) = get_tool_parameters($cleaning_date,$target); 719 726 720 727 my $args .= " -dbname gpc1 -updaterun -set_state goto_cleaned -state full -data_group $data_group "; … … 779 786 my $data_group = "${target}.${trunc_date}"; 780 787 my $tess_id = $tessID_list{$target}; 781 782 return($label,$workdir,$obs_mode,$object,$comment,$tess_id,$dist_group,$data_group );788 my $reduction = $reduction_class{$target}; 789 return($label,$workdir,$obs_mode,$object,$comment,$tess_id,$dist_group,$data_group,$reduction); 783 790 } 784 791 -
branches/eam_branches/20100225/ippTasks/detrend.cleanup.pro
r25324 r27526 6 6 check.globals 7 7 8 book init detCleanupProcessedImfile 9 book init detCleanupProcessedExp 8 book init detCleanupProcessed 9 book init detCleanupResid 10 10 11 book init detCleanupStackedImfile 11 12 book init detCleanupNormStatImfile 12 13 book init detCleanupNormImfile 13 14 book init detCleanupNormExp 14 book init detCleanupResidImfile 15 book init detCleanupResidExp 15 16 16 17 17 macro detclean.reset 18 book init detCleanupProcessedImfile 19 book init detCleanupProcessedExp 18 book init detCleanupProcessed 19 book init detCleanupResid 20 20 21 book init detCleanupStackedImfile 21 22 22 book init detCleanupNormStatImfile 23 23 book init detCleanupNormImfile 24 24 book init detCleanupNormExp 25 26 book init detCleanupResidImfile27 book init detCleanupResidExp28 25 end 29 26 30 27 macro detclean.status 31 echo detCleanupProcessedImfile 32 book listbook detCleanupProcessedImfile 33 echo detCleanupProcessedExp 34 book listbook detCleanupProcessedExp 35 echo detCleanupStackedImfile 28 book listbook detCleanupProcessed 29 book listbook detCleanupResid 30 36 31 book listbook detCleanupStackedImfile 37 38 32 book listbook detCleanupNormStatImfile 39 33 book listbook detCleanupNormImfile 40 34 book listbook detCleanupNormExp 41 book listbook detCleanupResidImfile 42 book listbook detCleanupResidExp 35 43 36 end 44 37 45 38 macro detclean.on 46 task detrend.cleanup.process .load39 task detrend.cleanup.processed.load 47 40 active true 48 41 end 49 task detrend.cleanup.process.run 50 active true 51 end 52 task detrend.cleanup.processexp.load 53 active true 54 end 55 task detrend.cleanup.processexp.run 56 active true 57 end 58 task detrend.cleanup.stack.load 59 active true 60 end 61 task detrend.cleanup.stack.run 62 active true 63 end 64 65 task detrend.cleanup.norm.load 66 active true 67 end 68 task detrend.cleanup.norm.run 69 active true 70 end 71 task detrend.cleanup.normexp.load 72 active true 73 end 74 task detrend.cleanup.normexp.run 75 active true 76 end 77 task detrend.cleanup.normstat.load 78 active true 79 end 80 task detrend.cleanup.normstat.run 42 task detrend.cleanup.processed.run 81 43 active true 82 44 end … … 88 50 active true 89 51 end 90 task detrend.cleanup.residexp.load 91 active true 92 end 93 task detrend.cleanup.residexp.run 94 active true 95 end 52 53 # task detrend.cleanup.stack.load 54 # active true 55 # end 56 # task detrend.cleanup.stack.run 57 # active true 58 # end 59 # task detrend.cleanup.norm.load 60 # active true 61 # end 62 # task detrend.cleanup.norm.run 63 # active true 64 # end 65 # task detrend.cleanup.normexp.load 66 # active true 67 # end 68 # task detrend.cleanup.normexp.run 69 # active true 70 # end 71 # task detrend.cleanup.normstat.load 72 # active true 73 # end 74 # task detrend.cleanup.normstat.run 75 # active true 76 # end 96 77 end 97 78 98 79 macro detclean.off 99 task detrend.cleanup.process.load 100 active false 101 end 102 task detrend.cleanup.process.run 103 active false 104 end 105 task detrend.cleanup.processexp.load 106 active false 107 end 108 task detrend.cleanup.processexp.run 109 active false 110 end 80 task detrend.cleanup.processed.load 81 active false 82 end 83 task detrend.cleanup.processed.run 84 active false 85 end 86 87 task detrend.cleanup.resid.load 88 active false 89 end 90 task detrend.cleanup.resid.run 91 active false 92 end 93 111 94 task detrend.cleanup.stack.load 112 95 active false … … 133 116 active false 134 117 end 135 task detrend.cleanup.resid.load 136 active false 137 end 138 task detrend.cleanup.resid.run 139 active false 140 end 141 task detrend.cleanup.residexp.load 142 active false 143 end 144 task detrend.cleanup.residexp.run 145 active false 146 end 118 147 119 end 148 120 149 121 150 122 # these variables will cycle through the known database names 151 $detCleanupProcessedImfile_DB = 0 152 $detCleanupProcessedExp_DB = 0 123 $detCleanupProcessed_DB = 0 124 $detCleanupResid_DB = 0 125 153 126 $detCleanupStackedImfile_DB = 0 154 127 $detCleanupNormStatImfile_DB = 0 155 128 $detCleanupNormImfile_DB = 0 156 129 $detCleanupNormExp_DB = 0 157 $detCleanupResidImfile_DB = 0 158 $detCleanupResidExp_DB = 0 159 160 ######## cleanup process imfile ######## 161 task detrend.cleanup.process.load 130 131 ######## cleanup processed imfile/exp ######## 132 task detrend.cleanup.processed.load 162 133 host local 163 134 … … 169 140 170 141 stdout NULL 171 stderr $LOGDIR/detrend.cleanup.process .imfile.log172 173 task.exec 174 $run = dettool -pendingcleanup_processed imfile142 stderr $LOGDIR/detrend.cleanup.processed.log 143 144 task.exec 145 $run = dettool -pendingcleanup_processedexp 175 146 if ($DB:n == 0) 176 147 option DEFAULT 177 148 else 178 149 # save the DB name for the exit tasks 179 option $DB:$detCleanupProcessed Imfile_DB180 $run = $run -dbname $DB:$detCleanupProcessed Imfile_DB181 $detCleanupProcessed Imfile_DB ++182 if ($detCleanupProcessed Imfile_DB >= $DB:n) set detCleanupProcessedImfile_DB = 0150 option $DB:$detCleanupProcessed_DB 151 $run = $run -dbname $DB:$detCleanupProcessed_DB 152 $detCleanupProcessed_DB ++ 153 if ($detCleanupProcessed_DB >= $DB:n) set detCleanupProcessed_DB = 0 183 154 end 184 155 add_poll_args run … … 189 160 task.exit 0 190 161 # convert 'stdout' to book format 191 ipptool2book stdout detCleanupProcessed Imfile -key det_id:exp_id:class_id -uniq -setword dbname $options:0 -setword pantaskState INIT162 ipptool2book stdout detCleanupProcessed -key det_id:exp_id -uniq -setword dbname $options:0 -setword pantaskState INIT 192 163 if ($VERBOSE > 2) 193 book listbook detCleanupProcessed Imfile164 book listbook detCleanupProcessed 194 165 end 195 166 196 167 # delete existing entries in the appropriate pantaskStates 197 process_cleanup detCleanupProcessed Imfile168 process_cleanup detCleanupProcessed 198 169 end 199 170 … … 214 185 215 186 # run the ipp_cleanup.pl script on pending images 216 task detrend.cleanup.process .run187 task detrend.cleanup.processed.run 217 188 periods -poll $RUNPOLL 218 189 periods -exec $RUNEXEC … … 221 192 222 193 task.exec 223 book npages detCleanupProcessed Imfile-var N194 book npages detCleanupProcessed -var N 224 195 if ($N == 0) break 225 196 if ($NETWORK == 0) break 226 197 227 # look for new images in detCleanupProcessed Imfile(pantaskState == INIT)228 book getpage detCleanupProcessed Imfile0 -var pageName -key pantaskState INIT198 # look for new images in detCleanupProcessed (pantaskState == INIT) 199 book getpage detCleanupProcessed 0 -var pageName -key pantaskState INIT 229 200 if ("$pageName" == "NULL") break 230 201 231 book setword detCleanupProcessedImfile $pageName pantaskState RUN 232 book getword detCleanupProcessedImfile $pageName det_id -var DET_ID 233 book getword detCleanupProcessedImfile $pageName exp_id -var EXP_ID 234 book getword detCleanupProcessedImfile $pageName class_id -var CLASS_ID 235 book getword detCleanupProcessedImfile $pageName camera -var CAMERA 236 book getword detCleanupProcessedImfile $pageName data_state -var CLEANUP_MODE 237 book getword detCleanupProcessedImfile $pageName dbname -var DBNAME 238 239 # specify choice of local or remote host based on camera and chip (class_id) 202 book setword detCleanupProcessed $pageName pantaskState RUN 203 book getword detCleanupProcessed $pageName det_id -var DET_ID 204 book getword detCleanupProcessed $pageName exp_id -var EXP_ID 205 book getword detCleanupProcessed $pageName camera -var CAMERA 206 book getword detCleanupProcessed $pageName data_state -var CLEANUP_MODE 207 book getword detCleanupProcessed $pageName dbname -var DBNAME 208 209 # specify choice of local or remote host based on camera and diff (class_id) 240 210 set.host.for.camera $CAMERA FPA 241 211 242 stdout $LOGDIR/detrend.cleanup.process .imfile.log243 stderr $LOGDIR/detrend.cleanup.process .imfile.log212 stdout $LOGDIR/detrend.cleanup.processed.log 213 stderr $LOGDIR/detrend.cleanup.processed.log 244 214 245 215 # XXX is everything listed here needed? 246 $run = ipp_cleanup.pl --stage detrend.process .imfile --stage_id $DET_ID --camera $CAMERA --mode $CLEANUP_MODE216 $run = ipp_cleanup.pl --stage detrend.processed --stage_id $DET_ID.$EXP_ID --camera $CAMERA --mode $CLEANUP_MODE --dbname $DBNAME 247 217 add_standard_args run 248 218 … … 259 229 # default exit status 260 230 task.exit default 261 process_exit detCleanupProcessed Imfile$options:0 $JOB_STATUS231 process_exit detCleanupProcessed $options:0 $JOB_STATUS 262 232 end 263 233 … … 266 236 showcommand crash 267 237 echo "hostname: $JOB_HOSTNAME" 268 book setword detCleanupProcessed Imfile$options:0 pantaskState CRASH238 book setword detCleanupProcessed $options:0 pantaskState CRASH 269 239 end 270 240 … … 272 242 task.exit timeout 273 243 showcommand timeout 274 book setword detCleanupProcessedImfile $options:0 pantaskState TIMEOUT 275 end 276 end 277 278 279 ######## cleanup process exp ######## 280 task detrend.cleanup.processexp.load 244 book setword detCleanupProcessed $options:0 pantaskState TIMEOUT 245 end 246 end 247 248 249 250 ######## cleanup resid imfile/exp ######## 251 task detrend.cleanup.resid.load 281 252 host local 282 253 … … 288 259 289 260 stdout NULL 290 stderr $LOGDIR/detrend.cleanup. process.exp.log291 292 task.exec 293 $run = dettool -pendingcleanup_ processedexp261 stderr $LOGDIR/detrend.cleanup.resid.log 262 263 task.exec 264 $run = dettool -pendingcleanup_residexp 294 265 if ($DB:n == 0) 295 266 option DEFAULT 296 267 else 297 268 # save the DB name for the exit tasks 298 option $DB:$detCleanup ProcessedExp_DB299 $run = $run -dbname $DB:$detCleanup ProcessedExp_DB300 $detCleanup ProcessedExp_DB ++301 if ($detCleanup ProcessedExp_DB >= $DB:n) set detCleanupProcessedExp_DB = 0269 option $DB:$detCleanupResid_DB 270 $run = $run -dbname $DB:$detCleanupResid_DB 271 $detCleanupResid_DB ++ 272 if ($detCleanupResid_DB >= $DB:n) set detCleanupResid_DB = 0 302 273 end 303 274 add_poll_args run … … 308 279 task.exit 0 309 280 # convert 'stdout' to book format 310 ipptool2book stdout detCleanup ProcessedExp -key det_id:exp_id -uniq -setword dbname $options:0 -setword pantaskState INIT281 ipptool2book stdout detCleanupResid -key det_id:iteration:exp_id -uniq -setword dbname $options:0 -setword pantaskState INIT 311 282 if ($VERBOSE > 2) 312 book listbook detCleanup ProcessedExp283 book listbook detCleanupResid 313 284 end 314 285 315 286 # delete existing entries in the appropriate pantaskStates 316 process_cleanup detCleanup ProcessedExp287 process_cleanup detCleanupResid 317 288 end 318 289 … … 333 304 334 305 # run the ipp_cleanup.pl script on pending images 335 task detrend.cleanup. processexp.run306 task detrend.cleanup.resid.run 336 307 periods -poll $RUNPOLL 337 308 periods -exec $RUNEXEC … … 340 311 341 312 task.exec 342 book npages detCleanup ProcessedExp-var N313 book npages detCleanupResid -var N 343 314 if ($N == 0) break 344 315 if ($NETWORK == 0) break 345 316 346 # look for new images in detCleanup ProcessedExp(pantaskState == INIT)347 book getpage detCleanup ProcessedExp0 -var pageName -key pantaskState INIT317 # look for new images in detCleanupResid (pantaskState == INIT) 318 book getpage detCleanupResid 0 -var pageName -key pantaskState INIT 348 319 if ("$pageName" == "NULL") break 349 320 350 book setword detCleanupProcessedExp $pageName pantaskState RUN 351 book getword detCleanupProcessedExp $pageName det_id -var DET_ID 352 book getword detCleanupProcessedExp $pageName exp_id -var EXP_ID 353 book getword detCleanupProcessedExp $pageName camera -var CAMERA 354 book getword detCleanupProcessedExp $pageName data_state -var CLEANUP_MODE 355 book getword detCleanupProcessedExp $pageName dbname -var DBNAME 356 357 # specify choice of local or remote host based on camera and chip (class_id) 321 book setword detCleanupResid $pageName pantaskState RUN 322 book getword detCleanupResid $pageName det_id -var DET_ID 323 book getword detCleanupResid $pageName exp_id -var EXP_ID 324 book getword detCleanupResid $pageName iteration -var ITERATION 325 book getword detCleanupResid $pageName camera -var CAMERA 326 book getword detCleanupResid $pageName data_state -var CLEANUP_MODE 327 book getword detCleanupResid $pageName dbname -var DBNAME 328 329 # specify choice of local or remote host based on camera and diff (class_id) 358 330 set.host.for.camera $CAMERA FPA 359 331 360 stdout $LOGDIR/detrend.cleanup. process.exp.log361 stderr $LOGDIR/detrend.cleanup. process.exp.log332 stdout $LOGDIR/detrend.cleanup.resid.log 333 stderr $LOGDIR/detrend.cleanup.resid.log 362 334 363 335 # XXX is everything listed here needed? 364 $run = ipp_cleanup.pl --stage detrend. process.exp --stage_id $DET_ID --camera $CAMERA --mode $CLEANUP_MODE336 $run = ipp_cleanup.pl --stage detrend.resid --stage_id $DET_ID.$EXP_ID --camera $CAMERA --mode $CLEANUP_MODE --dbname $DBNAME 365 337 add_standard_args run 366 338 … … 377 349 # default exit status 378 350 task.exit default 379 process_exit detCleanup ProcessedExp$options:0 $JOB_STATUS351 process_exit detCleanupResid $options:0 $JOB_STATUS 380 352 end 381 353 … … 384 356 showcommand crash 385 357 echo "hostname: $JOB_HOSTNAME" 386 book setword detCleanup ProcessedExp$options:0 pantaskState CRASH358 book setword detCleanupResid $options:0 pantaskState CRASH 387 359 end 388 360 … … 390 362 task.exit timeout 391 363 showcommand timeout 392 book setword detCleanup ProcessedExp$options:0 pantaskState TIMEOUT364 book setword detCleanupResid $options:0 pantaskState TIMEOUT 393 365 end 394 366 end … … 402 374 periods -timeout 30 403 375 npending 1 404 active true376 active false 405 377 406 378 stdout NULL … … 449 421 end 450 422 423 451 424 # run the ipp_cleanup.pl script on pending images 452 425 task detrend.cleanup.stack.run … … 521 494 periods -timeout 30 522 495 npending 1 523 active true496 active false 524 497 525 498 stdout NULL … … 573 546 periods -exec $RUNEXEC 574 547 periods -timeout 60 575 active true548 active false 576 549 577 550 task.exec … … 636 609 periods -timeout 30 637 610 npending 1 638 active true611 active false 639 612 640 613 stdout NULL … … 688 661 periods -exec $RUNEXEC 689 662 periods -timeout 60 690 active true663 active false 691 664 692 665 task.exec … … 752 725 periods -timeout 30 753 726 npending 1 754 active true727 active false 755 728 756 729 stdout NULL … … 804 777 periods -exec $RUNEXEC 805 778 periods -timeout 60 806 active true779 active false 807 780 808 781 task.exec … … 860 833 861 834 862 ######## cleanup resid imfile ########863 task detrend.cleanup.resid.load864 host local865 866 periods -poll $LOADPOLL867 periods -exec $LOADEXEC868 periods -timeout 30869 npending 1870 active true871 872 stdout NULL873 stderr $LOGDIR/detrend.cleanup.resid.imfile.log874 875 task.exec876 $run = dettool -pendingcleanup_residimfile877 if ($DB:n == 0)878 option DEFAULT879 else880 # save the DB name for the exit tasks881 option $DB:$detCleanupResidImfile_DB882 $run = $run -dbname $DB:$detCleanupResidImfile_DB883 $detCleanupResidImfile_DB ++884 if ($detCleanupResidImfile_DB >= $DB:n) set detCleanupResidImfile_DB = 0885 end886 add_poll_args run887 command $run888 end889 890 # success891 task.exit 0892 # convert 'stdout' to book format893 ipptool2book stdout detCleanupResidImfile -key det_id:iteration:exp_id:class_id -uniq -setword dbname $options:0 -setword pantaskState INIT894 if ($VERBOSE > 2)895 book listbook detCleanupResidImfile896 end897 898 # delete existing entries in the appropriate pantaskStates899 process_cleanup detCleanupResidImfile900 end901 902 # locked list903 task.exit default904 showcommand failure905 end906 907 task.exit crash908 showcommand crash909 end910 911 # operation times out?912 task.exit timeout913 showcommand timeout914 end915 end916 917 # run the ipp_cleanup.pl script on pending images918 task detrend.cleanup.resid.run919 periods -poll $RUNPOLL920 periods -exec $RUNEXEC921 periods -timeout 60922 active true923 924 task.exec925 book npages detCleanupResidImfile -var N926 if ($N == 0) break927 if ($NETWORK == 0) break928 929 # look for new images in detCleanupResidImfile (pantaskState == INIT)930 book getpage detCleanupResidImfile 0 -var pageName -key pantaskState INIT931 if ("$pageName" == "NULL") break932 933 book setword detCleanupResidImfile $pageName pantaskState RUN934 book getword detCleanupResidImfile $pageName det_id -var DET_ID935 book getword detCleanupResidImfile $pageName exp_id -var EXP_ID936 book getword detCleanupResidImfile $pageName class_id -var CLASS_ID937 book getword detCleanupResidImfile $pageName iteration -var ITERATION938 book getword detCleanupResidImfile $pageName camera -var CAMERA939 book getword detCleanupResidImfile $pageName data_state -var CLEANUP_MODE940 book getword detCleanupResidImfile $pageName dbname -var DBNAME941 942 # specify choice of local or remote host based on camera and chip (class_id)943 set.host.for.camera $CAMERA FPA944 945 stdout $LOGDIR/detrend.cleanup.resid.imfile.log946 stderr $LOGDIR/detrend.cleanup.resid.imfile.log947 948 # XXX is everything listed here needed?949 $run = ipp_cleanup.pl --stage detrend.resid.imfile --stage_id $DET_ID --camera $CAMERA --mode $CLEANUP_MODE950 add_standard_args run951 952 # save the pageName for future reference below953 options $pageName954 955 # create the command line956 if ($VERBOSE > 1)957 echo command $run958 end959 command $run960 end961 962 # default exit status963 task.exit default964 process_exit detCleanupResidImfile $options:0 $JOB_STATUS965 end966 967 # locked list968 task.exit crash969 showcommand crash970 echo "hostname: $JOB_HOSTNAME"971 book setword detCleanupResidImfile $options:0 pantaskState CRASH972 end973 974 # operation timed out?975 task.exit timeout976 showcommand timeout977 book setword detCleanupResidImfile $options:0 pantaskState TIMEOUT978 end979 end980 981 982 ######## cleanup resid exp ########983 task detrend.cleanup.residexp.load984 host local985 986 periods -poll $LOADPOLL987 periods -exec $LOADEXEC988 periods -timeout 30989 npending 1990 active true991 992 stdout NULL993 stderr $LOGDIR/detrend.cleanup.resid.exp.log994 995 task.exec996 $run = dettool -pendingcleanup_residexp997 if ($DB:n == 0)998 option DEFAULT999 else1000 # save the DB name for the exit tasks1001 option $DB:$detCleanupResidExp_DB1002 $run = $run -dbname $DB:$detCleanupResidExp_DB1003 $detCleanupResidExp_DB ++1004 if ($detCleanupResidExp_DB >= $DB:n) set detCleanupResidExp_DB = 01005 end1006 add_poll_args run1007 command $run1008 end1009 1010 # success1011 task.exit 01012 # convert 'stdout' to book format1013 ipptool2book stdout detCleanupResidExp -key det_id:iteration:exp_id -uniq -setword dbname $options:0 -setword pantaskState INIT1014 if ($VERBOSE > 2)1015 book listbook detCleanupResidExp1016 end1017 1018 # delete existing entries in the appropriate pantaskStates1019 process_cleanup detCleanupResidExp1020 end1021 1022 # locked list1023 task.exit default1024 showcommand failure1025 end1026 1027 task.exit crash1028 showcommand crash1029 end1030 1031 # operation times out?1032 task.exit timeout1033 showcommand timeout1034 end1035 end1036 1037 # run the ipp_cleanup.pl script on pending images1038 task detrend.cleanup.residexp.run1039 periods -poll $RUNPOLL1040 periods -exec $RUNEXEC1041 periods -timeout 601042 active true1043 1044 task.exec1045 book npages detCleanupResidExp -var N1046 if ($N == 0) break1047 if ($NETWORK == 0) break1048 1049 # look for new images in detCleanupResidExp (pantaskState == INIT)1050 book getpage detCleanupResidExp 0 -var pageName -key pantaskState INIT1051 if ("$pageName" == "NULL") break1052 1053 book setword detCleanupResidExp $pageName pantaskState RUN1054 book getword detCleanupResidExp $pageName det_id -var DET_ID1055 book getword detCleanupResidExp $pageName exp_id -var EXP_ID1056 book getword detCleanupResidExp $pageName iteration -var ITERATION1057 book getword detCleanupResidExp $pageName camera -var CAMERA1058 book getword detCleanupResidExp $pageName data_state -var CLEANUP_MODE1059 book getword detCleanupResidExp $pageName dbname -var DBNAME1060 1061 # specify choice of local or remote host based on camera and chip (class_id)1062 set.host.for.camera $CAMERA FPA1063 1064 stdout $LOGDIR/detrend.cleanup.resid.exp.log1065 stderr $LOGDIR/detrend.cleanup.resid.exp.log1066 1067 # XXX is everything listed here needed?1068 $run = ipp_cleanup.pl --stage detrend.resid.exp --stage_id $DET_ID --camera $CAMERA --mode $CLEANUP_MODE1069 add_standard_args run1070 1071 # save the pageName for future reference below1072 options $pageName1073 1074 # create the command line1075 if ($VERBOSE > 1)1076 echo command $run1077 end1078 command $run1079 end1080 1081 # default exit status1082 task.exit default1083 process_exit detCleanupResidExp $options:0 $JOB_STATUS1084 end1085 1086 # locked list1087 task.exit crash1088 showcommand crash1089 echo "hostname: $JOB_HOSTNAME"1090 book setword detCleanupResidExp $options:0 pantaskState CRASH1091 end1092 1093 # operation timed out?1094 task.exit timeout1095 showcommand timeout1096 book setword detCleanupResidExp $options:0 pantaskState TIMEOUT1097 end1098 end -
branches/eam_branches/20100225/ippTasks/nightly_stacks.pro
r27517 r27526 605 605 host $host 606 606 # set.host.for.camera GPC1 $class_id 607 $logfile = " burntool_logs/$class_id.$start_date.log"607 $logfile = "/data/${host}.0/burntool_logs/$class_id.$start_date.log" 608 608 609 609 $run = ipp_apply_burntool.pl --class_id $class_id --dateobs_begin $start_date --dateobs_end $end_date --dbname gpc1 --logfile $logfile -
branches/eam_branches/20100225/ippToPsps/scripts/pspsSchema2xml.pl
r27517 r27526 89 89 90 90 while (<FILE>) { 91 if ($_ =~ m/.*CREATE TABLE .*$tableName/) {91 if ($_ =~ m/.*CREATE TABLE\s+dbo\.$tableName\s*\(/i) { 92 92 93 93 close (FILE); … … 209 209 } 210 210 211 if($reading && $_ =~ m/^\ )/) {$reading = 0;}211 if($reading && $_ =~ m/^\s*\)\s*/) {$reading = 0;} 212 212 213 213 if(!$reading) {next;} … … 218 218 if (!$line) {next;} 219 219 if (length($line) < 5) {next;} 220 if ($line =~ m/^ --/) {next;}220 if ($line =~ m/^\s*--/) {next;} 221 221 if ($line =~ m/\/\*/) {next;} 222 222 if ($line =~ m/\*\//) {next;} -
branches/eam_branches/20100225/ippTools/share/magicdstool_getskycells.sql
r26557 r27526 1 -- Input warps 1 2 SELECT DISTINCT 2 3 diffSkyfile.diff_id, 3 diffRun.tess_id, 4 diffRun.tess_id, 4 5 diffSkyfile.skycell_id, 5 6 diffSkyfile.path_base, … … 8 9 JOIN magicRun USING(magic_id) 9 10 JOIN magicInputSkyfile USING(magic_id) 10 JOIN diffRun ON magicRun.diff_id = diffRun.diff_id11 JOIN diffRun USING(diff_id) 11 12 JOIN diffSkyfile 12 13 ON magicRun.diff_id = diffSkyfile.diff_id … … 17 18 -- Want input warps only 18 19 AND diffInputSkyfile.warp1 IS NOT NULL 20 AND magicRun.inverse = 0 19 21 JOIN warpSkyCellMap 20 22 ON warpSkyCellMap.warp_id = diffInputSkyfile.warp1 … … 27 29 diffSkyfile.fault = 0 28 30 AND diffSkyfile.quality = 0 29 AND magic_ds_id = %lld 31 -- WHERE hook %s 32 UNION 33 -- Reference warps 34 SELECT DISTINCT 35 diffSkyfile.diff_id, 36 diffRun.tess_id, 37 diffSkyfile.skycell_id, 38 diffSkyfile.path_base, 39 diffSkyfile.data_state 40 FROM magicDSRun 41 JOIN magicRun USING(magic_id) 42 JOIN magicInputSkyfile USING(magic_id) 43 JOIN diffRun USING(diff_id) 44 JOIN diffSkyfile 45 ON magicRun.diff_id = diffSkyfile.diff_id 46 AND magicInputSkyfile.node = diffSkyfile.skycell_id 47 JOIN diffInputSkyfile 48 ON diffInputSkyfile.diff_id = diffSkyfile.diff_id 49 AND diffInputSkyfile.skycell_id = diffSkyfile.skycell_id 50 AND diffInputSkyfile.warp2 IS NOT NULL 51 AND magicRun.inverse = 1 52 JOIN warpSkyCellMap 53 ON warpSkyCellMap.warp_id = diffInputSkyfile.warp2 54 AND warpSkyCellMap.skycell_id = diffInputSkyfile.skycell_id 55 JOIN warpSkyfile 56 ON warpSkyfile.warp_id = warpSkyCellMap.warp_id 57 AND warpSkyfile.skycell_id = warpSkyCellMap.skycell_id 58 AND warpSkyfile.quality = 0 59 WHERE 60 diffSkyfile.fault = 0 61 AND diffSkyfile.quality = 0 62 -- WHERE hook %s -
branches/eam_branches/20100225/ippTools/src/magicdstool.c
r27517 r27526 1135 1135 1136 1136 psMetadata *where = psMetadataAlloc(); 1137 PXOPT_COPY_S64(config->args, where, "-magic_ds_id", "magicDSRun.magic_ds_id", "=="); 1137 1138 PXOPT_COPY_STR(config->args, where, "-class_id", "warpSkyCellMap.class_id", "=="); 1138 1139 PXOPT_COPY_STR(config->args, where, "-skycell_id", "warpSkyCellMap.skycell_id", "=="); … … 1146 1147 } 1147 1148 1149 psString whereClause = NULL; 1148 1150 if (psListLength(where->list)) { 1149 psString whereClause = psDBGenerateWhereConditionSQL(where, NULL); 1150 psStringAppend(&query, " AND %s", whereClause); 1151 psFree(whereClause); 1151 whereClause = psDBGenerateWhereConditionSQL(where, NULL); 1152 psStringPrepend(&whereClause, "\n AND "); 1152 1153 } 1153 1154 psFree(where); 1154 1155 1155 if (!p_psDBRunQueryF(config->dbh, query, magic_ds_id)) {1156 if (!p_psDBRunQueryF(config->dbh, query, whereClause, whereClause)) { 1156 1157 psError(PS_ERR_UNKNOWN, false, "database error"); 1157 1158 psFree(query); -
branches/eam_branches/20100225/ippconfig/recipes/nightly_science.config
r27517 r27526 119 119 STACKABLE BOOL FALSE 120 120 END 121 TARGETS METADATA 122 NAME STR microtest 121 # This is a hack, and I freely admit it. 122 TARGETS METADATA 123 NAME STR microtestMD01 124 TESS STR MD01 125 OBJECT STR MD01% 126 COMMENT STR Microtest Obs% 127 STACKABLE BOOL TRUE 128 END 129 TARGETS METADATA 130 NAME STR microtestMD01.noPattern 131 TESS STR MD01 132 OBJECT STR MD01% 133 COMMENT STR Microtest Obs% 134 REDUCTION STR STDSCIENCE.V0 135 STACKABLE BOOL TRUE 136 END 137 TARGETS METADATA 138 NAME STR microtestMD02 139 TESS STR MD02 140 OBJECT STR MD02% 141 COMMENT STR Microtest Obs% 142 STACKABLE BOOL TRUE 143 END 144 TARGETS METADATA 145 NAME STR microtestMD02.noPattern 146 TESS STR MD02 147 OBJECT STR MD02% 148 COMMENT STR Microtest Obs% 149 REDUCTION STR STDSCIENCE.V0 150 STACKABLE BOOL TRUE 151 END 152 TARGETS METADATA 153 NAME STR microtestMD03 154 TESS STR MD03 155 OBJECT STR MD03% 156 COMMENT STR Microtest Obs% 157 STACKABLE BOOL TRUE 158 END 159 TARGETS METADATA 160 NAME STR microtestMD03.noPattern 161 TESS STR MD03 162 OBJECT STR MD03% 163 COMMENT STR Microtest Obs% 164 REDUCTION STR STDSCIENCE.V0 165 STACKABLE BOOL TRUE 166 END 167 TARGETS METADATA 168 NAME STR microtestMD04 123 169 TESS STR MD04 124 COMMENT STR Microtest Obs% 125 STACKABLE BOOL TRUE 126 END 127 # TARGETS METADATA 128 # NAME STR CMB 129 # TESS STR RINGS.V0 130 # COMMENT STR CMB_Cold% 131 # STACKABLE BOOL FALSE 132 # END 133 # TARGETS METADATA 134 # NAME STR SVS 135 # TESS STR RINGS.V0 136 # COMMENT STR SVS% 137 # STACKABLE BOOL FALSE 138 # END 170 OBJECT STR MD04% 171 COMMENT STR Microtest Obs% 172 STACKABLE BOOL TRUE 173 END 174 TARGETS METADATA 175 NAME STR microtestMD04.noPattern 176 TESS STR MD04 177 OBJECT STR MD04% 178 COMMENT STR Microtest Obs% 179 REDUCTION STR STDSCIENCE.V0 180 STACKABLE BOOL TRUE 181 END 182 TARGETS METADATA 183 NAME STR microtestMD05 184 TESS STR MD05 185 OBJECT STR MD05% 186 COMMENT STR Microtest Obs% 187 STACKABLE BOOL TRUE 188 END 189 TARGETS METADATA 190 NAME STR microtestMD05.noPattern 191 TESS STR MD05 192 OBJECT STR MD05% 193 COMMENT STR Microtest Obs% 194 REDUCTION STR STDSCIENCE.V0 195 STACKABLE BOOL TRUE 196 END 197 TARGETS METADATA 198 NAME STR microtestMD06 199 TESS STR MD06 200 OBJECT STR MD06% 201 COMMENT STR Microtest Obs% 202 STACKABLE BOOL TRUE 203 END 204 TARGETS METADATA 205 NAME STR microtestMD06.noPattern 206 TESS STR MD06 207 OBJECT STR MD06% 208 COMMENT STR Microtest Obs% 209 REDUCTION STR STDSCIENCE.V0 210 STACKABLE BOOL TRUE 211 END 212 TARGETS METADATA 213 NAME STR microtestMD07 214 TESS STR MD07 215 OBJECT STR MD07% 216 COMMENT STR Microtest Obs% 217 STACKABLE BOOL TRUE 218 END 219 TARGETS METADATA 220 NAME STR microtestMD07.noPattern 221 TESS STR MD07 222 OBJECT STR MD07% 223 COMMENT STR Microtest Obs% 224 REDUCTION STR STDSCIENCE.V0 225 STACKABLE BOOL TRUE 226 END 227 TARGETS METADATA 228 NAME STR microtestMD08 229 TESS STR MD08 230 OBJECT STR MD08% 231 COMMENT STR Microtest Obs% 232 STACKABLE BOOL TRUE 233 END 234 TARGETS METADATA 235 NAME STR microtestMD08.noPattern 236 TESS STR MD08 237 OBJECT STR MD08% 238 COMMENT STR Microtest Obs% 239 REDUCTION STR STDSCIENCE.V0 240 STACKABLE BOOL TRUE 241 END 242 TARGETS METADATA 243 NAME STR microtestMD09 244 TESS STR MD09 245 OBJECT STR MD09% 246 COMMENT STR Microtest Obs% 247 STACKABLE BOOL TRUE 248 END 249 TARGETS METADATA 250 NAME STR microtestMD09.noPattern 251 TESS STR MD09 252 OBJECT STR MD09% 253 COMMENT STR Microtest Obs% 254 REDUCTION STR STDSCIENCE.V0 255 STACKABLE BOOL TRUE 256 END 257 TARGETS METADATA 258 NAME STR microtestMD10 259 TESS STR MD10 260 OBJECT STR MD10% 261 COMMENT STR Microtest Obs% 262 STACKABLE BOOL TRUE 263 END 264 TARGETS METADATA 265 NAME STR microtestMD10.noPattern 266 TESS STR MD10 267 OBJECT STR MD10% 268 COMMENT STR Microtest Obs% 269 REDUCTION STR STDSCIENCE.V0 270 STACKABLE BOOL TRUE 271 END -
branches/eam_branches/20100225/ippconfig/recipes/psphot.config
r27508 r27526 70 70 MOMENTS_AR_MAX F32 1.5 # maximum axial ratio: 1 / AR < (sx / sy) < AR 71 71 MOMENTS_GAUSS_SIGMA F32 4.0 # XXX this is now autoscaled 72 73 # calculate difference stats? 74 DIFF_STATS BOOL FALSE 72 75 73 76 # basic object statistics … … 264 267 PSPHOT.CR.NSIGMA.LIMIT F32 3.0 # sources with crNsigma greater that this get tagged as likely cosmic rays 265 268 PSPHOT.EXT.NSIGMA.LIMIT F32 3.0 # sources with extNsigma greater that this get tagged as likely extended sources 266 PSPHOT.EXT.NSIGMA.MOMENTS F32 2.0 # sources with extNsigma greater that this get tagged as likely extended sources269 PSPHOT.EXT.NSIGMA.MOMENTS F32 3.0 # sources with extNsigma greater that this get tagged as likely extended sources 267 270 PSPHOT.CR.GROW S32 1 # Number of pixels to grow CR mask 268 271 PSPHOT.CR.NSIGMA.SOFTEN F32 0.0025 # Softening parameter for weights -
branches/eam_branches/20100225/ppViz
- Property svn:mergeinfo changed (with no actual effect on merging)
-
branches/eam_branches/20100225/ppViz/src/ppVizPattern
- Property svn:mergeinfo changed (with no actual effect on merging)
-
branches/eam_branches/20100225/pstamp/scripts/pstampparse.pl
r27517 r27526 233 233 # user requested us to search all components. Set to "" 234 234 $search_component = "" if $search_component eq "all"; 235 236 if (!check_image_type($stage)) { 237 print STDERR "invalid IMG_TYPE for row $rownum\n" if $verbose; 238 insertFakeJobForRow($row, 1, $PSTAMP_INVALID_REQUEST); 239 $num_jobs++; 240 next; 241 } 235 242 236 243 if ((($job_type eq "stamp") or ($req_type eq "bycoord")) and ! validROI($row)) { … … 958 965 } 959 966 967 sub check_image_type 968 { 969 my $img_type = shift; 970 if (!$img_type) { 971 print STDERR "NULL IMG_TYPE supplied\n"; 972 return 0; 973 } 974 if (($img_type eq "raw") or ($img_type eq "chip") or ($img_type eq "warp") or 975 ($img_type eq "stack") or ($img_type eq "diff")) { 976 return 1; 977 } else { 978 print STDERR "$img_type is not a valid IMG_TYPE\n"; 979 return 0; 980 } 981 } 982 960 983 sub my_die 961 984 { -
branches/eam_branches/20100225/tools/neb-ds9.pl
r26670 r27526 2 2 3 3 use Getopt::Std; 4 getopts('AM',\%opt); 4 use File::Temp qw( tempfile ); 5 getopts('AMDRC',\%opt); 5 6 6 7 $cmd = 'ds9 -scale mode zscale '; 7 8 if (exists($opt{M})) { 9 $cmd .= ' -mosaic wcs '; 10 } 8 11 if (exists($opt{A})) { 9 12 $cmd .= " -wcs align yes "; 13 } 14 15 if (exists($opt{C})) { 16 $cmd .= " -frame new rgb -rgb system image "; 17 @color = ("-red","-blue","-green"); 10 18 } 11 19 … … 16 24 $cmd .= "-medatacube $real_file "; 17 25 } 26 elsif (($real_file =~ /cmf$/)) { 27 my $head_name = $real_file; 28 $head_name =~ s/.*XY(\d\d).*/XY$1.psf/; 29 my ($tempFile, $tempName) = tempfile("/tmp/ds9.$$.XXXX", 30 UNLINK => 1, SUFFIX => '.reg' ); 31 32 if (exists($opt{R})) { 33 system("fdump $real_file $head_name | awk '{print(\"FK5;point(\",\$15,\$16,\") # point=boxcircle text = {\",\$8,\"}\"}' > $tempName"); 34 $cmd .= " -regions format xy -regions $tempName "; 35 } 36 else { 37 system("echo '# Region file format: DS9 version 4.1' > $tempName"); 38 system("echo 'global color=green dashlist=8 3 width=1 font=\"helvetica 10 normal\" select=1 highlite=1 dash=0 fixed=0 edit=1 move=1 delete=1 include=1 source=1' >> $tempName"); 39 40 system("fdump $real_file $head_name | awk '{print(\"image;ellipse(\",\$2,\$3,\$22,\$23,\$24,\") # text = {\",\$8,\"\}\")}' >> $tempName"); 41 $cmd .= " -regions format ds9 -regions $tempName "; 42 } 43 44 45 } 18 46 else { 47 if (exists($opt{C})) { 48 if ($#color == -1) { 49 next; 50 } 51 else { 52 $c = shift(@color); 53 $cmd .= " $c "; 54 } 55 } 19 56 $cmd .= " $real_file "; 20 57 } 21 58 } 22 59 } 23 #$cmd .= " -zoom to fit -regions format xy -regions system wcs -regions load targets.reg ";24 60 system("$cmd"); -
branches/eam_branches/20100225/tools/wiki_nightly_stacks_table.pl
r26710 r27526 22 22 $db = init_gpc_db(); 23 23 24 @targets = ('M31','MD01','MD02','MD03','MD04','MD05','MD06','MD07','MD08','MD09','MD10' );24 @targets = ('M31','MD01','MD02','MD03','MD04','MD05','MD06','MD07','MD08','MD09','MD10','ThreePi','STS','SweetSpot'); 25 25 26 26 # potential targets 27 27 if (exists($opt{P})) { 28 28 foreach $t (@targets) { 29 $sth = "select filter,DATE_FORMAT(rawExp.dateobs,'%Y-%m-%d') AS day,count(filter) FROM rawExp JOIN newExp using(exp_id) WHERE rawExp.fault = 0 AND exp_type = 'OBJECT' AND comment LIKE '${t}%' AND dateobs >= '2009-12-08T00:00:00' GROUP BY day,filter"; 29 $comment = $t; 30 if ($comment eq 'ThreePi') { 31 $comment = '3Pi'; 32 } 33 $sth = "select filter,DATE_FORMAT(rawExp.dateobs,'%Y-%m-%d') AS day,count(filter) FROM rawExp JOIN newExp using(exp_id) WHERE rawExp.fault = 0 AND exp_type = 'OBJECT' AND comment LIKE '%${comment}%' AND dateobs >= '2010-02-12T00:00:00' GROUP BY day,filter"; 30 34 $data_ref = $db->selectall_arrayref( $sth ); 31 35 foreach $rr (@{ $data_ref }) { … … 63 67 #queued in chip 64 68 65 $sth = "select rawExp.dateobs,chipRun.state,rawExp.filter,count(chipRun.state),chipRun.data_group,chipRun.dist_group from chipRun JOIN rawExp using (exp_id) where chipRun.label LIKE '%nightlys tack' GROUP BY data_group,filter,state ORDER BY dateobs";69 $sth = "select rawExp.dateobs,chipRun.state,rawExp.filter,count(chipRun.state),chipRun.data_group,chipRun.dist_group from chipRun JOIN rawExp using (exp_id) where chipRun.label LIKE '%nightlyscience' GROUP BY data_group,filter,state ORDER BY dateobs"; 66 70 67 71 $data_ref = $db->selectall_arrayref( $sth ); … … 133 137 134 138 #warps 135 $sth = "select rawExp.dateobs,warpRun.state,rawExp.filter,count(warpRun.state),warpRun.data_group,warpRun.dist_group from warpRun JOIN fakeRun using (fake_id) JOIN camRun using (cam_id) JOIN chipRun using (chip_id) JOIN rawExp using (exp_id) where warpRun.label LIKE '%nightlys tack' GROUP BY data_group,filter,state ORDER BY data_group,filter";139 $sth = "select rawExp.dateobs,warpRun.state,rawExp.filter,count(warpRun.state),warpRun.data_group,warpRun.dist_group from warpRun JOIN fakeRun using (fake_id) JOIN camRun using (cam_id) JOIN chipRun using (chip_id) JOIN rawExp using (exp_id) where warpRun.label LIKE '%nightlyscience' GROUP BY data_group,filter,state ORDER BY data_group,filter"; 136 140 $data_ref = $db->selectall_arrayref( $sth ); 137 141 … … 175 179 176 180 177 $sth = "select state,count(skycell_id),data_group,dist_group,filter from stackRun where label LIKE '%nightlys tack' group by data_group,filter,state";181 $sth = "select state,count(skycell_id),data_group,dist_group,filter from stackRun where label LIKE '%nightlyscience' group by data_group,filter,state"; 178 182 $data_ref = $db->selectall_arrayref( $sth ); 179 183 … … 245 249 # distribution 246 250 247 $sth = "select distRun.data_group,dist_group,filter,count(stage_id) from distRun JOIN stackRun ON (stage_id = stack_id) where distRun.label LIKE '%.nightlys tack' AND distRun.state = 'full' GROUP BY distRun.data_group,filter";251 $sth = "select distRun.data_group,dist_group,filter,count(stage_id) from distRun JOIN stackRun ON (stage_id = stack_id) where distRun.label LIKE '%.nightlyscience' AND distRun.state = 'full' GROUP BY distRun.data_group,filter"; 248 252 249 253 $data_ref = $db->selectall_arrayref( $sth ); … … 284 288 # faulted distributed 285 289 286 $sth = "select * from rcDSFileset join distRun using(dist_id) where rcDSFileset.fault > 0 and date(registered) >= '2010-01-01' AND label LIKE 'M%.nightlys tack' order by fs_id asc";290 $sth = "select * from rcDSFileset join distRun using(dist_id) where rcDSFileset.fault > 0 and date(registered) >= '2010-01-01' AND label LIKE 'M%.nightlyscience' order by fs_id asc"; 287 291 $data_ref = $db->selectall_arrayref( $sth ); 288 292
Note:
See TracChangeset
for help on using the changeset viewer.
