Changeset 23677
- Timestamp:
- Apr 2, 2009, 11:55:52 AM (17 years ago)
- Location:
- branches/pap
- Files:
-
- 31 edited
-
dbconfig/changes.txt (modified) (1 diff)
-
dbconfig/warp.md (modified) (1 diff)
-
ippScripts/scripts/warp_skycell.pl (modified) (4 diffs)
-
ippTools/share/difftool_definebyquery.sql (modified) (2 diffs)
-
ippTools/share/difftool_definebyquery_part1.sql (modified) (1 diff)
-
ippTools/share/difftool_definebyquery_part2.sql (modified) (1 diff)
-
ippTools/share/difftool_definewarpwarp_insert.sql (modified) (1 diff)
-
ippTools/share/difftool_todiffskyfile.sql (modified) (2 diffs)
-
ippTools/share/disttool_toadvance.sql (modified) (5 diffs)
-
ippTools/share/magicdstool_completed_runs.sql (modified) (5 diffs)
-
ippTools/share/magicdstool_getskycells.sql (modified) (1 diff)
-
ippTools/share/magicdstool_todestreak.sql (modified) (3 diffs)
-
ippTools/share/magictool_chipprocessedimfile.sql (modified) (1 diff)
-
ippTools/share/magictool_definebyquery.sql (modified) (2 diffs)
-
ippTools/share/magictool_definebyquery_insert.sql (modified) (1 diff)
-
ippTools/share/magictool_definebyquery_select_test.sql (modified) (1 diff)
-
ippTools/share/magictool_definebyquery_temp_insert.sql (modified) (1 diff)
-
ippTools/share/magictool_diffskyfile.sql (modified) (1 diff)
-
ippTools/share/magictool_inputs.sql (modified) (2 diffs)
-
ippTools/share/magictool_warpskyfile.sql (modified) (1 diff)
-
ippTools/share/pxadmin_create_tables.sql (modified) (47 diffs)
-
ippTools/share/stacktool_definebyquery_insert.sql (modified) (1 diff)
-
ippTools/share/stacktool_definebyquery_insert_random_part1.sql (modified) (1 diff)
-
ippTools/share/stacktool_definebyquery_part1.sql (modified) (1 diff)
-
ippTools/share/stacktool_definebyquery_test.sql (modified) (1 diff)
-
ippTools/share/stacktool_find_complete_warps.sql (modified) (2 diffs)
-
ippTools/share/stacktool_tosum.sql (modified) (1 diff)
-
pswarp/src/pswarpArguments.c (modified) (3 diffs)
-
pswarp/src/pswarpErrorCodes.dat (modified) (1 diff)
-
pswarp/src/pswarpLoop.c (modified) (2 diffs)
-
pswarp/src/pswarpPixelFraction.c (modified) (5 diffs)
Legend:
- Unmodified
- Added
- Removed
-
branches/pap/dbconfig/changes.txt
r23532 r23677 905 905 ALTER TABLE chipProcessedImfile ADD COLUMN quality SMALLINT AFTER fault; 906 906 ALTER TABLE rawImfile ADD COLUMN quality SMALLINT AFTER fault; 907 908 ALTER TABLE warpSkyfile DROP COLUMN ignored; 909 910 ALTER TABLE diffSkyfile ADD KEY(quality); 911 ALTER TABLE stackSumSkyfile ADD KEY(quality); 912 ALTER TABLE warpSkyfile ADD KEY(quality); 913 ALTER TABLE camProcessedExp ADD KEY(quality); 914 ALTER TABLE chipProcessedImfile ADD KEY(quality); 915 ALTER TABLE rawImfile ADD KEY(quality); -
branches/pap/dbconfig/warp.md
r23532 r23677 55 55 ymin S32 0 56 56 ymax S32 0 57 ignored BOOL f # Key58 57 fault S16 0 # Key 59 58 quality S16 0 -
branches/pap/ippScripts/scripts/warp_skycell.pl
r23653 r23677 175 175 # Run pswarp 176 176 my $cmdflags; 177 my $accept = 1; # Accept the skycell?178 177 my $do_stats; 179 178 unless ($no_op) { … … 215 214 216 215 if ($do_stats) { 217 # Check first for the stats file , and if the ACCEPT flag is set.216 # Check first for the stats file 218 217 my $outputStatsReal = $ipprc->file_resolve($outputStats); 219 218 &my_die("Couldn't find expected output file: $outputStats", $warp_id, $skycell_id, $tess_dir, $PS_EXIT_SYS_ERROR) unless -f $outputStatsReal; … … 234 233 my ($quality) = $cmdflags =~ /-quality (\d+)/; # Quality flag 235 234 236 if (!$quality and $cmdflags =~ /-accept/) {235 if (!$quality) { 237 236 &my_die("Couldn't find expected output file: $outputImage", $warp_id, $skycell_id, $tess_dir, $PS_EXIT_SYS_ERROR) unless $ipprc->file_exists($outputImage); 238 237 &my_die("Couldn't find expected output file: $outputMask", $warp_id, $skycell_id, $tess_dir, $PS_EXIT_SYS_ERROR) unless $ipprc->file_exists($outputMask); … … 251 250 $command .= " -magicked" if $magicked; 252 251 253 $command .= " -uri $outputImage" if $accept;252 $command .= " -uri $outputImage" if !$quality; 254 253 $command .= (" -dtime_script " . ((DateTime->now->mjd - $mjd_start) * 86400)); 255 $command .= " $cmdflags" if $accept;254 $command .= " $cmdflags"; 256 255 $command .= " -hostname $host" if defined $host; 257 256 $command .= " -dbname $dbname" if defined $dbname; -
branches/pap/ippTools/share/difftool_definebyquery.sql
r23581 r23677 38 38 WHERE 39 39 warpSkyfile.fault = 0 40 AND warpSkyfile.ignored = 041 40 AND warpSkyfile.quality = 0 42 41 -- warpsToDiff WHERE hook %s … … 52 51 WHERE stackRun.state = 'full' 53 52 AND stackSumSkyfile.fault = 0 53 AND stackSumSkyfile.quality = 0 54 54 -- stacksForDiff WHERE hook %s 55 55 GROUP BY -
branches/pap/ippTools/share/difftool_definebyquery_part1.sql
r23619 r23677 1 SELECT 2 exp_id, 3 warp_id, 4 rawExp.filter, 5 warpRun.label, 6 warpRun.tess_id, 7 count(skycell_id) as skycell_count 8 FROM warpRun 9 JOIN warpSkyfile USING(warp_id) 10 JOIN fakeRun USING(fake_id) 11 JOIN camRun USING(cam_id) 12 JOIN chipRun USING (chip_id) 13 JOIN rawExp USING(exp_id) 14 LEFT JOIN diffRun USING(exp_id) 15 16 WHERE 17 warpSkyfile.fault = 0 18 AND warpSkyfile.ignored = 0 19 AND warpSkyfile.quality = 0 20 -- warp where hook %s 21 -- exp where hook %s 22 -- diff where hook %s 23 24 GROUP BY exp_id, warp_id DESC 1 SELECT 2 exp_id, 3 warp_id, 4 rawExp.filter, 5 warpRun.label, 6 warpRun.tess_id, 7 COUNT(skycell_id) as skycell_count 8 FROM warpRun 9 JOIN warpSkyfile USING(warp_id) 10 JOIN fakeRun USING(fake_id) 11 JOIN camRun USING(cam_id) 12 JOIN chipRun USING(chip_id) 13 JOIN rawExp USING(exp_id) 14 LEFT JOIN diffRun USING(exp_id) 15 WHERE 16 warpSkyfile.fault = 0 17 AND warpSkyfile.quality = 0 18 -- warp where hook %s 19 -- exp where hook %s 20 -- diff where hook %s 21 GROUP BY exp_id, warp_id DESC -
branches/pap/ippTools/share/difftool_definebyquery_part2.sql
r21308 r23677 1 1 -- insert skycells to diff 2 2 INSERT INTO skycellsToDiff 3 SELECT 4 0, -- diff_id 5 warpSkyfile.skycell_id, 6 warpSkyfile.warp_id, -- warp1 7 NULL, -- stack1 8 NULL, -- warp2 9 max_stack_id, -- stack2 10 warpSkyfile.tess_id, 11 0 12 FROM warpSkyfile 13 JOIN warpRun USING(warp_id) 14 LEFT JOIN ( 3 15 SELECT 4 0, -- diff_id 5 warpSkyfile.skycell_id, 6 warpSkyfile.warp_id, -- warp1 7 NULL, -- stack1 8 NULL, -- warp2 9 max_stack_id, -- stack2 10 warpSkyfile.tess_id, 11 0 12 FROM warpSkyfile 13 JOIN warpRun USING(warp_id) 14 LEFT JOIN ( 15 SELECT 16 MAX(stack_id) AS max_stack_id, -- most recent stack, by virtue of auto-increment 17 stackRun.skycell_id, 18 stackRun.tess_id, 19 filter 20 FROM stackRun 21 JOIN stackSumSkyfile USING(stack_id) 22 WHERE stackSumSkyfile.fault = 0 23 AND stackRun.state = 'full' 24 -- stacks where hook %s 25 GROUP BY 26 skycell_id, 27 filter 28 ) as bestStacks 29 USING(skycell_id) 30 WHERE 31 warpSkyfile.warp_id = %lld 32 AND ignored = 0 33 AND filter = '%s' 34 AND warpSkyfile.tess_id = bestStacks.tess_id 35 -- (good fraction test goes here for example also above) 36 -- warp where hook %s 16 MAX(stack_id) AS max_stack_id, -- most recent stack, by virtue of auto-increment 17 stackRun.skycell_id, 18 stackRun.tess_id, 19 filter 20 FROM stackRun 21 JOIN stackSumSkyfile USING(stack_id) 22 WHERE stackSumSkyfile.fault = 0 23 AND stackSumSkyfile.quality = 0 24 AND stackRun.state = 'full' 25 -- stacks where hook %s 26 GROUP BY 27 skycell_id, 28 filter 29 ) as bestStacks USING(skycell_id) 30 WHERE 31 warpSkyfile.warp_id = %lld 32 AND warpSkyfile.fault = 0 33 AND warpSkyfile.quality = 0 34 AND filter = '%s' 35 AND warpSkyfile.tess_id = bestStacks.tess_id 36 -- warp where hook %s -
branches/pap/ippTools/share/difftool_definewarpwarp_insert.sql
r23504 r23677 11 11 FROM warpSkyfile AS inputWarpSkyfile 12 12 JOIN warpSkyfile AS templateWarpSkyfile USING(skycell_id, tess_id) 13 WHERE inputWarpSkyfile. ignored= 014 AND templateWarpSkyfile. ignored= 013 WHERE inputWarpSkyfile.quality = 0 14 AND templateWarpSkyfile.quality = 0 15 15 AND inputWarpSkyfile.warp_id = %s 16 16 AND templateWarpSkyfile.warp_id = %s -
branches/pap/ippTools/share/difftool_todiffskyfile.sql
r21308 r23677 63 63 AND diffSkyfile.diff_id IS NULL) 64 64 OR (diffRun.state = 'update' 65 AND diffSkyfile.fault = 0) 65 AND diffSkyfile.fault = 0 66 AND diffSkyfile.quality = 0) 66 67 ) 67 68 -- Ensure input warps are available … … 69 70 OR (warpRun.state = 'full' 70 71 AND warpSkyfile.fault = 0 71 AND warpSkyfile. ignored= 0))72 AND warpSkyfile.quality = 0)) 72 73 -- Ensure input stacks are available 73 74 AND (diffInputSkyfile.stack1 IS NULL 74 75 OR (stackRun.state = 'full' 75 AND stackSumSkyfile.fault = 0)) 76 AND stackSumSkyfile.fault = 0 77 AND stackSumSkyfile.quality = 0)) 76 78 -- Ensure template warps are available 77 79 AND (diffInputSkyfile.warp2 IS NULL 78 80 OR (warpTemplateRun.state = 'full' 79 81 AND warpTemplateSkyfile.fault = 0 80 AND warpTemplateSkyfile. ignored= 0))82 AND warpTemplateSkyfile.quality = 0)) 81 83 -- Ensure template stacks are available 82 84 AND (diffInputSkyfile.stack2 IS NULL 83 85 OR (stackTemplateRun.state = 'full' 84 AND stackTemplateSkyfile.fault = 0)) 86 AND stackTemplateSkyfile.fault = 0 87 AND stackTemplateSkyfile.quality = 0)) 85 88 86 89 -
branches/pap/ippTools/share/disttool_toadvance.sql
r23245 r23677 7 7 ( 8 8 -- raw stage 9 SELECT 9 SELECT 10 10 distRun.dist_id, 11 11 stage, … … 29 29 UNION 30 30 -- chip stage 31 SELECT 31 SELECT 32 32 distRun.dist_id, 33 33 stage, … … 51 51 UNION 52 52 -- warp stage 53 SELECT 53 SELECT 54 54 distRun.dist_id, 55 55 stage, … … 66 66 AND distRun.stage = 'warp' 67 67 -- AND warpSkyfile.fault = 0 68 -- AND warpSkyfile. ignored= 068 -- AND warpSkyfile.quality = 0 69 69 GROUP BY 70 70 distRun.dist_id, … … 99 99 UNION 100 100 -- stack stage 101 SELECT 101 SELECT 102 102 distRun.dist_id, 103 103 stage, -
branches/pap/ippTools/share/magicdstool_completed_runs.sql
r23389 r23677 4 4 ( 5 5 -- raw stage 6 SELECT 6 SELECT 7 7 magicDSRun.magic_ds_id 8 8 FROM magicDSRun … … 22 22 UNION 23 23 -- chip stage 24 SELECT 24 SELECT 25 25 magicDSRun.magic_ds_id 26 26 FROM magicDSRun … … 40 40 UNION 41 41 -- warp stage 42 SELECT 42 SELECT 43 43 magicDSRun.magic_ds_id 44 44 FROM magicDSRun … … 51 51 AND magicDSRun.stage = 'warp' 52 52 AND warpSkyfile.fault = 0 53 AND warpSkyfile. ignored= 053 AND warpSkyfile.quality = 0 54 54 GROUP BY 55 55 magicDSRun.magic_ds_id, … … 75 75 AND magicDSRun.stage = 'diff' 76 76 AND diffSkyfile.fault = 0 77 AND diffSkyfile.quality = 0 77 78 GROUP BY 78 79 magicDSRun.magic_ds_id, -
branches/pap/ippTools/share/magicdstool_getskycells.sql
r20973 r23677 21 21 ON warpSkyfile.warp_id = warpSkyCellMap.warp_id 22 22 AND warpSkyfile.skycell_id = warpSkyCellMap.skycell_id 23 AND warpSkyfile. ignored= 023 AND warpSkyfile.quality = 0 24 24 WHERE 25 25 diffSkyfile.fault = 0 26 AND diffSkyfile.quality = 0 26 27 AND magic_ds_id = %lld -
branches/pap/ippTools/share/magicdstool_todestreak.sql
r23389 r23677 61 61 AND chipRun.state = 'full' 62 62 AND chipProcessedImfile.fault = 0 63 AND chipProcessedImfile.quality = 0 63 64 AND magicDSFile.component IS NULL 64 65 UNION … … 95 96 AND warpRun.state = 'full' 96 97 AND warpSkyfile.fault = 0 97 AND warpSkyfile. ignored= 098 AND warpSkyfile.quality = 0 98 99 AND magicDSFile.component IS NULL 99 100 UNION … … 130 131 AND magicDSRun.stage = 'diff' 131 132 AND diffSkyfile.fault = 0 133 AND diffSkyfile.quality = 0 132 134 AND magicDSFile.component IS NULL 133 135 ) as Foo -
branches/pap/ippTools/share/magictool_chipprocessedimfile.sql
r23389 r23677 26 26 chipRun.state = 'full' 27 27 AND chipProcessedImfile.fault = 0 28 AND chipProcessedImfile.quality = 0 28 29 -- AND magicRun.state = 'full' 29 30 -- AND magicMask.fault = 0 -
branches/pap/ippTools/share/magictool_definebyquery.sql
r20743 r23677 45 45 WHERE 46 46 diffSkyfile.fault = 0 47 AND diffSkyfile.quality = 0 47 48 -- WHERE hook %s 48 AND exp_id = 3647549 AND diffRun.label = 'magic_2008-11-12'49 AND exp_id = 36475 50 AND diffRun.label = 'magic_2008-11-12' 50 51 GROUP BY 51 52 exp_id, … … 79 80 JOIN diffRun USING(diff_id) 80 81 WHERE 81 warpSkyfile. ignored= 082 warpSkyfile.quality = 0 82 83 -- magicSkycellNums WHERE hook %s 83 84 AND exp_id = 36475 -
branches/pap/ippTools/share/magictool_definebyquery_insert.sql
r20973 r23677 9 9 diff_id = @DIFF_ID@ -- Update this with the appropriate diff_id 10 10 AND fault = 0 11 AND quality = 0 -
branches/pap/ippTools/share/magictool_definebyquery_select_test.sql
r20475 r23677 25 25 JOIN warpSkyfile USING(warp_id, skycell_id) 26 26 WHERE 27 warpSkyfile. ignored= 027 warpSkyfile.quality = 0 28 28 AND warpRun.state = 'full' 29 29 -- INSERT HERE any additional restrictions (e.g., exp_id, warpSkyfile.good_frac) -
branches/pap/ippTools/share/magictool_definebyquery_temp_insert.sql
r20973 r23677 20 20 WHERE 21 21 diffSkyfile.fault = 0 22 AND diffSkyfile.quality = 0 22 23 -- WHERE hook %s 23 24 GROUP BY -
branches/pap/ippTools/share/magictool_diffskyfile.sql
r23389 r23677 20 20 ON warpSkyfile.warp_id = warpSkyCellMap.warp_id 21 21 AND warpSkyfile.skycell_id = warpSkyCellMap.skycell_id 22 AND warpSkyfile. ignored= 022 AND warpSkyfile.quality = 0 23 23 WHERE 24 24 diffRun.state = 'full' 25 25 AND diffSkyfile.fault = 0 26 AND diffSkyfile.quality = 0 26 27 -- AND magicRun.state = 'full' 27 28 -- AND magicMask.fault = 0 -
branches/pap/ippTools/share/magictool_inputs.sql
r20973 r23677 10 10 diffSkyfile.path_base, 11 11 diffSkyfile.fault 12 diffSkyfile.quality 12 13 FROM magicRun 13 14 JOIN magicInputSkyfile … … 35 36 WHERE 36 37 fault = 0 38 AND quality = 0 -
branches/pap/ippTools/share/magictool_warpskyfile.sql
r23389 r23677 21 21 warpRun.state = 'full' 22 22 AND warpSkyfile.fault = 0 23 AND warpSkyfile.quality = 0 23 24 -- AND magicRun.state = 'full' 24 25 -- AND magicMask.fault = 0 -
branches/pap/ippTools/share/pxadmin_create_tables.sql
r23532 r23677 18 18 epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP, 19 19 PRIMARY KEY(exp_name, camera, telescope), 20 KEY(fault) )21 ENGINE=innodb DEFAULT CHARSET=latin1;20 KEY(fault) 21 ) ENGINE=innodb DEFAULT CHARSET=latin1; 22 22 23 23 CREATE TABLE summitImfile ( … … 34 34 PRIMARY KEY(exp_name, camera, telescope, class, class_id), 35 35 KEY(file_id), 36 FOREIGN KEY (exp_name, camera, telescope) 37 REFERENCES summitExp(exp_name, camera, telescope)) 38 ENGINE=innodb DEFAULT CHARSET=latin1; 36 FOREIGN KEY(exp_name, camera, telescope) REFERENCES summitExp(exp_name, camera, telescope) 37 ) ENGINE=innodb DEFAULT CHARSET=latin1; 39 38 40 39 CREATE TABLE pzDownloadExp ( … … 46 45 PRIMARY KEY(exp_name, camera, telescope), 47 46 KEY(state), 48 FOREIGN KEY (exp_name, camera, telescope) 49 REFERENCES summitExp(exp_name, camera, telescope)) 50 ENGINE=innodb DEFAULT CHARSET=latin1; 47 FOREIGN KEY(exp_name, camera, telescope) REFERENCES summitExp(exp_name, camera, telescope) 48 ) ENGINE=innodb DEFAULT CHARSET=latin1; 51 49 52 50 CREATE TABLE pzDownloadImfile ( … … 62 60 PRIMARY KEY(exp_name, camera, telescope, class, class_id), 63 61 KEY(fault), 64 FOREIGN KEY (exp_name, camera, telescope) 65 REFERENCES pzDownloadExp(exp_name, camera, telescope), 66 FOREIGN KEY (exp_name, camera, telescope, class, class_id) 67 REFERENCES summitImfile(exp_name, camera, telescope, class, class_id)) ENGINE=innodb DEFAULT CHARSET=latin1; 62 FOREIGN KEY (exp_name, camera, telescope) REFERENCES pzDownloadExp(exp_name, camera, telescope), 63 FOREIGN KEY(exp_name, camera, telescope, class, class_id) REFERENCES summitImfile(exp_name, camera, telescope, class, class_id) 64 ) ENGINE=innodb DEFAULT CHARSET=latin1; 68 65 69 66 CREATE TABLE newExp ( … … 98 95 epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP, 99 96 PRIMARY KEY(exp_id, tmp_class_id), 100 FOREIGN KEY (exp_id) 101 REFERENCES newExp(exp_id)) 102 ENGINE=innodb DEFAULT CHARSET=latin1; 97 FOREIGN KEY(exp_id) REFERENCES newExp(exp_id) 98 ) ENGINE=innodb DEFAULT CHARSET=latin1; 103 99 104 100 CREATE TABLE rawExp ( … … 172 168 KEY(end_stage), 173 169 KEY(fault), 174 FOREIGN KEY (exp_id) 175 REFERENCES newExp(exp_id)) 176 ENGINE=innodb DEFAULT CHARSET=latin1; 170 FOREIGN KEY(exp_id) REFERENCES newExp(exp_id) 171 ) ENGINE=innodb DEFAULT CHARSET=latin1; 177 172 178 173 CREATE TABLE rawImfile ( … … 246 241 KEY(fault), 247 242 KEY(raw_image_id), 243 KEY(quality), 248 244 UNIQUE KEY(exp_id, tmp_class_id), 249 FOREIGN KEY (exp_id, tmp_class_id) 250 REFERENCES newImfile(exp_id, tmp_class_id)) 251 ENGINE=innodb DEFAULT CHARSET=latin1; 245 FOREIGN KEY(exp_id, tmp_class_id) REFERENCES newImfile(exp_id, tmp_class_id) 246 ) ENGINE=innodb DEFAULT CHARSET=latin1; 252 247 253 248 CREATE TABLE chipRun ( … … 272 267 KEY(end_stage), 273 268 INDEX(chip_id, exp_id), 274 FOREIGN KEY (exp_id) 275 REFERENCES rawExp(exp_id)) 276 ENGINE=innodb DEFAULT CHARSET=latin1; 269 FOREIGN KEY(exp_id) REFERENCES rawExp(exp_id) 270 ) ENGINE=innodb DEFAULT CHARSET=latin1; 277 271 278 272 CREATE TABLE chipImfile ( … … 282 276 PRIMARY KEY(chip_id, class_id), 283 277 KEY(chip_imfile_id), 284 FOREIGN KEY (chip_id) REFERENCES chipRun(chip_id))285 ENGINE=innodb DEFAULT CHARSET=latin1;278 FOREIGN KEY(chip_id) REFERENCES chipRun(chip_id) 279 ) ENGINE=innodb DEFAULT CHARSET=latin1; 286 280 287 281 CREATE TABLE chipProcessedImfile ( … … 348 342 KEY(data_state), 349 343 KEY(fault), 350 FOREIGN KEY (chip_id, exp_id) REFERENCES chipRun(chip_id, exp_id), 351 FOREIGN KEY (exp_id, class_id) REFERENCES rawImfile(exp_id, class_id)) 352 ENGINE=innodb DEFAULT CHARSET=latin1; 344 KEY(quality), 345 FOREIGN KEY(chip_id, exp_id) REFERENCES chipRun(chip_id, exp_id), 346 FOREIGN KEY(exp_id, class_id) REFERENCES rawImfile(exp_id, class_id) 347 ) ENGINE=innodb DEFAULT CHARSET=latin1; 353 348 354 349 CREATE TABLE chipMask ( 355 350 label VARCHAR(64), 356 PRIMARY KEY(label) )357 ENGINE=innodb DEFAULT CHARSET=latin1;351 PRIMARY KEY(label) 352 ) ENGINE=innodb DEFAULT CHARSET=latin1; 358 353 359 354 CREATE TABLE camRun ( … … 378 373 KEY(end_stage), 379 374 INDEX(cam_id, chip_id), 380 FOREIGN KEY (chip_id) 381 REFERENCES chipRun(chip_id)) 382 ENGINE=innodb DEFAULT CHARSET=latin1; 375 FOREIGN KEY(chip_id) REFERENCES chipRun(chip_id) 376 ) ENGINE=innodb DEFAULT CHARSET=latin1; 383 377 384 378 CREATE TABLE camProcessedExp ( … … 446 440 PRIMARY KEY(cam_id), 447 441 KEY(fault), 448 FOREIGN KEY (cam_id)449 REFERENCES camRun(cam_id))450 ENGINE=innodb DEFAULT CHARSET=latin1;442 KEY(quality), 443 FOREIGN KEY(cam_id) REFERENCES camRun(cam_id) 444 ) ENGINE=innodb DEFAULT CHARSET=latin1; 451 445 452 446 CREATE TABLE camMask ( 453 447 label VARCHAR(64), 454 PRIMARY KEY(label) )455 ENGINE=innodb DEFAULT CHARSET=latin1;448 PRIMARY KEY(label) 449 ) ENGINE=innodb DEFAULT CHARSET=latin1; 456 450 457 451 CREATE TABLE fakeRun ( … … 474 468 KEY(end_stage), 475 469 INDEX(fake_id, cam_id), 476 FOREIGN KEY (cam_id) 477 REFERENCES camRun(cam_id)) 478 ENGINE=innodb DEFAULT CHARSET=latin1; 470 FOREIGN KEY(cam_id) REFERENCES camRun(cam_id) 471 ) ENGINE=innodb DEFAULT CHARSET=latin1; 479 472 480 473 CREATE TABLE fakeProcessedImfile ( … … 492 485 PRIMARY KEY(fake_id, exp_id, class_id), 493 486 KEY(fault), 494 FOREIGN KEY (fake_id) 495 REFERENCES fakeRun(fake_id), 496 FOREIGN KEY (exp_id, class_id) 497 REFERENCES rawImfile(exp_id, class_id)) 498 ENGINE=innodb DEFAULT CHARSET=latin1; 487 FOREIGN KEY(fake_id) REFERENCES fakeRun(fake_id), 488 FOREIGN KEY(exp_id, class_id) REFERENCES rawImfile(exp_id, class_id) 489 ) ENGINE=innodb DEFAULT CHARSET=latin1; 499 490 500 491 CREATE TABLE fakeMask ( 501 492 label VARCHAR(64), 502 PRIMARY KEY(label) )503 ENGINE=innodb DEFAULT CHARSET=latin1;493 PRIMARY KEY(label) 494 ) ENGINE=innodb DEFAULT CHARSET=latin1; 504 495 505 496 CREATE TABLE detRun ( … … 534 525 ref_det_id BIGINT, 535 526 ref_iter INT, 536 -- parent INT, :: dropping this537 527 PRIMARY KEY(det_id), 538 528 KEY(det_id), … … 542 532 KEY(state), 543 533 KEY(label), 544 -- KEY(parent), :: dropping this 545 INDEX(det_id, iteration)) 546 ENGINE=innodb DEFAULT CHARSET=latin1; 534 INDEX(det_id, iteration) 535 ) ENGINE=innodb DEFAULT CHARSET=latin1; 547 536 548 537 CREATE TABLE detInputExp ( 549 det_id BIGINT, 550 iteration INT, 551 exp_id BIGINT, 552 include TINYINT, 553 PRIMARY KEY(det_id, iteration, exp_id), 554 INDEX(det_id, exp_id), 555 INDEX(det_id, iteration), 556 FOREIGN KEY (det_id) 557 REFERENCES detRun(det_id), 558 FOREIGN KEY (exp_id) 559 REFERENCES rawExp(exp_id)) 560 ENGINE=innodb DEFAULT CHARSET=latin1; 538 det_id BIGINT, 539 iteration INT, 540 exp_id BIGINT, 541 include TINYINT, 542 PRIMARY KEY(det_id, iteration, exp_id), 543 INDEX(det_id, exp_id), 544 INDEX(det_id, iteration), 545 FOREIGN KEY(det_id) REFERENCES detRun(det_id), 546 FOREIGN KEY(exp_id) REFERENCES rawExp(exp_id) 547 ) ENGINE=innodb DEFAULT CHARSET=latin1; 561 548 562 549 CREATE TABLE detProcessedImfile ( … … 584 571 INDEX(det_id, class_id), 585 572 INDEX(det_id, exp_id), 586 FOREIGN KEY (det_id, exp_id) 587 REFERENCES detInputExp(det_id, exp_id), 588 FOREIGN KEY (exp_id, class_id) 589 REFERENCES rawImfile(exp_id, class_id) 573 FOREIGN KEY(det_id, exp_id) REFERENCES detInputExp(det_id, exp_id), 574 FOREIGN KEY(exp_id, class_id) REFERENCES rawImfile(exp_id, class_id) 590 575 ) ENGINE=innodb DEFAULT CHARSET=latin1; 591 576 … … 610 595 PRIMARY KEY(det_id, exp_id), 611 596 KEY(fault), 612 FOREIGN KEY (det_id, exp_id) 613 REFERENCES detInputExp(det_id, exp_id), 614 FOREIGN KEY (det_id, exp_id) 615 REFERENCES detProcessedImfile(det_id, exp_id) 597 FOREIGN KEY(det_id, exp_id) REFERENCES detInputExp(det_id, exp_id), 598 FOREIGN KEY(det_id, exp_id) REFERENCES detProcessedImfile(det_id, exp_id) 616 599 ) ENGINE=innodb DEFAULT CHARSET=latin1; 617 600 … … 634 617 PRIMARY KEY(det_id, iteration, class_id), 635 618 KEY(fault), 636 FOREIGN KEY (det_id, iteration) 637 REFERENCES detInputExp(det_id, iteration), 638 FOREIGN KEY (det_id, class_id) 639 REFERENCES detProcessedImfile(det_id, class_id) 619 FOREIGN KEY(det_id, iteration) REFERENCES detInputExp(det_id, iteration), 620 FOREIGN KEY(det_id, class_id) REFERENCES detProcessedImfile(det_id, class_id) 640 621 ) ENGINE=innodb DEFAULT CHARSET=latin1; 641 622 … … 649 630 PRIMARY KEY(det_id, iteration, class_id), 650 631 KEY(fault), 651 FOREIGN KEY (det_id, iteration) 652 REFERENCES detInputExp(det_id, iteration), 653 FOREIGN KEY (det_id, iteration, class_id) 654 REFERENCES detStackedImfile(det_id, iteration, class_id) 632 FOREIGN KEY(det_id, iteration) REFERENCES detInputExp(det_id, iteration), 633 FOREIGN KEY(det_id, iteration, class_id) REFERENCES detStackedImfile(det_id, iteration, class_id) 655 634 ) ENGINE=innodb DEFAULT CHARSET=latin1; 656 635 … … 674 653 KEY(fault), 675 654 INDEX(det_id, iteration), 676 FOREIGN KEY (det_id) 677 REFERENCES detInputExp(det_id), 678 FOREIGN KEY (det_id, iteration, class_id) 679 REFERENCES detNormalizedStatImfile(det_id, iteration, class_id) 655 FOREIGN KEY(det_id) REFERENCES detInputExp(det_id), 656 FOREIGN KEY(det_id, iteration, class_id) REFERENCES detNormalizedStatImfile(det_id, iteration, class_id) 680 657 ) ENGINE=innodb DEFAULT CHARSET=latin1; 681 658 … … 697 674 PRIMARY KEY(det_id, iteration), 698 675 KEY(fault), 699 FOREIGN KEY (det_id, iteration) 700 REFERENCES detInputExp(det_id, iteration), 701 FOREIGN KEY (det_id, iteration) 702 REFERENCES detNormalizedImfile(det_id, iteration) 676 FOREIGN KEY(det_id, iteration) REFERENCES detInputExp(det_id, iteration), 677 FOREIGN KEY(det_id, iteration) REFERENCES detNormalizedImfile(det_id, iteration) 703 678 ) ENGINE=innodb DEFAULT CHARSET=latin1; 704 679 … … 735 710 KEY(fault), 736 711 INDEX(det_id, iteration, exp_id), 737 FOREIGN KEY (det_id, iteration, exp_id) 738 REFERENCES detInputExp(det_id, iteration, exp_id), 739 FOREIGN KEY (det_id, exp_id, class_id) 740 REFERENCES detProcessedImfile(det_id, exp_id, class_id) 712 FOREIGN KEY (det_id, iteration, exp_id) REFERENCES detInputExp(det_id, iteration, exp_id), 713 FOREIGN KEY (det_id, exp_id, class_id) REFERENCES detProcessedImfile(det_id, exp_id, class_id) 741 714 ) ENGINE=innodb DEFAULT CHARSET=latin1; 742 715 … … 770 743 KEY(fault), 771 744 INDEX(det_id, iteration), 772 FOREIGN KEY (det_id, iteration, exp_id) 773 REFERENCES detInputExp(det_id, iteration, exp_id), 774 FOREIGN KEY (det_id, iteration, exp_id) 775 REFERENCES detResidImfile(det_id, iteration, exp_id) 745 FOREIGN KEY(det_id, iteration, exp_id) REFERENCES detInputExp(det_id, iteration, exp_id), 746 FOREIGN KEY(det_id, iteration, exp_id) REFERENCES detResidImfile(det_id, iteration, exp_id) 776 747 ) ENGINE=innodb DEFAULT CHARSET=latin1; 777 748 … … 787 758 PRIMARY KEY(det_id, iteration), 788 759 KEY(fault), 789 FOREIGN KEY (det_id, iteration) 790 REFERENCES detInputExp(det_id, iteration), 791 FOREIGN KEY (det_id, iteration) 792 REFERENCES detResidExp(det_id, iteration) 760 FOREIGN KEY(det_id, iteration) REFERENCES detInputExp(det_id, iteration), 761 FOREIGN KEY(det_id, iteration) REFERENCES detResidExp(det_id, iteration) 793 762 ) ENGINE=innodb DEFAULT CHARSET=latin1; 794 763 … … 811 780 PRIMARY KEY(det_id, iteration, class_id), 812 781 KEY(fault), 813 FOREIGN KEY (det_id, iteration) 814 REFERENCES detRun(det_id, iteration) 782 FOREIGN KEY(det_id, iteration) REFERENCES detRun(det_id, iteration) 815 783 ) ENGINE=innodb DEFAULT CHARSET=latin1; 816 784 … … 837 805 KEY(end_stage), 838 806 INDEX(warp_id, fake_id), 839 FOREIGN KEY (fake_id) 840 REFERENCES fakeRun(fake_id) 807 FOREIGN KEY(fake_id) REFERENCES fakeRun(fake_id) 841 808 ) ENGINE=innodb DEFAULT CHARSET=latin1; 842 809 … … 849 816 PRIMARY KEY(warp_id, skycell_id, tess_id, class_id), 850 817 KEY(fault), 851 FOREIGN KEY (warp_id) 852 REFERENCES warpRun(warp_id) 818 FOREIGN KEY(warp_id) REFERENCES warpRun(warp_id) 853 819 ) ENGINE=innodb DEFAULT CHARSET=latin1; 854 820 … … 859 825 PRIMARY KEY(warp_id, skycell_id), 860 826 KEY(warp_skyfile_id), 861 FOREIGN KEY (warp_id) REFERENCES warpRun(warp_id))862 ENGINE=innodb DEFAULT CHARSET=latin1;827 FOREIGN KEY(warp_id) REFERENCES warpRun(warp_id) 828 ) ENGINE=innodb DEFAULT CHARSET=latin1; 863 829 864 830 … … 880 846 ymin INT, 881 847 ymax INT, 882 ignored TINYINT,883 848 quality SMALLINT NOT NULL, 884 849 fault SMALLINT, … … 886 851 PRIMARY KEY(warp_id, skycell_id, tess_id), 887 852 KEY(good_frac), 888 KEY( ignored), KEY(fault),889 FOREIGN KEY (warp_id, skycell_id, tess_id)890 REFERENCES warpSkyCellMap(warp_id, skycell_id, tess_id)853 KEY(fault), 854 KEY(quality), 855 FOREIGN KEY(warp_id, skycell_id, tess_id) REFERENCES warpSkyCellMap(warp_id, skycell_id, tess_id) 891 856 ) ENGINE=innodb DEFAULT CHARSET=latin1; 892 857 … … 918 883 warp_id BIGINT, 919 884 PRIMARY KEY(stack_id, warp_id), 920 FOREIGN KEY (stack_id) REFERENCESstackRun(stack_id),921 FOREIGN KEY (warp_id) REFERENCESwarpSkyfile(warp_id)885 FOREIGN KEY(stack_id) REFERENCES stackRun(stack_id), 886 FOREIGN KEY(warp_id) REFERENCES warpSkyfile(warp_id) 922 887 ) ENGINE=innodb DEFAULT CHARSET=latin1; 923 888 … … 954 919 KEY(good_frac), 955 920 KEY(fault), 956 FOREIGN KEY (stack_id) REFERENCES stackRun(stack_id) 921 KEY(quality), 922 FOREIGN KEY(stack_id) REFERENCES stackRun(stack_id) 957 923 ) ENGINE=innodb DEFAULT CHARSET=latin1; 958 924 … … 972 938 KEY(state), 973 939 KEY(tess_id), 974 FOREIGN KEY (exp_id) REFERENCES rawExp(exp_id)940 FOREIGN KEY(exp_id) REFERENCES rawExp(exp_id) 975 941 ) ENGINE=innodb DEFAULT CHARSET=latin1; 976 942 … … 992 958 KEY(skycell_id), 993 959 KEY(tess_id), 994 FOREIGN KEY (diff_id) REFERENCESdiffRun(diff_id),995 FOREIGN KEY (warp1, skycell_id, tess_id) REFERENCESwarpSkyfile(warp_id, skycell_id, tess_id),996 FOREIGN KEY (warp2, skycell_id, tess_id) REFERENCESwarpSkyfile(warp_id, skycell_id, tess_id),997 FOREIGN KEY (stack1) REFERENCESstackSumSkyfile(stack_id),998 FOREIGN KEY (stack2) REFERENCESstackSumSkyfile(stack_id)960 FOREIGN KEY(diff_id) REFERENCES diffRun(diff_id), 961 FOREIGN KEY(warp1, skycell_id, tess_id) REFERENCES warpSkyfile(warp_id, skycell_id, tess_id), 962 FOREIGN KEY(warp2, skycell_id, tess_id) REFERENCES warpSkyfile(warp_id, skycell_id, tess_id), 963 FOREIGN KEY(stack1) REFERENCES stackSumSkyfile(stack_id), 964 FOREIGN KEY(stack2) REFERENCES stackSumSkyfile(stack_id) 999 965 ) ENGINE=innodb DEFAULT CHARSET=latin1; 1000 966 … … 1029 995 KEY(good_frac), 1030 996 KEY(fault), 1031 FOREIGN KEY (diff_id) REFERENCES diffRun(diff_id) 997 KEY(quality), 998 FOREIGN KEY(diff_id) REFERENCES diffRun(diff_id) 1032 999 ) ENGINE=innodb DEFAULT CHARSET=latin1; 1033 1000 … … 1049 1016 KEY(label), 1050 1017 KEY(fault), 1051 FOREIGN KEY (exp_id) REFERENCES rawExp(exp_id),1052 FOREIGN KEY (diff_id) REFERENCES diffRun(diff_id)1018 FOREIGN KEY(exp_id) REFERENCES rawExp(exp_id), 1019 FOREIGN KEY(diff_id) REFERENCES diffRun(diff_id) 1053 1020 ) ENGINE=innodb DEFAULT CHARSET=latin1; 1054 1021 … … 1058 1025 node VARCHAR(64), 1059 1026 PRIMARY KEY(magic_id, diff_id, node), 1060 FOREIGN KEY (magic_id) REFERENCESmagicRun(magic_id),1061 FOREIGN KEY (diff_id) REFERENCES diffRun(diff_id)1027 FOREIGN KEY(magic_id) REFERENCES magicRun(magic_id), 1028 FOREIGN KEY(diff_id) REFERENCES diffRun(diff_id) 1062 1029 ) ENGINE=innodb DEFAULT CHARSET=latin1; 1063 1030 … … 1070 1037 KEY(dep), 1071 1038 INDEX(magic_id, node), 1072 FOREIGN KEY (magic_id) REFERENCESmagicRun(magic_id)1039 FOREIGN KEY(magic_id) REFERENCES magicRun(magic_id) 1073 1040 ) ENGINE=innodb DEFAULT CHARSET=latin1; 1074 1041 … … 1079 1046 fault SMALLINT, 1080 1047 PRIMARY KEY(magic_id, node), 1081 FOREIGN KEY (magic_id) REFERENCESmagicRun(magic_id),1082 FOREIGN KEY (magic_id, node) REFERENCESmagicTree(magic_id, node),1048 FOREIGN KEY(magic_id) REFERENCES magicRun(magic_id), 1049 FOREIGN KEY(magic_id, node) REFERENCES magicTree(magic_id, node), 1083 1050 KEY(fault) 1084 1051 ) ENGINE=innodb DEFAULT CHARSET=latin1; … … 1090 1057 fault SMALLINT, 1091 1058 PRIMARY KEY(magic_id), 1092 FOREIGN KEY (magic_id) REFERENCESmagicRun(magic_id),1059 FOREIGN KEY(magic_id) REFERENCES magicRun(magic_id), 1093 1060 KEY(fault) 1094 1061 ) ENGINE=innodb DEFAULT CHARSET=latin1; … … 1111 1078 KEY(magic_id), 1112 1079 KEY(label), 1113 FOREIGN KEY (magic_id) REFERENCESmagicRun(magic_id)1080 FOREIGN KEY(magic_id) REFERENCES magicRun(magic_id) 1114 1081 ) ENGINE=innodb DEFAULT CHARSET=latin1; 1115 1082 … … 1122 1089 PRIMARY KEY(magic_ds_id, component), 1123 1090 KEY(fault), 1124 FOREIGN KEY (magic_ds_id) REFERENCES magicDSRun(magic_ds_id)1091 FOREIGN KEY(magic_ds_id) REFERENCES magicDSRun(magic_ds_id) 1125 1092 ) ENGINE=innodb DEFAULT CHARSET=latin1; 1126 1093 … … 1141 1108 KEY(cal_id), 1142 1109 KEY(last_step), 1143 FOREIGN KEY (cal_id) REFERENCEScalDB(cal_id)1110 FOREIGN KEY(cal_id) REFERENCES calDB(cal_id) 1144 1111 ) ENGINE=innodb DEFAULT CHARSET=latin1; 1145 1112 … … 1169 1136 include TINYINT, 1170 1137 PRIMARY KEY(corr_id, chip_id), 1171 FOREIGN KEY (corr_id) REFERENCESflatcorrRun(corr_id),1172 FOREIGN KEY (chip_id) REFERENCESchipRun(chip_id)1138 FOREIGN KEY(corr_id) REFERENCES flatcorrRun(corr_id), 1139 FOREIGN KEY(chip_id) REFERENCES chipRun(chip_id) 1173 1140 ) ENGINE=innodb DEFAULT CHARSET=latin1; 1174 1141 … … 1179 1146 include TINYINT, 1180 1147 PRIMARY KEY(corr_id, cam_id), 1181 FOREIGN KEY (corr_id) REFERENCESflatcorrRun(corr_id),1182 FOREIGN KEY (chip_id) REFERENCESchipRun(chip_id),1183 FOREIGN KEY (cam_id) REFERENCEScamRun(cam_id)1148 FOREIGN KEY(corr_id) REFERENCES flatcorrRun(corr_id), 1149 FOREIGN KEY(chip_id) REFERENCES chipRun(chip_id), 1150 FOREIGN KEY(cam_id) REFERENCES camRun(cam_id) 1184 1151 ) ENGINE=innodb DEFAULT CHARSET=latin1; 1185 1152 … … 1233 1200 PRIMARY KEY(job_id, req_id), 1234 1201 KEY(job_id), 1235 FOREIGN KEY (req_id) REFERENCESpstampRequest(req_id)1202 FOREIGN KEY(req_id) REFERENCES pstampRequest(req_id) 1236 1203 ) ENGINE=innodb DEFAULT CHARSET=latin1; 1237 1204 -
branches/pap/ippTools/share/stacktool_definebyquery_insert.sql
r19258 r23677 21 21 AND rawExp.filter = '%s' 22 22 AND warpSkyfile.fault = 0 23 AND warpSkyfile. ignored= 023 AND warpSkyfile.quality = 0 -
branches/pap/ippTools/share/stacktool_definebyquery_insert_random_part1.sql
r23581 r23677 28 28 AND rawExp.filter = '%s' -- the result of the query is grouped by filter and inserted for one at a time 29 29 AND warpSkyfile.fault = 0 30 AND warpSkyfile.ignored = 031 30 AND warpSkyfile.quality = 0 32 31 -- Put additional constraints here -
branches/pap/ippTools/share/stacktool_definebyquery_part1.sql
r23581 r23677 24 24 WHERE 25 25 warpRun.state = 'full' 26 AND warpSkyfile.ignored = 027 26 AND warpSkyfile.fault = 0 28 27 AND warpSkyfile.quality = 0 -
branches/pap/ippTools/share/stacktool_definebyquery_test.sql
r19258 r23677 31 31 WHERE 32 32 warpRun.state = 'full' 33 AND warpSkyfile. ignored= 033 AND warpSkyfile.quality = 0 34 34 AND warpSkyfile.fault = 0 35 35 -- Any additional selection on warps/exposures goes here -
branches/pap/ippTools/share/stacktool_find_complete_warps.sql
r19258 r23677 6 6 COUNT(stackRun.stack_id) AS num_extant 7 7 FROM warpRun 8 JOIN warpSkyfile 8 JOIN warpSkyfile 9 9 USING(warp_id) 10 10 JOIN fakeRun … … 23 23 WHERE 24 24 warpRun.state = 'full' 25 AND warpSkyfile.ignored = 0 25 AND warpSkyfile.fault = 0 26 AND warpSkyfile.quality = 0 26 27 GROUP BY 27 28 warpSkyfile.skycell_id, stackRun.stack_id -
branches/pap/ippTools/share/stacktool_tosum.sql
r19678 r23677 12 12 USING(stack_id) 13 13 WHERE 14 ((stackRun.state = 'new' 15 AND stackSumSkyfile.stack_id IS NULL) 16 OR 17 (stackRun.state = 'update' 18 AND stackSumSkyfile.fault = 0)) 14 ((stackRun.state = 'new' AND stackSumSkyfile.stack_id IS NULL) 15 OR (stackRun.state = 'update' AND stackSumSkyfile.fault = 0 AND stackSumSkyfile.quality = 0)) -
branches/pap/pswarp/src/pswarpArguments.c
r23314 r23677 163 163 } 164 164 165 float acceptFrac = psMetadataLookupF32(&status, recipe, "ACCEPT.FRAC"); ///< Min fraction of good pixels166 if (!status) {167 acceptFrac = 0.0;168 psWarning("ACCEPT.FRAC is not set in the %s recipe --- defaulting to %f.", PSWARP_RECIPE, poorFrac);169 }170 171 165 // Set recipe values in the recipe (since we've possibly altered some) 172 166 psMetadataAddS32(recipe, PS_LIST_TAIL, "GRID.NX", PS_META_REPLACE, … … 180 174 psMetadataAddF32(recipe, PS_LIST_TAIL, "POOR.FRAC", PS_META_REPLACE, 181 175 "Fraction of bad flux for a pixel to be marked as poor", poorFrac); 182 psMetadataAddF32(recipe, PS_LIST_TAIL, "ACCEPT.FRAC", PS_META_REPLACE,183 "Minimum fraction of good pixels for result to be accepted", acceptFrac);184 176 185 177 // Set recipe values in the arguments … … 194 186 psMetadataAddF32(config->arguments, PS_LIST_TAIL, "POOR.FRAC", 0, 195 187 "Fraction of bad flux for a pixel to be marked as poor", poorFrac); 196 psMetadataAddF32(config->arguments, PS_LIST_TAIL, "ACCEPT.FRAC", 0,197 "Minimum fraction of good pixels for result to be accepted", acceptFrac);198 188 199 189 psTrace("pswarp", 1, "Done with pswarpArguments...\n"); -
branches/pap/pswarp/src/pswarpErrorCodes.dat
r11268 r23677 9 9 IO Problem in FITS I/O 10 10 DATA Problem in data values 11 NO_OVERLAP No overlap between input and skycell -
branches/pap/pswarp/src/pswarpLoop.c
r23597 r23677 274 274 } 275 275 276 if (!output->data_exists) { 277 psWarning("No overlap between input and skycell."); 278 if (stats) { 279 psMetadataAddS32(stats, PS_LIST_TAIL, "QUALITY", PS_META_REPLACE, 280 "No overlap between input and skycell", PSWARP_ERR_NO_OVERLAP); 281 } 282 psphotFilesActivate(config, false); 283 psFree(cells); 284 psFree(view); 285 return true; 286 } 287 276 288 pmCell *outCell = output->parent; ///< Output cell 277 289 pmChip *outChip = outCell->parent; ///< Output chip 278 290 pmFPA *outFPA = outChip->parent; ///< Output FP 279 291 280 if (!pswarpPixelFraction(output, stats, config)) { 281 // Don't write output images, and don't bother about anything else 282 output->data_exists = outCell->data_exists = outChip->data_exists = false; 292 if (pswarpPixelFraction(output, stats, config)) { 293 psError(PS_ERR_UNKNOWN, false, "Unable to calculate pixel regions."); 283 294 psFree(cells); 284 295 psFree(view); 285 goto COMPLETED;296 return false; 286 297 } 287 298 … … 457 468 // Now done with the skycell side of things 458 469 459 COMPLETED:460 470 // Write out summary statistics 461 471 if (stats) { -
branches/pap/pswarp/src/pswarpPixelFraction.c
r21323 r23677 34 34 PS_ASSERT_IMAGE_TYPE(readout->mask, PS_TYPE_IMAGE_MASK, false); 35 35 36 if (stats) { 37 PS_ASSERT_METADATA_NON_NULL(stats, false); 36 if (!stats) { 37 // No point in continuing --- we record results to the statistics 38 return true; 38 39 } 39 40 PS_ASSERT_PTR_NON_NULL(config, false); 40 41 PS_ASSERT_METADATA_NON_NULL(config->arguments, false); 41 42 42 bool status; 43 44 float minFrac = psMetadataLookupF32(NULL, config->arguments, "ACCEPT.FRAC"); ///< Minimum fraction 43 bool status; 45 44 46 45 // load the recipe … … 52 51 53 52 // output mask bits 54 psImageMaskType maskValue = psMetadataLookupImageMask(&status, recipe, "MASK.OUTPUT"); 53 psImageMaskType maskValue = psMetadataLookupImageMask(&status, recipe, "MASK.OUTPUT"); 55 54 psAssert (status, "MASK.OUTPUT was not defined"); 56 55 … … 59 58 60 59 int numCols = image->numCols, numRows = image->numRows; ///< Size of image 61 long numPix = numCols * numRows;62 60 63 61 // Range of valid pixels 64 62 int xMin = INT_MAX, xMax = -INT_MAX, yMin = INT_MAX, yMax = -INT_MAX; 65 63 66 long num Bad = 0;///< Number of bad pixels64 long numGood = 0; ///< Number of bad pixels 67 65 for (int y = 0; y < numRows; y++) { 68 66 for (int x = 0; x < numCols; x++) { 69 if (mask->data.PS_TYPE_IMAGE_MASK_DATA[y][x] & maskValue) { 70 numBad++; 71 } else { 67 if (!(mask->data.PS_TYPE_IMAGE_MASK_DATA[y][x] & maskValue)) 72 68 if (y > yMax) { 73 69 yMax = y; … … 86 82 } 87 83 88 float goodFrac = (numPix - numBad) / (float)numPix; ///< Fraction of good pixels89 bool accept = (goodFrac >= minFrac ? true : false); ///< Accept this readout?90 91 84 if (stats) { 92 psMetadataAddBool(stats, PS_LIST_HEAD, "ACCEPT", 0, "Accept this readout?", accept);93 94 85 psMetadataAddS32(stats, PS_LIST_TAIL, "RANGE.XMIN", 0, "Minimum valid x value", xMin); 95 86 psMetadataAddS32(stats, PS_LIST_TAIL, "RANGE.XMAX", 0, "Maximum valid x value", xMax); … … 98 89 } 99 90 100 return accept;91 return true; 101 92 } 102 93
Note:
See TracChangeset
for help on using the changeset viewer.
