Changeset 27510
- Timestamp:
- Mar 29, 2010, 1:53:15 PM (16 years ago)
- File:
-
- 1 edited
-
trunk/tools/test_destreak (modified) (7 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/tools/test_destreak
r27408 r27510 2 2 3 3 # given a run id or exposure find the various inputs and run 4 # streaksremove 4 # streaksremove 5 5 # Does not update the database or 'replace' the inputs 6 6 … … 31 31 'outroot=s' => \$outroot, 32 32 'logfile=s' => \$logfile, 33 'dbname '=> \$dbname,33 'dbname=s' => \$dbname, 34 34 'verbose' => \$verbose, 35 35 'save-temps' => \$save_temps, … … 71 71 magicDSFile.backup_path_base, 72 72 camProcessedExp.path_base AS cam_path_base 73 FROM chipRun 73 FROM chipRun 74 74 JOIN chipProcessedImfile using(chip_id, exp_id) 75 75 JOIN camRun using(chip_id) 76 76 JOIN camProcessedExp using(cam_id) 77 JOIN magicDSRun ON stage = 'chip' AND stage_id = chipRun.chip_id 77 JOIN magicDSRun ON stage = 'chip' AND stage_id = chipRun.chip_id 78 78 -- AND camRun.cam_id = magicDSRun.cam_id 79 79 JOIN magicDSFile ON magicDSRun.magic_ds_id = magicDSFile.magic_ds_id … … 116 116 . " --uri $uri" 117 117 . " --no-update" 118 118 119 119 ; 120 120 … … 129 129 $stage = "warp"; 130 130 131 $query = 132 131 $query = 132 133 133 "SELECT 134 134 exp_id, … … 141 141 warpSkyfile.path_base, 142 142 magicDSFile.backup_path_base 143 FROM warpRun 143 FROM warpRun 144 144 JOIN warpSkyfile using(warp_id) 145 JOIN magicDSRun ON stage = 'warp' AND stage_id = warpRun.warp_id 145 JOIN magicDSRun ON stage = 'warp' AND stage_id = warpRun.warp_id 146 146 JOIN magicDSFile ON magicDSRun.magic_ds_id = magicDSFile.magic_ds_id 147 147 AND skycell_id = component … … 212 212 my $dsn = "DBI:mysql:host=$dbserver;database=$dbname"; 213 213 214 my $dbh = DBI->connect($dsn, $dbuser, $dbpassword) 214 my $dbh = DBI->connect($dsn, $dbuser, $dbpassword) 215 215 or die "Cannot connect to database.\n"; 216 216
Note:
See TracChangeset
for help on using the changeset viewer.
